From 228d14579be7cd63fe3ffdea7a4da8e814c0905a Mon Sep 17 00:00:00 2001 From: Ralph Amissah Date: Tue, 15 May 2018 20:33:35 -0400 Subject: org cosmetic, minor --- org/output_sqlite.org | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'org/output_sqlite.org') 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 -- cgit v1.2.3