diff options
| -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), |