· 7 years ago · Feb 23, 2019, 02:42 PM
1-- phpMyAdmin SQL Dump -- version 4.1.12 -- -- -- Host: 20.0.0.2 -- Generation Time: Apr 13, 2016 at 09:47 AM -- Server version: 5.6.16 -- PHP Version: 5.4.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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 utf8 */; -- -- Database: `transfigure` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `pass` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `name`, `pass`) VALUES (1, 'admin', '3d6763c3d71a5097cc04be5c4cc232a812990171'); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE IF NOT EXISTS `category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `maincat_id` int(11) NOT NULL, `cat_name` text NOT NULL, `colors` int(11) NOT NULL, `size` int(11) NOT NULL, `rewards` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `category` -- INSERT INTO `category` (`id`, `maincat_id`, `cat_name`, `colors`, `size`, `rewards`, `ordr`, `visible`) VALUES (1, 2, 'Women''s Fashion & Clothing ', 1, 1, 1, 1, 1), (4, 2, 'Men''s Fashion & Clothing ', 1, 1, 0, 2, 1), (5, 2, 'Kids'' Clothing ', 0, 1, 0, 3, 1), (6, 2, 'Fashion Handbags & Accessories ', 0, 1, 1, 4, 1); -- -------------------------------------------------------- -- -- Table structure for table `cat_banner` -- CREATE TABLE IF NOT EXISTS `cat_banner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cat_id` int(11) NOT NULL, `image_1` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `cat_banner` -- INSERT INTO `cat_banner` (`id`, `cat_id`, `image_1`, `ordr`, `visible`) VALUES (1, 1, 1, 1, 1), (2, 1, 3, 2, 1), (3, 1, 4, 3, 1), (4, 1, 5, 4, 1); -- -------------------------------------------------------- -- -- Table structure for table `cat_offers` -- CREATE TABLE IF NOT EXISTS `cat_offers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `flash` int(11) NOT NULL, `offer_from` text NOT NULL, `offer_to` text NOT NULL, `offer_type` int(11) NOT NULL, `offer_val` text NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `cat_offers` -- INSERT INTO `cat_offers` (`id`, `flash`, `offer_from`, `offer_to`, `offer_type`, `offer_val`, `ordr`, `visible`) VALUES (2, 1, '1444797000', '1444867200', 1, '5', 1, 0), (3, 1, '1444797000', '1445385600', 1, '40', 2, 0), (4, 1, '1445315400', '1445904000', 1, '80', 3, 0), (5, 0, '1444797000', '1444910400', 1, '50', 4, 0), (6, 1, '1444887000', '1444953600', 1, '45', 5, 0); -- -------------------------------------------------------- -- -- Table structure for table `cat_offers_val` -- CREATE TABLE IF NOT EXISTS `cat_offers_val` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cat_o_id` int(11) NOT NULL, `cat` int(11) NOT NULL, `sub_cat` int(11) NOT NULL, `parent_subcat` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ; -- -- Dumping data for table `cat_offers_val` -- INSERT INTO `cat_offers_val` (`id`, `cat_o_id`, `cat`, `sub_cat`, `parent_subcat`) VALUES (51, 2, 1, 0, 0), (52, 2, 4, 0, 0), (53, 2, 0, 2, 0), (54, 3, 1, 0, 0), (55, 3, 4, 0, 0), (56, 3, 0, 2, 0), (57, 3, 0, 3, 0), (58, 3, 0, 4, 0), (59, 3, 0, 0, 2), (60, 4, 1, 0, 0), (61, 4, 0, 2, 0), (62, 4, 0, 0, 2), (63, 5, 5, 0, 0), (64, 5, 0, 13, 0), (65, 5, 0, 0, 13), (69, 6, 1, 0, 0), (70, 6, 0, 2, 0), (71, 6, 0, 0, 2); -- -------------------------------------------------------- -- -- Table structure for table `color` -- CREATE TABLE IF NOT EXISTS `color` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `image_1` int(11) NOT NULL, `cat_id` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `color` -- INSERT INTO `color` (`id`, `name`, `image_1`, `cat_id`, `ordr`, `visible`) VALUES (2, 'Black', 17, 1, 1, 1), (3, 'Red', 19, 1, 2, 1); -- -------------------------------------------------------- -- -- Table structure for table `country` -- CREATE TABLE IF NOT EXISTS `country` ( `iso` char(2) NOT NULL, `name` varchar(80) NOT NULL, `printable_name` varchar(80) NOT NULL, `iso3` char(3) DEFAULT NULL, `numcode` smallint(6) DEFAULT NULL, PRIMARY KEY (`iso`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `country` -- INSERT INTO `country` (`iso`, `name`, `printable_name`, `iso3`, `numcode`) VALUES ('AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4), ('AL', 'ALBANIA', 'Albania', 'ALB', 8), ('DZ', 'ALGERIA', 'Algeria', 'DZA', 12), ('AD', 'ANDORRA', 'Andorra', 'AND', 20), ('AO', 'ANGOLA', 'Angola', 'AGO', 24), ('AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28), ('AR', 'ARGENTINA', 'Argentina', 'ARG', 32), ('AM', 'ARMENIA', 'Armenia', 'ARM', 51), ('AU', 'AUSTRALIA', 'Australia', 'AUS', 36), ('AT', 'AUSTRIA', 'Austria', 'AUT', 40), ('AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31), ('BS', 'BAHAMAS', 'Bahamas', 'BHS', 44), ('BH', 'BAHRAIN', 'Bahrain', 'BHR', 48), ('BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50), ('BB', 'BARBADOS', 'Barbados', 'BRB', 52), ('BY', 'BELARUS', 'Belarus', 'BLR', 112), ('BE', 'BELGIUM', 'Belgium', 'BEL', 56), ('BZ', 'BELIZE', 'Belize', 'BLZ', 84), ('BJ', 'BENIN', 'Benin', 'BEN', 204), ('BM', 'BERMUDA', 'Bermuda', 'BMU', 60), ('BT', 'BHUTAN', 'Bhutan', 'BTN', 64), ('BO', 'BOLIVIA', 'Bolivia', 'BOL', 68), ('BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70), ('BW', 'BOTSWANA', 'Botswana', 'BWA', 72), ('BR', 'BRAZIL', 'Brazil', 'BRA', 76), ('BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96), ('BG', 'BULGARIA', 'Bulgaria', 'BGR', 100), ('BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854), ('BI', 'BURUNDI', 'Burundi', 'BDI', 108), ('KH', 'CAMBODIA', 'Cambodia', 'KHM', 116), ('CM', 'CAMEROON', 'Cameroon', 'CMR', 120), ('CA', 'CANADA', 'Canada', 'CAN', 124), ('CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132), ('KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136), ('CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140), ('TD', 'CHAD', 'Chad', 'TCD', 148), ('CL', 'CHILE', 'Chile', 'CHL', 152), ('CN', 'CHINA', 'China', 'CHN', 156), ('CO', 'COLOMBIA', 'Colombia', 'COL', 170), ('KM', 'COMOROS', 'Comoros', 'COM', 174), ('CG', 'CONGO (CG)', 'Congo', 'COG', 178), ('CD', 'CONGO (CD)', 'Congo, the Democratic Republic of the', 'COD', 180), ('CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188), ('CI', 'COTE D''IVOIRE', 'Cote D''Ivoire', 'CIV', 384), ('HR', 'CROATIA', 'Croatia', 'HRV', 191), ('CU', 'CUBA', 'Cuba', 'CUB', 192), ('CY', 'CYPRUS', 'Cyprus', 'CYP', 196), ('CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203), ('DK', 'DENMARK', 'Denmark', 'DNK', 208), ('DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262), ('DM', 'DOMINICA', 'Dominica', 'DMA', 212), ('DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214), ('EC', 'ECUADOR', 'Ecuador', 'ECU', 218), ('EG', 'EGYPT', 'Egypt', 'EGY', 818), ('SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222), ('GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226), ('ER', 'ERITREA', 'Eritrea', 'ERI', 232), ('EE', 'ESTONIA', 'Estonia', 'EST', 233), ('ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231), ('FJ', 'FIJI', 'Fiji', 'FJI', 242), ('FI', 'FINLAND', 'Finland', 'FIN', 246), ('FR', 'FRANCE', 'France', 'FRA', 250), ('GA', 'GABON', 'Gabon', 'GAB', 266), ('GM', 'GAMBIA', 'Gambia', 'GMB', 270), ('GE', 'GEORGIA', 'Georgia', 'GEO', 268), ('DE', 'GERMANY', 'Germany', 'DEU', 276), ('GH', 'GHANA', 'Ghana', 'GHA', 288), ('GR', 'GREECE', 'Greece', 'GRC', 300), ('GL', 'GREENLAND', 'Greenland', 'GRL', 304), ('GD', 'GRENADA', 'Grenada', 'GRD', 308), ('GT', 'GUATEMALA', 'Guatemala', 'GTM', 320), ('GN', 'GUINEA', 'Guinea', 'GIN', 324), ('GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624), ('GY', 'GUYANA', 'Guyana', 'GUY', 328), ('HT', 'HAITI', 'Haiti', 'HTI', 332), ('HN', 'HONDURAS', 'Honduras', 'HND', 340), ('HU', 'HUNGARY', 'Hungary', 'HUN', 348), ('IS', 'ICELAND', 'Iceland', 'ISL', 352), ('IN', 'INDIA', 'India', 'IND', 356), ('ID', 'INDONESIA', 'Indonesia', 'IDN', 360), ('IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364), ('IQ', 'IRAQ', 'Iraq', 'IRQ', 368), ('IE', 'IRELAND', 'Ireland', 'IRL', 372), ('IL', 'ISRAEL', 'Israel', 'ISR', 376), ('IT', 'ITALY', 'Italy', 'ITA', 380), ('JM', 'JAMAICA', 'Jamaica', 'JAM', 388), ('JP', 'JAPAN', 'Japan', 'JPN', 392), ('JO', 'JORDAN', 'Jordan', 'JOR', 400), ('KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398), ('KE', 'KENYA', 'Kenya', 'KEN', 404), ('KI', 'KIRIBATI', 'Kiribati', 'KIR', 296), ('KP', 'KOREA (KP)', 'Korea, Democratic People''s Republic of', 'PRK', 408), ('KR', 'KOREA (KR)', 'Korea, Republic of', 'KOR', 410), ('KW', 'KUWAIT', 'Kuwait', 'KWT', 414), ('KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417), ('LA', 'LAOS', 'Lao People''s Democratic Republic', 'LAO', 418), ('LV', 'LATVIA', 'Latvia', 'LVA', 428), ('LB', 'LEBANON', 'Lebanon', 'LBN', 422), ('LS', 'LESOTHO', 'Lesotho', 'LSO', 426), ('LR', 'LIBERIA', 'Liberia', 'LBR', 430), ('LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434), ('LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438), ('LT', 'LITHUANIA', 'Lithuania', 'LTU', 440), ('LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442), ('MO', 'MACAO', 'Macao', 'MAC', 446), ('MK', 'MACEDONIA', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807), ('MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450), ('MW', 'MALAWI', 'Malawi', 'MWI', 454), ('MY', 'MALAYSIA', 'Malaysia', 'MYS', 458), ('MV', 'MALDIVES', 'Maldives', 'MDV', 462), ('ML', 'MALI', 'Mali', 'MLI', 466), ('MR', 'MAURITANIA', 'Mauritania', 'MRT', 478), ('MU', 'MAURITIUS', 'Mauritius', 'MUS', 480), ('MX', 'MEXICO', 'Mexico', 'MEX', 484), ('FM', 'MICRONESIA', 'Micronesia, Federated States of', 'FSM', 583), ('MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498), ('MC', 'MONACO', 'Monaco', 'MCO', 492), ('MN', 'MONGOLIA', 'Mongolia', 'MNG', 496), ('MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500), ('MA', 'MOROCCO', 'Morocco', 'MAR', 504), ('MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508), ('MM', 'MYANMAR', 'Myanmar', 'MMR', 104), ('NA', 'NAMIBIA', 'Namibia', 'NAM', 516), ('NR', 'NAURU', 'Nauru', 'NRU', 520), ('NP', 'NEPAL', 'Nepal', 'NPL', 524), ('NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528), ('NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554), ('NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558), ('NE', 'NIGER', 'Niger', 'NER', 562), ('NG', 'NIGERIA', 'Nigeria', 'NGA', 566), ('NO', 'NORWAY', 'Norway', 'NOR', 578), ('OM', 'OMAN', 'Oman', 'OMN', 512), ('PK', 'PAKISTAN', 'Pakistan', 'PAK', 586), ('PS', 'PALESTINIAN TERRITORY', 'Palestinian Territory, Occupied', 'PSE', NULL), ('PA', 'PANAMA', 'Panama', 'PAN', 591), ('PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598), ('PY', 'PARAGUAY', 'Paraguay', 'PRY', 600), ('PE', 'PERU', 'Peru', 'PER', 604), ('PH', 'PHILIPPINES', 'Philippines', 'PHL', 608), ('PL', 'POLAND', 'Poland', 'POL', 616), ('PT', 'PORTUGAL', 'Portugal', 'PRT', 620), ('QA', 'QATAR', 'Qatar', 'QAT', 634), ('RO', 'ROMANIA', 'Romania', 'ROM', 642), ('RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643), ('RW', 'RWANDA', 'Rwanda', 'RWA', 646), ('SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654), ('KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659), ('LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662), ('VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670), ('WS', 'SAMOA', 'Samoa', 'WSM', 882), ('SM', 'SAN MARINO', 'San Marino', 'SMR', 674), ('ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678), ('SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682), ('SN', 'SENEGAL', 'Senegal', 'SEN', 686), ('SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690), ('SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694), ('SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703), ('SI', 'SLOVENIA', 'Slovenia', 'SVN', 705), ('SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90), ('SO', 'SOMALIA', 'Somalia', 'SOM', 706), ('ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710), ('ES', 'SPAIN', 'Spain', 'ESP', 724), ('LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144), ('SD', 'SUDAN', 'Sudan', 'SDN', 736), ('SR', 'SURINAME', 'Suriname', 'SUR', 740), ('SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748), ('SE', 'SWEDEN', 'Sweden', 'SWE', 752), ('CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756), ('SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760), ('TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158), ('TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762), ('TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834), ('TH', 'THAILAND', 'Thailand', 'THA', 764), ('TG', 'TOGO', 'Togo', 'TGO', 768), ('TO', 'TONGA', 'Tonga', 'TON', 776), ('TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780), ('TN', 'TUNISIA', 'Tunisia', 'TUN', 788), ('TR', 'TURKEY', 'Turkey', 'TUR', 792), ('TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795), ('UG', 'UGANDA', 'Uganda', 'UGA', 800), ('UA', 'UKRAINE', 'Ukraine', 'UKR', 804), ('AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784), ('GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826), ('US', 'UNITED STATES', 'United States', 'USA', 840), ('UY', 'URUGUAY', 'Uruguay', 'URY', 858), ('UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860), ('VU', 'VANUATU', 'Vanuatu', 'VUT', 548), ('VE', 'VENEZUELA', 'Venezuela', 'VEN', 862), ('VN', 'VIET NAM', 'Viet Nam', 'VNM', 704), ('YE', 'YEMEN', 'Yemen', 'YEM', 887), ('ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894), ('ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716), ('SG', 'SINGAPORE', 'Singapore', 'SGP', 702); -- -------------------------------------------------------- -- -- Table structure for table `enquiry` -- CREATE TABLE IF NOT EXISTS `enquiry` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `comments` text NOT NULL, `status` int(11) NOT NULL COMMENT '0=>Received,1=>Completed', `enq_time` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `enquiry` -- INSERT INTO `enquiry` (`id`, `user_id`, `comments`, `status`, `enq_time`) VALUES (1, 1, 'Test', 0, '1443594600'); -- -------------------------------------------------------- -- -- Table structure for table `filer` -- CREATE TABLE IF NOT EXISTS `filer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `size` int(11) NOT NULL, `time` text NOT NULL, `d` int(11) NOT NULL, `t` int(11) NOT NULL, `y` int(11) NOT NULL, `fd` text NOT NULL, `tag` text NOT NULL, `ip` text NOT NULL, `ext` varchar(11) NOT NULL, `folder` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ; -- -------------------------------------------------------- -- -- Table structure for table `filter_cat` -- CREATE TABLE IF NOT EXISTS `filter_cat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `filter_cat` -- INSERT INTO `filter_cat` (`id`, `name`, `ordr`, `visible`) VALUES (2, 'SIZE', 1, 1), (3, 'PRICE', 2, 1), (4, 'DRESS LENGTH', 3, 1), (5, 'SEASON', 4, 1), (6, 'NECKLINE', 5, 1), (7, 'PRICE', 6, 1), (8, 'COLOR', 7, 1), (10, 'SIZE', 8, 1), (11, 'OUTERWEAR TYPE', 9, 1); -- -------------------------------------------------------- -- -- Table structure for table `filter_subcat` -- CREATE TABLE IF NOT EXISTS `filter_subcat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `filter_cat` int(11) NOT NULL, `name` text NOT NULL, `image_1` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `filter_subcat` -- INSERT INTO `filter_subcat` (`id`, `filter_cat`, `name`, `image_1`, `ordr`, `visible`) VALUES (1, 4, 'Mini ', 6, 7, 1), (2, 4, 'Above Knee', 7, 8, 1), (3, 4, 'Knee-length', 8, 9, 1), (4, 6, 'V Neck', 9, 4, 1), (5, 6, 'Round Neck ', 10, 5, 1), (6, 6, 'Bateau', 11, 6, 1), (7, 8, 'Multi-color ', 16, 1, 1), (8, 8, 'Animal Print ', 14, 2, 1), (9, 8, 'Beige', 15, 3, 1); -- -------------------------------------------------------- -- -- Table structure for table `fitness` -- CREATE TABLE IF NOT EXISTS `fitness` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `address` text NOT NULL, `url` text NOT NULL, `image_1` int(11) NOT NULL, `features` text NOT NULL, `visible` int(11) NOT NULL, `ordr` int(11) NOT NULL, `del_i` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `fitness` -- INSERT INTO `fitness` (`id`, `name`, `address`, `url`, `image_1`, `features`, `visible`, `ordr`, `del_i`) VALUES (2, 'fitness test', 'No:49, Nerkundram Pathai, Dharan Singh Colony, Vadapalani, Chennai, Tamil Nadu 600026', 'www.url.in', 34, 'test \r\ntest\r\ntest', 1, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `home_banner` -- CREATE TABLE IF NOT EXISTS `home_banner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_name` text NOT NULL, `product_details` text NOT NULL, `product_url` text NOT NULL, `image_1` int(11) NOT NULL, `visible` int(11) NOT NULL, `ordr` int(11) NOT NULL, `del_i` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `home_banner` -- INSERT INTO `home_banner` (`id`, `product_name`, `product_details`, `product_url`, `image_1`, `visible`, `ordr`, `del_i`) VALUES (3, 'sample', 'new sample poosrkejrkndxnfnewnenxclldas mqwperjkpqw edmcpdfeopjsndcasdada', 'www.url.com', 32, 1, 2, 0), (4, 'second', 'Before starting to write an article on a journal, it helps to keep a few things in mind.\r\n\r\nFirst, search for the journal''s article on Wikipedia. It might already exist under a slightly different name than you were expecting.\r\nSecond, make sure the journal is notable according to our notability guidelines, otherwise it will probably be deleted. A journal will usually be considered notable if at least one of the three following criteria are met:\r\nThe journal is considered by reliable sources to be influential in its subject area.\r\nThe journal is frequently cited by other reliable sources.\r\nThe journal has a historic purpose or has a significant history.\r\nThis makes it hard for newly established journals to get an article on Wikipedia, as they usually have not had time to become influential journals. As a rule of thumb, if a journal is indexed in major databases in its field, or has an impact factor, this will be enough to establish notability.\r\nWriting an article about a journal usually is easier if you have an issue of the journal next to you, or the journal''s website loaded in your browser, or both.\r\nTracking down the history of a journal can be a bit complicated. Merges, splits, renaming, etc... are sometimes mentioned on the website, but are often omitted. The National Library of Australia''s catalogue is a good place to look for such information. However library catalogs can sometimes provide clues, but care should be exercised, as such catalogs are often outdated and may contain errors.', 'https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Academic_Journals/Writing_guide', 33, 1, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `image` -- CREATE TABLE IF NOT EXISTS `image` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image_name` text NOT NULL, `time` text NOT NULL, `d` int(11) NOT NULL, `t` int(11) NOT NULL, `y` int(11) NOT NULL, `fd` text NOT NULL, `tag` text NOT NULL, `ip` text NOT NULL, `type` varchar(11) NOT NULL, `width` int(11) NOT NULL, `height` int(11) NOT NULL, `folder` varchar(50) NOT NULL, `act_height` int(11) NOT NULL, `act_width` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ; -- -- Dumping data for table `image` -- INSERT INTO `image` (`id`, `image_name`, `time`, `d`, `t`, `y`, `fd`, `tag`, `ip`, `type`, `width`, `height`, `folder`, `act_height`, `act_width`) VALUES (1, 'LITB_c33709_78352_f5_cp_en.jpg', '1443593114', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 992, 320, 'cat_banner', 320, 992), (2, 'LITB_c33709_78352_f5_cp_en.jpg', '1443593333', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 992, 320, 'cat_banner', 320, 992), (3, 'LITB_c4704_78853_f1_cp_1_en.jpg', '1443593678', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 992, 320, 'cat_banner', 320, 992), (4, 'LITB_c71_78580_f6_cp_2_en.jpg', '1443593694', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 992, 320, 'cat_banner', 320, 992), (5, 'LITB_c4704_78853_f1_cp_1_en.jpg', '1443593823', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 992, 320, 'cat_banner', 320, 992), (6, 'mini.jpg', '1443594524', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 50, 50), (7, 'aboveknee.jpg', '1443594754', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 50, 50), (8, 'kneelength.jpg', '1443594782', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 50, 50), (9, 'vneck.jpg', '1443594882', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 50, 50), (10, 'roundneck.jpg', '1443594910', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 50, 50), (11, 'bateau.jpg', '1443594933', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 50, 50), (12, 'multi_color.jpg', '1443595022', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 16, 16), (13, 'multi_color.jpg', '1443595037', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 16, 16), (14, 'animalprint.jpg', '1443595062', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 16, 16), (15, 'beige1.jpg', '1443595083', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 16, 16), (16, 'multi_color.jpg', '1443595092', 30, 0, 2015, '30-09-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'filters', 16, 16), (17, '', '1443695040', 1, 0, 2015, '01-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'color', 16, 16), (18, '', '1443695055', 1, 0, 2015, '01-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'color', 16, 16), (19, '', '1443695068', 1, 0, 2015, '01-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 50, 50, 'color', 16, 16), (20, '', '1444287954', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 600, 800), (21, '', '1444287997', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 600, 800), (22, '', '1444288021', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 600, 800), (23, '', '1444288059', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 600, 800), (24, '', '1444288126', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 600, 800), (25, '', '1444288190', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 600, 800), (26, '', '1444289574', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 16, 16), (27, '', '1444289642', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 16, 16), (28, '', '1444296889', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 50, 50), (29, '', '1444296996', 8, 0, 2015, '08-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 600, 600, 'product_gallery', 600, 800), (30, '', '1444383107', 9, 0, 2015, '09-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 640, 561, 'product_more', 561, 640), (31, '', '1444383198', 9, 0, 2015, '09-10-2015', '', 'fe80::854a:1b0b:3bc7:fd05', '.jpeg', 640, 561, 'product_more', 561, 640), (32, '', '1460525739', 13, 0, 2016, '13-04-2016', '', '20.0.0.151', '.jpeg', 750, 750, 'images', 768, 1366), (33, '', '1460526168', 13, 0, 2016, '13-04-2016', '', '20.0.0.151', '.jpeg', 750, 750, 'images', 768, 1366), (34, '', '1460526781', 13, 0, 2016, '13-04-2016', '', '20.0.0.151', '.jpeg', 750, 750, 'images', 768, 1366); -- -------------------------------------------------------- -- -- Table structure for table `logger` -- CREATE TABLE IF NOT EXISTS `logger` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` text NOT NULL, `ip` text NOT NULL, `message` text NOT NULL, `type` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ; -- -- Dumping data for table `logger` -- INSERT INTO `logger` (`id`, `date`, `ip`, `message`, `type`) VALUES (1, '1443594486', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (2, '1443676076', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (3, '1443693881', '20.0.0.105', 'Login:admin,naveen', 2), (4, '1444020608', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (5, '1444214233', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (6, '1444280477', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (7, '1444366093', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (8, '1444370281', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (9, '1444375804', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (10, '1444375807', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (11, '1444375810', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (12, '1444375832', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (13, '1444375850', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (14, '1444375855', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (15, '1444375863', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (16, '1444376011', 'fe80::854a:1b0b:3bc7:fd05', 'Logged out', 3), (17, '1444378085', '20.0.0.105', 'Login:admin,naveen', 2), (18, '1444381257', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (19, '1444625237', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (20, '1444635350', 'fe80::854a:1b0b:3bc7:fd05', 'Logged out', 3), (21, '1444635353', 'fe80::854a:1b0b:3bc7:fd05', 'Logged out', 3), (22, '1444645380', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (23, '1444647222', 'fe80::854a:1b0b:3bc7:fd05', 'Logged out', 3), (24, '1444713467', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (25, '1444797876', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (26, '1444818822', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (27, '1444818850', 'fe80::854a:1b0b:3bc7:fd05', 'Deleted in product_offers', 2), (28, '1444831646', 'fe80::854a:1b0b:3bc7:fd05', 'Logged out', 3), (29, '1444884145', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (30, '1444913839', 'fe80::854a:1b0b:3bc7:fd05', 'Logged out', 3), (31, '1444913850', 'fe80::854a:1b0b:3bc7:fd05', 'Logged out', 3), (32, '1445834655', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (33, '1445835262', 'fe80::854a:1b0b:3bc7:fd05', 'Logged out', 3), (34, '1448891428', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (35, '1449927313', 'fe80::854a:1b0b:3bc7:fd05', 'Login:admin,naveen', 2), (36, '1453989079', '20.0.0.152', 'Login:admin,naveen', 2), (37, '1454678825', '20.0.0.152', 'Login:admin,naveen', 2), (38, '1454679634', '20.0.0.151', 'Login:admin,naveen', 2), (39, '1460372116', '20.0.0.152', 'Login:admin,naveen', 2), (40, '1460442629', '20.0.0.152', 'Login:admin,123456', 2), (41, '1460442634', '20.0.0.152', 'Login:admin,naveen', 2), (42, '1460522679', '20.0.0.152', 'Login:admin,naveen', 2), (43, '1460523434', '20.0.0.151', 'Login:admin,naveen', 2), (44, '1460526994', '20.0.0.152', 'Login:admin,naveen', 2), (45, '1460533070', '20.0.0.152', 'Login:admin,naveen', 2); -- -------------------------------------------------------- -- -- Table structure for table `main_cat` -- CREATE TABLE IF NOT EXISTS `main_cat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; -- -- Dumping data for table `main_cat` -- INSERT INTO `main_cat` (`id`, `name`, `ordr`, `visible`) VALUES (2, 'Fashion & Clothing ', 1, 1), (3, 'Weddings & Events ', 2, 1), (4, 'Home & Garden ', 3, 1), (5, 'Sports & Lifestyle ', 5, 1), (6, 'Phones & Electronics ', 4, 1), (7, 'test', 7, 1), (8, 'tesse', 6, 1); -- -------------------------------------------------------- -- -- Table structure for table `manage_payment_book` -- CREATE TABLE IF NOT EXISTS `manage_payment_book` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `bank_name` text NOT NULL, `card_name` text NOT NULL, `card_no` text NOT NULL, `expiry_month` text NOT NULL, `expiry_year` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `manage_payment_book` -- INSERT INTO `manage_payment_book` (`id`, `user_id`, `bank_name`, `card_name`, `card_no`, `expiry_month`, `expiry_year`) VALUES (1, 1, 'State Bank', 'kasthuri', '0123456789', '10', '2020'), (2, 1, 'Indian Bank', 'kasthuri', '0123456789', '9', '2025'); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE IF NOT EXISTS `orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_number` text NOT NULL, `total_price` double NOT NULL, `tax` double NOT NULL, `delivery_charge` double NOT NULL, `coupon` int(11) NOT NULL, `coupon_price` double NOT NULL, `user_id` int(11) NOT NULL, `user_shipid` int(11) NOT NULL, `user_billingid` int(11) NOT NULL, `payment_mode` int(11) NOT NULL, `payment_gatewayid` text NOT NULL, `payment_gateway_status` text NOT NULL, `del_time` text NOT NULL, `delivery_status` int(11) NOT NULL, `order_status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `order_details` -- CREATE TABLE IF NOT EXISTS `order_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `color` int(11) NOT NULL, `size` int(11) NOT NULL, `qty` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `page` -- CREATE TABLE IF NOT EXISTS `page` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` text NOT NULL, `content` text NOT NULL, `ip` int(11) NOT NULL, `time` int(11) NOT NULL, `d` int(11) NOT NULL, `m` int(11) NOT NULL, `y` int(11) NOT NULL, `fd` text NOT NULL, `editor_type` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -------------------------------------------------------- -- -- Table structure for table `parent_subcategory` -- CREATE TABLE IF NOT EXISTS `parent_subcategory` ( `id` int(11) NOT NULL AUTO_INCREMENT, `psubcat_name` text NOT NULL, `subcat_id` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, `filter` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ; -- -- Dumping data for table `parent_subcategory` -- INSERT INTO `parent_subcategory` (`id`, `psubcat_name`, `subcat_id`, `ordr`, `visible`, `filter`) VALUES (2, 'Maxi Dresses', 2, 1, 1, '4,6'), (3, 'Plus Size Dresses', 2, 2, 1, '8'), (4, 'Vintage Dresses', 2, 3, 1, '4,6'), (13, 'Dresses', 13, 4, 1, '2,8'), (14, 'Tops', 13, 5, 1, '2,7,8'), (15, 'Slim Hang bag', 16, 6, 1, '2,3'), (16, 'Vocational Hand bag', 16, 7, 1, '2,3'); -- -------------------------------------------------------- -- -- Table structure for table `products_list` -- CREATE TABLE IF NOT EXISTS `products_list` ( `id` int(11) NOT NULL AUTO_INCREMENT, `main_cat` int(11) NOT NULL, `cat` int(11) NOT NULL, `sub_cat` int(11) NOT NULL, `parent_subcat` int(11) NOT NULL, `color` text NOT NULL, `size` text NOT NULL, `product_name` text NOT NULL, `product_short_name` text NOT NULL, `product_code` text NOT NULL, `mrp_price` double NOT NULL, `price` double NOT NULL, `service_tax` double NOT NULL, `vat` double NOT NULL, `product_ratings` int(11) NOT NULL, `stock` int(11) NOT NULL, `new_arrival` int(11) NOT NULL COMMENT '0=>Not newarrival,1=>New arrival', `flash` int(11) NOT NULL COMMENT '0=>Not Flash,1=>Flash', `warehouse_serial` text NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `products_list` -- INSERT INTO `products_list` (`id`, `main_cat`, `cat`, `sub_cat`, `parent_subcat`, `color`, `size`, `product_name`, `product_short_name`, `product_code`, `mrp_price`, `price`, `service_tax`, `vat`, `product_ratings`, `stock`, `new_arrival`, `flash`, `warehouse_serial`, `ordr`, `visible`) VALUES (1, 2, 1, 2, 2, '2', '2', 'Women''s Lace White Dress, Sexy/Beach/Maxi Deep V Sleeveless See-through', 'Women''s Lace White Dress, Sexy/Beach/Maxi Deep V Sleeveless See-through', '00001', 2000, 1600, 1, 1, 5, 1, 1, 1, '', 2, 1), (2, 2, 1, 2, 2, '2', '2', 'Women''s Lace White Dress, Sexy/Beach/Maxi Deep V Sleeveless See-through', 'Women''s Lace White Dress, Sexy/Beach/Maxi Deep V Sleeveless See-through', '00002', 2000, 1600, 1, 1, 5, 1, 1, 1, '', 1, 1), (3, 2, 1, 2, 2, '2,3', '2,3', 'Women''s Solid Color Maxi Chiffon Dress with Lace Top', 'Women''s Solid Color Maxi Chiffon Dress with Lace Top', '00003', 2000, 1000, 1, 1, 5, 0, 1, 1, '', 4, 1), (4, 2, 1, 2, 2, '2,3', '2,3', 'Women''s Solid Color Maxi Chiffon Dress with Lace Top', 'Women''s Solid Color Maxi Chiffon Dress with Lace Top', '00004', 2000, 1000, 1, 1, 5, 0, 1, 1, '', 3, 1), (5, 2, 1, 2, 2, '', '', 'sdcasd', 'dasd', '00005', 100, 99, 0, 0, 5, 0, 0, 0, '', 5, 1), (6, 2, 1, 2, 2, '', '', 'Women''s Lace White Dress, Sexy/Beach/Maxi Deep V Sleeveless See-through', 'Women''s Lace White Dress, Sexy/Beach/Maxi Deep V Sleeveless See-through', '00006', 1500, 1300, 0, 0, 5, 0, 0, 0, '', 6, 1), (7, 2, 1, 2, 2, '2', '2', 'cvxv', 'xvxc', '00007', 1300, 1250, 0, 0, 5, 0, 0, 0, '', 8, 1), (8, 2, 1, 2, 2, '', '', 'cvxv', 'xvxc', '00008', 1200, 1180, 0, 0, 5, 0, 0, 0, '', 7, 1), (9, 2, 1, 2, 2, '', '', 'sdcasd', 'Women''s Solid Color Maxi Chiffon Dress with Lace Top', '00009', 2000, 1000, 0, 0, 5, 0, 0, 0, '', 9, 1), (10, 2, 1, 2, 2, '', '', 'cvxv', 'dasd', '00010', 2000, 1500, 0, 0, 5, 0, 0, 0, '', 10, 1), (11, 2, 5, 13, 13, '', '4', 'Girl''s Fashion Love Bowknot Clothing Set(Blouse&Pant)', 'Girl''s Fashion Love Bowknot Clothing Set(Blouse&Pant)', '00011', 2000, 1500, 0, 0, 5, 0, 0, 0, '', 11, 1), (12, 2, 1, 2, 2, '2', '3', 'Women''s Lace White Dress, Sexy/Beach/Maxi Deep V Sleeveless See-through', 'Women''s Lace White Dress, Sexy/Beach/Maxi Deep V Sleeveless See-through', '00012', 2000, 1000, 1, 1, 5, 1, 0, 1, '', 12, 1); -- -------------------------------------------------------- -- -- Table structure for table `product_filters` -- CREATE TABLE IF NOT EXISTS `product_filters` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `filter_val` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=61 ; -- -- Dumping data for table `product_filters` -- INSERT INTO `product_filters` (`id`, `product_id`, `filter_val`) VALUES (1, 1, 3), (2, 1, 7), (3, 1, 8), (4, 1, 3), (5, 1, 4), (11, 3, 3), (12, 3, 3), (13, 3, 4), (14, 3, 5), (15, 4, 3), (16, 4, 3), (17, 4, 4), (18, 4, 5), (46, 2, 1), (47, 2, 3), (48, 2, 7), (49, 2, 8), (50, 2, 1), (51, 2, 3), (52, 2, 4), (57, 12, 2), (58, 12, 8), (59, 12, 2), (60, 12, 5); -- -------------------------------------------------------- -- -- Table structure for table `product_gallery` -- CREATE TABLE IF NOT EXISTS `product_gallery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `image_1` int(11) NOT NULL, `pri` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `product_gallery` -- INSERT INTO `product_gallery` (`id`, `product_id`, `image_1`, `pri`, `ordr`, `visible`) VALUES (1, 2, 20, 0, 8, 1), (3, 2, 22, 0, 6, 1), (4, 2, 23, 0, 3, 1), (5, 2, 24, 1, 10, 0), (6, 2, 25, 0, 9, 1), (8, 2, 27, 0, 4, 1), (10, 1, 29, 1, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `product_more` -- CREATE TABLE IF NOT EXISTS `product_more` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `title` text NOT NULL, `image_1` int(11) NOT NULL, `html_content` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `product_more` -- INSERT INTO `product_more` (`id`, `product_id`, `title`, `image_1`, `html_content`) VALUES (2, 2, 'Product Details', 0, '<div class="widget description-key-features">\r\n <h2 class="old-title">Key Features</h2>\r\n <div class="features-list">\r\n <div class="number-tag">\r\n <span class="features-number"><i>1</i></span>\r\n </div>\r\n <div class="item-tag">\r\n Design:Lace\r\n </div>\r\n </div>\r\n <div class="features-list">\r\n <div class="number-tag">\r\n <span class="features-number"><i>2</i></span>\r\n </div>\r\n <div class="item-tag">\r\n Fabric:Chiffon\r\n </div>\r\n </div>\r\n</div>\r\n<div class="widget prod-description-specifications" id="prod-description-specifications">\r\n <h2 class="old-title">Specifications</h2>\r\n <div class="specTitle"> \r\n <table class="table table-condensed mini-text ">\r\n <tbody><tr>\r\n <th class="strong-title">Clothing Style</th>\r\n <td class="inline"><span class="">Maxi,</span> <span class="">Party,</span> <span class="">Vintage</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Season</th>\r\n <td class="inline"><span class="">Summer</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Color</th>\r\n <td class="inline"><span class="">Black,</span> <span class="">White,</span> <span class="">Red</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Silhouette</th>\r\n <td class="inline"><span class="">Swing</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Pattern</th>\r\n <td class="inline"><span class="">Solid</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Design</th>\r\n <td class="inline"><span class="red-empha">Lace<i class="litb-icon-keyfeature" data-spectip="Key Feature"></i></span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Neckline</th>\r\n <td class="inline"><span class="">Round Neck</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Waistline Type</th>\r\n <td class="inline"><span class="">Mid Rise</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Thickness</th>\r\n <td class="inline"><span class="">Thin</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Elasticity</th>\r\n <td class="inline"><span class="">Micro-elastic</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Fabric</th>\r\n <td class="inline"><span class="red-empha">Chiffon<i class="litb-icon-keyfeature" data-spectip="Key Feature"></i></span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Look After Me</th>\r\n <td class="inline"><span class="">Wash separately,</span> <span class="">Hand wash</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Size</th>\r\n <td class="inline"><span class="">XXXL,</span> <span class="">XXL,</span> <span class="">XL,</span> <span class="">L,</span> <span class="">M,</span> <span class="">S</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Dress Length</th>\r\n <td class="inline"><span class="">Maxi</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Sleeve Length</th>\r\n <td class="inline"><span class="">Short Sleeve</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Clothing Bust (cm)</th>\r\n <td class="inline"><span class="">S:88,M:92,L:96,XL:100,XXL:104,XXXL:108</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Clothing Waist (cm)</th>\r\n <td class="inline"><span class="">S:72,M:76,L:80,XL:84,XXL:88,XXXL:92</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Clothing Length (cm)</th>\r\n <td class="inline"><span class="">S:122,M:124,L:126,XL:128,XXL:130,XXXL:132</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Special Suggestion</th>\r\n <td class="inline"><span class="">This Style is TRUE to SIZE.</span> </td>\r\n </tr>\r\n </tbody></table>\r\n </div>\r\n</div>'), (4, 2, 'How To Measure', 31, ''), (5, 2, 'Size Charts', 0, '<div class="widget prod_description_sizechart" id="size_charts">\r\n \r\n\r\n \r\n <h2 class="main-title old-title">\r\n Size Charts\r\n </h2>\r\n <div class="btn-group chart-switcher" data-toggle="buttons-radio">\r\n <a href="javascript:void(0);" data-target="0-div" class="btn active">Size Conversion Chart</a>\r\n <a href="javascript:void(0);" data-target="1-div" class="btn">Women''s Clothing</a>\r\n </div>\r\n\r\n <div class="size-table-item 0-div">\r\n <div class="chartContainer 0">\r\n <table class="datasource table table-striped table-bordered table-hover" data-chart-unit="" data-unit="["","","","",""]" style="width: 726px;">\r\n <tbody><tr>\r\n <th class="">LITB</th>\r\n <th class="">US</th>\r\n <th class="">UK</th>\r\n <th class="">EU</th>\r\n <th class="">AUS</th>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XS - 150/76A">XS - 150/76A</td>\r\n <td class="prod_size" width="40" data-orig="0">0</td>\r\n <td class="prod_size" width="40" data-orig="2">2</td>\r\n <td class="prod_size" width="40" data-orig="32">32</td>\r\n <td class="prod_size" width="40" data-orig="2">2</td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="S - 155/80A">S - 155/80A</td>\r\n <td class="prod_size" width="40" data-orig="1">1</td>\r\n <td class="prod_size" width="40" data-orig="4">4</td>\r\n <td class="prod_size" width="40" data-orig="34">34</td>\r\n <td class="prod_size" width="40" data-orig="4">4</td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="M - 160/84A">M - 160/84A</td>\r\n <td class="prod_size" width="40" data-orig="2">2</td>\r\n <td class="prod_size" width="40" data-orig="6">6</td>\r\n <td class="prod_size" width="40" data-orig="36">36</td>\r\n <td class="prod_size" width="40" data-orig="6">6</td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="L - 165/88A">L - 165/88A</td>\r\n <td class="prod_size" width="40" data-orig="4">4</td>\r\n <td class="prod_size" width="40" data-orig="8">8</td>\r\n <td class="prod_size" width="40" data-orig="38">38</td>\r\n <td class="prod_size" width="40" data-orig="8">8</td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XL - 170/92A">XL - 170/92A</td>\r\n <td class="prod_size" width="40" data-orig="6">6</td>\r\n <td class="prod_size" width="40" data-orig="10">10</td>\r\n <td class="prod_size" width="40" data-orig="40">40</td>\r\n <td class="prod_size" width="40" data-orig="10">10</td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XXL - 175/96A">XXL - 175/96A</td>\r\n <td class="prod_size" width="40" data-orig="8">8</td>\r\n <td class="prod_size" width="40" data-orig="12">12</td>\r\n <td class="prod_size" width="40" data-orig="42">42</td>\r\n <td class="prod_size" width="40" data-orig="12">12</td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XXXL - 180/100A">XXXL - 180/100A</td>\r\n <td class="prod_size" width="40" data-orig="10">10</td>\r\n <td class="prod_size" width="40" data-orig="14">14</td>\r\n <td class="prod_size" width="40" data-orig="44">44</td>\r\n <td class="prod_size" width="40" data-orig="14">14</td>\r\n </tr>\r\n </tbody></table>\r\n </div>\r\n </div>\r\n <div class="size-table-item 1-div" style="display: none;">\r\n <div class="btn-group unit-switcher">\r\n <a href="javascript:void(0);" data-target="1" class="btn inches active">Inches</a>\r\n <a href="javascript:void(0);" data-target="1" class="btn centimeters">Centimeters</a>\r\n </div>\r\n <div class="chartContainer 1">\r\n <table class="datasource table table-striped table-bordered table-hover" data-chart-unit="" data-unit="["","cm","cm","cm"]" style="width: 726px;">\r\n <tbody><tr>\r\n <th>Size</th>\r\n <th>Bust</th>\r\n <th>Waist</th>\r\n <th>Hips</th>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XS - 150/76A">XS - 150/76A</td>\r\n <td class="prod_size" width="40" data-orig="76">30</td>\r\n <td class="prod_size" width="40" data-orig="60">23<em>½</em></td>\r\n <td class="prod_size" width="40" data-orig="82">32<em>¼</em></td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="S - 155/80A">S - 155/80A</td>\r\n <td class="prod_size" width="40" data-orig="80">31<em>½</em></td>\r\n <td class="prod_size" width="40" data-orig="64">25<em>¼</em></td>\r\n <td class="prod_size" width="40" data-orig="86">33<em>¾</em></td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="M - 160/84A">M - 160/84A</td>\r\n <td class="prod_size" width="40" data-orig="84">33</td>\r\n <td class="prod_size" width="40" data-orig="68">26<em>¾</em></td>\r\n <td class="prod_size" width="40" data-orig="90">35<em>½</em></td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="L - 165/88A">L - 165/88A</td>\r\n <td class="prod_size" width="40" data-orig="88">34<em>¾</em></td>\r\n <td class="prod_size" width="40" data-orig="72">28<em>¼</em></td>\r\n <td class="prod_size" width="40" data-orig="94">37</td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XL - 170/92A">XL - 170/92A</td>\r\n <td class="prod_size" width="40" data-orig="92">36<em>¼</em></td>\r\n <td class="prod_size" width="40" data-orig="76">30</td>\r\n <td class="prod_size" width="40" data-orig="98">38<em>½</em></td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XXL - 175/96A">XXL - 175/96A</td>\r\n <td class="prod_size" width="40" data-orig="96">37<em>¾</em></td>\r\n <td class="prod_size" width="40" data-orig="80">31<em>½</em></td>\r\n <td class="prod_size" width="40" data-orig="102">40<em>¼</em></td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XXXL - 180/100A">XXXL - 180/100A</td>\r\n <td class="prod_size" width="40" data-orig="100">39<em>¼</em></td>\r\n <td class="prod_size" width="40" data-orig="84">33</td>\r\n <td class="prod_size" width="40" data-orig="106">41<em>¾</em></td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XXXXL-185/104A">XXXXL-185/104A</td>\r\n <td class="prod_size" width="40" data-orig="104">41</td>\r\n <td class="prod_size" width="40" data-orig="88">34<em>¾</em></td>\r\n <td class="prod_size" width="40" data-orig="110">43<em>¼</em></td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="XXXXXL-190/108A">XXXXXL-190/108A</td>\r\n <td class="prod_size" width="40" data-orig="108">42<em>½</em></td>\r\n <td class="prod_size" width="40" data-orig="92">36<em>¼</em></td>\r\n <td class="prod_size" width="40" data-orig="114">45</td>\r\n </tr>\r\n <tr>\r\n <td class="prod_size" width="40" data-orig="One-Size">One-Size</td>\r\n <td class="prod_size" width="40" data-orig="80-84">31<em>½</em>-33</td>\r\n <td class="prod_size" width="40" data-orig="64-68">25<em>¼</em>-26<em>¾</em></td>\r\n <td class="prod_size" width="40" data-orig="86-90">33<em>¾</em>-35<em>½</em></td>\r\n </tr>\r\n </tbody></table>\r\n </div>\r\n </div>\r\n \r\n\r\n</div>'), (6, 1, 'Product Details', 0, '<div class="widget description-key-features">\r\n <h2 class="old-title">Key Features</h2>\r\n <div class="features-list">\r\n <div class="number-tag">\r\n <span class="features-number"><i>1</i></span>\r\n </div>\r\n <div class="item-tag">\r\n Design:Lace\r\n </div>\r\n </div>\r\n <div class="features-list">\r\n <div class="number-tag">\r\n <span class="features-number"><i>2</i></span>\r\n </div>\r\n <div class="item-tag">\r\n Fabric:Chiffon\r\n </div>\r\n </div>\r\n</div>\r\n<div class="widget prod-description-specifications" id="prod-description-specifications">\r\n <h2 class="old-title">Specifications</h2>\r\n <div class="specTitle"> \r\n <table class="table table-condensed mini-text ">\r\n <tbody><tr>\r\n <th class="strong-title">Clothing Style</th>\r\n <td class="inline"><span class="">Maxi,</span> <span class="">Party,</span> <span class="">Vintage</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Season</th>\r\n <td class="inline"><span class="">Summer</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Color</th>\r\n <td class="inline"><span class="">Black,</span> <span class="">White,</span> <span class="">Red</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Silhouette</th>\r\n <td class="inline"><span class="">Swing</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Pattern</th>\r\n <td class="inline"><span class="">Solid</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Design</th>\r\n <td class="inline"><span class="red-empha">Lace<i class="litb-icon-keyfeature" data-spectip="Key Feature"></i></span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Neckline</th>\r\n <td class="inline"><span class="">Round Neck</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Waistline Type</th>\r\n <td class="inline"><span class="">Mid Rise</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Thickness</th>\r\n <td class="inline"><span class="">Thin</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Elasticity</th>\r\n <td class="inline"><span class="">Micro-elastic</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Fabric</th>\r\n <td class="inline"><span class="red-empha">Chiffon<i class="litb-icon-keyfeature" data-spectip="Key Feature"></i></span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Look After Me</th>\r\n <td class="inline"><span class="">Wash separately,</span> <span class="">Hand wash</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Size</th>\r\n <td class="inline"><span class="">XXXL,</span> <span class="">XXL,</span> <span class="">XL,</span> <span class="">L,</span> <span class="">M,</span> <span class="">S</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Dress Length</th>\r\n <td class="inline"><span class="">Maxi</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Sleeve Length</th>\r\n <td class="inline"><span class="">Short Sleeve</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Clothing Bust (cm)</th>\r\n <td class="inline"><span class="">S:88,M:92,L:96,XL:100,XXL:104,XXXL:108</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Clothing Waist (cm)</th>\r\n <td class="inline"><span class="">S:72,M:76,L:80,XL:84,XXL:88,XXXL:92</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Clothing Length (cm)</th>\r\n <td class="inline"><span class="">S:122,M:124,L:126,XL:128,XXL:130,XXXL:132</span> </td>\r\n </tr>\r\n <tr>\r\n <th class="strong-title">Special Suggestion</th>\r\n <td class="inline"><span class="">This Style is TRUE to SIZE.</span> </td>\r\n </tr>\r\n </tbody></table>\r\n </div>\r\n</div>'); -- -------------------------------------------------------- -- -- Table structure for table `product_offers` -- CREATE TABLE IF NOT EXISTS `product_offers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `offer_from` text NOT NULL, `offer_to` text NOT NULL, `offer_type` int(11) NOT NULL COMMENT '0=>Amount,1=>Percentage', `offer_val` text NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `product_offers` -- INSERT INTO `product_offers` (`id`, `product_id`, `offer_from`, `offer_to`, `offer_type`, `offer_val`, `visible`) VALUES (2, 1, '1255062600', '1286728200', 1, '', 0), (6, 2, '1444365000', '1444525200', 1, '10', 0), (7, 2, '1444797000', '1445032800', 1, '15', 0), (8, 2, '1444883400', '1444953600', 1, '45', 0), (9, 2, '1444797000', '1444910400', 1, '45', 0), (11, 2, '1445056200', '1445378400', 1, '50', 0); -- -------------------------------------------------------- -- -- Table structure for table `product_review` -- CREATE TABLE IF NOT EXISTS `product_review` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `ratings` int(11) NOT NULL, `name` text NOT NULL, `review_content` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `product_review_image` -- CREATE TABLE IF NOT EXISTS `product_review_image` ( `id` int(11) NOT NULL AUTO_INCREMENT, `review_id` int(11) NOT NULL, `image_1` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `product_secondary_categories` -- CREATE TABLE IF NOT EXISTS `product_secondary_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `cat` int(11) NOT NULL, `sub_cat` int(11) NOT NULL, `parent_subcat` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ; -- -- Dumping data for table `product_secondary_categories` -- INSERT INTO `product_secondary_categories` (`id`, `product_id`, `cat`, `sub_cat`, `parent_subcat`) VALUES (15, 1, 1, 0, 0), (16, 1, 0, 2, 0), (17, 1, 0, 13, 0), (18, 1, 0, 0, 3), (19, 1, 0, 0, 13), (25, 6, 1, 0, 0), (26, 6, 0, 2, 0), (27, 6, 0, 0, 2), (28, 6, 0, 0, 3), (29, 4, 0, 0, 3), (30, 4, 0, 0, 4), (31, 3, 0, 2, 0), (32, 3, 0, 0, 2), (33, 2, 1, 0, 0), (34, 2, 0, 2, 0), (35, 2, 0, 3, 0), (36, 2, 0, 4, 0), (37, 2, 0, 0, 2); -- -------------------------------------------------------- -- -- Table structure for table `product_warehouse` -- CREATE TABLE IF NOT EXISTS `product_warehouse` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rack` int(11) NOT NULL, `shelf` int(11) NOT NULL, `product_id` int(11) NOT NULL, `no_of_products` double NOT NULL, `stock_in` int(11) NOT NULL, `stock_out` int(11) NOT NULL, `datetime` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Dumping data for table `product_warehouse` -- INSERT INTO `product_warehouse` (`id`, `rack`, `shelf`, `product_id`, `no_of_products`, `stock_in`, `stock_out`, `datetime`) VALUES (1, 3, 3, 2, 2, 0, 0, '1444890600'), (2, 2, 2, 2, 2, 0, 0, '1444890600'), (3, 2, 2, 12, 10, 0, 0, '1444890600'), (4, 2, 2, 2, 88, 0, 0, '1444890600'), (5, 2, 4, 1, 50, 0, 0, '1444890600'), (6, 2, 4, 1, 50, 0, 0, '1444896208'), (7, 3, 3, 1, 10, 0, 0, '1444896230'), (8, 3, 3, 2, 5, 0, 0, '1444899670'), (9, 3, 3, 2, 3, 0, 0, '1444899951'), (10, 2, 2, 2, 2, 0, 0, '1444900936'), (11, 2, 2, 3, 1, 0, 0, '1444910506'), (12, 3, 3, 1, 10, 0, 0, '1444910561'), (13, 3, 3, 8, 10, 0, 0, '1444913801'); -- -------------------------------------------------------- -- -- Table structure for table `product_warehouse_barcode` -- CREATE TABLE IF NOT EXISTS `product_warehouse_barcode` ( `id` int(11) NOT NULL AUTO_INCREMENT, `w_id` int(11) NOT NULL, `barcode` text NOT NULL, `status` int(11) NOT NULL COMMENT '0=>stock in,1=>stock out', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=247 ; -- -- Dumping data for table `product_warehouse_barcode` -- INSERT INTO `product_warehouse_barcode` (`id`, `w_id`, `barcode`, `status`) VALUES (1, 1, 'product1', 0), (2, 1, 'product2', 0), (3, 2, 'product1', 1), (4, 2, 'product2', 0), (8, 3, '00000', 0), (9, 3, '00001', 0), (10, 3, '00002', 0), (11, 3, '00003', 0), (12, 3, '00004', 0), (13, 3, '00005', 0), (14, 3, '00006', 0), (15, 3, '00007', 0), (16, 3, '00008', 1), (17, 3, '00009', 1), (18, 4, '00000', 0), (19, 4, '00001', 0), (20, 4, '00002', 0), (21, 4, '00003', 0), (22, 4, '00004', 0), (23, 4, '00005', 0), (24, 4, '00006', 0), (25, 4, '00007', 0), (26, 4, '00008', 0), (27, 4, '00009', 0), (28, 4, '00010', 0), (29, 4, '00011', 0), (30, 4, '00012', 0), (31, 4, '00013', 0), (32, 4, '00014', 0), (33, 4, '00015', 0), (34, 4, '00016', 0), (35, 4, '00017', 0), (36, 4, '00018', 0), (37, 4, '00019', 0), (38, 4, '00020', 0), (39, 4, '00021', 0), (40, 4, '00022', 0), (41, 4, '00023', 0), (42, 4, '00024', 0), (43, 4, '00025', 0), (44, 4, '00026', 0), (45, 4, '00027', 0), (46, 4, '00028', 0), (47, 4, '00029', 0), (48, 4, '00030', 0), (49, 4, '00031', 0), (50, 4, '00032', 0), (51, 4, '00033', 0), (52, 4, '00034', 0), (53, 4, '00035', 0), (54, 4, '00036', 0), (55, 4, '00037', 0), (56, 4, '00038', 0), (57, 4, '00039', 0), (58, 4, '00040', 0), (59, 4, '00041', 0), (60, 4, '00042', 0), (61, 4, '00043', 0), (62, 4, '00044', 0), (63, 4, '00045', 0), (64, 4, '00046', 0), (65, 4, '00047', 0), (66, 4, '00048', 0), (67, 4, '00049', 0), (68, 4, '00050', 0), (69, 4, '00051', 0), (70, 4, '00052', 0), (71, 4, '00053', 0), (72, 4, '00054', 0), (73, 4, '00055', 0), (74, 4, '00056', 0), (75, 4, '00057', 0), (76, 4, '00058', 0), (77, 4, '00059', 0), (78, 4, '00060', 0), (79, 4, '00061', 0), (80, 4, '00062', 0), (81, 4, '00063', 0), (82, 4, '00064', 0), (83, 4, '00065', 0), (84, 4, '00066', 0), (85, 4, '00067', 0), (86, 4, '00068', 0), (87, 4, '00069', 0), (88, 4, '00070', 0), (89, 4, '00071', 0), (90, 4, '00072', 0), (91, 4, '00073', 0), (92, 4, '00074', 0), (93, 4, '00075', 0), (94, 4, '00076', 0), (95, 4, '00077', 0), (96, 4, '00078', 0), (97, 4, '00079', 0), (98, 4, '00080', 0), (99, 4, '00081', 0), (100, 4, '00082', 0), (101, 4, '00083', 0), (102, 4, '00084', 0), (103, 4, '00085', 0), (104, 4, '00086', 0), (105, 4, '00087', 0), (106, 5, '00000', 0), (107, 5, '00001', 0), (108, 5, '00002', 0), (109, 5, '00003', 0), (110, 5, '00004', 0), (111, 5, '00005', 0), (112, 5, '00006', 0), (113, 5, '00007', 0), (114, 5, '00008', 0), (115, 5, '00009', 0), (116, 5, '00010', 0), (117, 5, '00011', 0), (118, 5, '00012', 0), (119, 5, '00013', 0), (120, 5, '00014', 0), (121, 5, '00015', 0), (122, 5, '00016', 0), (123, 5, '00017', 0), (124, 5, '00018', 0), (125, 5, '00019', 0), (126, 5, '00020', 0), (127, 5, '00021', 0), (128, 5, '00022', 0), (129, 5, '00023', 0), (130, 5, '00024', 0), (131, 5, '00025', 0), (132, 5, '00026', 0), (133, 5, '00027', 0), (134, 5, '00028', 0), (135, 5, '00029', 0), (136, 5, '00030', 0), (137, 5, '00031', 0), (138, 5, '00032', 0), (139, 5, '00033', 0), (140, 5, '00034', 0), (141, 5, '00035', 0), (142, 5, '00036', 0), (143, 5, '00037', 0), (144, 5, '00038', 0), (145, 5, '00039', 0), (146, 5, '00040', 0), (147, 5, '00041', 0), (148, 5, '00042', 0), (149, 5, '00043', 0), (150, 5, '00044', 0), (151, 5, '00045', 0), (152, 5, '00046', 0), (153, 5, '00047', 0), (154, 5, '00048', 0), (155, 5, '00049', 0), (156, 6, '00000', 0), (157, 6, '00001', 0), (158, 6, '00002', 0), (159, 6, '00003', 0), (160, 6, '00004', 0), (161, 6, '00005', 0), (162, 6, '00006', 0), (163, 6, '00007', 0), (164, 6, '00008', 0), (165, 6, '00009', 0), (166, 6, '00010', 0), (167, 6, '00011', 0), (168, 6, '00012', 0), (169, 6, '00013', 0), (170, 6, '00014', 0), (171, 6, '00015', 0), (172, 6, '00016', 0), (173, 6, '00017', 0), (174, 6, '00018', 0), (175, 6, '00019', 0), (176, 6, '00020', 0), (177, 6, '00021', 0), (178, 6, '00022', 0), (179, 6, '00023', 0), (180, 6, '00024', 0), (181, 6, '00025', 0), (182, 6, '00026', 0), (183, 6, '00027', 0), (184, 6, '00028', 0), (185, 6, '00029', 0), (186, 6, '00030', 0), (187, 6, '00031', 0), (188, 6, '00032', 0), (189, 6, '00033', 0), (190, 6, '00034', 0), (191, 6, '00035', 0), (192, 6, '00036', 0), (193, 6, '00037', 0), (194, 6, '00038', 0), (195, 6, '00039', 0), (196, 6, '00040', 0), (197, 6, '00041', 0), (198, 6, '00042', 0), (199, 6, '00043', 0), (200, 6, '00044', 0), (201, 6, '00045', 0), (202, 6, '00046', 0), (203, 6, '00047', 0), (204, 6, '00048', 0), (205, 6, '00049', 0), (206, 7, '00000', 0), (207, 7, '00001', 0), (208, 7, '00002', 0), (209, 7, '00003', 0), (210, 7, '00004', 0), (211, 7, '00005', 0), (212, 7, '00006', 0), (213, 7, '00007', 0), (214, 7, '00008', 0), (215, 7, '00009', 0), (216, 8, '00000', 0), (217, 8, '00001', 0), (218, 8, '00002', 0), (219, 8, '00003', 0), (220, 8, '00004', 0), (221, 9, '00000', 0), (222, 9, '00001', 0), (223, 9, '00002', 0), (224, 10, '00000', 0), (225, 10, '00001', 0), (226, 11, '00000', 0), (227, 12, '00000', 0), (228, 12, '00001', 0), (229, 12, '00002', 0), (230, 12, '00003', 0), (231, 12, '00004', 0), (232, 12, '00005', 0), (233, 12, '00006', 0), (234, 12, '00007', 0), (235, 12, '00008', 0), (236, 12, '00009', 0), (237, 13, '00000', 0), (238, 13, '00001', 0), (239, 13, '00002', 0), (240, 13, '00003', 0), (241, 13, '00004', 0), (242, 13, '00005', 0), (243, 13, '00006', 0), (244, 13, '00007', 0), (245, 13, '00008', 0), (246, 13, '00009', 0); -- -------------------------------------------------------- -- -- Table structure for table `rewards` -- CREATE TABLE IF NOT EXISTS `rewards` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rewards_val` text NOT NULL, `order_val` text NOT NULL, `cat_id` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `rewards` -- INSERT INTO `rewards` (`id`, `rewards_val`, `order_val`, `cat_id`, `ordr`, `visible`) VALUES (2, '30', '600', 1, 1, 1), (3, '100', '1500', 1, 2, 1); -- -------------------------------------------------------- -- -- Table structure for table `service_tax` -- CREATE TABLE IF NOT EXISTS `service_tax` ( `id` int(11) NOT NULL AUTO_INCREMENT, `service_tax` double NOT NULL, `vat` double NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `service_tax` -- INSERT INTO `service_tax` (`id`, `service_tax`, `vat`, `visible`) VALUES (2, 12.36, 5, 1); -- -------------------------------------------------------- -- -- Table structure for table `size` -- CREATE TABLE IF NOT EXISTS `size` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `cat_id` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `size` -- INSERT INTO `size` (`id`, `name`, `cat_id`, `ordr`, `visible`) VALUES (2, 'US5.5 / EU36 / UK3.5 / CN35', 1, 1, 1), (3, 'US6 / EU36 / UK4 / CN36', 1, 2, 1), (4, '69', 5, 3, 1), (5, '81', 5, 5, 1), (6, '92', 5, 4, 1), (7, 'teest', 0, 6, 1); -- -------------------------------------------------------- -- -- Table structure for table `sub_category` -- CREATE TABLE IF NOT EXISTS `sub_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `subcat_name` text NOT NULL, `cat_id` int(11) NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, `filter` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; -- -- Dumping data for table `sub_category` -- INSERT INTO `sub_category` (`id`, `subcat_name`, `cat_id`, `ordr`, `visible`, `filter`) VALUES (2, 'Women''s Dresses ', 1, 1, 1, '2,3,4,8'), (3, 'Women''s Tops', 1, 2, 1, ''), (4, 'Women''s Coats & Trench Coats', 1, 3, 1, '2,4,5'), (13, 'Girls'' Clothing ', 5, 4, 1, '3'), (14, 'Boys'' Clothing ', 5, 5, 1, '3'), (16, 'Hand bag1', 6, 6, 1, '2,3'), (17, 'Hand bag2', 6, 7, 1, '2,3'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` text NOT NULL, `first_name` text NOT NULL, `last_name` text NOT NULL, `email` text NOT NULL, `password` text NOT NULL, `pwd` text NOT NULL, `others` text NOT NULL, `reg_time` text NOT NULL, `suspend` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `title`, `first_name`, `last_name`, `email`, `password`, `pwd`, `others`, `reg_time`, `suspend`) VALUES (1, 'Ms', 'Kasthuri', 'Manoharan', 'kasthuri@nscript.in', '7c4a8d09ca3762af61e59520943dc26494f8941b', '123456', 'Nscript', '1443511800', 0); -- -------------------------------------------------------- -- -- Table structure for table `user_address` -- CREATE TABLE IF NOT EXISTS `user_address` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `address1` text NOT NULL, `address2` text NOT NULL, `city` text NOT NULL, `country` text NOT NULL, `state` text NOT NULL, `postal_code` text NOT NULL, `phone_number` text NOT NULL, `bill_address` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `user_address` -- INSERT INTO `user_address` (`id`, `user_id`, `address1`, `address2`, `city`, `country`, `state`, `postal_code`, `phone_number`, `bill_address`) VALUES (1, 1, 'No.84/169,Surya working womens hostel,', 'Gengu reddy road,egmore,chennai', 'chennai', 'IN', 'TamilNadu', '600026', '8681862251', 1), (2, 1, 'No.84/169,Surya working womens hostel,', 'Gengu reddy road,egmore,chennai', 'chennai', 'IN', 'TamilNadu', '600026', '8681862251', 0), (3, 1, 'No.84/169,LIC colony,', 'Nerkundram pathai,Vadapalani,chennai', 'chennai', 'IN', 'TamilNadu', '600026', '8681862251', 0); -- -------------------------------------------------------- -- -- Table structure for table `warehouse_rack` -- CREATE TABLE IF NOT EXISTS `warehouse_rack` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `warehouse_rack` -- INSERT INTO `warehouse_rack` (`id`, `name`, `ordr`, `visible`) VALUES (2, 'A', 1, 1), (3, 'B', 2, 1); -- -------------------------------------------------------- -- -- Table structure for table `warehouse_shelf` -- CREATE TABLE IF NOT EXISTS `warehouse_shelf` ( `id` int(11) NOT NULL AUTO_INCREMENT, `r_id` int(11) NOT NULL, `name` text NOT NULL, `shelf_capacity` text NOT NULL, `ordr` int(11) NOT NULL, `visible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `warehouse_shelf` -- INSERT INTO `warehouse_shelf` (`id`, `r_id`, `name`, `shelf_capacity`, `ordr`, `visible`) VALUES (2, 2, 'A1', '100', 1, 1), (3, 3, 'B1', '100', 2, 1), (4, 2, 'A2', '100', 3, 1); -- -------------------------------------------------------- -- -- Table structure for table `wishlist` -- CREATE TABLE IF NOT EXISTS `wishlist` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; /*!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 */;