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

[..hidden..]

Revision: 1235
          http://svn.sourceforge.net/ledger-smb/?rev=1235&view=rev
Author:   linuxpoet
Date:     2007-05-22 10:11:20 -0700 (Tue, 22 May 2007)

Log Message:
-----------
Created entity to class relationship

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-05-22 17:01:33 UTC (rev 1234)
+++ trunk/sql/Pg-database.sql	2007-05-22 17:11:20 UTC (rev 1235)
@@ -37,7 +37,14 @@
 
 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,
   name text check (name ~ '[[:alnum:]_]') NOT NULL,


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