CodeIgniter 1.7

Chapter appendix: MySQL query to set up the website's database

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 ...