test/dummy/db/test.sqlite3 in sequenced-1.0.0 vs test/dummy/db/test.sqlite3 in sequenced-1.2.0
- old
+ new
@@ -1,11 +1,16 @@
-SQLite format 3 @ ) & q //tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)c
+SQLite format 3 @ -$ ) & q //tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar(255) 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)N ktablequestionsquestions
CREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "summary" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Nwtableordersorders 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)yE indexindex_invoices_on_account_idinvoicesCREATE INDEX "index_invoices_on_account_id" ON "invoices" ("account_id")g !tableinvoicesinvoicesCREATE 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)~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); ItableaccountsaccountsCREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT
-
^ p^ )20120220000804)20120219232323)20120219175744)20120219172922)20120219172039)20120219171957)20120219165548)20120219165346)20120219174931
- U {hU )20120220000804 )20120219232323)20120219175744)20120219172922)20120219172039)20120219171957)20120219165548)20120219165346)20120219174931
J/L v % ; ItableaccountsaccountsCREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "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; ItableaccountsaccountsCREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "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")g !tableinvoicesinvoicesCREATE 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)yE indexindex_invoices_on_account_idinvoicesCREATE INDEX "index_invoices_on_account_id" ON "invoices" ("account_id")Nwtableordersorders 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)
a25 |G !indexindex_comments_on_question_idcommentsCREATE INDEX "index_comments_on_question_id" ON "comments" ("question_id")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)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)m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id")N ktablequestionsquestions
+
+L p^L
+)20130411225444 )20120220000804)20120219232323)20120219175744)20120219172922)20120219172039)20120219171957)20120219165548)20120219165346)20120219174931
+
+B {hUB )20130411225444
+)20120220000804 )20120219232323)20120219175744)20120219172922)20120219172039)20120219171957)20120219165548)20120219165346)20120219174931
J/L v % ; ItableaccountsaccountsCREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "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; ItableaccountsaccountsCREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "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")g !tableinvoicesinvoicesCREATE 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)yE indexindex_invoices_on_account_idinvoicesCREATE INDEX "index_invoices_on_account_id" ON "invoices" ("account_id")Nwtableordersorders 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)
+ a25 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 "index_comments_on_question_id" ON "comments" ("question_id")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)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)m?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id")N ktablequestionsquestions
CREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "summary" varchar(255), "body" text, "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)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")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)
-
+
\ No newline at end of file