aboutsummaryrefslogtreecommitdiffstats
path: root/actionmailbox/db/migrate/20180917164000_create_action_mailbox_tables.rb
Commit message (Collapse)AuthorAgeFilesLines
* Allow changing text and blob size without giving the `limit` optionRyuta Kamizono2019-01-291-5/+1
| | | | | | | | | | | | | | In MySQL, the text column size is 65,535 bytes by default (1 GiB in PostgreSQL). It is sometimes too short when people want to use a text column, so they sometimes change the text size to mediumtext (16 MiB) or longtext (4 GiB) by giving the `limit` option. Unlike MySQL, PostgreSQL doesn't allow the `limit` option for a text column (raises ERROR: type modifier is not allowed for type "text"). So `limit: 4294967295` (longtext) couldn't be used in Action Text. I've allowed changing text and blob size without giving the `limit` option, it prevents that migration failure on PostgreSQL.
* Revert "Apply `t.timestamps` changes in Action Text and Action Mailbox"Ryuta Kamizono2019-01-291-1/+5
| | | | This reverts commit 30f666f87ab873258b797b39f29cf852f7621bea.
* Apply `t.timestamps` changes in Action Text and Action MailboxRyuta Kamizono2019-01-291-5/+1
| | | | Follow up #34956.
* Allow using Action Mailbox on MySQL 5.5Ryuta Kamizono2019-01-181-2/+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-1/+1
| | | | | | 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-1/+4
| | | | | | | 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.
* Add 'null: false' to Action Mailbox tableikepon2019-01-161-2/+2
| | | | created_at and updated_at columns in Action Mailbox table aren't intended nullable.
* Use 6.0 version of ActiveRecord::Migration for Action Mailboxbogdanvlviv2018-12-301-1/+1
| | | | | | Since Action Mailbox will be introduced in Rails 6.0, it makes more sense to generate migration of that version. Also I changed its test dummy app to use default 6.0 configs.
* Import Action MailboxGeorge Claghorn2018-12-251-0/+11