From 8c2a99452fcaa2c6410dfabee17db7bab4d76f0d Mon Sep 17 00:00:00 2001 From: einhverfr Date: Tue, 17 Oct 2006 23:56:43 +0000 Subject: 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 --- sql/Pg-tables.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'sql/Pg-tables.sql') 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' +); -- cgit v1.2.3