-- Database upgrades (running all SQL commands below the matching "-- version: x" line) -- version: 1 CREATE TABLE `support_ranks` ( `rank_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `rank_name` VARCHAR( 256 ) NOT NULL , `rank_access` INT( 4 ) NOT NULL , `rank_info` VARCHAR( 512 ) NOT NULL , `rank_order` SMALLINT( 4 ) NOT NULL ) ENGINE = MYISAM ; ALTER TABLE `users` ADD `user_rank` INT( 11 ) NOT NULL AFTER `user_access`; -- version: 2 ALTER TABLE `owner_history` CHANGE `owner_history_uid` `owner_history_to_uid` INT( 11 ) NOT NULL; ALTER TABLE `owner_history` ADD `owner_history_from_uid` INT( 11 ) NOT NULL AFTER `owner_history_to_uid`; -- version: 3