modules/navigation/navigation.mysql


CREATE TABLE menu (
  mid int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  description text NULL default '',
  weight tinyint(4) NOT NULL default '0',
  roles varchar(255) NULL default '',
  vocabularies varchar(255) NULL default '',
  PRIMARY KEY (mid),
  KEY (name)
) TYPE=MyISAM;


CREATE TABLE menu_item (
  iid int(10) unsigned NOT NULL auto_increment,
  mid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  description text NULL default '',
  url varchar(255) NOT NULL default '',
  weight tinyint(4) NOT NULL default '0',
  enable int(1) unsigned NOT NULL default '0',
  roles varchar(255) NULL default '',
  terms varchar(255) NULL default '',
  PRIMARY KEY (iid),
  KEY (mid)
) TYPE=MyISAM;

CREATE TABLE menu_hierarchy (
  iid int(10) unsigned NOT NULL default '0',
  parent int(10) unsigned NOT NULL default '0',
  KEY iid (iid),
  KEY parent (parent)
) TYPE=MyISAM;
1
2	CREATE TABLE menu (
3	mid int(10) unsigned NOT NULL auto_increment,
4	name varchar(255) NOT NULL default '',
5	description text NULL default '',
6	weight tinyint(4) NOT NULL default '0',
7	roles varchar(255) NULL default '',
8	vocabularies varchar(255) NULL default '',
9	PRIMARY KEY (mid),
10	KEY (name)
11	) TYPE=MyISAM;
12
13
14	CREATE TABLE menu_item (
15	iid int(10) unsigned NOT NULL auto_increment,
16	mid int(10) unsigned NOT NULL default '0',
17	name varchar(255) NOT NULL default '',
18	description text NULL default '',
19	url varchar(255) NOT NULL default '',
20	weight tinyint(4) NOT NULL default '0',
21	enable int(1) unsigned NOT NULL default '0',
22	roles varchar(255) NULL default '',
23	terms varchar(255) NULL default '',
24	PRIMARY KEY (iid),
25	KEY (mid)
26	) TYPE=MyISAM;
27
28	CREATE TABLE menu_hierarchy (
29	iid int(10) unsigned NOT NULL default '0',
30	parent int(10) unsigned NOT NULL default '0',
31	KEY iid (iid),
32	KEY parent (parent)
33	) TYPE=MyISAM;