Page MenuHomeIn-Portal Phabricator
Files F871849

install_data.sql
No OneTemporary
Actions

File Metadata

Created
Thu, May 8, 3:55 AM

install_data.sql
View Options

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 = 'projects';
UPDATE Category SET IsMenu = 1, Priority = -5 WHERE Template = 'sitemap';
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, -4, NULL, 0, NULL, 'Content&|&Contacts', 'Content&|&Contacts', 'Content&|&Contacts', 'Content&|&Contacts', 'Content&|&Contacts', -1, 120, '|1|200|', 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, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'sitemap'), '<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. Sed ut perspiciatis unde omnis iste 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, 2, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'sitemap'), '<p>Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, 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. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur. Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur. 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.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), 'Take the best business deal', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 2, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<strong>Smart Biz Template</strong> is one of <a target="_blank" href="http://www.templatemonster.com/website-templates.php">free website templates</a> created by Templates.com team. This website template is optimized for 1024X768 screen resolution. It is also XHTML &amp; CSS valid.', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 3, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<figure class="left marg_right1 marg_top2"><img width="120" height="108" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page1_img5.jpg" /></figure>\r\n<p class="marg_top">This <a target="_blank" href="http://blog.templatemonster.com/2011/01/24/free-business-website-template-efficient-choice/">Free Business Website Template</a> goes with two packages &ndash; with PSD source files and without them. PSD source files are available for free for the registered members of Templates.com. The basic package (without PSD is available for anyone without registration).</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 4, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<p>This website template has several pages: <a href="index.html">Home</a>, <a href="About.html">About</a>, <a href="Projects.html">Projects</a>, <a href="Contacts.html">Contacts</a> (note that contact us form &ndash; doesn&rsquo;t work), <a href="Sitemap.html">Sitemap</a>.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 5, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<ul class="list1 cols">\r\n <li><a href="#">At vero eos et accusamus iusto</a></li>\r\n <li><a href="#">Odio dignissimos ducimus</a></li>\r\n <li><a href="#">Blanditiis praesentium voluptatum</a></li>\r\n <li><a href="#">Deleniti atque corrupti quos dolores</a></li>\r\n</ul>\r\n<ul class="list1 cols pad_left2">\r\n <li><a href="#">Sint occaecati cuditate nongd</a></li>\r\n <li><a href="#">Provident similque suxpin culpa qui</a></li>\r\n <li><a href="#">Officia deserunt mollitia animidt</a></li>\r\n <li><a href="#">Etharum quidem rerum facili</a></li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 100, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<a href="#" class="button">read more</a>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 101, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<ul class="banners">\r\n <li><a href="#"><img width="210" height="144" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page1_img1.jpg" /></a>\r\n <div class="pad">\r\n <p class="font1">Company History</p>\r\n <p>Lorem ipsum doloamet consect etuer adipiscing.</p>\r\n </div>\r\n </li>\r\n <li><a href="#"><img width="210" height="144" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page1_img2.jpg" /></a>\r\n <div class="pad">\r\n <p class="font1">Our Capabilities</p>\r\n <p>Sed ut perspiciatis unde omnis iste naturror voluptatem.</p>\r\n </div>\r\n </li>\r\n <li><a href="#"><img width="210" height="144" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page1_img3.jpg" /></a>\r\n <div class="pad">\r\n <p class="font1">Where We Deliver</p>\r\n <p>Nam libero tempore cum soluta nobis est eligendi optio.</p>\r\n </div>\r\n </li>\r\n <li><a href="#"><img width="210" height="144" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page1_img4.jpg" /></a>\r\n <div class="pad">\r\n <p class="font1">Operations Consulting</p>\r\n <p>Temporibus autem quibusdam et aut officiis.</p>\r\n </div>\r\n </li>\r\n</ul>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 102, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), 'Latest projects', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 103, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<figure class="left marg_right1"><a href="#"><img width="98" height="79" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page1_img6.jpg" /></a></figure>\r\n<p>Sed peraspiciatis unde omnis iste natus eraror sit voluptatem accusantium doloremque.</p>\r\n<a class="marker" href="#">read more</a>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 104, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<figure class="left marg_right1"><a href="#"><img width="98" height="79" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page1_img7.jpg" /></a></figure>\r\n<p>Laudantiuam totam aperiam, eaque ipsa quaae ab illo inventore veritatais quasi.</p>\r\n<a class="marker" href="#">read more</a>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 105, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<figure class="left marg_right1"><a href="#"><img width="98" height="79" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page1_img8.jpg" /></a></figure>\r\n<p>Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit sed.</p>\r\n<a class="marker" href="#">read more</a>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'projects'), 'Project name', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 2, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'projects'), 'Latest projects', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 3, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'projects'), '<figure class="left marg_right2"><img width="195" height="108" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page3_img1.jpg" /></figure>\r\n<p class="pad_bot3"><strong>Accusamus iusto odio dignissimos ducimus qui blanditiis praesentium </strong></p>\r\n<p>Deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 4, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'projects'), '<p>Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus.</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 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 qui ratione voluptatem sequi nesciunt.</p>\r\n', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), 'A few words about us', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 2, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), 'Testimonials', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 3, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<figure class="left marg_right2"><img width="152" height="108" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page2_img1.jpg" /></figure>\r\n<p class="pad_bot3"><strong>At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium </strong></p>\r\n<p>Voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 4, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<p>Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda:</p>\r\n<ul class="list1">\r\n <li><a href="#">Sint occaecati cuditate nongd</a></li>\r\n <li><a href="#">Provident similque suxpin culpa qui</a></li>\r\n <li><a href="#">Officia deserunt mollitia animidt</a></li>\r\n</ul>\r\n<p class="marg_top">Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus.</p>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 5, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<figure class="left marg_right2"><img width="94" height="84" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page2_img2.jpg" /></figure>\r\n<p><strong>James Colloway</strong><br />\r\n<span class="color1">Managing Director</span></p>\r\nSed peraspiciatis unde omhnis accusantium doloremque.', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 6, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<figure class="left marg_right2"><img width="94" height="84" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page2_img3.jpg" /></figure>\r\n<p><strong>William Mason</strong><br />\r\n<span class="color1">Company President</span></p>\r\nLeaque ipsa quaae abillo intore veritatais quasi.', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 7, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'about'), '<figure class="left marg_right2"><img width="94" height="84" border="0" alt="" src="{SitePath}system/user_files/Images/business-demo/page2_img4.jpg" /></figure>\r\n<p><strong>Lance Manian</strong><br />\r\n<span class="color1">Sales Director</span></p>\r\nQuia volupts sit aspernatur aut odit omhnisaut fugitsed.', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 1, 200, 'Contact form', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 2, 200, 'Contact us', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 5, 200, '<strong>\r\n Country:<br>\r\n City:<br>\r\n Telephone:<br>\r\n Email:\r\n </strong>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 6, 200, 'USA<br>\r\n San Diego<br>\r\n +354 5635600<br>\r\n <a href="mailto:">smartbiz@mail.com</a>', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 7, 200, 'Miscellaneous Info', '', '', '', '');
INSERT INTO PageContent VALUES(DEFAULT, 8, 200, 'Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusantaque earum rerum hic.', '', '', '', '');
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 = 'Smart Biz' WHERE VariableName = 'Site_Name';

Event Timeline

In-Portal CMS · In-Portal Community Pages · In-Portal Issue Tracker · In-Portal Repository Browser · Quality Assurance · In-Portal CI Server