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, 17 insertions, 1 deletions

diff --git a/lib/sisu/v2/constants.rb b/lib/sisu/v2/constants.rb
index 9abe9c0b..3fcb1e3a 100644
--- a/lib/sisu/v2/constants.rb
+++ b/lib/sisu/v2/constants.rb
@@ -111,7 +111,6 @@ Rx[:meta]=/#{Mx[:meta_o]}(\S+?)#{Mx[:meta_c]}/
 Dx[:url_o]='‹';   Dx[:url_c]='›'
 Dx[:url_o_xml]='<';   Dx[:url_c_xml]='>'
 Dx[:rel_o]='‹';   Dx[:rel_c]='›'
-Db[:name_prefix]="SiSU#{SiSU_version_dir}_"
 Tex[:backslash]="\\\\"
 Tex[:backslash]="\\\\"
 Tex[:tilde]='\\\\\\~'
@@ -132,6 +131,23 @@ Px[:lv4]=     '-'
 Px[:lv5]=     '.'
 Px[:lv6]=     '.'
 #Px[:lv5_6]=   '.'
+Db[:name_prefix]="SiSU#{SiSU_version_dir}a_"
+Db[:name_prefix_db]="sisu_#{SiSU_version_dir}a_"
+Db[:col_title]=800
+Db[:col_title_part]=400
+Db[:col_title_edition]=10
+Db[:col_name]=600
+Db[:col_creator_misc_short]=100
+Db[:col_language]=100
+Db[:col_language_char]=3
+Db[:col_date_text]=10
+Db[:col_classify_txt_long]=600
+Db[:col_classify_txt_short]=600
+Db[:col_classify_short]=200
+Db[:col_classify_identify]=256
+Db[:col_classify_library]=30
+Db[:col_classify_small]=16
+Db[:col_filename]=256
 __END__
 consider:
   〔comment〕