upgrade/0.9.17/08_google_apps_nicknames.sql

   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: