summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorlinuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>2007-06-19 19:02:53 +0000
committerlinuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>2007-06-19 19:02:53 +0000
commit3cc0d3602de14d8ca90e133a22621acdbb0d5a1d (patch)
treeab2c5adf913fc144150981083b57918b4524273b
parentdf3a7353522e3eb9fa4764f0ef653ab83fba2f65 (diff)
further cleaning of batch
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1287 4979c152-3d1c-0410-bac9-87ea11338e46
-rw-r--r--sql/Pg-database.sql4
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),