CREATE TABLE `installs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(255) NOT NULL,
`fs_username` varchar(255) DEFAULT NULL,
`mysql_username` varchar(100) DEFAULT NULL,
`data` text NOT NULL,
`created` datetime NOT NULL,
`ftp_username` varchar(255) DEFAULT NULL,
`http_common` text NOT NULL COMMENT 'common config added in customer vhosts',
`http_global` text NOT NULL COMMENT 'added in the global scope, outside of vhosts',
`http_ssl` text NOT NULL COMMENT 'ssl only extra config',
`http_plain` text NOT NULL COMMENT 'http only config, not included in SSL',
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`ftp_hostname` varchar(255) NOT NULL,
`mas_hostname` varchar(255) NOT NULL,
`free` tinyint(1) NOT NULL,
`custom_ssl` tinyint(1) NOT NULL,
`max_items` int(10) unsigned NOT NULL,
`max_categories` int(10) unsigned NOT NULL,
`max_admins` int(10) unsigned NOT NULL,
`clouds` tinyint(3) unsigned NOT NULL DEFAULT '1',
`disk_space` bigint(20) unsigned NOT NULL COMMENT 'KiB',
`bandwidth` bigint(20) unsigned NOT NULL COMMENT 'KiB',
`no_powered_by` tinyint(1) NOT NULL DEFAULT '0',
`active` tinyint(1) NOT NULL DEFAULT '0',
`redirects` text NOT NULL COMMENT 'serialized list of hostname redirects',
`seo_prefix` varchar(50) NOT NULL DEFAULT 'divinity-cart' COMMENT 'override default SEO prefix',
`quota_exceeded` tinyint(1) NOT NULL DEFAULT '0',
`master_install_id` bigint(20) unsigned NOT NULL,
`handler_id` tinyint(3) unsigned NOT NULL,
`shared_code` tinyint(1) NOT NULL DEFAULT '0',
`revision` int(10) NOT NULL DEFAULT '0',
`shared_code_group_id` int(5) DEFAULT NULL,
`add_www` tinyint(1) NOT NULL DEFAULT '1',
`custom_sphinx_queries` mediumtext,
`static_in_memcached` tinyint(1) NOT NULL DEFAULT '0',
`extra_upstreams` text,
`dynamic_ips` tinyint(1) NOT NULL DEFAULT '0',
`custom_rewrites` text,
PRIMARY KEY (`id`),
UNIQUE KEY `fs_username` (`fs_username`),
UNIQUE KEY `mysql_username` (`mysql_username`),
UNIQUE KEY `ftp_username` (`ftp_username`),
KEY `install_fk_handler` (`handler_id`)
) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=latin1