CoreFiles by mySites.guru
3.7.0-2017-01-08.sql32 lines, 1,788 bytes, from Joomla_3.9.21-Stable-Full_Package.zip
Raw History Compare with 3.9.20
md5
c1ad361dfc558a3cd27caab6d1a7236a
sha1
ca254275be2a6b3e5c7231f3395d27ea09269077
sha256
e07a852a501bf8f0fa42aacf745d19afe1b6b9180b86a337f0139d5bf0c95493
-- Normalize ucm_content_table default values.
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_type_alias];
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_body];
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_params];
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_metadata];
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_language];

ALTER TABLE [#__ucm_content] DROP CONSTRAINT [#__ucm_content_core_content_id$idx_type_alias_item_id];
ALTER TABLE [#__ucm_content] ALTER COLUMN [core_content_item_id] [bigint] NOT NULL;
ALTER TABLE [#__ucm_content] ADD CONSTRAINT [#__ucm_content_core_content_id$idx_type_alias_item_id] UNIQUE NONCLUSTERED
(
	[core_type_alias] ASC,
	[core_content_item_id] ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY];
ALTER TABLE [#__ucm_content] ADD DEFAULT (0) FOR [core_content_item_id];

ALTER TABLE [#__ucm_content] ALTER COLUMN [asset_id] [bigint] NOT NULL;
ALTER TABLE [#__ucm_content] ADD DEFAULT (0) FOR [asset_id];

ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_images];
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_urls];
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_metakey];
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_metadesc];
ALTER TABLE [#__ucm_content] ADD DEFAULT ('') FOR [core_xreference];

DROP INDEX [idx_core_type_id] ON [#__ucm_content];
ALTER TABLE [#__ucm_content] ALTER COLUMN [core_type_id] [bigint] NOT NULL;
CREATE NONCLUSTERED INDEX [idx_core_type_id] ON [#__ucm_content]
(
	[core_type_id] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF);
ALTER TABLE [#__ucm_content] ADD DEFAULT (0) FOR [core_type_id];

The same content is in 140 releases, Joomla 3.7.0-beta4 to 3.10.12. See them all, or every version of this file.