From fb9196a9ebc6a7fd2384c894053327fc63782886 Mon Sep 17 00:00:00 2001 From: linuxpoet Date: Tue, 22 May 2007 17:11:20 +0000 Subject: Created entity to class relationship git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1235 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 3657ac63..29adb6b8 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -37,6 +37,13 @@ INSERT INTO entity_class (id,class) VALUES (6,'Referral'); SELECT setval('entity_class_id_seq',7); +CREATE TABLE entity_class_to_entity ( + entity_class_id integer not null references entity_class(id), + entity_id integer not null references entity(id) + ); + +COMMENT ON TABLE entity_class_to_entity IS $$ Relation builder for classes to entity $$; + CREATE TABLE country ( id serial PRIMARY KEY, -- cgit v1.2.3