 --
 
 DROP TABLE IF EXISTS page;
-CREATE TABLE page (
-  id INTEGER PRIMARY KEY AUTO_INCREMENT,-- ID
-  is_published BOOLEAN DEFAULT FALSE,	-- FALSE/0 = private, TRUE/1 = public
-  workgroup_id INTEGER,			-- Workgroup, if any
-  type INTEGER,				-- 0 = long-term content, 1 = blog article
-  title VARCHAR(255) NOT NULL,		-- Title of page
-  contents TEXT NOT NULL,		-- Contents of page
-  filename VARCHAR(255) UNIQUE NOT NULL,-- Filename link
-  altname VARCHAR(255) NOT NULL,	-- Alternate filename, if any
-  create_date DATETIME NOT NULL,	-- Time/date of creation
-  create_id INTEGER NOT NULL,		-- User that created the article
-  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(type),
-  INDEX(filename),
-  INDEX(altname),
-  INDEX(create_id),
-  INDEX(modify_id)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+-- CREATE TABLE page (
+--  id INTEGER PRIMARY KEY AUTO_INCREMENT,-- ID
+--  is_published BOOLEAN DEFAULT FALSE,	-- FALSE/0 = private, TRUE/1 = public
+--  workgroup_id INTEGER,			-- Workgroup, if any
+--  type INTEGER,				-- 0 = long-term content, 1 = blog article
+--  title VARCHAR(255) NOT NULL,		-- Title of page
+--  contents TEXT NOT NULL,		-- Contents of page
+--  filename VARCHAR(255) UNIQUE NOT NULL,-- Filename link
+--  altname VARCHAR(255) NOT NULL,	-- Alternate filename, if any
+--  create_date DATETIME NOT NULL,	-- Time/date of creation
+--  create_id INTEGER NOT NULL,		-- User that created the article
+--  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(type),
+--  INDEX(filename),
+--  INDEX(altname),
+--  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', '1991-01-01 00:00:00',1,'1991-01-01 00:00:00',1);
INSERT INTO workgroup VALUES(2, 1, 'Semantic Model (SM)', 'sm3', '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', '1991-01-01 00:00:00',1,'1991-01-01 00:00:00',1);
INSERT INTO workgroup VALUES(4, 1, 'Cloud Imaging Model', 'cloud', '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', '1991-01-01 00:00:00',1,'1991-01-01 00: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;


--
