INSERT INTO `adfcontent` (`id`, `objecttype`, `objectid`, `adf_id`, `content`, `language`) VALUES
(1, 'page', 1, 1, '[{"bannerimage":"57","bannertitle":"Helping you tell your story","bannertext":"<p>Using banners, you can tell a story or get your message across to your visitors in a visually engaging way.<\\/p>","bannerlink":"page-4"},{"bannerimage":"55","bannertitle":"Directing your visitors","bannertext":"<p>Using high quality images, you can signpost your customers to the content that you want them to lead them towards.<\\/p>","bannerlink":"page-5"},{"bannerimage":"56","bannertitle":"Open up your personality","bannertext":"<p>A website should be a reflection of your business or organisation. Shout about who you are.<\\/p>","bannerlink":"page-2"}]', 'en');

INSERT INTO `content` (`id`, `objecttype`, `objectid`, `contentcontainer_id`, `content`, `language`, `editable`, `status`) VALUES
(4, 'page', 5, 2, '', 'en', 1, 1),
(5, 'page', 5, 1, '', 'en', 1, 1),
(9, 'post', 8, 1, '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 'en', 1, 1),
(15, 'page', 8, 2, '', 'en', 1, 1),
(39, 'page', 1, 1, '<h1>SeeCMS - take control of your site</h1>\n<p>SeeCMS lets you add text to your website with ease, ensuring that your brand and style are being honoured at all times. Add headings, sub headings, main content, all in an intuitive way - making website maintenance a pleasure, not a chore.</p>\n<p>Whether you''re a techie or a technophobe, SeeCMS arms you with the tools to add wording that tells your customers and clients who you are, what you do and why visitors should engage with you.</p>\n<p>Your website should work hard for you - bringing in leads, giving useful calls to action and engaging your existing customers.</p>\n<p>&nbsp;Take control of your site with SeeCMS.</p>', 'en', 1, 1),
(42, 'page', 2, 4, '<h1>Get into your site</h1>\n<p>So you''ve got a website, it looks great and has lots of features. Now you need to get across who you are, what you do, and why people should use you. Use your content wisely and you can get across all of your messages.</p>', 'en', 1, 1),
(43, 'page', 2, 2, '<p>Don''t just call your page ''about us'' - give it a bit of thought. Can you use something more creative, or more pertinent to your business? How about ''getting to know us'' or ''meet the organisation of your dreams''. It''s your site, and you''re in control.</p>\n<p>Sure, use professionals to help you formulate just the right messages if words aren''t you thing. After all, there''s lots to consider - how much text to write, what do you want to get across, what will appeal to your visitors.</p>\n<p>And of course there''s Search Engine Optimisation (SEO) to think about. How do you get those magic keywords across the content without writing something that''s not only hard to read, but obviously written mainly to boost rankings.</p>\n<p>Content is key, or so they say. And to that end, your text should be high-quality, well-written and appealing to visitors. That will show by the length of time people spend on your site and whether they share your content socially - all markers of a good website in the eys of Google (other search engines are available, of course).</p>', 'en', 1, 1),
(44, 'page', 6, 1, '<h1>Add layers to your site (but not too many...)</h1>', 'en', 1, 1),
(45, 'page', 6, 2, '<p>Secondary navigation, and even tertiary navigation, can add layers of information to your website. Hit the visitor with some overarching information on the homepage as a catch all, and then allow your customers to delve as deep as they want to into your site.</p>\n<p>You can add to the levels of complexity the further people journey around your site. But don''t overdo it - content hidden away is less likely to be found, and won''t provide for a great user experience, and you could be missing getting some key information across.</p>\n<p>Three clicks to every piece of information is pretty good practice, but if your site has thousans of pages, that might not be so easy. Make sure to spread your information out, and always consider your site''s architecture.</p>', 'en', 1, 1),
(47, 'page', 6, 4, '<h1>Delving deeper</h1>\n<p>Adding further content to your website is simple. Information can get more complex and you can put your point across in more detail. Use your inner pages wisely to build up your content.</p>', 'en', 1, 1),
(48, 'page', 7, 4, '<h1>Finding out more</h1>\n<p>Websites can easily grow as you do. It''s simple to add pages to your website packed with useful content as your company or organisation develops. </p>', 'en', 1, 1),
(50, 'page', 7, 1, '<h1>Your website can grow as you do</h1>', 'en', 1, 1),
(51, 'page', 7, 2, '<p>When you first go live with a new site, it should be well-organised, feature all of your best photos, your latest projects,and be generally, well, up-to-date.</p>\n<p>But as you carry on doing what you do and the weeks become motnhs become years, your website should be reflecting your progress.</p>\n<p>Whether you expand in size, provide more services or win more clients, there''s potentially more information to add to the website, and whilst it''s easy to add all of your new exciting content, it''s also easy for it to get a bit unweildy.</p>\n<p>Your website needs love, care and attention - and that will please the search engines too, so make sure to give your website a spring clean from time to time, won''t you?</p>', 'en', 1, 1),
(52, 'page', 4, 4, '<h1>News</h1>\n<p>You''ve won an award, you''ve held a brilliant event, you''ve secured a new contract. Share your news with your visitors and you can big yourself up, all in the name of being sociable. Add pictures to your news stories and you''re opening up your organisation, giving it a face. You show yourself as a business worth engaging with, a service great to use.</p>\n<p>But whatever you do, keep your news up to date. If your latest item is pictures from the charity gala circa 2011 then you''re clients will think either a) you don''t care about your site or b) you''ve had a very quiet few years. And no, they won''t think you must be doing so well that you''re too busy to update the website.</p>', 'en', 1, 1),
(53, 'page', 5, 4, '<h1>Events</h1>\n<p>All kinds of businesses and organisations have an events calendar - schools parents evenings, theatre shows, training sessions, conferences, dinners - the list is pretty endless.</p>\n<p>Whether people are able to see the event and can just drop by or they are able to book a place and even pay online, an events calendar shows just how much you''ve got going on, just for your lovely audience.</p>', 'en', 1, 1),
(56, 'page', 3, 4, '<h1>Contact</h1>\n<p>If someone has found your website and taken the time to have a little poke around, it needs to be simple for them to go a step further. A lot of the time this call to action is simply to get in touch.</p>\n<p>It could be picking up the phone, or it could be sending a message via a form - whatever the method, this is where people can engage with you for real. You might want to include a map of your location, directions - or an open invite to drop in for a cup of tea.</p>', 'en', 1, 1),
(57, 'page', 3, 2, '<h2>Fancy a cuppa? Pop in and see us!</h2>', 'en', 1, 1),
(58, 'page', 3, 1, '<h2>Or send us a message...</h2>', 'en', 1, 1),
(60, 'post', 4, 3, '<p><img class="seecmsimagedefault" src="/images/uploads/img-5-44.jpg" alt="" /></p>', 'en', 1, 1),
(63, 'post', 3, 1, '<p>SeeCMS was ten years in the making and launched to the world at Venturefest, Yorkshire''s leading science, technology and innovation event.</p>\n<p>Releasing the CMS as an open source product for the first time, we listened to our customers to make sure that we are providing services with them in mind.</p>\n<p>Our content management system is the backbone of hundreds of websites across Yorkshire, the UK and indeed further afield, internationally.</p>\n<p>The move to release SeeCMS as an open source product has come from our passion for providing the best possible service to our clients.</p>\n<p>Director Anne Taylor said: "As a digital agency, we''re always keen to keep ahead of the game, and we''re confident that SeeCMS provides our clients with all of the tools needed to take full control of their websites in an intuitive and informative way."</p>\n', 'en', 1, 1),
(64, 'post', 3, 4, '<h1>SeeCMS launches at Venturefest</h1>\n<p>York-based web company See Green launced SeeCMS, an intuitive and innovative content management system, at Venturefest 2015, which took place at York Racecourse on March 12th.</p>', 'en', 1, 1),
(65, 'post', 4, 1, '<p>A news article should be interesting and have a point. It needs to cover some important questions: who, why, what, where and when.</p>\n<p>Who is the article about, why is this newsworthy, what were the subjects doing, where did, or will, the news happen and when.</p>\n<p>From there on in, try to keep in engaging - not too long and not too short. Just right, as Goldilocks would say. Don''t forget to use pictures, link to further information and giving people the chance to comment or share is great.</p>', 'en', 1, 1),
(66, 'post', 4, 4, '<h1>Here''s the catchy headline again</h1>\n<p>When you write a news article, don''t forget who your audiences are. Make sure that your news really IS news.</p>', 'en', 1, 1),
(67, 'page', 2, 1, '<h2>Create captivating headings</h2>', 'en', 1, 1),
(69, 'page', 10, 4, '<h1>Gallery</h1>\n<p>A photo says a thousand words, or so the old addage goes. If top-notch images will help your cause, get them on your site - either within the content, or in the form of a gallery or galleries.</p>\n<p>Thanks to <a href="https://stocksnap.io">stocksnap.io</a> for the copyright free stock photos.</p>', 'en', 1, 1),
(70, 'post', 5, 4, '<h1>Event name here</h1>\n<p>Perhpas with a few more event details</p>', 'en', 1, 1),
(71, 'post', 5, 3, '<p><img class="seecmsimagedefault" src="/images/uploads/img-6-53.jpg" alt="" /></p>', 'en', 1, 0),
(72, 'post', 7, 4, '<h1>Event name</h1>\n<p>An nice little intro to this event</p>', 'en', 1, 1),
(73, 'post', 7, 1, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec faucibus leo sit amet augue ornare, ac condimentum felis iaculis. Sed tincidunt venenatis volutpat. Phasellus et finibus risus. Vestibulum suscipit blandit risus, vel rutrum metus bibendum pellentesque. Quisque sed hendrerit lectus. Proin vel mi ut lacus vestibulum faucibus. Mauris aliquet leo at justo rhoncus, vel tempus magna efficitur. Sed sed ultricies nulla. Phasellus at purus erat. Mauris vel dolor tellus. Donec non nibh rhoncus, gravida dolor ut, placerat felis. Integer posuere blandit eros sit amet dapibus. Fusce vehicula felis vitae blandit congue. Cras sit amet enim mattis, lobortis purus nec, porta metus. Vestibulum id augue lorem. Ut sit amet sem ut nulla accumsan aliquam eu imperdiet lectus.</p>\n<p>Maecenas vulputate tortor libero, sed volutpat metus vulputate ac. Nam egestas tempus justo, et pulvinar nibh euismod eu. Donec condimentum neque non dui aliquet tincidunt. Nulla placerat cursus lacinia. Duis dignissim tristique massa sit amet commodo. Suspendisse potenti. Nulla ultrices nulla id turpis dictum iaculis.</p>', 'en', 1, 1),
(74, 'post', 7, 3, '<p><img class="seecmsimagedefault" src="/images/uploads/img-5-46.jpg" alt="" /></p>', 'en', 1, 1),
(75, 'post', 6, 4, '<h1>Event</h1>\n<p>Call us now to book on this <span data-dobid="hdw">fictitious</span> event</p>', 'en', 1, 1),
(76, 'post', 6, 1, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec faucibus leo sit amet augue ornare, ac condimentum felis iaculis. Sed tincidunt venenatis volutpat. Phasellus et finibus risus. Vestibulum suscipit blandit risus, vel rutrum metus bibendum pellentesque. Quisque sed hendrerit lectus. Proin vel mi ut lacus vestibulum faucibus. Mauris aliquet leo at justo rhoncus, vel tempus magna efficitur. Sed sed ultricies nulla. Phasellus at purus erat. Mauris vel dolor tellus. Donec non nibh rhoncus, gravida dolor ut, placerat felis. Integer posuere blandit eros sit amet dapibus. Fusce vehicula felis vitae blandit congue. Cras sit amet enim mattis, lobortis purus nec, porta metus. Vestibulum id augue lorem. Ut sit amet sem ut nulla accumsan aliquam eu imperdiet lectus.</p>\n<p>Maecenas vulputate tortor libero, sed volutpat metus vulputate ac. Nam egestas tempus justo, et pulvinar nibh euismod eu. Donec condimentum neque non dui aliquet tincidunt. Nulla placerat cursus lacinia. Duis dignissim tristique massa sit amet commodo. Suspendisse potenti. Nulla ultrices nulla id turpis dictum iaculis.</p>', 'en', 1, 1),
(77, 'post', 6, 3, '<p><img class="seecmsimagedefault" src="/images/uploads/img-5-44.jpg" alt="" /></p>', 'en', 1, 1),
(78, 'page', 8, 4, '<h1>Members only please</h1>\n<p>Here you can allow access just to selected users. If you''d like to give it a try you can create yourself an account in the CMS.</p>', 'en', 1, 1),
(79, 'page', 8, 1, '<p><strong>If you''re not already a member you might need to call us to get access.</strong></p>\n<p>There are options to allow users to register themselves, just not in this demo. Check out the SeeCMS documentation to find out how.</p>', 'en', 1, 1),
(80, 'post', 3, 3, '<p><img class="seecmsimagedefault" src="/images/uploads/img-5-47.jpg" alt="" /></p>', 'en', 1, 1);

INSERT INTO `contentappend` (`id`, `objecttype`, `objectid`, `contentcontainer_id`, `content`, `language`, `position`) VALUES
(1, 'page', 3, 2, '<map>', 'en', 2),
(2, 'page', 10, 2, '<gallery>', 'en', 2),
(3, 'page', 4, 2, '<newsfeedmain>', 'en', 2),
(4, 'page', 4, 3, '<newsarchive>', 'en', 2),
(5, 'page', 5, 3, '<eventsarchive>', 'en', 2),
(6, 'page', 5, 2, '<eventsfeed>', 'en', 2),
(7, 'page', 3, 1, '<contactform>', 'en', 2),
(8, 'page', 8, 2, '<loginform>', 'en', 2);

INSERT INTO `media` (`id`, `name`, `alt`, `isfolder`, `parentid`, `status`, `description`, `type`) VALUES
(57, 'D506D6123F', 'D506D6123F', 0, 0, 1, 'D506D6123F', 'jpg'),
(55, '7E71222234', '7E71222234', 0, 0, 1, '7E71222234', 'jpg'),
(56, 'F5CE4RRRRY', 'F5CE4RRRRY', 0, 0, 1, 'F5CE4RRRRY', 'jpg'),
(54, '887B49FEB7', '887B49FEB7', 0, 0, 1, '887B49FEB7', 'jpg'),
(53, '19ZH8U96AV', '19ZH8U96AV', 0, 0, 1, '19ZH8U96AV', 'jpg'),
(51, 'IKDNT0YH2N', 'IKDNT0YH2N', 0, 41, 1, 'IKDNT0YH2N', 'jpg'),
(50, 'Gallery pic 2', 'N9UX2T8204', 0, 41, 1, 'N9UX2T8204', 'jpg'),
(49, 'Gallery pic 3', 'X5WYN8NHRB', 0, 41, 1, 'X5WYN8NHRB', 'jpg'),
(48, 'QW87IF70MJ', 'QW87IF70MJ', 0, 41, 1, 'QW87IF70MJ', 'jpg'),
(47, 'LV2IUQNTZ5', 'LV2IUQNTZ5', 0, 41, 1, 'LV2IUQNTZ5', 'jpg'),
(46, 'Z0O9ZE93PC', 'Z0O9ZE93PC', 0, 41, 1, 'Z0O9ZE93PC', 'jpg'),
(45, 'Gallery pic 1', 'DT6O6PRI7K', 0, 41, 1, 'DT6O6PRI7K', 'jpg'),
(44, 'Here''s a lovely cat', 'Here''s a lovely cat', 0, 41, 1, '60T5RG5V64', 'jpg'),
(43, 'I0G8CG9708', 'I0G8CG9708', 0, 41, 1, 'I0G8CG9708', 'jpg'),
(42, 'VHVDUJHKXJ', 'VHVDUJHKXJ', 0, 41, 1, 'VHVDUJHKXJ', 'jpg'),
(41, 'Gallery', '', 1, 0, 1, '', '');

INSERT INTO `page` (`id`, `title`, `template`, `status`, `parentid`, `pageorder`, `deleted`, `commencement`, `expiry`, `lastupdated`, `visibility`, `htmltitle`, `metadescription`, `metakeywords`, `redirect`, `ascendants`) VALUES
(2, 'About', 'Default', 1, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, NULL, NULL, NULL, NULL, '0'),
(3, 'Contact', '50 50', 1, 0, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '0'),
(4, 'News', 'Default', 1, 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, NULL, NULL, NULL, NULL, '0'),
(5, 'Events', 'Default', 1, 0, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, NULL, NULL, NULL, NULL, '0'),
(6, 'Delving deeper', 'Default', 1, 2, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '0,2'),
(7, 'Finding out more', 'Default', 1, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '0,2'),
(8, 'Login', '50 50', 1, 0, 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, '', '', '', '', '0'),
(9, 'Members', 'Default', 1, 0, 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, '', '', '', '', '0'),
(10, 'Gallery', 'Single', 1, 0, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', '', '0');

INSERT INTO `post` (`id`, `title`, `template`, `date`, `status`, `parentid`, `postorder`, `deleted`, `commencement`, `expiry`, `lastupdated`, `visibility`, `htmltitle`, `metadescription`, `metakeywords`, `redirect`, `standfirst`, `isfolder`, `tags`, `media_id`, `posttype_id`, `eventstart`, `eventend`) VALUES
(1, 'News', 'Default', '2015-02-17', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', NULL, NULL, NULL, NULL, 1, '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'Events', 'Default', '2015-02-17', 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', NULL, NULL, NULL, NULL, 1, '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'SeeCMS launches at Venturefest', 'Default', '2015-01-31', 1, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', NULL, 'It''s been ten years in the making, and now SeeCMS, an innovative and intuitive content management system, has been unleashed to the world at Venturefest Yorkshire for the first time as open source.', 0, '', 47, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'Here''s a catchy headline', 'Default', '2015-02-16', 1, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', NULL, 'And here''s some extra text to describe what the news story is about. Keep it concise!', 0, '', 44, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'Event 3', 'Default', '2015-02-26', 1, 2, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', NULL, 'This is an example event description.', 0, '', 51, 2, '2016-02-28 12:00:00', '2016-02-28 15:00:00'),
(6, 'Event', 'Default', '2015-02-26', 1, 2, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', NULL, 'This is an example event description.', 0, '', 49, 2, '2015-12-20 00:00:00', '2015-12-20 00:00:00'),
(7, 'Event 2', 'Default (Editable Right Hand Column)', '2015-02-26', 1, 2, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, '', '', '', NULL, 'This is an example event description.', 0, '', 0, 2, '2015-11-21 00:00:00', '2015-11-21 00:00:00');

INSERT INTO `route` (`route`, `primaryroute`, `objecttype`, `objectid`) VALUES
('about/', 1, 'page', 2),
('news/', 1, 'page', 4),
('events/', 1, 'page', 5),
('event-2/', 1, 'post', 7),
('members/', 1, 'page', 9),
('see-cms-launching-at-venturefest/', 1, 'post', 3),
('gallery/', 1, 'page', 10),
('contact/', 1, 'page', 3),
('login/', 1, 'page', 8),
('event/', 1, 'post', 6),
('event-3/', 1, 'post', 5),
('about/delving-deeper/', 1, 'page', 6),
('about/finding-out-more/', 1, 'page', 7),
('heres-a-catchy-headline/', 1, 'post', 4);

INSERT INTO `websiteusergroup` (`id`, `name`, `autoaddnewusers`) VALUES
(1, 'Registered users', 1);

INSERT INTO `websiteusergrouppermission` (`id`, `objecttype`, `objectid`, `websiteusergroup_id`) VALUES
(1, 'page', 9, 1);