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)
Tue, Jul 9, 6:00 AM
Unknown Object (File)
Sat, Jun 29, 9:16 PM
Unknown Object (File)
Fri, Jun 28, 1:37 PM
Unknown Object (File)
Jun 23 2024, 1:28 AM
Unknown Object (File)
Jun 16 2024, 1:37 AM
Unknown Object (File)
Jun 8 2024, 9:38 PM
Unknown Object (File)
Jun 7 2024, 12:50 PM
Unknown Object (File)
Jun 6 2024, 10:12 PM
View All 73 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...