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

[..hidden..]

Revision: 1369
          http://svn.sourceforge.net/ledger-smb/?rev=1369&view=rev
Author:   einhverfr
Date:     2007-07-10 11:34:47 -0700 (Tue, 10 Jul 2007)

Log Message:
-----------
Fixing menu_attributes so that it does not roll back the function

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-07-10 18:09:50 UTC (rev 1368)
+++ trunk/sql/Pg-database.sql	2007-07-10 18:34:47 UTC (rev 1369)
@@ -636,7 +636,7 @@
 --
 CREATE TABLE vendor (
   entity_id int references entity(id) not null PRIMARY KEY,
-  entity_class_id int references entity(entity_class) not null check (entity_class_id = 1),
+  entity_class_id int references entity_class(id) not null check (entity_class_id = 1),
   terms int2 default 0,
   taxincluded bool default 'f',
   vendornumber varchar(32),
@@ -2214,7 +2214,6 @@
 135	action	backup	352
 134	media	file	353
 135	media	email	354
-136	menu	1	532
 137	module	am.pl	355
 138	module	am.pl	356
 139	module	am.pl	357
@@ -2228,7 +2227,6 @@
 143	module	am.pl	365
 142	action	add_warehouse	366
 143	action	list_warehouse	367
-144	menu	1	533
 145	module	am.pl	368
 146	module	am.pl	369
 145	action	add_department	370
@@ -2384,6 +2382,8 @@
 193	target	_top	534
 192	menu	1	530
 192	new	1	531
+136	menu	1	535
+144	menu	1	536
 \.
 
 


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