BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS `mycal_categories` (
	`ID`	INTEGER PRIMARY KEY AUTOINCREMENT,
	`name`	VARCHAR ( 48 ) NOT NULL DEFAULT '',
	`symbol`	VARCHAR ( 8 ) NOT NULL DEFAULT '',
	`sequence`	TINYINT NOT NULL DEFAULT 1,
	`repeat`	TINYINT NOT NULL DEFAULT 0,
	`noverlap`	TINYINT NOT NULL DEFAULT 0,
	`olErrMsg`	VARCHAR ( 56 ) NOT NULL DEFAULT '',
	`defSlot`	TINYINT NOT NULL DEFAULT 0,
	`approve`	TINYINT NOT NULL DEFAULT 0,
	`dayColor`	TINYINT NOT NULL DEFAULT 0,
	`color`	VARCHAR ( 8 ) DEFAULT NULL,
	`bgColor`	VARCHAR ( 8 ) DEFAULT NULL,
	`checkBx`	TINYINT NOT NULL DEFAULT 0,
	`checkLb`	VARCHAR ( 16 ) NOT NULL DEFAULT 'approved',
	`checkMk`	VARCHAR ( 8 ) NOT NULL DEFAULT '✓',
	`subName1`	VARCHAR ( 20 ) NOT NULL DEFAULT '',
	`subColor1`	VARCHAR ( 8 ) DEFAULT NULL,
	`subBgrnd1`	VARCHAR ( 8 ) DEFAULT NULL,
	`subName2`	VARCHAR ( 20 ) NOT NULL DEFAULT '',
	`subColor2`	VARCHAR ( 8 ) DEFAULT NULL,
	`subBgrnd2`	VARCHAR ( 8 ) DEFAULT NULL,
	`subName3`	VARCHAR ( 20 ) NOT NULL DEFAULT '',
	`subColor3`	VARCHAR ( 8 ) DEFAULT NULL,
	`subBgrnd3`	VARCHAR ( 8 ) DEFAULT NULL,
	`subName4`	VARCHAR ( 20 ) NOT NULL DEFAULT '',
	`subColor4`	VARCHAR ( 8 ) DEFAULT NULL,
	`subBgrnd4`	VARCHAR ( 8 ) DEFAULT NULL,
	`urlLink`	VARCHAR ( 120 ) NOT NULL DEFAULT '',
	`status`	BOOLEAN NOT NULL DEFAULT 0
);
INSERT INTO `mycal_categories` VALUES (1,'Pit-A - BBQ Pit','',1,0,1,'Booking already exists.Please Contact the Admin',0,0,3,'#3EC91A','',0,'approved','✓','','','','','','','','','','','','','',0);
INSERT INTO `mycal_categories` VALUES (2,'Futsal Court Schedule','',0,0,0,'event overlap; select an other time',0,0,0,'#FA230C','',0,'','✓','','','','','','','','','','','','','',-1);
INSERT INTO `mycal_categories` VALUES (3,'Event','A',0,4,0,'event overlap; select an other time',0,0,0,'#4415D1','',0,'','✓','','','','','','','','','','','','','',-1);
INSERT INTO `mycal_categories` VALUES (4,'Pit-B - BBQ Pit','',2,0,1,'Booking already exists.Please Contact the Admin',0,0,0,'#C740AE','',0,'','✓','','','','','','','','','','','','','',0);
INSERT INTO `mycal_categories` VALUES (5,'Pit-C - BBQ Pit','',3,0,1,'Booking already exists.Please Contact the Admin',0,0,0,'#EB3615','',0,'','✓','','','','','','','','','','','','','',0);
INSERT INTO `mycal_categories` VALUES (6,'Pit-D - BBQ Pit','',4,0,1,'Booking already exists.Please Contact the Admin',0,0,0,'#0FBCBF','',0,'','✓','','','','','','','','','','','','','',0);
INSERT INTO `mycal_categories` VALUES (7,'Pit-E - BBQ Pit','',5,0,1,'Booking already exists.Please Contact the Admin',0,0,0,'#B1BA0D','',0,'','✓','','','','','','','','','','','','','',0);
INSERT INTO `mycal_categories` VALUES (8,'Pit-F - BBQ Pit','',6,0,1,'Booking already exists.Please Contact the Admin',0,0,0,'#076E0C','',0,'','✓','','','','','','','','','','','','','',0);
INSERT INTO `mycal_categories` VALUES (9,'Futsal Court','',7,0,2,'Booking already exists.Please Contact the Admin',0,0,0,'#91193F','',0,'','✓','','','','','','','','','','','','','',0);
INSERT INTO `mycal_categories` VALUES (10,'Event','',8,0,1,'Booking already exists.Please Contact the Admin',0,0,0,'#9280F2','',0,'','✓','','','','','','','','','','','','','',0);
INSERT INTO `mycal_categories` VALUES (11,'Others','',9,0,1,'Booking already exists.Please Contact the Admin',0,0,0,'#1E1F47','',0,'','✓','','','','','','','','','','','','','',0);
COMMIT;