CoreFiles by mySites.guru
3.9.0-2018-10-15.sql22 lines, 767 bytes, from Joomla_3.9.21-Stable-Full_Package.zip
Raw History Compare with 3.9.20
md5
38e957e0fb7a017e7dead00624f93b64
sha1
c9820164e403cd9b3a325a77d37adda277a54408
sha256
ac7de5bdd8edee07ee9e50ec6075727ea77a8bbfe3195fe3fd709a1cb0a2dc64
CREATE NONCLUSTERED INDEX "idx_user_id" ON "#__action_logs"
(
	"user_id" ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF);

CREATE NONCLUSTERED INDEX "idx_user_id_logdate" ON "#__action_logs"
(
	"user_id" ASC,
	"log_date" ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF);

CREATE NONCLUSTERED INDEX "idx_user_id_extension" ON "#__action_logs"
(
	"user_id" ASC,
	"extension" ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF);

CREATE NONCLUSTERED INDEX "idx_extension_itemid" ON "#__action_logs"
(
	"extension" ASC,
	"item_id"
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF);

The same content is in 79 releases, Joomla 3.9.3-rc to 3.10.12. See them all, or every version of this file.