1 CREATE TABLE `prefix_widget_data` (
\r
2 `ident` int(11) NOT NULL auto_increment,
\r
3 `widget` int(11) NOT NULL,
\r
4 `name` varchar(128) NOT NULL,
\r
5 `value` text NOT NULL,
\r
6 PRIMARY KEY (`ident`),
\r
7 KEY `widget` (`widget`)
\r
10 CREATE TABLE `prefix_widgets` (
\r
11 `ident` int(11) NOT NULL auto_increment,
\r
12 `owner` int(11) NOT NULL,
\r
13 `type` varchar(128) NOT NULL,
\r
14 `location` varchar(128) NOT NULL,
\r
15 `location_id` int(11) NOT NULL,
\r
16 `wcolumn` int(11) NOT NULL,
\r
17 `display_order` int(11) NOT NULL,
\r
18 `access` varchar(128) NOT NULL,
\r
19 PRIMARY KEY (`ident`),
\r
20 KEY `owner` (`owner`,`display_order`,`access`),
\r
21 KEY `location_id` (`location_id`)
\r