-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: May 14, 2024 at 12:53 AM -- Server version: 10.3.39-MariaDB-log -- PHP Version: 8.1.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `qualityp_cms` -- -- -------------------------------------------------------- -- -- Table structure for table `blog` -- CREATE TABLE `blog` ( `article_id` int(11) NOT NULL, `page_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `path` varchar(255) NOT NULL, `date` datetime NOT NULL, `title` varchar(164) NOT NULL, `summary` text NOT NULL, `content` text NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `visited` int(5) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `cat_id` int(5) UNSIGNED NOT NULL, `parent_id` int(5) UNSIGNED NOT NULL DEFAULT 0, `cat_name` varchar(100) NOT NULL, `cat_path` varchar(100) NOT NULL, `title` varchar(100) NOT NULL, `keywords` text NOT NULL, `description` text NOT NULL, `content` text NOT NULL, `num_products` int(3) UNSIGNED NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 0, `menu` tinyint(1) NOT NULL DEFAULT 0, `position` int(4) UNSIGNED NOT NULL DEFAULT 10, `visited` int(10) UNSIGNED NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `deleted_pages` -- CREATE TABLE `deleted_pages` ( `page_id` int(4) UNSIGNED NOT NULL, `parent_id` int(4) UNSIGNED NOT NULL DEFAULT 0, `position` int(10) UNSIGNED NOT NULL DEFAULT 10, `page_type` varchar(10) NOT NULL, `display_content` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'fr custom pages, is the content displayed?', `name` varchar(30) NOT NULL DEFAULT '', `path` varchar(100) NOT NULL, `content` mediumtext NOT NULL, `title` varchar(72) NOT NULL DEFAULT '', `keywords` text NOT NULL, `description` text NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `menu` int(2) UNSIGNED NOT NULL DEFAULT 0, `menu_text` varchar(50) NOT NULL, `menu_id` int(2) UNSIGNED NOT NULL DEFAULT 1, `index_page` tinyint(1) NOT NULL DEFAULT 0, `error_page` tinyint(1) NOT NULL DEFAULT 0, `external` tinyint(1) NOT NULL DEFAULT 0, `external_path` varchar(100) NOT NULL, `has_slideshow` tinyint(1) NOT NULL DEFAULT 0, `visited` int(5) UNSIGNED NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `deleted_pages` -- INSERT INTO `deleted_pages` (`page_id`, `parent_id`, `position`, `page_type`, `display_content`, `name`, `path`, `content`, `title`, `keywords`, `description`, `active`, `menu`, `menu_text`, `menu_id`, `index_page`, `error_page`, `external`, `external_path`, `has_slideshow`, `visited`) VALUES (9, 0, 70, 'page', 1, 'Test Page', '/Test-Page/', '', '', '', '', 1, 0, 'Test Page', 1, 0, 0, 0, '', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `discount_codes` -- CREATE TABLE `discount_codes` ( `code_id` int(3) UNSIGNED NOT NULL, `code` varchar(8) NOT NULL, `discount_type` varchar(2) NOT NULL DEFAULT '%' COMMENT '$, %', `discount` float(5,2) UNSIGNED NOT NULL, `start_date` int(10) UNSIGNED NOT NULL COMMENT 'UNIX time', `finish_date` int(10) UNSIGNED NOT NULL COMMENT 'UNIX time' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `files` -- CREATE TABLE `files` ( `file_id` int(10) UNSIGNED NOT NULL, `file_name` varchar(128) NOT NULL, `file_path` varchar(256) NOT NULL, `file_title` varchar(256) NOT NULL, `file_description` text NOT NULL, `file_size` int(10) UNSIGNED NOT NULL, `mime_type` varchar(64) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `date_uploaded` int(10) UNSIGNED NOT NULL COMMENT 'unix timestamp', `date_updated` int(10) UNSIGNED NOT NULL, `count_downloads` int(10) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `gallery_data` -- CREATE TABLE `gallery_data` ( `gallery_id` int(5) UNSIGNED NOT NULL, `gallery_name` varchar(60) NOT NULL, `gallery_title` varchar(100) NOT NULL, `gallery_description` text NOT NULL, `gallery_path` varchar(60) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `visited` int(5) UNSIGNED NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `gallery_data` -- INSERT INTO `gallery_data` (`gallery_id`, `gallery_name`, `gallery_title`, `gallery_description`, `gallery_path`, `active`, `visited`) VALUES (1, 'Photo Gallery', '', '', '/resources/images/gallery/1/', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `image_data` -- CREATE TABLE `image_data` ( `image_id` int(5) UNSIGNED NOT NULL, `image_type` varchar(64) NOT NULL DEFAULT 'gallery' COMMENT 'eg gallery, category, product, page, slideshow', `container_id` int(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'foreign key', `gallery_id` int(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'foreign key', `image_path` varchar(255) NOT NULL, `image_filename` varchar(60) NOT NULL, `title` varchar(50) NOT NULL, `link` varchar(128) NOT NULL, `width` int(6) UNSIGNED NOT NULL DEFAULT 0, `height` int(6) UNSIGNED NOT NULL DEFAULT 0, `image_position` int(3) UNSIGNED NOT NULL DEFAULT 10, `order_id` int(2) UNSIGNED NOT NULL DEFAULT 50, `active` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `image_data` -- INSERT INTO `image_data` (`image_id`, `image_type`, `container_id`, `gallery_id`, `image_path`, `image_filename`, `title`, `link`, `width`, `height`, `image_position`, `order_id`, `active`) VALUES (5, 'gallery', 1, 0, '/resources/images/gallery/1/', '004.jpg', '', '', 1000, 632, 10, 50, 1), (9, 'gallery', 1, 0, '/resources/images/gallery/1/', '017.jpg', '', '', 534, 800, 10, 50, 1), (8, 'gallery', 1, 0, '/resources/images/gallery/1/', '20131128_151255.jpg', '', '', 1000, 674, 10, 50, 1), (10, 'gallery', 1, 0, '/resources/images/gallery/1/', '041.jpg', '', '', 1000, 667, 10, 50, 1), (11, 'page-slideshow', 1, 0, '/resources/images/page/1/', 'slide11.jpg', '', '', 1002, 360, 20, 50, 1), (12, 'gallery', 1, 0, '/resources/images/gallery/1/', '1.jpg', '', '', 1000, 750, 10, 50, 1), (13, 'gallery', 1, 0, '/resources/images/gallery/1/', '2.jpg', '', '', 1000, 750, 10, 50, 1); -- -------------------------------------------------------- -- -- Table structure for table `lists` -- CREATE TABLE `lists` ( `list_id` int(10) UNSIGNED NOT NULL, `list_name` varchar(64) NOT NULL, `list_description` varchar(128) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `lists` -- INSERT INTO `lists` (`list_id`, `list_name`, `list_description`) VALUES (1, 'Product data fields', 'WEP default list for product data fields'), (2, 'Product option fields', 'WEP default list for product option fields'); -- -------------------------------------------------------- -- -- Table structure for table `list_options` -- CREATE TABLE `list_options` ( `option_id` int(10) UNSIGNED NOT NULL, `list_id` int(10) UNSIGNED NOT NULL COMMENT 'foreign key -> lists', `option_text` varchar(128) NOT NULL, `active` tinyint(1) NOT NULL, `position` int(10) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `menus` -- CREATE TABLE `menus` ( `menu_id` int(2) UNSIGNED NOT NULL, `menu_title` varchar(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `order_id` int(10) UNSIGNED NOT NULL, `order_ref` int(10) UNSIGNED NOT NULL COMMENT 'doubles as timestamp', `order_description` varchar(128) NOT NULL, `order_total` float(8,2) UNSIGNED NOT NULL DEFAULT 0.00, `shipping_location` varchar(128) NOT NULL, `shipping_cost` float(6,2) UNSIGNED NOT NULL DEFAULT 0.00, `discount_code` varchar(8) NOT NULL, `discount` float(5,2) UNSIGNED NOT NULL, `discount_type` varchar(2) NOT NULL, `discount_amount` float(10,2) UNSIGNED NOT NULL, `customer_id` int(5) UNSIGNED NOT NULL DEFAULT 0, `customer_name` varchar(128) NOT NULL, `customer_email` varchar(128) NOT NULL, `customer_phone` varchar(128) NOT NULL, `delivery_address` text NOT NULL, `delivery_instructions` text NOT NULL, `paid` tinyint(1) NOT NULL DEFAULT 0, `payment_method` varchar(24) NOT NULL, `transaction_fee` float(6,2) NOT NULL, `payment_ref` varchar(64) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_products` -- CREATE TABLE `order_products` ( `order_id` int(5) UNSIGNED NOT NULL DEFAULT 0, `product_id` varchar(10) NOT NULL DEFAULT '0', `product_name` varchar(128) NOT NULL, `category_id` int(5) UNSIGNED NOT NULL COMMENT 'foreign key categories', `category_name` varchar(64) NOT NULL, `price` float(6,2) UNSIGNED NOT NULL DEFAULT 0.00, `wholesale_price` float(6,2) UNSIGNED NOT NULL DEFAULT 0.00, `quantity` int(2) UNSIGNED NOT NULL DEFAULT 0, `quantity_description` varchar(64) NOT NULL, `options` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_temp` -- CREATE TABLE `order_temp` ( `order_id` int(5) NOT NULL, `json` text NOT NULL, `email_text` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='store temporary data while customer is offsite at payment ga'; -- -------------------------------------------------------- -- -- Table structure for table `page_data` -- CREATE TABLE `page_data` ( `page_id` int(4) UNSIGNED NOT NULL, `parent_id` int(4) UNSIGNED NOT NULL DEFAULT 0, `position` int(10) UNSIGNED NOT NULL DEFAULT 10, `page_type` varchar(20) NOT NULL DEFAULT 'page' COMMENT 'page; [hook]', `display_content` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'fr custom pages, is the content displayed?', `name` varchar(60) NOT NULL, `path` varchar(100) NOT NULL, `content` mediumtext NOT NULL, `title` varchar(72) NOT NULL DEFAULT '', `keywords` text NOT NULL, `description` text NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `menu` int(2) UNSIGNED NOT NULL DEFAULT 0, `menu_text` varchar(50) NOT NULL, `menu_id` int(2) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'menu in template toinclude page on', `index_page` tinyint(1) NOT NULL DEFAULT 0, `error_page` tinyint(1) NOT NULL DEFAULT 0, `external` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'link out to another site', `external_path` varchar(100) NOT NULL, `has_slideshow` tinyint(1) NOT NULL DEFAULT 0, `visited` int(5) UNSIGNED NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `page_data` -- INSERT INTO `page_data` (`page_id`, `parent_id`, `position`, `page_type`, `display_content`, `name`, `path`, `content`, `title`, `keywords`, `description`, `active`, `menu`, `menu_text`, `menu_id`, `index_page`, `error_page`, `external`, `external_path`, `has_slideshow`, `visited`) VALUES (1, 0, 10, 'page', 1, 'home', '/home/', '<div class="left">\r\n<h1>Welcome to Quality Precast Concepts</h1>\r\n<h3>Quality Pre-Cast Concrete made in Christchurch</h3>\r\n<p>We are a Canterbury born and bred company located on Christchurch’s doorstep – Rolleston. Our aim is to be supplier of choice for quality precast elements. To meet our customers’ needs we appreciate that we must be able offer a complete range of manufacturing and product options.</p>\r\n<p><strong>PRESTRESSED</strong> flooring systems including Unispan, flat slabs, Interspan (rib & infill) and Double tees.</p>\r\n<p><strong>PRECAST</strong> elements including panels, beams, spandrels, bleachers (precast and/or prestressed) and stairs.</p>\r\n<p style="text-align: center;">As our product range expands we will update our website.</p>\r\n</div>\r\n<div class="right"><a class="img-link" href="/about-us/"> <img src="/resources/image/why.jpg" alt="about us" width="275" height="133" /> <span class="text">About Us </span> <span class="inner-shadow"> </span> </a> <a class="img-link" href="/contact-us/"> <img src="/resources/image/products.jpg" alt="contat us" width="275" height="133" /> <span class="text">Contact Us </span> <span class="inner-shadow"> </span> </a></div>', 'Welcome to Quality Precast Concepts', '', '', 1, 1, 'home', 1, 1, 0, 0, '', 1, 69920), (2, 0, 20, 'page', 1, 'about us', '/about-us/', '<h1>About Quality Precast Concepts</h1>\r\n<h3>Quality Pre-Cast Concrete made in Christchurch</h3>\r\n<p><strong>INNOVATION & ACTION</strong> - Quality Precast Concepts specialises in creating innovative solutions to a wide range of precast concrete needs. Our business grew from a recognised need to find such solutions, allied to more efficient ways of manufacturing while improving quality through innovation.</p>\r\n<p><strong>QUALITY ASSURANCE</strong> – Quality control is an integral part of our daily function. We are dedicated to setting the standard for production operations, preparation and procedures. Our quality assurance programme assists Engineers, Architects and Designers who select us as quality precasters known for superior workmanship.</p>\r\n<p><strong>EXPERTISE</strong> – Our personnel have many years of industry experience between them having specialised in precast manufacture and production technologies. Our team understands product applications and specifications and as such are able to offer options with regard to innovative solutions. We offer prompt attention to client enquiries and will work with you to find the best option.</p>\r\n<p><strong>OUR CAPABILITIES</strong> – Our site covers in excess of 1 hectare with a start-up production area of 3500 m2, serviced by a 25 tonne capacity overhead crane. So plenty of room to expand as the market requires. We have invested heavily in our modern facilities to ensure efficient manufacture and product turnaround times.</p>', 'About Quality Precast Concepts', '', '', 1, 1, 'about us', 1, 0, 0, 0, '', 0, 11785), (3, 0, 40, 'page', 1, 'services', '/services/', '<h1>Heading 1</h1>\r\n<p>Lorem ipsum dolor sit amet, <a href="/">consectetur adipiscing elit</a>. Pellentesque non ultricies urna. Cras erat justo, convallis at condimentum a, euismod non nisi. Ut sed dui sit amet risus fermentum ornare. Vestibulum a metus quis ligula sagittis lacinia nec sit amet turpis.</p>\r\n<p>Pellentesque dignissim mi sed libero dapibus sed tincidunt velit aliquam. Etiam nec consectetur lacus. Vivamus quis ipsum at tortor rutrum ultrices. Quisque et cursus dolor. Proin sem augue, ullamcorper vel consectetur eu, dapibus ac dui. Proin in leo vitae est pretium sodales.</p>\r\n<h2>Heading 2</h2>\r\n<ol>\r\n<li>list</li>\r\n<li>list</li>\r\n<li>list</li>\r\n</ol>\r\n<ul>\r\n<li>list</li>\r\n<li>list</li>\r\n<li>list</li>\r\n</ul>\r\n<h3>Heading 3</h3>\r\n<p>[image here]</p>', '', '', '', 0, 0, 'services', 1, 0, 0, 0, '', 0, 7), (4, 0, 70, 'page', 1, 'contact us', '/contact-us/', '<h1>Contact Quality Precast Concepts</h1>\r\n<h3>Quality Pre-Cast Concrete made in Christchurch</h3>\r\n<form id="contact" action="/processes/process-form.php" method="post" enctype="multipart/form-data" class="contact mceVisualAid">\r\n<script type="text/javascript">// <![CDATA[\r\nif(m = $.cookie("formMessage")){\r\n document.write(URLDecode(m));\r\n $.removeCookie("formMessage");\r\n }\r\n// ]]></script>\r\n<h2>enquire now</h2>\r\n<p><input id="Name" name="Name" type="text" class="required" placeholder="name.." /></p>\r\n<p><input id="Email" name="Email" type="text" class="email required" placeholder="email.." /></p>\r\n<p><input id="Phone" name="Phone" type="text" placeholder="phone.." /></p>\r\n<p class="radio">preferred reply.. <input id="contact_email" name="prefered_contact" type="radio" value="email" /> <label for="contact_email">email</label> <input id="contact_phone" name="prefered_contact" type="radio" value="phone" /> <label for="contact_phone">phone</label></p>\r\n<p><textarea id="Message" name="Message" rows="20" placeholder="message.."></textarea></p>\r\n<p><label for="security_code">Security:</label> <img class="auth" src="/resources/captcha/CaptchaSecurityImages.php" alt="Security Code" /> <input id="security_code" name="auth" type="text" /></p>\r\n<p class="action"><input name="submit" type="submit" value="send" class="button" /></p>\r\n</form>\r\n<script type="text/javascript">// <![CDATA[\r\nrefillFormAdv("contact");\r\n// ]]></script>\r\n<div class="map"><iframe src="https://maps.google.co.nz/maps?q=889+Jones+Road+Rolleston&ie=UTF8&hq=&hnear=889+Jones+Rd,+Rolleston+7675&gl=nz&t=m&z=14&ll=-43.588965,172.377295&output=embed" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" width="460" height="260"></iframe><br /><small></small>\r\n<p><strong>889 Jones Road Rolleston</strong></p>\r\n<div class="map-left">\r\n<p>David Te Maari</p>\r\n<p>Mobile: 022 401 0709</p>\r\n<p>Phone : 03 347 4768</p>\r\n<p><a href="mailto:david@qualityprecast.co.nz">david@qualityprecast.co.nz</a></p>\r\n</div>\r\n<div class="map-right">\r\n<p>Lew Austin</p>\r\n<p>Mobile: 021 3567 36</p>\r\n<p>Phone: 03 347 4768</p>\r\n<p><a href="mailto:lew@qualityprecast.co.nz">lew@qualityprecast.co.nz</a></p>\r\n</div>\r\n</div>', 'Contact Quality Precast Concepts', '', '', 1, 1, 'contact us', 1, 0, 0, 0, '', 0, 23260), (5, 2, 10, 'page', 1, 'lew austin', '/about-us/lew-austin/', '<h1>LEW AUSTIN</h1>\r\n<p>Lews business career began in the Hydraulic & Pumping Industry with a well-known National Electrical & Mechanical company B.R. Homersham ltd, advancing to owning his own Irrigation & Pumping company designing & Installing broad acre Irrigation systems for the cropping & pastoral farms.</p>\r\n<p>He went on to introduce to New Zealand a new industry, the advanced treatment of domestic & commercial wastewater systems, developing his own systems in modular monolithic precast concrete one piece poured structures, allowing these to be transported throughout the country. Parallel to this industry he began the manufacture of vertical cast concrete pipe & associated infrastructure precast product.</p>\r\n<p>On selling this business Lew proceeded into Quality Precast Concepts involved in Specialised precast & Associated products.</p>', 'LEW AUSTIN', '', '', 0, 0, 'lew austin', 1, 0, 0, 0, '', 0, 421), (6, 2, 20, 'page', 1, 'greg neill', '/about-us/greg-neill/', '<h1>GREG NEILL</h1>\r\n<p>Has been involved in the precast industry in one way or another for in excess of 40 years- both in New Zealand and overseas. During this time he has had involvement in all aspects of the manufacture of precast concrete products, both large and small. Listed below are some of those products.</p>\r\n<ul>\r\n<li>Prestressed Bridge beams - Double hollow core, I beam and U beams.</li>\r\n<li>Concrete pipes –spun and vertical cast.</li>\r\n<li>Prestressed flooring units – Unispan, flat slab, Interspan, extruded, double and single tees & shell beams.</li>\r\n<li>Precast water storage & treatment tanks and reservoirs</li>\r\n<li>Power poles – precast, prestressed and spun.</li>\r\n<li>Piles - precast and prestressed.</li>\r\n<li>Prestressed Railway sleepers.</li>\r\n<li>Infrastructure products - precast manholes and lids, sumps culverts and underpasses.</li>\r\n<li>Wall panels, plain and architectural, boundary walls, beams, columns, stairs.</li>\r\n<li>Large civil componentry.</li>\r\n<li>Stadium Bleachers – precast and prestressed.</li>\r\n</ul>', 'GREG NEILL', '', '', 0, 0, 'greg neill', 1, 0, 0, 0, '', 0, 519), (7, 0, 30, 'page', 1, 'Products', '/Products/', '<div class="conleft" style="min-height: 914px; padding-bottom: 40px;">\r\n<h1>Products</h1>\r\n<h2>About Precast Concrete</h2>\r\n<p>Precast concrete is a construction method produced by casting concrete into reusable mould forms, ensuring precise control of product produced. In contrast standard concrete is poured on site into varying mould forms, which doesn’t provide quality & uniformity to the same degree.</p>\r\n<p>Precast Concrete in moulds can offer a variety of shapes, sizes & thicknesses unobtainable to the same degree in on site work.</p>\r\n<h2>Flat Slab Flooring</h2>\r\n<p>Incorporated into buildings where large span & fast erection is required. Ideal for use in hotels, office blocks, industrial buildings and schools.</p>\r\n<h2>Double Tee Floors</h2>\r\n<p>Used as a preferred method of construction for parking decks, floor @ roof applications, such as pools & gyms. The system is extremely durable, sound resistant & can withstand earthquakes.</p>\r\n<img class="img-link" style="max-width: 800px; bottom: 40px; position: absolute;" src="/resources/image/prodbot.jpg" alt="" width="735" height="300" /></div>\r\n<div class="conright"><img class="img-link" style="margin-top: 20px;" src="/resources/image/prodimg3.png" alt="" width="200" height="151" /> <img class="img-link" src="/resources/image/prodimg2.png" alt="" width="200" height="151" /> <img class="img-link" src="/resources/image/prod-img1.png" alt="" width="200" height="151" /><img class="img-link" src="/resources/image/050small.jpg" alt="" width="200" height="300" /></div>', 'Precast Concrete Products', '', '', 1, 1, 'products', 1, 0, 0, 0, '', 0, 17299), (8, 0, 60, 'page', 1, 'Our Team', '/Our-Team/', '<h1>The Quality Precast Concepts Team</h1>\r\n<p><img class="img-link2" src="/resources/image/lew2.jpg" alt="Lew Austin" width="220" height="250" /></p>\r\n<h2>Lew Austin</h2>\r\n<p>Lews business career began in the Hydraulic & Pumping Industry with a well-known National Electrical & Mechanical company B.R. Homersham ltd, advancing to owning his own Irrigation & Pumping company designing & Installing broad acre Irrigation systems for cropping & pastoral farms.</p>\r\n<p>He went on to introduce to New Zealand a new industry, the advanced treatment of domestic & commercial wastewater systems, developing his own systems in modular monolithic precast concrete one piece poured structures, allowing these to be transported throughout the country. Parallel to this industry he began the manufacture of vertical cast concrete pipe & associated infrastructure precast product.</p>\r\n<p>On selling this business Lew proceeded into Quality Precast Concepts involved in Specialised precast & Associated products.</p>\r\n<p><img class="img-link2" src="/resources/image/greg2.jpg" alt="Greg Neill" width="220" height="250" /></p>\r\n<h2>Greg Neill</h2>\r\n<p>Has been involved in the precast industry in one way or another for in excess of 40 years- both in New Zealand and overseas. During this time he has had involvement in all aspects of the manufacture of precast concrete products, both large and small. Listed below are some of those products.</p>\r\n<ul>\r\n<li>Prestressed Bridge beams - Double hollow core, I beam and U beams.</li>\r\n<li>Concrete pipes –spun and vertical cast.</li>\r\n<li>Prestressed flooring units – Unispan, flat slab, Interspan, extruded, double and single tees & shell beams.</li>\r\n<li>Precast water storage & treatment tanks and reservoirs</li>\r\n<li>Power poles – precast, prestressed and spun.</li>\r\n<li>Piles - precast and prestressed.</li>\r\n<li>Prestressed Railway sleepers.</li>\r\n<li>Infrastructure products - precast manholes and lids, sumps culverts and underpasses.</li>\r\n<li>Wall panels, plain and architectural, boundary walls, beams, columns, stairs.</li>\r\n<li>Large civil componentry.</li>\r\n<li>Stadium Bleachers – precast and prestressed.</li>\r\n</ul>\r\n<div class="clear"> </div>', 'The Quality Precast Concepts Team', '', '', 1, 1, 'our team', 1, 0, 0, 0, '', 0, 13538), (10, 0, 50, 'page', 1, 'gallery', '/gallery/', '<p>%%GALLERY-1%%</p>', 'Quality Precast | Gallery', '', '', 1, 1, 'gallery', 1, 0, 0, 0, '', 0, 11004); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `prod_id` int(5) UNSIGNED NOT NULL, `category_id` int(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'foreign key = categories(cat_id)', `product_name` varchar(128) NOT NULL, `product_code` varchar(16) NOT NULL, `product_path` text NOT NULL, `product_description` text NOT NULL, `short_description` text NOT NULL, `location` varchar(64) NOT NULL, `price` float(6,2) UNSIGNED NOT NULL DEFAULT 0.00, `sale_price` float(6,2) UNSIGNED NOT NULL, `on_sale` tinyint(1) NOT NULL DEFAULT 0, `number_in_stock` int(5) UNSIGNED NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `featured` tinyint(1) NOT NULL DEFAULT 0, `sidebar` tinyint(1) NOT NULL DEFAULT 0, `associated_products` text NOT NULL COMMENT 'json serialised array', `visited` int(5) NOT NULL DEFAULT 0, `date_added` int(10) UNSIGNED NOT NULL COMMENT '(timestamp)' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_category_xref` -- CREATE TABLE `product_category_xref` ( `product_id` int(5) UNSIGNED NOT NULL, `category_id` int(5) UNSIGNED NOT NULL, `product_path` varchar(128) NOT NULL, `position` int(10) UNSIGNED NOT NULL DEFAULT 10 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_data` -- CREATE TABLE `product_data` ( `product_id` int(10) UNSIGNED NOT NULL, `option_id` int(10) UNSIGNED NOT NULL, `option_value` varchar(64) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_options` -- CREATE TABLE `product_options` ( `product_id` int(10) UNSIGNED NOT NULL, `option_id` int(10) UNSIGNED NOT NULL, `option_value` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_prices` -- CREATE TABLE `product_prices` ( `product_id` int(10) UNSIGNED NOT NULL, `quantity` int(5) UNSIGNED NOT NULL, `quantity_description` varchar(64) NOT NULL, `price` float(6,2) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `session_anon` -- CREATE TABLE `session_anon` ( `session_id` varchar(64) NOT NULL, `user_id` int(4) UNSIGNED NOT NULL DEFAULT 0, `full_name` varchar(64) NOT NULL, `shipping_location` int(10) UNSIGNED NOT NULL, `address` text NOT NULL, `phone` varchar(32) NOT NULL, `email` varchar(64) NOT NULL, `newsletter` tinyint(1) NOT NULL, `interests` text NOT NULL, `cart` text NOT NULL, `wishlist` text NOT NULL, `timestamp` int(10) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `session_anon` -- INSERT INTO `session_anon` (`session_id`, `user_id`, `full_name`, `shipping_location`, `address`, `phone`, `email`, `newsletter`, `interests`, `cart`, `wishlist`, `timestamp`) VALUES ('c537ce8f9ec53978eb4612062c3c6bdf', 0, '', 0, '', '', '', 0, '', '', '', 1715604161), ('73f4ac4a5d974b175cb9bed18267d3b8', 0, '', 0, '', '', '', 0, '', '', '', 1715604488), ('f9244f1a953e734cd777ed17b9c8e257', 0, '', 0, '', '', '', 0, '', '', '', 1715604686), ('0f8ecdc94315cf624ce81dd11890a70c', 0, '', 0, '', '', '', 0, '', '', '', 1715604687), ('0d51269b603638e4c59fbec81c1beeec', 0, '', 0, '', '', '', 0, '', '', '', 1715598570), ('16abb9aaddb6134bb46a232b5b54192e', 0, '', 0, '', '', '', 0, '', '', '', 1715598572), ('604lpfk73755sivfmv6pfc1gc4', 0, '', 0, '', '', '', 0, '', '', '', 1715599084), ('qj7er2st8u2309i9nbt8ed5pn5', 0, '', 0, '', '', '', 0, '', '', '', 1715595528); -- -------------------------------------------------------- -- -- Table structure for table `shipping` -- CREATE TABLE `shipping` ( `ship_id` int(2) UNSIGNED NOT NULL, `location` varchar(128) NOT NULL, `shipping_cost` float(6,2) UNSIGNED NOT NULL DEFAULT 0.00, `position` int(10) UNSIGNED NOT NULL DEFAULT 10, `active` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `stockists` -- CREATE TABLE `stockists` ( `stockist_id` int(3) UNSIGNED NOT NULL, `region_id` int(2) UNSIGNED NOT NULL, `stockist_name` varchar(64) NOT NULL, `stockist_address` text NOT NULL, `stockist_phone` varchar(24) NOT NULL, `stockist_website` varchar(64) NOT NULL, `stockist_map_code` text NOT NULL, `active` tinyint(1) NOT NULL, `order_id` int(2) UNSIGNED NOT NULL DEFAULT 50 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `stockist_regions` -- CREATE TABLE `stockist_regions` ( `region_id` int(3) UNSIGNED NOT NULL, `region_name` varchar(32) NOT NULL, `international` tinyint(1) NOT NULL, `active` tinyint(1) NOT NULL, `order_id` int(2) NOT NULL DEFAULT 50 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `testimonials` -- CREATE TABLE `testimonials` ( `testimonial_id` int(10) UNSIGNED NOT NULL, `type_id` int(10) UNSIGNED NOT NULL, `witness` varchar(128) NOT NULL, `testimony` text NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `position` int(10) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `user_id` int(5) UNSIGNED NOT NULL COMMENT 'This will be each members unique ID.', `full_name` varchar(50) NOT NULL, `first_name` varchar(40) NOT NULL, `last_name` varchar(40) NOT NULL, `address` text NOT NULL, `phone` varchar(32) NOT NULL, `shipping_location` int(3) UNSIGNED NOT NULL, `cart` text NOT NULL, `wishlist` text NOT NULL, `email` varchar(60) NOT NULL COMMENT 'This will be the email address of the member', `newsletter` tinyint(1) NOT NULL DEFAULT 0, `interests` text NOT NULL, `personal_discount` float(5,2) NOT NULL DEFAULT 0.00, `wholesale` tinyint(1) NOT NULL DEFAULT 0, `notes` text NOT NULL, `password` text NOT NULL COMMENT 'This will be the members password to log into the system', `date_added` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'This will be the date the member first signed up (timestamp) ', `date_active` int(10) UNSIGNED NOT NULL, `suspended` tinyint(1) NOT NULL DEFAULT 0, `validation_string` varchar(30) NOT NULL COMMENT 'for email validation and password reset', `password_reset` varchar(30) NOT NULL COMMENT 'verification code to allow changing password without logging in' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `blog` -- ALTER TABLE `blog` ADD PRIMARY KEY (`article_id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`cat_id`); -- -- Indexes for table `deleted_pages` -- ALTER TABLE `deleted_pages` ADD PRIMARY KEY (`page_id`), ADD KEY `parent-child` (`parent_id`); -- -- Indexes for table `discount_codes` -- ALTER TABLE `discount_codes` ADD PRIMARY KEY (`code_id`); -- -- Indexes for table `files` -- ALTER TABLE `files` ADD PRIMARY KEY (`file_id`); -- -- Indexes for table `gallery_data` -- ALTER TABLE `gallery_data` ADD PRIMARY KEY (`gallery_id`); -- -- Indexes for table `image_data` -- ALTER TABLE `image_data` ADD PRIMARY KEY (`image_id`), ADD KEY `type` (`image_type`,`container_id`); -- -- Indexes for table `lists` -- ALTER TABLE `lists` ADD PRIMARY KEY (`list_id`); -- -- Indexes for table `list_options` -- ALTER TABLE `list_options` ADD PRIMARY KEY (`option_id`,`list_id`), ADD KEY `active` (`active`); -- -- Indexes for table `menus` -- ALTER TABLE `menus` ADD PRIMARY KEY (`menu_id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`order_id`), ADD KEY `customer_id` (`customer_id`); -- -- Indexes for table `order_products` -- ALTER TABLE `order_products` ADD PRIMARY KEY (`order_id`,`product_id`); -- -- Indexes for table `order_temp` -- ALTER TABLE `order_temp` ADD PRIMARY KEY (`order_id`); -- -- Indexes for table `page_data` -- ALTER TABLE `page_data` ADD PRIMARY KEY (`page_id`), ADD KEY `parent-child` (`parent_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`prod_id`); -- -- Indexes for table `product_category_xref` -- ALTER TABLE `product_category_xref` ADD PRIMARY KEY (`product_id`,`category_id`); -- -- Indexes for table `product_data` -- ALTER TABLE `product_data` ADD PRIMARY KEY (`product_id`,`option_id`), ADD KEY `option_value` (`option_value`); -- -- Indexes for table `product_options` -- ALTER TABLE `product_options` ADD PRIMARY KEY (`product_id`,`option_id`); -- -- Indexes for table `product_prices` -- ALTER TABLE `product_prices` ADD PRIMARY KEY (`product_id`,`quantity`); -- -- Indexes for table `session_anon` -- ALTER TABLE `session_anon` ADD PRIMARY KEY (`session_id`); -- -- Indexes for table `shipping` -- ALTER TABLE `shipping` ADD PRIMARY KEY (`ship_id`); -- -- Indexes for table `stockists` -- ALTER TABLE `stockists` ADD PRIMARY KEY (`stockist_id`), ADD KEY `region_id` (`region_id`); -- -- Indexes for table `stockist_regions` -- ALTER TABLE `stockist_regions` ADD PRIMARY KEY (`region_id`); -- -- Indexes for table `testimonials` -- ALTER TABLE `testimonials` ADD PRIMARY KEY (`testimonial_id`), ADD KEY `type_id` (`type_id`,`active`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blog` -- ALTER TABLE `blog` MODIFY `article_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `cat_id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `deleted_pages` -- ALTER TABLE `deleted_pages` MODIFY `page_id` int(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `discount_codes` -- ALTER TABLE `discount_codes` MODIFY `code_id` int(3) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `files` -- ALTER TABLE `files` MODIFY `file_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `gallery_data` -- ALTER TABLE `gallery_data` MODIFY `gallery_id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `image_data` -- ALTER TABLE `image_data` MODIFY `image_id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `lists` -- ALTER TABLE `lists` MODIFY `list_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `list_options` -- ALTER TABLE `list_options` MODIFY `option_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `menus` -- ALTER TABLE `menus` MODIFY `menu_id` int(2) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `order_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `page_data` -- ALTER TABLE `page_data` MODIFY `page_id` int(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `prod_id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `shipping` -- ALTER TABLE `shipping` MODIFY `ship_id` int(2) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `stockists` -- ALTER TABLE `stockists` MODIFY `stockist_id` int(3) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `stockist_regions` -- ALTER TABLE `stockist_regions` MODIFY `region_id` int(3) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `testimonials` -- ALTER TABLE `testimonials` MODIFY `testimonial_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `user_id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'This will be each members unique ID.'; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
cải xoăn