/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_Portfolio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idCategory` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text,
  `link` enum('y','n') NOT NULL,
  `linkTitle` varchar(255) NOT NULL,
  `linkUrl` varchar(255) NOT NULL,
  `show` enum('y','n') NOT NULL DEFAULT 'y',
  `sorter` int(11) NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idCategory` (`idCategory`,`show`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_Portfolio` (`id`, `idCategory`, `title`, `image`, `description`, `link`, `linkTitle`, `linkUrl`, `show`, `sorter`, `added`, `changed`) VALUES (1,1,'Indoor Home Design 2','classic_indoor_design_5(49).jpg','<p>Ei nec dicam verear tibique. Veritus platonem quo eu, mollis apeirian id duo. Vis vide adversarium philosophia ne, verear accusamus scripserit his at, no putant alterum postulant has. Has mutat detraxit recteque ei, nemore nostrum eos eu.</p>','y','Test Link','http://google.com','y',1,'2010-11-22 14:20:20','2012-03-01 16:02:50'),(2,2,'Home','Riverfront-home-design-by-Hartree-Architects_1(57).jpg','<p>Content coming soon</p>','n','','','y',17,'2010-11-22 14:20:43','2011-04-22 12:10:53'),(3,1,'Indoor Home Design 1','2cwvd5u(48).jpg','','y','Manufacturers','{BASE_URL}/manufacturers','y',0,'2010-11-23 10:39:21','2011-11-10 17:53:57'),(20,8,'Title','fff_(564).gif','','n','','','y',0,'2012-02-13 17:14:01','2012-02-13 17:19:02'),(19,7,'New Image','port-work(463).gif','<p>This is my test</p>','n','','','y',0,'2011-10-13 16:08:15','2011-10-13 16:08:15'),(17,5,'second','D7000_18_105_top_l-001(78).jpg','<p>test</p>','n','','','n',1,'2011-04-22 10:48:02','2011-04-22 12:40:44'),(18,5,'Third','Samsung_Topaz_P2370(79).jpg','<p>third</p>','n','','','n',2,'2011-04-22 11:00:27','2011-04-22 12:43:55'),(4,3,'Receiption Desk Room','reception desk and lobby design(46).jpg','<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas feugiat consequat diam. Maecenas metus. Vivamus diam purus, cursus a, commodo non, facilisis vitae, nulla. Aenean dictum lacinia tortor. Nunc iaculis, nibh non iaculis aliquam, orci felis euismod neque, sed ornare massa mauris sed velit. Nulla pretium mi et risus. Fusce mi pede, tempor id, cursus ac, ullamcorper nec, enim. Sed tortor. Curabitur molestie. Duis velit augue, condimentum at, ultrices a, luctus ut, orci. Donec pellentesque egestas eros. Integer cursus, augue in cursus faucibus, eros pede bibendum sem, in tempus tellus justo quis ligula. Etiam eget tortor. Vestibulum rutrum, est ut placerat elementum, lectus nisl aliquam velit, tempor aliquam eros nunc nonummy metus. In eros metus, gravida a, gravida sed, lobortis id, turpis. Ut ultrices, ipsum at venenatis fringilla, sem nulla lacinia tellus, eget aliquet turpis mauris non enim. Nam turpis. Suspendisse lacinia. Curabitur ac tortor ut ipsum egestas elementum. Nunc imperdiet gravida mauris.</p>','n','','','y',16,'2010-11-25 11:12:07','2011-04-22 12:10:53'),(5,3,'Ultra Modern Corporate Office Interrior','ultra modern corporate offices and interiors(47).jpg','<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas feugiat consequat diam. Maecenas metus. Vivamus diam purus, cursus a, commodo non, facilisis vitae, nulla. Aenean dictum lacinia tortor. Nunc iaculis, nibh non iaculis aliquam, orci felis euismod neque, sed ornare massa mauris sed velit. Nulla pretium mi et risus. Fusce mi pede, tempor id, cursus ac, ullamcorper nec, enim. Sed tortor. Curabitur molestie. Duis velit augue, condimentum at, ultrices a, luctus ut, orci. Donec pellentesque egestas eros. Integer cursus, augue in cursus faucibus, eros pede bibendum sem, in tempus tellus justo quis ligula. Etiam eget tortor. Vestibulum rutrum, est ut placerat elementum, lectus nisl aliquam velit, tempor aliquam eros nunc nonummy metus. In eros metus, gravida a, gravida sed, lobortis id, turpis. Ut ultrices, ipsum at venenatis fringilla, sem nulla lacinia tellus, eget aliquet turpis mauris non enim. Nam turpis. Suspendisse lacinia. Curabitur ac tortor ut ipsum egestas elementum. Nunc imperdiet gravida mauris.</p>','n','','','y',15,'2010-11-25 11:12:56','2011-04-22 12:10:53'),(6,1,'Living Room 1','ContemporaryLivingRoombyZalf-1(50).jpg','<p>Content coming soon</p>','n','','','y',2,'2010-11-25 11:42:53','2011-11-10 17:53:57'),(7,1,'Living Room 2','ContemporaryLivingRoombyZalf-4(51).jpg','<p>Content coming soon</p>','n','','','y',3,'2010-11-25 11:43:53','2011-11-10 17:53:57'),(8,1,'Living Room 3','ContemporaryLivingRoombyZalf-6(52).jpg','<p>Content coming soon</p>','n','','','y',4,'2010-11-25 11:44:15','2011-11-10 17:53:57'),(9,1,'Living Room 4','ContemporaryLivingRoombyZalf-5(53).jpg','','n','','','y',5,'2010-11-25 11:44:53','2011-11-10 17:53:57'),(10,1,'Living Room 5','ContemporaryLivingRoombyZalf-8(54).jpg','<p>Content coming soon</p>','n','','','y',6,'2010-11-25 11:45:19','2011-11-10 17:53:57'),(11,1,'Living Room 6','ContemporaryLivingRoombyZalf-10(55).jpg','<p>Content coming soon</p>','n','','','y',7,'2010-11-25 11:45:48','2011-11-10 17:53:57'),(12,1,'Living Room 7','indoor-plants-on-modern-home-design-3(56).jpg','<p>Content coming soon</p>','n','','','y',8,'2010-11-25 11:46:18','2011-11-10 17:53:57'),(13,2,'Green Home','Luxury-Home-Design-with-Elegant-Architectur-and-Large-Outdoor-Entertainment-1(58).jpg','<p>Content coming soon</p>','n','','','y',7,'2010-11-25 11:49:03','2011-04-22 12:10:53'),(14,2,'Modern Luxury','2010-modern-luxury-outdoor-home-design-640x396(59).jpg','<p>Content coming soon</p>','n','','','y',6,'2010-11-25 11:49:38','2011-04-22 12:10:53'),(15,4,'Test work 1','object-002(447).png','<ul>\r\n    <li>Lorem ipsum erat adhuc omnes nec ne, ea eos deserunt adipisci</li>\r\n    <li>eleifend. Ipsum elitr homero an mea, per ut prima delicata,</li>\r\n    <li>no eam veniam luptatum delicatissimi. Ut blandit repudiandae</li>\r\n    <li>mea, per ne mazim dissentias. Dicit iriure perpetua eos an, nec stet dissentiunt eu,</li>\r\n    <li>no his vide tollit. Posidonium philosophia mei no, wisi lorem deleniti ad mei,</li>\r\n    <li>te sit affert postea facilisis. Esse tamquam ei qui, erant utinam voluptaria vis et.</li>\r\n</ul>','n','test link','http://www.google.com','n',3,'2010-12-02 07:03:52','2011-10-11 15:04:43');
