| 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: |