patch-renameuser_status-unique-to-pk.json
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

patch-renameuser_status-unique-to-pk.json
View Options

	{
	"comment": "Convert unique index to primary key (T300577)",
	"before": {
	"name": "renameuser_status",
	"comment": "Table for global rename status",
	"columns": [
	{
	"name": "ru_oldname",
	"comment": "Old name being renamed from",
	"type": "binary",
	"options": {
	"notnull": true,
	"length": 255
	}
	},
	{
	"name": "ru_newname",
	"comment": "New name being renamed to",
	"type": "binary",
	"options": {
	"notnull": true,
	"length": 255
	}
	},
	{
	"name": "ru_wiki",
	"comment": "WikiID",
	"type": "binary",
	"options": {
	"notnull": true,
	"length": 255
	}
	},
	{
	"name": "ru_status",
	"comment": "current state of the renaming",
	"type": "mwenum",
	"options": {
	"notnull": false,
	"CustomSchemaOptions": {
	"enum_values": [
	"queued",
	"inprogress",
	"failed"
	]
	}
	}
	}
	],
	"indexes": [
	{
	"name": "ru_oldname",
	"columns": [
	"ru_oldname",
	"ru_wiki"
	],
	"unique": true
	}
	]
	},
	"after": {
	"name": "renameuser_status",
	"comment": "Table for global rename status",
	"columns": [
	{
	"name": "ru_oldname",
	"comment": "Old name being renamed from",
	"type": "binary",
	"options": {
	"notnull": true,
	"length": 255
	}
	},
	{
	"name": "ru_newname",
	"comment": "New name being renamed to",
	"type": "binary",
	"options": {
	"notnull": true,
	"length": 255
	}
	},
	{
	"name": "ru_wiki",
	"comment": "WikiID",
	"type": "binary",
	"options": {
	"notnull": true,
	"length": 255
	}
	},
	{
	"name": "ru_status",
	"comment": "current state of the renaming",
	"type": "mwenum",
	"options": {
	"notnull": false,
	"CustomSchemaOptions": {
	"enum_values": [
	"queued",
	"inprogress",
	"failed"
	]
	}
	}
	}
	],
	"indexes": [],
	"pk": [
	"ru_oldname",
	"ru_wiki"
	]
	}
	}