/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_PostComment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idPost` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `title` varchar(255) NOT NULL,
  `author` varchar(255) DEFAULT NULL,
  `authorId` int(11) DEFAULT NULL,
  `authorType` enum('admin','user') DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `content` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `ipAddress` varchar(20) DEFAULT NULL,
  `userAgent` varchar(255) DEFAULT NULL,
  `referer` varchar(255) DEFAULT NULL,
  `status` enum('pending','approved','disapproved','spam') NOT NULL DEFAULT 'pending',
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_PostComment` (`id`, `idPost`, `date`, `title`, `author`, `authorId`, `authorType`, `email`, `content`, `url`, `ipAddress`, `userAgent`, `referer`, `status`, `added`, `changed`) VALUES (14,11,'2011-11-10 10:40:00','','Guest',NULL,NULL,'guest@vityk.fr-wd.com','That\'s quite possibly the stupidist statement I\'ve seen about patents. If Microsoft or any other company (Apple, AT&T, IBM, Oracle, etc.) is due license fees for the use of their patented IP then it is not a racket. A company is due license fees from others that use IP which the patent holder invested monies in designing, engineering and researching. That why the US has patent laws.','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Eric-Schmidt-Microsoft-Pushes-Patent-Deals-Out-Of-Fear-Of-Android','approved','2011-11-10 10:40:24','2011-11-10 14:26:27'),(13,8,'2011-10-26 17:14:19','','Vitalii Ternopilskyi',21,'user','test@vityk.fr-wd.com','Kopete?\r\nI prefer Qutim... or Pidgin.\r\nKopete does not have all the protocols I need...','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/The-Perfect-Desktop-Kubuntu-11-10','approved','2011-10-26 17:14:19','2011-10-26 17:14:19'),(12,8,'2011-10-26 17:02:32','Have you considered','Website Administrator',35,'admin','test@vityk.fr-wd.com','Have you considered BlueGriffon instead of Kompozer?\r\n\r\nKompozer seems to be an outdated and discontinued projet. \r\n\r\nBlueGriffon looks like a much better option to me.','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/The-Perfect-Desktop-Kubuntu-11-10','approved','2011-10-26 17:02:32','2011-10-26 17:02:32'),(15,11,'2011-11-10 00:00:00','','Website Administrator',35,'admin','test@vityk.fr-wd.com','The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\r\n\r\nzzz','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Eric-Schmidt-Microsoft-Pushes-Patent-Deals-Out-Of-Fear-Of-Android','approved','2011-11-10 11:44:31','2011-11-10 12:38:55'),(16,11,'2011-11-10 00:00:00','','Website Administrator',35,'admin','test@vityk.fr-wd.com','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Eric-Schmidt-Microsoft-Pushes-Patent-Deals-Out-Of-Fear-Of-Android','approved','2011-11-10 12:39:24','2011-11-10 12:45:44'),(17,11,'2011-11-10 14:31:00','','Website Administrator',35,'admin','test@vityk.fr-wd.com','At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Eric-Schmidt-Microsoft-Pushes-Patent-Deals-Out-Of-Fear-Of-Android','approved','2011-11-10 14:31:01','2011-11-10 14:31:44'),(18,11,'2011-11-10 14:32:00','','Website Administrator',35,'admin','test@vityk.fr-wd.com','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Eric-Schmidt-Microsoft-Pushes-Patent-Deals-Out-Of-Fear-Of-Android','approved','2011-11-10 14:32:27','2011-11-10 14:32:46'),(19,11,'2011-11-10 14:40:00','','Website Administrator',35,'admin','test@vityk.fr-wd.com','Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','http://www.frontierwebdev.com','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Eric-Schmidt-Microsoft-Pushes-Patent-Deals-Out-Of-Fear-Of-Android','approved','2011-11-10 14:40:45','2011-11-10 14:44:07'),(24,10,'2011-11-10 17:39:00','test title','vityk',NULL,NULL,'test@vityk.fr-wd.com','test comment','http://www.frontierwebdev.com/','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Google-Web-Toolkit-and-Web-Services-The-JSONJSONP-Way','approved','2011-11-10 17:39:23','2011-11-10 17:39:57'),(25,10,'2011-11-10 17:46:04','test title 2','Vitalii Ternopilskyi',21,'user','test@vityk.fr-wd.com','test comment 2','http://google.com','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Google-Web-Toolkit-and-Web-Services-The-JSONJSONP-Way','approved','2011-11-10 17:46:04','2011-11-10 17:46:27'),(22,11,'2011-11-10 17:24:00','cc','Website Administrator',35,'admin','test@vityk.fr-wd.com','dd','http://www.frontierwebdew.com','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/admin/blog/comment/11?orderBy=date+DESC','approved','2011-11-10 17:33:46','2011-11-10 17:33:46'),(23,11,'2011-11-10 17:34:03','GParted Live Update Supports Btrfs Resizing','Website Administrator',35,'admin','test@vityk.fr-wd.com','adfasdf','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Eric-Schmidt-Microsoft-Pushes-Patent-Deals-Out-Of-Fear-Of-Android','approved','2011-11-10 17:34:03','2011-11-10 17:34:35'),(26,10,'2011-11-10 17:47:22','test title 3','Website Administrator',35,'admin','test@vityk.fr-wd.com','test comment 3','http://ya.ru','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1','{BASE_URL}/blog/Google-Web-Toolkit-and-Web-Services-The-JSONJSONP-Way','approved','2011-11-10 17:47:23','2011-11-10 17:47:45'),(27,15,'2011-11-24 10:36:46','Test Comment 1','tester Sha',42,'admin','tester@sha.fr-wd.com','This is my test comment 1.','','10.0.0.242','Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20100101 Firefox/8.0','{BASE_URL}/blog/lily','approved','2011-11-24 10:36:46','2012-03-09 15:12:45'),(28,15,'2011-11-24 11:16:45','Test Comment 2','Lia',NULL,NULL,'my@sha.fr-wd.com','tan prep pali e, kin olin kute interj ma. ken e nasin nanpa. ale jo lipu conj pini, jaki insa sinpin kin tu. len kama mama e, kin o seme mute sinpin. o olin sona ale, li pana sama akesi ali. ken walo lawa sinpin en. ni kute ante ali, oth e kala kepeken, ijo n pimeja sinpin.','','10.0.0.242','Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2)','{BASE_URL}/blog/lily','approved','2011-11-24 11:16:45','2012-03-09 15:12:44'),(30,15,'2012-03-09 14:17:19','','Website Administrator',35,'admin','test@vityk.fr-wd.com','test','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2','{BASE_URL}/blog/lily','approved','2012-03-09 14:17:19','2012-03-09 15:12:42');