PHP Classes

File: adminpro_updatev1.2-v1.3.x.sql

Recommend this page to a friend!
  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: 17 years ago
Size: 599 bytes


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` ;
For more information send a message to info at phpclasses dot org.