Page MenuHomePhorge
Differential D3179

Add some missing indices in signup_codes table
ClosedPublic
Actions

Authored by machniak on Jan 3 2022, 11:25 AM.
Tags
None
Referenced Files
Unknown Object (File)
Sat, Sep 7, 9:26 AM
Unknown Object (File)
Wed, Sep 4, 11:44 PM
Unknown Object (File)
Wed, Sep 4, 6:36 PM
Unknown Object (File)
Tue, Sep 3, 6:51 AM
Unknown Object (File)
Sat, Aug 31, 5:07 AM
Unknown Object (File)
Sat, Aug 31, 12:20 AM
Unknown Object (File)
Sat, Aug 31, 12:20 AM
Unknown Object (File)
Fri, Aug 30, 11:49 PM
View All 90 Files
Subscribers
Restricted Project

Details

Reviewers
vanmeeuwen
Group Reviewers
Restricted Project
Commits
rKba18be4fbe73: Add some missing indices in signup_codes table
Summary

We query the table by email and ip_address and expires_at columns.

I also replaced whereDate() with where() in these queries as more appropriate.

Test Plan

./phpunit

Diff Detail

Repository
rK kolab
Branch
dev/signup-codes-indices
Lint
No Lint Coverage
Unit
No Test Coverage
Build Status
Buildable 37646
Build 15131: arc lint + arc unit

Event Timeline

machniak requested review of this revision.Jan 3 2022, 11:25 AM
machniak created this revision.
Harbormaster completed remote builds in B37646: Diff 9095.Jan 3 2022, 11:25 AM
vanmeeuwen accepted this revision.Jan 3 2022, 11:30 AM
This revision is now accepted and ready to land.Jan 3 2022, 11:30 AM
Closed by commit rKba18be4fbe73: Add some missing indices in signup_codes table (authored by machniak). · Explain WhyJan 3 2022, 11:42 AM
This revision was automatically updated to reflect the committed changes.

Revision Contents
Changeset List

PathSize
src/
app/
Rules/
4 lines
database/
migrations/
43 lines

Diff 9095

View Options

src/app/Rules/SignupExternalEmail.php

Loading...
View Options

src/database/migrations/2022_01_03_120000_signup_codes_indices.php

Loading...