DEBUG MYSQL data type

--
-- 資料表格式： `ci_sessions`
--

CREATE TABLE `ci_sessions` (
`session_id` varchar(40) character set utf8 collate utf8_unicode_ci NOT
NULL default '0',
`ip_address` varchar(45) character set utf8 collate utf8_unicode_ci NOT
NULL default '0',
`user_agent` varchar(120) character set utf8 collate utf8_unicode_ci NOT
NULL,
`last_activity` int(10) NOT NULL,
`user_data` text character set utf8 collate utf8_unicode_ci NOT NULL,
PRIMARY KEY  (`session_id`),
KEY `last_activity_idx` (`last_activity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 資料表格式： `session_logs`
--

CREATE TABLE `session_logs` (
`SESSION_ID` varchar(40) character set utf8 collate utf8_unicode_ci NOT
NULL,
`IP_ADDRESS` varchar(45) character set utf8 collate utf8_unicode_ci NOT
NULL,
`USER_AGENT` varchar(120) NOT NULL,
`ADDTIME` int(10) default NULL,
`UPDATETIME` int(10) default NULL,
`IS_ALIVE` tinyint(4) NOT NULL default '0',
PRIMARY KEY  (`SESSION_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 資料表格式： `user`
--

CREATE TABLE `user` (
`uid` int(10) NOT NULL auto_increment,
`username` varchar(20) NOT NULL,
`salt` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`email` varchar(255) NOT NULL,
`login_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`auth_type` tinyint(4) NOT NULL,
`addr` varchar(255) NOT NULL,
PRIMARY KEY  (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;