spec/dummy/db/development.sqlite3 in ddr-models-1.16.1 vs spec/dummy/db/development.sqlite3 in ddr-models-1.16.2
- old
+ new
@@ -1,16 +1,18 @@
-SQLite format 3 @
- -%
8]
p
,< =//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [+Iindexindex_workflow_states_on_workflow_stateworkflow_statesCREATE INDEX "index_workflow_states_on_workflow_state" ON "workflow]tableeventseventsCREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_date_time" datetime, "user_id" integer, "type" varchar(255), "pid" varchar(255), "software" varchar(255), "comment" text, "created_at" datetime, "updated_at" datetime, "summary" varchar(255), "outcome" varchar(255), "detail" text, "exception" varchar(255), "user_key" varchar(255))n
;indexindex_users_on_usernameusersCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")SGindexindex_users_on_reset_password_tokenusers
CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")]5}indexindex_users_on_emailusersCREATE INDEX "index_users_on_email" ON "users" ("email");
-UtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "username" varchar(255) DEFAULT '' NOT NULL, "first_name" varchar(255), "middle_name" varchar(255), "nickname" varchar(255), "last_name" varchar(255), "display_name" varchar(255))E!indexindex_minted_ids_on_referentminted_ids
-CREATE INDEX "index_minted_ids_on_referent" ON "mintek+tableeventseventsCREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_date_time" datetime, "user_id" integer, "type" varchar(255), "pid" varchar(255), "software" varchar(255), "comment" text, "created_at" datetime, "updated_at" datetime, "summary" varchar(255), "outcome" varchar(255), "detail" text, "exception" varchar(255))^5}indexindex_events_on_typeeventsCREATE INDEX "index_events_on_type" ON "events" ("type")[3yindexindex_events_on_pideventsCREATE INDEX "index_events_on_pid" ON "events" ("pid")h; indexindex_events_on_outcomeeventsCREATE INDEX "index_events_on_outcome" ON "events" ("outcome") K)indexindex_events_on_event_date_timeeventsCREATE INDEX "index_events_on_event_date_time" ON "events" ("event_date_time")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) QwtableeventseventsCREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_date_time" datetime, "user_id" integer, "type" varchar(255), "pid" varchar(255), "software" varchar(255), "comment" text, "created_at" datetime, "updated_at" datetime, "summary" varchar(255), "outcome" varchar(255), "detail" text)
+SQLite format 3 @
+ ! -%
] ,<9
6 =//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
+ [+ K)indexindex_events_on_event_date_timeeventsCREATE INDEX "index_events_on_event_date_time" ON "events" ("event_date_time") [tableeventseventsCREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_date_time" datetime, "user_id" integer, "type" varchar(255), "pid" varchar(255), "software" varchar(255), "comment" text, "created_at" datetime, "updated_at" datetime, "summary" varchar(255), "outcome" varchar(255), "detail" text, "exception" text(65535), "user_key" varchar(255))n
;indexindex_users_on_usernameusersCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")SGindexindex_users_on_reset_password_tokenusers
CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")]5}indexindex_users_on_emailusersCREATE INDEX "index_users_on_email" ON "users" ("email");
+UtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "username" varchar(255) DEFAULT '' NOT NULL, "first_name" varchar(255), "middle_name" varchar(255), "nickname" varchar(255), "last_name" varchar(255), "display_name" varchar(255))XE!indexindex_minted_ids_on_referentminted_ids
+CREATE INDEX "index_minted_ids_on_referent" ON "mintek+tableeventseventsCREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_date_time" datetime, "user_id" integer, "type" varchar(255), "pid" varchar(255), "software" varchar(255), "comment" text, "created_at" datetime, "updated_at" datetime, "summary" varchar(255), "outcome" varchar(255), "detail" text, "exception" varchar(255))
`5}indexindex_events_on_typeeventsCREATE INDEX "index_events_on_type" ON "events" ("type")J3yindexindex_events_on_pideve^5}indexindex_events_on_typeeventsCREATE INDEX "index_events_on_type" ON "events" ("type")[3yindexindex_events_on_pideventsCREATE INDEX "index_events_on_pid" ON "events" ("pid")h; indexindex_events_on_outcomeeventsCREATE INDEX "index_events_on_outcome" ON "events" ("outcome")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) QwtableeventseventsCREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_date_time" datetime, "user_id" integer, "type" varchar(255), "pid" varchar(255), "software" varchar(255), "comment" text, "created_at" datetime, "updated_at" datetime, "summary" varchar(255), "outcome" varchar(255), "detail" text)
-
+
-
^ p^ )20150130134416)20150110023410)20141218020612)20141216040225)20141104181418)20141103192146)20141021234156)20141021233359)20141107124012
- V |iV )20150130134416 )20150110023410)20141218020612)20141216040225)20141104181418)20141103192146)20141021234156)20141021233359) 20141107124012
+
: p^L: )20150713171838
+)20150710211530 )20150130134416)20150110023410)20141218020612)20141216040225)20141104181418)20141103192146)20141021234156)20141021233359)20141107124012
+ 0 |iVC0 )20150713171838)20150710211530
+)20150130134416 )20150110023410)20141218020612)20141216040225)20141104181418)20141103192146)20141021234156)20141021233359) 20141107124012
\ No newline at end of file