summaryrefslogtreecommitdiff
path: root/sql/legacy
diff options
context:
space:
mode:
authortetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>2006-11-12 06:55:19 +0000
committertetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>2006-11-12 06:55:19 +0000
commit7578960f91c2385b07a44e051d5d79b72e1e38c9 (patch)
tree82c49891f94824508fe7fb562120fb18202e26e7 /sql/legacy
parentd570fc9447f3faa8b4c67eff73d69ef04997dea2 (diff)
Adding tax category support to the db
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@524 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/legacy')
-rw-r--r--sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql b/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
index 90e7e313..9594f9a0 100644
--- a/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
+++ b/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
@@ -43,6 +43,8 @@ ALTER TABLE parts ADD PRIMARY KEY (id);
ALTER TABLE partsgroup ADD PRIMARY KEY (id);
ALTER TABLE partstax ADD PRIMARY KEY (parts_id, chart_id);
+ALTER TABLE partstax ADD FOREIGN KEY (chart_id) REFERENCES chart (id);
+ALTER TABLE partstax ADD FOREIGN KEY (parts_id) REFERENCES parts (id);
ALTER TABLE pricegroup ADD PRIMARY KEY (id);
@@ -132,6 +134,14 @@ INSERT INTO taxmodule (
1, 'Simple'
);
+CREATE TABLE taxcategory (
+ taxcategory_id serial PRIMARY KEY,
+ taxcategoryname text NOT NULL,
+ taxmodule_id int NOT NULL REFERENCES taxmodule (taxmodule_id)
+);
+
+ALTER TABLE partstax ADD COLUMN taxcategory_id int REFERENCES taxcategory (taxcategory_id);
+
LOCK tax IN EXCLUSIVE MODE;
ALTER TABLE tax ADD COLUMN pass int DEFAULT 0;
UPDATE tax SET pass = 0;