DROP TABLE IF EXISTS `session`;
CREATE TABLE `session` (
`id` int(11) NOT NULL auto_increment,
`session` varchar(50) default NULL,
`userid` int(11) default NULL,
`sess_start` datetime default NULL,
`sess_expire` datetime default NULL,
`last_activity` datetime default NULL,
`ip` varchar(20) default NULL,
`user_agent` varchar(200) default NULL,
PRIMARY KEY (`id`)
) ;
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(200) default NULL,
`password` varchar(250) default NULL,
`email` varchar(250) default NULL,
`vip` tinyint(3) default NULL,
`status` enum('banned','pending','active') default 'pending',
`auth_code` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ;
INSERT INTO `user` VALUES (1,'Testman','t',' [email protected]',2,'active',NULL);
|
Download
