   is_published BOOLEAN DEFAULT FALSE,	-- Show as active?
   name VARCHAR(255) NOT NULL,		-- Workgroup name
   dirname VARCHAR(255) NOT NULL,	-- Directory name
+  list VARCHAR(255) NOT NULL,		-- Mailing list address
   chair_id INTEGER,			-- Chair of WG
   vicechair_id INTEGER,			-- Vice/co chair of WG
   secretary_id INTEGER,			-- Secretary of WG

--

DROP TABLE IF EXISTS calendar;
CREATE TABLE calendar (
  id INTEGER PRIMARY KEY AUTO_INCREMENT,-- Printer ID
  status INTEGER NOT NULL,		-- 0 = tentative, 1 = confirmed, 2 = canceled
  workgroup_id INTEGER,			-- Workgroup, if any
  date DATETIME NOT NULL,		-- Date of event
  duration INTEGER NOT NULL,		-- Duration of event in minutes
  title VARCHAR(255) NOT NULL,		-- Title/summary of event
  contents TEXT NOT NULL,		-- Text/description of event
  create_date DATETIME NOT NULL,	-- Time/date of creation
  create_id INTEGER NOT NULL,		-- User that submitted the printer
  modify_date DATETIME NOT NULL,	-- Time/date of last change
  modify_id INTEGER NOT NULL,		-- User that made the last change

  INDEX(workgroup_id),
  INDEX(create_id),
  INDEX(modify_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--

  INDEX(create_id),
  INDEX(modify_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO workgroup VALUES(1, 1, 'Internet Printing Protocol (IPP)', 'ipp', 'ipp@pwg.org', 0, 0, 0, '1991-01-01 00:00:00',1,'1991-01-01 00:00:00',1);
INSERT INTO workgroup VALUES(2, 1, 'Semantic Model (SM)', 'sm3', 'sm3@pwg.org', 0, 0, 0, '1991-01-01 00:00:00',1,'1991-01-01 00:00:00',1);
INSERT INTO workgroup VALUES(3, 1, 'Imaging Device Security (IDS)', 'ids', 'ids@pwg.org', 0, 0, 0, '1991-01-01 00:00:00',1,'1991-01-01 00:00:00',1);
INSERT INTO workgroup VALUES(4, 1, 'Cloud Imaging Model', 'cloud', 'cloud@pwg.org', 0, 0, 0, '1991-01-01 00:00:00',1,'1991-01-01 00:00:00',1);
INSERT INTO workgroup VALUES(5, 0, 'Workgroup for Imaging Management Solutions (WIMS)', 'wims', 'wims@pwg.org', 0, 0, 0, '1991-01-01 00:00:00',1,'1991-01-01 00:00:00',1);


--
