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

[..hidden..]

Revision: 1340
          http://svn.sourceforge.net/ledger-smb/?rev=1340&view=rev
Author:   linuxpoet
Date:     2007-06-27 14:42:17 -0700 (Wed, 27 Jun 2007)

Log Message:
-----------
changed inventory to track employee table, instead of entity table

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-27 21:36:16 UTC (rev 1339)
+++ trunk/sql/Pg-database.sql	2007-06-27 21:42:17 UTC (rev 1340)
@@ -715,8 +715,7 @@
 );
 --
 CREATE TABLE inventory (
-  entity_id integer references entity(id) not null PRIMARY KEY,
-  entity_class_id integer references entity_class(id) not null check (entity_class_id = 3),
+  entity_id integer references employee(entity_id) not null,
   warehouse_id int,
   parts_id int,
   trans_id int,


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