File: script.sql

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','gringo696@yahoo.com',2,'active',NULL);