[Summary view] [Print] [Text view]

   1  /*
   2  If you are upgrading version 1.0 or 1.01 to this release of InfoCentral,
   3  you should run this this SQL file to add the usr_Notes column to the user_usr
   4  table. This must be done for the upgraded files to run correctly.
   5  */
   6  
   7  ALTER TABLE user_usr ADD usr_Notes TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER usr_ManageGroups
   8  ALTER TABLE person_per    ADD per_Title varchar(50) default NULL,
   9                                  ADD per_Suffix varchar(50) default NULL,
  10                                  ADD per_WorkEmail varchar(50) default NULL