892wKWec

1# Dump of table ci_sessions
2# ------------------------------------------------------------
3
4DROP TABLE IF EXISTS `ci_sessions`;
5
6CREATE TABLE `ci_sessions` (
7  `session_id` varchar(40) NOT NULL DEFAULT '0',
8  `ip_address` varchar(16) NOT NULL DEFAULT '0',
9  `user_agent` varchar(50) NOT NULL,
10  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
11  `user_data` text NOT NULL,
12  PRIMARY KEY (`session_id`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8;
14
15
16
17# Dump of table blog_user
18# ------------------------------------------------------------
19
20DROP TABLE IF EXISTS `blog_user`;
21
22CREATE TABLE `cms_user` (
23  `USER_ID` int(11) NOT NULL AUTO_INCREMENT,
24  `USERNAME` varchar(100) NOT NULL,
25  `PASSWORD` varchar(100) NOT NULL,
26  `EMAIL_ADDR` varchar(100) NOT NULL,
27  `IS_ACTIVE` tinyint(4) NOT NULL,
28  `ROLE` int(11) NOT NULL,
29  PRIMARY KEY (`USER_ID`)
30) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;