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: 19 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, 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');