Commit | Line | Data |
---|---|---|
0fada8c8 SJ |
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: |