diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-07-10 18:34:47 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-07-10 18:34:47 +0000 |
| commit | 8fc414c2b89f2b4b14d889d84f199ac557ade62b (patch) | |
| tree | 81711c990a08e71dbb349b77ad352d33c3223802 /sql | |
| parent | a0bfc3a2b70467d2857be851f017fba10aa1835e (diff) | |
Fixing menu_attributes so that it does not roll back the function
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1369 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 18066e33..9cb6c87f 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -636,7 +636,7 @@ create table shipto ( -- 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 @@ COPY menu_attribute (node_id, attribute, value, id) FROM stdin; 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 @@ COPY menu_attribute (node_id, attribute, value, id) FROM stdin; 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 @@ COPY menu_attribute (node_id, attribute, value, id) FROM stdin; 193 target _top 534 192 menu 1 530 192 new 1 531 +136 menu 1 535 +144 menu 1 536 \. |