· 8 years ago · Jan 26, 2018, 10:24 AM
1CREATE TABLE IF NOT EXISTS `sopac_lists` (
2 `list_id` int(10) unsigned NOT NULL auto_increment,
3 `uid` int(10) unsigned NOT NULL,
4 `title` varchar(128) default NULL,
5 `description` varchar(256) default NULL,
6 `public` tinyint(3) unsigned NOT NULL,
7 PRIMARY KEY (`list_id`),
8 KEY `uid` (`uid`)
9)