diff options
Diffstat (limited to 'org/output_sqlite.org')
| -rw-r--r-- | org/output_sqlite.org | 31 |
1 files changed, 3 insertions, 28 deletions
diff --git a/org/output_sqlite.org b/org/output_sqlite.org index fe76db4..c7b6571 100644 --- a/org/output_sqlite.org +++ b/org/output_sqlite.org @@ -1016,16 +1016,13 @@ foreach (part; doc_matters.xml.keys_seq.sql) { } break; case "backmatter": - assert(part == "endnotes" || "glossary" || "bibliography" || "bookindex_seg" || "blurb" || "tail", part); + assert(part == "glossary" || "bibliography" || "bookindex_seg" || "blurb" || "tail", part); switch (obj.is_of) { case "para": switch (obj.is_a) { case "heading": obj_txt = format_and_sqlite_load.heading(obj); break; - case "endnote": assert(part == "endnotes", part); - obj_txt = format_and_sqlite_load.para(obj); - break; case "glossary": assert(part == "glossary", part); obj_txt = format_and_sqlite_load.para(obj); break; @@ -1086,7 +1083,7 @@ return _insert_doc_objects.join.to!(char[]).toUTF8; #+END_SRC ** 5. SQL statements -*** drop tables +*** drop index and tables **** DROP INDEX IF EXISTS #+name: sqlite_statement_drop_existing_index @@ -1118,7 +1115,7 @@ DROP TABLE IF EXISTS doc_objects; DROP TABLE IF EXISTS urls; #+END_SRC -*** create tables +*** create tables and index **** CREATE TABLE metadata_and_text #+name: sqlite_statement_create_table_metadata_and_src_txt @@ -1223,24 +1220,9 @@ CREATE TABLE doc_objects ( ocns VARCHAR(6), clean TEXT NULL, body TEXT NULL, - book_idx TEXT NULL, seg VARCHAR(256) NULL, lev_an VARCHAR(1), lev SMALLINT NULL, - lev0 SMALLINT, - lev1 SMALLINT, - lev2 SMALLINT, - lev3 SMALLINT, - lev4 SMALLINT, - lev5 SMALLINT, - lev6 SMALLINT, - lev7 SMALLINT, - en_a SMALLINT NULL, - en_z SMALLINT NULL, - en_a_asterisk SMALLINT NULL, - en_z_asterisk SMALLINT NULL, - en_a_plus SMALLINT NULL, - en_z_plus SMALLINT NULL, t_of VARCHAR(16), t_is VARCHAR(16), node VARCHAR(16) NULL, @@ -1259,13 +1241,6 @@ CREATE INDEX idx_ocn ON doc_objects(ocn); CREATE INDEX idx_digest_clean ON doc_objects(digest_clean); CREATE INDEX idx_digest_all ON doc_objects(digest_all); CREATE INDEX idx_clean ON doc_objects(clean); -CREATE INDEX idx_lev0 ON doc_objects(lev0); -CREATE INDEX idx_lev1 ON doc_objects(lev1); -CREATE INDEX idx_lev2 ON doc_objects(lev2); -CREATE INDEX idx_lev3 ON doc_objects(lev3); -CREATE INDEX idx_lev4 ON doc_objects(lev4); -CREATE INDEX idx_lev5 ON doc_objects(lev5); -CREATE INDEX idx_lev6 ON doc_objects(lev6); CREATE INDEX idx_title ON metadata_and_text(title); CREATE INDEX idx_author ON metadata_and_text(creator_author); CREATE INDEX idx_filename ON metadata_and_text(src_filename); |