UPDATE Category SET IsMenu = 1 WHERE Template = 'index';

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) VALUES(200, 1, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
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) VALUES(201, 1, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
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) VALUES(202, 1, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0);
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) VALUES(203, 1, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0);

UPDATE IdGenerator SET lastid = lastid + 100;

INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<p>Once upon a time, there was a webmaster wanna-be Dwayne Wiener working for a company Techno-funky Gadgets, Inc. Dwayne was in charge of the company&rsquo;s website: responsible for keeping information current, maintaining lists of products and services, posting specials and press releases, and updating the portfolio.</p>\r\n<p>Dwayne was not very happy because every little update to the website had to be done by web designers, who were always late and charged a lot of money. As a result of that, the website was outdated, stagnant and non-performing.</p>\r\n<p><img src="http://demo.in-portal.com/demo_images/dwayne_wiener.png" alt="Dwayne Wiener" style="width: 415px; height: 300px;" /><br />\r\n<br />\r\n&ldquo;There must be another way!&rdquo; Dwayne thought in despair. This is how Dwayne found In-Portal Content Management System that puts companies back in control of their websites. The Content Management System (or CMS) allows companies to maintain and update their websites in-house, allowing for a more efficient delivery of critical information, and reducing operating costs of the website.</p>\r\n<p>Dwayne equipped the company&rsquo;s website with the In-Portal CMS, allowing Dwayne and other personnel at Techno-funky Gadgets to make updates to the website at their convenience. First Dwayne was worried that updating the website is complicated and would require special knowledge of web design and programming. Then Dwayne discovered that the system is very easy to use and is similar to Microsoft&copy; Word&trade;, with all the familiar tools and interfaces. It is completely online-based and can be accessed from any computer connected to the Internet, without any need for special software. The system is also very secure: only authorized personnel can make changes to the website.</p>\r\n<p>The uneasy days were over and Dwayne was happy once again. Techno-funky Gadget&rsquo;a website became one of the best in the industry, the company was saving a lot of money, and clients loved dealing with Techno-funky Gadgets because the website was appealing and easy to use. Dwayne was praised for the technical innovation, became a well known Internet guru around the office, and finally got the well-deserved promotion to the position of a Webmaster.</p>', NULL, NULL, NULL, NULL);
INSERT INTO PageContent VALUES(DEFAULT, 5, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<dt>Dwayne Wiener - Employee of the Month</dt>\r\n<dd>November 20, 2012 Dwayne Wiener has been voted Techno-funky Gadgets&rsquo;s Employee of the Month for December, 2012. Dwayne oversees performance of the company&rsquo;s new website, and is the mastermind behind its execution. The new website, developed by Intechnic Corporation, has an improved functionality, is easy to maintain, and it didn&rsquo;t break Techno-funky Gadgets&rsquo;s bank! Dwayne Wiener&rsquo;s accomplishment is projected to cut costs by 40%, and to increase revenues by 20% from current levels &ndash; an unprecedented improvement from a single implementation.</dd>\r\n<dt>New Website for Techno-funky Gadgets</dt>\r\n<dd>October 15, 2012 Techno-funky Gadgets is proud to announce the launch of its new website, dedicated to providing clients with an online resource for innovative and affordable products and services for anyone who needs them. It is intuitively structured, and is easy to navigate. The site is based on Intechnic&rsquo;s state-of-the-art Content Management System. It allows administrators at Techno-funky Gadgets to maintain the contents and the structure of the website in-house, without using any help from web designers. Regularly updated, the new Techno-funky Gadgets website is worthy of bookmarking for regular visits by anyone needing anything!</dd>', NULL, NULL, NULL, NULL);
INSERT INTO PageContent VALUES(DEFAULT, 6, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '<dt>ADMINISTRATIVE CONSOLE</dt>\r\n<dd>In-Portal&rsquo;s Administrative Console is Dwayne&rsquo;s little secret. It allows him to update the company&rsquo;s website from any computer with Internet access while he relaxes in his home or office, with a beer in hand, or with a cucumber mask on his face!<br />\r\n<br />\r\n<a href="admin/index.php"> <img src="http://demo.in-portal.com/demo_images/click_here.gif" style="width: 220px; height: 125px;" alt="Administrative Console" /> </a></dd>', NULL, NULL, NULL, NULL);
INSERT INTO PageContent VALUES(DEFAULT, 1, 200, '<p><img alt="About Techno-funky Gadgets" style="float: right; width: 182px; height: 292px;" src="http://demo.in-portal.com/demo_images/about_company.png" /> Techno-funky Gadgets is a company of tomorrow. We are setting industry standards by utilizing cutting edge technologies and innovations, while opening new frontiers and possibilities for our customers. Dedicated to the design, production, and delivery of innovative giggalmators, agathokakologs, and hundreds of other products and services over the last 25 years, Techno-funky Gadgets is uniquely able to offer its clients expert advice and comprehensive range of products to help them with any aspect of life. The products and services that we develop and make available on the market are used in every day lives of millions of people. Imagine yourself without a giggalmator today, and you will understand exactly what impact Techno-funky Gadgets has on the global community.</p>\r\n<p>Our mission is to fulfill each and every one of our customers&rsquo; needs. We value personal approach, diligence and professionalism, and we place trust at the center of every relationship, always staying committed to our customer. Our Customer Service Representatives are so dedicated to their job &ndash; they give out their personal numbers to clients, maintaining our reputation of a world class service company! All of our products and services come with an unlimited lifetime warranty, as Techno-funky Gadgets takes pride in delivering only the highest quality products and services.</p>\r\n<p>Customers that choose Techno-funky Gadgets can rest assured that they have made a wise decision. Their business will always be safe in the hands of professionals who are not only experts in their respective fields, but who also greatly enjoy doing what they do best.</p>\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n&nbsp; <script type="text/javascript">\r\n$(document).ready(function() {\r\n	$(''div.text'').addClass(''about'');\r\n});\r\n</script>', NULL, NULL, NULL, NULL);
INSERT INTO PageContent VALUES(DEFAULT, 1, 201, '<p>Products by Techno-funky Gadgets come in a wide variety of shapes, sizes, colors, sounds, resolutions and tastes. Our award-winning products are enjoyed by everyone: from children to great-grandparents; from pre-schoolers to PhD&rsquo;s; from artists to CFO&rsquo;s; from rich to poor, from boring to funny. However you like it &ndash; Techno-funky Gadgets can cater to your needs.</p>\r\n<p><img alt="Giggalmator" style="float: left; width: 129px; height: 140px;" src="http://demo.in-portal.com/demo_images/giggalmator.jpg" /></p>\r\n<h4>Giggalmator</h4>\r\nGiggalmator is the most advanced product in the family of Techno-funky Gadgets&rsquo;s Products. With 500 gigabytes of storage space, 30 miles per gallon and 256 distinct transformation styles, it delivers maximum results in minimum amount of time, while offering superb adaptation functions.  With the best taste bud rating in the industry, and the highest crash test score, you can rely on Giggalmator to deliver scrumptious, stylish, reliable results.&nbsp;\r\n<p><img alt="Agathokakolog" style="float: right; width: 137px; height: 148px;" src="http://demo.in-portal.com/demo_images/agathokakolog.jpg" /></p>\r\n<p>&nbsp;</p>\r\n<h4>Agathokakolog</h4>\r\nAgathokakolog is the most impressive product of its kind on the market today: it can spin at the speed of 867,5309 rev/min, transmit 1.5Gbps of junk email, shoot 3.14 arrows per second, and on top of all that, its bouncing abilities are unsurpassed at .007 Million bounces per second!  You&rsquo;ve got to have it to believe it!<br />\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n&nbsp; <script type="text/javascript">\r\n$(document).ready(function() {\r\n	$(''div.text'').addClass(''products'');\r\n});\r\n</script>', NULL, NULL, NULL, NULL);
INSERT INTO PageContent VALUES(DEFAULT, 1, 202, '<p>Techno-funky Gadgets is committed to excellence in all aspects of business. Just as our products are of the highest quality, our services bring the utmost satisfaction to our clients. We strive to make the world a better place, and our services have been designed with that goal in mind.</p>\r\n<p>The packages described herein are available for general public; however, if you have a special request, please let us know and we will do our best to accommodate you.</p>\r\n<h4>The Performance Boosting Package</h4>\r\n<p><img alt="The Performance Boosting Package" style="float: right; width: 150px; height: 215px;" src="http://demo.in-portal.com/demo_images/services_photo.png" /><br />\r\nIs your office lacking performance? Are you a Manager whose subordinates are unproductive? Nothing gets done around the office? Has your secretary been typing up that memo about doing work on time, for the past four days? If you answered &ldquo;Yes&rdquo; to any of the above questions, this Boosting Package is for you! $copmpany has all of our productivity problems solved: the package consists of one Office Drill Sergeant and two Assistants.</p>\r\n<p>As we always do what&rsquo;s in the best interest of our Client, this is a service we provide for a maximum period of one week at a time, so as not to increase employee turnover in your Company. You will have the Office Drill Sergeant at your workplace from morning and until night, ensuring that no one under your command slacks off. This is our most popular office service, and the only one, according to our clients, that significantly increases productivity in the office.</p>\r\n<h4>The Dust-Bust Package</h4>\r\n<p>Techno-funky Gadgets believes that plants must not be dusty. After a number of extensive and very reliable surveys, Techno-funky Gadgets received <img alt="The Performance Boosting Package" style="float: left; width: 137px; height: 166px;" src="http://demo.in-portal.com/demo_images/service.jpg" />reassurance that many people in the world have the same concern.</p>\r\n<p>This Package includes:<br />\r\n1. Plant-dusting of all plants &ndash; both inside and outside of your house<br />\r\n2. A set of our revolutionary Plant Dusters, engineered and produced by Techno-funky Gadgets<br />\r\n3. Actual planting of 3 new plants of your choice<br />\r\n4. BONUS: A complimentary video of various plant-dusting techniques!</p>\r\n<p>Techno-funky Gadgets only hires the top-of-the-class graduates of the World Plant-Dusting Institute, administer rigorous tests to ensure qualification, and hold mandatory Seminars to ensure that all of our top-notch dusters stay atop the newest industry developments and standards.</p>\r\n<p>This package does not disappoint &ndash; we leave your plants spotless, green, and dust-free!</p>\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n&nbsp; <script type="text/javascript">\r\n$(document).ready(function() {\r\n	$(''div.text'').addClass(''services'');\r\n});\r\n</script>', NULL, NULL, NULL, NULL);
INSERT INTO PageContent VALUES(DEFAULT, 1, 203, '<p><img alt="Contact Us" style="width: 197px; height: 135px; float: right;" src="http://demo.in-portal.com/demo_images/contact_us.jpg" /> If you have any questions, comments, concerns, or if you would like to request general information about any of our products or services, please contact us in a way that is the most convenient for you:\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n<br/>\r\n</p>\r\n', NULL, NULL, NULL, NULL);
INSERT INTO PageContent VALUES(DEFAULT, 2, 203, '<p>Techno-funky Gadgets, Inc<br />\r\n1234 Funky Drive<br />\r\nDwayneville, Alaska 00190<br />\r\nUnited States</p>\r\n<p>Phone: 847-816-1231<br />\r\nE-mail: <a href="mailto:info@company.com">info@company.com</a></p>', NULL, NULL, NULL, NULL);
INSERT INTO PageContent VALUES(DEFAULT, 3, 203, 'NOTE: fields marked with <span class="red">*</span> are required.', NULL, NULL, NULL, NULL);

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

INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 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, 1, 1, NULL, 0, 1, 0);
INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 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, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 4);
INSERT INTO FormFields VALUES(6, 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);

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 = 'Techno-funky Gadgets' WHERE VariableName = 'Site_Name';