spec/dummy/db/test.sqlite3 in wupee-1.1.4 vs spec/dummy/db/test.sqlite3 in wupee-2.0.0.beta1
- old
+ new
@@ -1,9 +1,9 @@
-SQLite format 3 @
- -
G
<S
-4 D; 33Mtablewupee_notificationswupee_notificationsCREATE TABLE "wupee_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "receiver_id" integer, "receiver_type" varchar, "attached_object_id" integer, "attached_object_type" varchar, "notification_type_id" integer, "is_read" boolean DEFAULT 'f', "is_sent" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
-Y;indexidx_wupee_notif_typ_config_on_receiver_type_and_receiver_idwupee_notification_type_configurationsCREATE INDEX "idx_wupee_notif_typ_config_on_receiver_type_and_receiver_id" ON "wupee_notification_type_configurations" ("receiver_type", "receiver_id")m sYindexidx_wupee_notif_type_config_on_notification_type_idwupee_notification_type_configurations
-CREATE INDEX "idx_wupee_notif_type_config_on_notification_type_id" ON "wupee_notification_type_configurations" ("notification_type_id")kYY1tablewupee_notification_type_configurationswupee_notification_type_configurations CREATE TABLE "wupee_notification_type_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "notification_type_id" integer, "receiver_id" integer, "receiver_type" varchar, "value" integer DEFAULT 0, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL).Y=Sindexindex_wupee_notification_types_on_namewupee_notification_typesCREATE UNIQUE INDEX "index_wupee_notification_types_on_name" ON "wupee_notification_types" ("name")f==_tablewupee_notification_typeswupee_notification_typesCREATE TABLE "wupee_notification_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)6?tablemessagesmessagesCREATE TABLE "messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)>[tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
)20151029113107)20151029113101)20151029113100)20150213152846)20150213150625
- )20151029113107)20151029113101)20151029113100)20150213152846) 20150213150625
-
-
-
+SQLite format 3 @
+ - <8 )6?tablemessagesmessagesCREATE TABLE "messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)>[tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar
+
)20151029113107)20151029113100)20150213152846)20150213150625
+ )20151029113107)20151029113100)20150213152846) 20150213150625
S S K^ l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")>[tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)6?tablemessagesmessagesCREATE TABLE "messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)f==_tablewupee_notification_typeswupee_notification_typesCREATE TABLE "wupee_notification_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
+
IH 433tablewupee_notificationswupee_notificat.Y=Sindexindex_wupee_notification_types_on_namewupee_notification_types CREATE UNIQUE INDEX "index_wupee_notification_types_on_name" ON "wupee_notification_types" ("name")433.Y=Sindexindex_wupee_notification_types_on_namewupee_notification_types CREATE UNIQUE INDEX "index_wupee_notification_types_on_name" ON "wupee_notification_types" ("name")433tablewupee_notificationswupee_notificationsCREATE TABLE "wupee_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "receiver_id" integer, "receiver_type" varchar, "attached_object_id" integer, "attached_object_type" varchar, "notification_type_id" integer, "is_read" boolean DEFAULT 'f', "is_sent" boolean DEFAULT 'f', "is_wanted" boolean DEFAULT 't', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
+
+
t, ?k3mindexidx_wupee_notifications_on_notification_type_idwupee_notificationsCREATE INDEX "idx_wupee_notifications_on_notification_type_id" ON "wupee_notifications" ("notification_type_id")5 Y3kindexidx_wupee_notifications_on_receiver_idwupee_notificationsCREATE INDEX "idx_wupee_notifications_on_receiver_id" ON "wupee_notifications" ("receiver_type", "receiver_id")Q
+g3indexidx_wupee_notifications_on_attached_object_idwupee_notifications
CREATE INDEX "idx_wupee_notifications_on_attached_object_id" ON "wupee_notifications" ("attached_object_type", "attached_object_id")
+
\ No newline at end of file