test/dummy/db/test.sqlite3 in sequenced-2.0.0 vs test/dummy/db/test.sqlite3 in sequenced-3.0.0
- old
+ new
@@ -1,13 +1,14 @@
-SQLite format 3 @ -% E[ N wtableordersorders CREATE 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[ N wtableordersorders CREATE 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
E indexindex_invoices_on_account_idinvoices CREATE 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")xE indexindex_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)N ktablequestionsquestionsCREATE 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)
p^L:( )20140404195334
)20131226000000 )20130730004055 )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")xE indexindex_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)N ktablequestionsquestionsCREATE 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)
p^L:( )20151120190645)20140404195334
)20131226000000 )20130730004055 )20130715002029
)20130411225444 )20120220000804)20120219232323)20120219175744)20120219174931)20120219172922)20120219172039)20120219171957)20120219165548)20120219165346
- {hUB/ )20140404195334)20131226000000
)20130730004055 )20130715002029 )20130411225444
+ {hUB/ )20151120190645)20140404195334)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")N ktablequestionsquestionsCREATE 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)xE indexindex_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
E indexindex_invoices_on_account_idinvoices CREATE INDEX "index_invoices_on_account_id" ON "invoices" ("account_id")N wtableordersorders CREATE 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)
z z`KwQ) @ ktableemailsemailsCREATE TABLE "emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "emailable_type" U }t 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")T wtableaddressesaddressesCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY 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)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")T wtableaddressesaddressesCREATE 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)c tablecommentscommentsCREATE 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)
-
d; c tableratingsratingsCREATE 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)U }tableproductsproductsCREATE TABLE "products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)T {tablemonstersmonstersCREATE TABLE "monsters" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sequential_id" integer, "type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)B StablepolicemenpolicemenCREATE TABLE "policemen" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
+
W d;W /1Iindexunique_concurrentconcurrent_badgers CREATE UNIQUE INDEX "unique_concurrent" ON "concurrent_badgers" ("sequential_id", "burrow_id");11!tableconcurrent_badgersconcurrent_badgersCREATE TABLE "concurrent_badgers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sequential_id" integer NOT NULL, "burrow_id" integer)c tableratingsratingsCREATE 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)U }tableproductsproductsCREATE TABLE "products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)T {tablemonstersmonstersCREATE TABLE "monsters" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sequential_id" integer, "type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)B StablepolicemenpolicemenCREATE TABLE "policemen" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sequential_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
+
\ No newline at end of file