-- phpMyAdmin SQL Dump -- version 2.6.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 04, 2010 at 06:40 PM -- Server version: 4.1.9 -- PHP Version: 4.3.10 -- -- Database: `superasia` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_catogery` -- CREATE TABLE `tbl_catogery` ( `catogery_id` int(255) NOT NULL auto_increment, `catogery_name` varchar(255) NOT NULL default '', `parent_id` int(10) NOT NULL default '0', `catogery_img` varchar(255) NOT NULL default '', `date_created` varchar(20) NOT NULL default '', `sort_id` varchar(10) NOT NULL default '', `status` varchar(10) NOT NULL default '', PRIMARY KEY (`catogery_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; -- -- Dumping data for table `tbl_catogery` -- INSERT INTO `tbl_catogery` VALUES (2, 'Washing Machines', 0, 'menu__26.jpg', '2010-01-01 04:0', '', ''); INSERT INTO `tbl_catogery` VALUES (3, 'Air conditioner', 0, 'sub_sidmenu_h.jpg', '2010-01-01 04:0', '', ''); INSERT INTO `tbl_catogery` VALUES (4, 'TCP Fans', 0, 'sub_sidmenu.jpg', '2010-01-01 04:0', '', ''); INSERT INTO `tbl_catogery` VALUES (5, 'Twin Tube', 2, '', '2010-01-01 04:2', '', ''); INSERT INTO `tbl_catogery` VALUES (6, 'Single Tube', 2, '', '2010-01-01 04:3', '', ''); INSERT INTO `tbl_catogery` VALUES (7, 'Ceiling Fan', 4, '', '2010-01-01 04:3', '', ''); INSERT INTO `tbl_catogery` VALUES (8, 'Microwave Ovens', 0, '', '2010-01-01 05:39:20', '', ''); INSERT INTO `tbl_catogery` VALUES (9, 'Room Air Cooler', 0, '', '2010-01-01 05:40:25', '', ''); INSERT INTO `tbl_catogery` VALUES (10, 'Water Dispensers', 0, '', '2010-01-01 05:40:52', '', ''); INSERT INTO `tbl_catogery` VALUES (11, 'Electric Water Coolers', 0, '', '2010-01-01 05:41:23', '', ''); INSERT INTO `tbl_catogery` VALUES (12, 'Gas Water Heaters', 0, '', '2010-01-01 05:41:45', '', ''); INSERT INTO `tbl_catogery` VALUES (13, 'Pedestal Fan', 4, '', '2010-01-01 05:52:26', '', ''); INSERT INTO `tbl_catogery` VALUES (14, 'Table Cum Pedestal Fan', 4, '', '2010-01-01 05:52:41', '', ''); INSERT INTO `tbl_catogery` VALUES (15, 'Twin Tub', 2, '', '2010-01-01 05:53:19', '', ''); INSERT INTO `tbl_catogery` VALUES (16, 'Single Tub', 2, '', '2010-01-01 05:53:39', '', ''); INSERT INTO `tbl_catogery` VALUES (17, 'Spinners', 2, '', '2010-01-01 05:54:07', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `tbl_products` -- CREATE TABLE `tbl_products` ( `products_id` int(255) NOT NULL auto_increment, `catogery_id` int(255) NOT NULL default '0', `products_title` varchar(255) NOT NULL default '', `products_limg` varchar(255) NOT NULL default '', `date_created` varchar(255) NOT NULL default '', `status` varchar(255) NOT NULL default '', `sort` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=66 ; -- -- Dumping data for table `tbl_products` -- INSERT INTO `tbl_products` VALUES (2, 3, 'SAS-09 .75 Ton Only Cold', 'ac75.jpg', '2010-01-01 05:48:28 PM', '', 0); INSERT INTO `tbl_products` VALUES (3, 3, 'SAS-12 1 Ton Hot & Cold', 'ac01.jpg', '2010-01-01 05:49:23 PM', '', 0); INSERT INTO `tbl_products` VALUES (4, 3, 'SAS-18 1.5 Ton Hot & Cold', 'ac15.jpg', '2010-01-01 05:50:05 PM', '', 0); INSERT INTO `tbl_products` VALUES (5, 3, 'SAS-24 2 Ton Hot & Cold', 'ac20.jpg', '2010-01-01 05:50:30 PM', '', 0); INSERT INTO `tbl_products` VALUES (6, 3, 'SAF-48 4 Ton Hot & Cold', 'SAF48_4ton.jpg', '2010-01-01 05:50:48 PM', '', 0); INSERT INTO `tbl_products` VALUES (7, 15, 'SA-242 Crystal Clean Wash', 'sa242.jpg', '2010-01-01 05:54:52 PM', '', 0); INSERT INTO `tbl_products` VALUES (8, 15, 'SA-245 Easy Wash', 'sa245.jpg', '2010-01-01 05:55:28 PM', '', 0); INSERT INTO `tbl_products` VALUES (9, 15, 'SA-250 Crystal Wash', 'sa250.jpg', '2010-01-01 05:55:54 PM', '', 0); INSERT INTO `tbl_products` VALUES (10, 15, 'WD-215 Jet Stream', 'wd215.jpg', '2010-01-01 05:56:14 PM', '', 0); INSERT INTO `tbl_products` VALUES (11, 16, 'SA-290 Big Wash', 'sa290.jpg', '2010-01-01 05:56:37 PM', '', 0); INSERT INTO `tbl_products` VALUES (12, 16, 'SA-240 Super Wash', 'sa240.jpg', '2010-01-01 05:57:00 PM', '', 0); INSERT INTO `tbl_products` VALUES (13, 16, 'SA-260 Plus Hi Wash', 'sa260.jpg', '2010-01-01 05:57:20 PM', '', 0); INSERT INTO `tbl_products` VALUES (14, 16, 'SA-255 Rapid Wash', 'sa255.jpg', '2010-01-01 05:57:57 PM', '', 0); INSERT INTO `tbl_products` VALUES (15, 16, 'SA-218 Saver Wash', 'sa218.jpg', '2010-01-01 05:58:15 PM', '', 0); INSERT INTO `tbl_products` VALUES (16, 16, 'SA-222 Perfect Wash', 'sa222.jpg', '2010-01-01 05:58:33 PM', '', 0); INSERT INTO `tbl_products` VALUES (17, 16, 'SA-220 Ideal Wash', 'sa220.jpg', '2010-01-01 05:58:51 PM', '', 0); INSERT INTO `tbl_products` VALUES (18, 16, 'SA-233 Speed Wash', 'sa233.jpg', '2010-01-01 05:59:14 PM', '', 0); INSERT INTO `tbl_products` VALUES (19, 16, 'SA-210 Quick Wash', 'sa210.jpg', '2010-01-01 05:59:36 PM', '', 0); INSERT INTO `tbl_products` VALUES (20, 16, 'SAS-15 Steel Body', 'sas15.jpg', '2010-01-01 05:59:50 PM', '', 0); INSERT INTO `tbl_products` VALUES (21, 16, 'SAP-315 Ideal Comfort', 'sap315.jpg', '2010-01-01 06:00:09 PM', '', 0); INSERT INTO `tbl_products` VALUES (22, 16, 'SAP-320 Wash Thrill', 'sap320.jpg', '2010-01-01 06:00:35 PM', '', 0); INSERT INTO `tbl_products` VALUES (23, 16, 'SAP-400 Super Family Wash', 'sap400.jpg', '2010-01-01 06:01:03 PM', '', 0); INSERT INTO `tbl_products` VALUES (24, 17, 'SD-518 Saver Spin', 'sd518.jpg', '2010-01-01 06:01:37 PM', '', 0); INSERT INTO `tbl_products` VALUES (25, 17, 'SD-522 Perfect Spin', 'sd522.jpg', '2010-01-01 06:01:57 PM', '', 0); INSERT INTO `tbl_products` VALUES (26, 17, 'SD-550 Easy Spin', 'sd550.jpg', '2010-01-01 06:02:15 PM', '', 0); INSERT INTO `tbl_products` VALUES (27, 17, 'SD-520 Turbo Spin', 'sd520.jpg', '2010-01-01 06:02:40 PM', '', 0); INSERT INTO `tbl_products` VALUES (28, 17, 'SD-555 Super Spin', 'sd555.jpg', '2010-01-01 06:03:00 PM', '', 0); INSERT INTO `tbl_products` VALUES (29, 17, 'SDS-520 Steel Body', 'sds520.jpg', '2010-01-01 06:04:20 PM', '', 0); INSERT INTO `tbl_products` VALUES (30, 7, 'Classic Model', '', '2010-01-02 01:50:16 PM', '', 0); INSERT INTO `tbl_products` VALUES (31, 7, 'Tulip Model', '', '2010-01-02 01:50:31 PM', '', 0); INSERT INTO `tbl_products` VALUES (32, 7, 'Antique Model', 'antique_model.jpg', '2010-01-02 01:50:47 PM', '', 0); INSERT INTO `tbl_products` VALUES (33, 7, 'Pretty Model', 'pretty_model.jpg', '2010-01-02 01:51:02 PM', '', 0); INSERT INTO `tbl_products` VALUES (34, 7, 'Fancy Model', 'fancy_model.jpg', '2010-01-02 01:51:16 PM', '', 0); INSERT INTO `tbl_products` VALUES (35, 7, 'Saver Model', '', '2010-01-02 01:51:40 PM', '', 0); INSERT INTO `tbl_products` VALUES (36, 7, 'Grand Model', 'grand_model.jpg', '2010-01-02 01:51:56 PM', '', 0); INSERT INTO `tbl_products` VALUES (37, 7, 'Crystal Model', 'crystal_model.jpg', '2010-01-02 01:52:10 PM', '', 0); INSERT INTO `tbl_products` VALUES (38, 7, 'Alpha Model', 'alpha_model.jpg', '2010-01-02 01:52:22 PM', '', 0); INSERT INTO `tbl_products` VALUES (39, 13, 'Delux Model', '', '2010-01-02 01:52:56 PM', '', 0); INSERT INTO `tbl_products` VALUES (40, 13, 'Standard Model', '', '2010-01-02 01:53:12 PM', '', 0); INSERT INTO `tbl_products` VALUES (41, 13, 'Delta Model', '', '2010-01-02 01:53:27 PM', '', 0); INSERT INTO `tbl_products` VALUES (42, 14, 'TCP Fan', 'tcp.jpg', '2010-01-02 01:53:49 PM', '', 0); INSERT INTO `tbl_products` VALUES (43, 14, 'Table Fan', 'table_fan.jpg', '2010-01-02 01:54:03 PM', '', 0); INSERT INTO `tbl_products` VALUES (44, 14, 'Bracket Fan', 'bracket_fan.jpg', '2010-01-02 01:54:25 PM', '', 0); INSERT INTO `tbl_products` VALUES (45, 14, 'Louver Fan', 'louver_fan.jpg', '2010-01-02 01:54:51 PM', '', 0); INSERT INTO `tbl_products` VALUES (46, 14, 'Circumatic Fan', 'circumatic_fan.jpg', '2010-01-02 01:55:11 PM', '', 0); INSERT INTO `tbl_products` VALUES (47, 14, 'Exhaust Fan Metal', 'metal_exhaust.jpg', '2010-01-02 01:55:49 PM', '', 0); INSERT INTO `tbl_products` VALUES (48, 14, 'Exhaust Fan Plastic', 'plastic_exhaust.jpg', '2010-01-02 01:56:14 PM', '', 0); INSERT INTO `tbl_products` VALUES (49, 14, 'Exhaust Fan Vent. G.Type', '', '2010-01-02 01:56:37 PM', '', 0); INSERT INTO `tbl_products` VALUES (50, 12, 'Gas Water Heater', 'gas_wheater.jpg', '2010-01-02 01:57:05 PM', '', 0); INSERT INTO `tbl_products` VALUES (51, 12, 'Electric Water Heater', 'elec_wheater.jpg', '2010-01-02 01:57:18 PM', '', 0); INSERT INTO `tbl_products` VALUES (52, 10, 'HC-20', 'hc20.jpg', '2010-01-02 01:58:19 PM', '', 0); INSERT INTO `tbl_products` VALUES (53, 10, 'HC-25', 'hc25.jpg', '2010-01-02 01:58:34 PM', '', 0); INSERT INTO `tbl_products` VALUES (54, 10, 'HC-33', 'hc33.jpg', '2010-01-02 01:58:54 PM', '', 0); INSERT INTO `tbl_products` VALUES (55, 11, 'SA-WC-60', '', '2010-01-02 01:59:27 PM', '', 0); INSERT INTO `tbl_products` VALUES (56, 11, 'SA-WC-40', 'sawc40.jpg', '2010-01-02 01:59:40 PM', '', 0); INSERT INTO `tbl_products` VALUES (57, 9, 'Jet Cool 1000', 'jet1000.jpg', '2010-01-02 02:00:19 PM', '', 0); INSERT INTO `tbl_products` VALUES (58, 9, 'Jet Cool 3000', 'jet3000.jpg', '2010-01-02 02:00:31 PM', '', 0); INSERT INTO `tbl_products` VALUES (59, 9, 'ECM 2500 Quick Cool', 'ecm2500.jpg', '2010-01-02 02:00:52 PM', '', 0); INSERT INTO `tbl_products` VALUES (60, 9, 'ECM 4000 Heat Hunter', 'ecm4000.jpg', '2010-01-02 02:01:05 PM', '', 0); INSERT INTO `tbl_products` VALUES (61, 9, 'RAC 450 (Plastic & Mattel) Desert Bush', 'rac450m.jpg', '2010-01-02 02:01:36 PM', '', 0); INSERT INTO `tbl_products` VALUES (62, 8, 'SM-124', 'sm123.jpg', '2010-01-02 02:01:54 PM', '', 0); INSERT INTO `tbl_products` VALUES (63, 8, 'SM-137', '', '2010-01-02 02:02:08 PM', '', 0); INSERT INTO `tbl_products` VALUES (64, 8, 'SM-136 DGM', 'sm136dgm.jpg', '2010-01-02 02:02:22 PM', '', 0); INSERT INTO `tbl_products` VALUES (65, 8, 'SM-151 DG', 'sm151dg.jpg', '2010-01-02 02:02:41 PM', '', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_user` -- CREATE TABLE `tbl_user` ( `user_id` int(10) unsigned NOT NULL auto_increment, `user_name` varchar(20) NOT NULL default '', `user_password` varchar(32) NOT NULL default '', `user_regdate` datetime NOT NULL default '0000-00-00 00:00:00', `user_last_login` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`user_id`), UNIQUE KEY `user_name` (`user_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `tbl_user` -- INSERT INTO `tbl_user` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '2005-02-20 17:35:44', '2010-01-02 16:01:39');