PHP Classes

File: adminpro.sql

Recommend this page to a friend!
  Classes of Giorgos  >  AdminPro class  >  adminpro.sql  >  Download  
File: adminpro.sql
Role: Auxiliary data
Content type: text/plain
Description: The SQL Statement for the MySQL Table
Class: AdminPro class
MySQL/Session based user authentication/management
Author: By
Last change: Changed to be compatible with AdminPro version 1.3
Date: 12 years ago
Size: 1,073 bytes


Class file image Download
# AdminPro Class Database Setup
# Version: 1.3
# Author: Giorgos Tsiledakis
#Please check the configuration file to ensure that the variables are the same
# Structure of table `myuser`

CREATE TABLE `myuser` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `userName` char(50) binary default NULL,
  `userPass` char(50) binary default NULL,
  `isAdmin` tinyint(2) NOT NULL default '-1',
  `userGroup` int(10) unsigned default '1',
  `sessionID` char(50) default NULL,
  `lastLog` datetime default NULL,
  `userRemark` char(255) default NULL,
  UNIQUE KEY `userName` (`userName`)
) TYPE=MyISAM COMMENT='Created by the AdminPro Class MySQL Setup ' ;

# Data if md5 encryption is enabled

INSERT INTO `myuser` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, 1, '', '0000-00-00 00:00:00', 'Default Administrator');

# Data if md5 encryption is not enabled

#INSERT INTO `myuser` VALUES (1, 'admin', 'admin', 1, '', '0000-00-00 00:00:00', 'Default Administrator');