diff options
| author | Ralph Amissah <ralph@amissah.com> | 2018-05-15 20:33:35 -0400 |
|---|---|---|
| committer | Ralph Amissah <ralph@amissah.com> | 2019-04-10 15:14:15 -0400 |
| commit | 228d14579be7cd63fe3ffdea7a4da8e814c0905a (patch) | |
| tree | 4535606f6e3533c9be1987945889ff9958536ef7 /org/output_sqlite.org | |
| parent | html & epub images in place (dimensions not & other issues) (diff) | |
org cosmetic, minor
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 |