[platal.git] / upgrade / 0.9.17 / 08_google_apps_nicknames.sql

-- This SQL table comes from the 'gapps-daemon' project.

-- Table `gapps_nicknames`
-- Holds the list of all nicknames registered in the Google Apps domain.
CREATE TABLE IF NOT EXISTS `gapps_nicknames` (
  -- Application-specific field.
  l_userid INT DEFAULT NULL,

  -- Shared fields.
  g_account_name VARCHAR(256) NOT NULL,
  g_nickname VARCHAR(256) NOT NULL,
  -- Indexes.
  PRIMARY KEY(g_nickname),
  INDEX g_account_name(g_account_name),
  INDEX l_userid(l_userid)
) CHARSET=utf8;

-- Add new task types.
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;

-- vim:set syntax=mysql:
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: