SF.net SVN: ledger-smb: [1287] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1287
          http://svn.sourceforge.net/ledger-smb/?rev=1287&view=rev
Author:   linuxpoet
Date:     2007-06-19 12:02:53 -0700 (Tue, 19 Jun 2007)

Log Message:
-----------
further cleaning of batch

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-19 18:58:40 UTC (rev 1286)
+++ trunk/sql/Pg-database.sql	2007-06-19 19:02:53 UTC (rev 1287)
@@ -7,7 +7,7 @@
 
 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 @@
 
 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),


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.