Add indexes to taxhist and inherited tables. Plus invchead index.

diff --git a/foundation-database/manifest.js b/foundation-database/manifest.js
index d729a19..38a38b5 100644 (file)
--- a/foundation-database/manifest.js
+++ b/foundation-database/manifest.js
@@ -990,7 +990,24 @@
     "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",
     "public/views/armemo.sql",

diff --git a/foundation-database/public/tables/apopentax.sql b/foundation-database/public/tables/apopentax.sql
new file mode 100644 (file)
index 0000000..893b0ec
--- /dev/null
+++ b/foundation-database/public/tables/apopentax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX apopentax_taxhist_parent_id_idx on apopentax using btree (taxhist_parent_id);
+select xt.add_index('apopentax', 'taxhist_parent_id','apopentax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX apopentax_taxhist_taxtype_id_idx on apopentax using btree (taxhist_taxtype_id);
+select xt.add_index('apopentax', 'taxhist_taxtype_id','apopentax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX apopentax_taxhist_parent_type_idx on apopentax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('apopentax', 'taxhist_parent_id, taxhist_taxtype_id','apopentax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/aropentax.sql b/foundation-database/public/tables/aropentax.sql
new file mode 100644 (file)
index 0000000..d850803
--- /dev/null
+++ b/foundation-database/public/tables/aropentax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX aropentax_taxhist_parent_id_idx on aropentax using btree (taxhist_parent_id);
+select xt.add_index('aropentax', 'taxhist_parent_id','aropentax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX aropentax_taxhist_taxtype_id_idx on aropentax using btree (taxhist_taxtype_id);
+select xt.add_index('aropentax', 'taxhist_taxtype_id','aropentax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX aropentax_taxhist_parent_type_idx on aropentax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('aropentax', 'taxhist_parent_id, taxhist_taxtype_id','aropentax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/asohisttax.sql b/foundation-database/public/tables/asohisttax.sql
new file mode 100644 (file)
index 0000000..1247dd2
--- /dev/null
+++ b/foundation-database/public/tables/asohisttax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX asohisttax_taxhist_parent_id_idx on asohisttax using btree (taxhist_parent_id);
+select xt.add_index('asohisttax', 'taxhist_parent_id','asohisttax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX asohisttax_taxhist_taxtype_id_idx on asohisttax using btree (taxhist_taxtype_id);
+select xt.add_index('asohisttax', 'taxhist_taxtype_id','asohisttax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX asohisttax_taxhist_parent_type_idx on asohisttax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('asohisttax', 'taxhist_parent_id, taxhist_taxtype_id','asohisttax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/cmheadtax.sql b/foundation-database/public/tables/cmheadtax.sql
new file mode 100644 (file)
index 0000000..4f60ec9
--- /dev/null
+++ b/foundation-database/public/tables/cmheadtax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX cmheadtax_taxhist_parent_id_idx on cmheadtax using btree (taxhist_parent_id);
+select xt.add_index('cmheadtax', 'taxhist_parent_id','cmheadtax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX cmheadtax_taxhist_taxtype_id_idx on cmheadtax using btree (taxhist_taxtype_id);
+select xt.add_index('cmheadtax', 'taxhist_taxtype_id','cmheadtax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX cmheadtax_taxhist_parent_type_idx on cmheadtax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('cmheadtax', 'taxhist_parent_id, taxhist_taxtype_id','cmheadtax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/cmitemtax.sql b/foundation-database/public/tables/cmitemtax.sql
new file mode 100644 (file)
index 0000000..cb711c2
--- /dev/null
+++ b/foundation-database/public/tables/cmitemtax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX cmitemtax_taxhist_parent_id_idx on cmitemtax using btree (taxhist_parent_id);
+select xt.add_index('cmitemtax', 'taxhist_parent_id','cmitemtax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX cmitemtax_taxhist_taxtype_id_idx on cmitemtax using btree (taxhist_taxtype_id);
+select xt.add_index('cmitemtax', 'taxhist_taxtype_id','cmitemtax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX cmitemtax_taxhist_parent_type_idx on cmitemtax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('cmitemtax', 'taxhist_parent_id, taxhist_taxtype_id','cmitemtax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/cobilltax.sql b/foundation-database/public/tables/cobilltax.sql
new file mode 100644 (file)
index 0000000..b2f44df
--- /dev/null
+++ b/foundation-database/public/tables/cobilltax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX cobilltax_taxhist_parent_id_idx on cobilltax using btree (taxhist_parent_id);
+select xt.add_index('cobilltax', 'taxhist_parent_id','cobilltax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX cobilltax_taxhist_taxtype_id_idx on cobilltax using btree (taxhist_taxtype_id);
+select xt.add_index('cobilltax', 'taxhist_taxtype_id','cobilltax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX cobilltax_taxhist_parent_type_idx on cobilltax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('cobilltax', 'taxhist_parent_id, taxhist_taxtype_id','cobilltax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/cobmisctax.sql b/foundation-database/public/tables/cobmisctax.sql
new file mode 100644 (file)
index 0000000..7925844
--- /dev/null
+++ b/foundation-database/public/tables/cobmisctax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX cobmisctax_taxhist_parent_id_idx on cobmisctax using btree (taxhist_parent_id);
+select xt.add_index('cobmisctax', 'taxhist_parent_id','cobmisctax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX cobmisctax_taxhist_taxtype_id_idx on cobmisctax using btree (taxhist_taxtype_id);
+select xt.add_index('cobmisctax', 'taxhist_taxtype_id','cobmisctax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX cobmisctax_taxhist_parent_type_idx on cobmisctax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('cobmisctax', 'taxhist_parent_id, taxhist_taxtype_id','cobmisctax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/cohisttax.sql b/foundation-database/public/tables/cohisttax.sql
new file mode 100644 (file)
index 0000000..b5da013
--- /dev/null
+++ b/foundation-database/public/tables/cohisttax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX cohisttax_taxhist_parent_id_idx on cohisttax using btree (taxhist_parent_id);
+select xt.add_index('cohisttax', 'taxhist_parent_id','cohisttax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX cohisttax_taxhist_taxtype_id_idx on cohisttax using btree (taxhist_taxtype_id);
+select xt.add_index('cohisttax', 'taxhist_taxtype_id','cohisttax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX cohisttax_taxhist_parent_type_idx on cohisttax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('cohisttax', 'taxhist_parent_id, taxhist_taxtype_id','cohisttax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/invchead.sql b/foundation-database/public/tables/invchead.sql
new file mode 100644 (file)
index 0000000..94b61fb
--- /dev/null
+++ b/foundation-database/public/tables/invchead.sql
@@ -0,0 +1,2 @@
+--CREATE INDEX invchead_invchead_cust_id_idx on invchead using btree (invchead_cust_id);
+select xt.add_index('invchead', 'invchead_cust_id','invchead_invchead_cust_id_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/invcheadtax.sql b/foundation-database/public/tables/invcheadtax.sql
new file mode 100644 (file)
index 0000000..fdad4cf
--- /dev/null
+++ b/foundation-database/public/tables/invcheadtax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX invcheadtax_taxhist_parent_id_idx on invcheadtax using btree (taxhist_parent_id);
+select xt.add_index('invcheadtax', 'taxhist_parent_id','invcheadtax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX invcheadtax_taxhist_taxtype_id_idx on invcheadtax using btree (taxhist_taxtype_id);
+select xt.add_index('invcheadtax', 'taxhist_taxtype_id','invcheadtax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX invcheadtax_taxhist_parent_type_idx on invcheadtax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('invcheadtax', 'taxhist_parent_id, taxhist_taxtype_id','invcheadtax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/invcitemtax.sql b/foundation-database/public/tables/invcitemtax.sql
new file mode 100644 (file)
index 0000000..aaa7f42
--- /dev/null
+++ b/foundation-database/public/tables/invcitemtax.sql
@@ -0,0 +1,5 @@
+--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/tables/taxhist.sql
new file mode 100644 (file)
index 0000000..48176dd
--- /dev/null
+++ b/foundation-database/public/tables/taxhist.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX taxhist_taxhist_parent_id_idx on taxhist using btree (taxhist_parent_id);
+select xt.add_index('taxhist', 'taxhist_parent_id','taxhist_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX taxhist_taxhist_taxtype_id_idx on taxhist using btree (taxhist_taxtype_id);
+select xt.add_index('taxhist', 'taxhist_taxtype_id','taxhist_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX taxhist_taxhist_parent_type_idx on taxhist using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('taxhist', 'taxhist_parent_id, taxhist_taxtype_id','taxhist_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/toheadtax.sql b/foundation-database/public/tables/toheadtax.sql
new file mode 100644 (file)
index 0000000..ce9d236
--- /dev/null
+++ b/foundation-database/public/tables/toheadtax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX toheadtax_taxhist_parent_id_idx on toheadtax using btree (taxhist_parent_id);
+select xt.add_index('toheadtax', 'taxhist_parent_id','toheadtax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX toheadtax_taxhist_taxtype_id_idx on toheadtax using btree (taxhist_taxtype_id);
+select xt.add_index('toheadtax', 'taxhist_taxtype_id','toheadtax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX toheadtax_taxhist_parent_type_idx on toheadtax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('toheadtax', 'taxhist_parent_id, taxhist_taxtype_id','toheadtax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/toitemtax.sql b/foundation-database/public/tables/toitemtax.sql
new file mode 100644 (file)
index 0000000..5b8f29c
--- /dev/null
+++ b/foundation-database/public/tables/toitemtax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX toitemtax_taxhist_parent_id_idx on toitemtax using btree (taxhist_parent_id);
+select xt.add_index('toitemtax', 'taxhist_parent_id','toitemtax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX toitemtax_taxhist_taxtype_id_idx on toitemtax using btree (taxhist_taxtype_id);
+select xt.add_index('toitemtax', 'taxhist_taxtype_id','toitemtax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX toitemtax_taxhist_parent_type_idx on toitemtax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('toitemtax', 'taxhist_parent_id, taxhist_taxtype_id','toitemtax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/voheadtax.sql b/foundation-database/public/tables/voheadtax.sql
new file mode 100644 (file)
index 0000000..3f7edc6
--- /dev/null
+++ b/foundation-database/public/tables/voheadtax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX voheadtax_taxhist_parent_id_idx on voheadtax using btree (taxhist_parent_id);
+select xt.add_index('voheadtax', 'taxhist_parent_id','voheadtax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX voheadtax_taxhist_taxtype_id_idx on voheadtax using btree (taxhist_taxtype_id);
+select xt.add_index('voheadtax', 'taxhist_taxtype_id','voheadtax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX voheadtax_taxhist_parent_type_idx on voheadtax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('voheadtax', 'taxhist_parent_id, taxhist_taxtype_id','voheadtax_taxhist_parent_type_idx', 'btree', 'public');

diff --git a/foundation-database/public/tables/voitemtax.sql b/foundation-database/public/tables/voitemtax.sql
new file mode 100644 (file)
index 0000000..79011c6
--- /dev/null
+++ b/foundation-database/public/tables/voitemtax.sql
@@ -0,0 +1,8 @@
+--CREATE INDEX voitemtax_taxhist_parent_id_idx on voitemtax using btree (taxhist_parent_id);
+select xt.add_index('voitemtax', 'taxhist_parent_id','voitemtax_taxhist_parent_id_idx', 'btree', 'public');
+
+--CREATE INDEX voitemtax_taxhist_taxtype_id_idx on voitemtax using btree (taxhist_taxtype_id);
+select xt.add_index('voitemtax', 'taxhist_taxtype_id','voitemtax_taxhist_taxtype_id_idx', 'btree', 'public');
+
+--CREATE INDEX voitemtax_taxhist_parent_type_idx on voitemtax using btree (taxhist_parent_id, taxhist_taxtype_id);
+select xt.add_index('voitemtax', 'taxhist_parent_id, taxhist_taxtype_id','voitemtax_taxhist_parent_type_idx', 'btree', 'public');