DROP TABLE IF EXISTS `clcategory`;
CREATE TABLE `clcategory`(`CategoryName` VARCHAR(50) ,`CategoryID` INT AUTO_INCREMENT,PRIMARY KEY (`CategoryID`));
DROP TABLE IF EXISTS `clmain`;
CREATE TABLE `clmain`(`Category` VARCHAR(50) ,`Details` LONGTEXT ,`Fullinfo` LONGTEXT ,`ID` INT AUTO_INCREMENT,`Picture` LONGTEXT ,`Posted` DATE ,`Subcategory` VARCHAR(50) ,`Title` VARCHAR(50) ,`UserID` VARCHAR(50) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `clusers`;
CREATE TABLE `clusers`(`email` VARCHAR(50) ,`fullname` VARCHAR(50) ,`password` VARCHAR(50) ,`username` VARCHAR(50) ,PRIMARY KEY (`username`,`password`));
DROP TABLE IF EXISTS `clreply`;
CREATE TABLE `clreply`(`Email` VARCHAR(50) ,`FullName` VARCHAR(50) ,`Message` LONGTEXT ,`ReplyID` INT AUTO_INCREMENT,`Subject` LONGTEXT ,PRIMARY KEY (`ReplyID`));
DROP TABLE IF EXISTS `clreplyfriend`;
CREATE TABLE `clreplyfriend`(`Message` LONGTEXT ,`RecipientEmail` VARCHAR(50) ,`RecipientName` VARCHAR(50) ,`ReplyID` INT AUTO_INCREMENT,`SenderEmail` VARCHAR(50) ,`SenderName` VARCHAR(50) ,`Subject` LONGTEXT ,PRIMARY KEY (`ReplyID`));
DROP TABLE IF EXISTS `clsubcategory`;
CREATE TABLE `clsubcategory`(`Category` VARCHAR(50) ,`SubcategoryID` INT AUTO_INCREMENT,`SubcategoryName` VARCHAR(50) ,PRIMARY KEY (`SubcategoryID`));
INSERT INTO `clcategory`(`CategoryID`,`CategoryName`) VALUES(1,'Home Services');
INSERT INTO `clcategory`(`CategoryID`,`CategoryName`) VALUES(2,'Automotive');
INSERT INTO `clcategory`(`CategoryID`,`CategoryName`) VALUES(3,'Announcements');
INSERT INTO `clcategory`(`CategoryID`,`CategoryName`) VALUES(4,'Real Estate');
INSERT INTO `clcategory`(`CategoryID`,`CategoryName`) VALUES(5,'For Sale');
INSERT INTO `clmain`(`ID`,`Category`,`Subcategory`,`Title`,`Posted`,`Details`,`Fullinfo`,`Picture`,`UserID`) VALUES(1,'For Sale','Books','Winnie the Pooh','2007-4-3 0:0:0','Pooh is a little bear with a big intelligence. He loves to sit under a tree and think. Under the tree called Mr Sander he thinks about what he should do. Usually this means thinking about wether it\'s time for hunny. As his biggest worry is hunny. He eats hunny at breakfast, lunch and dinner. Many adventures of Pooh are about hunny.  rWinnie the Pooh is Christopher Robins best friend. Winnie the Pooh has lots of friends, like Piglet, Tigger and Rabbit.','<P>Pooh is a little bear with a big intelligence.&nbsp;He loves to sit under a tree and <A href=\"http://www.poohfriends.com/modules.php?name=Audio&amp;l\_op=visit&amp;lid=46\" target=\_blank>think</A>.&nbsp;Under the tree called Mr Sander he thinks about&nbsp;what he should do. Usually this means thinking about wether it\'s time for hunny. As&nbsp;his biggest worry is hunny. He eats hunny at breakfast, lunch and dinner.&nbsp;Many adventures of Pooh are about hunny.&nbsp; <BR>Winnie the Pooh is Christopher Robins best friend. Winnie the Pooh has lots of friends, like Piglet, Tigger and Rabbit.</P>','pooh.jpg','jane');
INSERT INTO `clmain`(`ID`,`Category`,`Subcategory`,`Title`,`Posted`,`Details`,`Fullinfo`,`Picture`,`UserID`) VALUES(2,'Real Estate','Homes','All about weddings','2007-4-3 0:0:0','Everything you need to plan for a wedding! Whether you are the bride and groom, a family member, bridesmaid, or a guest, this site will provide you with ... r',NULL,'card2.jpg','admin');
INSERT INTO `clmain`(`ID`,`Category`,`Subcategory`,`Title`,`Posted`,`Details`,`Fullinfo`,`Picture`,`UserID`) VALUES(3,'Automotive','Cars','2003 Nissan Frontier XE-V6 ','2007-4-24 0:0:0','Details: 2003 Nissan Frontier XE-V6 $24550, 29912 kms., Silver, Automatic, 3 Passenger, 2 Door, Stock# U3C429816, Air Conditioning, Alloy Wheels, CD, Power Windows, Power Locks, Tilt, Cruise Control, 4x4, ABS, Loaded ADDISON AUTO EXCHANGE, Toronto, 416-466-2004 ',NULL,'c440045a.jpg','admin');
INSERT INTO `clmain`(`ID`,`Category`,`Subcategory`,`Title`,`Posted`,`Details`,`Fullinfo`,`Picture`,`UserID`) VALUES(4,'For Sale','Books','New book','2007-4-24 0:0:0','Read and release your books into the wild! Tag your used books with a unique tracking number, then follow their travels through the world at BookCrossing',NULL,'81057.jpg','admin');
INSERT INTO `clusers`(`username`,`password`,`email`,`fullname`) VALUES('admin','admin','admin@test.com','admin admin');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(1,'Trucks','Home Services');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(2,'Cars','Automotive');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(3,'Vans','Automotive');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(4,'Weddings','Announcements');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(5,'Births','Announcements');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(6,'Antiques','For Sale');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(7,'Condos','Real Estate');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(8,'Homes','Real Estate');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(9,'Vacation Propertie','Real Estate');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(10,'Building Trades','Home Services');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(11,'Handy Men','Home Services');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(12,'test auto sub','Automotive');
INSERT INTO `clsubcategory`(`SubcategoryID`,`SubcategoryName`,`Category`) VALUES(13,'Books','For Sale');