Login   Register  
PHP Classes
elePHPant
Icontem

File: script.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Andrei  >  SMK User Authentication  >  script.sql  >  Download  
File: script.sql
Role: Auxiliary data
Content type: text/plain
Description: Table creation script
Class: SMK User Authentication
Authenticate users with MySQL database records
Author: By
Last change:
Date: 8 years ago
Size: 871 bytes
 

Contents

Class file image Download
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);