UPDATE Category SET IsMenu = 1, Priority = -1 WHERE Template = 'index';
UPDATE Category SET IsMenu = 1, Priority = -2 WHERE Template = 'about';
UPDATE Category SET IsMenu = 1, Priority = -3 WHERE Template = 'services';
UPDATE Category SET IsMenu = 1, Priority = -4 WHERE Template = 'testimonials';
UPDATE Category SET Priority = -6 WHERE Filename = 'Pages';

INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId, EnablePageCache, OverridePageCacheKey, PageCacheKey, PageExpiration) VALUES(200, 1, NULL, 1, '', 'Contacts', '', '', '', '', 'Contacts', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1295021675, 0, 1, -5, NULL, 0, NULL, 'Content&|&Contacts', 'Content&|&Contacts', 'Content&|&Contacts', 'Content&|&Contacts', 'Content&|&Contacts', -1, 110, '|1|11|', 22, 23, 'Content/Contacts', NULL, 2, 2, 2, 1295566100, -1, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Form', '', '', '', '', 'Contacts', '', '', '', '', NULL, NULL, 1, 0, 1, '#form_thankyou#', '', 0, 0, 0, '', NULL);

INSERT INTO PageContent VALUES(DEFAULT, 100, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), 'At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident.', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), 'Welcome to Carpet Cleaning!', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 2, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<figure class="left marg_right1"><img width="186" height="186" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page1_img1.jpg" /></figure>\r\n<p class="pad_bot1"><strong>Sed ut perspiciatis unde</strong> omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiamnumquam eius.</p>\r\n<p>Eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos dolorem.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 3, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), 'Our Services', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 4, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<p class="pad_bot1"><strong>Neque porro quisquam est</strong>, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n						<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore.</p>\r\n', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 5, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<ul class="list1 cols">\r\n    <li><a href="#">Ut enim ad minima veniam quis</a></li>\r\n    <li><a href="#">Nostrum exercitationem ullam</a></li>\r\n    <li><a href="#">Corporis suscipit laboriosam nisi ut</a></li>\r\n    <li><a href="#">Aliquid ex ea commodi consequatur</a></li>\r\n    <li><a href="#">Quis autem vel eum iure</a></li>\r\n    <li><a href="#">Reprehenderit qui in ea voluptate</a></li>\r\n</ul>\r\n<ul class="list1 cols pad_left1">\r\n    <li><a href="#">At vero eos et accusamus et</a></li>\r\n    <li><a href="#">Lusto odio dignissimos ducimus</a></li>\r\n    <li><a href="#">Qui blanditiis praesentium voluptatu</a></li>\r\n    <li><a href="#">Deleniti atque corrupti quos dolores</a></li>\r\n    <li><a href="#">Et quas molestias excepturi sint</a></li>\r\n    <li><a href="#">Occaecati cupiditate non provident</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 6, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), 'Our Work', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 7, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<figure class="left marg_right2"><img width="88" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page1_img2.jpg" /></figure> 							<figure class="left marg_right2"><img width="88" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page1_img3.jpg" /></figure> 							<figure class="left"><img width="88" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page1_img4.jpg" /></figure>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 8, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<figure class="left marg_right2"><img width="88" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page1_img5.jpg" /></figure> 							<figure class="left marg_right2"><img width="88" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page1_img6.jpg" /></figure> 							<figure class="left"><img width="88" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page1_img7.jpg" /></figure>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 9, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), 'Recent News', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 10, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<p class="font1">12.11.2010</p>\r\n<p class="under">Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia conquuntur magni dolores eos qui ratione.</p>\r\n<p class="font1">03.11.2010</p>\r\n<p>Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), 'Our Profile', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 2, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<figure class="left marg_right1"><img width="88" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page2_img1.jpg" /></figure> 							Nisi ut aliquid ex ea commodi consequatur uis autem vel eum iure reprehenderit qui in ea voluptate:\r\n<ul class="list1 left">\r\n    <li><a href="#">At vero eos et accusamus et exercitationem</a></li>\r\n    <li><a href="#">Lusto odio dignissimos ducmus commodi</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 4, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<p><strong>Sed ut perspiciatis unde omnste</strong> 							natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 5, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<figure class="right marg_left1"><img width="112" height="112" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page2_img2.jpg" /></figure>\r\n<p>Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia <a href="#">consequuntur magni dolores</a> eosui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velited quia non numquam eius modi</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 9, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), 'What We Offer', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 3, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), 'What We Deliver', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 10, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<strong>At vero eos accusamus</strong><br />\r\nEt iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque:\r\n<ul class="list1 pad_bot2">\r\n    <li><a href="#">Nostrum exercitationem ullam</a></li>\r\n    <li><a href="#">Corporis suscipit laboriosam nisi ut</a></li>\r\n</ul>\r\n<strong>Excepturi sint occaecati cupiditate</strong><br />\r\nNon provident, similique sunt in culpa qui officia deserunt mollitia animi:\r\n<ul class="list1">\r\n    <li><a href="#">Qui blanditiis praesentium voluptatum Deleniti </a></li>\r\n    <li><a href="#">atque corrupti quos dolores</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 11, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<p><strong>Neque porro quisquam est, qui dolorem ipsum </strong><br />\r\nQuia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eiusodi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptat enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 12, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<p><strong>Tempora incidunt ut labore</strong>et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur. Quis autem vel eum iure <a href="#">reprehenderit qui</a> in ea voluptate velit esse quam nihil molestiae consequatur.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'testimonials'), 'Testimonials', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 2, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'testimonials'), '<article class="cols"> 									<figure class="left marg_right1 pad_bot1"><img width="62" height="62" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page4_img1.jpg" /></figure>\r\n<p class="font1 marg_top1">Jessica Hammond</p>\r\n<p class="color1">Housewife</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>\r\n</article> 								<article class="cols pad_left1"> 									<figure class="left marg_right1 pad_bot1"><img width="62" height="62" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page4_img2.jpg" /></figure>\r\n<p class="font1 marg_top1">Mark Megarus</p>\r\n<p class="color1">Businessman</p>\r\n<p>Ut enim minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat sed do eiusmod.</p>\r\n</article>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 3, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'testimonials'), '<article class="cols"> 									<figure class="left marg_right1 pad_bot1"><img width="62" height="62" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page4_img3.jpg" /></figure>\r\n<p class="font1 marg_top1">Timothy Regus</p>\r\n<p class="color1">Engineer</p>\r\n<p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa.</p>\r\n</article> 								<article class="cols pad_left1"> 									<figure class="left marg_right1 pad_bot1"><img width="62" height="62" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page4_img4.jpg" /></figure>\r\n<p class="font1 marg_top1">Maria Bonazzi</p>\r\n<p class="color1">Surgeon</p>\r\n<p>Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aufugit, sed quia consequuntur magni dolores eos qui ratione voluptatem.</p>\r\n</article>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 4, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'services'), '<figure class="left marg_right1"><img width="128" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page3_img3.jpg" /></figure> 							<strong>Ut enim ad minima veniam quis nostrum </strong><br />\r\nQuis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur.\r\n<ul class="list1 left">\r\n    <li><a href="#">Excepteur sint occaecat cupidatat</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 5, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'services'), '<figure class="left marg_right1"><img width="128" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page3_img4.jpg" /></figure> 							<strong>Lorem ipsum dolor amet consectetur </strong><br />\r\nUt enim ad minim veniam, quis nostrud exercitation ullamco laboris reprehenderit in voluptate velit esse cillum.\r\n<ul class="list1 left">\r\n    <li><a href="#">Excepteur sint occaecat cupidatat</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'services'), 'Services Overview', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 2, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'services'), '<figure class="left marg_right1"><img width="128" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page3_img1.jpg" /></figure> 							<strong>Lorem ipsum dolor amet consectetur </strong><br />\r\nUt enim ad minim veniam, quis nostrud exercitation ullamco laboris reprehenderit in voluptate velit esse cillum.\r\n<ul class="list1 left">\r\n    <li><a href="#">Excepteur sint occaecat cupidatat</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 3, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'services'), '<figure class="left marg_right1"><img width="128" height="88" border="0" alt="" src="{SitePath}system/user_files/Images/cleaning-demo/page3_img2.jpg" /></figure> 							<strong>Sed ut perspiciatis unde omnis </strong><br />\r\nNemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni.\r\n<ul class="list1 left">\r\n    <li><a href="#">Excepteur sint occaecat cupidatat</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 9, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'services'), 'Services List', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 10, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'services'), '<ul class="list1 pad_bot1">\r\n    <li><a href="#">At vero eos et accusamus et iusto</a></li>\r\n    <li><a href="#">Odio dignissimos ducimus qui blanditiis</a></li>\r\n    <li><a href="#">Praesentium voluptatum deleniti</a></li>\r\n    <li><a href="#">Atque corrupti quos dolores et quas</a></li>\r\n    <li><a href="#">Molestias excepturi sint occaecati cupiditate</a></li>\r\n    <li><a href="#">Non provident, similique sunt in culpa</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 9, 200, 'Our Contacts', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 10, 200, '<p class="col_1">Country:<br />\r\nCity:<br />\r\nTelephone:<br />\r\nEmail:</p>\r\n<p class="col_2">USA<br />\r\nSan Diego<br />\r\n+354 5635600<br />\r\n<a href="mailto:">businessco@mail.com</a></p>', '', '', '', '');

UPDATE IdGenerator SET lastid = lastid + 100;

INSERT INTO PermCache VALUES(DEFAULT, 200, 1, '11');

INSERT INTO Forms VALUES(1, 'Contact Form', 'Contact Form', 0, 1, 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', '');

INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, 1, 1);
INSERT INTO FormFields VALUES(2, 1, 0, 'Company', 'lu_fld_Company', NULL, 'la_fld_Company', 'text', NULL, 4, 0, 0, 1, NULL, 0, 1, 0);
INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 0, 1, NULL, 1, 1, 2);
INSERT INTO FormFields VALUES(4, 1, 0, 'Phone', 'lu_fld_Phone', NULL, 'la_fld_Phone', 'text', NULL, 2, 0, 0, 1, NULL, 0, 1, 0);
INSERT INTO FormFields VALUES(5, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, 1, 3);
INSERT INTO FormFields VALUES(6, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 4);

ALTER TABLE FormSubmissions
	ADD COLUMN fld_1 text,
	ADD COLUMN fld_2 text,
	ADD COLUMN fld_3 text,
	ADD COLUMN fld_4 text,
	ADD COLUMN fld_5 text,
	ADD COLUMN fld_6 text;

UPDATE ConfigurationValues SET VariableValue = 'Carpet Cleaning' WHERE VariableName = 'Site_Name';