Skip to content

Instantly share code, notes, and snippets.

View blimey85's full-sized avatar

Gary Traffanstedt blimey85

  • Shit So Fancy
  • Orlando, FL
View GitHub Profile
@blimey85
blimey85 / sample_data.sql
Created April 10, 2016 05:39
Sampel data for beers app.
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 te
@blimey85
blimey85 / schema.rb
Created April 10, 2016 05:34
Beers sample app db schema
ActiveRecord::Schema.define(version: 20160331201031) do
create_table "beers", force: :cascade do |t|
t.string "name", limit: 255
t.text "description", limit: 65535
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "comments_count", limit: 4, default: 0, null: false
end