f9K6hBm1

1-- assembled updates
2ALTER TABLE version_db_auth CHANGE COLUMN 2016_09_04_00 2016_11_18_00 bit;
3
4--
5-- Do not remove this file when we archive sql under this folder
6-- it is needed for pending sql importer
7--
8-- DB update 2016_09_04_00 -> 2016_11_19_00
9DROP PROCEDURE IF EXISTS `updateDb`;
10DELIMITER //
11CREATE PROCEDURE updateDb ()
12proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE';
13START TRANSACTION;
14ALTER TABLE version_db_auth CHANGE COLUMN 2016_09_04_00 2016_11_19_00 bit;
15SELECT sql_rev INTO OK FROM version_db_auth WHERE sql_rev = '1478975214169487000'; IF OK <> 'FALSE' THEN LEAVE proc; END IF;
16--
17-- START UPDATING QUERIES
18--
19INSERT INTO version_db_auth (`sql_rev`) VALUES ('1478975214169487000');
20
21ALTER TABLE `account`
22    ADD `token_key` VARCHAR(100) NOT NULL DEFAULT '' AFTER `s`,
23    ADD `reg_mail` VARCHAR(255) NOT NULL DEFAULT '' AFTER `email`,
24    ADD `last_attempt_ip` VARCHAR(15) NOT NULL DEFAULT '127.0.0.1' AFTER `last_ip`,
25    ADD `lock_country` VARCHAR(2) NOT NULL DEFAULT '00' AFTER `locked`;
26--
27-- END UPDATING QUERIES
28--
29COMMIT;
30END;
31//
32DELIMITER ;
33CALL updateDb();
34DROP PROCEDURE IF EXISTS `updateDb`;