From 902cd8a3713746761e456eeccef22e3afcd901ef Mon Sep 17 00:00:00 2001 From: Ben Thompson Date: Tue, 20 May 2014 16:45:56 -0400 Subject: [PATCH] Move to indexes to private-ext. --- foundation-database/manifest.js | 2 -- foundation-database/public/indexes/toheadtax.sql | 8 -------- foundation-database/public/indexes/toitemtax.sql | 8 -------- 3 files changed, 18 deletions(-) delete mode 100644 foundation-database/public/indexes/toheadtax.sql delete mode 100644 foundation-database/public/indexes/toitemtax.sql diff --git a/foundation-database/manifest.js b/foundation-database/manifest.js index 5f7d8bae0..20cdb9ea5 100644 --- a/foundation-database/manifest.js +++ b/foundation-database/manifest.js @@ -26,8 +26,6 @@ "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", diff --git a/foundation-database/public/indexes/toheadtax.sql b/foundation-database/public/indexes/toheadtax.sql deleted file mode 100644 index ce9d23604..000000000 --- a/foundation-database/public/indexes/toheadtax.sql +++ /dev/null @@ -1,8 +0,0 @@ ---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/indexes/toitemtax.sql b/foundation-database/public/indexes/toitemtax.sql deleted file mode 100644 index 5b8f29c14..000000000 --- a/foundation-database/public/indexes/toitemtax.sql +++ /dev/null @@ -1,8 +0,0 @@ ---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'); -- 2.39.2