-- 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

