Commit | Line | Data |
---|---|---|
65d7c623 VZ |
1 | -- This SQL table comes from the 'gapps-daemon' project. |
2 | ||
3 | -- Table `gapps_nicknames` | |
4 | -- Holds the list of all nicknames registered in the Google Apps domain. | |
5 | CREATE TABLE IF NOT EXISTS `gapps_nicknames` ( | |
6 | -- Application-specific field. | |
7 | l_userid INT DEFAULT NULL, | |
8 | ||
9 | -- Shared fields. | |
10 | g_account_name VARCHAR(256) NOT NULL, | |
11 | g_nickname VARCHAR(256) NOT NULL, | |
12 | -- Indexes. | |
13 | PRIMARY KEY(g_nickname), | |
14 | INDEX g_account_name(g_account_name), | |
15 | INDEX l_userid(l_userid) | |
16 | ) CHARSET=utf8; | |
17 | ||
18 | -- Add new task types. | |
19 | ALTER TABLE gapps_queue MODIFY j_type ENUM('n_create', 'n_delete', 'n_resync', 'r_activity', 'r_accounts', 'u_create', 'u_delete', 'u_update', 'u_sync') NOT NULL; | |
20 | ||
21 | -- vim:set syntax=mysql: |