test/dummy/db/test.sqlite3 in sequenced-1.4.0 vs test/dummy/db/test.sqlite3 in sequenced-1.5.0
- old
+ new
@@ -1,13 +1,13 @@
-SQLite format 3 @
-$ E[ NwtableordersordersCREATE TABLE "orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product" varchar(255), "account_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)y
+SQLite format 3 @ -% E[ NwtableordersordersCREATE TABLE "orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product" varchar(255), "account_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)y
Eindexindex_invoices_on_account_idinvoicesCREATE INDEX "index_invoices_on_account_id" ON "invoices" ("account_id")g !tableinvoicesinvoices
-CREATE TABLE "invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" integer, "sequential_id" integer, "account_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL);Itableaccountsaccounts CREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)~I%indexindex_answers_on_sequential_idanswersCREATE INDEX "index_answers_on_sequential_id" ON "answers" ("sequential_id")xEindexindex_answers_on_question_idanswersCREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id")`tableanswersanswersCREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer, "body" text, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)NktablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "summary" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT
: p^L: )20130715002029
+CREATE TABLE "invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" integer, "sequential_id" integer, "account_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL);Itableaccountsaccounts CREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)~I%indexindex_answers_on_sequential_idanswersCREATE INDEX "index_answers_on_sequential_id" ON "answers" ("sequential_id")xEindexindex_answers_on_question_idanswersCREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id")`tableanswersanswersCREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer, "body" text, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)NktablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "summary" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT
p^L:(
)20131226000000)20130730004055)20130715002029
)20130411225444 )20120220000804)20120219232323)20120219175744)20120219174931)20120219172922)20120219172039)20120219171957)20120219165548)20120219165346
- / {hUB/ )20130715002029)20130411225444
+
{hUB/ )20131226000000
)20130730004055)20130715002029)20130411225444
)20120220000804 )20120219232323)20120219175744)20120219174931)20120219172922)20120219172039)20120219171957)20120219165548)20120219165346
-
// % q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_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")NktablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "summary" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)`tableanswersanswersCREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer, "body" text, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)xEindexindex_answers_on_question_idanswersCREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id")~I%indexindex_answers_on_sequential_idanswersCREATE INDEX "index_answers_on_sequential_id" ON "answers" ("sequential_id");Itableaccountsaccounts CREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)g !tableinvoicesinvoices
+
) ) &I,&I % 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")NktablequestionsquestionsCREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "summary" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)`tableanswersanswersCREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer, "body" text, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)xEindexindex_answers_on_question_idanswersCREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id")~I%indexindex_answers_on_sequential_idanswersCREATE INDEX "index_answers_on_sequential_id" ON "answers" ("sequential_id");Itableaccountsaccounts CREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)g !tableinvoicesinvoices
CREATE TABLE "invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" integer, "sequential_id" integer, "account_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)y
-Eindexindex_invoices_on_account_idinvoicesCREATE INDEX "index_invoices_on_account_id" ON "invoices" ("account_id")NwtableordersordersCREATE TABLE "orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product" varchar(255), "account_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
zeO D @ ktableemailsemailsCREATE TABLE "emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "emailable_type" varchar(255), "emailable_id" integer, "sequential_id" integer, "address" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|G!indexindex_comments_on_question_idcommentsCREATE INDEX "indc''tablesubscriptionssubscriptions
CREATE TABLE "subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "plan" varchar(255), "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)h
/tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "name" varchar(255), "custom_sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id")TwtableaddressesaddressesCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "city" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)ctablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer, "body" text, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|G!indexindex_comments_on_question_idcommentsCREATE INDEX "index_comments_on_question_id" ON "comments" ("question_id")ktableemailsemailsCREATE TABLE "emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "emailable_type" varchar(255), "emailable_id" integer, "sequential_id" integer, "address" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)ctableratingsratingsCREATE TABLE "ratings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "comment_id" integer, "score" integer, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
+Eindexindex_invoices_on_account_idinvoicesCREATE INDEX "index_invoices_on_account_id" ON "invoices" ("account_id")NwtableordersordersCREATE TABLE "orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product" varchar(255), "account_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)c''tablesubscriptionssubscriptions
CREATE TABLE "subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "plan" varchar(255), "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
%`kQ) @ ktableemailsemailsCREATE TABLE "emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "emailable_type"