


# Dump of table article_seo
# ------------------------------------------------------------


CREATE TABLE `article_seo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news_article_id` int(11) NOT NULL,
  `seo_data_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_article_seo_news_article1_idx` (`news_article_id`),
  KEY `fk_article_seo_seo_data2_idx` (`seo_data_id`),
  CONSTRAINT `fk_article_seo_news_article1` FOREIGN KEY (`news_article_id`) REFERENCES `news_article` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_article_seo_seo_data2` FOREIGN KEY (`seo_data_id`) REFERENCES `seo_data` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table content
# ------------------------------------------------------------


CREATE TABLE `content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content_block_id` int(11) NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `published_user_id` int(11) DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `published` datetime DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 - Mark-up\n1 - Block\n',
  `content` text,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 - Archive\n1 - Pending Approval\n2 - Published\n',
  PRIMARY KEY (`id`),
  KEY `fk_content_content_block1_idx` (`content_block_id`),
  KEY `fk_content_user1_idx` (`updated_user_id`),
  KEY `fk_content_user2_idx` (`published_user_id`),
  CONSTRAINT `fk_content_content_block1` FOREIGN KEY (`content_block_id`) REFERENCES `content_block` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_content_user1` FOREIGN KEY (`updated_user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_content_user2` FOREIGN KEY (`published_user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table content_block
# ------------------------------------------------------------


CREATE TABLE `content_block` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_user_id` int(11) NOT NULL,
  `markup_key` varchar(45) NOT NULL,
  `created` datetime DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_markup_key` (`markup_key`),
  KEY `fk_content_block_user1_idx` (`created_user_id`),
  CONSTRAINT `fk_content_block_user1` FOREIGN KEY (`created_user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table content_block_page
# ------------------------------------------------------------


CREATE TABLE `content_block_page` (
  `page_id` int(11) NOT NULL,
  `content_block_id` int(11) NOT NULL,
  `position` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`page_id`,`content_block_id`),
  KEY `fk_content_block_page_content_block1_idx` (`content_block_id`),
  KEY `idx_position` (`position`),
  CONSTRAINT `fk_content_block_page_content_block1` FOREIGN KEY (`content_block_id`) REFERENCES `content_block` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_content_block_page_page1` FOREIGN KEY (`page_id`) REFERENCES `page` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table content_block_setting
# ------------------------------------------------------------


CREATE TABLE `content_block_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `name` varchar(45) NOT NULL,
  `settings` text,
  PRIMARY KEY (`id`),
  KEY `fk_block_setting_site1_idx` (`site_id`),
  CONSTRAINT `fk_block_setting_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table content_update
# ------------------------------------------------------------


CREATE TABLE `content_update` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table event
# ------------------------------------------------------------


CREATE TABLE `event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `event_type_id` int(11) NOT NULL,
  `event_id` varchar(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `page_title` varchar(100) DEFAULT NULL,
  `sub_title` varchar(100) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `description` text,
  `slug` varchar(100) DEFAULT NULL,
  `ticket_url` varchar(500) DEFAULT NULL,
  `event_info_link` varchar(100) DEFAULT NULL,
  `race_day` tinyint(4) NOT NULL DEFAULT '0',
  `featured` tinyint(4) NOT NULL DEFAULT '0',
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `modified` int(11) DEFAULT '0',
  `custom_field_data` text,
  `ems_event` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `fk_event_site1_idx` (`site_id`),
  KEY `idx_slug` (`slug`),
  KEY `fk_event_event_type1_idx` (`event_type_id`),
  KEY `idx_ems_event_id` (`event_id`),
  KEY `idx_modified` (`modified`),
  KEY `idx_featured` (`featured`),
  KEY `idx_active` (`active`),
  KEY `idx_deleted` (`deleted`),
  CONSTRAINT `fk_event_event_type1` FOREIGN KEY (`event_type_id`) REFERENCES `event_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_event_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table event_image
# ------------------------------------------------------------


CREATE TABLE `event_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '0 - Hero\n1 - Thumbnail\n2 - Sponsor',
  PRIMARY KEY (`id`),
  KEY `fk_event_image_image1_idx` (`image_id`),
  KEY `fk_event_image_event1_idx` (`event_id`),
  CONSTRAINT `fk_event_image_event1` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_event_image_image1` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table event_seo
# ------------------------------------------------------------


CREATE TABLE `event_seo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL,
  `seo_data_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_event_seo_event1_idx` (`event_id`),
  KEY `fk_event_seo_seo_data1_idx` (`seo_data_id`),
  CONSTRAINT `fk_event_seo_event1` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_event_seo_seo_data1` FOREIGN KEY (`seo_data_id`) REFERENCES `seo_data` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table event_type
# ------------------------------------------------------------


CREATE TABLE `event_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `custom_field_list` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table facility
# ------------------------------------------------------------


CREATE TABLE `facility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL,
  `wifi` tinyint(1) NOT NULL DEFAULT '0',
  `av_system` tinyint(1) NOT NULL DEFAULT '0',
  `telephone_points` tinyint(1) NOT NULL DEFAULT '0',
  `bar` tinyint(1) NOT NULL DEFAULT '0',
  `walk_in` tinyint(1) NOT NULL DEFAULT '0',
  `pre_book` tinyint(1) NOT NULL DEFAULT '0',
  `notes` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table facility_capacity
# ------------------------------------------------------------


CREATE TABLE `facility_capacity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facility_id` int(11) NOT NULL,
  `facility_layout_id` int(11) NOT NULL,
  `capacity` int(11) NOT NULL DEFAULT '0',
  `projection_type` enum('np','bp','fp') NOT NULL DEFAULT 'np' COMMENT 'np - No Projection\nbp - Back Projection\nfp - Front Projection',
  `notes` text,
  PRIMARY KEY (`id`),
  KEY `fk_facility_capacity_facility1_idx` (`facility_id`),
  KEY `fk_facility_capacity_facility_layout1_idx` (`facility_layout_id`),
  CONSTRAINT `fk_facility_capacity_facility1` FOREIGN KEY (`facility_id`) REFERENCES `facility` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_facility_capacity_facility_layout1` FOREIGN KEY (`facility_layout_id`) REFERENCES `facility_layout` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table facility_category
# ------------------------------------------------------------


CREATE TABLE `facility_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table facility_facility_use
# ------------------------------------------------------------


CREATE TABLE `facility_facility_use` (
  `facility_id` int(11) NOT NULL,
  `facility_use_id` int(11) NOT NULL,
  `facility_category_id` int(11) NOT NULL,
  `notes` text,
  PRIMARY KEY (`facility_id`,`facility_use_id`),
  KEY `fk_facility_facility_use_facility_use1_idx` (`facility_use_id`),
  KEY `fk_facility_facility_use_facility1_idx` (`facility_id`),
  KEY `fk_facility_facility_use_facility_category1_idx` (`facility_category_id`),
  CONSTRAINT `fk_facility_facility_use_facility1` FOREIGN KEY (`facility_id`) REFERENCES `facility` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_facility_facility_use_facility_category1` FOREIGN KEY (`facility_category_id`) REFERENCES `facility_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_facility_facility_use_facility_use1` FOREIGN KEY (`facility_use_id`) REFERENCES `facility_use` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table facility_layout
# ------------------------------------------------------------


CREATE TABLE `facility_layout` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table facility_unique_selling_point
# ------------------------------------------------------------


CREATE TABLE `facility_unique_selling_point` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facility_id` int(11) NOT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  KEY `fk_unique_selling_point_facility1_idx` (`facility_id`),
  CONSTRAINT `fk_unique_selling_point_facility1` FOREIGN KEY (`facility_id`) REFERENCES `facility` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table facility_use
# ------------------------------------------------------------


CREATE TABLE `facility_use` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table file
# ------------------------------------------------------------


CREATE TABLE `file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `uploaded` datetime NOT NULL,
  `original_filename` varchar(200) NOT NULL,
  `extension` varchar(5) NOT NULL,
  `size` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_image_site1_idx` (`site_id`),
  KEY `fk_image_user1_idx` (`user_id`),
  CONSTRAINT `fk_image_site10` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_image_user10` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table image
# ------------------------------------------------------------


CREATE TABLE `image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `parent_image_id` int(11) DEFAULT NULL,
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '0 - Desktop\n1 - Tablet (port)\n2 - Tablet (land)\n3 - Mobile',
  `title` varchar(200) NOT NULL,
  `alt_tag` varchar(125) DEFAULT NULL,
  `uploaded` datetime NOT NULL,
  `original_filename` varchar(200) NOT NULL,
  `thumbnail_filename` varchar(200) NOT NULL,
  `extension` varchar(5) NOT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_image_site1_idx` (`site_id`),
  KEY `fk_image_user1_idx` (`user_id`),
  KEY `idx_parent_image_id` (`parent_image_id`),
  KEY `idx_image_type` (`type`),
  CONSTRAINT `fk_image_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_image_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table news_article
# ------------------------------------------------------------


CREATE TABLE `news_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `site_user_id` int(11) NOT NULL,
  `news_article_category_id` int(11) NOT NULL,
  `image_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `published_date` datetime DEFAULT NULL,
  `title` varchar(80) NOT NULL,
  `slug` varchar(80) NOT NULL,
  `content` mediumtext NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `fk_news_article_news_article_category1_idx` (`news_article_category_id`),
  KEY `fk_news_article_image1_idx` (`image_id`),
  KEY `fk_news_article_site_user1_idx` (`site_user_id`),
  KEY `fk_news_article_site1_idx` (`site_id`),
  FULLTEXT KEY `titlecontent` (`title`,`content`),
  CONSTRAINT `fk_news_article_image1` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_news_article_news_article_category1` FOREIGN KEY (`news_article_category_id`) REFERENCES `news_article_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_news_article_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_news_article_site_user1` FOREIGN KEY (`site_user_id`) REFERENCES `site_user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table news_article_category
# ------------------------------------------------------------


CREATE TABLE `news_article_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `title` varchar(25) NOT NULL,
  `slug` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_news_article_category_site1_idx` (`site_id`),
  KEY `idx_slug` (`slug`),
  CONSTRAINT `fk_news_article_category_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `news_article_category` (`id`, `site_id`, `title`, `slug`)
VALUES
	(1,16,'All Weather Championship','all-weather-championship'),
	(2,16,'Industry News','industry-news'),
	(3,16,'Partners & Sponsors','partners-and-sponsors'),
	(4,16,'Racing','racing');



# Dump of table notification
# ------------------------------------------------------------


CREATE TABLE `notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `message_added` date NOT NULL,
  `message` varchar(255) NOT NULL DEFAULT '',
  `expiry_date` date NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `fk_table1_site1_idx` (`site_id`),
  KEY `fk_notification_user1_idx` (`user_id`),
  CONSTRAINT `fk_notification_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_table1_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table package
# ------------------------------------------------------------


CREATE TABLE `package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL,
  `package_type_id` int(11) NOT NULL,
  `package_id` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text,
  `price` decimal(13,4) NOT NULL,
  `created` int(11) NOT NULL,
  `modified` int(11) NOT NULL,
  `featured` tinyint(4) NOT NULL DEFAULT '0',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `display_order` int(11) DEFAULT NULL,
  `sold_out` tinyint(4) NOT NULL DEFAULT '0',
  `off_sale` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_package_package_type1_idx` (`package_type_id`),
  KEY `fk_package_event1_idx` (`event_id`),
  KEY `idx_package_id` (`package_id`),
  KEY `idx_order` (`display_order`),
  CONSTRAINT `fk_package_event1` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_package_package_type1` FOREIGN KEY (`package_type_id`) REFERENCES `package_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table package_type
# ------------------------------------------------------------


CREATE TABLE `package_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `package_type_id` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_package_type_id` (`package_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table page
# ------------------------------------------------------------


CREATE TABLE `page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `image_id` int(11) DEFAULT '0',
  `title` varchar(50) DEFAULT NULL,
  `name` varchar(200) NOT NULL,
  `description` text,
  `cache` mediumtext,
  `parent_page_id` int(11) NOT NULL DEFAULT '0',
  `previous_page_id` int(11) NOT NULL DEFAULT '0',
  `next_page_id` int(11) NOT NULL DEFAULT '0',
  `sitemap_priority` float NOT NULL DEFAULT '0',
  `sitemap_frequency` varchar(10) NOT NULL COMMENT '''always'', ''hourly'', ''daily'', ''weekly'', ''monthly'', ''yearly'', ''never''',
  `sitemap_lastmod` datetime DEFAULT NULL,
  `menu_order` int(11) NOT NULL DEFAULT '0',
  `include_on_menu` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `idx_page_name` (`name`),
  KEY `fk_page_site1_idx` (`site_id`),
  KEY `idx_parent_page_id` (`parent_page_id`),
  KEY `idx_previous_page_id` (`previous_page_id`),
  KEY `idx_next_page_id` (`next_page_id`),
  KEY `idx_menu_order` (`menu_order`),
  KEY `fk_page_image1_idx` (`image_id`),
  CONSTRAINT `fk_page_image1` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_page_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table page_seo
# ------------------------------------------------------------


CREATE TABLE `page_seo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `seo_data_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_page_seo_page1_idx` (`page_id`),
  KEY `fk_page_seo_seo_data2_idx` (`seo_data_id`),
  CONSTRAINT `fk_page_seo_page1` FOREIGN KEY (`page_id`) REFERENCES `page` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_page_seo_seo_data2` FOREIGN KEY (`seo_data_id`) REFERENCES `seo_data` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table rbac_permissions
# ------------------------------------------------------------


CREATE TABLE `rbac_permissions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Lft` int(11) NOT NULL,
  `Rght` int(11) NOT NULL,
  `Title` char(64) COLLATE utf8_bin NOT NULL,
  `Description` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Title` (`Title`),
  KEY `Lft` (`Lft`),
  KEY `Rght` (`Rght`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


INSERT INTO `rbac_permissions` (`ID`, `Lft`, `Rght`, `Title`, `Description`)
VALUES
	(1,0,9,X'726F6F74',X'726F6F74'),
	(2,1,2,X'6D616E6167655F7573657273',X'43616E206D616E616765207573657273'),
	(3,3,4,X'656469745F636F6E74656E74',X'43616E206564697420636D7320636F6E74656E74'),
	(4,5,6,X'6D616E6167655F6E657773',X'43616E206D616E616765206E6577732073746F72696573'),
	(5,7,8,X'6D616E6167655F62726F616463617374',X'43616E206D616E6167652062726F616463617374206D65737361676573');



# Dump of table rbac_rolepermissions
# ------------------------------------------------------------


CREATE TABLE `rbac_rolepermissions` (
  `RoleID` int(11) NOT NULL,
  `PermissionID` int(11) NOT NULL,
  `AssignmentDate` int(11) NOT NULL,
  PRIMARY KEY (`RoleID`,`PermissionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


INSERT INTO `rbac_rolepermissions` (`RoleID`, `PermissionID`, `AssignmentDate`)
VALUES
	(1,1,1467367657),
	(8,2,1467644172),
	(8,3,1467644172),
	(8,4,1467644172),
	(8,5,1467644172),
	(9,3,1467644172),
	(9,4,1467644172),
	(9,5,1467644172),
	(10,3,1467644172);



# Dump of table rbac_roles
# ------------------------------------------------------------


CREATE TABLE `rbac_roles` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Lft` int(11) NOT NULL,
  `Rght` int(11) NOT NULL,
  `Title` varchar(128) COLLATE utf8_bin NOT NULL,
  `Description` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Title` (`Title`),
  KEY `Lft` (`Lft`),
  KEY `Rght` (`Rght`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


INSERT INTO `rbac_roles` (`ID`, `Lft`, `Rght`, `Title`, `Description`)
VALUES
	(1,0,7,X'726F6F74',X'726F6F74'),
	(8,1,2,X'73797374656D5F61646D696E',X'53797374656D2061646D696E6973747261746F72'),
	(9,3,4,X'736974655F61646D696E',X'536974652061646D696E6973747261746F72'),
	(10,5,6,X'636F6E74656E745F656469746F72',X'436F6E74656E7420656469746F72');



# Dump of table rbac_userroles
# ------------------------------------------------------------


CREATE TABLE `rbac_userroles` (
  `UserID` int(11) NOT NULL,
  `RoleID` int(11) NOT NULL,
  `AssignmentDate` int(11) NOT NULL,
  PRIMARY KEY (`UserID`,`RoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


INSERT INTO `rbac_userroles` (`UserID`, `RoleID`, `AssignmentDate`)
VALUES
	(1,1,1485528819),
	(1,8,1485528819),
	(2,1,1485528819),
	(2,8,1485528819),
	(3,1,1485528819),
	(3,8,1485528819),
	(4,1,1485528819),
	(4,8,1485528819),
	(5,1,1485528819),
	(5,8,1485528819),
	(6,1,1485528819),
	(6,8,1485528819);



# Dump of table schema_version
# ------------------------------------------------------------


CREATE TABLE `schema_version` (
  `installed_rank` int(11) NOT NULL,
  `version` varchar(50) DEFAULT NULL,
  `description` varchar(200) NOT NULL,
  `type` varchar(20) NOT NULL,
  `script` varchar(1000) NOT NULL,
  `checksum` int(11) DEFAULT NULL,
  `installed_by` varchar(100) NOT NULL,
  `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `execution_time` int(11) NOT NULL,
  `success` tinyint(1) NOT NULL,
  PRIMARY KEY (`installed_rank`),
  KEY `schema_version_s_idx` (`success`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Dump of table seo_data
# ------------------------------------------------------------


CREATE TABLE `seo_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(200) DEFAULT NULL,
  `cannonical_tag` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table site
# ------------------------------------------------------------


CREATE TABLE `site` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `template_dir` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `site` (`id`, `name`, `template_dir`)
VALUES
	(16,'All Weather Championships','awchampionships-racecourse');



# Dump of table site_global
# ------------------------------------------------------------


CREATE TABLE `site_global` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `label` varchar(20) NOT NULL,
  `json` tinyint(4) NOT NULL DEFAULT '0',
  `data` text,
  PRIMARY KEY (`id`),
  KEY `fk_site_global_site1_idx` (`site_id`),
  KEY `idx_label` (`label`),
  CONSTRAINT `fk_site_global_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `site_global` (`id`, `site_id`, `label`, `json`, `data`)
VALUES
	(1,16,'dress_code',0,'Dress Code details'),
	(2,16,'site_details',1,'{\n  \"blocktitle\": \"Contact Details\",\n  \"name\": \"All Weather Championships\",\n  \"address\": {\n    \"street\": \"3rd Floor, Millbank Tower\",\n    \"locality\": \"21-24 Millbank\",\n    \"region\": \"London\",\n    \"postcode\": \"SW1P 4QP\",\n    \"telephone\": \"0207 802 5120\",\n    \"fax\": \"0207 821 5225\",\n    \"email\": \"info@arenaracingcompany.co.uk\"\n  },\n  \"opening_times\": {\n    \"times\": \"9am - 5pm\",\n    \"days\": \"(Monday - Friday)\",\n    \"note\": \"If you leave a message out of office hours, your call will be returned as soon as possible.\"\n  },\n  \"contact_points_left\": {\n    \"point1\": {\n      \"label\": \"General Enquiries\",\n      \"display\": \"0207 802 5120\",\n      \"contact\": \"+442078025120\",\n      \"email\": \"info@arenaracingcompany.co.uk\"\n    }\n\n  },\n  \"contact_points_right\": {\n\n  },\n  \"email_addresses\": {\n    \"enquiries\": \"info@arenaracingcompany.co.uk\",\n    \"events\": \"info@arenaracingcompany.co.uk\",\n    \"weddings\": \"info@arenaracingcompany.co.uk\"\n  },\n  \"items\": [\n   \n  ],\n  \"map\": {\n    \"api\": \"-0.1648024655878544%2C51.47516410854787%2C-0.08716860786080362%2C51.50896500935509\",\n    \"latLon\": \"51.492067691626204%2C-0.125985536724329\",\n    \"markerTitle\": \"All Weather Championships\"\n  },\n  \"header_menu\": { \"template\": \"dark\" },\n  \"footer_type\": { \"template\": \"page-footer-arc\" }\n}'),
	(3,16,'social_icons',1,'{\n  \"icons\": [\n    {\n      \"url\": \"https://www.facebook.com/arenaracingcompany2015/\",\n      \"filename\": \"facebook\",\n      \"title\": \"Facebook\"\n    },\n    {\n      \"url\": \"https://twitter.com/arenaracingco\",\n      \"filename\": \"twitter\",\n      \"title\": \"Twitter\"\n    },\n    {\n      \"url\": \"https://www.linkedin.com/company/arena-leisure-plc\",\n      \"filename\": \"linkedin\",\n      \"title\": \"LinkedIn\"\n    }\n  ]\n}'),
	(4,16,'sponsors',1,'{\n  \"sponsors\": [\n    {\n      \"url\": \"http://www.attheraces.com/\",\n      \"filename\": \"AttheRaces.png\",\n     \"type\": \"partner\"\n    },\n    {\n      \"url\": \"https://betway.com/\",\n      \"filename\": \"BetWay.png\",\n      \"type\": \"sponsor\"\n    }\n  ]\n}'),
	(5,16,'footer_industry_icon',1,'{\n  \"icons\": [\n    {\n      \"url\": \"https://www.rewards4racing.com/?utm_source=partner&utm_medium=arc\",\n      \"filename\": \"Rewards4Racing-Sponsorship.png\",\n      \"title\": \"Rewards4Racing\"\n    },\n    {\n      \"url\": \"http://www.attheraces.com/\",\n      \"filename\": \"atr.png\",\n      \"title\": \"At The Races\"\n    },\n    {\n      \"url\": \"https://www.theracingpartnership.com\",\n      \"filename\": \"trp.png\",\n      \"title\": \"The Racing Partnership\"\n    },\n    {\n      \"url\": \"http://ebfstallions.com/\",\n      \"filename\": \"ebf.png\",\n      \"title\": \"European Breeders Fund\"\n    }\n    \n  ]\n}'),
	(6,16,'eventmaster_forms',1,'\n{\n  \"settings\": {\n  	\"database_id\": \"arenaracingcompany_c\"\n  },\n  \"contact\": {\n    \"assigned_user\": \"10cc8617-daf1-ae19-69c4-578df1a18c97\",\n    \"assigned_campaign\": \"76e0ea00-3c8e-42b1-4211-57348fd32455\"\n  },\n  \"newsletter\": {\n    \"assigned_user\": \"623ad052-fe18-8081-daba-50631e2c178a\",\n    \"assigned_campaign\": \"76d3626b-e9f5-c534-a4cd-51caac80be7b\"\n  }\n}'),
	(13,16,'add_this_id',2,'{\n  \"add_this\": {\n    \"id\": \"5b4f59c01e698c86\",\n    \"class\": \"addthis_inline_share_toolbox\"\n  }\n}\n'),
	(14,16,'raceday_info',0,'<p>Children under 18 go free when accompanied by an adult (*Some exceptions apply). ID may be required.</p>\n<p>No refund shall be given in respect of any unused part of any badge or other entitlement. <a href=\"/terms-and-conditions/\">Click here</a> for our full terms and conditions.</p>'),
	(15,16,'main_menu',1,'{\n  \"template\": {\n    \"name\": \"dark\",\n    \"whatson\": false\n  },\n  \"evergreenPages\": [\n    {\n      \"heading\": \"Group Highlights\",\n      \"items\": [\n        {\n          \"title\": \"All-Weather Championships\",\n          \"slug\": \"/racing-highlights/all-weather-championships/\"\n        },\n        {\n          \"title\": \"The Silk Series\",\n          \"slug\": \"/racing-highlights/the-silk-series/\"\n        },\n        {\n          \"title\": \"St Leger Festival\",\n          \"slug\": \"/racing-highlights/st-leger-festival/\"\n        },\n        {\n          \"title\": \"The Derby Trials\",\n          \"slug\": \"/racing-highlights/the-derby-trial/\"\n        },\n        {\n          \"title\": \"Churchill Stakes\",\n          \"slug\": \"/racing-highlights/churchill-stakes/\"\n        }\n      ]\n    },\n    {\n      \"heading\": \"Popular Events\",\n      \"items\": [\n        {\n          \"title\": \"Family Fun Days\",\n          \"slug\": \"/popular-events/family-fun-days/\"\n        },\n        {\n          \"title\": \"Ladies Day\",\n          \"slug\": \"/popular-events/ladies-day/\"\n        },\n        {\n          \"title\": \"Oktoberfest\",\n          \"slug\": \"/popular-events/oktoberfest/\"\n        },\n        {\n          \"title\": \"Live Music\",\n          \"slug\": \"/popular-events/live-music/\"\n        },\n        {\n          \"title\": \"Christmas Parties\",\n          \"slug\": \"/popular-events/christmas-parties/\"\n        }\n      ]\n    }\n  ],\n  \"megaMenuDriver\": {\n    \"image\": \"generic-thumbnail.jpg\",\n    \"image_alt\": \"Alt Tag for the Mega Menu Driver\",\n    \"title\": \"Hire Our Venue\",\n    \"subtitle\": \"Find out about all the options at our racecourse. There is something for everyone.\",\n    \"slug\": \"/hire-our-venue/\"\n  },\n  \"menus\" : [\n    {\n      \"title\": \"About Us\",\n      \"menu\": \"about-us\",\n      \"url\": \"/about-us/\"\n    },\n    {\n      \"title\": \"Partners & Sponsorship\",\n      \"menu\": \"partners-and-sponsors\",\n      \"columns\": [\n        {\n          \"title\":{\n            \"text\":\"Partners & Sponsorship\",\n            \"slug\":\"/partners-and-sponsors/\"\n          },\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Partners\",\n              \"slug\": \"/partners-and-sponsors/partners/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Sponsorship\",\n              \"slug\": \"/partners-and-sponsors/sponsorship/\"\n            }\n\n          ]\n        },\n        {\n          \"items\": [\n\n          ]\n        },\n        {\n          \"items\": [\n          ]\n        }\n\n      ]\n    },\n    {\n      \"title\": \"Careers\",\n      \"menu\": \"careers\",\n      \"url\": \"/careers/\"\n    },\n    {\n      \"title\": \"Racing\",\n      \"menu\": \"racing\",\n      \"columns\": [\n        {\n          \"title\":{\n            \"text\":\"Racing\",\n            \"slug\":\"/racing/\"\n          },\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Horse Racing\",\n              \"slug\": \"/racing/horse-racing/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"All Weather Championships\",\n              \"slug\": \"/racing/horse-racing/all-weather-championships/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"The Silk Series\",\n              \"slug\": \"/racing/horse-racing/the-silk-series/\"\n            }\n\n\n          ]\n        },\n        {\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Our Racecourses\",\n              \"slug\": \"/racing/horse-racing/our-racecourses/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Owners & Trainers Facilities\",\n              \"slug\": \"/racing/horse-racing/owners-and-trainers-facilities/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Annual Membership\",\n              \"slug\": \"/racing/horse-racing/annual-membership/\"\n            }\n\n          ]\n        },\n        {\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Greyhound Racing\",\n              \"slug\": \"/racing/greyhound-racing/\"\n            }\n\n          ]\n        },\n        {\n          \"items\": [\n          ]\n        }\n\n      ]\n    },\n\n    {\n      \"title\": \"Music & Entertainment\",\n      \"menu\": \"music-and-entertainment\",\n      \"columns\": [\n        {\n          \"title\":{\n            \"text\":\"Music & Entertainment\",\n            \"slug\":\"/music-and-entertainment/\"\n          },\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Live Music & Entertainment\",\n              \"slug\": \"/music-and-entertainment/live-music/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Events & Activities\",\n              \"slug\": \"/music-and-entertainment/events-and-activities/\"\n            }\n\n          ]\n        },\n        {\n          \"items\": [\n\n          ]\n        },\n        {\n          \"items\": [\n\n          ]\n        }\n\n      ]\n    },\n\n    {\n      \"title\": \"YourVENUE\",\n      \"menu\": \"your-venue\",\n      \"columns\": [\n        {\n          \"title\":{\n            \"text\":\"YourVENUE\",\n            \"slug\":\"/your-venue/\"\n          },\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Our Unique Venues\",\n              \"slug\": \"/your-venue/our-unique-venues/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Meeting Room Hire\",\n              \"slug\": \"/your-venue/meeting-room-hire/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Conferences & Event Venue Hire\",\n              \"slug\": \"/your-venue/conferences-and-event-venue-hire/\"\n            }\n\n\n          ]\n        },\n        {\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Wedding Venues\",\n              \"slug\": \"/your-venue/wedding-venues/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Party Venue Hire\",\n              \"slug\": \"/your-venue/party-venue-hire/\"\n            }\n\n          ]\n        },\n        {\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Christmas Party Venues\",\n              \"slug\": \"/your-venue/christmas-party-venues/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Large Scale Venue Hire\",\n              \"slug\": \"/your-venue/large-scale-venue-hire/\"\n            }\n\n\n          ]\n        }\n\n      ]\n    },\n\n    {\n      \"title\": \"Media Centre\",\n      \"menu\": \"media-centre\",\n      \"columns\": [\n        {\n          \"title\":{\n            \"text\":\"Media Centre\",\n            \"slug\":\"/media-centre/\"\n          },\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"News Articles\",\n              \"slug\": \"/media-centre/news/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Policies\",\n              \"slug\": \"/media-centre/policies/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Modern Slavery\",\n              \"slug\": \"/media-centre/policies/modern-slavery/\"\n            }\n\n\n          ]\n        },\n        {\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Accessibility\",\n              \"slug\": \"/media-centre/policies/accessibility/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Venue Etiquette\",\n              \"slug\": \"/media-centre/policies/venue-etiquette/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Equine Welfare\",\n              \"slug\": \"/media-centre/policies/equine-welfare/\"\n            }\n\n          ]\n        },\n        {\n          \"items\": [\n            {\n              \"type\": \"parent\",\n              \"title\": \"Resources\",\n              \"slug\": \"/media-centre/resources/\"\n            },\n            {\n              \"type\": \"parent\",\n              \"title\": \"Beginners Guide to Racing\",\n              \"slug\": \"/media-centre/resources/beginners-guide-to-racing/\"\n            }\n          ]\n        }\n\n      ]\n    },\n    {\n      \"title\": \"Contact Us\",\n      \"menu\": \"contact-us\",\n      \"url\": \"/contact-us/\"\n    }\n  ]\n}'),
	(16,16,'items_per_page',1,'{\n	\"news\": {\n		\"desktop\":\n		{\n			\"landing\":9,\n			\"search\":2\n		},\n		\"mobile\":\n		{\n			\"landing\":8,\n			\"search\":4\n		}\n	}\n}');



# Dump of table site_user
# ------------------------------------------------------------


CREATE TABLE `site_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_site_user_site1_idx` (`site_id`),
  KEY `fk_site_user_user1_idx` (`user_id`),
  KEY `idx_active` (`active`),
  KEY `idx_deleted` (`deleted`),
  CONSTRAINT `fk_site_user_site1` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_site_user_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table url
# ------------------------------------------------------------


CREATE TABLE `url` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Does this URL gain access to the admin tools?',
  `type` enum('local','development','production') DEFAULT NULL COMMENT 'Type of host.',
  PRIMARY KEY (`id`),
  KEY `fk_url_site_idx` (`site_id`),
  KEY `idx_url` (`url`),
  CONSTRAINT `fk_url_site` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `url` (`id`, `site_id`, `url`, `admin`, `type`)
VALUES
	(8,16,'awchampionships.local.co.uk',0,NULL),
	(9,16,'admin.awchampionships.local.co.uk',0,NULL),
	(10,16,'awchampionships.arenaracingdev.co.uk',0,NULL),
	(11,16,'admin.awchampionships.arenaracingdev.co.uk',0,NULL),
	(12,16,'www.awchampionships.co.uk',0,NULL),
	(13,16,'admin.awchampionships.co.uk',0,NULL),
	(14,16,'awchampionships.co.uk',0,NULL);



# Dump of table user
# ------------------------------------------------------------


CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `email_address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_email_address` (`email_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `user` (`id`, `name`, `email_address`)
VALUES
	(1,'Steve','sheath@arenaracingcompany.co.uk'),
	(2,'Kamil','kgraj@arenaracingcompany.co.uk'),
	(3,'David Gath','dgath@arenaracingcompany.co.uk'),
	(4,'richard harris','rharris@arenaracingcompany.co.uk'),
	(5,'Lauren Keeling','lkeeling@arenaracingcompany.co.uk'),
	(6,'Earl Hamilton','ehamilton@arenaracingcompany.co.uk');




