Sampel data for beers app.

sample_data.sql

INSERT INTO `beers` VALUES (1,'Budweiser','Tastes like pee.','2016-03-31 13:59:47','2016-04-08 21:44:16',27),(2,'Coors','Also much like pee.','2016-04-05 13:59:47','2016-04-08 13:59:45',0);
INSERT INTO `comment_hierarchies` VALUES (8,8,0),(9,9,0),(10,10,0),(8,11,1),(11,11,0),(9,12,1),(12,12,0),(10,13,1),(13,13,0),(9,14,2),(12,14,1),(14,14,0),(15,15,0),(15,16,1),(16,16,0),(15,17,2),(16,17,1),(17,17,0),(15,18,3),(16,18,2),(17,18,1),(18,18,0),(19,19,0),(20,20,0),(21,21,0),(22,22,0),(23,23,0),(24,24,0),(22,25,1),(25,25,0),(26,26,0),(27,27,0),(28,28,0),(29,29,0),(29,30,1),(30,30,0),(31,31,0),(32,32,0),(33,33,0),(34,34,0),(35,35,0),(36,36,0),(37,37,0);
INSERT INTO `comments` VALUES (8,1,'Beer',NULL,'test',NULL,1,NULL,15,16,'2016-03-31 14:58:33','2016-03-31 14:58:33'),(9,1,'Beer',NULL,'This is another comment.',NULL,1,NULL,NULL,NULL,'2016-03-31 15:25:09','2016-03-31 15:25:09'),(10,1,'Beer',NULL,'And some more comments.',NULL,1,NULL,NULL,NULL,'2016-03-31 15:25:16','2016-03-31 15:25:16'),(11,1,'Beer',NULL,'reply to test?',NULL,1,8,NULL,NULL,'2016-03-31 15:42:32','2016-03-31 15:42:32'),(12,1,'Beer',NULL,'This is a reply.',NULL,1,9,NULL,NULL,'2016-03-31 15:43:40','2016-03-31 15:43:40'),(13,1,'Beer',NULL,'And some more replies.',NULL,1,10,NULL,NULL,'2016-03-31 15:44:52','2016-03-31 15:44:52'),(14,1,'Beer',NULL,'Second level reply?',NULL,1,12,NULL,NULL,'2016-03-31 15:47:50','2016-03-31 15:47:50'),(15,1,'Beer',NULL,'This is a root level comment.',NULL,1,NULL,NULL,NULL,'2016-03-31 15:49:28','2016-03-31 15:49:28'),(16,1,'Beer',NULL,'This is a second level comment.',NULL,1,15,NULL,NULL,'2016-03-31 15:49:46','2016-03-31 15:49:46'),(17,1,'Beer',NULL,'This is a third level comment.',NULL,1,16,NULL,NULL,'2016-03-31 15:49:54','2016-03-31 15:49:54'),(18,1,'Beer',NULL,'And a fourth level comment.',NULL,1,17,NULL,NULL,'2016-03-31 15:50:03','2016-03-31 15:50:03'),(19,1,'Beer',NULL,'Trying to setup counter caching.',NULL,1,NULL,NULL,NULL,'2016-03-31 20:08:43','2016-03-31 20:08:43'),(20,1,'Beer',NULL,'testing',NULL,1,NULL,NULL,NULL,'2016-03-31 20:12:15','2016-03-31 20:12:15'),(21,1,'Beer',NULL,'test',NULL,1,NULL,NULL,NULL,'2016-03-31 20:13:42','2016-03-31 20:13:42'),(22,1,'Beer',NULL,'testing again',NULL,1,NULL,NULL,NULL,'2016-03-31 20:17:25','2016-03-31 20:17:25'),(23,1,'Beer',NULL,'Testing my new counter method.',NULL,1,NULL,NULL,NULL,'2016-03-31 20:29:15','2016-03-31 20:29:15'),(24,1,'Beer',NULL,'Comment counter is working!',NULL,1,NULL,NULL,NULL,'2016-03-31 20:35:14','2016-03-31 20:35:14'),(25,1,'Beer',NULL,'Testing that replies still work.',NULL,1,22,NULL,NULL,'2016-03-31 20:35:46','2016-03-31 20:35:46'),(26,1,'Beer',NULL,'Posting a new comment.',NULL,1,NULL,NULL,NULL,'2016-03-31 20:39:40','2016-03-31 20:39:40'),(27,1,'Beer',NULL,'Posting a second new comment.',NULL,1,NULL,NULL,NULL,'2016-03-31 20:41:26','2016-03-31 20:41:26'),(28,1,'Beer',NULL,'do ray me so fal',NULL,1,NULL,NULL,NULL,'2016-03-31 20:43:21','2016-03-31 20:43:21'),(29,1,'Beer',NULL,'la tee do',NULL,1,NULL,NULL,NULL,'2016-03-31 20:44:29','2016-03-31 20:44:29'),(30,1,'Beer',NULL,'another reply',NULL,1,29,NULL,NULL,'2016-03-31 20:55:21','2016-03-31 20:55:21'),(31,1,'Beer',NULL,'<p>Does this even work?<br></p>',NULL,1,NULL,NULL,NULL,'2016-04-01 05:37:28','2016-04-01 05:37:28'),(32,1,'Beer',NULL,'<p>Ok, <b>testing</b> with <i>some</i> <u>formatting</u>.<br></p>',NULL,1,NULL,NULL,NULL,'2016-04-01 05:39:46','2016-04-01 05:39:46'),(33,1,'Beer',NULL,'<p>This is an :app<br></p>',NULL,1,NULL,NULL,NULL,'2016-04-01 16:03:56','2016-04-01 16:03:56'),(34,1,'Beer',NULL,'<p>A new comment.<br></p>',NULL,1,NULL,NULL,NULL,'2016-04-08 21:44:16','2016-04-08 21:44:16'),(35,2,'Beer',NULL,'<p>A new comment.<br></p>',NULL,1,NULL,NULL,NULL,'2016-04-08 21:44:16','2016-04-08 21:44:16'),(36,2,'Beer',NULL,'<p>Blah A new comment.<br></p>',NULL,1,NULL,NULL,NULL,'2016-04-08 21:44:16','2016-04-08 21:44:16'),(37,2,'Beer',NULL,'<p>Hello A new comment.<br></p>',NULL,1,NULL,NULL,NULL,'2016-04-08 21:44:16','2016-04-08 21:44:16');