maintenance/update-keys.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

-- SQL to insert update keys into the initial tables after a
-- fresh installation of MediaWiki's database.
-- This is read and executed by the install script; you should
-- not have to run it by itself unless doing a manual install.
-- Insert keys here if either the unnecessary would cause heavy
-- processing or could potentially cause trouble by lowering field
-- sizes, adding constraints, etc.
-- When adjusting field sizes, it is recommended removing old
-- patches but to play safe, update keys should also inserted here.

-- This is a shared file used for both MySQL and SQLite installs.
-- Therefore inserting multiple values is not possible using the
-- INSERT INTO VALUES syntax.
--
--
-- The /*_*/ comments in this and other files are
-- replaced with the defined table prefix by the installer
-- and updater scripts. If you are installing or running
-- updates manually, you will need to manually insert the
-- table prefix if any when running these scripts.
--

INSERT IGNORE INTO /*_*/updatelog
	SELECT 'filearchive-fa_major_mime-patch-fa_major_mime-chemical.sql' AS ul_key, null as ul_value
	UNION SELECT 'image-img_major_mime-patch-img_major_mime-chemical.sql', null
	UNION SELECT 'oldimage-oi_major_mime-patch-oi_major_mime-chemical.sql', null
	UNION SELECT 'user_groups-ug_group-patch-ug_group-length-increase-255.sql', null
	UNION SELECT 'user_former_groups-ufg_group-patch-ufg_group-length-increase-255.sql', null
	UNION SELECT 'user_properties-up_property-patch-up_property.sql', null;