| 1 | ALTER TABLE account_auth_openid DROP KEY user_id_url_index; |
| 2 | ALTER TABLE account_auth_openid ADD UNIQUE KEY user_id_url_index (uid, url(60)); |
| 3 | |
| 4 | DROP TABLE IF EXISTS tmp_gapps_nicknames; |
| 5 | CREATE TEMPORARY TABLE tmp_gapps_nicknames LIKE gapps_nicknames; |
| 6 | INSERT INTO tmp_gapps_nicknames SELECT * FROM gapps_nicknames; |
| 7 | DROP TABLE gapps_nicknames; |
| 8 | CREATE TABLE gapps_nicknames ( |
| 9 | l_userid INT(11) UNSIGNED DEFAULT NULL, |
| 10 | g_account_name VARCHAR(256) NOT NULL, |
| 11 | g_nickname VARCHAR(256) NOT NULL, |
| 12 | PRIMARY KEY (g_nickname(60)), |
| 13 | KEY g_account_name (g_account_name(60)), |
| 14 | KEY l_userid (l_userid) |
| 15 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 16 | INSERT INTO gapps_nicknames SELECT * FROM tmp_gapps_nicknames; |
| 17 | DROP TABLE IF EXISTS tmp_gapps_nicknames; |
| 18 | |
| 19 | DROP TABLE IF EXISTS tmp_gapps_accounts; |
| 20 | CREATE TEMPORARY TABLE tmp_gapps_accounts LIKE gapps_accounts; |
| 21 | INSERT INTO tmp_gapps_accounts SELECT * FROM gapps_accounts; |
| 22 | DROP TABLE gapps_accounts; |
| 23 | CREATE TABLE gapps_accounts ( |
| 24 | l_userid INT(11) UNSIGNED DEFAULT NULL, |
| 25 | l_sync_password TINYINT(1) DEFAULT 1, |
| 26 | l_activate_mail_redirection TINYINT(1) DEFAULT 1, |
| 27 | g_account_id CHAR(16) DEFAULT NULL, |
| 28 | g_account_name VARCHAR(256) NOT NULL, |
| 29 | g_first_name VARCHAR(40) NOT NULL, |
| 30 | g_last_name VARCHAR(40) NOT NULL, |
| 31 | g_status ENUM('unprovisioned','disabled','active') DEFAULT 'unprovisioned', |
| 32 | g_admin TINYINT(1) DEFAULT NULL, |
| 33 | g_suspension VARCHAR(256) DEFAULT NULL, |
| 34 | r_disk_usage BIGINT(20) DEFAULT NULL, |
| 35 | r_creation DATE DEFAULT NULL, |
| 36 | r_last_login DATE DEFAULT NULL, |
| 37 | r_last_webmail DATE DEFAULT NULL, |
| 38 | PRIMARY KEY (g_account_name(60)), |
| 39 | KEY l_userid (l_userid) |
| 40 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 41 | INSERT INTO gapps_accounts SELECT * FROM tmp_gapps_accounts; |
| 42 | DROP TABLE IF EXISTS tmp_gapps_accounts; |
| 43 | |
| 44 | -- vim:set syntax=mysql: |