patch-add-uas_year.sql
No OneTemporary
Actions

Size

855 B

Referenced Files

None

Subscribers

None

patch-add-uas_year.sql
View Options

	-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
	-- Source: schema/abstractSchemaChanges/patch-add-uas_year.json
	-- Do not modify this file directly.
	-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
	CREATE TEMPORARY TABLE /_/__temp__global_user_autocreate_serial AS
	SELECT
	uas_shard,
	uas_value
	FROM /_/global_user_autocreate_serial;

	DROP TABLE /_/global_user_autocreate_serial;


	CREATE TABLE /_/global_user_autocreate_serial (
	uas_shard INTEGER UNSIGNED NOT NULL,
	uas_year SMALLINT UNSIGNED NOT NULL,
	uas_value INTEGER UNSIGNED NOT NULL,
	PRIMARY KEY(uas_shard, uas_year)
	);

	INSERT INTO /_/global_user_autocreate_serial (uas_shard, uas_value)
	SELECT
	uas_shard,
	uas_value
	FROM
	/_/__temp__global_user_autocreate_serial;

	DROP TABLE /_/__temp__global_user_autocreate_serial;