Login   Register  
PHP Classes
elePHPant
Icontem

File: adminpro.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 10 years ago
Size: 1,073 bytes
 

Contents

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,
  PRIMARY KEY  (`ID`),
  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');