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

[..hidden..]

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

Log Message:
-----------
fixed inventory model to force employee

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-27 18:06:47 UTC (rev 1338)
+++ trunk/sql/Pg-database.sql	2007-06-27 21:36:16 UTC (rev 1339)
@@ -715,13 +715,14 @@
 );
 --
 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),
   warehouse_id int,
   parts_id int,
   trans_id int,
   orderitems_id int,
   qty numeric,
   shippingdate date,
-  person_id integer references person(id) not null,
   entry_id SERIAL PRIMARY KEY
 );
 --


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