INSERT INTO `site` (`id`, `name`, `template_dir`)
VALUES
	(24, ''Nottingham Greyhounds'', ''nottingham-greyhounds'');


INSERT INTO `url` (`site_id`, `url`, `admin`, `type`)
VALUES
	(24, ''nottingham-greyhounds.local.co.uk'', 0, NULL),
	(24, ''nottingham-greyhounds.arenaracingdev.co.uk'', 0, NULL),
	(24, ''sunderland-greyhounds.co.uk'', 0, NULL),
	(24, ''www.nottingham-greyhounds.co.uk'', 0, NULL),
	(24, ''admin.nottingham-greyhounds.arenaracingdev.co.uk'', 0, NULL),
	(24, ''admin.nottingham-greyhounds.co.uk'', 0, NULL),
	(24, ''admin.nottingham-greyhounds.local.co.uk'', 0, NULL);


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

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

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


INSERT INTO `user` (`name`, `email_address`, `password`)
VALUES
	(''Steve'', ''sheath@arenaracingcompany.co.uk'', NULL),
	(''Kamil'', ''kgraj@arenaracingcompany.co.uk'', NULL),
	(''Lauren'', ''lkeeling@arenaracingcompany.co.uk'', NULL),
	(''Sam Cone'', ''scone@arenaracingcompany.co.uk'', NULL),
	(''Richard Anderson'', ''randerson@arenaracingcompany.co.uk'', NULL),
	(''Martyn Collins'', ''mcollins@arenaracingcompany.co.uk'', NULL);


INSERT INTO `site_user` (`site_id`, `user_id`, `active`, `deleted`)
VALUES
	((SELECT id FROM site), (SELECT id FROM user WHERE email_address=''sheath@arenaracingcompany.co.uk''), ''1'', ''0''),
	((SELECT id FROM site), (SELECT id FROM user WHERE email_address=''kgraj@arenaracingcompany.co.uk''), ''1'', ''0''),
	((SELECT id FROM site), (SELECT id FROM user WHERE email_address=''lkeeling@arenaracingcompany.co.uk''), ''1'', ''0''),
	((SELECT id FROM site), (SELECT id FROM user WHERE email_address=''scone@arenaracingcompany.co.uk''), ''1'', ''0''),
	((SELECT id FROM site), (SELECT id FROM user WHERE email_address=''randerson@arenaracingcompany.co.uk''), ''1'', ''0''),
	((SELECT id FROM site), (SELECT id FROM user WHERE email_address=''mcollins@arenaracingcompany.co.uk''), ''1'', ''0'');



INSERT INTO `rbac_userroles` (`UserID`, `RoleID`, `AssignmentDate`)
VALUES
	((SELECT id FROM user WHERE email_address=''sheath@arenaracingcompany.co.uk''), 1, 1485528819),
	((SELECT id FROM user WHERE email_address=''sheath@arenaracingcompany.co.uk''), 8, 1485528819),
	((SELECT id FROM user WHERE email_address=''kgraj@arenaracingcompany.co.uk''), 1, 1485528819),
	((SELECT id FROM user WHERE email_address=''kgraj@arenaracingcompany.co.uk''), 8, 1485528819),
	((SELECT id FROM user WHERE email_address=''lkeeling@arenaracingcompany.co.uk''), 1, 1485528819),
	((SELECT id FROM user WHERE email_address=''lkeeling@arenaracingcompany.co.uk''), 8, 1485528819),
	((SELECT id FROM user WHERE email_address=''scone@arenaracingcompany.co.uk''), 1, 1485528819),
	((SELECT id FROM user WHERE email_address=''scone@arenaracingcompany.co.uk''), 8, 1485528819),
	((SELECT id FROM user WHERE email_address=''randerson@arenaracingcompany.co.uk''), 1, 1485528819),
	((SELECT id FROM user WHERE email_address=''randerson@arenaracingcompany.co.uk''), 8, 1485528819),
	((SELECT id FROM user WHERE email_address=''mcollins@arenaracingcompany.co.uk''), 1, 1485528819),
	((SELECT id FROM user WHERE email_address=''mcollins@arenaracingcompany.co.uk''), 8, 1485528819);


INSERT INTO `news_article_category` (`site_id`, `title`, `slug`)
VALUES
	((SELECT id FROM site), ''Racing'', ''racing''),
	((SELECT id FROM site), ''Offers'', ''offers''),
	((SELECT id FROM site), ''Events'', ''events''),
	((SELECT id FROM site), ''Local'', ''local'');

INSERT INTO `cache_asset` (`latest_version`, `filename`, `path`, `include_theme`)
VALUES
(1, ''main.js'', ''/javascript'', 0),
(1, ''admin.js'', ''/javascript'', 0),
(1, ''style.css'', ''/css'', 1),
(1, ''arc-image-manager.js'', ''/node_modules/arc-image-manager/dist'', 0),
(1, ''arcmodal.js'', ''/node_modules/arc-modal/dist'', 0),
(1, ''arc-slider.js'', ''/node_modules/arc-slider/dist'', 0),
(1, ''admin.css'', ''/css'', 0),
(1, ''arc-admin-dashboard.js'', ''/node_modules/admin-dashboard/dist'', 0),
(1, ''admin-panel.js'', ''/javascript'', 0);

