|
Revision 1070, 0.7 kB
(checked in by ben, 2 years ago)
|
Database handling changes for the widget system.
|
| Line | |
|---|
| 1 |
CREATE TABLE `prefix_widget_data` ( |
|---|
| 2 |
`ident` int(11) NOT NULL auto_increment, |
|---|
| 3 |
`widget` int(11) NOT NULL, |
|---|
| 4 |
`name` varchar(128) NOT NULL, |
|---|
| 5 |
`value` text NOT NULL, |
|---|
| 6 |
PRIMARY KEY (`ident`), |
|---|
| 7 |
KEY `widget` (`widget`) |
|---|
| 8 |
) ; |
|---|
| 9 |
|
|---|
| 10 |
CREATE TABLE `prefix_widgets` ( |
|---|
| 11 |
`ident` int(11) NOT NULL auto_increment, |
|---|
| 12 |
`owner` int(11) NOT NULL, |
|---|
| 13 |
`type` varchar(128) NOT NULL, |
|---|
| 14 |
`location` varchar(128) NOT NULL, |
|---|
| 15 |
`location_id` int(11) NOT NULL, |
|---|
| 16 |
`wcolumn` int(11) NOT NULL, |
|---|
| 17 |
`display_order` int(11) NOT NULL, |
|---|
| 18 |
`access` varchar(128) NOT NULL, |
|---|
| 19 |
PRIMARY KEY (`ident`), |
|---|
| 20 |
KEY `owner` (`owner`,`display_order`,`access`), |
|---|
| 21 |
KEY `location_id` (`location_id`) |
|---|
| 22 |
) ; |
|---|
