CoreFiles by mySites.guru
3.9.0-2018-10-15.sql22 lines, 788 bytes, from Joomla_3.9.2-Stable-Full_Package.zip
Raw History Compare with 3.9.1
md5
9b9a329ec43c9e222855bdd9a1697a21
sha1
f9e12f680285e234242239b9465f1f40e10be93a
sha256
5ec4861d47ffc91d85eff5907f18c0531b94323a60c286371d40985bcee3b0d4
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 6 releases, Joomla 3.9.0-rc2 to 3.9.2. See them all, or every version of this file.