ci mysql query to set up database of a website

websites

DROP TABLE IF EXISTS `ci_sessions`;
CREATE TABLE IF NOT EXISTS `ci_sessions` (
`session_id` varchar(40) NOT NULL default '0',
`peopleid` int(11) NOT NULL,
`ip_address` varchar(16) NOT NULL default '0',
`user_agent` varchar(50) NOT NULL,
`last_activity` int(10) unsigned NOT NULL default '0',
`left` int(11) NOT NULL,
`name` varchar(25) NOT NULL,
`status` tinyint(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `domains`;
CREATE TABLE IF NOT EXISTS `domains` (
`id` int(10) NOT NULL auto_increment,
`url` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
`registrar` varchar(100) NOT NULL,
`dateregd` int(11) NOT NULL default '0',
`cost` float NOT NULL default '0',
`regdfor` int(11) NOT NULL default '0',
`notes` blob NOT NULL,
`pw` varchar(25) NOT NULL,
`un` varchar(25) NOT NULL,
`lastupdate` int(11) NOT NULL default '0',
`submit` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
DROP TABLE IF EXISTS `events`;
CREATE TABLE IF NOT EXISTS `events` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default 'not set',
`type` enum('test','alert','report') NOT NULL,
`testid` int(10) NOT NULL,
`siteid` int(10) NOT NULL,
`userid` int(10) NOT NULL,
`reported` int(11) NOT NULL,
`result` blob NOT NULL,
`time` int(11) NOT NULL,
`timetaken` float NOT NULL,
`isalert` varchar(2) NOT NULL,
`emailid` int(11) NOT NULL,
`submit` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;
DROP TABLE IF EXISTS `frequencies`;
CREATE TABLE IF NOT EXISTS `frequencies` (
`id` int(10) NOT NULL,
`name` varchar(16) NOT NULL,
`submit` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `hosts`;
CREATE TABLE IF NOT EXISTS `hosts` (
`id` int(11) NOT NULL auto_increment,
`cost` float NOT NULL,
`name` varchar(100) NOT NULL,
`hosturl` varchar(100) NOT NULL,
`un` varchar(50) NOT NULL,
`pw` varchar(50) NOT NULL,
`ns1url` varchar(36) NOT NULL,
`ns1ip` varchar(36) NOT NULL,
`ns2url` varchar(36) NOT NULL,
`ns2ip` varchar(36) NOT NULL,
`ftpurl` varchar(100) NOT NULL,
`ftpserverip` varchar(36) NOT NULL,
`ftpun` varchar(50) NOT NULL,
`ftppw` varchar(50) NOT NULL,
`cpurl` varchar(36) NOT NULL,
`cpun` varchar(36) NOT NULL,
`cppw` varchar(36) NOT NULL,
`pop3server` varchar(36) NOT NULL,
`servicetel` varchar(50) NOT NULL,
`servicetel2` varchar(50) NOT NULL,
`serviceemail` varchar(100) NOT NULL,
`webroot` varchar(48) NOT NULL,
`absoluteroot` varchar(48) NOT NULL,
`cgiroot` varchar(48) NOT NULL,
`booked` int(11) NOT NULL,
`duration` int(11) NOT NULL,
`lastupdate` int(11) NOT NULL default '0',
`submit` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
DROP TABLE IF EXISTS `people`;
CREATE TABLE IF NOT EXISTS `people` (
`id` int(11) NOT NULL auto_increment,
`uname` varchar(25) NOT NULL,
`pw` varchar(25) NOT NULL,
`status` smallint(3) NOT NULL default '1',
`name` varchar(50) NOT NULL,
`firstname` varchar(50) NOT NULL,
`surname` varchar(50) NOT NULL,
`email` varchar(120) NOT NULL,
`lastupdate` int(11) NOT NULL default '0',
`submit` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
DROP TABLE IF EXISTS `sites`;
CREATE TABLE IF NOT EXISTS `sites` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`url` varchar(100) NOT NULL,
`un` varchar(50) NOT NULL,
`pw` varchar(50) NOT NULL,
`client1` int(10) NOT NULL default '0',
`client2` int(10) NOT NULL default '0',
`admin1` int(10) NOT NULL default '0',
`admin2` int(10) NOT NULL default '0',
`domainid` int(10) NOT NULL default '0',
`hostid` int(10) NOT NULL default '0',
`webroot` varchar(50) NOT NULL,
`files` text NOT NULL,
`filesdate` int(11) NOT NULL default '0',
`lastupdate` int(11) NOT NULL default '0',
`submit` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
DROP TABLE IF EXISTS `tests`;
CREATE TABLE IF NOT EXISTS `tests` (
`id` int(11) NOT NULL auto_increment,
`siteid` int(11) NOT NULL default '0',
`name` varchar(250) NOT NULL,
`type` varchar(25) NOT NULL,
`url` varchar(120) NOT NULL,
`regex` varchar(250) NOT NULL,
`p1` varchar(250) NOT NULL,
`p2` varchar(250) NOT NULL,
`p3` varchar(250) NOT NULL,
`p4` varchar(250) NOT NULL,
`p5` varchar(250) NOT NULL,
`p6` varchar(250) NOT NULL,
`frequency` int(10) NOT NULL default '0',
`lastdone` int(10) NOT NULL default '0',
`isalert` varchar(2) NOT NULL,
`setup` int(10) NOT NULL default '0',
`lastupdate` int(10) NOT NULL default '0',
`notes` varchar(250) NOT NULL,
`submit` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
DROP TABLE IF EXISTS `types`;
CREATE TABLE IF NOT EXISTS `types` (
`id` varchar(7) NOT NULL,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;