spec/dummy/db/test.sqlite3 in mailboxer_multi_attach-0.0.4 vs spec/dummy/db/test.sqlite3 in mailboxer_multi_attach-0.0.5
- old
+ new
@@ -1,33 +1,34 @@
-SQLite format 3 @ t -
+SQLite format 3 @ n n -
8
T k
%*NJ )Y1indexindex_mailboxer_receipts_on_receiver_id_and_receiver_typemailboxer_receiptsCREATE INDEX "index_mailboxer_receipts_on_receiver_id_and_receiver_type" ON "mailboxer_receipts" ("receiver_id", "receiver_type")x;;indexindex_mailboxer_notifications_on_notified_object_id_and_typemailboxer_notificationsCREATE INDEX "index_mailboxer_notifications_on_notified_object_id_and_type" ON "mailboxer_notifications" ("notified_object_id", "notified_object_type")b;indexindex_mailboxer_notifications_on_sender_id_and_sender_typemailboxer_notificationsCREATE INDEX "index_mailboxer_notifications_on_sender_id_and_sender_type" ON "mailboxer_notifications" ("sender_id", "sender_type")#
W;Aindexindex_mailboxer_notifications_on_typemailboxer_notificationsCREATE INDEX "index_mailboxer_notifications_on_type" ON "mailboxer_notifications" ("type")d}K
indexindex_mailboxer_conversation_opt_outs_on_conversation_idmailboxer_conversation_opt_outs
CREATE INDEX "index_mailboxer_conversation_opt_outs_on_conversation_id" ON "mailboxer_conversation_opt_outs" ("conversation_id")KAindexindex_mailboxer_conversation_opt_outs_on_unsubscriber_id_typemailboxer_conversation_opt_outsCREATE INDEX "index_mailboxer_conversation_opt_outs_on_unsubscriber_id_type" ON "mailboxer_conversation_opt_outs" ("unsubscriber_id", "unsubscriber_type")
KK}tablemailboxer_conversation_opt_outsmailboxer_conversation_opt_outsCREATE TABLE "mailboxer_conversation_opt_outs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "unsubscriber_id" integer, "unsubscriber_type" varchar(255), "conversation_id" integer)D m;mindexindex_mailboxer_notifications_on_conversation_idmailboxer_notifications
CREATE INDEX "index_mailboxer_notifications_on_conversation_id" ON "mailboxer_notifications" ("conversation_id")0c1Yindexindex_mailboxer_receipts_on_notification_idmailboxer_receipts CREATE INDEX "index_mailboxer_receipts_on_notification_id" ON "mailboxer_receipts" ("notification_id")3;;}tablemailboxer_notificationsmailboxer_notificationsCREATE TABLE "mailboxer_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "body" text, "subject" varchar(255) DEFAULT '', "sender_id" integer, "sender_type" varchar(255), "conversation_id" integer, "draft" boolean DEFAULT 'f', "notification_code" varchar(255), "notified_object_id" integer, "notified_object_type" varchar(255), "attachment" varchar(255), "updated_at" datetime NOT NULL, "created_at" datetime NOT NULL, "global" boolean DEFAULT 'f', "expires" datetime)11Wtablemailboxer_receiptsmailboxer_receiptsCREATE TABLE "mailboxer_receipts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "receiver_id" integer, "receiver_type" varchar(255), "notification_id" integer NOT NULL, "is_read" boolean DEFAULT 'f', "trashed" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "mailbox_type" varchar(25), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v;;tablemailboxer_conversationsmailboxer_conversationsCREATE TABLE "mailboxer_conversations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subject" varchar(255) DEFAULT '', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)HotableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "email" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime 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)
)20151123235316)20151123152910)20151123152909)20151123152908)20151123025448
- )20151123235316)20151123152910)20151123152909)20151123152908) 20151123025448 q0@P `p 0@P N1 )AAUser 2user2@user.com2015-11-24 13:21:52.2057892015-11-24 13:21:52.205789N0 )AAUser 1user1@user.com2015-11-24 13:21:52.2005502015-11-24 13:21:52.200550N/ )AAUser 2user2@user.com2015-11-24 13:21:42.5281642015-11-24 13:21:42.528164N. )AAUser 1user1@user.com2015-11-24 13:21:42.5209972015-11-24 13:21:42.520997N- )AAUser 2user2@user.com2015-11-24 13:18:03.3834732015-11-24 13:18:03.383473N, )AAUser 1user1@user.com2015-11-24 13:18:03.3707712015-11-24 13:18:03.370771N+ )AAUser 2user2@user.com2015-11-24 13:17:20.0420482015-11-24 13:17:20.042048N* )AAUser 1user1@user.com2015-11-24 13:17:20.0358912015-11-24 13:17:20.035891N) )AAUser 2user2@user.com2015-11-24 13:16:21.3716382015-11-24 13:16:21.371638N( )AAUser 1user1@user.com2015-11-24 13:16:21.3641782015-11-24 13:16:21.364178N' )AAUser 2user2@user.com2015-11-24 13:15:13.4575562015-11-24 13:15:13.457556N& )AAUser 1user1@user.com2015-11-24 13:15:13.4514922015-11-24 13:15:13.451492N% )AAUser 2user2@user.com2015-11-24 13:14:46.7539672015-11-24 13:14:46.753967N$ )AAUser 1user1@user.com2015-11-24 13:14:46.7470242015-11-24 13:14:46.747024N# )AAUser 2user2@user.com2015-11-24 13:14:23.5240082015-11-24 13:14:23.524008N" )AAUser 1user1@user.com2015-11-24 13:14:23.5159212015-11-24 13:14:23.515921N! )AAUser 2user2@user.com2015-11-24 13:12:24.7644802015-11-24 13:12:24.764480N )AAUser 1user1@user.com2015-11-24 13:12:24.7578792015-11-24 13:12:24.757879N )AAUser 2user2@user.com2015-11-24 13:11:35.4451422015-11-24 13:11:35.445142N )AAUser 1user1@user.com2015-11-24 13:11:35.4381442015-11-24 13:11:35.438144N )AAUser 2user2@user.com2015-11-24 13:09:04.0551882015-11-24 13:09:04.055188N )AAUser 1user1@user.com2015-11-24 13:09:04.0466842015-11-24 13:09:04.046684N )AAUser 2user2@user.com2015-11-24 01:39:14.7942012015-11-24 01:39:14.794201N )AAUser 1user1@user.com2015-11-24 01:39:14.7806462015-11-24 01:39:14.780646N )AAUser 2user2@user.com2015-11-24 01:38:44.4162202015-11-24 01:38:44.416220N )AAUser 1user1@user.com2015-11-24 01:38:44.4019382015-11-24 01:38:44.401938N )AAUser 2user2@user.com2015-11-24 01:36:50.7771132015-11-24 01:36:50.777113N )AAUser 1user1@user.com2015-11-24 01:36:50.7705822015-11-24 01:36:50.770582N )AAUser 2user2@user.com2015-11-24 01:01:54.1076642015-11-24 01:01:54.107664N )AAUser 1user1@user.com2015-11-24 01:01:54.1005102015-11-24 01:01:54.100510N )AAUser 2user2@user.com2015-11-24 01:00:00.4736262015-11-24 01:00:00.473626N )AAUser 1user1@user.com2015-11-24 01:00:00.4596582015-11-24 01:00:00.459658N )AAUser 2user2@user.com2015-11-24 00:55:00.3361882015-11-24 00:55:00.336188N )AAUser 1user1@user.com2015-11-24 00:55:00.3215512015-11-24 00:55:00.321551N )AAUser 2user2@user.com2015-11-24 00:52:50.6974422015-11-24 00:52:50.697442N )AAUser 1user1@user.com2015-11-24 00:52:50.6901332015-11-24 00:52:50.690133N
)AAUser 2user2@user.com2015-11-24 00:32:07.4733522015-11-24 00:32:07.473352N )AAUser 1user1@user.com2015-11-24 00:32:07.4660012015-11-24 00:32:07.466001N )AAUser 1user1@user.com2015-11-24 00:17:38.9476722015-11-24 00:17:38.947672N
- )AAUser 1user1@user.com2015-11-24 00:10:16.5491552015-11-24 00:10:16.549155N )AAUser 1user1@user.com2015-11-24 00:09:56.2367612015-11-24 00:09:56.236761N )AAUser 2user2@user.com2015-11-24 00:09:48.8941052015-11-24 00:09:48.894105N )AAUser 1user1@user.com2015-11-24 00:09:48.8870952015-11-24 00:09:48.887095N )AAUser 2user2@user.com2015-11-24 00:05:21.4049892015-11-24 00:05:21.404989N )AAUser 1user1@user.com2015-11-24 00:05:21.3892352015-11-24 00:05:21.389235N )AAUser 2user2@user.com2015-11-23 23:59:13.2176982015-11-23 23:59:13.217698N )AAUser 1user1@user.com2015-11-23 23:59:13.2036442015-11-23 23:59:13.203644N )AAUser 2user2@user.com2015-11-23 23: gG _ Yg S7 L GW C'