CoreFiles by mySites.guru
3.5.0-2016-03-01.sql15 lines, 706 bytes, from Joomla_3.9.13-Stable-Full_Package.zip
Raw History Compare with 3.9.12
md5
ddea8c7e8ebcd2f0da8f4ffb0a44d2d5
sha1
d1a269750e0002f5e90f2fd7433dc8198d8fa340
sha256
e636e7fc8eb2b7c6afd72bda7dca1b2a870eec294066f2c67d8587b640c6abc6
ALTER TABLE [#__redirect_links] DROP CONSTRAINT [#__redirect_links$idx_link_old];
ALTER TABLE [#__redirect_links] ALTER COLUMN [old_url] [nvarchar](2048) NOT NULL;

--
-- The following statement had to be modified for 3.6.0 by removing the
-- NOT NULL, which was wrong because not consistent with new install.
-- See also 3.6.0-2016-04-06.sql for updating 3.5.0 or 3.5.1
--
ALTER TABLE [#__redirect_links] ALTER COLUMN [new_url] [nvarchar](2048);

ALTER TABLE [#__redirect_links] ALTER COLUMN [referer] [nvarchar](2048) NOT NULL;
CREATE NONCLUSTERED INDEX [idx_old_url] ON [#__redirect_links]
(
	[old_url] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF);

The same content is in 161 releases, Joomla 3.6.0-alpha to 3.10.12. See them all, or every version of this file.