spec/test_app/db/test.sqlite3 in notifiable-rails-0.13.0 vs spec/test_app/db/test.sqlite3 in notifiable-rails-0.14.0
- old
+ new
@@ -1,7 +1,7 @@
SQLite format 3 @
- -%
y'
P ;
- n O 33Etablenotifiable_statusesnotifiable_statuses CREATE TABLE "notifiable_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "notification_id" integer, "device_token_id" integer, "status" integer)c
+ -%
y'
P ;
+ n f 33stablenotifiable_statusesnotifiable_statuses CREATE TABLE "notifiable_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "notification_id" integer, "device_token_id" integer, "status" integer, "created_at" datetime)c
==Ytablenotifiable_notificationsnotifiable_notifications CREATE TABLE "notifiable_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "message" text, "params" text, "app_id" integer, "sent_count" integer DEFAULT 0, "gateway_accepted_count" integer DEFAULT 0, "opened_count" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime)0 _=Qindexindex_notifiable_device_tokens_on_user_idnotifiable_device_tokens
CREATE INDEX "index_notifiable_device_tokens_on_user_id" ON "notifiable_device_tokens" ("user_id")1[=Windexindex_notifiable_device_tokens_on_tokennotifiable_device_tokens CREATE UNIQUE INDEX "index_notifiable_device_tokens_on_token" ON "notifiable_device_tokens" ("token")=c=gindexindex_notifiable_device_tokens_on_device_idnotifiable_device_tokensCREATE UNIQUE INDEX "index_notifiable_device_tokens_on_device_id" ON "notifiable_device_tokens" ("device_id")R==7tablenotifiable_device_tokensnotifiable_device_tokensCREATE TABLE "notifiable_device_tokens" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "provider" varchar(255), "device_id" varchar(255), "is_valid" boolean DEFAULT 't', "user_id" integer, "app_id" integer, "created_at" datetime, "updated_at" datetime)T++_tablenotifiable_appsnotifiable_appsCREATE TABLE "notifiable_apps" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "configuration" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)mtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' 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 NULL)
)20131229104039)20131228225140)20131228225139)20131210115649)20131210115648
)20131229104039)20131228225140)20131228225139)20131210115649) 20131210115648
\ No newline at end of file