diff options
| author | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-27 21:42:17 +0000 |
|---|---|---|
| committer | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-27 21:42:17 +0000 |
| commit | 7b16e40635a2b34c0134722cc62ac658a5e4d3ad (patch) | |
| tree | 593edc075622ccce431150f86951694be05e9c16 /sql | |
| parent | 8b765c8b48c06f42a1c6eead2bd6f58f776a3d72 (diff) | |
changed inventory to track employee table, instead of entity table
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1340 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index bc9244a2..b28c41e7 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -715,8 +715,7 @@ CREATE TABLE warehouse ( ); -- 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, |