DROP TABLE IF EXISTS `ppcategory`;
CREATE TABLE `ppcategory`(`CategoryID` INT AUTO_INCREMENT,`CategoryName` VARCHAR(50) ,PRIMARY KEY (`CategoryID`));
DROP TABLE IF EXISTS `ppmain`;
CREATE TABLE `ppmain`(`Category` VARCHAR(50) ,`Details` LONGTEXT ,`Fullinfo` LONGTEXT ,`ID` INT AUTO_INCREMENT,`Picture` VARCHAR(50) ,`Price` VARCHAR(50) ,`Subcategory` VARCHAR(50) ,`Title` VARCHAR(50) ,`UserID` VARCHAR(50) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `pppaypal_info`;
CREATE TABLE `pppaypal_info`(`CancelPage` VARCHAR(50) ,`Currency` VARCHAR(50) ,`ID` INT AUTO_INCREMENT,`IPNPage` VARCHAR(50) ,`Logo` VARCHAR(50) ,`PayPalEmailAddress` VARCHAR(50) ,`PayPalServer` VARCHAR(50) ,`SMSEmailAddress` VARCHAR(50) ,`StoreName` VARCHAR(50) ,`SuccessPage` VARCHAR(50) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `ppusers`;
CREATE TABLE `ppusers`(`email` VARCHAR(50) ,`fullname` VARCHAR(50) ,`password` VARCHAR(50) ,`username` VARCHAR(50) ,`userid` INT AUTO_INCREMENT,PRIMARY KEY (`userid`));
DROP TABLE IF EXISTS `ppsubcategory`;
CREATE TABLE `ppsubcategory`(`Category` VARCHAR(50) ,`SubcategoryID` INT AUTO_INCREMENT,`SubcategoryName` VARCHAR(50) ,PRIMARY KEY (`SubcategoryID`));
INSERT INTO `ppcategory`(`CategoryID`,`CategoryName`) VALUES(1,'Appliances');
INSERT INTO `ppcategory`(`CategoryID`,`CategoryName`) VALUES(2,'Audio');
INSERT INTO `ppcategory`(`CategoryID`,`CategoryName`) VALUES(3,'Portable Audio');
INSERT INTO `ppcategory`(`CategoryID`,`CategoryName`) VALUES(4,'Portable Electronics');
INSERT INTO `ppcategory`(`CategoryID`,`CategoryName`) VALUES(5,'Services');
INSERT INTO `ppcategory`(`CategoryID`,`CategoryName`) VALUES(6,'TV/Video');
INSERT INTO `ppmain`(`ID`,`Category`,`Subcategory`,`Title`,`Price`,`Details`,`Fullinfo`,`Picture`,`UserID`) VALUES(3,'TV/Video','Plasma/LCD','Sony KDL-52 X2000','155.70','This plasma TV features a totally new design that reinvents TV as we know it. At 4 inches thick, it features a cable TV tuner and integrated speaker system',NULL,'251822s.jpg',NULL);
INSERT INTO `ppmain`(`ID`,`Category`,`Subcategory`,`Title`,`Price`,`Details`,`Fullinfo`,`Picture`,`UserID`) VALUES(4,'TV/Video','Plasma/LCD','Sharp LC-52 XD1RU','299.95','This plasma TV features a totally new design that reinvents TV as we know it. At 4 inches thick, it features a cable TV tuner and integrated speaker system',NULL,'212540s.jpg',NULL);
INSERT INTO `ppmain`(`ID`,`Category`,`Subcategory`,`Title`,`Price`,`Details`,`Fullinfo`,`Picture`,`UserID`) VALUES(5,'Portable Electronics','Mobile Phone','Nokia E61 ','298.95',NULL,NULL,'228474s.jpg',NULL);
INSERT INTO `ppmain`(`ID`,`Category`,`Subcategory`,`Title`,`Price`,`Details`,`Fullinfo`,`Picture`,`UserID`) VALUES(6,'Appliances','Refridgerators/Freezers','Indesit T 14','366.66',NULL,NULL,'223699s.jpg',NULL);
INSERT INTO `pppaypal_info`(`ID`,`StoreName`,`Currency`,`PayPalEmailAddress`,`Logo`,`IPNPage`,`CancelPage`,`SuccessPage`,`PayPalServer`,`SMSEmailAddress`) VALUES(1,'XLineSoft Test store ','USD','kornilov@xlinesoft.com','http://xlinesoft.com/img/top004.jpg','http://test.com/1','http://test.com/2','http://test.com/3','Test server',NULL);
INSERT INTO `ppusers`(`userid`,`username`,`password`,`email`,`fullname`) VALUES(1,'admin','admin',NULL,'Administrator');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(1,'Washer/Dryers','Appliances');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(2,'Refridgerators/Freezers','Appliances');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(3,'Home Stereo','Audio');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(4,'Home Theatre','Audio');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(5,'Speakers','Audio');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(6,'MP3 Players','Portable Audio');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(7,'Handhelds & PDAs','Portable Electronics');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(8,'Installation','Services');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(9,'Repairs','Services');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(10,'DVD Players','TV/Video');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(11,'Flat Screen','TV/Video');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(12,'Plasma/LCD','TV/Video');
INSERT INTO `ppsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(13,'Mobile Phone','Portable Electronics');
