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
F10370767: D3179.id.diff
Sat, Sep 30, 10:14 PM
F10368268: D3179.diff
Sat, Sep 30, 10:02 AM
F10367956: D3179.id.diff
Sat, Sep 30, 7:49 AM
Unknown Object (File)
Fri, Sep 29, 9:07 AM
Unknown Object (File)
Thu, Sep 28, 1:30 AM
Unknown Object (File)
Wed, Sep 27, 9:22 PM
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...