diff options
author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-30 15:01:08 +0000 |
---|---|---|
committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-30 15:01:08 +0000 |
commit | 4410a3d62f37dd01feba6aaaa9a1090248aa0d6a (patch) | |
tree | 6e21de4c258e463f14dbfeb2ab55cf88a09f5a27 /sql/Pg-tables.sql | |
parent | f6f049eb28180b2e51f8dac70ef345ce889c847f (diff) |
Fixed Pg-tables.sql, added scripts to configure replication
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@174 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/Pg-tables.sql')
-rwxr-xr-x | sql/Pg-tables.sql | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/sql/Pg-tables.sql b/sql/Pg-tables.sql index 896dae28..9cd3f939 100755 --- a/sql/Pg-tables.sql +++ b/sql/Pg-tables.sql @@ -24,7 +24,7 @@ CREATE TABLE makemodel ( ); -- CREATE TABLE gl ( - id int DEFAULT nextval ( 'id' ) PRIMAY KEY, + id int DEFAULT nextval ( 'id' ) PRIMARY KEY, reference text, description text, transdate date DEFAULT current_date, @@ -41,8 +41,7 @@ CREATE TABLE chart ( category char(1), link text, gifi_accno text, - contra bool DEFAULT 'f', - PRIMARY KEY (id) + contra bool DEFAULT 'f' ); -- CREATE TABLE gifi ( @@ -261,7 +260,7 @@ CREATE TABLE customertax ( CREATE TABLE vendortax ( vendor_id int, chart_id int, - PRIMARKY KEY (vendor_id, chart_id) + PRIMARY KEY (vendor_id, chart_id) ); -- CREATE TABLE oe ( @@ -424,7 +423,7 @@ CREATE TABLE department ( -- department transaction table CREATE TABLE dpt_trans ( trans_id int PRIMARY KEY, - department_id int, + department_id int ); -- -- business table @@ -454,7 +453,7 @@ CREATE TABLE inventory ( qty numeric, shippingdate date, employee_id int, - entry_id SERIAL PRIMARY KEY, + entry_id SERIAL PRIMARY KEY ); -- CREATE TABLE yearend ( @@ -490,7 +489,7 @@ CREATE TABLE partscustomer ( ); -- CREATE TABLE language ( - code varchar(6) SERIAL PRIMARY KEY, + code varchar(6) PRIMARY KEY, description text ); -- |