· 8 years ago · Jan 05, 2018, 08:44 AM
1CREATE TABLE IF NOT EXISTS `sites` (
2 `id` int(11) NOT NULL auto_increment,
3 `name` varchar(255) NOT NULL,
4 `description` text NOT NULL,
5 `domain_name` varchar(255) NOT NULL,
6 `site_url` varchar(255) NOT NULL,
7 `icon_url` varchar(255) NOT NULL,
8 `state` varchar(255) NOT NULL,
9 `scripts` varchar(255) NOT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=134 ;