db sql table and column structure changes, name prefix "sisu_v2a_" resulting sisu version bump 2.1.0, plus other lesser fixes

[Note: it is necessary to create new database and tables and to populate them]

* db (sql) database table name and column structure changes, new pgsql db name
  prefix "sisu_v2a_" (version bump), continue to review
  (db_columns, db_create, db_import, db_sqltxt)

* db remove and update fix, match filename for removal with = (not LIKE or ~)

* db sqlite, issue with --recreate, bugfix
  (db_drop)

1 files changed, 12 insertions, 12 deletions

diff --git a/lib/sisu/v2/db_indexes.rb b/lib/sisu/v2/db_indexes.rb
index a64fb362..3cbcc20c 100644
--- a/lib/sisu/v2/db_indexes.rb
+++ b/lib/sisu/v2/db_indexes.rb
@@ -73,15 +73,15 @@ module SiSU_DB_index
       def base
         print "\n          create documents common indexes\n" unless @opt.cmd =~/q/
         sql_arr=[
-          %{CREATE INDEX object_nr ON documents(ocn);},
-          %{CREATE INDEX digest_clean ON documents(digest_clean);},
-          %{CREATE INDEX digest_all ON documents(digest_all);},
-          %{CREATE INDEX lev1 ON documents(lev1);},
-          %{CREATE INDEX lev2 ON documents(lev2);},
-          %{CREATE INDEX lev3 ON documents(lev3);},
-          %{CREATE INDEX lev4 ON documents(lev4);},
-          %{CREATE INDEX lev5 ON documents(lev5);},
-          %{CREATE INDEX lev6 ON documents(lev6);},
+          %{CREATE INDEX object_nr ON doc_objects(ocn);},
+          %{CREATE INDEX digest_clean ON doc_objects(digest_clean);},
+          %{CREATE INDEX digest_all ON doc_objects(digest_all);},
+          %{CREATE INDEX lev1 ON doc_objects(lev1);},
+          %{CREATE INDEX lev2 ON doc_objects(lev2);},
+          %{CREATE INDEX lev3 ON doc_objects(lev3);},
+          %{CREATE INDEX lev4 ON doc_objects(lev4);},
+          %{CREATE INDEX lev5 ON doc_objects(lev5);},
+          %{CREATE INDEX lev6 ON doc_objects(lev6);},
           %{CREATE INDEX endnote_nr ON endnotes(nr);},
           %{CREATE INDEX digest_en ON endnotes(digest_clean);},
           %{CREATE INDEX endnote_nr_asterisk ON endnotes_asterisk(nr);},
@@ -90,15 +90,15 @@ module SiSU_DB_index
           %{CREATE INDEX endnote_nr_plus ON endnotes_plus(nr);},
           %{CREATE INDEX endnote_plus ON endnotes_plus(clean);},
           %{CREATE INDEX digest_en_plus ON endnotes_plus(digest_clean);},
-          %{CREATE INDEX title ON metadata(title);},
-          %{CREATE INDEX filename ON metadata(filename)},
+          %{CREATE INDEX title ON metadata_and_text(title);},
+          %{CREATE INDEX filename ON metadata_and_text(filename)},
         ]
         conn_execute_array(sql_arr)
       end
       def text
         print "\n          create documents text indexes\n" unless @opt.cmd =~/q/
         sql_arr=[
-          %{CREATE INDEX clean ON documents(clean);},
+          %{CREATE INDEX clean ON doc_objects(clean);},
           %{CREATE INDEX endnote ON endnotes(clean);}
         ]
         conn_execute_array(sql_arr)