· 6 years ago · Jun 28, 2019, 10:34 PM
1CREATE TABLE IF NOT EXISTS `homes_stickers` (
2 `id` int(11) NOT NULL,
3 `userid` int(11) NOT NULL,
4 `x` varchar(6) NOT NULL DEFAULT '1' COMMENT 'left',
5 `y` varchar(6) NOT NULL DEFAULT '1' COMMENT 'top',
6 `z` varchar(6) NOT NULL DEFAULT '1' COMMENT 'boder:',
7 `data` text NOT NULL,
8 `type` varchar(1) NOT NULL DEFAULT '1',
9 `subtype` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Widget Type (if widget)',
10 `skin` text NOT NULL,
11 `groupid` int(11) NOT NULL DEFAULT '-1',
12 `var` int(100) DEFAULT NULL
13) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;