/*!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=63 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 (45,25,'2012-12-03 11:53:46','','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','Even after using ZF2 through the various betas and pouring over the code, I\'m still a little confused about the purpose of a module in ZF2. It seems to be an arbitrary categorization for any piece of code deemed worthy. I\'ve seen it used for implementing the Doctrine entity manager, authentication, among other things, all of which differ quite a bit from the implementation in ZF1.\r\n\r\nIn ZF1, modules provided a great way to group controllers within the MVC framework. It was relatively straightforward when looking at it from the MVC perspective. Modules led to controllers and views, providing a nice default routing scheme (module/controller/action), and models were nice and tidy in the models directory. There *seems* to be a fair amount of duplication involved in using modules in this fashion in ZF2. Am I mistaken? If so, does anyone have any suggestions?','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','approved','2012-12-03 11:53:46','2012-12-03 11:53:57'),(46,25,'2012-12-03 12:37:35','','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','ddd','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 12:37:35','2012-12-03 12:37:35'),(47,25,'2012-12-03 12:38:24','','vityk',NULL,NULL,'vityk@fr-wd.com','zzzzz','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.95 Safari/537.11','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 12:38:24','2012-12-03 12:38:24'),(48,25,'2012-12-03 12:55:12','','vityk',NULL,NULL,'vityk@fr-wd.com','zzzzz','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.95 Safari/537.11','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 12:55:12','2012-12-03 12:55:12'),(49,25,'2012-12-03 12:56:49','dddd','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','asd fasdf asdf','http://www.adaptainc.com/','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 12:56:49','2012-12-03 12:56:49'),(50,25,'2012-12-03 12:56:56','','vityk',NULL,NULL,'vityk@fr-wd.com','zzzzz','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.95 Safari/537.11','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 12:56:56','2012-12-03 12:56:56'),(51,25,'2012-12-03 12:57:22','tttt','aaaa',NULL,NULL,'test@vityk.fr-wd.com','ccccc','http://www.adaptainc.com/','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.95 Safari/537.11','{BASE_URL}/blog/Why-Modules','disapproved','2012-12-03 12:57:22','2012-12-07 10:43:46'),(52,25,'2012-12-03 13:00:09','','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','ddddddddd','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 13:00:09','2012-12-03 13:00:09'),(53,25,'2012-12-03 13:01:23','','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','ffffff','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 13:01:23','2012-12-03 13:01:23'),(54,25,'2012-12-03 13:03:06','','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','dddd','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 13:03:06','2012-12-03 13:03:06'),(55,25,'2012-12-03 13:03:59','','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','ddd','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 13:03:59','2012-12-03 13:03:59'),(56,25,'2012-12-03 13:04:31','','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','asdfasd','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 13:04:31','2012-12-03 13:04:31'),(57,25,'2012-12-03 13:06:08','','Vitalii Ternopilskyi',2,'user','vityk@adaptainc.com','asdfasdf','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-03 13:06:08','2012-12-03 13:06:08'),(58,25,'2012-12-06 15:35:04','','Liudmyla Chekhovska',3,'user','customer@sha.fr-wd.com','Test comment posted by Liudmyla Chekhovska','','10.0.0.6','Mozilla/5.0 (Windows NT 6.1; rv:17.0) Gecko/20100101 Firefox/17.0','{BASE_URL}/blog/Why-Modules','approved','2012-12-06 15:35:04','2012-12-06 15:37:29'),(59,25,'2012-12-06 15:35:00','test title','Liudmyla Chekhovska',3,'user','customer@sha.fr-wd.com','Test comment 2 posted by Liudmyla Chekhovska','','10.0.0.6','Mozilla/5.0 (Windows NT 6.1; rv:17.0) Gecko/20100101 Firefox/17.0','{BASE_URL}/blog/Why-Modules','approved','2012-12-06 15:35:58','2012-12-06 15:40:46'),(60,25,'2012-12-06 15:45:06','','Test Author',NULL,NULL,'test@sha.fr-wd.com','comment goes here','','10.0.0.6','Mozilla/5.0 (Windows NT 6.1; rv:17.0) Gecko/20100101 Firefox/17.0','{BASE_URL}/blog/Why-Modules','pending','2012-12-06 15:45:06','2012-12-06 15:45:06'),(62,26,'2012-12-07 16:14:59','test title','vityk',NULL,NULL,'test@vityk.fr-wd.com','test comment http://www.adaptainc.com/','http://www.adaptainc.com/','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0','{BASE_URL}/blog/test-title','approved','2012-12-07 16:14:59','2012-12-07 16:15:11'),(44,25,'2012-12-03 11:47:41','','Oakleys',NULL,NULL,'Oakleys@vityk.fr-wd.com','Thanks. I wanna know how to write reusable ZF2 modules','','10.0.0.8','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0','{BASE_URL}/blog/Why-Modules','approved','2012-12-03 11:47:41','2012-12-03 11:53:55');