Commit Graph

290 Commits

Author SHA1 Message Date
Son Nguyen Kim 35a9a723aa add index for Alias name and email column 2021-08-04 08:57:13 +02:00
Son Nguyen Kim b9d1d10473 Revert "add some indexes to speed up search by query"
This reverts commit e9538a62be.
2021-08-04 08:56:11 +02:00
Son Nguyen Kim e9538a62be add some indexes to speed up search by query 2021-08-03 19:13:48 +02:00
Son Nguyen Kim 6dac717c75 Add IgnoreBounceSender model 2021-08-02 11:30:29 +02:00
Son Nguyen Kim 5821bd6512 Create HibpNotifiedAlias to store all notified aliases 2021-07-29 09:41:46 +02:00
Son Nguyen Kim 5aef6cceb2 Add description, date column to Hibp model 2021-07-29 08:51:21 +02:00
Son Nguyen Kim 52376484a5 Add nb_block_last_24h, nb_bounced_last_24h, nb_forward_last_24h, nb_reply_last_24h 2021-07-28 18:31:59 +02:00
Son Nguyen Kim 39e2750486 remove Metric 2021-07-28 18:20:18 +02:00
Son Nguyen Kim 8de9931b28 Add User.expand_alias_info column 2021-07-22 10:17:23 +02:00
Son Nguyen Kim 4b9b3f18a2 add index for contact.reply_email col 2021-07-13 10:17:10 +02:00
Son Nguyen Kim 7a8b5d80ed Create coupon model 2021-07-12 19:26:28 +02:00
Son Nguyen Kim 0b063cb409 Add EmailLog.alias_id column 2021-07-11 12:27:30 +02:00
Son NK 3443b456b5 add sql migration 2021-06-27 17:51:28 +02:00
Son NK b84eb13ab5 Discard ignored email
Create IgnoredEmail model
2021-06-22 17:52:24 +02:00
Son NK da0424666a fix migration 2021-06-02 18:51:04 +02:00
Son Nguyen Kim b14d79c8f7
Merge pull request #496 from nbraud/pw_hash/refactor
Fix minor issues with password-handling, refactor
2021-06-02 18:33:56 +02:00
nicoo 586654e08e app.pw_models: Refactor, use constant-time equality 2021-05-29 17:42:46 +02:00
Son NK 28285f28ac Add index for AliasHibp 2021-05-28 19:59:26 +02:00
Son NK b23e3d94fd make sure AliasHibp has cascade ondelete 2021-05-25 18:14:44 +02:00
Sylvia van Os a08b0c05cc Don't override id 2021-05-17 21:29:29 +02:00
Sylvia van Os f67f5297f2 Add HIBP checks 2021-05-14 19:50:32 +02:00
Son NK 229d2c644b Add Payout model 2021-05-10 13:03:19 +02:00
Son NK f8540808bc remove Client.published 2021-04-06 19:46:21 +02:00
Son NK 3c4a1413e0 Remove ClientUser.nonce 2021-04-01 12:49:32 +02:00
Son NK 2f28e51c53 missing migration 2021-04-01 12:35:43 +02:00
Son NK 36e7cf3fdc add ClientUser.nonce 2021-04-01 12:31:37 +02:00
Son NK bbfb69d774 Add Client approved, description columns 2021-04-01 10:50:11 +02:00
Son NK 1600e273dd remove Metric2.name column 2021-03-23 10:30:57 +01:00
Son NK ec1633d0d7 create Metric2 model 2021-03-23 10:23:40 +01:00
Son 178d2c8689 recreate migration file 2021-03-06 18:10:34 +01:00
Son 29afc1b6b5 Add Alias.transfer_token col 2021-03-06 18:08:42 +01:00
Son NK 9492aaccf5 Add EmailLog.auto_replied col 2021-03-06 17:44:46 +01:00
Son NK 9ccfed28c5 fix migration: set include_sender_in_reverse_alias to false if null 2021-02-24 15:54:57 +01:00
Son NK 3aeaf6fe29 make include_sender_in_reverse_alias non nullable 2021-02-24 15:44:50 +01:00
Son NK e19fff3a9a Add Alias.original_owner_id column 2021-02-17 12:49:47 +01:00
Son NK 0354943ff4 Add User.sender_format_updated_at column 2021-01-26 20:13:51 +01:00
Son NK 1013e8dd79 Create Bounce, TransactionalEmail models 2021-01-26 09:59:22 +01:00
Son NK 980942a1f9 create Metric model 2021-01-25 18:47:02 +01:00
Son NK 435ced66bc make User.name nullable 2021-01-11 10:24:00 +01:00
Son NK 8dbaf3cf56 Add EmailLog.spam_report column 2021-01-04 14:38:32 +01:00
Son NK 0cf283089d fix migration name too long 2020-12-31 14:46:38 +01:00
Son NK 75d1b090cd rename default_random_alias_public_domain_id -> default_alias_public_domain_id 2020-12-31 14:14:56 +01:00
Son NK e0a414212e rename default_random_alias_domain_id -> default_alias_custom_domain_id 2020-12-31 14:06:32 +01:00
Son NK 9f9d292754 remove can_use_coinbase column 2020-12-19 16:31:16 +01:00
Son NK 1961d2f18e Add User.can_use_coinbase column 2020-12-13 19:28:13 +01:00
Son NK 9329cf04ad Create CoinbaseSubscription model 2020-12-13 19:05:43 +01:00
Son NK 05d4ec1c2f Add directory.disabled column 2020-12-07 10:48:43 +01:00
Son NK eab09d8c32 Add User.include_sender_in_reverse_alias column. Null for existing user, False for new user. 2020-12-06 19:36:39 +01:00
Son NK 255a7e085a add index on user_id, mailbox_id, ... if possible 2020-12-02 17:33:03 +01:00
Son NK 6b07be5677 add email_log.mailbox_id column 2020-11-24 16:35:16 +01:00
Son NK 5997e5b5b5 add Mailbox.disable_pgp column 2020-11-24 11:22:41 +01:00
Son NK abf50e302b Add Alias.pinned column 2020-11-15 18:38:07 +01:00
Son NK f62c568dd0 Add Contact.invalid_email column 2020-11-14 15:54:06 +01:00
Son NK 7cc57106de Add Mailbox.generic_subject column 2020-11-07 12:48:44 +01:00
Son NK 050c2feaeb Add LifetimeCoupon.paid column 2020-10-21 19:31:07 +02:00
Son NK 828799010b Add CustomDomain.nb_failed_checks column 2020-10-20 16:50:01 +02:00
Son NK dcbd7baabc Add PublicDomain.premium_only column 2020-10-15 16:08:06 +02:00
Son NK 8268568f08 add mailbox.disabled column. Disable a mailbox if it fails tests for 10 days consecutive. 2020-10-12 13:28:21 +02:00
Son NK 987d25263c regenerate migration file 2020-10-11 20:37:52 +02:00
Sylvia van Os 26d0437009 Make prefix generation configurable per domain 2020-10-09 22:54:13 +02:00
Son NK 6c37a91c6d add User.disabled field 2020-10-04 12:49:43 +02:00
Son NK 8b344e7dfe migration file 2020-09-28 17:43:16 +02:00
Son NK a37f7fe8b8 sql migration 2020-09-14 18:22:35 +02:00
Son NK fead5efc8b migration script 2020-09-12 14:34:38 +02:00
Son NK b92966b2c6 sql migration 2020-09-10 20:15:21 +02:00
Son NK 9c72f4dec0 Add Alias.disable_email_spoofing_check column 2020-08-26 14:39:03 +02:00
Son NK 0c6a5f4333 add EmailLog.spam_score column 2020-08-16 11:59:53 +02:00
Son NK 8e6fb9975d add sql migration 2020-08-15 13:17:08 +02:00
Son NK 4a2a4b9828 migration script 2020-08-01 12:48:03 +02:00
Son NK 7a22b58f19 migration file 2020-07-23 11:11:54 +02:00
Son NK d7b992aef3 sql migration 2020-07-04 23:32:55 +02:00
Son NK 59764f8e84 sql migration 2020-06-28 11:18:44 +02:00
Son NK 1f7779ed7b add sql migration 2020-06-25 13:05:37 +02:00
Son NK bc464d3549 migration script 2020-06-07 13:41:59 +02:00
Son NK 8b066fdf3d missing migration 2020-06-05 23:10:34 +02:00
Son NK dc9701177f migration script 2020-05-28 20:38:38 +02:00
Son NK 0367ab0e78 migration script 2020-05-27 14:12:44 +02:00
Son NK 5b1d8d4d74 migration script 2020-05-27 00:20:33 +02:00
Son NK eff960b451 regenerate migration 2020-05-24 19:54:12 +02:00
Sibren Vasse 097ac771b0 Prevent OTP replay attacks by invalidating last token 2020-05-24 19:23:16 +02:00
Sibren Vasse 35bb1645a3 Allow user to disable mfa for browser for 30 days 2020-05-24 19:23:16 +02:00
Son NK de1823c854 add migration script 2020-05-24 19:04:01 +02:00
Son NK 01a40ff801 migration script 2020-05-23 19:54:39 +02:00
Son NK be7ef9bbe9 migration script 2020-05-23 12:06:45 +02:00
Sibren Vasse e905e151ca Create user setting for replacing reverse alias (default: false) 2020-05-17 19:40:46 +02:00
Son NK d439871f65 generate new migration script 2020-05-17 12:51:07 +02:00
Son NK 4fe02266f2 Revert "migration sql"
This reverts commit 0524944d2a.
2020-05-17 12:50:39 +02:00
Son NK 12b76dd33b Merge branch 'master' into alias-disable-pgp 2020-05-17 10:46:44 +02:00
Son NK 5ff31f3eb4 migration script 2020-05-17 10:34:55 +02:00
Son NK 0524944d2a migration sql 2020-05-16 20:52:14 +02:00
Son NK 82a92dee52 fix migration 2020-05-16 20:44:06 +02:00
Sibren Vasse a5f24e0227 Add more From: sender formatting options 2020-05-16 18:44:31 +02:00
Son NK 0b652cf3f8 remove AliasMailbox.user_id column 2020-05-15 16:35:57 +02:00
Son NK 0ad296fa69 add necessary migration 2020-05-10 20:09:54 +02:00
Son NK 3ebaa54a4c migration script 2020-05-09 20:45:23 +02:00
Son NK 7bb7b92595 Fix migration 2020-05-09 18:34:34 +02:00
Son Nguyen Kim b95d815e5c
Merge pull request #168 from simple-login/global-trash
Global trash
2020-05-09 18:08:51 +02:00
Son NK acf628f8f2 fix migration script 2020-05-09 14:50:53 +02:00
Son Nguyen Kim e23887bb37
Merge pull request #164 from SibrenVasse/spf
Enforce SPF
2020-05-09 14:37:09 +02:00
Sibren Vasse 001079bdc5 Enforce SPF 2020-05-09 14:15:08 +02:00
Son NK 0441e5e2a9 Remove DeletedAlias.user_id column 2020-05-07 22:40:30 +02:00
Son NK f8e896541d replace Mailbox.email unique constraint by (email, user_id) 2020-05-07 21:46:16 +02:00
Son NK 985e4ee2f8 sql migration for fido 2020-05-07 17:59:29 +02:00
Sibren Vasse 0e4799030d Add default alias name to custom domain 2020-05-03 19:35:02 +02:00
Son NK 5b8c7884b4 sql migration 2020-05-03 12:02:34 +02:00
Son NK 249eab31e7 sql migration 2020-05-02 18:14:17 +02:00
Son NK 22bfb4082e add alias.name column 2020-04-26 10:37:40 +02:00
Son NK b5b4fe2773 make sure original_transaction_id is unique 2020-04-19 23:13:07 +02:00
Son NK 1805980cb3 fix planenum enum already used 2020-04-19 11:47:25 +02:00
Son NK 11772d35e1 Add sql migration 2020-04-19 11:18:42 +02:00
Son NK 47f8e6f8e8 Add migration script 2020-04-13 20:51:00 +02:00
Son NK dee6d4959d Add User.intro_shown column 2020-04-13 13:22:52 +02:00
Son NK cdf23d04fc Add Referral model 2020-04-09 22:20:06 +02:00
Son NK fa8e0aee45 Add contact.name column 2020-04-05 12:18:18 +02:00
Son NK 9563b706f2 Add EmailLog is_spam, spam_status column 2020-03-30 21:42:25 +02:00
Son NK 65ca7d2a71 add User.use_via_format_for_sender column 2020-03-28 22:35:29 +01:00
Son NK 5b9f3c2763 add contact.is_cc column 2020-03-28 19:05:27 +01:00
Son NK 86ef7f54d9 RefusedEmail.path can be null 2020-03-22 16:51:21 +01:00
Son NK 8abdf655fc make aliasUsedOn.user_id non nullable 2020-03-20 12:29:37 +01:00
Son NK 92de2102ad Add AliasUsedOn.user_id col 2020-03-20 12:13:00 +01:00
Son NK 783b1937d5 make user_id non nullable on contact, email_log and file 2020-03-20 10:17:52 +01:00
Son NK 5400631d77 fix migration 2020-03-20 10:17:52 +01:00
Son NK cd19997424 Add File.user_id, Contact.user_id, EmailLog.user_id columns 2020-03-20 09:51:15 +01:00
Son NK edcdbabc93 fix migration 2020-03-19 10:54:37 +01:00
Son Nguyen Kim 44e2e175ef
Merge pull request #115 from simple-login/rename
Rename
2020-03-19 10:39:05 +01:00
Son NK 2d90d35647 rename gen_email_id -> alias_id 2020-03-17 12:01:18 +01:00
Son NK ab16f1afeb rename table gen_email -> alias 2020-03-17 11:52:47 +01:00
Son NK bea870ef8b rename ForwardEmailLog to EmailLog 2020-03-17 11:10:50 +01:00
Son NK f2d630e597 rename forward_id to contact_id 2020-03-17 11:05:53 +01:00
Son NK 578d09c26c rename forward_email table to contact 2020-03-17 10:57:55 +01:00
Son NK ea43b8f685 Open PGP to everyone 2020-03-17 09:22:29 +01:00
Son NK a923d9ad6a Add refused_email.deleted column 2020-03-15 11:10:37 +01:00
Son NK 7bf1baaafa Add sql migration 2020-03-14 16:36:18 +01:00
Son NK c41d4761aa Add migration script 2020-03-08 23:12:49 +01:00
Son NK 9ad2a80d36 add migration to set GenEmail.mailbox_id non-nullable 2020-03-05 21:39:49 +01:00
Son NK aeed62e95b All users use full-mailbox
- remove can_use_multiple_mailbox col
- remove full_mailbox col
2020-02-29 00:03:35 +07:00
Son NK bf3cbd033e add migration script 2020-02-28 19:09:01 +07:00
Son NK ed11363b0c add db migration script 2020-02-27 22:26:35 +07:00
Son NK ccb2d62906 Add necessary migration script 2020-02-23 17:02:59 +07:00
Son NK e51f91e769 add necessary migration 2020-02-23 16:04:23 +07:00
Son NK 9788c5afbb add migration script 2020-02-23 14:14:14 +07:00
Son NK f468a21b14 Add necessary migration 2020-02-22 20:57:39 +07:00
Son NK c5feede87d add User.can_use_multiple_mailbox column 2020-02-11 22:42:51 +07:00
Son NK eca2422be4 Add Mailbox model, GenEmail.mailbox_id column 2020-02-10 23:11:09 +07:00
Son NK ebadcfb175 add GenEmail.note column 2020-02-05 15:45:29 +07:00
Son NK ffee8757ea add Job model 2020-02-03 13:09:48 +07:00
Son NK 354e5f9a67 add User.trial_end column 2020-01-30 10:10:28 +07:00
Son NK 5a57e3bc44 Add Directory model and add directory_id column to GenEmail 2020-01-08 21:23:41 +01:00
Son NK 98d2882719 Add LifetimeCoupon model and User.lifetime column 2020-01-01 20:02:30 +01:00
Son NK 8202be7bae Fix migration 2019-12-30 22:27:45 +01:00