diff options
| author | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-19 19:02:53 +0000 |
|---|---|---|
| committer | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-19 19:02:53 +0000 |
| commit | 3cc0d3602de14d8ca90e133a22621acdbb0d5a1d (patch) | |
| tree | ab2c5adf913fc144150981083b57918b4524273b /sql | |
| parent | df3a7353522e3eb9fa4764f0ef653ab83fba2f65 (diff) | |
further cleaning of batch
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1287 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 2590f564..3cbd08a8 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -7,7 +7,7 @@ CREATE TABLE transactions ( CREATE TABLE batch_class ( id serial unique, - batch_type varchar primary key + class varchar primary key ); insert into batch_class (batch_class) values ('ap'); @@ -18,7 +18,7 @@ insert into batch_class (batch_class) values ('gl'); CREATE TABLE batch ( id serial unique, - batch_class_id references batch_class(id) not null, + batch_class_id references class(id) not null, description text, approved_on date default null, approved_by int references employee(entity_id), |