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)
Sun, Oct 27, 1:41 PM
Unknown Object (File)
Sun, Oct 27, 1:41 PM
Unknown Object (File)
Sun, Oct 27, 1:41 PM
Unknown Object (File)
Thu, Oct 24, 8:04 AM
Unknown Object (File)
Thu, Oct 10, 6:49 AM
Unknown Object (File)
Thu, Oct 10, 1:27 AM
Unknown Object (File)
Sep 15 2024, 3:44 PM
Unknown Object (File)
Sep 13 2024, 8:44 AM
View All 99 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...