 -- Site Features:
 --
 --   - Users
---   - Blog articles and user-editable content/workgroup pages
---   - Calendar
+-- !!   - Blog articles and user-editable content/workgroup pages
+-- !!   - Calendar
 --   - Issues
 --   - Certified printers
 --   - Pending certifications (submissions)
---   - Comments (attached to pretty much anything)
---   - RSS feed for blog and certified printers
+-- !!   - Comments (attached to pretty much anything)
+-- !!   - RSS feed for blog and certified printers
 --
 
 

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


--

--

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;


--
