#---------------------------- # Table structure for 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; #---------------------------- # Records for table adminusers #---------------------------- insert into adminusers values (1, 'Muhammad', 'Shahzad', 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, '20050828111906', '203.99.49.90'), (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 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; #---------------------------- # Records for 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 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; #---------------------------- # Records for 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_20.jpg', 0, 'Best1', '2005-08-08 00:00:00', 1, '20050808081915', 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'); #---------------------------- # Table structure for 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; #---------------------------- # No records for table career #---------------------------- #---------------------------- # Table structure for 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; #---------------------------- # Records for table categories #---------------------------- insert into categories values (53, 'Casualwear', 0, '2005-08-27 00:00:00', 1, '20050827230514', 1, 100, 0), (54, 'Formalwear', 0, '2005-08-27 00:00:00', 1, '20050827230530', 1, 200, 0), (55, 'Occasions', 0, '2005-08-27 00:00:00', 1, '20050827230700', 1, 300, 0), (56, 'Accessories', 0, '2005-08-27 00:00:00', 1, '20050827230908', 1, 400, 0), (57, 'Tops', 53, '2005-08-27 00:00:00', 1, '20050827231037', 1, 110, 0), (58, 'Trousers', 53, '2005-08-27 00:00:00', 1, '20050827231209', 1, 120, 0), (59, 'Skirts', 53, '2005-08-27 00:00:00', 1, '20050827231229', 1, 130, 0), (60, 'Blouses', 53, '2005-08-27 00:00:00', 1, '20050827231246', 1, 140, 0), (61, 'Tops', 54, '2005-08-27 00:00:00', 1, '20050827231526', 1, 210, 0), (62, 'Trousers', 54, '2005-08-27 00:00:00', 1, '20050827231546', 1, 220, 0), (63, 'Skirts', 54, '2005-08-27 00:00:00', 1, '20050827231605', 1, 230, 0), (64, 'Suits', 54, '2005-08-27 00:00:00', 1, '20050827231645', 1, 240, 0), (65, 'Dresses', 54, '2005-08-27 00:00:00', 1, '20050827235422', 1, 250, 0), (66, 'Bridesmaid', 55, '2005-08-27 00:00:00', 1, '20050828000858', 1, 320, 0), (67, 'Mother of Bride/Groom', 55, '2005-08-28 00:00:00', 1, '20050828000911', 1, 310, 0); #---------------------------- # Table structure for 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; #---------------------------- # Records for 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 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; #---------------------------- # Records for table config #---------------------------- insert into config values (1, 2, '20', '20', '2.99'); #---------------------------- # Table structure for 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; #---------------------------- # Records for table contents #---------------------------- insert into contents values (25, 'aboutus', 'About Us', '

 about us \r\n

\r\n

\r\n

\r\n\r\n

', 1, '2005-03-30 16:45:35', 1, '20050723020227', 1), (30, 'contactus', 'Contact Us', '

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', 1, '2005-04-11 13:22:22', 1, '20050723020310', 1), (31, 'privacy', 'Security & Privacy', '

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

security & privacy \r\n

\r\n\r\n

\r\n

Privacy
At ExpressGiftService.com, we respect your privacy and are committed to maintaining it. Full details of our privacy policy are given below. In the event that we make any changes to the policy, the information below will be updated immediately.

\r\n

 

\r\n

How do we use your information?

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
We use the information you provide us:
\r\n
    \r\n
  • To administer your account and may disclose your details to our third party service providers for the purpose of processing your order. \r\n
  • And, from time to time, to inform you by email about services, promotions and special offers. \r\n
  • We will contact you by telephone or email if there is a query regarding your order.
\r\n

Payment Details:

\r\n

ExpressGiftService do not hold or store customer’s payment information. We use 2CO’s merchant account services which is one of the top name in ecommerce business. All transactions at ExpressGiftServices.com have been processed using SSL(Secure Socket Layer) which is an industry standard and send an information directly to banking networks for authorization and all this information is hidden from any of the staff at ExpressGiftService.com.

\r\n

Please Note:

\r\n

We will never ask for a customer to confirm any account or credit card details via email and if you receive an email claiming to be from ExpressGiftService.com asking you to do so then please ignore it and do not respond.

\r\n

 

', 1, '2005-04-11 13:22:22', 1, '20050723020343', 1), (32, 'howtoorder', 'How To Order', '

how to order? \r\n

\r\n\r\n

\r\n

We won\'t ask you for any payment until we\'ve made sure that all the goods in your shopping basket have been processed. And to make sure you always have the highest level of security, your payment details are automatically encrypted when you enter them. You can pay for your online order using Paypal, Visa, MasterCard, Discover, American Express, Dinners, JCB and debit cards with the Visa and MasterCard logo.

\r\n

 

', 1, '2005-04-11 13:22:22', 1, '20050723021144', 1), (33, 'paymentoptions', 'Payment Options', '

payment options  \r\n

\r\n\r\n

\r\n

 

', 1, '2005-04-11 13:22:22', 1, '20050723021210', 1), (38, 'secureshopping', 'Secure Shopping', '

secure shopping \r\n

\r\n

\r\n

', 1, '2005-07-22 00:00:00', 1, '20050723021326', 1), (39, 'policy', 'Privacy Policy', '', 1, '2005-07-22 00:00:00', 1, '20050723021355', 1); #---------------------------- # Table structure for 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; #---------------------------- # Records for 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 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; #---------------------------- # Records for table countries #---------------------------- insert into countries values (1, 'Pakistan', '2005-04-03 15:59:56', 1, '20050414175854', 1), (2, 'United Kingdom', '2005-04-03 15:59:56', 1, '20050414175853', 1), (3, 'United States of America', '2005-04-03 15:59:56', 1, '20050414175849', 1), (8, 'Bangladesh', '2005-04-03 15:59:56', 1, '20050403165250', 1), (9, null, null, 0, '20050414175856', 0); #---------------------------- # Table structure for 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; #---------------------------- # Records for table courier #---------------------------- insert into courier values (1, '3 to 5 days', 'http://www.msn.com', '2005-04-05 00:00:00', 1, '00000000000000', 1), (3, '5 to 10 days', 'http://www.tcs.com.pk?track.asp?id=', '2005-04-05 00:00:00', 1, '20050414144646', 1); #---------------------------- # Table structure for 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; #---------------------------- # No records for table coveragecities #---------------------------- #---------------------------- # Table structure for 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; #---------------------------- # Records for table currency #---------------------------- insert into currency values (2, 'USD', '$', '1.77855', '2005-03-30 00:00:00', 1, '20050806045705', 1), (1, 'GPB', '£', '1', '2005-03-30 00:00:00', 1, '20050806045616', 1), (3, 'EURO', '€', '1.43808', '2005-03-30 00:00:00', 1, '20050806025844', 1), (4, 'CAD', '$', '2.16753', '2005-03-30 00:00:00', 1, '20050806030017', 1), (5, 'AUD', '$', '2.31505', '2005-03-30 00:00:00', 1, '20050806030116', 1), (6, 'Pak', 'Rs', '106.107', '2005-03-30 00:00:00', 1, '20050806030208', 1); #---------------------------- # Table structure for 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; #---------------------------- # Records for 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(57,\'Test Prod\',\'1\',\'2\',\'Test Short Desc\',\'Test Long descr\',1,0,0,1,\'http://www.yahoo.com\',0,100,\'products/middleTJ01-418550.jpg\',\'products/middleTJ01-418550.jpg\',\'no\',\'no\',\'no\',0,1,1,1,1,\'2005/08/28\',1,1)', 'Password updated by admin', '20050828095252'); #---------------------------- # Table structure for feedback #---------------------------- CREATE TABLE `feedback` ( `id` int(11) NOT NULL auto_increment, `comments` longtext, `name` varchar(50) default NULL, `city` varchar(50) default NULL, `state` varchar(50) default NULL, `country` varchar(50) default NULL, `sex` varchar(50) default NULL, `age` varchar(50) default NULL, `email` varchar(50) default NULL, `learnFrom` varchar(50) default NULL, `created` datetime default NULL, `createdBy` varchar(50) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(50) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; #---------------------------- # No records for table feedback #---------------------------- #---------------------------- # Table structure for generaluser #---------------------------- CREATE TABLE `generaluser` ( `userID` int(11) NOT NULL default '0', `firstName` varchar(50) default NULL, `lastName` varchar(50) default NULL, `billingAddressl1` varchar(100) default NULL, `billingAddressl2` varchar(100) default NULL, `billingAddressl3` varchar(100) default NULL, `billingAddressl4` varchar(100) default NULL, `billingCity` varchar(50) default NULL, `billingState` varchar(50) default NULL, `billingCountry` int(11) default NULL, `billingZipCode` varchar(50) default NULL, `billingEmail` varchar(100) default NULL, `billingPhoneno` varchar(100) default NULL, `shippingAddressl1` varchar(100) default NULL, `shippingAddressl2` varchar(100) default NULL, `shippingAddressl3` varchar(100) default NULL, `shippingAddressl4` varchar(100) default NULL, `shippingCity` varchar(50) default NULL, `shippingState` varchar(50) default NULL, `shippingCountry` int(11) default NULL, `shippingEmail` varchar(50) default NULL, `shippingZipCode` varchar(50) default NULL, `shippingPhoneno` varchar(50) default NULL, `created` datetime default NULL, `createdBy` varchar(50) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(50) default NULL, PRIMARY KEY (`userID`) ) TYPE=MyISAM; #---------------------------- # Records for table generaluser #---------------------------- insert into generaluser values (3, 'Farhan', 'Ali', 'H.No 28', 'line2', 'line3', 'line4', 'Rawalpindi', 'Punjab', 2, '46000', 'farhan@artologics.com', '12245511544', 'H.No 10', 'USA Line2', 'USA Line3', 'USA Line4', '6666', 'Baluchistan', 1, 'farhan_ali82@hotmail.com', '502002', '1215415454141', '2005-04-05 00:00:00', '1', '20050801224438', '1'), (20, 'Syed Muhammad', 'Farhan Ali', 'Home in rwp', 'line2', 'line3', 'line 4', 'Rawalpindi', 'Punjab', 2, '46000', 'farhan.ali82@hotm.ailcom', '051-111111', 'Home in rwp', 'line2', 'line3', 'line 4', 'Rawalpindi', 'Punjab', 2, 'farhan.ali82@hotm.ailcom', null, '051-111111', null, '1', '20050414180619', '1'), (21, 'Farhan', 'Shah', 'Artologics, 2nd Floor Blue Plaza', 'Lane 5,', 'Peshawar Road', '', 'Rawalpindi', 'Punjab', 1, '46000', 'farhan.ali82@hotmail.com', '1234565', 'Artologics, 2nd Floor Blue Plaza', 'Lane 5,', 'Peshawar Road', '', 'faisalabad', 'Punjab', 2, 'farhan.ali82@hotmail.com', '46000', '1234565', null, '1', '20050414180619', '1'), (13, 'chanda', 'khand', 'hasilpur road basti baatlian', '', '', '', 'hasilpur', 'punjab', 1, '63100', 'ssschanda@hotmail.com', '03007818059', 'hasilpur road basti baatlian', '', '', '', 'hasilpur', 'punjab', 1, 'ssschanda@hotmail.com', '63100', '03007818059', null, null, '20050630053213', null), (18, 'khaqan', 'mahmood', 'isb', 'isb', '', '', 'isb', 'isb', 2, '44000', 'khaqan@artologics.com', '234243', 'isb', 'isb', '', '', 'rwer', 'isb', 2, 'khaqan@artologics.com', '44000', '234243', null, null, '20050721041513', null); #---------------------------- # Table structure for inventory #---------------------------- CREATE TABLE `inventory` ( `inventoryID` int(11) NOT NULL auto_increment, `productID` int(11) default '0', `attribute1` int(11) default '0', `attribute2` int(11) default '0', `attribute3` int(11) default '0', `attribute4` int(11) default '0', `attribute5` int(11) default '0', `stock` int(11) default '0', `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`inventoryID`) ) TYPE=MyISAM; #---------------------------- # Records for table inventory #---------------------------- insert into inventory values (185, 165, 384, 386, 0, 0, 0, 12, null, 0, '20050828095600', 0), (186, 165, 384, 387, 0, 0, 0, 12, null, 0, '20050828095600', 0), (187, 165, 384, 388, 0, 0, 0, 12, null, 0, '20050828095601', 0), (188, 165, 385, 386, 0, 0, 0, 23, null, 0, '20050828095601', 0), (189, 165, 385, 387, 0, 0, 0, 234, null, 0, '20050828095601', 0); #---------------------------- # Table structure for listboxes #---------------------------- CREATE TABLE `listboxes` ( `comboID` int(11) NOT NULL auto_increment, `productID` int(11) default '0', `attributeID` char(10) default NULL, `displayText` char(50) default NULL, `calculateStock` 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 (`comboID`) ) TYPE=MyISAM; #---------------------------- # Records for table listboxes #---------------------------- insert into listboxes values (145, 165, 'attribute1', 'Size', 1, null, 0, '20050828095515', 0), (146, 165, 'attribute2', 'Color', 1, null, 0, '20050828095516', 0); #---------------------------- # Table structure for lovs #---------------------------- CREATE TABLE `lovs` ( `lovID` int(11) NOT NULL auto_increment, `listBoxID` int(11) default '0', `displayText` char(50) default NULL, `status` tinyint(1) default '1', `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`lovID`) ) TYPE=MyISAM; #---------------------------- # Records for table lovs #---------------------------- insert into lovs values (384, 145, 'XL', 1, null, 0, '20050828095535', 0), (385, 145, 'XXL', 1, null, 0, '20050828095535', 0), (386, 146, 'Blue', 1, null, 0, '20050828095535', 0), (387, 146, 'Green', 1, null, 0, '20050828095535', 0), (388, 146, 'Yellow', 1, null, 0, '20050828095535', 0); #---------------------------- # Table structure for mailinglist #---------------------------- CREATE TABLE `mailinglist` ( `id` int(11) NOT NULL auto_increment, `email` varchar(50) default NULL, `subscribed` tinyint(1) default NULL, `created` datetime default NULL, `createdBy` varchar(50) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(50) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; #---------------------------- # No records for table mailinglist #---------------------------- #---------------------------- # Table structure for noticeboard #---------------------------- CREATE TABLE `noticeboard` ( `id` int(11) NOT NULL auto_increment, `notice` longtext, `created` datetime default NULL, `subject` varchar(255) default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; #---------------------------- # Records for table noticeboard #---------------------------- insert into noticeboard values (3, '

Yes… Site is launched as beta version, you can post your feed back for improvment.

\r\n

Thanks & Regards.

', '2005-03-30 11:43:55', 'Testing Notice board', 1, '20050724174314', 1); #---------------------------- # Table structure for orderdetails #---------------------------- CREATE TABLE `orderdetails` ( `orderID` int(11) default '0', `productID` int(11) default '0', `price` double(11,2) default '0.00', `quantity` int(11) default '0', `description` varchar(100) default NULL, `created` datetime default NULL, `createdBy` varchar(100) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(100) default NULL ) TYPE=MyISAM; #---------------------------- # No records for table orderdetails #---------------------------- #---------------------------- # Table structure for orders #---------------------------- CREATE TABLE `orders` ( `orderID` int(11) NOT NULL auto_increment, `userID` int(11) default '0', `orderDate` datetime default NULL, `premiumShipping` double default '0', `discountGiven` double default '0', `orderTotal` double(11,2) default '0.00', `orderStatus` varchar(50) default NULL, `customMessage` longtext, `specialInstruction` longtext, `notes` longtext, `customTime` datetime default NULL, `paymentDone` tinyint(1) default '0', `paymentGatewayID` int(11) default '0', `sentBy` varchar(100) default NULL, `billingAddressl1` varchar(50) default NULL, `billingAddressl2` varchar(50) default NULL, `billingAddressl3` varchar(50) default NULL, `billingAddressl4` varchar(50) default NULL, `billingCity` varchar(50) default NULL, `billingState` varchar(50) default NULL, `billingCountry` int(11) default NULL, `billingZipCode` varchar(50) default NULL, `billingPhoneno` varchar(50) default NULL, `billingEmail` varchar(50) default NULL, `sentTo` varchar(100) default 'Testing Name', `shippingAddressl1` varchar(50) default NULL, `shippingAddressl2` varchar(50) default NULL, `shippingAddressl3` varchar(50) default NULL, `shippingAddressl4` varchar(50) default NULL, `city` varchar(50) default NULL, `state` varchar(50) default NULL, `country` int(11) default NULL, `zipCode` varchar(50) default NULL, `phoneNo` varchar(50) default NULL, `trackingID` varchar(50) default NULL, `courierID` int(11) default '0', `created` datetime default NULL, `createdBy` varchar(50) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(50) default NULL, PRIMARY KEY (`orderID`) ) TYPE=MyISAM; #---------------------------- # No records for table orders #---------------------------- #---------------------------- # Table structure for paymentgateways #---------------------------- CREATE TABLE `paymentgateways` ( `gatewayID` int(11) NOT NULL default '0', `gatewayName` varchar(50) default NULL, `accountInfo` varchar(50) default NULL, `gatewayEnabled` tinyint(1) default NULL, `description` longtext, `image1` varchar(200) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', `updatingIP` varchar(50) default NULL, PRIMARY KEY (`gatewayID`) ) TYPE=MyISAM; #---------------------------- # Records for table paymentgateways #---------------------------- insert into paymentgateways values (1, '2 Checkout', '321482', 1, '\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
', 'icons/2CO.gif', '20050617081140', 1, '127.0.0.1'), (2, 'Paypal', 'contact@outsizes.com', 1, '\r\n\r\n\r\n\r\n\r\n
Secure service provided by PayPal.com, Limited to 40 countries only
', 'icons/paypal.gif', '20050722080440', 1, '127.0.0.1'), (3, 'WorldPay', '123456', 0, '\r\n\r\n\r\n\r\n\r\n
Worldwide 100% Secure credit card processing. You never have to worry about credit card safety when you are shopping at our site. We are using WorldPay.com for this service. Your credit card details will be collected and stored on secure WorldPay\'s server
', 'icons/WorldPay.gif', '20050625064550', 1, '127.0.0.1'); #---------------------------- # Table structure for productprice #---------------------------- CREATE TABLE `productprice` ( `productID` int(11) NOT NULL default '0', `currencyID` int(11) NOT NULL default '0', `price` double default '0', `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`productID`,`currencyID`) ) TYPE=MyISAM; #---------------------------- # Records for table productprice #---------------------------- insert into productprice values (164, 2, '-1', '2005-08-27 00:00:00', 1, '20050827233744', 1), (164, 1, '24.99', '2005-08-27 00:00:00', 1, '20050827233745', 1), (164, 3, '-1', '2005-08-27 00:00:00', 1, '20050827233745', 1), (164, 4, '-1', '2005-08-27 00:00:00', 1, '20050827233745', 1), (164, 5, '-1', '2005-08-27 00:00:00', 1, '20050827233745', 1), (164, 6, '-1', '2005-08-27 00:00:00', 1, '20050827233745', 1), (165, 2, '-1', '2005-08-28 00:00:00', 1, '20050828095252', 1), (165, 1, '100', '2005-08-28 00:00:00', 1, '20050828095252', 1), (165, 3, '-1', '2005-08-28 00:00:00', 1, '20050828095253', 1), (165, 4, '-1', '2005-08-28 00:00:00', 1, '20050828095253', 1), (165, 5, '-1', '2005-08-28 00:00:00', 1, '20050828095253', 1), (165, 6, '-1', '2005-08-28 00:00:00', 1, '20050828095253', 1); #---------------------------- # Table structure for products #---------------------------- CREATE TABLE `products` ( `productID` int(11) NOT NULL auto_increment, `categoryID` int(11) default '0', `productName` varchar(50) default NULL, `shortDescription` longtext, `longDescription` longtext, `status` tinyint(1) default '0', `discounted` tinyint(1) default NULL, `discountPercentage` int(11) default '0', `quantityInHand` int(11) default '0', `quantitySold` int(11) default '0', `weight` double default '0', `image1` varchar(50) default NULL, `image2` varchar(50) default NULL, `image3` varchar(50) default NULL, `image4` varchar(50) default NULL, `image5` varchar(50) default NULL, `displaySizeChart` tinyint(1) default '0', `sizeChartURL` varchar(200) default NULL, `viewed` int(11) default '0', `newProduct` tinyint(1) NOT NULL default '0', `bestSeller` tinyint(1) default NULL, `featuredProduct` tinyint(1) default NULL, `categoryFeatured` tinyint(1) default NULL, `customTimeDeliverable` tinyint(1) default '0', `shipToWholePakistan` tinyint(1) default '0', `shipToWholeWorld` tinyint(1) default NULL, `companyCode` varchar(32) NOT NULL default '', `supplierCode` varchar(32) NOT NULL default '', `created` datetime default NULL, `createdBy` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`productID`) ) TYPE=MyISAM; #---------------------------- # Records for table products #---------------------------- insert into products values (164, 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, '#', 3, 1, 0, 1, null, 0, 0, null, '', '', '2005-08-27 00:00:00', 1, '20050828104301', 1), (165, 57, 'Test Prod', 'Test Short Desc', 'Test Long descr', 1, 0, 0, 293, 0, '100', 'products/middleTJ01-418550.jpg', 'products/middleTJ01-418550.jpg', 'no', 'no', 'no', 1, 'http://www.yahoo.com', 0, 1, 1, 1, null, 1, 0, null, '1', '2', '2005-08-28 00:00:00', 1, '20050828095601', 1); #---------------------------- # Table structure for relatedproducts #---------------------------- CREATE TABLE `relatedproducts` ( `productID` int(4) NOT NULL default '0', `relatedProductID` int(4) NOT NULL default '0', PRIMARY KEY (`productID`,`relatedProductID`) ) TYPE=MyISAM; #---------------------------- # No records for table relatedproducts #---------------------------- #---------------------------- # Table structure for reply #---------------------------- CREATE TABLE `reply` ( `replyID` int(11) NOT NULL auto_increment, `supportID` int(11) NOT NULL default '0', `message` longtext, `replyBy` int(11) default NULL, `replied` timestamp(14) NOT NULL, PRIMARY KEY (`replyID`) ) TYPE=MyISAM; #---------------------------- # Records for table reply #---------------------------- insert into reply values (1, 6, 'asdfasdf asdf asdf ', 1, '20050618120753'), (2, 6, 'test', 1, '20050628082639'); #---------------------------- # Table structure for searchstrings #---------------------------- CREATE TABLE `searchstrings` ( `id` int(11) NOT NULL auto_increment, `searchText` varchar(50) default NULL, `timesSearch` varchar(50) default NULL, `created` datetime default NULL, `createdBy` varchar(50) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(50) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; #---------------------------- # Records for table searchstrings #---------------------------- insert into searchstrings values (1, 'a', '69', '2005-04-12 00:00:00', '203.82.48.54', '20050828102434', '62.183.100.121'), (2, 'r', '2', '2005-04-12 00:00:00', '212.103.235.141', '20050415000000', '212.240.194.229'), (3, 's', '16', '2005-04-12 00:00:00', '84.66.246.65', '20050828102439', '62.183.100.121'), (4, 'd', '1', '2005-04-12 00:00:00', '84.66.246.65', '20050424000000', '212.240.194.229'), (5, 'black', '3', '2005-04-13 00:00:00', '212.240.194.229', '20050413000000', '212.240.194.229'), (6, 'armani', '1', '2005-04-13 00:00:00', '84.67.175.62', '20050424000000', '212.240.194.229'), (7, 'adf', '2', '2005-04-18 00:00:00', '203.82.48.54', '20050721071931', '203.82.63.2'), (8, 'f', '2', '2005-04-18 00:00:00', '203.82.48.54', '20050424000000', '84.66.220.157'), (9, 'w', '1', '2005-04-18 00:00:00', '212.240.194.229', '20050424000000', '212.240.194.229'), (10, 't', '1', '2005-04-24 00:00:00', '84.66.220.157', '20050424000000', '212.240.194.229'), (11, 'c', '3', '2005-04-24 00:00:00', '84.66.220.157', '20050709002917', '81.77.77.88'), (12, '1', '8', '2005-04-06 00:00:00', '127.0.0.1', '20050726034545', '213.80.151.54'), (13, 'hell', '1', '2005-04-12 00:00:00', '192.168.0.1', '20050414183831', '192.168.0.1'), (14, 'test', '1', '2005-05-30 00:00:00', '84.65.210.254', '20050414183832', '192.168.0.1'), (15, 'bangles', '2', '2005-05-30 00:00:00', '203.99.49.90', '20050630052007', '203.135.21.45'), (16, 'kin', '8', '2005-06-15 00:00:00', '212.240.194.226', '20050623073642', '212.103.235.141'), (17, 'k', '1', '2005-04-14 00:00:00', '127.0.0.1', '00000000000000', null), (18, 'g', '1', '2005-06-17 00:00:00', '203.99.49.90', '20050617071515', '203.99.49.90'), (19, 'green', '1', '2005-06-17 00:00:00', '203.99.49.90', '20050617071529', '203.99.49.90'), (20, 'green s', '1', '2005-06-17 00:00:00', '203.99.49.90', '20050617071538', '203.99.49.90'), (21, 'dunkin', '5', '2005-06-17 00:00:00', '203.99.49.90', '20050706214939', '84.65.198.83'), (22, 'wh', '2', '2005-06-25 00:00:00', '203.99.49.90', '20050625065309', '203.99.49.90'), (23, 'sfsf', '1', '2005-06-26 00:00:00', '81.77.3.102', '20050626140812', '81.77.3.102'), (24, 'nokia', '13', '2005-06-26 00:00:00', '81.77.3.102', '20050718113332', '213.80.158.17'), (25, 'flower', '1', '2005-06-26 00:00:00', '81.77.3.102', '20050626140835', '81.77.3.102'), (26, 'flowers', '1', '2005-06-26 00:00:00', '81.77.3.102', '20050626140840', '81.77.3.102'), (27, 'rose', '1', '2005-06-26 00:00:00', '81.77.3.102', '20050626140855', '81.77.3.102'), (28, 'cake', '1', '2005-06-28 00:00:00', '84.67.163.94', '20050628211243', '84.67.163.94'), (29, 'burfi', '1', '2005-07-10 00:00:00', '84.66.151.202', '20050710154559', '84.66.151.202'), (30, 'Rado', '3', '2005-07-10 00:00:00', '84.66.151.202', '20050714224127', '81.79.195.23'), (31, 'Gillet', '1', '2005-07-10 00:00:00', '84.66.151.202', '20050710154929', '84.66.151.202'), (32, 'ertert', '1', '2005-07-14 00:00:00', '81.77.38.1', '20050714193231', '81.77.38.1'), (33, 'ghulab', '1', '2005-07-14 00:00:00', '81.79.195.23', '20050714224413', '81.79.195.23'), (34, 'ghu', '1', '2005-07-14 00:00:00', '81.79.195.23', '20050714224429', '81.79.195.23'), (35, 'hui', '3', '2005-07-18 00:00:00', '127.0.0.1', '20050718110036', '127.0.0.1'), (36, 'vah', '8', '2005-07-18 00:00:00', '127.0.0.1', '20050718112156', '127.0.0.1'), (37, 'nokia1', '1', '2005-07-18 00:00:00', '127.0.0.1', '20050718112735', '127.0.0.1'), (38, 'lopez', '1', '2005-07-18 00:00:00', '127.0.0.1', '20050718112842', '127.0.0.1'), (39, 'still', '1', '2005-07-18 00:00:00', '127.0.0.1', '20050718112849', '127.0.0.1'), (40, 'stil', '1', '2005-07-18 00:00:00', '127.0.0.1', '20050718112855', '127.0.0.1'), (41, 'women', '12', '2005-07-18 00:00:00', '127.0.0.1', '20050718114706', '127.0.0.1'), (42, 'bag', '6', '2005-07-18 00:00:00', '203.82.63.2', '20050726115536', '213.80.158.56'), (43, 'asdfasdf', '1', '2005-07-23 00:00:00', '203.99.49.173', '20050723063101', '203.99.49.173'), (44, '..', '3', '2005-07-26 00:00:00', '203.82.48.54', '20050726032857', '203.82.48.54'), (45, '\'', '5', '2005-07-26 00:00:00', '203.82.48.54', '20050726044414', '213.80.151.54'), (46, '', '2', '2005-07-26 00:00:00', '203.82.48.54', '20050726033146', '203.82.48.54'), (47, '\\\'', '7', '2005-07-26 00:00:00', '213.80.151.54', '20050726065505', '203.99.49.173'), (48, '\\\\', '1', '2005-07-26 00:00:00', '213.80.151.54', '20050726045241', '213.80.151.54'), (49, 'stretch', '1', '2005-07-26 00:00:00', '203.99.49.173', '20050726070410', '203.99.49.173'), (50, 'jean', '13', '2005-07-26 00:00:00', '203.99.49.173', '20050726115507', '213.80.158.56'), (51, 'silk', '1', '2005-07-28 00:00:00', '203.99.49.90', '20050728130910', '203.99.49.90'), (52, 'o', '2', '2005-08-13 00:00:00', '81.79.136.23', '20050828102452', '62.183.100.121'), (53, '#', '1', '2005-08-26 00:00:00', '203.82.48.54', '20050826124644', '203.82.48.54'), (54, 'sd', '1', '2005-08-28 00:00:00', '62.183.100.121', '20050828102320', '62.183.100.121'), (55, 'asdasd', '1', '2005-08-28 00:00:00', '62.183.100.121', '20050828102424', '62.183.100.121'); #---------------------------- # Table structure for support #---------------------------- CREATE TABLE `support` ( `id` int(11) NOT NULL auto_increment, `email` varchar(50) default NULL, `subject` varchar(50) default NULL, `message` longtext, `type` varchar(50) default NULL, `created` datetime default NULL, `createdBy` varchar(50) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(50) default NULL, `status` varchar(50) NOT NULL default 'New', PRIMARY KEY (`id`) ) TYPE=MyISAM; #---------------------------- # Records for table support #---------------------------- insert into support values (4, 'me@mine.com', 'how to use send mail when an event occurs', 'form5olo', 'Enquiry', '2005-04-06 15:05:40', '127.0.0.1', '20050406150540', '1', 'Fixed'), (6, 'farhan@artologics.com', 'I dont have any problem', 'Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing ', 'Enquiry', '2005-05-27 08:49:06', '203.99.49.90', '20050618120737', '1', 'Reply'); #---------------------------- # Table structure for transactions #---------------------------- CREATE TABLE `transactions` ( `transactionID` int(11) NOT NULL auto_increment, `coporateUserID` int(11) default '0', `amountTransferred` double default '0', `description` longtext, `discountGiven` double default '0', `created` datetime default NULL, `createdBy` varchar(50) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(50) default NULL, PRIMARY KEY (`transactionID`) ) TYPE=MyISAM; #---------------------------- # No records for table transactions #---------------------------- #---------------------------- # Table structure for useraccounts #---------------------------- CREATE TABLE `useraccounts` ( `accountID` int(11) NOT NULL auto_increment, `loginName` varchar(50) default NULL, `password` varchar(50) default NULL, `type` char(1) default NULL, `email` varchar(50) default NULL, `created` datetime default NULL, `createdBy` varchar(50) default NULL, `updated` timestamp(14) NOT NULL, `updatedBy` varchar(50) default NULL, PRIMARY KEY (`accountID`) ) TYPE=MyISAM; #---------------------------- # Records for table useraccounts #---------------------------- insert into useraccounts values (1, 'admin', 'test', 'a', 'admin@expressgifts.com', '0000-00-00 00:00:00', '1', '00000000000000', '1'), (3, 'farhan', 'farhan', 'g', 'farhan@artologics.com', '2005-04-11 15:26:08', '1', '20050620075345', '1'), (11, 'shah', 'shah', 'c', 'khaqan@artologics.com', '2005-04-11 15:26:08', '1', '20050411152608', '1'), (10, 'kk', 'kk', 'c', 'khaqan@artologics.com', '2005-04-10 15:49:57', '1', '20050410154957', '1'), (12, 'mateenmba_2005@hotmail.com', 'mateenmba_2005', 'a', 'mateenmba_2005@hotmail.com', '2005-06-28 00:00:00', 'Admin ID: 1', '20050628080028', 'Admin ID: 1'), (13, 'safia', 'baloo', 'g', 'ssschanda@hotmail.com', null, null, '20050630053213', null), (18, 'khaqan', 'khaqan1', 'g', 'khaqan@artologics.com', null, null, '20050721035701', null), (19, 'eb', 'eb', 'a', 'ebdeveloper@yahoo.com', '2005-08-28 00:00:00', 'Admin ID: 1', '20050828102100', 'Admin ID: 1'); #---------------------------- # Table structure for weightcosting #---------------------------- CREATE TABLE `weightcosting` ( `weightCostingID` int(11) NOT NULL auto_increment, `countryID` int(11) default '0', `courierID` int(11) default '0', `weightMin` double default '0', `WeightMax` double default '0', `shipCost` double default '0', `created` datetime default NULL, `createdby` int(11) default '0', `updated` timestamp(14) NOT NULL, `updatedBy` int(11) default '0', PRIMARY KEY (`weightCostingID`) ) TYPE=MyISAM; #---------------------------- # Records for table weightcosting #---------------------------- insert into weightcosting values (9, 2, 1, '22', '223', '1', '2005-08-28 00:00:00', 1, '20050828112321', 1);