Changeset 513 for trunk/phpbms/install/createtables.sql

Timestamp:

04/23/09 14:06:11 (3 years ago)

Author:

nate

Message:

• Menus now use a uuid field instead of an id type field to determine a menu item's parent menu item.

Files:

• trunk/phpbms/install/createtables.sql (modified) (1 diff)

trunk/phpbms/install/createtables.sql

@@ -29 +29 @@
 CREATE TABLE menu (
   id int(11) NOT NULL auto_increment,
+  `uuid` varchar(64) NOT NULL,
   name varchar(64) NOT NULL default '',
   link varchar(128) NOT NULL default '',
-  parentid int(11) NOT NULL default '0',
+  parentid varchar(64) NOT NULL default '0',
   displayorder int(11) NOT NULL default '0',
   createdby int(11) NOT NULL default '0',