Move to the indexes dir.

diff --git a/foundation-database/manifest.js b/foundation-database/manifest.js
index 38a38b5..220984b 100644 (file)
--- a/foundation-database/manifest.js
+++ b/foundation-database/manifest.js
@@ -5,9 +5,24 @@
     "remove from 440_schema.sql everything that's defined here. it's now redundant"
   ],
   "databaseScripts": [
+    "public/indexes/apopentax.sql",
+    "public/indexes/aropentax.sql",
+    "public/indexes/asohisttax.sql",
+    "public/indexes/cmheadtax.sql",
+    "public/indexes/cmitemtax.sql",
+    "public/indexes/cobilltax.sql",
+    "public/indexes/cobmisctax.sql",
+    "public/indexes/cohisttax.sql",
     "public/indexes/evntlog.sql",
+    "public/indexes/invchead.sql",
+    "public/indexes/invcheadtax.sql",
     "public/indexes/invcitemtax.sql",
     "public/indexes/shipitem.sql",
+    "public/indexes/taxhist.sql",
+    "public/indexes/toheadtax.sql",
+    "public/indexes/toitemtax.sql",
+    "public/indexes/voheadtax.sql",
+    "public/indexes/voitemtax.sql",
 
     "public/types/achline.sql",
     "public/types/apaging.sql",
@@ -990,23 +1005,7 @@
     "public/trigger_functions/wo.sql",
     "public/trigger_functions/womatl.sql",
 
-    "public/tables/apopentax.sql",
-    "public/tables/aropentax.sql",
-    "public/tables/asohisttax.sql",
-    "public/tables/cmheadtax.sql",
-    "public/tables/cmitemtax.sql",
-    "public/tables/cobilltax.sql",
-    "public/tables/cobmisctax.sql",
-    "public/tables/cohisttax.sql",
-    "public/tables/invchead.sql",
-    "public/tables/invcheadtax.sql",
-    "public/tables/invcitemtax.sql",
     "public/tables/metric.sql",
-    "public/tables/taxhist.sql",
-    "public/tables/toheadtax.sql",
-    "public/tables/toitemtax.sql",
-    "public/tables/voheadtax.sql",
-    "public/tables/voitemtax.sql",
 
     "public/views/address.sql",
     "public/views/apmemo.sql",

diff --git a/foundation-database/public/tables/apopentax.sql b/foundation-database/public/indexes/apopentax.sql
similarity index 100%
rename from foundation-database/public/tables/apopentax.sql
rename to foundation-database/public/indexes/apopentax.sql

diff --git a/foundation-database/public/tables/aropentax.sql b/foundation-database/public/indexes/aropentax.sql
similarity index 100%
rename from foundation-database/public/tables/aropentax.sql
rename to foundation-database/public/indexes/aropentax.sql

diff --git a/foundation-database/public/tables/asohisttax.sql b/foundation-database/public/indexes/asohisttax.sql
similarity index 100%
rename from foundation-database/public/tables/asohisttax.sql
rename to foundation-database/public/indexes/asohisttax.sql

diff --git a/foundation-database/public/tables/cmheadtax.sql b/foundation-database/public/indexes/cmheadtax.sql
similarity index 100%
rename from foundation-database/public/tables/cmheadtax.sql
rename to foundation-database/public/indexes/cmheadtax.sql

diff --git a/foundation-database/public/tables/cmitemtax.sql b/foundation-database/public/indexes/cmitemtax.sql
similarity index 100%
rename from foundation-database/public/tables/cmitemtax.sql
rename to foundation-database/public/indexes/cmitemtax.sql

diff --git a/foundation-database/public/tables/cobilltax.sql b/foundation-database/public/indexes/cobilltax.sql
similarity index 100%
rename from foundation-database/public/tables/cobilltax.sql
rename to foundation-database/public/indexes/cobilltax.sql

diff --git a/foundation-database/public/tables/cobmisctax.sql b/foundation-database/public/indexes/cobmisctax.sql
similarity index 100%
rename from foundation-database/public/tables/cobmisctax.sql
rename to foundation-database/public/indexes/cobmisctax.sql

diff --git a/foundation-database/public/tables/cohisttax.sql b/foundation-database/public/indexes/cohisttax.sql
similarity index 100%
rename from foundation-database/public/tables/cohisttax.sql
rename to foundation-database/public/indexes/cohisttax.sql

diff --git a/foundation-database/public/tables/invchead.sql b/foundation-database/public/indexes/invchead.sql
similarity index 100%
rename from foundation-database/public/tables/invchead.sql
rename to foundation-database/public/indexes/invchead.sql

diff --git a/foundation-database/public/tables/invcheadtax.sql b/foundation-database/public/indexes/invcheadtax.sql
similarity index 100%
rename from foundation-database/public/tables/invcheadtax.sql
rename to foundation-database/public/indexes/invcheadtax.sql

diff --git a/foundation-database/public/indexes/invcitemtax.sql b/foundation-database/public/indexes/invcitemtax.sql
index af601dc..ff7c07c 100644 (file)
--- a/foundation-database/public/indexes/invcitemtax.sql
+++ b/foundation-database/public/indexes/invcitemtax.sql
@@ -1,3 +1,8 @@
-DROP INDEX IF EXISTS invcitemtax_taxhist_parent_id_idx;
-CREATE INDEX invcitemtax_taxhist_parent_id_idx ON invcitemtax (taxhist_parent_id);
+--CREATE INDEX invcitemtax_taxhist_parent_id_idx on invcitemtax using btree (taxhist_parent_id);
+select xt.add_index('invcitemtax', 'taxhist_parent_id','invcitemtax_taxhist_parent_id_idx', 'btree', 'public');
 
+--CREATE INDEX invcitemtax_taxhist_taxtype_id_idx on invcitemtax using btree (taxhist_taxtype_id);
+select xt.add_index('invcitemtax', 'taxhist_taxtype_id','invcitemtax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX invcitemtax_taxhist_parent_type_idx on invcitemtax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('invcitemtax', 'taxhist_parent_id, taxhist_taxtype_id','invcitemtax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/taxhist.sql b/foundation-database/public/indexes/taxhist.sql
similarity index 100%
rename from foundation-database/public/tables/taxhist.sql
rename to foundation-database/public/indexes/taxhist.sql

diff --git a/foundation-database/public/tables/toheadtax.sql b/foundation-database/public/indexes/toheadtax.sql
similarity index 100%
rename from foundation-database/public/tables/toheadtax.sql
rename to foundation-database/public/indexes/toheadtax.sql

diff --git a/foundation-database/public/tables/toitemtax.sql b/foundation-database/public/indexes/toitemtax.sql
similarity index 100%
rename from foundation-database/public/tables/toitemtax.sql
rename to foundation-database/public/indexes/toitemtax.sql

diff --git a/foundation-database/public/tables/voheadtax.sql b/foundation-database/public/indexes/voheadtax.sql
similarity index 100%
rename from foundation-database/public/tables/voheadtax.sql
rename to foundation-database/public/indexes/voheadtax.sql

diff --git a/foundation-database/public/tables/voitemtax.sql b/foundation-database/public/indexes/voitemtax.sql
similarity index 100%
rename from foundation-database/public/tables/voitemtax.sql
rename to foundation-database/public/indexes/voitemtax.sql

diff --git a/foundation-database/public/tables/invcitemtax.sql b/foundation-database/public/tables/invcitemtax.sql
deleted file mode 100644 (file)
index aaa7f42..0000000
--- a/foundation-database/public/tables/invcitemtax.sql
+++ /dev/null
@@ -1,5 +0,0 @@
---CREATE INDEX invcitemtax_taxhist_taxtype_id_idx on invcitemtax using btree (taxhist_taxtype_id);
-select xt.add_index('invcitemtax', 'taxhist_taxtype_id','invcitemtax_taxhist_taxtype_id_idx', 'btree', 'public');
-
---CREATE INDEX invcitemtax_taxhist_parent_type_idx on invcitemtax using btree (taxhist_parent_id, taxhist_taxtype_id);
-select xt.add_index('invcitemtax', 'taxhist_parent_id, taxhist_taxtype_id','invcitemtax_taxhist_parent_type_idx', 'btree', 'public');