Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P17332
toomanykeys
Active
Public
Actions
Authored by
Ejegg
on Sep 27 2021, 10:43 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
Wikimedia-Fundraising-CiviCRM
Referenced Files
F34659684: toomanykeys
Sep 27 2021, 10:43 PM
2021-09-27 22:43:04 (UTC+0)
Subscribers
None
Added
keys
(
24
):
ADD
INDEX
INDEX_all_funds_last_donation_date
(
all_funds_last_donation_date
),
ADD
INDEX
INDEX_all_funds_first_donation_date
(
all_funds_first_donation_date
),
ADD
INDEX
INDEX_all_funds_number_donations
(
all_funds_number_donations
),
ADD
INDEX
INDEX_all_funds_largest_donation
(
all_funds_largest_donation
),
ADD
INDEX
INDEX_all_funds_total_2018_2019
(
all_funds_total_2018_2019
),
ADD
INDEX
INDEX_all_funds_change_2018_2019
(
all_funds_change_2018_2019
),
ADD
INDEX
INDEX_all_funds_total_2019_2020
(
all_funds_total_2019_2020
),
ADD
INDEX
INDEX_all_funds_change_2019_2020
(
all_funds_change_2019_2020
),
ADD
INDEX
INDEX_all_funds_total_2020_2021
(
all_funds_total_2020_2021
),
ADD
INDEX
INDEX_all_funds_change_2020_2021
(
all_funds_change_2020_2021
),
ADD
INDEX
INDEX_all_funds_total_2021_2022
(
all_funds_total_2021_2022
),
ADD
INDEX
INDEX_all_funds_change_2021_2022
(
all_funds_change_2021_2022
),
ADD
INDEX
INDEX_total_2022_2023
(
total_2022_2023
),
ADD
INDEX
INDEX_total_2022
(
total_2022
),
ADD
INDEX
INDEX_endowment_total_2022
(
endowment_total_2022
),
ADD
INDEX
INDEX_endowment_total_2022_2023
(
endowment_total_2022_2023
),
ADD
INDEX
INDEX_all_funds_total_2022_2023
(
all_funds_total_2022_2023
),
ADD
INDEX
INDEX_all_funds_change_2022_2023
(
all_funds_change_2022_2023
),
ADD
INDEX
INDEX_total_2023_2024
(
total_2023_2024
),
ADD
INDEX
INDEX_total_2023
(
total_2023
),
ADD
INDEX
INDEX_endowment_total_2023
(
endowment_total_2023
),
ADD
INDEX
INDEX_endowment_total_2023_2024
(
endowment_total_2023_2024
),
ADD
INDEX
INDEX_all_funds_total_2023_2024
(
all_funds_total_2023_2024
),
ADD
INDEX
INDEX_all_funds_change_2023_2024
(
all_funds_change_2023_2024
)
Existing
keys
:
PRIMARY
KEY
(
`
id
`
),
UNIQUE
KEY
`
unique_entity_id
`
(
`
entity_id
`
),
KEY
`
INDEX_last_donation_date
`
(
`
last_donation_date
`
),
KEY
`
INDEX_last_donation_currency
`
(
`
last_donation_currency
`
),
KEY
`
INDEX_last_donation_amount
`
(
`
last_donation_amount
`
),
KEY
`
INDEX_last_donation_usd
`
(
`
last_donation_usd
`
),
KEY
`
INDEX_lifetime_usd_total
`
(
`
lifetime_usd_total
`
),
KEY
`
total_2015_2016
`
(
`
total_2015_2016
`
),
KEY
`
total_2016_2017
`
(
`
total_2016_2017
`
),
KEY
`
total_2017_2018
`
(
`
total_2017_2018
`
),
KEY
`
total_2018_2019
`
(
`
total_2018_2019
`
),
KEY
`
total_2019_2020
`
(
`
total_2019_2020
`
),
KEY
`
total_2020_2021
`
(
`
total_2020_2021
`
),
KEY
`
INDEX_first_donation_date
`
(
`
first_donation_date
`
),
KEY
`
INDEX_first_donation_usd
`
(
`
first_donation_usd
`
),
KEY
`
INDEX_number_donations
`
(
`
number_donations
`
),
KEY
`
INDEX_total_2015
`
(
`
total_2015
`
),
KEY
`
INDEX_total_2016
`
(
`
total_2016
`
),
KEY
`
INDEX_total_2017
`
(
`
total_2017
`
),
KEY
`
INDEX_total_2018
`
(
`
total_2018
`
),
KEY
`
INDEX_total_2019
`
(
`
total_2019
`
),
KEY
`
INDEX_total_2020
`
(
`
total_2020
`
),
KEY
`
INDEX_endowment_last_donation_date
`
(
`
endowment_last_donation_date
`
),
KEY
`
INDEX_endowment_first_donation_date
`
(
`
endowment_first_donation_date
`
),
KEY
`
INDEX_lifetime_including_endowment
`
(
`
lifetime_including_endowment
`
),
KEY
`
INDEX_endowment_lifetime_usd_total
`
(
`
endowment_lifetime_usd_total
`
),
KEY
`
INDEX_endowment_number_donations
`
(
`
endowment_number_donations
`
),
KEY
`
INDEX_largest_donation
`
(
`
largest_donation
`
),
KEY
`
INDEX_endowment_largest_donation
`
(
`
endowment_largest_donation
`
),
KEY
`
INDEX_date_of_largest_donation
`
(
`
date_of_largest_donation
`
),
KEY
`
INDEX_endowment_total_2018
`
(
`
endowment_total_2018
`
),
KEY
`
INDEX_endowment_total_2018_2019
`
(
`
endowment_total_2018_2019
`
),
KEY
`
INDEX_endowment_total_2019
`
(
`
endowment_total_2019
`
),
KEY
`
INDEX_endowment_total_2019_2020
`
(
`
endowment_total_2019_2020
`
),
KEY
`
INDEX_endowment_total_2020
`
(
`
endowment_total_2020
`
),
KEY
`
INDEX_endowment_total_2020_2021
`
(
`
endowment_total_2020_2021
`
),
KEY
`
entity_total
`
(
`
entity_id
`
,
`
lifetime_usd_total
`
),
KEY
`
INDEX_total_2021_2022
`
(
`
total_2021_2022
`
),
KEY
`
INDEX_total_2021
`
(
`
total_2021
`
),
KEY
`
INDEX_endowment_total_2021
`
(
`
endowment_total_2021
`
),
KEY
`
INDEX_endowment_total_2021_2022
`
(
`
endowment_total_2021_2022
`
),
CONSTRAINT
`
FK_wmf_donor_entity_id
`
FOREIGN
KEY
(
`
entity_id
`
)
REFERENCES
`
civicrm_contact
`
(
`
id
`
)
ON
DELETE
CASCADE
Event Timeline
Ejegg
created this paste.
Sep 27 2021, 10:43 PM
2021-09-27 22:43:04 (UTC+0)
Log In to Comment