1 -- Database upgrades (running all SQL commands below the matching "-- version: x" line)
5 CREATE TABLE `support_ranks` (
6 `rank_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
7 `rank_name` VARCHAR( 256 ) NOT NULL ,
8 `rank_access` INT( 4 ) NOT NULL ,
9 `rank_info` VARCHAR( 512 ) NOT NULL ,
10 `rank_order` SMALLINT( 4 ) NOT NULL
13 ALTER TABLE `users` ADD `user_rank` INT( 11 ) NOT NULL AFTER `user_access`;
17 ALTER TABLE `owner_history` CHANGE `owner_history_uid` `owner_history_to_uid` INT( 11 ) NOT NULL;
18 ALTER TABLE `owner_history` ADD `owner_history_from_uid` INT( 11 ) NOT NULL AFTER `owner_history_to_uid`;