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

[..hidden..]

Revision: 3265
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3265&view=rev
Author:   einhverfr
Date:     2011-06-16 23:02:31 +0000 (Thu, 16 Jun 2011)

Log Message:
-----------
Correcting Pg-database load issues

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-06-16 13:46:39 UTC (rev 3264)
+++ trunk/sql/Pg-database.sql	2011-06-16 23:02:31 UTC (rev 3265)
@@ -2711,17 +2711,13 @@
     role_name character varying,
     acl_type character varying,
     node_id integer,
-    CONSTRAINT menu_acl_acl_type_check CHECK ((((acl_type)::text = 'allow'::text) OR ((acl_type)::text = 'deny'::text)))
+    CONSTRAINT menu_acl_acl_type_check CHECK ((((acl_type)::text = 'allow'::text) OR ((acl_type)::text = 'deny'::text))),
     PRIMARY KEY (node_id, role_name)
 );
 
 
 
 ALTER TABLE ONLY menu_acl
-    ADD CONSTRAINT menu_acl_pkey PRIMARY KEY (id);
-
-
-ALTER TABLE ONLY menu_acl
     ADD CONSTRAINT menu_acl_node_id_fkey FOREIGN KEY (node_id) REFERENCES menu_node(id);
 
 


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