 --
 
 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;
+-- 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 user VALUES(1, 2, 'michael.r.sweet@gmail.com','Michael Sweet','$6$b1963065bac3a508$uli/BFat3xp8FNEQ6ZGmvCW3KVMseVkabOFHLMIRAFjNVXmJa.z36LX.pYJPqty4aczuD1hxtLP6AM.O8L2.61',TRUE,999999,'America/Toronto',50,'','','','','','','1969-11-20 12:00:00',1,'1969-11-20 12:00:00',1);


--

  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);


--
