spec/dummy/db/development.sqlite3 in commontator-4.5.4 vs spec/dummy/db/development.sqlite3 in commontator-4.6.0

- old
+ new

@@ -1,14 +1,13 @@ -SQLite format 3@ -   3210 -321 0   - 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") +SQLite format 3@ -!  3210 +3210   + q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")355 tablecommontator_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_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)by5#indexindex_commontator_comments_on_c_id_and_c_type_and_t_idcommontator_commentsCREATE INDEX "index_commontator_comments_on_c_id_and_c_type_and_t_id" ON "commontator_comments" ("creator_id", "creator_type", "thread_id") + Q &[5Iindexindex_commontator_comments_on_thread_idcommontator_commentsCREATE INDEX "index_commontator_comments_on_thread_id" ON "commontator_comments" ("thread_id")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")0 ??otablecommontator_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, "created_at" datetime, "updated_at" datetime)  +  + 118/ +?Qindexindex_commontator_subscriptions_on_s_id_and_s_type_and_t_idcommontator_subscriptions CREATE UNIQUE INDEX "index_commontator_subscriptions_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)N e3indexindex_commontator_threads_on_c_id_and_c_typecommontator_threadsCREATE UNIQUE INDEX "index_commontator_threads_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)##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)    - -  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_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") - -  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) - - + pp2?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") \ No newline at end of file