spec/dummy/db/development.sqlite3 in ddr-models-1.3.0 vs spec/dummy/db/development.sqlite3 in ddr-models-1.4.0
- old
+ new
@@ -1,17 +1,16 @@
-SQLite format 3 @ -%
`s
-
-^ x" n;indexindex_users_on_usernameusersCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")SGindexindex_users_on_reset_password_tokenusersCREATE 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))![+Iindexindex_workflow_states_on_workflow_stateworkflow_statesCREATE INDEX "index_workflow_states_on_workflow_state" ON "workflow_states" ("workflow_state")
E++indexindex_workflow_states_on_pidworkflow_statesCREATE UNIQUE INDEX "index_workflow_states_on_pid" ON "workflow_states" ("pid")\++otableworkflow_statesworkflow_states
CREATE TABLE "workflow_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pid" varchar(255), "workflow_state" varchar(255), "created_at" datetime, "updated_at" datetime){E!indexindex_minted_ids_on_referentminted_idsCREATE INDEX "index_minted_ids_on_referent" ON "minted_ids" ("referent")
-G!/indexindex_minted_ids_on_minted_idminted_idsCREATE UNIQUE INDEX "index_minted_ids_on_minted_id" ON "minted_ids" ("minted_id")M !!etableminted_idsminted_ids
-CREATE TABLE "minted_ids" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "minted_id" varchar(255), "referent" varchar(255), "created_at" datetime, "updated_at" datetime)^5}indexindex_events_on_typeevents CREATE 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)NwtableeventseventsCREATE 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)=//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)
)20141107124012)20141104181418)20141103192146)20141021234156)20141021233359
- )20141107124012)20141104181418)20141103192146)20141021234156) 20141021233359
+SQLite format 3 @ -%
]
p
[
+ ,S< =//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_states" ("workflow_state")E++indexindex_workflow_states_on_pidworkflow_statesCREATE UNIQUE INDEX "index_workflow_states_on_pid" ON "workflow_states" ("pid")\++otableworkflow_statesworkflow_statesCREATE TABLE "workflow_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pid" varchar(255), "workflow_state" varchar(255), "created_at" datetime, "updated_at" datetime)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 "minted_ids" ("referent")G!/indexindex_minted_ids_on_minted_idminted_ids CREATE UNIQUE INDEX "index_minted_ids_on_minted_id" ON "minted_ids" ("minted_id")M!!etableminted_idsminted_idsCREATE TABLE "minted_ids" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "minted_id" varchar(255), "referent" varchar(255), "created_at" datetime, "updated_at" datetime)^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)NwtableeventseventsCREATE 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)
+
-
-
+
)20141104181418)20141103192146)20141021234156)20141021233359)20141107124012
+ )20141104181418)20141103192146)20141021234156)20141021233359) 20141107124012
\ No newline at end of file