summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2006-10-17 23:56:43 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2006-10-17 23:56:43 +0000
commit8c2a99452fcaa2c6410dfabee17db7bab4d76f0d (patch)
tree6accee182b18867dabd734909a91f785a2bc3edd
parent4e712f50af7f8348b69acf11b6b9ce6cfb41cde8 (diff)
Added default tax modules to Pg-tables.sql
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@223 4979c152-3d1c-0410-bac9-87ea11338e46
-rwxr-xr-xsql/Pg-tables.sql8
1 files changed, 7 insertions, 1 deletions
diff --git a/sql/Pg-tables.sql b/sql/Pg-tables.sql
index 022b40ed..32dffb9a 100755
--- a/sql/Pg-tables.sql
+++ b/sql/Pg-tables.sql
@@ -254,7 +254,7 @@ CREATE TABLE tax (
taxnumber text,
validto date,
pass integer DEFAULT 0 NOT NULL,
- taxmodule_id int,
+ taxmodule_id int DEFAULT 1 NOT NULL,
FOREIGN KEY (chart_id) REFERENCES chart (id),
FOREIGN KEY (taxmodule_id) REFERENCES taxmodule (taxmodule_id)
);
@@ -706,3 +706,9 @@ table_id INT REFERENCES custom_table_catalog,
field_name TEXT
);
INSERT INTO defaults (version) VALUES ('2.6.18');
+
+INSERT INTO taxmodule (
+ taxmodule_id, taxmodulename
+ ) VALUES (
+ 1, 'Simple'
+);