spec/dummy/db/test.sqlite3 in storytime-0.0.1 vs spec/dummy/db/test.sqlite3 in storytime-0.0.2

- old
+ new

@@ -1,36 +1,37 @@ -SQLite format 3@ W#W-% I - ^O-b6i+eindexindex_storytime_sites_on_selected_root_page_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_selected_root_page_id" ON "storytime_sites" ("selected_root_page_id")i++ tablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_tracking_id" varchar(255), "root_page_content" integer DEFAULT 0, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime, "selected_root_page_id" integer)>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id")!++ytablestorytime_postsstorytime_postsCREATE TABLE "storytime_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "content" text, "excerpt" text, "published" boolean, "post_type" varchar(255), "created_at" datetime, "updated_at" datetime)$Y7Eindexindex_storytime_permissions_on_role_idstorytime_permissionsCREATE INDEX "index_storytime_permissions_on_role_id" ON "storytime_permissions" ("role_id")* ]7Mindexindex_storytime_permissions_on_action_idstorytime_permissionsCREATE INDEX "index_storytime_permissions_on_action_id" ON "storytime_permissions" ("action_id")c 77etablestorytime_permissionsstorytime_permissions CREATE TABLE "storytime_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "role_id" integer, "action_id" integer, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_pages_on_user_idstorytime_pages CREATE INDEX "index_storytime_pages_on_user_id" ON "storytime_pages" ("user_id") -++Otablestorytime_pagesstorytime_pages CREATE TABLE "storytime_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "slug" varchar(255), "content" text, "published" boolean, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_media_on_user_idstorytime_media -CREATE INDEX "index_storytime_media_on_user_id" ON "storytime_media" ("user_id")Q++Ytablestorytime_mediastorytime_media CREATE TABLE "storytime_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar(255), "user_id" integer, "created_at" datetime, "updated_at" datetime)Y//atablestorytime_actionsstorytime_actionsCREATE TABLE "storytime_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "guid" varchar(255), "created_at" datetime, "updated_at" datetime))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) //Etablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255) NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar(255), "created_at" date  7storytime_permissions#/storytime_actions+storytime_roles +SQLite format 3@ *&L*-% I + ^x$3=W+Aindexindex_storytime_sites_on_root_post_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_root_post_id" ON "storytime_sites" ("root_post_id")`++wtablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_tracking_id" varchar(255), "root_page_content" integer DEFAULT 0, "root_post_id" integer, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime)>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id")W+Aindexindex_storytime_posts_on_post_type_idstorytime_postsCREATE INDEX "index_storytime_posts_on_post_type_id" ON "storytime_posts" ("post_type_id")U++atablestorytime_postsstorytime_postsCREATE TABLE "storytime_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "slug" varchar(255), "content" text, "excerpt" text, "published_at" datetime, "post_type_id" integer, "featured_media_id" integer, "created_at" datetime, "updated_at" datetime)n 55tablestorytime_post_typesstorytime_post_typesCREATE TABLE "storytime_post_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permanent" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime)$ Y7Eindexindex_storytime_permissions_on_role_idstorytime_permissions CREATE INDEX "index_storytime_permissions_on_role_id" ON "storytime_permissions" ("role_id")* ]7Mindexindex_storytime_permissions_on_action_idstorytime_permissions CREATE INDEX "index_storytime_permissions_on_action_id" ON "storytime_permissions" ("action_id")c +77etablestorytime_permissionsstorytime_permissions CREATE TABLE "storytime_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "role_id" integer, "action_id" integer, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_media_on_user_idstorytime_media +CREATE INDEX "index_storytime_media_on_user_id" ON "storytime_media" ("user_id")Q++Ytablestorytime_mediastorytime_media CREATE TABLE "storytime_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar(255), "user_id" integer, "created_at" datetime, "updated_at" datetime)Y//atablestorytime_actionsstorytime_actionsCREATE TABLE "storytime_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "guid" varchar(255), "created_at" datetime, "updated_at" datetime))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) //Etablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255) NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar(255), "created_at" date. RR8h+Apost-58hStorytime::Post2014-08-13 20:37:03.7949658g+Apost-57gStorytime::Post2014-08-13 20:37:03.776170:+Apost-56fStorytime::Post2014-08-13 20:37:03.753806 Q !{<f +storytime_sites 1storytime_comments +5storytime_post_types]+storytime_media2storytime_postsg+storytime_postsh +users`+storytime_roles 1storytime_versionsh +/friendly_id_slugsh7storytime_permissions/storytime_actionsT ++post-58Storytime::Posth+post-57Storytime::Postgpost-56Storytime::Postf ++post-58Storytime::Posth+post-57Storytime::Postgpost-56Storytime::Postf +hhggff ++Storytime::Posth+Storytime::PostgStorytime::Postf BLT%AAManage Users1f7d472014-08-13 20:37:03.5479632014-08-13 20:37:03.547963TS5AAManage Site Settings47342a2014-08-13 20:37:03.5447352014-08-13 20:37:03.544735WR;AAPublish Own Posts/Pages5030ed2014-08-13 20:37:03.5413282014-08-13 20:37:03.541328aQOAAManage Other People's Posts/Pagesd8a1b12014-08-13 20:37:03.5368012014-08-13 20:37:03.536801 K2+AAsuccess-kid.jpgP2014-08-13 20:36:48.6287172014-08-13 20:36:48.628717 + P2 ~=z9>AAT2014-08-13 20:37:03.5689112014-08-13 20:37:03.568911>AAS2014-08-13 20:37:03.5664342014-08-13 20:37:03.566434>AAQ2014-08-13 20:37:03.5641942014-08-13 20:37:03.564194>AAQ2014-08-13 20:37:03.5619582014-08-13 20:37:03.561958>AAR2014-08-13 20:37:03.5595492014-08-13 20:37:03.559549>AAR2014-08-13 20:37:03.5572242014-08-13 20:37:03.557224> AAR2014-08-13 20:37:03.5546832014-08-13 20:37:03.554683 +TSQQRRR + |GW%AAPost Type #7f2014-08-13 20:36:56.4168432014-08-13 20:36:56.416843GV%AAPost Type #6f2014-08-13 20:36:56.4141992014-08-13 20:36:56.414199GU%AAPost Type #5f2014-08-13 20:36:56.4104672014-08-13 20:36:56.410467?]AApaget2014-08-13 20:37:03.5242792014-08-13 20:37:03.524279?\AAblogt2014-08-13 20:37:03.5198352014-08-13 20:37:03.519835 j Hh q_AAA`Post #58post-58Post #53. It was a dark and stormy night. The End.Post #58. It was a dark and stormy night.2014-08-13 20:37:03.785062\2014-08-13 20:37:03.7884492014-08-13 20:37:03.788449Hg q_AAA_Post #57post-57Post #52. It was a dark and stormy night. The End.Post #57. It was a dark and stormy night.2014-08-13 20:37:03.762798\2014-08-13 20:37:03.7661502014-08-13 20:37:03.766150q_AAA^Post #56post-56Post #51. It was a dark and stormy night. The End.Post #56. It was a dark and stormy night.2014-08-13 20:37:03.741591\2014-08-13 20:37:03.7459562014-08-13 20:37:03.745956 +\h\g\f +`h_g^f |;>?AAadmin2014-08-13 20:37:03.5330662014-08-13 20:37:03.533066?>AAeditor2014-08-13 20:37:03.5305852014-08-13 20:37:03.530585?=AAwriter2014-08-13 20:37:03.5278232014-08-13 20:37:03.527823 bL 'AASite Title 302014-08-13 20:37:01.0601122014-08-13 20:37:01.060112L 'AASite Title 382014-08-13 20:37:03.5779272014-08-13 20:37:03.577927 +  @@N | +P + r  +bW+AW+Aindexindex_storytime_sites_on_root_post_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_root_post_id" ON "storytime_sites" ("root_post_id")`++wtablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_trackP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)855tablestorytime_post_typesstorytime_post_typesCREATE TABLE "storytime_post_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)q//tableschema_migrationsschema_migrations"CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) =//indexunique_schema_migrationsschema_migrations#CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") !//Etablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255) NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar(255), "created_at" datetime)h"/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")C#q/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")#$[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id"))%_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")Y&//atablestorytime_actionsstorytime_actionsCREATE TABLE "storytime_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "guid" varchar(255), "created_at" datetime, "updated_at" datetime)Q'++Ytablestorytime_mediastorytime_media CREATE TABLE "storytime_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar(255), "user_id" integer, "created_at" datetime, "updated_at" datetime) (M+-indexindex_storytime_media_on_user_idstorytime_media +CREATE INDEX "index_storytime_media_on_user_id" ON "storytime_media" ("user_id")c)77etablestorytime_permissionsstorytime_permissions CREATE TABLE "storytime_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "role_id" integer, "action_id" integer, "created_at" datetime, "updated_at" datetime)**]7Mindexindex_storytime_permissions_on_action_idstorytime_permissions CREATE INDEX "index_storytime_permissions_on_action_id" ON "storytime_permissions" ("action_id")$+Y7Eindexindex_storytime_permissions_on_role_idstorytime_permissions CREATE INDEX "index_storytime_permissions_on_role_id" ON "storytime_permissions" ("role_id")n,55tablestorytime_post_typesstorytime_post_typesCREATE TABLE "storytime_post_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permanent" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime)U-++atablestorytime_postsstorytime_postsCREATE TABLE "storytime_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "slug" varchar(255), "content" text, "excerpt" text, "published_at" datetime, "post_type_id" integer, "featured_media_id" integer, "created_at" datetime, "updated_at" datetime).W+Aindexindex_storytime_posts_on_post_type_idstorytime_postsCREATE INDEX "index_storytime_posts_on_post_type_id" ON "storytime_posts" ("post_type_id") q M : + 6=#8::StableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "storytime_role_id" integer, "storytime_name" varchar(255))@S19indexindex_storytime_comments_on_post_idstorytime_comments&CREATE INDEX "index_storytime_comments_on_post_id" ON "storytime_comments" ("post_id")?S19indexindex_storytime_comments_on_user_idstorytime_comments%CREATE INDEX "index_storytime_comments_on_user_id" ON "storytime_comments" ("user_id")h>11{tablestorytime_commentsstorytime_comments$CREATE TABLE "storytime_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)=M-indexindex_users_on_storytime_role_idusers!CREATE INDEX "index_users_on_storytime_role_id" ON "users" ("storytime_role_id")<SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e;5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")9/1Kindexversionable_indexstorytime_versionsCREATE INDEX "versionable_index" ON "storytime_versions" ("versionable_type", "versionable_id")8S19indexindex_storytime_versions_on_user_idstorytime_versionsCREATE INDEX "index_storytime_versions_on_user_id" ON "storytime_versions" ("user_id")711Ktablestorytime_versionsstorytime_versionsCREATE TABLE "storytime_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "versionable_id" integer, "versionable_type" varchar(255), "created_at" datetime, "updated_at" datetime);6))1tablestorytime_tagsstorytime_tagsCREATE TABLE "storytime_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)5Q15indexindex_storytime_taggings_on_tag_idstorytime_taggingsCREATE INDEX "index_storytime_taggings_on_tag_id" ON "storytime_taggings" ("tag_id")4S19indexindex_storytime_taggings_on_post_idstorytime_taggingsCREATE INDEX "index_storytime_taggings_on_post_id" ON "storytime_taggings" ("post_id")W311Ytablestorytime_taggingsstorytime_taggingsCREATE TABLE "storytime_taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)2W+Aindexindex_storytime_sites_on_root_post_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_root_post_id" ON "storytime_sites" ("root_post_id")`1++wtablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_tracking_id" varchar(255), "root_page_content" integer DEFAULT 0, "root_post_id" integer, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime)>0++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) /M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id")  - - - DL%AAManage Users1f7d472014-05-27 01:24:34.8478722014-05-27 01:24:34.847872T5AAManage Site Settings47342a2014-05-27 01:24:34.8453322014-05-27 01:24:34.845332W;AAPublish Own Posts/Pages5030ed2014-05-27 01:24:34.8425672014-05-27 01:24:34.842567aOAAManage Other People's Posts/Pagesd8a1b12014-05-27 01:24:34.8396052014-05-27 01:24:34.839605  -  - #G -Q [  e ' o 1 - - -x -: D N<#AA2014-05-27 01:41:14.8052822014-05-27 01:41:14.805282<"AA2014-05-27 01:41:14.8024012014-05-27 01:41:14.802401;! AA2014-05-27 01:41:14.8003762014-05-27 01:41:14.800376;  AA2014-05-27 01:41:14.7984242014-05-27 01:41:14.798424<AA2014-05-27 01:41:14.7959202014-05-27 01:41:14.795920<AA2014-05-27 01:41:14.7937722014-05-27 01:41:14.793772; AA2014-05-27 01:41:14.7856942014-05-27 01:41:14.785694<AA2014-05-27 01:35:18.1414642014-05-27 01:35:18.141464<AA2014-05-27 01:35:18.1380392014-05-27 01:35:18.138039; AA2014-05-27 01:35:18.1341522014-05-27 01:35:18.134152; AA2014-05-27 01:35:18.1315592014-05-27 01:35:18.131559<AA2014-05-27 01:35:18.1293532014-05-27 01:35:18.129353<AA2014-05-27 01:35:18.1271312014-05-27 01:35:18.127131; AA2014-05-27 01:35:18.1179102014-05-27 01:35:18.117910<AA2014-05-27 01:34:31.6564272014-05-27 01:34:31.656427<AA2014-05-27 01:34:31.6532542014-05-27 01:34:31.653254; AA2014-05-27 01:34:31.6511472014-05-27 01:34:31.651147; AA2014-05-27 01:34:31.6489802014-05-27 01:34:31.648980<AA2014-05-27 01:34:31.6468992014-05-27 01:34:31.646899<AA2014-05-27 01:34:31.6448212014-05-27 01:34:31.644821; AA2014-05-27 01:34:31.6364882014-05-27 01:34:31.636488<AA2014-05-27 01:26:20.5523252014-05-27 01:26:20.552325< AA2014-05-27 01:26:20.5500292014-05-27 01:26:20.550029;  AA2014-05-27 01:26:20.5475002014-05-27 01:26:20.547500;  AA2014-05-27 01:26:20.5456182014-05-27 01:26:20.545618< -AA2014-05-27 01:26:20.5435872014-05-27 01:26:20.543587< AA2014-05-27 01:26:20.5414952014-05-27 01:26:20.541495; AA2014-05-27 01:26:20.5338232014-05-27 01:26:20.533823<AA2014-05-27 01:24:34.8789212014-05-27 01:24:34.878921<AA2014-05-27 01:24:34.8763532014-05-27 01:24:34.876353; AA2014-05-27 01:24:34.8743512014-05-27 01:24:34.874351; AA2014-05-27 01:24:34.8723192014-05-27 01:24:34.872319<AA2014-05-27 01:24:34.8702422014-05-27 01:24:34.870242<AA2014-05-27 01:24:34.8680762014-05-27 01:24:34.868076; AA2014-05-27 01:24:34.8633062014-05-27 01:24:34.863306 -#9rmJE}w[UOg?a9#" !            -     -#4X{oRFuic]L@:4#"!        -    - >~>>AAadmin2014-05-27 01:24:34.8328972014-05-27 01:24:34.832897?AAeditor2014-05-27 01:24:34.8305912014-05-27 01:24:34.830591?AAwriter2014-05-27 01:24:34.8238812014-05-27 01:24:34.823881  -  36  -u  Mq6i+6i+eindexindex_storytime_sites_on_selected_root_page_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_selected_root_page_id" ON "storytime_sites" ("selected_root_page_id")i++ tablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_tracking_id" varchar(255), "root_page_content" integer DEFAULT 0, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime, "selected_root_page_id" integer)>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) //Etablefriendly_id_slugsfriendly_id_slugsCREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255) NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar(255), "created_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)h/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")Cq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id"))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")Y//atablestorytime_actionsstorytime_actionsCREATE TABLE "storytime_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "guid" varchar(255), "created_at" datetime, "updated_at" datetime)Q++Ytablestorytime_mediastorytime_media CREATE TABLE "storytime_media" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar(255), "user_id" integer, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_media_on_user_idstorytime_media -CREATE INDEX "index_storytime_media_on_user_id" ON "storytime_media" ("user_id") -++Otablestorytime_pagesstorytime_pages CREATE TABLE "storytime_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "slug" varchar(255), "content" text, "published" boolean, "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_pages_on_user_idstorytime_pages CREATE INDEX "index_storytime_pages_on_user_id" ON "storytime_pages" ("user_id")c 77etablestorytime_permissionsstorytime_permissions CREATE TABLE "storytime_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "role_id" integer, "action_id" integer, "created_at" datetime, "updated_at" datetime)* ]7Mindexindex_storytime_permissions_on_action_idstorytime_permissionsCREATE INDEX "index_storytime_permissions_on_action_id" ON "storytime_permissions" ("action_id")$Y7Eindexindex_storytime_permissions_on_role_idstorytime_permissionsCREATE INDEX "index_storytime_permissions_on_role_id" ON "storytime_permissions" ("role_id")!++ytablestorytime_postsstorytime_postsCREATE TABLE "storytime_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "title" varchar(255), "content" text, "excerpt" text, "published" boolean, "post_type" varchar(255), "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_posts_on_user_idstorytime_postsCREATE INDEX "index_storytime_posts_on_user_id" ON "storytime_posts" ("user_id") .\ t 1 nAS19indexindex_storytime_versions_on_user_idstorytime_versions CREATE INDEX "index_storytime_versions_on_user_id" ON "storytime_versions" ("user_id")11Ktablestorytime_versionsstorytime_versionsCREATE TABLE "storytime_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "versionable_id" integer, "versionable_type" varchar(255), "created_at" datetime, "updated_at" datetime) M+-indexindex_storytime_users_on_role_idstorytime_usersCREATE INDEX "index_storytime_users_on_role_id" ON "storytime_users" ("role_id"):g+oindexindex_storytime_us =//indexunique_schema_migrationsschema_migrations#CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrations"CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)>++3tablestorytime_rolesstorytime_rolesCREATE TABLE "storytime_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)i++ tablestorytime_sitesstorytime_sitesCREATE TABLE "storytime_sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "post_slug_style" integer DEFAULT 0, "ga_tracking_id" varchar(255), "root_page_content" integer DEFAULT 0, "header" text, "footer" text, "created_at" datetime, "updated_at" datetime, "selected_root_page_id" integer)6i+eindexindex_storytime_sites_on_selected_root_page_idstorytime_sitesCREATE INDEX "index_storytime_sites_on_selected_root_page_id" ON "storytime_sites" ("selected_root_page_id")W11Ytablestorytime_taggingsstorytime_taggingsCREATE TABLE "storytime_taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)S19indexindex_storytime_taggings_on_post_idstorytime_taggingsCREATE INDEX "index_storytime_taggings_on_post_id" ON "storytime_taggings" ("post_id")Q15indexindex_storytime_taggings_on_tag_idstorytime_taggingsCREATE INDEX "index_storytime_taggings_on_tag_id" ON "storytime_taggings" ("tag_id");))1tablestorytime_tagsstorytime_tagsCREATE TABLE "storytime_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)/++tablestorytime_usersstorytime_usersCREATE TABLE "storytime_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "role_id" integer) I+3indexindex_storytime_users_on_emailstorytime_usersCREATE UNIQUE INDEX "index_storytime_users_on_email" ON "storytime_users" ("email"):g+oindexindex_storytime_users_on_reset_password_tokenstorytime_usersCREATE UNIQUE INDEX "index_storytime_users_on_reset_password_token" ON "storytime_users" ("reset_password_token") M+-indexindex_storytime_users_on_role_idstorytime_usersCREATE INDEX "index_storytime_users_on_role_id" ON "storytime_users" ("role_id")11Ktablestorytime_versionsstorytime_versionsCREATE TABLE "storytime_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "versionable_id" integer, "versionable_type" varchar(255), "created_at" datetime, "updated_at" datetime)S19indexindex_storytime_versions_on_user_idstorytime_versions CREATE INDEX "index_storytime_versions_on_user_id" ON "storytime_versions" ("user_id")/1Kindexversionable_indexstorytime_versions!CREATE INDEX "versionable_index" ON "storytime_versions" ("versionable_type", "versionable_id") - -   - - -  - - p^L:()20140521191728 )20140521191048 )20140521190606 )20140516141252 -)20140514200304 )20140514200234)20140513162745)20140513161233)20140511200849)20140509191309)20140509150223)20140501174341)20140501171949)20140521191744 -|iVC0 -)20140521191728)20140521191048 )20140521190606 )20140516141252 )20140514200304 -)20140514200234 )20140513162745)20140513161233)20140511200849)20140509191309)20140509150223)20140501174341)20140501171949) 20140521191744 +  ~hq+AAPost #53. It was a dark and stormy night. The End.hStorytime::Post2014-08-13 20:37:03.7911832014-08-13 20:37:03.791183~gq+AAPost #52. It was a dark and stormy night. The End.gStorytime::Post2014-08-13 20:37:03.7698272014-08-13 20:37:03.769827q+AAPost #51. It was a dark and stormy night. The End.fStorytime::Post2014-08-13 20:37:03.7487622014-08-13 20:37:03.748762 +hgf ++Storytime::Posthh+Storytime::PostggStorytime::Postff n $!`3AA'user123@example.com$2a$04$SmIQP4KuL2KuG7KoQ4QA8uhY3vu/HPQhmiTcamwMlz1y03Q8Otjhe2014-08-13 20:37:03.7822612014-08-13 20:37:03.782261user name 123!_3AA'user122@example.com$2a$04$Bo4OMr0K3dA59MoQDBBAnu.iw1XuOvEpk.mnFpjJVE1kw8eNpqgA62014-08-13 20:37:03.7600792014-08-13 20:37:03.760079user name 122!^3AA'user121@example.com$2a$04$6tKJs3/HquhndthftKjMCOTp1scuBolFverlsmvWS6LSSS/ZRblJi2014-08-13 20:37:03.7387072014-08-13 20:37:03.738707user name 121i]3 AAAA'user120@example.com$2a$04$bPPpVEj4rWN.wBFEW8pNYup8M3I8XvuzxkdPdRhpHqic4f2h/0yPS2014-08-13 20:37:03.6418362014-08-13 20:37:03.641836127.0.0.1127.0.0.12014-08-13 20:37:03.5748142014-08-13 20:37:03.642904user name 120 +3user123@example.com`3user122@example.com_3user121@example.com^3user120@example.com] +`_^] +`_^] p^L:()20140813130534)20140813014447 )20140521191744 )20140521191728 )20140521191048 +)20140521190606 )20140516141252)20140514200304)20140514200234)20140513161233)20140511200849)20140509191309)20140501174341)20140530185250)20140714015418 +|iVC0 +)20140813130534)20140813014447)20140521191744 )20140521191728 )20140521191048 )20140521190606 +)20140516141252 )20140514200304)20140514200234)20140513161233)20140511200849)20140509191309)20140501174341)20140530185250) 20140714015418 jK#AAComment #14Ze2014-08-13 20:37:01.2567192014-08-13 20:37:01.256719I #AAComment #13\e2014-08-13 20:37:01.2537762014-08-13 20:37:01.253776 +Z +\ +e +e \ No newline at end of file