From 3cc0d3602de14d8ca90e133a22621acdbb0d5a1d Mon Sep 17 00:00:00 2001 From: linuxpoet Date: Tue, 19 Jun 2007 19:02:53 +0000 Subject: further cleaning of batch git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1287 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 4 ++-- 1 file 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), -- cgit v1.2.3