aboutsummaryrefslogtreecommitdiffstats
path: root/actionmailbox/test/dummy/db/schema.rb
Commit message (Collapse)AuthorAgeFilesLines
* SQLite3: Implement `add_foreign_key` and `remove_foreign_key`Ryuta Kamizono2019-02-111-0/+1
| | | | | | | | | | | | I implemented Foreign key create in `create_table` for SQLite3 at #24743. This follows #24743 to implement `add_foreign_key` and `remove_foreign_key`. Unfortunately SQLite3 has one limitation that `PRAGMA foreign_key_list(table-name)` doesn't have constraint name. So we couldn't implement find/remove foreign key by name for now. Fixes #35207. Closes #31343.
* Allow using Action Mailbox on MySQL 5.5Ryuta Kamizono2019-01-181-5/+5
| | | | | | | | | | Active Record still support MySQL 5.5 which doesn't support datetime with precision. https://github.com/rails/rails/blob/9e34df00039d63b5672315419e76f06f80ef3dc4/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb#L99-L101 So we should check `supports_datetime_with_precision?` on the connection.
* Specify a name for [ message_id, message_checksum ] index to ensure the name ↵Pratik Naik2019-01-171-4/+4
| | | | | | does not exceed the limit. Also, update test schema to reflect the recent changes.
* Ensure Action Mailbox processes an email only once when received multiple timesPratik Naik2019-01-171-0/+2
| | | | | | | This also adds a new column, message_checksum, to the action_mailbox_inbound_emails table for storing SHA1 digest of the email source. Additionally, it makes generating the missing message id deterministic and adds a unique index on message_checksum and message_id to detect duplicate emails.
* Import Action MailboxGeorge Claghorn2018-12-251-0/+43