## Update user_tbl.
## (If it exists!)
ALTER TABLE `user_tbl` ADD modified_by_user_id smallint(11) default NULL AFTER added_by_user_id;
ALTER TABLE `user_tbl` MODIFY added_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER modified_by_user_id;
ALTER TABLE `user_tbl` ADD modified_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER added_datetime;

## Update admin_tbl.
## NOTE: This first one might need customizing.
ALTER TABLE `admin_tbl` CHANGE priv user_type enum('root','admin','editor') default NULL;

ALTER TABLE `admin_tbl` ADD login_abuse_exempt enum('true') default NULL AFTER user_type;
ALTER TABLE `admin_tbl` ADD blocked enum('true') default NULL AFTER login_abuse_exempt;
ALTER TABLE `admin_tbl` ADD blocked_reason varchar(255) NOT NULL default '' AFTER blocked;
ALTER TABLE `admin_tbl` ADD abuse_warning_level tinyint(4) NOT NULL default '0' AFTER blocked_reason;
ALTER TABLE `admin_tbl` ADD added_by_user_id smallint(11) default NULL AFTER last_login_ip;
ALTER TABLE `admin_tbl` ADD modified_by_user_id smallint(11) default NULL AFTER added_by_user_id;
ALTER TABLE `admin_tbl` MODIFY added_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER modified_by_user_id;
ALTER TABLE `admin_tbl` ADD modified_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER added_datetime;

## Upgrade version_tbl.
ALTER TABLE `version_tbl` ADD version_number SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER version_title;
ALTER TABLE `version_tbl` ADD version_notes VARCHAR(255) NOT NULL DEFAULT '' AFTER version_number;
ALTER TABLE `version_tbl` CHANGE saved_by_admin_id saved_by_user_id smallint(11) default NULL;

## Rename added_by_admin_id -> added_by_user_id in all tables.
## Changing these will require source code modifications.
## This is just an EXAMPLE!
# ALTER TABLE `client_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;