Created entity to class relationship

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1235 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 7 insertions, 0 deletions

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,