]][ahhhhhhhfgfgdsfstrrrttrfwerwerwerdgdgrrreeteetffwerwerwerwerdsddfgh

-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Feb 26, 2025 at 08:05 AM -- Server version: 5.7.23-23 -- PHP Version: 8.1.31 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: `adchowat_webdb` -- -- -------------------------------------------------------- -- -- Table structure for table `banners` -- CREATE TABLE `banners` ( `banner_id` int(11) NOT NULL, `banner_date` date NOT NULL, `banner_area` varchar(30) NOT NULL, `banner_page` varchar(30) NOT NULL, `banner_image` varchar(50) NOT NULL, `banner_slogan` varchar(200) NOT NULL, `banner_slogan_position` varchar(10) NOT NULL, `banner_order` int(2) NOT NULL, `banner_status` varchar(20) NOT NULL, `banner_log` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `banners` -- INSERT INTO `banners` (`banner_id`, `banner_date`, `banner_area`, `banner_page`, `banner_image`, `banner_slogan`, `banner_slogan_position`, `banner_order`, `banner_status`, `banner_log`) VALUES (1, '2018-09-22', 'header', 'home', 'slide-5.jpg', 'Sharp Ply Ring Form <br />Adjustable Circular Formwork<br />@ STP Project, Bangalore.', 'left', 4, 'Active', '# Banner added on 22-09-2018 11:50 by Admin;'), (3, '2018-09-22', 'header', 'home', 'slide-7.jpg', 'Emerging Innovations <br/>Concrete Solutions', 'left', 2, 'Active', '# Banner added on 22-09-2018 11:50 by Admin;'), (8, '2020-10-16', 'header', 'home', 'slide-9.jpg', 'Quality Products for <br/> Construction Formwork', 'left', 5, 'Active', '# Banner added on 2020-10-16 by Aditya; '), (11, '2022-06-28', 'header', 'home', 'banner-1656389150.jpg', 'VARIECO in action.<br />At Navi Mumbai', 'left', 3, 'Active', '# Banner added on 2022-06-28 by Aditya; '), (12, '2022-06-28', 'header', 'home', 'banner-1656389565.jpg', 'Lightweight Framed Fomrwork<br />VARIECO', 'left', 1, 'Active', '# Banner added on 2022-06-28 by Aditya; '), (21, '2025-02-12', 'header', 'home', 'banner-1739370796.php', 'asdasdasdasd<br />sdasdasda', 'left', 6, 'Active', '# Banner added on 2025-02-12 by Aditya; '), (22, '2025-02-24', 'header', 'home', 'banner-1740346304.php', 'd<br />d', 'left', 7, 'Active', '# Banner added on 2025-02-24 by Aditya; '), (23, '2025-02-24', 'header', 'home', 'banner-1740347360.php', '', 'left', 8, 'Active', '# Banner added on 2025-02-24 by Aditya; '); -- -------------------------------------------------------- -- -- Table structure for table `content` -- CREATE TABLE `content` ( `content_id` int(2) NOT NULL, `menu_main_id` int(2) NOT NULL, `menu_sub_id` int(2) NOT NULL, `content_image` varchar(30) NOT NULL, `content_desc` varchar(30) NOT NULL, `content_full` text NOT NULL, `content_short` text NOT NULL, `content_status` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `menu_main` -- CREATE TABLE `menu_main` ( `menu_id` int(2) NOT NULL, `menu_type` varchar(20) NOT NULL, `menu_order` int(2) NOT NULL, `menu_desc` varchar(30) NOT NULL, `menu_icon` varchar(30) NOT NULL, `menu_image1` text NOT NULL, `menu_image2` text NOT NULL, `have_sub` varchar(3) NOT NULL, `parent_menu_id` int(2) NOT NULL, `sub_level` int(2) NOT NULL, `page_desc` varchar(30) NOT NULL, `page_file` varchar(30) NOT NULL, `page_title` varchar(100) NOT NULL, `page_meta_desc` varchar(200) NOT NULL, `page_meta_keywords` varchar(200) NOT NULL, `body_class` varchar(30) NOT NULL, `menu_status` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `menu_main` -- INSERT INTO `menu_main` (`menu_id`, `menu_type`, `menu_order`, `menu_desc`, `menu_icon`, `menu_image1`, `menu_image2`, `have_sub`, `parent_menu_id`, `sub_level`, `page_desc`, `page_file`, `page_title`, `page_meta_desc`, `page_meta_keywords`, `body_class`, `menu_status`) VALUES (1, 'Main', 1, 'About', '', '', '', 'No', 0, 0, 'About us', 'about.php', 'About us', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (2, 'Main', 2, 'Products', '', '', '', 'Yes', 0, 0, 'Products', '#', 'Products', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (3, 'Main', 3, 'Gallery', '', '', '', 'Yes', 0, 0, 'Gallery', '#', 'Gallery', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (4, 'Main', 4, 'Contact us', '', '', '', 'No', 0, 0, 'Contact us', 'contact.php', 'Contact us', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (5, 'Main', 1, 'Construction', '', '', '', 'Yes', 2, 1, 'Construction', 'construction.php', 'Construction', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (6, 'Main', 2, 'Formwork', '', '', '', 'Yes', 2, 1, 'Formwork', 'formwork.php', 'Formwork', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (7, 'Main', 3, 'Scaffolding', '', '', '', 'Yes', 2, 1, 'Scaffolding', 'scaffolding.php', 'Scaffolding', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (8, 'Main', 4, 'Automobile', '', '', '', 'Yes', 2, 1, 'Automobile', 'automobile.php', 'Automobile', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (9, 'Main', 5, 'Industrial', '', '', '', 'Yes', 2, 1, 'Industrial', 'indu-battens.php', 'Industrial', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (10, 'Main', 6, 'Interiors', '', '', '', 'Yes', 2, 1, 'Interiors', 'interiors.php', 'Interiors', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (11, 'Main', 7, 'Packing', '', '', '', 'Yes', 2, 1, 'Packing', 'packing.php', 'Packing', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (12, 'Main', 8, 'Doors', '', '', '', 'Yes', 2, 1, 'Doors', 'doors.php', 'Doors', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (13, 'Main', 9, 'Pallet', '', '', '', 'Yes', 2, 1, 'Pallet', 'prod-pallet.php', 'Pallet', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (14, 'Main', 1, 'Shuttering Plywood', '', '', '', 'No', 5, 2, 'Shuttering Plywood', 'cons-shutteringply.php', 'Shuttering Plywood', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (15, 'Main', 2, 'Calibrated Sheathing Sheet', '', '', '', 'No', 5, 2, 'Calibrated Sheathing Sheet', 'cons-calibrated-sheathing.php', 'Calibrated Sheathing Sheet', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (16, 'Main', 3, 'Film Face Birch Plywood', '', '', '', 'No', 5, 2, 'Film Face Birch Plywood', 'cons-birch-plywood.php', 'Film Face Birch Plywood', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (17, 'Main', 4, 'WPC Sheathing Sheet', '', '', '', 'No', 5, 2, 'WPC Sheathing Sheet', 'cons-wpc-sheathing.php', 'WPC Sheathing Sheet', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (18, 'Main', 5, 'Plastic Coated Sheet', '', '', '', 'No', 5, 2, 'Plastic Coated Sheet', 'cons-plastic-coated.php', 'Plastic Coated Sheet', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (19, 'Main', 6, 'Laminated Veener Lumber', '', '', '', 'No', 5, 2, 'Laminated Veener Lumber', 'cons-lvl.php', 'Laminated Veener Lumber', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (20, 'Main', 7, 'Formwork Beams', '', '', '', 'No', 5, 2, 'Formwork Beams', 'cons-hbeam.php', 'Formwork Beams', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (21, 'Main', 8, 'Pine Wood Battens', '', '', '', 'No', 5, 2, 'Pine Wood Battens', 'cons-pinewood.php', 'Pine Wood Battens', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (22, 'Main', 1, 'Wall & column Formwork', '', '', '', 'No', 6, 2, 'Wall & column Formwork', 'frmk-wall-column.php', 'Wall & column Formwork', 'Sharpply-Variant Formwork and Scaffolding for Building Construction, Cost effective, Durable, Efficient and User friendly products.', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (23, 'Main', 2, 'Slab Formwork', '', '', '', 'No', 6, 2, 'Slab Formwork', 'frmk-slab.php', 'Slab Formwork', 'Sharpply-Variant Formwork and Scaffolding for Building Construction, Cost effective, Durable, Efficient and User friendly products.', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (24, 'Main', 3, 'Climbing Formwork', '', '', '', 'No', 6, 2, 'Climbing Formwork', 'frmk-climbing.php', 'Climbing Formwork', 'Sharpply-Variant Formwork and Scaffolding for Building Construction, Cost effective, Durable, Efficient and User friendly products.', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (25, 'Main', 4, 'Special Formwork', '', '', '', 'No', 6, 2, 'Special Formwork', 'frmk-special.php', 'Special Formwork', 'Sharpply-Variant Formwork and Scaffolding for Building Construction, Cost effective, Durable, Efficient and User friendly products.', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (26, 'Main', 5, 'Safety System', '', '', '', 'No', 6, 2, 'Safety System', 'frmk-safety.php', 'Safety System', 'Sharpply-Variant Formwork and Scaffolding for Building Construction, Cost effective, Durable, Efficient and User friendly products.', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (27, 'Main', 1, 'Top Tower 40', '', '', '', 'No', 7, 2, 'Top Tower 40', 'scpf-load-bearing-tt40.php', 'Top Tower 40', 'Sharpply-Variant Formwork and Scaffolding for Building Construction, Cost effective, Durable, Efficient and User friendly products.', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (28, 'Main', 2, 'Top Tower 60', '', '', '', 'No', 7, 2, 'Top Tower 60', 'scpf-load-bearing-tt70.php', 'Top Tower 60', 'Sharpply-Variant Formwork and Scaffolding for Building Construction, Cost effective, Durable, Efficient and User friendly products.', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (29, 'Main', 3, 'Top Tower 100', '', '', '', 'No', 7, 2, 'Top Tower 100', 'scpf-load-bearing-tt100.php', 'Top Tower 100', 'Sharpply-Variant Formwork and Scaffolding for Building Construction, Cost effective, Durable, Efficient and User friendly products.', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (30, 'Main', 1, 'Compressed Chequered Flooring', '', '', '', 'No', 8, 2, 'Compressed Chequered Flooring', 'producauto-checkflooring.php', 'Compressed Chequered Flooring', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (31, 'Main', 2, 'Compressed Truck Flooring', '', '', '', 'No', 8, 2, 'Compressed Truck Flooring', 'auto-trukflooring.php', 'Compressed Truck Flooring', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (32, 'Main', 3, 'Container Flooring', '', '', '', 'No', 8, 2, 'Container Flooring', 'auto-contflloring.php', 'Container Flooring', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (33, 'Main', 4, 'Fire Retardant Plywood', '', '', '', 'No', 8, 2, 'Fire Retardant Plywood', 'auto-frplywood.php', 'Fire Retardant Plywood', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (34, 'Main', 5, 'Alluminium-claded Chequered Fl', '', '', '', 'No', 8, 2, 'Alluminium-claded Chequered Fl', 'auto-alluflooring.php', 'Alluminium-claded Chequered Flooring', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (35, 'Main', 1, 'Plywood Battens and Dies', '', '', '', 'No', 9, 2, 'Plywood Battens and Dies', 'indu-battens.php', 'Plywood Battens and Dies', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (36, 'Main', 1, 'Commercial Plywood', '', '', '', 'No', 10, 2, 'Commercial Plywood', 'inte-commercial.php', 'Commercial Plywood', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (37, 'Main', 2, 'Block Boards', '', '', '', 'No', 10, 2, 'Block Boards', 'inte-blockboard.php', 'Block Boards', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (38, 'Main', 3, 'Moisture and Boiling Water Pro', '', '', '', 'No', 10, 2, 'Moisture and Boiling Water Pro', 'inte-mrbr.php', 'Moisture and Boiling Water Proof Plywood', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (39, 'Main', 4, 'Pre laminated Plywood', '', '', '', 'No', 10, 2, 'Pre laminated Plywood', 'inte-prelam.php', 'Pre laminated Plywood', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (40, 'Main', 5, 'Birch Plywood', '', '', '', 'No', 10, 2, 'Birch Plywood', 'inte-birchply.php', 'Birch Plywood', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (41, 'Main', 6, 'Other Plywoods', '', '', '', 'No', 10, 2, 'Other Plywoods', 'inte-otherply.php', 'Other Plywoods', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (42, 'Main', 1, 'Packing Plywood', '', '', '', 'No', 11, 2, 'Packing Plywood', 'pack-plywood.php', 'Packing Plywood', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (43, 'Main', 2, 'Pine Wood Battens', '', '', '', 'No', 11, 2, 'Pine Wood Battens', 'pack-battens.php', 'Pine Wood Battens', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (44, 'Main', 1, 'ECP Door and Window Frames', '', '', '', 'No', 12, 2, 'ECP Door and Window Frames', 'door-ecp.php', 'ECP Door and Window Frames', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (45, 'Main', 2, 'Aditya Veneer Doors', '', '', '', 'No', 12, 2, 'Aditya Veneer Doors', 'door-veneer.php', 'Aditya Veneer Doors', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (46, 'Main', 3, 'Moulded Panel Door', '', '', '', 'No', 12, 2, 'Moulded Panel Door', 'door-panel.php', 'Moulded Panel Door', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (47, 'Main', 4, 'Decorative PVC Door', '', '', '', 'No', 12, 2, 'Decorative PVC Door', 'door-decopvc.php', 'Decorative PVC Door', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (48, 'Main', 5, 'Veneer Moulded Panel Door', '', '', '', 'No', 12, 2, 'Veneer Moulded Panel Door', 'door-moulded.php', 'Veneer Moulded Panel Door', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (49, 'Main', 6, 'Pre Stained Doors', '', '', '', 'No', 12, 2, 'Pre Stained Doors', 'door-prestained.php', 'Pre Stained Doors', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (50, 'Main', 7, 'Flush Doors', '', '', '', 'No', 12, 2, 'Flush Doors', 'door-flush.php', 'Flush Doors', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (51, 'Main', 8, 'Fire Retardent Doors', '', '', '', 'No', 12, 2, 'Fire Retardent Doors', 'door-frdoor.php', 'Fire Retardent Doors', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (52, 'Main', 9, 'Core Content', '', '', '', 'No', 12, 2, 'Core Content', 'door-core.php', 'Core Content', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (53, 'Main', 10, 'Pre-hung Doors', '', '', '', 'No', 12, 2, 'Pre-hung Doors', 'door-prehung.php', 'Pre-hung Doors', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (54, 'Main', 1, 'Production Pallet', '', '', '', 'No', 13, 2, 'Production Pallet', 'prod-pallet.php', 'Production Pallet', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (55, 'Main', 1, 'Exihibitions', '', '', '', 'No', 3, 1, 'Exhibitions', 'exhibition.php', 'Exhibitions', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'), (56, 'Main', 2, 'News', '', '', '', 'No', 3, 1, 'News', 'news.php', 'News', 'Sharp Ply, Formwork to Finish one stop solution, poineer in introducting new products and technologies for Construction Industry', 'Sharp Ply, Formwork to Finish, Construction Formwork, LVL, Lumber, Plywood, Doors, Compressed Wooden Floor Board, Scaffolding, Laminated Veener', '', 'Active'); -- -------------------------------------------------------- -- -- Table structure for table `news_list` -- CREATE TABLE `news_list` ( `news_id` int(6) NOT NULL, `news_date` date NOT NULL, `news_image` text NOT NULL, `news_status` varchar(20) NOT NULL, `news_log` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `news_list` -- INSERT INTO `news_list` (`news_id`, `news_date`, `news_image`, `news_status`, `news_log`) VALUES (1, '2018-01-01', '55.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (2, '2018-01-01', '56.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (3, '2018-01-01', '57.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (4, '2018-01-01', '58.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (5, '2018-01-01', '59.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (6, '2018-01-01', '61.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (7, '2018-01-01', '62.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (8, '2018-01-01', '63.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (10, '2018-01-01', '66.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (11, '2018-01-01', '67.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (12, '2018-01-01', '68.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (13, '2018-01-01', '69.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (14, '2018-01-01', '70.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (17, '2018-01-01', '201811-1537928144.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (18, '2018-01-01', '201811-1537928942.jpg', 'Active', '# News added on 26-09-2018 10:00 by Admin;'), (19, '2018-10-01', '2018101-1541261375.jpeg', 'Active', '# News added on 2018-11-03 by Kiran; '), (20, '2018-03-29', '2018329-1541261429.jpg', 'Active', '# News added on 2018-11-03 by Kiran; '); -- -------------------------------------------------------- -- -- Table structure for table `organisation` -- CREATE TABLE `organisation` ( `org_id` int(11) NOT NULL, `org_name` varchar(200) NOT NULL, `org_shortname` varchar(20) NOT NULL, `org_logo_round` varchar(20) NOT NULL, `org_logo_2` varchar(20) NOT NULL, `org_logo_3` varchar(20) NOT NULL, `org_address` varchar(1000) NOT NULL, `org_city` varchar(100) NOT NULL, `org_city_pin` int(6) NOT NULL, `org_mob_number_1` varchar(14) NOT NULL, `org_mob_number_2` varchar(14) NOT NULL, `org_land_number_1` varchar(14) NOT NULL, `org_land_number_2` varchar(14) NOT NULL, `org_email_1` varchar(50) NOT NULL, `org_email_2` varchar(50) NOT NULL, `org_gst_number` varchar(15) NOT NULL, `org_bank_account` varchar(1000) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `organisation` -- INSERT INTO `organisation` (`org_id`, `org_name`, `org_shortname`, `org_logo_round`, `org_logo_2`, `org_logo_3`, `org_address`, `org_city`, `org_city_pin`, `org_mob_number_1`, `org_mob_number_2`, `org_land_number_1`, `org_land_number_2`, `org_email_1`, `org_email_2`, `org_gst_number`, `org_bank_account`) VALUES (1, 'Pride Energy Environment Resource Research Institute', 'PEERRI', 'logo_round_png', 'logo_small', '', '150, 1, Infantry Road, Opp. to Commissioner Office,\r\nVasanth NagarMarilingappa Extension', 'Bengaluru', 560001, '8095312222', '9341923455', '080', '080', 'info@peerri.org', '', '', 'A/c No.: 000000'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `usr_id` int(3) NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(20) NOT NULL, `name` varchar(100) NOT NULL, `designation` varchar(20) NOT NULL, `roll` varchar(20) NOT NULL, `level` int(2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`usr_id`, `username`, `password`, `name`, `designation`, `roll`, `level`) VALUES (1, 'aditya@sharpply.com', 'Aditya#2020', 'Aditya', 'Administrator', 'Administrator', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `banners` -- ALTER TABLE `banners` ADD PRIMARY KEY (`banner_id`); -- -- Indexes for table `content` -- ALTER TABLE `content` ADD PRIMARY KEY (`content_id`); -- -- Indexes for table `menu_main` -- ALTER TABLE `menu_main` ADD PRIMARY KEY (`menu_id`); -- -- Indexes for table `news_list` -- ALTER TABLE `news_list` ADD PRIMARY KEY (`news_id`); -- -- Indexes for table `organisation` -- ALTER TABLE `organisation` ADD PRIMARY KEY (`org_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`usr_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `banners` -- ALTER TABLE `banners` MODIFY `banner_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `content` -- ALTER TABLE `content` MODIFY `content_id` int(2) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `menu_main` -- ALTER TABLE `menu_main` MODIFY `menu_id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57; -- -- AUTO_INCREMENT for table `news_list` -- ALTER TABLE `news_list` MODIFY `news_id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `organisation` -- ALTER TABLE `organisation` MODIFY `org_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `usr_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;