2 CREATE TABLE `prefix_dashboard_data` (
\r
3 `ident` int(11) NOT NULL auto_increment,
\r
4 `widget` int(11) NOT NULL,
\r
5 `name` varchar(128) NOT NULL,
\r
6 `value` text NOT NULL,
\r
7 PRIMARY KEY (`ident`),
\r
8 KEY `widget` (`widget`)
\r
11 CREATE TABLE `prefix_dashboard_widgets` (
\r
12 `ident` int(11) NOT NULL auto_increment,
\r
13 `owner` int(11) NOT NULL,
\r
14 `widget_type` varchar(128) NOT NULL,
\r
15 `display_order` int(11) NOT NULL,
\r
16 `access` varchar(128) NOT NULL,
\r
17 PRIMARY KEY (`ident`),
\r
18 KEY `owner` (`owner`,`display_order`,`access`)
\r