diff options
Diffstat (limited to 'org/output_sqlite.org')
| -rw-r--r-- | org/output_sqlite.org | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/org/output_sqlite.org b/org/output_sqlite.org index 566775b..fe76db4 100644 --- a/org/output_sqlite.org +++ b/org/output_sqlite.org @@ -14,6 +14,9 @@ #+FILETAGS: :sdp:niu:output: #+TAGS: assert(a) class(c) debug(d) mixin(m) sdp(s) tangle(T) template(t) WEB(W) noexport(n) +- [[./sdp.org][sdp]] [[./][org/]] +- [[./output_hub.org][output_hub]] + * sql ** 0. module, templates @@ -1083,7 +1086,7 @@ return _insert_doc_objects.join.to!(char[]).toUTF8; #+END_SRC ** 5. SQL statements -*** create tables +*** drop tables **** DROP INDEX IF EXISTS #+name: sqlite_statement_drop_existing_index @@ -1115,6 +1118,7 @@ DROP TABLE IF EXISTS doc_objects; DROP TABLE IF EXISTS urls; #+END_SRC +*** create tables **** CREATE TABLE metadata_and_text #+name: sqlite_statement_create_table_metadata_and_src_txt |