sqlite document db discrete & collection, started

- discrete document , drop & recreate document
  --sqlite-disctrete
- document collection
  - create tables
    --sqlite-create
  - populate db with specified document
    --sqlite-update

1 files changed, 184 insertions, 188 deletions

diff --git a/src/sdp/output/sqlite.d b/src/sdp/output/sqlite.d
index e7ef6bf..69c7d51 100644
--- a/src/sdp/output/sqlite.d
+++ b/src/sdp/output/sqlite.d
@@ -3,7 +3,6 @@ import sdp.output;
 import
   std.file,
   std.conv : to;
-import sdp.output.sqlite;
 template SQLiteBuildTablesAndPopulate() {
   void SQLiteBuildTablesAndPopulate(D,I)(
     auto ref const D    doc_abstraction,
@@ -11,7 +10,6 @@ template SQLiteBuildTablesAndPopulate() {
   ) {
     import d2sqlite3;
     import std.typecons : Nullable;
-    import sdp.output.sqlite;
     mixin SiSUoutputRgxInit;
     static auto rgx = Rgx();
     template SQLiteFormatAndLoadObject() {
@@ -459,128 +457,132 @@ template SQLiteBuildTablesAndPopulate() {
         auto ref              I    doc_matters,
       ) {
         auto pth_sqlite = SiSUpathsSQLite!()(doc_matters.src_path_info, doc_matters.language);
-        auto db = Database(pth_sqlite.sqlite_file(doc_matters.source_filename));
+        auto db = Database(pth_sqlite.sqlite_file(doc_matters.environment["pwd"].baseName));
         // auto db = Database(":memory:"); // open database in memory
-        db.run("
-        DROP TABLE IF EXISTS metadata_and_text;
-        DROP TABLE IF EXISTS doc_objects;
-        DROP TABLE IF EXISTS urls;
-        CREATE TABLE metadata_and_text (
-          tid                              BIGINT            PRIMARY KEY,
-          title                            VARCHAR(800)  NOT NULL,
-          title_main                       VARCHAR(400)      NULL, /*NOT*/
-          title_sub                        VARCHAR(400)      NULL,
-          title_short                      VARCHAR(400)      NULL,
-          title_edition                    VARCHAR(10)       NULL,
-          title_note                       VARCHAR(2500)     NULL,
-          title_language                   VARCHAR(100)      NULL,
-          title_language_char              VARCHAR(6)        NULL,
-          creator_author                   VARCHAR(600)      NULL,
-          creator_author_hon               VARCHAR(100)      NULL,
-          creator_author_nationality       VARCHAR(100)      NULL,
-          creator_editor                   VARCHAR(600)      NULL,
-          creator_contributor              VARCHAR(600)      NULL,
-          creator_illustrator              VARCHAR(600)      NULL,
-          creator_photographer             VARCHAR(600)      NULL,
-          creator_translator               VARCHAR(600)      NULL,
-          creator_prepared_by              VARCHAR(600)      NULL,
-          creator_digitized_by             VARCHAR(600)      NULL,
-          creator_audio                    VARCHAR(600)      NULL,
-          creator_video                    VARCHAR(600)      NULL,
-          language_document                VARCHAR(100)      NULL,
-          language_document_char           VARCHAR(6)        NULL, /*NOT*/
-          language_original                VARCHAR(100)      NULL,
-          language_original_char           VARCHAR(6)        NULL,
-          date_added_to_site               VARCHAR(10)       NULL,
-          date_available                   VARCHAR(10)       NULL,
-          date_created                     VARCHAR(10)       NULL,
-          date_issued                      VARCHAR(10)       NULL,
-          date_modified                    VARCHAR(10)       NULL,
-          date_published                   VARCHAR(10)       NULL,
-          date_valid                       VARCHAR(10)       NULL,
-          date_translated                  VARCHAR(10)       NULL,
-          date_original_publication        VARCHAR(10)       NULL,
-          date_generated                   VARCHAR(10)       NULL,
-          publisher                        VARCHAR(600)      NULL,
-          original_publisher               VARCHAR(600)      NULL,
-          original_language                VARCHAR(100)      NULL,
-          original_language_char           VARCHAR(6)        NULL,
-          original_source                  VARCHAR(600)      NULL,
-          original_institution             VARCHAR(600)      NULL,
-          original_nationality             VARCHAR(100)      NULL,
-          rights                           VARCHAR(2500)     NULL,
-          rights_copyright_text            VARCHAR(2500)     NULL,
-          rights_copyright_translation     VARCHAR(2500)     NULL,
-          rights_copyright_illustrations   VARCHAR(2500)     NULL,
-          rights_copyright_photographs     VARCHAR(2500)     NULL,
-          rights_copyright_preparation     VARCHAR(2500)     NULL,
-          rights_copyright_digitization    VARCHAR(2500)     NULL,
-          rights_copyright_audio           VARCHAR(2500)     NULL,
-          rights_copyright_video           VARCHAR(2500)     NULL,
-          rights_license                   VARCHAR(2500)     NULL,
-          identifier_oclc                  VARCHAR(30)       NULL,
-          identifier_isbn                  VARCHAR(16)       NULL,
-          classify_topic_register          VARCHAR(2500)     NULL,
-          classify_subject                 VARCHAR(600)      NULL,
-          classify_loc                     VARCHAR(30)       NULL,
-          classify_dewey                   VARCHAR(30)       NULL,
-          classify_keywords                VARCHAR(600)      NULL,
-          notes_abstract                   TEXT              NULL,
-          notes_description                TEXT              NULL,
-          notes_comment                    TEXT              NULL,
-          notes_coverage                   VARCHAR(200)      NULL,
-          notes_relation                   VARCHAR(200)      NULL,
-          notes_history                    VARCHAR(600)      NULL,
-          notes_type                       VARCHAR(600)      NULL,
-          notes_format                     VARCHAR(600)      NULL,
-          notes_prefix                     TEXT              NULL,
-          notes_prefix_a                   TEXT              NULL,
-          notes_prefix_b                   TEXT              NULL,
-          notes_suffix                     TEXT              NULL,
-          src_filename                     VARCHAR(256)      NULL,
-          src_fingerprint                  VARCHAR(256)      NULL,
-          src_filesize                     VARCHAR(10)       NULL,
-          src_wordcount                    VARCHAR(10)       NULL,
-          src_text                         TEXT              NULL,
-          fulltext                         TEXT              NULL,
-          links                            TEXT              NULL
-        );
-        
-        CREATE TABLE doc_objects (
-          lid                              BIGINT PRIMARY KEY,
-          metadata_tid                     BIGINT REFERENCES metadata_and_text,
-          ocn                              SMALLINT,
-          ocnd                             VARCHAR(6),
-          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,
-          parent                           VARCHAR(16) NULL,
-          digest_clean                     CHAR(256),
-          digest_all                       CHAR(256),
-          types                            CHAR(1) NULL
-        )
-        ");
+        if (doc_matters.opt_action["sqlite-create"]) {
+          if ((doc_matters.opt_action["verbose"])) { writeln("sqlite create tables... "); }
+          db.run("
+          DROP TABLE IF EXISTS metadata_and_text;
+          DROP TABLE IF EXISTS doc_objects;
+          DROP TABLE IF EXISTS urls;
+          CREATE TABLE metadata_and_text (
+            tid                              BIGINT            PRIMARY KEY,
+            title                            VARCHAR(800)  NOT NULL,
+            title_main                       VARCHAR(400)      NULL, /*NOT*/
+            title_sub                        VARCHAR(400)      NULL,
+            title_short                      VARCHAR(400)      NULL,
+            title_edition                    VARCHAR(10)       NULL,
+            title_note                       VARCHAR(2500)     NULL,
+            title_language                   VARCHAR(100)      NULL,
+            title_language_char              VARCHAR(6)        NULL,
+            creator_author                   VARCHAR(600)      NULL,
+            creator_author_email             VARCHAR(100)      NULL,
+            creator_author_hon               VARCHAR(100)      NULL,
+            creator_author_nationality       VARCHAR(100)      NULL,
+            creator_editor                   VARCHAR(600)      NULL,
+            creator_contributor              VARCHAR(600)      NULL,
+            creator_illustrator              VARCHAR(600)      NULL,
+            creator_photographer             VARCHAR(600)      NULL,
+            creator_translator               VARCHAR(600)      NULL,
+            creator_prepared_by              VARCHAR(600)      NULL,
+            creator_digitized_by             VARCHAR(600)      NULL,
+            creator_audio                    VARCHAR(600)      NULL,
+            creator_video                    VARCHAR(600)      NULL,
+            language_document                VARCHAR(100)      NULL,
+            language_document_char           VARCHAR(6)        NULL, /*NOT*/
+            language_original                VARCHAR(100)      NULL,
+            language_original_char           VARCHAR(6)        NULL,
+            date_added_to_site               VARCHAR(10)       NULL,
+            date_available                   VARCHAR(10)       NULL,
+            date_created                     VARCHAR(10)       NULL,
+            date_issued                      VARCHAR(10)       NULL,
+            date_modified                    VARCHAR(10)       NULL,
+            date_published                   VARCHAR(10)       NULL,
+            date_valid                       VARCHAR(10)       NULL,
+            date_translated                  VARCHAR(10)       NULL,
+            date_original_publication        VARCHAR(10)       NULL,
+            date_generated                   VARCHAR(10)       NULL,
+            publisher                        VARCHAR(600)      NULL,
+            original_publisher               VARCHAR(600)      NULL,
+            original_language                VARCHAR(100)      NULL,
+            original_language_char           VARCHAR(6)        NULL,
+            original_source                  VARCHAR(600)      NULL,
+            original_institution             VARCHAR(600)      NULL,
+            original_nationality             VARCHAR(100)      NULL,
+            original_title                   VARCHAR(800)      NULL,
+            rights_copyright                 VARCHAR(2500)     NULL,
+            rights_copyright_audio           VARCHAR(2500)     NULL,
+            rights_copyright_cover           VARCHAR(2500)     NULL,
+            rights_copyright_illustrations   VARCHAR(2500)     NULL,
+            rights_copyright_photographs     VARCHAR(2500)     NULL,
+            rights_copyright_text            VARCHAR(2500)     NULL,
+            rights_copyright_translation     VARCHAR(2500)     NULL,
+            rights_copyright_video           VARCHAR(2500)     NULL,
+            rights_license                   VARCHAR(2500)     NULL,
+            identifier_oclc                  VARCHAR(30)       NULL,
+            identifier_isbn                  VARCHAR(16)       NULL,
+            classify_topic_register          VARCHAR(2500)     NULL,
+            classify_subject                 VARCHAR(600)      NULL,
+            classify_loc                     VARCHAR(30)       NULL,
+            classify_dewey                   VARCHAR(30)       NULL,
+            classify_keywords                VARCHAR(600)      NULL,
+            notes_abstract                   TEXT              NULL,
+            notes_description                TEXT              NULL,
+            notes_comment                    TEXT              NULL,
+            notes_coverage                   VARCHAR(200)      NULL,
+            notes_relation                   VARCHAR(200)      NULL,
+            notes_history                    VARCHAR(600)      NULL,
+            notes_type                       VARCHAR(600)      NULL,
+            notes_format                     VARCHAR(600)      NULL,
+            notes_prefix                     TEXT              NULL,
+            notes_prefix_a                   TEXT              NULL,
+            notes_prefix_b                   TEXT              NULL,
+            notes_suffix                     TEXT              NULL,
+            src_filename                     VARCHAR(256)      NULL,
+            src_fingerprint                  VARCHAR(256)      NULL,
+            src_filesize                     VARCHAR(10)       NULL,
+            src_wordcount                    VARCHAR(10)       NULL,
+            src_text                         TEXT              NULL,
+            fulltext                         TEXT              NULL,
+            links                            TEXT              NULL
+          );
+          /* */
+          CREATE TABLE doc_objects (
+            lid                              BIGINT PRIMARY KEY,
+            metadata_tid                     BIGINT REFERENCES metadata_and_text,
+            ocn                              SMALLINT,
+            ocnd                             VARCHAR(6),
+            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,
+            parent                           VARCHAR(16) NULL,
+            digest_clean                     CHAR(256),
+            digest_all                       CHAR(256),
+            types                            CHAR(1) NULL
+          )
+          ");
+        }
         Statement insert_metadata = db.prepare("
           INSERT INTO metadata_and_text (
             tid,
@@ -593,6 +595,7 @@ template SQLiteBuildTablesAndPopulate() {
             title_language,
             title_language_char,
             creator_author,
+            creator_author_email,
             creator_author_hon,
             creator_author_nationality,
             creator_editor,
@@ -625,14 +628,14 @@ template SQLiteBuildTablesAndPopulate() {
             original_source,
             original_institution,
             original_nationality,
-            rights,
-            rights_copyright_text,
-            rights_copyright_translation,
+            original_title,
+            rights_copyright,
+            rights_copyright_audio,
+            rights_copyright_cover,
             rights_copyright_illustrations,
             rights_copyright_photographs,
-            rights_copyright_preparation,
-            rights_copyright_digitization,
-            rights_copyright_audio,
+            rights_copyright_text,
+            rights_copyright_translation,
             rights_copyright_video,
             rights_license,
             identifier_oclc,
@@ -673,6 +676,7 @@ template SQLiteBuildTablesAndPopulate() {
             :title_language,
             :title_language_char,
             :creator_author,
+            :creator_author_email,
             :creator_author_hon,
             :creator_author_nationality,
             :creator_editor,
@@ -705,14 +709,14 @@ template SQLiteBuildTablesAndPopulate() {
             :original_source,
             :original_institution,
             :original_nationality,
-            :rights,
-            :rights_copyright_text,
-            :rights_copyright_translation,
+            :original_title,
+            :rights_copyright,
+            :rights_copyright_audio,
+            :rights_copyright_cover,
             :rights_copyright_illustrations,
             :rights_copyright_photographs,
-            :rights_copyright_preparation,
-            :rights_copyright_digitization,
-            :rights_copyright_audio,
+            :rights_copyright_text,
+            :rights_copyright_translation,
             :rights_copyright_video,
             :rights_license,
             :identifier_oclc,
@@ -743,74 +747,66 @@ template SQLiteBuildTablesAndPopulate() {
             :links
           )
         ");
+        // insert_metadata.bind(":tid",                               ); // unique identifier you could try use sha of title author & language? or auto increment??
         insert_metadata.bind(":title",                             doc_matters.conf_make_meta.meta.title_full);
-        // insert_metadata.bind(":title_main",                     doc_matters.conf_make_meta.meta.title_main);
-        // insert_metadata.bind(":title_sub",                      doc_matters.conf_make_meta.meta.title_subtitle);
-        // insert_metadata.bind(":title_short",                    doc_matters.conf_make_meta.meta.title_short); //
-        // insert_metadata.bind(":title_edition",                  doc_matters.conf_make_meta.meta.title_edition);
-        // insert_metadata.bind(":title_note",                     doc_matters.conf_make_meta.meta.title_note);
-        // insert_metadata.bind(":title_language",                 doc_matters.conf_make_meta.meta.title_language);
+        insert_metadata.bind(":title_main",                        doc_matters.conf_make_meta.meta.title_main);
+        insert_metadata.bind(":title_sub",                         doc_matters.conf_make_meta.meta.title_subtitle);
+        insert_metadata.bind(":title_short",                       doc_matters.conf_make_meta.meta.title_short); //
+        insert_metadata.bind(":title_edition",                     doc_matters.conf_make_meta.meta.title_edition);
+        insert_metadata.bind(":title_language",                    doc_matters.conf_make_meta.meta.title_language);
         // insert_metadata.bind(":title_language_char",            doc_matters.conf_make_meta.meta.title_language_char);
+        insert_metadata.bind(":classify_dewey",                    doc_matters.conf_make_meta.meta.classify_dewey);
+        insert_metadata.bind(":classify_keywords",                 doc_matters.conf_make_meta.meta.classify_keywords);
+        insert_metadata.bind(":classify_loc",                      doc_matters.conf_make_meta.meta.classify_loc);
+        insert_metadata.bind(":classify_subject",                  doc_matters.conf_make_meta.meta.classify_subject);
+        insert_metadata.bind(":classify_topic_register",           doc_matters.conf_make_meta.meta.classify_topic_register);
         insert_metadata.bind(":creator_author",                    doc_matters.conf_make_meta.meta.creator_author);
-        // insert_metadata.bind(":creator_author_hon",             doc_matters.conf_make_meta.meta.creator_author_hon);
-        // insert_metadata.bind(":creator_author_nationality",     doc_matters.conf_make_meta.meta.creator_author_nationality);
+        insert_metadata.bind(":creator_author_email",              doc_matters.conf_make_meta.meta.creator_author_email);
         // insert_metadata.bind(":creator_editor",                 doc_matters.conf_make_meta.meta.creator_editor);
         // insert_metadata.bind(":creator_contributor",            doc_matters.conf_make_meta.meta.creator_contributor);
-        // insert_metadata.bind(":creator_illustrator",            doc_matters.conf_make_meta.meta.creator_illustrator);
+        insert_metadata.bind(":creator_illustrator",               doc_matters.conf_make_meta.meta.creator_illustrator);
         // insert_metadata.bind(":creator_photographer",           doc_matters.conf_make_meta.meta.creator_photographer);
-        // insert_metadata.bind(":creator_translator",             doc_matters.conf_make_meta.meta.creator_translator);
-        // insert_metadata.bind(":creator_prepared_by",            doc_matters.conf_make_meta.meta.creator_prepared_by);
-        // insert_metadata.bind(":creator_digitized_by",           doc_matters.conf_make_meta.meta.creator_digitized_by);
+        insert_metadata.bind(":creator_translator",                doc_matters.conf_make_meta.meta.creator_translator);
         // insert_metadata.bind(":creator_audio",                  doc_matters.conf_make_meta.meta.creator_audio);
         // insert_metadata.bind(":creator_video",                  doc_matters.conf_make_meta.meta.creator_video);
-        // insert_metadata.bind(":language_document",              doc_matters.conf_make_meta.meta.language_document);
-        // insert_metadata.bind(":language_document_char",         doc_matters.conf_make_meta.meta.language_document_char);
-        // insert_metadata.bind(":language_original",              doc_matters.conf_make_meta.meta.language_original);
-        // insert_metadata.bind(":language_original_char",         doc_matters.conf_make_meta.meta.language_original_char);
-        // insert_metadata.bind(":date_added_to_site",             doc_matters.conf_make_meta.meta.date_added_to_site);
-        // insert_metadata.bind(":date_available",                 doc_matters.conf_make_meta.meta.date_available);
-        // insert_metadata.bind(":date_created",                   doc_matters.conf_make_meta.meta.date_created);
-        // insert_metadata.bind(":date_issued",                    doc_matters.conf_make_meta.meta.date_issued);
-        // insert_metadata.bind(":date_modified",                  doc_matters.conf_make_meta.meta.date_modified);
-        // insert_metadata.bind(":date_published",                 doc_matters.conf_make_meta.meta.date_published);
-        // insert_metadata.bind(":date_valid",                     doc_matters.conf_make_meta.meta.date_valid);
+        insert_metadata.bind(":date_added_to_site",                doc_matters.conf_make_meta.meta.date_added_to_site);
+        insert_metadata.bind(":date_available",                    doc_matters.conf_make_meta.meta.date_available);
+        insert_metadata.bind(":date_created",                      doc_matters.conf_make_meta.meta.date_created);
+        insert_metadata.bind(":date_issued",                       doc_matters.conf_make_meta.meta.date_issued);
+        insert_metadata.bind(":date_modified",                     doc_matters.conf_make_meta.meta.date_modified);
+        insert_metadata.bind(":date_published",                    doc_matters.conf_make_meta.meta.date_published);
+        insert_metadata.bind(":date_valid",                        doc_matters.conf_make_meta.meta.date_valid);
         // insert_metadata.bind(":date_translated",                doc_matters.conf_make_meta.meta.date_translated);
         // insert_metadata.bind(":date_original_publication",      doc_matters.conf_make_meta.meta.date_original_publication);
         // insert_metadata.bind(":date_generated",                 doc_matters.conf_make_meta.meta.date_generated);
-        // insert_metadata.bind(":publisher",                      doc_matters.conf_make_meta.meta.publisher));
-        // insert_metadata.bind(":original_publisher",             doc_matters.conf_make_meta.meta.original_publisher);
-        // insert_metadata.bind(":original_language",              doc_matters.conf_make_meta.meta.original_language);
-        // insert_metadata.bind(":original_language_char",         doc_matters.conf_make_meta.meta.original_language_char);
-        // insert_metadata.bind(":original_source",                doc_matters.conf_make_meta.meta.original_source);
-        // insert_metadata.bind(":original_institution",           doc_matters.conf_make_meta.meta.original_institution);
-        // insert_metadata.bind(":original_nationality",           doc_matters.conf_make_meta.meta.original_nationality);
+        insert_metadata.bind(":identifier_isbn",                   doc_matters.conf_make_meta.meta.identifier_isbn);
+        insert_metadata.bind(":identifier_oclc",                   doc_matters.conf_make_meta.meta.identifier_oclc);
+        insert_metadata.bind(":language_document",                 doc_matters.conf_make_meta.meta.language_document);
+        insert_metadata.bind(":language_document_char",            doc_matters.conf_make_meta.meta.language_document_char);
+        // insert_metadata.bind(":language_original",              doc_matters.conf_make_meta.meta.language_original);
+        // insert_metadata.bind(":language_original_char",         doc_matters.conf_make_meta.meta.language_original_char);
+        insert_metadata.bind(":notes_abstract",                    doc_matters.conf_make_meta.meta.notes_abstract);
+        insert_metadata.bind(":notes_description",                 doc_matters.conf_make_meta.meta.notes_description);
+        insert_metadata.bind(":original_publisher",                doc_matters.conf_make_meta.meta.original_publisher);
+        insert_metadata.bind(":original_language",                 doc_matters.conf_make_meta.meta.original_language);
+        insert_metadata.bind(":original_language_char",            doc_matters.conf_make_meta.meta.original_language_char);
+        insert_metadata.bind(":original_source",                   doc_matters.conf_make_meta.meta.original_source);
+        insert_metadata.bind(":original_title",                    doc_matters.conf_make_meta.meta.original_title);
+        insert_metadata.bind(":publisher",                         doc_matters.conf_make_meta.meta.publisher);
         // insert_metadata.bind(":rights",                         doc_matters.conf_make_meta.meta.rights);
-        // insert_metadata.bind(":rights_copyright_text",          doc_matters.conf_make_meta.meta.rights_copyright_text);
-        // insert_metadata.bind(":rights_copyright_translation",   doc_matters.conf_make_meta.meta.rights_copyright_translation);
-        // insert_metadata.bind(":rights_copyright_illustrations", doc_matters.conf_make_meta.meta.rights_illustrations);
-        // insert_metadata.bind(":rights_copyright_photographs",   doc_matters.conf_make_meta.meta.rights_photographs);
+        insert_metadata.bind(":rights_copyright",                  doc_matters.conf_make_meta.meta.rights_copyright);
+        insert_metadata.bind(":rights_copyright_audio",            doc_matters.conf_make_meta.meta.rights_copyright_audio);
+        insert_metadata.bind(":rights_copyright_cover",            doc_matters.conf_make_meta.meta.rights_copyright_cover);
+        insert_metadata.bind(":rights_copyright_illustrations",    doc_matters.conf_make_meta.meta.rights_copyright_illustrations);
+        insert_metadata.bind(":rights_copyright_photographs",      doc_matters.conf_make_meta.meta.rights_copyright_photographs);
         // insert_metadata.bind(":rights_copyright_preparation",   doc_matters.conf_make_meta.meta.rights_preparation);
+        insert_metadata.bind(":rights_copyright_text",      doc_matters.conf_make_meta.meta.rights_copyright_text);
+        insert_metadata.bind(":rights_copyright_translation",      doc_matters.conf_make_meta.meta.rights_copyright_translation);
+        insert_metadata.bind(":rights_copyright_video",            doc_matters.conf_make_meta.meta.rights_copyright_video);
         // insert_metadata.bind(":rights_copyright_digitization",  doc_matters.conf_make_meta.meta.rights_digitization);
         // insert_metadata.bind(":rights_copyright_audio",         doc_matters.conf_make_meta.meta.rights_audio);
         // insert_metadata.bind(":rights_copyright_video",         doc_matters.conf_make_meta.meta.rights_video);
-        // insert_metadata.bind(":rights_license",                 doc_matters.conf_make_meta.meta.rights_license);
-        // insert_metadata.bind(":identifier_oclc",                doc_matters.conf_make_meta.meta.identifier_oclc);
-        // insert_metadata.bind(":identifier_isbn",                doc_matters.conf_make_meta.meta.identifier_isbn);
-        // insert_metadata.bind(":classify_topic_register",        doc_matters.conf_make_meta.meta.classify_topic_register);
-        // insert_metadata.bind(":classify_subject",               doc_matters.conf_make_meta.meta.classify_subject);
-        // insert_metadata.bind(":classify_loc",                   doc_matters.conf_make_meta.meta.classify_loc);
-        // insert_metadata.bind(":notes_abstract",                 doc_matters.conf_make_meta.meta.notes_abstract);
-        // insert_metadata.bind(":notes_description",              doc_matters.conf_make_meta.meta.notes_description);
-        // insert_metadata.bind(":notes_comment",                  doc_matters.conf_make_meta.meta.notes_comment);
-        // insert_metadata.bind(":notes_coverage",                 doc_matters.conf_make_meta.meta.notes_coverage);
-        // insert_metadata.bind(":notes_relation",                 doc_matters.conf_make_meta.meta.notes_relation);
-        // insert_metadata.bind(":notes_history",                  doc_matters.conf_make_meta.meta.notes_history);
-        // insert_metadata.bind(":notes_type",                     doc_matters.conf_make_meta.meta.notes_type);
-        // insert_metadata.bind(":notes_format",                   doc_matters.conf_make_meta.meta.notes_format);
-        // insert_metadata.bind(":notes_prefix",                   doc_matters.conf_make_meta.meta.notes_prefix);
-        // insert_metadata.bind(":notes_prefix_a",                 doc_matters.conf_make_meta.meta.notes_prefix_a);
-        // insert_metadata.bind(":notes_prefix_b",                 doc_matters.conf_make_meta.meta.notes_prefix_b);
-        // insert_metadata.bind(":notes_suffix",                   doc_matters.conf_make_meta.meta.notes_suffix);
+        insert_metadata.bind(":rights_license",                    doc_matters.conf_make_meta.meta.rights_license);
         // insert_metadata.bind(":src_filename",                   doc_matters.conf_make_meta.meta.src_filename);
         // insert_metadata.bind(":src_fingerprint",                doc_matters.conf_make_meta.meta.src_fingerprint);
         // insert_metadata.bind(":src_filesize",                   doc_matters.conf_make_meta.meta.src_filesize);
@@ -822,7 +818,7 @@ template SQLiteBuildTablesAndPopulate() {
         /+ watch +/
         writeln("sql statement executed");
         assert(db.totalChanges == 1);
-        
+        //
         Statement insert_doc_objects = db.prepare("
           INSERT INTO doc_objects (
             lid,