spec/dummy/db/development.sqlite3 in commontator-4.2.1 vs spec/dummy/db/development.sqlite3 in commontator-4.2.2

- old
+ new

@@ -1,16 +1,14 @@ -SQLite format 3@ -!   3210 +SQLite format 3@ -!   3210 3210   - Fq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[55Ytablecommontator_commentscommontator_commentsCREATE TABLE "commontator_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "creator_type" varchar(255), "creator_id" integer, "editor_type" varchar(255), "editor_id" integer, "thread_id" integer NOT NULL, "body" text NOT NULL, "deleted_at" datetime, "cached_votes_total" integer DEFAULT 0, "cached_votes_up" integer DEFAULT 0, "cached_votes_down" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) TT?@W5indexindex_c_c_on_c_type_and_c_id_and_t_idcommontator_commentsCREATE INDEX "index_c_c_on_c_type_and_c_id_and_t_id" ON "commontator_comments" ("creator_type", "creator_id", "thread_id")&[5Iindexindex_commontator_comments_on_thread_idcommontator_comments CREATE INDEX "index_commontator_comments_on_thread_id" ON "commontator_comments" ("thread_id")Am5mindexindex_commontator_comments_on_cached_votes_totalcommontator_comments + Fq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[55Ytablecommontator_commentscommontator_commentsCREATE TABLE "commontator_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "creator_type" varchar(255), "creator_id" integer, "editor_type" varchar(255), "editor_id" integer, "thread_id" integer NOT NULL, "body" text NOT NULL, "deleted_at" datetime, "cached_votes_total" integer DEFAULT 0, "cached_votes_up" integer DEFAULT 0, "cached_votes_down" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) TT?@W5indexindex_c_c_on_c_id_and_c_type_and_t_idcommontator_commentsCREATE INDEX "index_c_c_on_c_id_and_c_type_and_t_id" ON "commontator_comments" ("creator_id", "creator_type", "thread_id")&[5Iindexindex_commontator_comments_on_thread_idcommontator_comments CREATE INDEX "index_commontator_comments_on_thread_id" ON "commontator_comments" ("thread_id")Am5mindexindex_commontator_comments_on_cached_votes_totalcommontator_comments CREATE INDEX "index_commontator_comments_on_cached_votes_total" ON "commontator_comments" ("cached_votes_total")8g5aindexindex_commontator_comments_on_cached_votes_upcommontator_comments CREATE INDEX "index_commontator_comments_on_cached_votes_up" ON "commontator_comments" ("cached_votes_up")> k5iindexindex_commontator_comments_on_cached_votes_downcommontator_comments CREATE INDEX "index_commontator_comments_on_cached_votes_down" ON "commontator_comments" ("cached_votes_down")      iCU -??9tablecommontator_subscriptionscommontator_subscriptions CREATE TABLE "commontator_subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subscriber_type" varchar(255) NOT NULL, "subscriber_id" integer NOT NULL, "thread_id" integer NOT NULL, "unread" integer DEFAULT 0 NOT NULL, "created_at" datetime, "updated_at" datetime)W W?%indexindex_c_s_on_s_type_and_s_id_and_t_idcommontator_subscriptionsCREATE UNIQUE INDEX "index_c_s_on_s_type_and_s_id_and_t_id" ON "commontator_subscriptions" ("subscriber_type", "subscriber_id", "thread_id"): e?]indexindex_commontator_subscriptions_on_thread_idcommontator_subscriptionsCREATE INDEX "index_commontator_subscriptions_on_thread_id" ON "commontator_subscriptions" ("thread_id") +??9tablecommontator_subscriptionscommontator_subscriptions CREATE TABLE "commontator_subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subscriber_type" varchar(255) NOT NULL, "subscriber_id" integer NOT NULL, "thread_id" integer NOT NULL, "unread" integer DEFAULT 0 NOT NULL, "created_at" datetime, "updated_at" datetime)W W?%indexindex_c_s_on_s_id_and_s_type_and_t_idcommontator_subscriptionsCREATE UNIQUE INDEX "index_c_s_on_s_id_and_s_type_and_t_id" ON "commontator_subscriptions" ("subscriber_id", "subscriber_type", "thread_id"): e?]indexindex_commontator_subscriptions_on_thread_idcommontator_subscriptionsCREATE INDEX "index_commontator_subscriptions_on_thread_id" ON "commontator_subscriptions" ("thread_id")  -   `7 33tablecommontator_threadscommontator_threadsCREATE TABLE "commontator_threads" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commontable_type" varchar(255), "commontable_id" integer, "closed_at" datetime, "closer_type" varchar(255), "closer_id" integer, "created_at" datetime, "updated_at" datetime).E3qindexindex_c_t_on_c_type_and_c_idcommontator_threadsCREATE UNIQUE INDEX "index_c_t_on_c_type_and_c_id" ON "commontator_threads" ("commontable_type", "commontable_id") %%tabledummy_modelsdummy_modelsCREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)##tabledummy_usersdummy_usersCREATE TABLE "dummy_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime) -    8p2tablevotesvotesCREATE TABLE "votes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "votable_id" integer, "votable_type" varchar(255), "voter_id" integer, "voter_type" varchar(255), "vote_flag" boolean, "vote_scope" varchar(255), "created_at" datetime, "updated_at" datetime)aSindexindex_votes_on_votable_id_and_votable_typevotesCREATE INDEX "index_votes_on_votable_id_and_votable_type" ON "votes" ("votable_id", "votable_type")YCindexindex_votes_on_voter_id_and_voter_typevotesCREATE INDEX "index_votes_on_voter_id_and_voter_type" ON "votes" ("voter_id", "voter_type")?w}indexindex_votes_on_voter_id_and_voter_type_and_vote_scopevotesCREATE INDEX "index_votes_on_voter_id_and_voter_type_and_vote_scope" ON "votes" ("voter_id", "voter_type", "vote_scope")K indexindex_votes_on_votable_id_and_votable_type_and_vote_scopevotesCREATE INDEX "index_votes_on_votable_id_and_votable_type_and_vote_scope" ON "votes" ("votable_id", "votable_type", "vote_scope") - - +  rr]7 33tablecommontator_threadscommontator_threadsCREATE TABLE "commontator_threads" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commontable_type" varchar(255), "commontable_id" integer, "closed_at" datetime, "closer_type" varchar(255), "closer_id" integer, "created_at" datetime, "updated_at" datetime).E3qindexindex_c_t_on_c_id_and_c_typecommontator_threadsCREATE UNIQUE INDEX "index_c_t_on_c_id_and_c_type" ON "commontator_threads" ("commontable_id", "commontable_type") %%tabledummy_modelsdummy_modelsCREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime) +    )gK indexindex_votes_on_votable_id_and_votable_type_and_vote_scopevotesCREATE INDEX "index_votes_on_votable_id_and_votable_type_and_vote_scope" ON "votes" ("votable_id", "votable_type", "vote_scope")?w}indexindex_votes_on_voter_id_and_voter_type_and_vote_scopevotesCREATE INDEX "index_votes_on_voter_id_and_voter_type_and_vote_scope" ON "votes" ("voter_id", "voter_type", "vote_scope")##tabledummy_usersdummy_usersCREATE TABLE "dummy_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)4GtablevotesvotesCREATE TABLE "votes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "votable_id" integer, "votable_type" varchar(255), "voter_id" integer, "voter_type" varchar(255), "vote_flag" boolean, "vote_scope" varchar(255), "vote_weight" integer, "created_at" datetime, "updated_at" datetime)   \ No newline at end of file