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)
Wed, Apr 17, 9:04 AM
Unknown Object (File)
Mon, Apr 8, 10:58 PM
Unknown Object (File)
Sun, Apr 7, 9:46 AM
Unknown Object (File)
Sat, Apr 6, 2:03 PM
Unknown Object (File)
Fri, Mar 29, 9:52 AM
Unknown Object (File)
Mon, Mar 25, 1:20 AM
Unknown Object (File)
Mon, Mar 25, 1:20 AM
Unknown Object (File)
Mon, Mar 25, 1:20 AM
View All 51 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
Lint
Lint Not Applicable
Unit
Tests Not Applicable

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 9107

View Options

src/app/Rules/SignupExternalEmail.php

Loading...
View Options

src/database/migrations/2022_01_03_120000_signup_codes_indices.php

Loading...