Login   Register  
PHP Classes
elePHPant
Icontem

File: adminpro_updatev1.2-v1.3.x.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_updatev1.2-v1.3.x.sql  >  Download  
File: adminpro_updatev1.2-v1.3.x.sql
Role: Auxiliary data
Content type: text/plain
Description: Some SQL patch to update the table from 1.2 (initially published) to 1.3.x
Class: AdminPro class
MySQL/Session based user authentication/management
Author: By
Last change:
Date: 9 years ago
Size: 599 bytes
 

Contents

Class file image Download
# AdminPro Class MySQL Table Update: v1.2 to v1.3.x
#
# The AdminPro Class MySQL Table structure has changed in v1.3.x
# You can update your existing table to be compatible with v!.3.x without changing any existing data.
# Change the values of the SQL statement according to your configuration file
# 'myser':Table name; 'userGroup':User group field name (new in v1.3.x); 'isAdmin':Administrator field name;
# Backup first your AdminPro Class MySQL Table, just for any case...
# Execute the SQL statement:

ALTER TABLE `myuser` ADD `userGroup` INT( 10 ) UNSIGNED DEFAULT 1 AFTER `isAdmin` ;