/* SQLyog - Free MySQL GUI v5.02 Host - 4.0.18-nt : Database - gvdeals ********************************************************************* Server version : 4.0.18-nt */ /*Table structure for table `adminusers` */ DROP TABLE IF EXISTS `adminusers`; CREATE TABLE `adminusers` ( `adminID` int(11) NOT NULL default '0', `firstName` varchar(50) default NULL, `lastName` varchar(50) default NULL, `canAddProducts` tinyint(1) default NULL, `canUpdateProducts` tinyint(1) default NULL, `canAccessInventoryControl` tinyint(1) default NULL, `canRelateProducts` tinyint(1) default NULL, `canViewOrders` tinyint(1) default NULL, `canUpdateOrders` tinyint(1) default NULL, `canDeleteOrders` tinyint(1) default NULL, `canAddCategories` tinyint(1) default NULL, `canUpdateCategories` tinyint(1) default NULL, `canSendNewsletter` tinyint(1) default NULL, `canViewMailingList` tinyint(1) default NULL, `canViewSearchStrings` tinyint(1) default NULL, `canControlJobs` tinyint(1) default NULL, `canViewSupport` tinyint(1) default NULL, `canManageSupport` tinyint(1) default NULL, `canManageFeedback` tinyint(1) default NULL, `canManageBanners` tinyint(1) default NULL, `canAddCMS` tinyint(1) default NULL, `canUpdateCMS` tinyint(1) default NULL, `canManageNoticeboard` tinyint(1) default NULL, `canControlAdminAccounts` tinyint(1) default NULL, `canControlCorporateAccounts` tinyint(1) default NULL, `canControlGeneralAccounts` tinyint(1) default '1', `canUpdatePaymentGateways` tinyint(1) default NULL, `canChangeCurrencySettings` tinyint(1) default NULL, `canControlShipmentCharges` tinyint(1) default NULL, `canManageCouriers` tinyint(1) default NULL, `canManageCountries` tinyint(1) default NULL, `canManageCities` tinyint(1) default NULL, `created` datetime default NULL, `createdBy` int(11) default NULL, `lastLogin` timestamp(14) NOT NULL, `lastLoginIP` varchar(50) default NULL, PRIMARY KEY (`adminID`) ) TYPE=MyISAM; /*Data for the table `adminusers` */ insert into `adminusers` values (1,'Muhammad','attique',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'2001-01-04 00:00:00',1,20061124113612,'127.0.0.1'), (12,'Mateen','Ahmad',1,1,1,1,1,1,0,1,1,1,1,0,0,1,1,1,1,0,0,0,0,0,0,0,1,1,1,1,1,'2005-06-28 00:00:00',1,20050718000819,'127.0.0.1'), (19,'eb','eb',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'2005-08-28 00:00:00',1,20050828102100,NULL); /*Table structure for table `bannercategories` */ DROP TABLE IF EXISTS `bannercategories`; CREATE TABLE `bannercategories` ( `categoryID` tinyint(3) unsigned NOT NULL auto_increment, `categoryName` varchar(50) default NULL, `description` tinytext, `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`categoryID`) ) TYPE=MyISAM; /*Data for the table `bannercategories` */ insert into `bannercategories` values (1,'Best sellers','313x72','2005-07-18 06:10:46',NULL,20050727224425,NULL), (2,'New items','313x77','2005-07-18 06:11:33',NULL,20050727224425,NULL), (3,'Main banner','466x231','2005-07-18 06:11:54',NULL,20050727224425,NULL), (4,'Sale banner','313x82','2005-07-18 06:12:03',NULL,20050727224425,NULL); /*Table structure for table `banners` */ DROP TABLE IF EXISTS `banners`; CREATE TABLE `banners` ( `BannerID` int(11) NOT NULL auto_increment, `bannerCat` tinyint(3) unsigned NOT NULL default '0', `Image` varchar(255) NOT NULL default '', `Show` tinyint(4) NOT NULL default '0', `Name` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `createdBy` int(11) NOT NULL default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) NOT NULL default '0', `show_cat` int(11) NOT NULL default '0', `url` varchar(255) NOT NULL default '', PRIMARY KEY (`BannerID`) ) TYPE=MyISAM; /*Data for the table `banners` */ insert into `banners` values (36,4,'3_22.jpg',0,'Sale Items','2005-08-08 00:00:00',1,20050808082120,1,0,'http://www.out-sizes.com/sale_items.php'), (35,2,'3_21.jpg',0,'New Items1','2005-08-08 00:00:00',1,20050808082014,1,0,'http://www.out-sizes.com/new_items.php'), (34,1,'3_200.jpg',0,'Best1','2005-08-08 00:00:00',1,20051024091637,1,0,'http://www.out-sizes.com/best_sellers.php'), (32,3,'4_19.jpg',0,'Main2','2005-08-08 00:00:00',1,20050808081743,1,0,'http://www.out-sizes.com'), (33,3,'5_19.jpg',0,'Main3','2005-08-08 00:00:00',1,20050808081832,1,0,'http://www.out-sizes.com'), (31,3,'3_19.jpg',0,'Main1','2005-08-08 00:00:00',1,20050808081710,1,0,'http://www.out-sizes.com'), (37,3,'picture.jpg',0,'bnnn','2006-11-24 00:00:00',1,20061124115912,1,0,'http://sssss'), (39,1,'',-1,'corner','2006-11-24 00:00:00',1,20061124125920,1,0,'http://sss'), (38,1,'3_19.jpg',1,'aaq1a','2006-11-24 00:00:00',1,20061124125249,1,0,'http://'), (40,1,'4_19.jpg',0,'ssssssss','0000-00-00 00:00:00',1,20061125105258,1,0,'http://ssss'), (41,1,'banner_20.jpg',1,'aaaa','0000-00-00 00:00:00',1,20061125110231,1,0,'http://'), (42,1,'5_22.jpg',1,'wewew','0000-00-00 00:00:00',1,20061125110337,1,0,'http://www.mikeil.com/fedex/admin/'), (43,1,'5_21.jpg',1,'gg','0000-00-00 00:00:00',1,20061125110408,1,0,'http://www.google.com/'); /*Table structure for table `brands` */ DROP TABLE IF EXISTS `brands`; CREATE TABLE `brands` ( `id` int(5) NOT NULL auto_increment, `name` varchar(150) default NULL, `categoryid` int(5) default NULL, `description` text, PRIMARY KEY (`id`) ) TYPE=MyISAM; /*Data for the table `brands` */ insert into `brands` values (1,'car',0,''), (2,'Fragrance',0,''), (7,'Others',NULL,NULL); /*Table structure for table `career` */ DROP TABLE IF EXISTS `career`; CREATE TABLE `career` ( `jobID` int(11) NOT NULL auto_increment, `jobName` varchar(50) default NULL, `description` longtext, `contactInformation` varchar(100) default NULL, `closingDate` datetime default NULL, `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`jobID`) ) TYPE=MyISAM; /*Data for the table `career` */ /*Table structure for table `categories` */ DROP TABLE IF EXISTS `categories`; CREATE TABLE `categories` ( `categoryID` int(11) NOT NULL auto_increment, `name` varchar(50) default NULL, `parentCategory` int(11) default '0', `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', `priority` int(11) default '100', `bannerID` int(11) NOT NULL default '0', PRIMARY KEY (`categoryID`) ) TYPE=MyISAM; /*Data for the table `categories` */ insert into `categories` values (102,'Electronics',0,'2006-11-06 00:00:00',1,20061116011550,1,2,0), (103,'Computer Hardware',0,'2006-11-06 00:00:00',1,20061116010733,1,4,0), (104,'Software',0,'2006-11-06 00:00:00',1,20061116010744,1,5,0), (105,'Games & Movies',0,'2006-11-06 00:00:00',1,20061116011356,1,12,0), (106,'Apparel',0,'2006-11-06 00:00:00',1,20061116011023,1,6,0), (107,'Shoes',0,'2006-11-06 00:00:00',1,20061116011205,1,7,0), (108,'Bath & Body',0,'2006-11-06 00:00:00',1,20061116011332,1,10,0), (109,'Childrens Toys',0,'2006-11-06 00:00:00',1,20061116011237,1,9,0), (110,'Accessories',103,'2006-11-06 00:00:00',1,20061106050031,1,0,0), (111,'Backup Devices & Media',103,'2006-11-06 00:00:00',1,20061106050105,1,0,0), (112,'Barebone & Accessories',103,'2006-11-06 00:00:00',1,20061106050144,1,0,0), (113,'Cases & External Enclosures',103,'2006-11-06 00:00:00',1,20061106050217,1,0,0), (114,'Automotive Electronics',102,'2006-11-06 00:00:00',1,20061129152012,1,0,38), (115,'Digital Frames',102,'2006-11-06 00:00:00',1,20061106050315,1,0,0), (116,'Electronic Gadgets',102,'2006-11-06 00:00:00',1,20061106050347,1,0,0), (117,'GPS & Accesories',102,'2006-11-06 00:00:00',1,20061106050409,1,0,0), (118,'Misc',108,'2006-11-06 00:00:00',1,20061106061753,1,0,0), (119,'Strapless Sandals',107,'2006-11-06 00:00:00',1,20061106065413,1,2,0), (128,'Fragrances',0,'2006-11-16 00:00:00',1,20061116011213,1,8,0), (121,'Misc',109,'2006-11-09 00:00:00',1,20061109114932,1,1,0), (122,'Other',121,'2006-11-09 00:00:00',1,20061109114953,1,0,0), (123,'Battery Cells',117,'2006-11-09 00:00:00',1,20061109224708,1,4,0), (124,'Unipolar Antennas',114,'2006-11-14 00:00:00',1,20061114010440,1,33,0), (125,'Automobiles',0,'2006-11-14 00:00:00',1,20061116011545,1,1,0), (129,'Women',128,'2006-11-16 00:00:00',1,20061116002232,1,0,0), (127,'Bumpers/Gadges/Wheels',126,'2006-11-14 00:00:00',1,20061114233418,1,3,0), (130,'Men',128,'2006-11-16 00:00:00',1,20061116002245,1,0,0), (131,'Gift Sets',128,'2006-11-16 00:00:00',1,20061116002259,1,0,0), (132,'Calling Cards',0,'2006-11-16 00:00:00',1,20061116011344,1,11,0), (133,'Microsoft',104,'2006-11-16 00:00:00',1,20061116004426,1,6,0), (134,'Adobe',104,'2006-11-16 00:00:00',1,20061116004332,1,1,0), (135,'Corel',104,'2006-11-16 00:00:00',1,20061116004443,1,2,0), (136,'DVD Copy',104,'2006-11-16 00:00:00',1,20061116004458,1,3,0), (137,'Intervideo',104,'2006-11-16 00:00:00',1,20061116004512,1,4,0), (138,'McAfee',104,'2006-11-16 00:00:00',1,20061116004533,1,5,0), (139,'Nero',104,'2006-11-16 00:00:00',1,20061116004550,1,7,0), (140,'Panda',104,'2006-11-16 00:00:00',1,20061116004615,1,8,0), (141,'Quicken',104,'2006-11-16 00:00:00',1,20061116004622,1,9,0), (142,'Roxio',104,'2006-11-16 00:00:00',1,20061116004638,1,10,0), (143,'Sage',104,'2006-11-16 00:00:00',1,20061116004658,1,11,0), (144,'Scansoft',104,'2006-11-16 00:00:00',1,20061116004712,1,12,0), (145,'Symantec',104,'2006-11-16 00:00:00',1,20061116004728,1,13,0), (146,'Womenswear',106,'2006-11-16 00:00:00',1,20061116004908,1,1,0), (147,'Menswear',106,'2006-11-16 00:00:00',1,20061116004919,1,2,0), (148,'Accessories',106,'2006-11-16 00:00:00',1,20061116004951,1,3,0), (149,'Accessories',146,'2006-11-16 00:00:00',1,20061116005026,1,1,0), (150,'Coats & Jackets',146,'2006-11-16 00:00:00',1,20061116005048,1,2,0), (151,'Dresses',146,'2006-11-16 00:00:00',1,20061116005114,1,3,0), (152,'Jeans',146,'2006-11-16 00:00:00',1,20061116005133,1,4,0), (153,'Skirts',146,'2006-11-16 00:00:00',1,20061116005143,1,5,0), (154,'Tops',146,'2006-11-16 00:00:00',1,20061116005153,1,6,0), (155,'Trousers & Shorts',146,'2006-11-16 00:00:00',1,20061116005213,1,7,0), (156,'Accessories',147,'2006-11-16 00:00:00',1,20061116005249,1,1,0), (157,'Coats & Jackets',147,'2006-11-16 00:00:00',1,20061116005305,1,2,0), (158,'Jeans',147,'2006-11-16 00:00:00',1,20061116005315,1,3,0), (159,'Knits & Sweats',147,'2006-11-16 00:00:00',1,20061116005335,1,4,0), (160,'Shirts',147,'2006-11-16 00:00:00',1,20061116005352,1,5,0), (161,'Tees & Polos',147,'2006-11-16 00:00:00',1,20061116005410,1,6,0), (162,'Trousers',147,'2006-11-16 00:00:00',1,20061116005424,1,7,0), (163,'Logo Tees',147,'2006-11-16 00:00:00',1,20061116005443,1,8,0), (165,'Cooling Devices',103,'2006-11-16 00:00:00',1,20061116005749,1,5,0), (166,'External Enclosures',103,'2006-11-16 00:00:00',1,20061116005803,1,6,0), (167,'Flash Memory & Readers',103,'2006-11-16 00:00:00',1,20061116005814,1,7,0), (168,'Hard Drives',103,'2006-11-16 00:00:00',1,20061116005827,1,8,0), (169,'Input Devices',103,'2006-11-16 00:00:00',1,20061116005836,1,9,0), (170,'Memory',103,'2006-11-16 00:00:00',1,20061116005849,1,10,0), (171,'Monitors',103,'2006-11-16 00:00:00',1,20061116005859,1,11,0), (172,'Motherboards',103,'2006-11-16 00:00:00',1,20061116005908,1,12,0), (173,'Power Protection',103,'2006-11-16 00:00:00',1,20061116005918,1,13,0), (174,'Power Supplies',103,'2006-11-16 00:00:00',1,20061116005928,1,14,0), (175,'Printers, Scanners & Faxes',103,'2006-11-16 00:00:00',1,20061116005940,1,15,0), (176,'Processors',103,'2006-11-16 00:00:00',1,20061116005953,1,16,0), (177,'Projectors',103,'2006-11-16 00:00:00',1,20061116010004,1,17,0), (178,'Servers',103,'2006-11-16 00:00:00',1,20061116010015,1,18,0), (179,'Sound Cards & MIDI Devices',103,'2006-11-16 00:00:00',1,20061116010026,1,19,0), (180,'Speakers & Headphones',103,'2006-11-16 00:00:00',1,20061116010036,1,20,0), (181,'Video Cards & Video Devices',103,'2006-11-16 00:00:00',1,20061116010046,1,21,0), (182,'Web/Surveillance Cameras',103,'2006-11-16 00:00:00',1,20061116010101,1,22,0), (183,'Jewelry',0,'2006-11-16 00:00:00',1,20061116010653,1,3,0), (184,'Acura',125,'2006-11-16 00:00:00',1,20061116011701,1,1,0), (185,'Audi',125,'2006-11-16 00:00:00',1,20061116011727,1,2,0), (186,'BMW',125,'2006-11-16 00:00:00',1,20061116011742,1,3,0), (187,'Buick',125,'2006-11-16 00:00:00',1,20061116011809,1,4,0), (188,'Cadillac',125,'2006-11-16 00:00:00',1,20061116011824,1,5,0), (189,'Chevrolet',125,'2006-11-16 00:00:00',1,20061116011841,1,6,0), (190,'Chrysler',125,'2006-11-16 00:00:00',1,20061116011913,1,7,0), (191,'Ford',125,'2006-11-16 00:00:00',1,20061116011948,1,8,0), (192,'GMC',125,'2006-11-16 00:00:00',1,20061116012006,1,9,0), (193,'Honda',125,'2006-11-16 00:00:00',1,20061116012019,1,10,0), (194,'Hummer',125,'2006-11-16 00:00:00',1,20061116012026,1,11,0), (195,'Hyundai',125,'2006-11-16 00:00:00',1,20061116012044,1,12,0), (196,'Infiniti',125,'2006-11-16 00:00:00',1,20061116012057,1,13,0), (197,'Isuzu',125,'2006-11-16 00:00:00',1,20061116012112,1,14,0), (198,'Jaguar',125,'2006-11-16 00:00:00',1,20061116012130,1,15,0), (199,'Jeep',125,'2006-11-16 00:00:00',1,20061116012145,1,16,0), (200,'Kia',125,'2006-11-16 00:00:00',1,20061116012157,1,17,0), (201,'Land Rover',125,'2006-11-16 00:00:00',1,20061116012220,1,18,0), (202,'Lexus',125,'2006-11-16 00:00:00',1,20061116012316,1,19,0), (203,'Lincoln',125,'2006-11-16 00:00:00',1,20061116012330,1,20,0), (204,'Mazda',125,'2006-11-16 00:00:00',1,20061116012417,1,21,0), (205,'Mercedes-Benz',125,'2006-11-16 00:00:00',1,20061116012439,1,22,0), (206,'Mercury',125,'2006-11-16 00:00:00',1,20061116012450,1,23,0), (207,'Mini',125,'2006-11-16 00:00:00',1,20061116012503,1,24,0), (208,'Mitsubishi',125,'2006-11-16 00:00:00',1,20061116012510,1,25,0), (209,'Nissan',125,'2006-11-16 00:00:00',1,20061116012621,1,26,0), (210,'Oldsmobile',125,'2006-11-16 00:00:00',1,20061116012631,1,27,0), (211,'Plymoth',125,'2006-11-16 00:00:00',1,20061116012655,1,28,0), (212,'Pontiac',125,'2006-11-16 00:00:00',1,20061116012707,1,29,0), (213,'Saturn',125,'2006-11-16 00:00:00',1,20061116012727,1,30,0), (214,'Scion',125,'2006-11-16 00:00:00',1,20061116012739,1,31,0), (215,'Subaru',125,'2006-11-16 00:00:00',1,20061116012802,1,32,0), (216,'Toyota',125,'2006-11-16 00:00:00',1,20061116012814,1,33,0), (217,'Volkswagon',125,'2006-11-16 00:00:00',1,20061116012828,1,34,0), (218,'Volvo',125,'2006-11-16 00:00:00',1,20061116012839,1,35,0), (219,'Mens',183,'2006-11-16 00:00:00',1,20061116013222,1,2,0), (220,'Womens',183,'2006-11-16 00:00:00',1,20061116013215,1,1,0), (221,'China Battery Cells',123,'2006-11-16 00:00:00',1,20061116104847,1,3,0), (222,'Express',158,'2006-11-16 00:00:00',1,20061116231628,1,1,0); /*Table structure for table `cities` */ DROP TABLE IF EXISTS `cities`; CREATE TABLE `cities` ( `cityID` int(11) NOT NULL auto_increment, `countryID` int(11) default '0', `cityName` char(50) default NULL, `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`cityID`) ) TYPE=MyISAM; /*Data for the table `cities` */ insert into `cities` values (1,1,'Islamabad','2005-03-29 20:15:05',1,20050414175713,1), (16,1,'Rawalpindi','2005-03-29 20:15:05',1,20050329201505,1), (14,1,'Peshawar','2005-03-29 20:14:49',1,20050329201449,1), (13,1,'Karachi','2005-03-29 20:14:18',1,20050329201418,1), (7,1,'Lahore','2005-04-03 15:40:07',1,20050403154007,1), (22,1,'Faisalabad','2005-03-29 20:16:52',1,20050329201652,1), (23,1,'Gujranwala','2005-03-29 20:16:59',1,20050329201659,1), (24,1,'Multan','2005-03-29 20:17:07',1,20050329201707,1), (28,1,'Gujrat','2005-03-29 20:17:24',1,20050329201724,1), (29,1,'Bahawalpur','2005-06-18 00:00:00',1,20050618100003,1), (30,1,'Sahiwal','2005-06-23 00:00:00',1,20050623113521,1); /*Table structure for table `config` */ DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` int(11) NOT NULL default '0', `discountFor` int(4) default '0', `discountRate` double default '0', `minOrderTotal` double NOT NULL default '10000', `premiumShippingInUSD` double default '2.53', PRIMARY KEY (`id`) ) TYPE=MyISAM; /*Data for the table `config` */ insert into `config` values (1,0,0,0,2.99); /*Table structure for table `contents` */ DROP TABLE IF EXISTS `contents`; CREATE TABLE `contents` ( `contentid` int(11) NOT NULL auto_increment, `title` varchar(50) default NULL, `maptitle` varchar(50) NOT NULL default '', `content` longtext, `showflag` tinyint(1) default NULL, `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`contentid`) ) TYPE=MyISAM; /*Data for the table `contents` */ insert into `contents` values (25,'aboutus','About Us','

About Us

\r\n
\r\n

Edit this information in admin panel.',1,'2005-03-30 16:45:35',1,20061106050614,1), (30,'contactus','Contact Us','\r\n\r\n\r\nUntitled Document\r\n\r\n\r\n\r\n\r\n

Our aim is to achieve 100% customer satisfaction and doing so give you a personalized shopping experience that is quick, reliable and more pleasurable.
\r\n
\r\n Should you have any questions or comments about the products, site or ordering service then we’ll be happy to help.
\r\n
\r\n You can contact us by one of the following methods
\r\n
\r\n Phone:
\r\n
\r\n Customer Service Hours:
\r\n Monday - Friday
\r\n 10am - 4pm EST.
\r\n
\r\n Office: +1 305-519-0037 (US)
\r\n Fax: +1 305-519-0038 (US)
\r\n
\r\n Email:
\r\n
\r\n • Support (support@giveudeals.com)
\r\n • Orders (sales@giveudeals.com)
\r\n • General (contact@giveudeals.com)
\r\n • Website (info@giveudeals.com)
\r\n
\r\n Live! Support
\r\n
\r\n • AOL Instant Messenger (GiveUDeals)
\r\n• Yahoo! Instant Messenger (GiveUDealz@yahoo.com)
\r\n• MSN Instant Messenge (GiveUDeals@hotmail.com)\r\n
\r\n
\r\nUnlike phone hours, we have Live! online support for late hours and normal business hours.
\r\nYou can click on the listed messengers under Live! Support and can speak to one of our representatives
\r\n(Please note that these functions require that you actually have the Messenger application installed and opened on your computer)
\r\n
\r\nUS Address:
\r\n
\r\n 951 NE 167th Street
\r\nSuite: 103
\r\nNorth Miami Beach, FL 33162

\r\n\r\n\r\n',1,'2005-04-11 13:22:22',1,20061116033216,1), (31,'privacy','Security & Privacy','

Security & Privacy

\r\n
\r\n

Edit this information in admin panel.',1,'2005-04-11 13:22:22',1,20061106050648,1), (32,'howtoorder','How To Order','

How To Order

\r\n
\r\n

Edit this information in admin panel.',1,'2005-04-11 13:22:22',1,20061106050730,1), (33,'paymentoptions','Payment Options','

Payment Options

\r\n
\r\n

Edit this in admin panel.',0,'2005-04-11 13:22:22',1,20061115010718,1), (38,'secureshopping','Secure Shopping','

Secure Shopping

\r\n
\r\n

Edit this in admin panel.',1,'2005-07-22 00:00:00',1,20061106050823,1), (40,'customer_service','Customer Service','

Customer Service

\r\n
\r\n

Edit this in admin panel.',1,'2006-11-06 00:00:00',1,20061106050927,1), (39,'policy','Privacy Policy','

Privacy Policy

\r\n
\r\n

Edit this in admin panel.',1,'2005-07-22 00:00:00',1,20061106050834,1); /*Table structure for table `corporateusers` */ DROP TABLE IF EXISTS `corporateusers`; CREATE TABLE `corporateusers` ( `userID` int(11) NOT NULL default '0', `companyName` varchar(50) default NULL, `introducedBy` varchar(255) default 'none', `description` varchar(255) default NULL, `companyRegNo` varchar(255) default NULL, `taxNumber` varchar(255) default NULL, `amountLimit` int(11) default '0', `balance` int(11) default '0', `discountPercentage` double default '0', `status` char(3) default 'PRE', `contactPerson` varchar(50) default NULL, `designation` varchar(50) default NULL, `phoneNo` varchar(50) default NULL, `email` varchar(100) default NULL, `addressline1` varchar(100) default NULL, `addressline2` varchar(100) default NULL, `addressline3` varchar(100) default NULL, `city` varchar(50) default NULL, `state` varchar(50) default NULL, `country` int(11) default NULL, `zipCode` varchar(50) default NULL, `created` datetime default NULL, `createdBy` int(11) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default NULL, PRIMARY KEY (`userID`) ) TYPE=MyISAM; /*Data for the table `corporateusers` */ insert into `corporateusers` values (10,'Aerolog Technologies','none','A leading firm','125255623-ABCD','125A-DKKK',200,723,5,'PRE','Mr. XYZ','Manager Administration','123456789','farhan@artologics.com','Location: ABC, 123 Main','Street, XYZ Bazar',NULL,'Islamabad','Punjab',1,'46000','2005-04-10 15:49:57',1,20050713202441,1), (11,'Artologics','none','A leading firm in xxx','123456799-LKJH','125A-DKKK',200,1000,10,'POS','Mr. Khaqan Mehmood','CEO','123456789','khaqan@artologics.com','Location: ABC, 123 Main','Street, XYZ Bazar','','Rawalpindi','Punjab',1,'46000','2005-04-11 15:26:08',1,20050415160500,1); /*Table structure for table `countries` */ DROP TABLE IF EXISTS `countries`; CREATE TABLE `countries` ( `countryID` int(11) NOT NULL auto_increment, `countryName` varchar(200) default NULL, `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`countryID`) ) TYPE=MyISAM; /*Data for the table `countries` */ insert into `countries` values (2,'United States of America','2005-04-03 15:59:56',1,20061110083612,1); /*Table structure for table `courier` */ DROP TABLE IF EXISTS `courier`; CREATE TABLE `courier` ( `courierID` int(11) NOT NULL auto_increment, `name` varchar(50) default NULL, `url` longtext, `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`courierID`) ) TYPE=MyISAM; /*Data for the table `courier` */ insert into `courier` values (8,'FedEx 2Day','http://www.fedex.com/','2006-11-27 00:00:00',1,20061127131323,1), (7,'FedEx Standard Overnight','http://www.fedex.com/','2006-11-27 00:00:00',1,20061127131302,1), (9,'FedEx Express Saver','http://www.fedex.com/','2006-11-27 00:00:00',1,20061127131353,1), (10,'USPS Express','http://www.usps.com/','2006-11-27 00:00:00',1,20061127131414,1), (11,'USPS Priority','http://www.usps.com/','2006-11-27 00:00:00',1,20061127131430,1); /*Table structure for table `coveragecities` */ DROP TABLE IF EXISTS `coveragecities`; CREATE TABLE `coveragecities` ( `cityID` int(11) default '0', `productID` int(11) default '0', `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0' ) TYPE=MyISAM; /*Data for the table `coveragecities` */ /*Table structure for table `currency` */ DROP TABLE IF EXISTS `currency`; CREATE TABLE `currency` ( `currencyID` int(11) NOT NULL auto_increment, `currencyName` varchar(20) default NULL, `displaySymbol` varchar(20) default NULL, `exchangeRate` double default '0', `created` datetime default NULL, `createdby` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedby` int(11) default '0', PRIMARY KEY (`currencyID`) ) TYPE=MyISAM; /*Data for the table `currency` */ insert into `currency` values (1,'USD','$',1,'2005-03-30 00:00:00',1,20061106085719,1); /*Table structure for table `databaseactivitylog` */ DROP TABLE IF EXISTS `databaseactivitylog`; CREATE TABLE `databaseactivitylog` ( `activityID` int(11) NOT NULL auto_increment, `userid` int(11) default '0', `queryPerformed` longtext, `type` longtext, `created` timestamp(14) NOT NULL, PRIMARY KEY (`activityID`) ) TYPE=MyISAM; /*Data for the table `databaseactivitylog` */ insert into `databaseactivitylog` values (661,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Casualwear\',\'0\',\'100\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827230514), (662,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Formalwear\',\'0\',\'200\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827230530), (663,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Occasions\',\'0\',\'300\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827230700), (664,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Accessories\',\'0\',\'400\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827230908), (665,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Tops\',\'53\',\'110\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231037), (666,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Trousers\',\'53\',\'120\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231209), (667,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Skirts\',\'53\',\'130\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231229), (668,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Blouses\',\'53\',\'140\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231246), (669,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Tops\',\'54\',\'210\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231526), (670,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Trousers\',\'54\',\'220\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231546), (671,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Skirts\',\'54\',\'230\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231605), (672,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Suits\',\'54\',\'240\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231645), (673,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Dresses\',\'0\',\'250\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827231708), (674,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'ID Collection Top\',\'\',\'\',\'test\',\'test\',1,0,0,0,\'#\',0,0.1,\'products/middleIDformal.jpg\',\'products/middleIDformal.jpg\',\'products/middleIDformal.jpg\',\'no\',\'no\',0,0,1,1,0,\'2005/08/27\',1,1)','Password updated by admin',20050827233744), (675,1,'update categories set name=\'Dresses\',parentCategory=\'54\',priority=\'250\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'65\'','Category info updated',20050827235422), (676,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Bridesmaid\',\'55\',\'310\',\'2005/08/27\',\'1\',\'1\',\'0\')','New Category added',20050827235732), (677,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Mother of Bride/Groom\',\'55\',\'320\',\'2005/08/28\',\'1\',\'1\',\'0\')','New Category added',20050828000822), (678,1,'update categories set name=\'Bridesmaid\',parentCategory=\'55\',priority=\'320\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'66\'','Category info updated',20050828000858), (679,1,'update categories set name=\'Mother of Bride/Groom\',parentCategory=\'55\',priority=\'310\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'67\'','Category info updated',20050828000911), (680,1,'update adminusers set firstName=\'Muhammad\', lastName=\'Shahzad\', canAddProducts=\'0\', canUpdateProducts=\'1\', canAccessInventoryControl=\'1\', canRelateProducts=\'1\', canViewOrders=\'1\', canUpdateOrders=\'1\', canDeleteOrders=\'1\', canAddCategories=\'1\', canUpdateCategories=\'1\', canSendNewsletter=\'1\', canViewMailingList=\'1\', canViewSearchStrings=\'1\', canControlJobs=\'1\', canViewSupport=\'1\', canManageSupport=\'1\', canManageFeedback=\'1\', canManageBanners=\'1\', canAddCMS=\'1\', canUpdateCMS=\'1\', canManageNoticeboard=\'1\', canControlAdminAccounts=\'1\', canControlCorporateAccounts=\'1\', canControlGeneralAccounts=\'1\', canUpdatePaymentGateways=\'1\', canChangeCurrencySettings=\'1\', canControlShipmentCharges=\'1\', canManageCouriers=\'1\', canManageCountries=\'1\', canManageCities=\'1\' where adminID= \'1\'','Administrator previlages updated',20050828101452), (681,1,'update adminusers set firstName=\'Muhammad\', lastName=\'Shahzad\', canAddProducts=\'1\', canUpdateProducts=\'1\', canAccessInventoryControl=\'1\', canRelateProducts=\'1\', canViewOrders=\'1\', canUpdateOrders=\'1\', canDeleteOrders=\'1\', canAddCategories=\'1\', canUpdateCategories=\'1\', canSendNewsletter=\'1\', canViewMailingList=\'1\', canViewSearchStrings=\'1\', canControlJobs=\'1\', canViewSupport=\'1\', canManageSupport=\'1\', canManageFeedback=\'1\', canManageBanners=\'1\', canAddCMS=\'1\', canUpdateCMS=\'1\', canManageNoticeboard=\'1\', canControlAdminAccounts=\'1\', canControlCorporateAccounts=\'1\', canControlGeneralAccounts=\'1\', canUpdatePaymentGateways=\'1\', canChangeCurrencySettings=\'1\', canControlShipmentCharges=\'1\', canManageCouriers=\'1\', canManageCountries=\'1\', canManageCities=\'1\' where adminID= \'1\'','Administrator previlages updated',20050828101522), (682,1,'insert into useraccounts (loginName,password,type,email,created,createdBy,updatedBy) values (\'eb\',\'eb\',\'a\',\'ebdeveloper@yahoo.com\',\'2005/08/28\',\'Admin ID: 1\',\'Admin ID: 1\')','Administrator account created',20050828102100), (683,1,'INSERT INTO `adminusers` \n (`adminID`,`firstName`, `lastName`, \n `canAddProducts`, `canUpdateProducts`, `canAccessInventoryControl`, \n `canRelateProducts`, `canViewOrders`, `canUpdateOrders`, \n `canDeleteOrders`, `canAddCategories`, `canUpdateCategories`, \n `canSendNewsletter`, `canViewMailingList`, `canViewSearchStrings`, canControlJobs,\n `canViewSupport`, `canManageSupport`, `canManageFeedback`, \n `canManageBanners`, `canAddCMS`, `canUpdateCMS`, \n `canManageNoticeboard`, `canControlAdminAccounts`, `canControlCorporateAccounts`, `canControlGeneralAccounts`, \n `canUpdatePaymentGateways`, `canChangeCurrencySettings`, `canControlShipmentCharges`, \n `canManageCouriers`, `canManageCountries`, `canManageCities`,created,createdBy) \n VALUES (\'19\',\'eb\', \'eb\', \n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \'1\',\n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\',\'2005/08/28\',\'1\')','Administrator account created',20050828102100), (684,0,'insert into searchstrings(searchText,timesSearch,created,createdBy,updatedBy) values(\'sd\',1,\'2005/08/28\',\'62.183.100.121\',\'62.183.100.121\')','Search has been performed by a user',20050828102320), (685,0,'insert into searchstrings(searchText,timesSearch,created,createdBy,updatedBy) values(\'asdasd\',1,\'2005/08/28\',\'62.183.100.121\',\'62.183.100.121\')','Search has been performed by a user',20050828102424), (686,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'62.183.100.121\' where searchText=\'a\'','Search has been performed by a user',20050828102434), (687,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'62.183.100.121\' where searchText=\'s\'','Search has been performed by a user',20050828102440), (688,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'62.183.100.121\' where searchText=\'o\'','Search has been performed by a user',20050828102452), (689,1,'delete from generaluser where userID = \'17\'','General user is deleted',20050828111939), (690,1,'delete from useraccounts where accountID = \'17\'','Remove entry from useraccounts',20050828111939), (691,1,'insert into `weightcosting` (`countryID`,`courierID`,`weightMin`,`WeightMax`,`shipCost`,created, `createdby`,`updatedBy`) values(\'2\',\'1\',\'22\',\'223\',\'1\',\'2005/08/28\',\'1\',\'1\')','Weight Costing is added',20050828112321), (692,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'ID Top\',\'\',\'\',\'\',\'test\',1,0,0,0,\'#\',0,100,\'products/middleidblacktop.jpg\',\'products/middleidblacktopskirt.jpg\',\'no\',\'no\',\'no\',0,0,1,1,0,\'2005/08/28\',1,1)','Password updated by admin',20050828171853), (693,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'ID Black Top\',\'\',\'\',\'\',\'test\',1,0,0,0,\'#\',0,100,\'products/middleidblacktop.jpg\',\'products/middleidblacktopskirt.jpg\',\'no\',\'no\',\'no\',0,0,1,1,0,\'2005/08/29\',1,1)','Password updated by admin',20050829200742), (694,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'ID Top 7002\',\'\',\'7002\',\'\',\'Bubble Georgette fabric short sleeve top.\',1,0,0,0,\'#\',0,150,\'products/middleID7002TOPCLOSEBROWN.jpg\',\'products/middleID7002TOPCLOSEBROWN.jpg\',\'products/middleID7002TOPN6926SKIRTBROWN.jpg\',\'no\',\'no\',0,0,1,1,0,\'2005/09/04\',1,1)','Password updated by admin',20050904203315), (695,0,'insert into searchstrings(searchText,timesSearch,created,createdBy,updatedBy) values(\'top\',1,\'2005/09/07\',\'212.240.194.236\',\'212.240.194.236\')','Search has been performed by a user',20050907171205), (696,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'212.240.194.236\' where searchText=\'top\'','Search has been performed by a user',20050907171235), (697,1,'insert into useraccounts (loginName,password,type,email,created,createdBy,updatedBy) values (\'test\',\'test\',\'a\',\'test\',\'2005/09/13\',\'Admin ID: 1\',\'Admin ID: 1\')','Administrator account created',20050913214534), (698,1,'INSERT INTO `adminusers` \n (`adminID`,`firstName`, `lastName`, \n `canAddProducts`, `canUpdateProducts`, `canAccessInventoryControl`, \n `canRelateProducts`, `canViewOrders`, `canUpdateOrders`, \n `canDeleteOrders`, `canAddCategories`, `canUpdateCategories`, \n `canSendNewsletter`, `canViewMailingList`, `canViewSearchStrings`, canControlJobs,\n `canViewSupport`, `canManageSupport`, `canManageFeedback`, \n `canManageBanners`, `canAddCMS`, `canUpdateCMS`, \n `canManageNoticeboard`, `canControlAdminAccounts`, `canControlCorporateAccounts`, `canControlGeneralAccounts`, \n `canUpdatePaymentGateways`, `canChangeCurrencySettings`, `canControlShipmentCharges`, \n `canManageCouriers`, `canManageCountries`, `canManageCities`,created,createdBy) \n VALUES (\'20\',\'test\', \'test\', \n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \n \'0\', \'1\', \'1\', \n \'1\', \'1\', \'0\', \'1\',\n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\', \n \'1\', \'1\', \'1\',\'2005/09/13\',\'1\')','Administrator account created',20050913214534), (699,1,'delete from adminusers where adminID = \'20\'','Delete an admin account',20050913224807), (700,1,'delete from useraccounts where accountID = \'20\'','Remove entry from useraccounts',20050913224807), (701,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(64,\'Busy Triple Stitched Jacket\',\'Busy Triple Stitched Jacket\',\'\',\'\',\'

Busy jacket

\',1,0,0,0,\'#\',0,300,\'products/middlebusyredtriplejacket.jpg\',\'products/middlebusyredtriplejacket.jpg\',\'products/middlebusyredtriplestitch.jpg\',\'no\',\'no\',0,0,1,1,0,\'2005/09/14\',1,1)','Password updated by admin',20050914232004), (702,1,'update products set image1=\'products/middlebusyredtriplejacket.jpg\',image2=\'products/middlebusyredtripletrouser.jpg\',image3=\'products/middlebusyredtriplejacket.jpg\', categoryID=64,productName=\'Busy Triple Stitched Jacket\',companyCode=\'Busy Triple Stitched Jacket\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Busy jacket

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=1,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 168','Password updated by admin',20050914232725), (703,1,'update products set image1=\'products/middlebusyredtriplejacket.jpg\',image2=\'products/middlebusyredtriplestitch.jpg\',image3=\'products/middlebusyredtriplejacket.jpg\', categoryID=64,productName=\'Busy Triple Stitched Jacket\',companyCode=\'Busy Triple Stitched Jacket\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Busy jacket

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=3,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 168','Password updated by admin',20050914232829), (704,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(64,\'Busy Triple Stitched Trouser\',\'Busy Triple Stitched Trouser\',\'\',\'\',\'Busy trouser\',1,0,0,0,\'#\',0,200,\'products/middlebusyredtripletrouser.jpg\',\'products/middlebusyredtriplestitch.jpg\',\'products/middlebusyredtripletrouser.jpg\',\'no\',\'no\',0,0,1,1,0,\'2005/09/14\',1,1)','Password updated by admin',20050914233148), (705,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'ID 1167\',\'\',\'\',\'\',\'id 1167\',1,0,0,0,\'#\',0,200,\'products/middleid1167.jpg\',\'products/middleid1167.jpg\',\'products/middleid1167top6190skirt.jpg\',\'products/middleid1167pinkblk.jpg\',\'products/middleid1167toppink6190skirtblk.jpg\',0,1,0,1,0,\'2005/09/14\',1,1)','Password updated by admin',20050914233753), (706,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'ID 1167\',\'\',\'\',\'\',\'ID 1167 Top\',1,0,0,0,\'#\',0,200,\'products/middleid1167.jpg\',\'products/middleid1167toppink6190skirtblk.jpg\',\'products/middleid1167pinkblk.jpg\',\'products/middleid1167top6190skirt.jpg\',\'products/middleid1167.jpg\',0,0,0,1,0,\'2005/09/14\',1,1)','Password updated by admin',20050914234444), (707,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(63,\'ID 6926 \',\'\',\'\',\'\',\'ID 6926 skirt in camel brown and black, matching ID top 7002. Lined georgette\',1,0,0,0,\'#\',0,200,\'products/middleID6926SKIRTCAMEL.jpg\',\'products/middleID6926SKIRTBROWN.jpg\',\'products/middleID6926SKIRTBLACK.jpg\',\'products/middleID6926SKIRTCAMEL.jpg\',\'products/middleID7002TOPN6926SKIRTBROWN.jpg\',0,1,0,1,0,\'2005/09/15\',1,1)','Password updated by admin',20050915131703), (708,1,'update products set image1=\'products/middleID6926SKIRTCAMEL.jpg\',image2=\'products/middleID6926SKIRTBLACK2.jpg\',image3=\'products/middleID6926SKIRTBROWN.jpg\',image4=\'products/middleID7002TOPN6926SKIRTCAMEL.jpg\',image5=\'products/middleID6926SKIRTCAMEL.jpg\', categoryID=63,productName=\'ID 6926\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'ID 6926 skirt in camel brown and black, matching ID top 7002. Lined georgette \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=1,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 172','Password updated by admin',20050915132337), (709,1,'update products set image1=\'products/middleID7002TOPCLOSECAMEL.jpg\',image2=\'products/middleID7002TOPCLOSEBLACK.jpg\',image3=\'products/middleID7002TOPCLOSEBROWN.jpg\',image4=\'products/middleID7002TOPCLOSECAMEL.jpg\',image5=\'products/middleID7002TOPN6926SKIRTBROWN.jpg\', categoryID=61,productName=\'ID Top 7002\',companyCode=\'\',supplierCode=\'7002\',shortDescription=\'\',longDescription=\'Bubble Georgette fabric short sleeve top. \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=150,viewed=8,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 167','Password updated by admin',20050915132616), (710,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'Xtra Details Coins\',\'Bigstuff Xtra Details Coins Sleeveless\',\'\',\'\',\'Xtra Details sleeveless top with coins\',1,0,0,0,\'#\',0,250,\'products/middlextracoinssleeveless.jpg\',\'products/middlextracoinssleeveless2.jpg\',\'products/middlextracoinssleeveless.jpg\',\'no\',\'no\',0,1,0,1,0,\'2005/09/15\',1,1)','Password updated by admin',20050915133752), (711,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'203.99.49.90\' where searchText=\' \'','Search has been performed by a user',20050917071055), (712,0,'insert into searchstrings(searchText,timesSearch,created,createdBy,updatedBy) values(\'sf\',1,\'2005/09/17\',\'203.99.49.90\',\'203.99.49.90\')','Search has been performed by a user',20050917073228), (713,0,'insert into searchstrings(searchText,timesSearch,created,createdBy,updatedBy) values(\'gdg\',1,\'2005/09/17\',\'203.99.49.90\',\'203.99.49.90\')','Search has been performed by a user',20050917073757), (714,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'203.99.49.90\' where searchText=\'s\'','Search has been performed by a user',20050917074432), (715,0,'insert into mailinglist(email,subscribed,created,createdBy,updatedBy) values(\'adad@dsdf.com\',1,\'2005/09/17\',\'203.99.49.90\',\'203.99.49.90\')','An email address was subscribed',20050917000000), (716,0,'insert into mailinglist(email,subscribed,created,createdBy,updatedBy) values(\'khaqan99@yahoo.com\',1,\'2005/09/17\',\'203.99.49.90\',\'203.99.49.90\')','An email address was subscribed',20050917000000), (717,0,'insert into mailinglist(email,subscribed,created,createdBy,updatedBy) values(\'khaqan99@yahoo.com\',1,\'2005/09/17\',\'203.99.49.90\',\'203.99.49.90\')','An email address was subscribed',20050917000000), (718,0,'insert into mailinglist(email,subscribed,created,createdBy,updatedBy) values(\'khaqan99@yahoo.com\',1,\'2005/09/17\',\'203.99.49.90\',\'203.99.49.90\')','An email address was subscribed',20050917000000), (719,0,'update mailinglist set subscribed=\'0\',updated=\'2005/09/17\',updatedBy=\'203.99.49.90\' where email=\'khaqan99@yahoo.com\'','An email address was Unsubscribed',20050917000000), (720,0,'insert into feedback(comments,name,city,state,country,sex,age,email,learnFrom,created,createdBy,updatedBy) values(\'testing.com is the best site of the world. plz. compay that site and visit tht site.\r\n\r\nthanx.\r\ntester.\',\'Testing\',\'islamabad\',\'Punjab\',\'PAkistan\',\'Male\',\'21\',\'testing@testing.com\',\'testing.com\',\'2005/09/17\',\'203.99.49.90\',\'203.99.49.90\')','Feedback sent',20050917100507), (721,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(64,\'Busy Single Stitch Jacket\',\'Busy Single Stitch Jacket\',\'\',\'\',\'

Single stitched collar and pocket Busy suit jacket

\',1,0,0,0,\'#\',0,300,\'products/middlebusysinglestitchjackdarkgre.jpg\',\'products/middlebusysinglestitchblacksuit.jpg\',\'products/middlebusysinglestitchjackblack.jpg\',\'products/middlebusysinglestitchjackdarkgre.jpg\',\'no\',0,0,0,1,0,\'2005/09/19\',1,1)','Password updated by admin',20050919193123), (722,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(64,\'Busy Single Stitch Trouser\',\'Busy Single Stitch Trouser\',\'\',\'\',\'

Matching trouser for Busy single stitch jacket

\',1,0,0,0,\'#\',0,200,\'products/middlebusydarkgreentrouser.jpg\',\'products/middlebusysinglestitchblacksuit.jpg\',\'products/middlebusyblacktrouser.jpg\',\'products/middlebusydarkgreentrouser.jpg\',\'no\',0,0,0,1,0,\'2005/09/19\',1,1)','Password updated by admin',20050919193807), (723,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'Busy Bubble Top\',\'Busy Bubble Top\',\'\',\'\',\'\',1,0,0,0,\'#\',0,100,\'products/middlebusybubbletopcreme.jpg\',\'products/middlebusybubbletopcreme.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/09/19\',1,1)','Password updated by admin',20050919194118), (724,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(61,\'Busy Bubble Top\',\'Busy Bubble Top\',\'\',\'\',\'Bubble top, goes well with busy suits\',1,0,0,0,\'#\',0,100,\'products/middlebusybubbletopcreme.jpg\',\'products/middlebusybubbletopcreme.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/09/19\',1,1)','Password updated by admin',20050919194236), (725,1,'update products set categoryID=61,productName=\'Busy Bubble Top\',companyCode=\'Busy Bubble Top\',supplierCode=\'\',shortDescription=\'\',longDescription=\'a\', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=100,viewed=1,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 176','Password updated by admin',20050919194518), (726,1,'update products set categoryID=61,productName=\'ID Top\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'test \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=100,viewed=16,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 165','Password updated by admin',20050919194632), (727,1,'update products set categoryID=61,productName=\'ID 1167\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'id 1167 \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=3,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 170','Password updated by admin',20050919194730), (728,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(57,\'Bigstuff Top\',\'Bigstuff top oval neck strap back brown and black\',\'\',\'\',\'Bigstuff top with oval neck and straps on upper back\',1,0,0,0,\'#\',0,200,\'products/middlebigstuffbrowncasual.jpg\',\'products/middlebigstuffbrowncasual.jpg\',\'no\',\'no\',\'no\',0,0,1,1,0,\'2005/09/19\',1,1)','Password updated by admin',20050919195018), (729,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(58,\'Embroidered Combat Trousers\',\'Embroidered Combat Trousers\',\'\',\'\',\'Embroidered combat trousers \',1,0,0,0,\'#\',0,250,\'products/middleembroideredcombats.jpg\',\'products/middleembroideredcombats.jpg\',\'no\',\'no\',\'no\',0,0,1,1,0,\'2005/09/19\',1,1)','Password updated by admin',20050919195458), (730,1,'update paymentgateways set accountInfo=\'398825\',gatewayEnabled=\'1\',description=\'\r\n\r\n\r\n\r\n\r\n
2CO accepts customer orders via online checks, Visa, MasterCard, Discover, American Express, Dinners, JCB and debit cards
\',updatedBy=\'1\' where gatewayID=1','Payment gateway is updated',20050924225205), (731,1,'update categories set name=\'Tops & Blouses\',parentCategory=\'0\',priority=\'300\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'55\'','Category info updated',20050925191526), (732,1,'update categories set name=\'Tops & Blouses\',parentCategory=\'0\',priority=\'100\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'53\'','Category info updated',20050925195112), (733,1,'update categories set name=\'Trousers & Skirts\',parentCategory=\'0\',priority=\'200\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'54\'','Category info updated',20050925195206), (734,1,'update categories set name=\'Suits\',parentCategory=\'0\',priority=\'300\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'55\'','Category info updated',20050925195254), (735,1,'update categories set name=\'Dresses\',parentCategory=\'0\',priority=\'400\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'56\'','Category info updated',20050925195324), (736,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Jackets & Coats\',\'0\',\'500\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925195353), (737,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Denim\',\'0\',\'600\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925195415), (738,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Knitwear\',\'0\',\'700\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925195436), (739,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Lingerie & Nightwear\',\'0\',\'800\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925195508), (740,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Shoes & Bags\',\'0\',\'900\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925195619), (741,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Tops\',\'53\',\'100\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925195825), (742,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Blouses\',\'53\',\'100\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925195849), (743,1,'update products set status=0 where categoryID = \'53\'','Category deleted',20050925200001), (744,1,'delete from categories where parentCategory = \'53\'','Deleting child categories',20050925200001), (745,1,'delete from categories where categoryID = \'53\'','Category deleted',20050925200002), (746,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Tops & Blouses\',\'0\',\'100\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925200054), (747,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Blouses\',\'75\',\'110\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925200121), (748,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Tops\',\'0\',\'120\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925200143), (749,1,'update products set status=0 where categoryID = \'77\'','Category deleted',20050925200209), (750,1,'delete from categories where parentCategory = \'77\'','Deleting child categories',20050925200209), (751,1,'delete from categories where categoryID = \'77\'','Category deleted',20050925200209), (752,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Tops\',\'75\',\'120\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925200227), (753,1,'update products set status=0 where categoryID = \'76\'','Category deleted',20050925200250), (754,1,'delete from categories where parentCategory = \'76\'','Deleting child categories',20050925200250), (755,1,'delete from categories where categoryID = \'76\'','Category deleted',20050925200250), (756,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Blouses\',\'75\',\'110\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925200325), (757,1,'update products set categoryID=78,productName=\'Busy Bubble Top\',companyCode=\'Busy Bubble Top\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Bubble top, goes well with busy suits \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=100,viewed=2,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 177','Password updated by admin',20050925200421), (758,1,'update products set categoryID=78,productName=\'Xtra Details Coins\',companyCode=\'Bigstuff Xtra Details Coins Slee\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Xtra Details sleeveless top with coins \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=250,viewed=3,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 173','Password updated by admin',20050925200444), (759,1,'update products set categoryID=78,productName=\'ID 1167\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'ID 1167 Top \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=4,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 171','Password updated by admin',20050925200507), (760,1,'update products set categoryID=78,productName=\'ID Collection Top\',companyCode=\'\',supplierCode=\'\',shortDescription=\'test\',longDescription=\'test \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=0.1,viewed=14,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 164','Password updated by admin',20050925200541), (761,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Formal\',\'55\',\'310\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925200645), (762,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Occasions\',\'55\',\'320\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925200749), (763,1,'update products set status=0 where categoryID = \'67\'','Category deleted',20050925200825), (764,1,'delete from categories where parentCategory = \'67\'','Deleting child categories',20050925200825), (765,1,'delete from categories where categoryID = \'67\'','Category deleted',20050925200825), (766,1,'update products set status=0 where categoryID = \'55\'','Category deleted',20050925200836), (767,1,'delete from categories where parentCategory = \'55\'','Deleting child categories',20050925200836), (768,1,'delete from categories where categoryID = \'55\'','Category deleted',20050925200836), (769,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Suits\',\'0\',\'300\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925201424), (770,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Formal\',\'82\',\'310\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925201450), (771,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Occasions\',\'82\',\'320\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925201508), (772,1,'update products set categoryID=83,productName=\'Busy Single Stitch Jacket\',companyCode=\'Busy Single Stitch Jacket\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Single stitched collar and pocket Busy suit jacket

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=1,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 174','Password updated by admin',20050925201532), (773,1,'update products set categoryID=64,productName=\'Busy Single Stitch Trouser\',companyCode=\'Busy Single Stitch Trouser\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Matching trouser for Busy single stitch jacket

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=0,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 175','Password updated by admin',20050925201542), (774,1,'update products set categoryID=83,productName=\'Busy Single Stitch Trouser\',companyCode=\'Busy Single Stitch Trouser\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Matching trouser for Busy single stitch jacket

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=0,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 175','Password updated by admin',20050925201616), (775,1,'update products set categoryID=83,productName=\'Busy Triple Stitched Jacket\',companyCode=\'Busy Triple Stitched Jacket\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Busy jacket

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=9,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 168','Password updated by admin',20050925201642), (776,1,'update products set categoryID=83,productName=\'Busy Triple Stitched Trouser\',companyCode=\'Busy Triple Stitched Trouser\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Busy trouser \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=8,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 169','Password updated by admin',20050925201656), (777,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Jeans\',\'69\',\'610\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925201843), (778,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Jackets\',\'69\',\'620\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925201906), (779,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Skirts\',\'69\',\'630\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925201926), (780,1,'update products set categoryID=84,productName=\'ID 6926\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'ID 6926 skirt in camel brown and black, matching ID top 7002. Lined georgette \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=3,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 172','Password updated by admin',20050925202020), (781,1,'update products set categoryID=84,productName=\'ID Top 7002\',companyCode=\'\',supplierCode=\'7002\',shortDescription=\'\',longDescription=\'Bubble Georgette fabric short sleeve top. \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=150,viewed=11,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 167','Password updated by admin',20050925202043), (782,1,'update products set categoryID=84,productName=\'ID Black Top\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'test \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=100,viewed=19,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 166','Password updated by admin',20050925202104), (783,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Cardigans\',\'70\',\'710\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925202158), (784,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Jumpers\',\'70\',\'720\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925202215), (785,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Bras\',\'71\',\'810\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925202305), (786,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Night Dresses\',\'71\',\'820\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925202344), (787,1,'update products set status=0 where categoryID = \'54\'','Category deleted',20050925202445), (788,1,'delete from categories where parentCategory = \'54\'','Deleting child categories',20050925202446), (789,1,'delete from categories where categoryID = \'54\'','Category deleted',20050925202446), (790,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Trousers & Skirts\',\'0\',\'200\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925202553), (791,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Casual Trousers\',\'92\',\'210\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925202643), (792,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Formal Trousers\',\'92\',\'220\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925202705), (793,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Skirts\',\'92\',\'230\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925202731); insert into `databaseactivitylog` values (794,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(83,\'Busy Black Stripe Jacket\',\'\',\'\',\'\',\'Busy Black Stripe Jacket\',1,0,0,0,\'#\',0,300,\'products/middlebusyblackstripejacket.jpg\',\'products/middlebusyblackstripesuit.jpg\',\'products/middlebusyblackstripejacket.jpg\',\'no\',\'no\',0,1,1,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925214120), (795,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(87,\'Embroidered Pocket Jean\',\'\',\'\',\'\',\'Embroidered Pocket Jean\',1,0,0,0,\'#\',0,200,\'products/middlejean1pic1.jpg\',\'products/middlejean1pic2.jpg\',\'products/middlejean1pic2.jpg\',\'products/middlejean1pic1.jpg\',\'no\',0,1,1,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925214614), (796,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(87,\'Embroidered Pocket Jean\',\'\',\'\',\'\',\'Embroidered Pocket Jean\',1,0,0,0,\'#\',0,200,\'products/middlejean1pic1.jpg\',\'products/middlejean1pic2.jpg\',\'products/middlejean1pic2.jpg\',\'products/middlejean1pic1.jpg\',\'no\',0,1,1,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925214629), (797,1,'update products set categoryID=85,productName=\'Embroidered Pocket Jean\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Embroidered Pocket Jean \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=1,newProduct=1,bestSeller=1,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 181','Password updated by admin',20050925214845), (798,1,'update products set categoryID=85,productName=\'Embroidered Pocket Jean\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Embroidered Pocket Jean \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=2,newProduct=1,bestSeller=1,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 181','Password updated by admin',20050925214922), (799,1,'update products set categoryID=85,productName=\'Embroidered Pocket Jean\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Embroidered Pocket Jean \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=2,newProduct=1,bestSeller=1,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 182','Password updated by admin',20050925214934), (800,1,'update products set categoryID=85,productName=\'Embroidered Pocket Jean\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Embroidered Pocket Jean \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=2,newProduct=1,bestSeller=1,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 182','Password updated by admin',20050925215037), (801,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(85,\'Embroidered Pocket Jean\',\'\',\'\',\'\',\'Embroidered Pocket Jean\',1,0,0,0,\'#\',0,200,\'products/middlejean1pic1.jpg\',\'products/middlejean1pic3.jpg\',\'products/middlejean1pic2.jpg\',\'products/middlejean1pic1.jpg\',\'no\',0,1,1,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925215131), (802,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(85,\'Front Embroidered Jean\',\'\',\'\',\'\',\'Front Embroidered Jean\',1,0,0,0,\'#\',0,200,\'products/middlejean2.jpg\',\'products/middlejean2.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925215526), (803,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(85,\'Pocket Embroidered Jean Brown\',\'\',\'\',\'\',\'Pocket Embroidered Jean Brown\',1,0,0,0,\'#\',0,200,\'products/middlejean3.jpg\',\'products/middlejean3pic2.jpg\',\'products/middlejean3.jpg\',\'no\',\'no\',0,0,1,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925215727), (804,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Coats & Jackets\',\'68\',\'510\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925220052), (805,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(96,\'Brown Fur Bodywarmer\',\'\',\'\',\'\',\'Brown Fur Bodywarmer\',1,0,0,0,\'#\',0,400,\'products/middleleatherbodywarmer.jpg\',\'products/middleleatherbodywarmer.jpg\',\'no\',\'no\',\'no\',0,1,1,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925220156), (806,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Dresses\',\'56\',\'410\',\'2005/09/25\',\'1\',\'1\',\'0\')','New Category added',20050925220438), (807,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(95,\'Black and Red Dress\',\'\',\'\',\'\',\'Black and Red Dress\',1,0,0,0,\'#\',0,300,\'products/middleblkreddress.jpg\',\'products/middleblkreddress2.jpg\',\'products/middleblkreddress.jpg\',\'no\',\'no\',0,0,1,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925220600), (808,1,'update products set categoryID=97,productName=\'Black and Red Dress\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Black and Red Dress \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=0,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 187','Password updated by admin',20050925220751), (809,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(97,\'Brown Dress\',\'\',\'\',\'\',\'Brown Dress\',1,0,0,0,\'#\',0,400,\'products/middledarkbrowndress.jpg\',\'products/middledarkbrowndress2.jpg\',\'products/middledarkbrowndress.jpg\',\'no\',\'no\',0,1,0,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925220953), (810,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(95,\'Dark Pink Dress\',\'\',\'\',\'\',\'Dark Pink Dress\',1,0,0,0,\'#\',0,400,\'products/middledarkpinkdress.jpg\',\'products/middledarkpinkdress2.jpg\',\'products/middledarkpinkdress.jpg\',\'no\',\'no\',0,1,1,1,0,\'2005/09/25\',1,1)','Password updated by admin',20050925221311), (811,1,'update products set categoryID=97,productName=\'Dark Pink Dress\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Dark Pink Dress \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=400,viewed=0,newProduct=1,bestSeller=1,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 189','Password updated by admin',20050925221404), (812,0,'insert into searchstrings(searchText,timesSearch,created,createdBy,updatedBy) values(\'7002\',1,\'2005/09/27\',\'203.82.48.54\',\'203.82.48.54\')','Search has been performed by a user',20050927081756), (813,1,'update products set categoryID=84,productName=\'Testing Product\',companyCode=\'ID Top 7002\',supplierCode=\'7002\',shortDescription=\'\',longDescription=\'Bubble Georgette fabric short sleeve top. \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=150,viewed=14,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 167','Password updated by admin',20050927082124), (814,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'203.82.48.54\' where searchText=\'7002\'','Search has been performed by a user',20050927083537), (815,1,'update products set categoryID=78,productName=\'ID Collection Top\',companyCode=\'\',supplierCode=\'\',shortDescription=\'test\',longDescription=\'test \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=0.1,viewed=15,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 164','Password updated by admin',20050927083937), (816,1,'update products set categoryID=78,productName=\'Busy Bubble Top\',companyCode=\'Busy Bubble Top\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Bubble top, goes well with busy suits \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=100,viewed=2,newProduct=1,bestSeller=1,featuredProduct=1,customTimeDeliverable=1,updatedBy=\'1\' where productID = 177','Password updated by admin',20050927105833), (817,0,'insert into mailinglist(email,subscribed,created,createdBy,updatedBy) values(\'shahzaduk@hotmail.com\',1,\'2005/09/28\',\'81.79.75.93\',\'81.79.75.93\')','An email address was subscribed',20050928000000), (818,0,'insert into mailinglist(email,subscribed,created,createdBy,updatedBy) values(\'shahzaduk@hotmail.com\',1,\'2005/09/28\',\'81.79.75.93\',\'81.79.75.93\')','An email address was subscribed',20050928000000), (819,0,'insert into mailinglist(email,subscribed,created,createdBy,updatedBy) values(\'khaqan@k.com\',1,\'2005/09/28\',\'203.82.48.54\',\'203.82.48.54\')','An email address was subscribed',20050928000000), (820,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'203.82.48.54\' where searchText=\'black\'','Search has been performed by a user',20050928072412), (821,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'203.82.48.54\' where searchText=\'black\'','Search has been performed by a user',20050928072439), (822,1,'update paymentgateways set accountInfo=\'contact@outsizes.com\',gatewayEnabled=\'0\',description=\'\r\n\r\n\r\n\r\n\r\n
Secure service provided by PayPal.com, Limited to 40 countries only
\',updatedBy=\'1\' where gatewayID=2','Payment gateway is updated',20051002153236), (823,1,'update contents set title=\'policy\',maptitle=\'Privacy Policy\',showflag=\'1\',content=\'

secure shopping \r\n

\r\n

\r\n

\',updatedBy=\'1\' where contentid =\'39\' ','Content updated',20051002153614), (824,1,'update contents set title=\'secureshopping\',maptitle=\'Secure Shopping\',showflag=\'1\',content=\'

secure shopping \r\n

\r\n

\r\n

\r\n\r\n

We use Internet standard encryption technology to scramble your sensitive data when you transmit it to us. This process is known as SSL (secure sockets layer) and we are constantly updating our technology to provide you with the maximum practicable level of security. To check that you are in a secure area of our site look at the bottom of your browser and you will see a closed padlock or an unbroken key.

\',updatedBy=\'1\' where contentid =\'38\' ','Content updated',20051002155052), (825,1,'update contents set title=\'contactus\',maptitle=\'Contact Us\',showflag=\'1\',content=\'

contact us \r\n

\r\n

\r\n

\r\n\r\n

\r\n

As a customer you are important to us, and we would like to hear what you think. Whether you would like us to answer a question, offer shopping advice, or simply respond to a comment or suggestion, we are here to help you.

You can contact us by one of the following methods

\r\n

Telephone Support:

\r\n\r\n

Email:

\r\n\',updatedBy=\'1\' where contentid =\'30\' ','Content updated',20051002155549), (826,1,'update contents set title=\'policy\',maptitle=\'Privacy Policy\',showflag=\'1\',content=\'

Privacy Policy \r\n

\r\n

\r\n

\',updatedBy=\'1\' where contentid =\'39\' ','Content updated',20051002160018), (827,1,'update contents set title=\'paymentoptions\',maptitle=\'Payment Options\',showflag=\'0\',content=\'

payment options  \r\n

\r\n\r\n

\r\n

 

\',updatedBy=\'1\' where contentid =\'33\' ','Content updated',20051002160243), (828,1,'delete from generaluser where userID = \'13\'','General user is deleted',20051002160633), (829,1,'delete from useraccounts where accountID = \'13\'','Remove entry from useraccounts',20051002160633), (830,1,'delete from generaluser where userID = \'3\'','General user is deleted',20051002160636), (831,1,'delete from useraccounts where accountID = \'3\'','Remove entry from useraccounts',20051002160636), (832,1,'delete from generaluser where userID = \'18\'','General user is deleted',20051002160709), (833,1,'delete from useraccounts where accountID = \'18\'','Remove entry from useraccounts',20051002160709), (834,1,'update paymentgateways set accountInfo=\'398825\',gatewayEnabled=\'1\',description=\'\r\n\r\n\r\n\r\n\r\n
2CO accepts customer orders via online checks, Visa, MasterCard, Discover, American Express, Dinners, JCB and debit cards
\',updatedBy=\'1\' where gatewayID=1','Payment gateway is updated',20051002161541), (835,1,'delete from courier where courierID = \'3\'','Courier is deleted',20051002161731), (836,1,'update `courier` set `name`=\'Standard Shipping\',url=\'http://www.out-sizes.com\',updatedBy=\'1\' where courierID = \'1\'','Courier info updated',20051002161753), (837,1,'update config set discountFor=\'0\',discountRate=\'0\',minOrderTotal=\'0\',premiumShippingInUSD=\'2.99\' where id=1','Category info updated',20051002161810), (838,1,'delete from countries where countryID = \'9\'','Country is deleted',20051002161840), (839,1,'delete from countries where countryID = \'1\'','Country is deleted',20051002163512), (840,1,'delete from countries where countryID = \'8\'','Country is deleted',20051002163517), (841,1,'delete from countries where countryID = \'3\'','Country is deleted',20051002163523), (842,1,'insert into `weightcosting` (`countryID`,`courierID`,`weightMin`,`WeightMax`,`shipCost`,created, `createdby`,`updatedBy`) values(\'2\',\'1\',\'0\',\'10000\',\'5\',\'2005/10/02\',\'1\',\'1\')','Weight Costing is added',20051002163625), (843,1,'delete from weightcosting where weightCostingID = \'9\'','Shipment deleted',20051002163635), (844,1,'insert into `weightcosting` (`countryID`,`courierID`,`weightMin`,`WeightMax`,`shipCost`,created, `createdby`,`updatedBy`) values(\'2\',\'1\',\'10001\',\'20000\',\'10\',\'2005/10/02\',\'1\',\'1\')','Weight Costing is added',20051002163718), (845,1,'update products set categoryID=85,productName=\'Embroidered Pocket Jean\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Embroidered Pocket Jean \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=3,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 183','Password updated by admin',20051002195356), (846,1,'update products set categoryID=85,productName=\'Pocket Embroidered Jean Brown\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Pocket Embroidered Jean Brown \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=2,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 185','Password updated by admin',20051002195454), (847,1,'update products set categoryID=83,productName=\'Busy Triple Stitched Trouser\',companyCode=\'Busy Triple Stitched Trouser\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Busy trouser \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=8,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 169','Password updated by admin',20051002195720), (848,1,'update products set categoryID=78,productName=\'Busy Bubble Top\',companyCode=\'Busy Bubble Top\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Bubble top, goes well with busy suits \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=100,viewed=3,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=1,updatedBy=\'1\' where productID = 177','Password updated by admin',20051002200121), (849,1,'update products set categoryID=84,productName=\'Testing Product\',companyCode=\'ID Top 7002\',supplierCode=\'7002\',shortDescription=\'\',longDescription=\'Bubble Georgette fabric short sleeve top. \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=150,viewed=18,newProduct=0,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 167','Password updated by admin',20051002200230), (850,1,'update contents set title=\'aboutus\',maptitle=\'About Us\',showflag=\'1\',content=\'

 about us \r\n

\r\n

\r\n

\r\n\r\n

We have been in the ladies fashion business for over 25 years. Over the years we discovered there was a growing demand for larger sizes. There were so many people looking for larger sizes that we decided that we should specialise and cater for this market.

\r\n

For the last 12 years the business has specialised in the outsize market. We now cater for sizes 12-39 (UK Sizes, 36-62 European Sizes).

\',updatedBy=\'1\' where contentid =\'25\' ','Content updated',20051004205242), (851,1,'update contents set title=\'aboutus\',maptitle=\'About Us\',showflag=\'1\',content=\'

 about us \r\n

\r\n

\r\n

\r\n\r\n

We have been in the ladies fashion business for over 25 years. Over the years we discovered there was a growing demand for larger sizes. There were so many people looking for larger sizes that we decided that we should specialise and cater for this market.

\r\n

For the last 12 years the business has specialised in the outsize market. We now cater for sizes 12-39 (UK Sizes, 36-62 European Sizes). We have everything from casualwear, jeans, dress jackets, outerwear, jackets & coats, to eveningwear and partywear. Also, we have a range of shoes and matching bags as well as hats and fascinators.

\r\n

At out-sizes, we ensure that all garments are selected with the customer in mind. Quality fabrics, superb fit and innovative designs at unbeatable prices make shopping at out-sizes a unforgetable experience.

\',updatedBy=\'1\' where contentid =\'25\' ','Content updated',20051004210149), (852,1,'update contents set title=\'aboutus\',maptitle=\'About Us\',showflag=\'1\',content=\'

 about us \r\n

\r\n

\r\n

\r\n\r\n

We have been in the ladies fashion business for over 25 years. Over the years we discovered there was a growing demand for larger sizes. There were so many people looking for larger sizes that we decided that we should specialise and cater for this market.

\r\n

For the last 12 years the business has specialised in the outsize market. We now cater for sizes 12-38 (UK Sizes, 36-62 European Sizes). We have everything from casualwear, jeans, dress jackets, outerwear, jackets & coats, to eveningwear and partywear. Also, we have a range of shoes and matching bags as well as hats and fascinators.

\r\n

At out-sizes, we ensure that all garments are selected with the customer in mind. Quality fabrics, superb fit and innovative designs at unbeatable prices make shopping at out-sizes a unforgetable experience.

\',updatedBy=\'1\' where contentid =\'25\' ','Content updated',20051004210215), (853,0,'update searchstrings set timesSearch=timesSearch+1, updatedBy=\'212.240.194.236\' where searchText=\'jean\'','Search has been performed by a user',20051005165420), (854,1,'insert into countries (countryName,created,createdBy,updatedBy) values (\'Pakistan\',\'2005/10/05\',\'1\',\'1\')','Country is added',20051005165548), (855,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(78,\'Halterneck Top\',\'Bigscene halterneck top\',\'\',\'\',\'Brushed cotton halterneck top with necklace design\',1,0,0,0,\'#\',0,200,\'products/middlebigscenehalternecktop.jpg\',\'products/middlebigscenehalternecktop.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/10/08\',1,1)','Password updated by admin',20051008150311), (856,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(78,\'Shell Sequence Top\',\'Bigscene shell sequence top\',\'\',\'\',\'Viscose Lycra topwith shell design around the neck\',1,0,0,0,\'#\',0,200,\'products/middlebigsceneshellsequencetop.jpg\',\'products/middlebigsceneshellsequencetopclo.jpg\',\'products/middlebigsceneshellsequencetop.jpg\',\'no\',\'no\',0,0,0,0,0,\'2005/10/08\',1,1)','Password updated by admin',20051008150746), (857,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(78,\'Sequence Vest Top\',\'Bigscene Vest top \',\'\',\'\',\'

V-neck vest top with sequence detail around neck.

\r\n

Material:Viscose, Lycra stretch fabric

\',1,0,0,0,\'#\',0,200,\'products/middlebigscenesleevelesssequencet.jpg\',\'products/middlebigscenesleevelesssequencet.jpg\',\'no\',\'no\',\'no\',0,0,0,0,0,\'2005/10/08\',1,1)','Password updated by admin',20051008151926), (858,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(78,\'Tie Dye Vest Top \',\'Bigscene Tie Die vest top\',\'\',\'\',\'

Tie dye vest top with lace detaile around neck line and around front

\r\n

Material:Stretch Viscose Lycra

\',1,0,0,0,\'#\',0,200,\'products/middlebigscenetiedietop.jpg\',\'products/middlebigscenetiedietopclose.jpg\',\'products/middlebigscenetiedietop.jpg\',\'no\',\'no\',0,0,0,0,0,\'2005/10/08\',1,1)','Password updated by admin',20051008152340), (859,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(96,\'Busy 3/4 Dress Coat\',\'\',\'\',\'\',\'

Fully lined 3/4 length dress coat with a back vent

\r\n

Dry Clean Only

\',1,0,0,0,\'#\',0,600,\'products/middlebusy3quaterdressblackcoat.jpg\',\'products/middlebusy3quaterdressbrowncoat.jpg\',\'products/middlebusy3quaterdressblackcoat.jpg\',\'no\',\'no\',0,0,0,0,0,\'2005/10/08\',1,1)','Password updated by admin',20051008153011), (860,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(83,\'Busy Brown Stripe Jacket\',\'Busy Brown Stripe Jacket\',\'\',\'\',\'

2 button fully lined suit jacket

\r\n

Material:100% Polyester with luxury viscose lining

\',1,0,0,0,\'#\',0,500,\'products/middleBusybrownstripejacket.jpg\',\'products/middleBusybrownstripesuit.jpg\',\'products/middleBusybrownstripejacket.jpg\',\'no\',\'no\',0,0,0,0,0,\'2005/10/08\',1,1)','Password updated by admin',20051008153643), (861,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(83,\'Busy Brown Stripe Trouser\',\'Busy Brown Stripe Trouser\',\'\',\'\',\'

Suit trousers, straight cut, 1\" waistband

\r\n

Material:100% Polyester

\',1,0,0,0,\'#\',0,300,\'products/middleBusybrownstripetrouser.jpg\',\'products/middleBusybrownstripesuit.jpg\',\'products/middleBusybrownstripetrouser.jpg\',\'no\',\'no\',0,0,0,0,0,\'2005/10/08\',1,1)','Password updated by admin',20051008154408), (862,1,'update weightcosting set countryID=\'2\',courierID=\'1\',weightMin=\'0\',WeightMax=\'1000\',shipCost=\'3.95\',updatedBy=\'1\' where weightCostingID=\'10\'','Weight shipping cost is updated',20051008155051), (863,1,'update weightcosting set countryID=\'2\',courierID=\'1\',weightMin=\'1001\',WeightMax=\'2000\',shipCost=\'7.95\',updatedBy=\'1\' where weightCostingID=\'11\'','Weight shipping cost is updated',20051008155125), (864,1,'update categories set name=\'Occasions\',parentCategory=\'82\',priority=\'330\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'84\'','Category info updated',20051009162251), (865,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Trousers\',\'82\',\'320\',\'2005/10/09\',\'1\',\'1\',\'0\')','New Category added',20051009162303), (866,1,'update categories set name=\'Jackets\',parentCategory=\'82\',priority=\'310\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'83\'','Category info updated',20051009162340), (867,1,'update products set status=0 where categoryID = \'92\'','Category deleted',20051009162448), (868,1,'delete from categories where parentCategory = \'92\'','Deleting child categories',20051009162449), (869,1,'delete from categories where categoryID = \'92\'','Category deleted',20051009162449), (870,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Trousers & Skirts\',\'0\',\'200\',\'2005/10/09\',\'1\',\'1\',\'0\')','New Category added',20051009162614), (871,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Skirts\',\'99\',\'210\',\'2005/10/09\',\'1\',\'1\',\'0\')','New Category added',20051009162645), (872,1,'insert into categories (name,parentCategory,priority,created,createdBy,updatedBy,bannerID) values (\'Trousers\',\'99\',\'220\',\'2005/10/09\',\'1\',\'1\',\'0\')','New Category added',20051009162706), (873,1,'update products set categoryID=98,productName=\'Busy Triple Stitched Trouser\',companyCode=\'Busy Triple Stitched Trouser\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Busy trouser \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=8,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 169','Password updated by admin',20051009162806), (874,1,'update products set categoryID=98,productName=\'Busy Single Stitch Trouser\',companyCode=\'Busy Single Stitch Trouser\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Matching trouser for Busy single stitch jacket

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=0,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 175','Password updated by admin',20051009162821), (875,1,'update products set categoryID=98,productName=\'Busy Brown Stripe Trouser\',companyCode=\'Busy Brown Stripe Trouser\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Suit trousers, straight cut, 1\" waistband

\r\n

Material:100% Polyester

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=0,newProduct=0,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 196','Password updated by admin',20051009162836), (876,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(78,\'Striped Blouse\',\'Miss Chloe striped blouse\',\'\',\'\',\'

Crystal pleat striped blouse

\r\n

Material: 100% Polyester

\r\n

Machine Washable

\',1,0,0,0,\'#\',0,150,\'products/middlemisschloestripeblousebrwn.jpg\',\'products/middlemisschloestripeblousepurple.jpg\',\'products/middlemisschloestripeblousebrwn.jpg\',\'no\',\'no\',0,1,0,1,0,\'2005/10/12\',1,1)','Password updated by admin',20051012162838), (877,1,'update products set categoryID=79,productName=\'Striped Blouse\',companyCode=\'Miss Chloe striped blouse\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Crystal pleat striped blouse

\r\n

Material: 100% Polyester

\r\n

Machine Washable

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=150,viewed=0,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 197','Password updated by admin',20051012163130), (878,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(79,\'Roger Stripe Blouse\',\'Roger Stripe Blouse\',\'\',\'\',\'

Long striped over blouse by Roger

\r\n

Material: 100% Polyester

\r\n

Machine Washable

\',1,0,0,0,\'#\',0,150,\'products/middlerogerlongstripbrownblouse.jpg\',\'products/middlerogerlongstripbrownblouse.jpg\',\'no\',\'no\',\'no\',0,0,0,0,0,\'2005/10/12\',1,1)','Password updated by admin',20051012163637), (879,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(79,\'Miss Chloe Sparkle Blouse\',\'Miss Chloe Sparkle Blouse\',\'\',\'Colours: Burgundy and Black\',\'

Material: 100% Polyester

\r\n

Machine Washable

\',1,0,0,0,\'#\',0,150,\'products/middlemisschloeburgundyblouse.jpg\',\'products/middlemisschloeblackblouse.jpg\',\'products/middlemisschloeburgundyblouse.jpg\',\'no\',\'no\',0,0,0,0,0,\'2005/10/15\',1,1)','Password updated by admin',20051015164632), (880,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(84,\'ID Pebble Georgette Suit\',\'ID Pebble Georgette Suit\',\'\',\'Colours: Purple and Black\',\'

ID skirt and Jacket/Top suit

\r\n

Material: Pebble Georgette

\',1,0,0,0,\'#\',0,500,\'products/middleidpebblegeorgettepurplesuit.jpg\',\'products/middleidpebblegeorgetteblacksuit.jpg\',\'products/middleidpebblegeorgetteclosepurpl.jpg\',\'products/middleidpebblegeorgettepurplesuit.jpg\',\'no\',0,0,0,0,0,\'2005/10/15\',1,1)','Password updated by admin',20051015165359), (881,1,'update products set categoryID=84,productName=\'ID Pebble Georgette Suit\',companyCode=\'ID Pebble Georgette Suit\',supplierCode=\'\',shortDescription=\'Colours: Purple and Black\',longDescription=\'

ID skirt and Jacket suit

\r\n

Material: Pebble Georgette

\r\n

Machine Washable

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=500,viewed=1,newProduct=0,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 200','Password updated by admin',20051015165817), (882,1,'update products set categoryID=79,productName=\'Miss Chloe Sequence Blouse\',companyCode=\'Miss Chloe Sequence Blouse\',supplierCode=\'\',shortDescription=\'Colours: Burgundy and Black\',longDescription=\'

Material: 100% Polyester

\r\n

Machine Washable

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=150,viewed=4,newProduct=0,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 199','Password updated by admin',20051015165920), (883,1,'update products set categoryID=78,productName=\'ID Sequence Top \',companyCode=\'style 1167 id top\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Tie dye effect sequence top

\r\n

Material: 100% Polyester

\r\n

Hand Wash

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=17,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 171','Password updated by admin',20051015170131), (884,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(79,\'Roger Blouse with Camisole\',\'Roger Blouse with Camisole\',\'\',\'\',\'

Tie Dye effect sequence blouse with matching camisole

\r\n

Material: 100% Polyester

\r\n

Blouse:Dry Clean

\r\n

Camisole:Handwash

\',1,0,0,0,\'#\',0,250,\'products/middlepurpleblousewithvest.jpg\',\'products/middlebrownblousewithvest.jpg\',\'products/middlepurpleblousewithvest.jpg\',\'no\',\'no\',0,0,0,1,0,\'2005/10/15\',1,1)','Password updated by admin',20051015170855), (885,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(88,\'Full Length Mohair Effect Cardigan\',\'Full Length Mohair Effect Cardigan\',\'\',\'\',\'

Full length mohair effect cardigan

\r\n

Material: 65% Polyester, 35% Nylon

\r\n

Hand Washable

\',1,0,0,0,\'#\',0,350,\'products/middlepurplelongcardigan.jpg\',\'products/middlebrownlongcardigan.jpg\',\'products/middlepurplelongcardigan.jpg\',\'no\',\'no\',0,0,0,1,0,\'2005/10/15\',1,1)','Password updated by admin',20051015171348), (886,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(96,\'Faux Sheepskin Waistcoat\',\'Faux Sheepskin Waistcoat\',\'\',\'\',\'

Faux sheepskin waistcoat with fur lining.

\r\n

Dry Clean Only

\',1,0,0,0,\'#\',0,500,\'products/middlefauxsheepskinwaistcoatbrown.jpg\',\'products/middlefauxsheepskinwaistcoatcream.jpg\',\'products/middlefauxsheepskinwaistcoatbrown.jpg\',\'no\',\'no\',0,0,0,1,0,\'2005/10/19\',1,1)','Password updated by admin',20051019155758), (887,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(84,\'ID Suit Leaf Design\',\'id 7178\',\'\',\'\',\'

Black suit with leafy design in gold. Suit consists of a top and skirt with elasticated waist 

\',1,0,0,0,\'#\',0,400,\'products/middleidblacksuitgoldleaves.jpg\',\'products/middleidblacksuitgoldleaveskirt.jpg\',\'products/middleidblacksuitgoldleavestop.jpg\',\'products/middleidblacksuitgoldleaves.jpg\',\'no\',0,0,0,1,0,\'2005/10/19\',1,1)','Password updated by admin',20051019161054), (888,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(96,\'Canvas Parker\',\'\',\'\',\'\',\'

Canvas padded parker style jacket

\r\n

Material: Outer 100% Cotton, Lining 100% Cotton

\r\n

Machine Washable

\',1,0,0,0,\'#\',0,450,\'products/middleRajanparker.jpg\',\'products/middleRajanparker.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/10/19\',1,1)','Password updated by admin',20051019161901), (889,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(78,\'ITY Sequence Top\',\'ID style 832\',\'\',\'\',\'

ITY stretch fabric with sequences along neck and one side

\r\n

Material: 100% Polyester

\r\n

Machine Washable

\',1,0,0,0,\'#\',0,200,\'products/middleidblackembroideredtop.jpg\',\'products/middleidblackembroideredtop.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/10/19\',1,1)','Password updated by admin',20051019163049), (890,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(84,\'Milano Frill Skirt Suit\',\'Milano 1531\',\'\',\'\',\'

Two Piece skirt suit. Top with sequence sleaves, skirt with a frill design. Two Tone effect fabric

\r\n

Material: 100% Polyester, acitate lining

\r\n

Dry Clean Only

\',1,0,0,0,\'#\',0,400,\'products/middlemilanosuitmaroon.jpg\',\'products/middlemilanosuitmaroontop.jpg\',\'products/middlemilanosuitmaroon2.jpg\',\'no\',\'no\',0,0,0,1,0,\'2005/10/22\',1,1)','Password updated by admin',20051022135750), (891,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(78,\'Beaded Top\',\'Bigstuff style 2313\',\'\',\'\',\'

Vest top with beading on the front

\r\n

Material: 95% Viscose, 5% Lycra

\r\n

Handwash

\',1,0,0,0,\'#\',0,230,\'products/middlebroochtopbrown.jpg\',\'products/middlebroochtopblack.jpg\',\'products/middlebroochtopbrown.jpg\',\'no\',\'no\',0,0,0,1,0,\'2005/10/22\',1,1)','Password updated by admin',20051022140531), (892,1,'update categories set name=\'Formal\',parentCategory=\'82\',priority=\'310\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'83\'','Category info updated',20051022143436), (893,1,'update categories set name=\'Trousers\',parentCategory=\'0\',priority=\'700\',updatedBy=\'1\',bannerID=\'0\' where categoryID=\'98\'','Category info updated',20051022143458), (894,1,'update products set status=0 where categoryID = \'98\'','Category deleted',20051022143523), (895,1,'delete from categories where parentCategory = \'98\'','Deleting child categories',20051022143523), (896,1,'delete from categories where categoryID = \'98\'','Category deleted',20051022143523), (897,1,'update products set categoryID=83,productName=\'Busy Triple Stitched Jacket\',companyCode=\'Busy Triple Stitched Jacket\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Busy jacket

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=18,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 168','Password updated by admin',20051022144016), (898,1,'update products set categoryID=83,productName=\'Busy Black Stripe Jacket\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Busy Black Stripe Jacket \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=6,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 180','Password updated by admin',20051022144054), (899,1,'update products set categoryID=96,productName=\'Brown Fur Bodywarmer\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Brown Fur Bodywarmer \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=400,viewed=5,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 186','Password updated by admin',20051022144125), (900,1,'update products set categoryID=97,productName=\'Black and Red Dress\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Black and Red Dress \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=4,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 187','Password updated by admin',20051022144139), (901,1,'update products set categoryID=78,productName=\'Beaded Top\',companyCode=\'Bigstuff style 2313\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Vest top with beading on the front

\r\n

Material: 95% Viscose, 5% Lycra

\r\n

Handwash

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=230,viewed=0,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 208','Password updated by admin',20051022144210), (902,1,'update products set categoryID=78,productName=\'ITY Sequence Top\',companyCode=\'ID style 832\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

ITY stretch fabric with sequences along neck and one side

\r\n

Material: 100% Polyester

\r\n

Machine Washable

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=1,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 206','Password updated by admin',20051022144444), (903,1,'update products set categoryID=84,productName=\'ID Pebble Georgette Suit\',companyCode=\'ID Pebble Georgette Suit\',supplierCode=\'\',shortDescription=\'Colours: Purple and Black\',longDescription=\'

ID skirt and Jacket suit

\r\n

Material: Pebble Georgette

\r\n

Machine Washable

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=500,viewed=1,newProduct=0,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 200','Password updated by admin',20051022144648), (904,1,'update products set image1=\'products/middlebusyblackpinkstripeclose.jpg\',image2=\'products/middlebusyblackpinkstripe.jpg\',image3=\'products/middlebusyblackpinkstripeclose.jpg\', categoryID=83,productName=\'Busy Black Stripe Jacket\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Busy Black Stripe Jacket \', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=6,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 180','Password updated by admin',20051022152017), (905,1,'update products set image1=\'products/middlebusybrowngoldstripeclose.jpg\',image2=\'products/middlebusybrowngoldstripe.jpg\',image3=\'products/middlebusybrowngoldstripeclose.jpg\', categoryID=83,productName=\'Busy Brown Stripe Jacket\',companyCode=\'Busy Brown Stripe Jacket\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

2 button fully lined suit jacket

\r\n

Material:100% Polyester with luxury viscose lining

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=500,viewed=2,newProduct=0,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 195','Password updated by admin',20051022152120), (906,1,'update products set image2=\'products/middlebusyredsuit.jpg\', categoryID=83,productName=\'Busy Red Suit\',companyCode=\'Busy Triple Stitched Red Suit\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Triple Stitched Jacket and Trouser Suit. Fully Lined

\r\n

Material: 100% Polyester

\r\n

Dry Clean

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=600,viewed=19,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 168','Password updated by admin',20051022152429), (907,1,'update products set categoryID=83,productName=\'Busy Pink Stripe Black Suit \',companyCode=\'Busy Pink Stripe Black Suit\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Self Stripe Jacket and Trouser Suit. Fully Lined

\r\n

Material: 100% Polyester

\r\n

Dry Clean

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=600,viewed=6,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 180','Password updated by admin',20051022152715), (908,1,'update products set categoryID=83,productName=\'Busy Gold Stripe Brown Suit\',companyCode=\'Busy Gold Stripe Brown Suit\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Self Stripe Jacket and Trouser Suit. Fully Lined

\r\n

Material: 100% Polyester

\r\n

Dry Clean

\r\n

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=600,viewed=2,newProduct=0,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 195','Password updated by admin',20051022152859), (909,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(88,\'Toggle Cardigan\',\'Toggle Cardigan\',\'\',\'\',\'

3/4 length cardigan with toggle buttons

\r\n

Material: 100% Acrylic

\r\n

 

\',1,0,0,0,\'#\',0,350,\'products/middletogglecardiganbrown.jpg\',\'products/middletogglecardigancream.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/10/22\',1,1)','Password updated by admin',20051022154610), (910,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(88,\'Buckle Cardigan\',\'Buckle Cardigan\',\'\',\'\',\'

Bucle Cardigan with hook and eye fastener

\r\n

Material: 86% Acrylic 14% Polyester

\r\n

Machine Washable

\',1,0,0,0,\'#\',0,350,\'products/middlelongredhookcardigan.jpg\',\'products/middlelongredhookcardigan.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/10/22\',1,1)','Password updated by admin',20051022155046), (911,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(101,\'w4qq\',\'\',\'\',\'\',\'q\',1,0,0,0,\'#\',0,12,\'products/middlebroochtopbrown.jpg\',\'products/middlebroochtopbrown.jpg\',\'no\',\'no\',\'no\',0,0,0,0,0,\'2005/10/22\',1,1)','Password updated by admin',20051022160108), (912,1,'update products set categoryID=83,productName=\'Busy Single Stitch Jacket\',companyCode=\'Busy Single Stitch Jacket\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Single stitched collar and pocket Busy suit jacket

\', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=300,viewed=6,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 174','Password updated by admin',20051022163519), (913,1,'update products set categoryID=84,productName=\'ID 6926\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'ID 6926 skirt in camel brown and black, matching ID top 7002. Lined georgette \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=3,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 172','Password updated by admin',20051022163642), (914,1,'update products set categoryID=84,productName=\'Testing Product\',companyCode=\'ID Top 7002\',supplierCode=\'7002\',shortDescription=\'\',longDescription=\'Bubble Georgette fabric short sleeve top. \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=150,viewed=18,newProduct=0,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 167','Password updated by admin',20051022163659), (915,1,'update products set categoryID=78,productName=\'Xtra Details Coins\',companyCode=\'Bigstuff Xtra Details Coins Slee\',supplierCode=\'\',shortDescription=\'\',longDescription=\'Xtra Details sleeveless top with coins \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=250,viewed=9,newProduct=1,bestSeller=1,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 173','Password updated by admin',20051022165316), (916,1,'update products set categoryID=78,productName=\'ID Sequence Top\',companyCode=\'style 1167 id top\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Tie dye effect sequence top

\r\n

Material: 100% Polyester

\r\n

Hand Wash

\', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=200,viewed=32,newProduct=1,bestSeller=0,featuredProduct=0,customTimeDeliverable=0,updatedBy=\'1\' where productID = 171','Password updated by admin',20051022165340); insert into `databaseactivitylog` values (917,1,'insert into products(\n categoryID,productName,companyCode,supplierCode,\n shortDescription,longDescription,\n status,discounted,discountPercentage,displaySizeChart,sizeChartURL,\n quantityInHand,weight,\n image1,image2,image3,image4,image5,\n viewed,bestSeller,featuredProduct,newProduct,\n customTimeDeliverable,\n created,createdBy,updatedBy)\n values(78,\'Crushed Velvet Sequence Top\',\'Crushed Velvet Sequence Top\',\'\',\'\',\'

Crushed Velvet Sequence Top

\r\n

Material: 92% Polyester 8% Elastane

\r\n

Machine Washable

\',1,0,0,0,\'#\',0,200,\'products/middlecrushedvelvetsequencetop.jpg\',\'products/middlecrushedvelvetsequencetop.jpg\',\'no\',\'no\',\'no\',0,0,0,1,0,\'2005/10/22\',1,1)','Password updated by admin',20051022165719), (918,1,'update products set categoryID=84,productName=\'ID Black Top\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'test \', status=0,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=100,viewed=32,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 166','Password updated by admin',20051022170037), (919,1,'update products set categoryID=78,productName=\'Beaded Top\',companyCode=\'Bigstuff style 2313\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Vest top with beading on the front

\r\n

Material: 95% Viscose, 5% Lycra

\r\n

Handwash

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=230,viewed=0,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 208','Password updated by admin',20051023000154), (920,1,'insert into courier (name,url,created,createdBy, updatedBy) values (\'Fast Shipment\',\'http://www.out-sizes.com\',\'2005/10/24\',\'1\',\'1\')','Courier is added',20051024084453), (921,1,'insert into `weightcosting` (`countryID`,`courierID`,`weightMin`,`WeightMax`,`shipCost`,created, `createdby`,`updatedBy`) values(\'2\',\'4\',\'0\',\'10000\',\'100\',\'2005/10/24\',\'1\',\'1\')','Weight Costing is added',20051024084554), (922,1,'update products set categoryID=78,productName=\'Beaded Top\',companyCode=\'Bigstuff style 2313\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Vest top with beading on the front

\r\n

Material: 95% Viscose, 5% Lycra

\r\n

Handwash

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=230,viewed=2,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 208','Password updated by admin',20051024110047), (923,1,'update weightcosting set countryID=\'2\',courierID=\'4\',weightMin=\'0\',WeightMax=\'1000\',shipCost=\'0.01\',updatedBy=\'1\' where weightCostingID=\'10\'','Weight shipping cost is updated',20051024110241), (924,1,'update weightcosting set countryID=\'2\',courierID=\'1\',weightMin=\'0\',WeightMax=\'1000\',shipCost=\'0.00\',updatedBy=\'1\' where weightCostingID=\'10\'','Weight shipping cost is updated',20051024112757), (925,1,'update products set categoryID=78,productName=\'Beaded Top\',companyCode=\'Bigstuff style 2313\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Vest top with beading on the front

\r\n

Material: 95% Viscose, 5% Lycra

\r\n

Handwash

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=230,viewed=6,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 208','Password updated by admin',20051026233444), (926,1,'update products set categoryID=96,productName=\'Canvas Parker\',companyCode=\'\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Canvas padded parker style jacket

\r\n

Material: Outer 100% Cotton, Lining 100% Cotton

\r\n

Machine Washable

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=450,viewed=0,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 205','Password updated by admin',20051026233535), (927,1,'update products set categoryID=88,productName=\'Full Length Mohair Effect Cardigan\',companyCode=\'Full Length Mohair Effect Cardig\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Full length mohair effect cardigan

\r\n

Material: 65% Polyester, 35% Nylon

\r\n

Hand Washable

\', status=1,discounted=0,discountPercentage=0,displaySizeChart=0,sizeChartURL=\'#\',weight=350,viewed=1,newProduct=1,bestSeller=0,featuredProduct=1,customTimeDeliverable=0,updatedBy=\'1\' where productID = 202','Password updated by admin',20051026233606), (928,1,'update products set categoryID=84,productName=\'ID Suit Leaf Design\',companyCode=\'id 7178\',supplierCode=\'\',shortDescription=\'\',longDescription=\'

Black suit with leafy design in gold. Suit consists of a top and skirt