patch-site_identifiers-rename-indexes.json
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

patch-site_identifiers-rename-indexes.json
View Options

	{
	"comment": "Rename indexes to have uniform si_ prefix with the columns (T270033)",
	"before": {
	"name": "site_identifiers",
	"comment": "Links local site identifiers to their corresponding site.",
	"columns": [
	{
	"name": "si_type",
	"comment": "local key type, ie 'interwiki' or 'langlink'",
	"type": "binary",
	"options": {
	"length": 32,
	"notnull": true
	}
	},
	{
	"name": "si_key",
	"comment": "local key value, ie 'en' or 'wiktionary'",
	"type": "binary",
	"options": {
	"length": 32,
	"notnull": true
	}
	},
	{
	"name": "si_site",
	"comment": "Key on sites.site_id",
	"type": "integer",
	"options": {
	"unsigned": true,
	"notnull": true
	}
	}
	],
	"indexes": [
	{
	"name": "site_ids_site",
	"columns": [
	"si_site"
	],
	"unique": false
	},
	{
	"name": "site_ids_key",
	"columns": [
	"si_key"
	],
	"unique": false
	}
	],
	"pk": [
	"si_type",
	"si_key"
	]
	},
	"after": {
	"name": "site_identifiers",
	"comment": "Links local site identifiers to their corresponding site.",
	"columns": [
	{
	"name": "si_type",
	"comment": "local key type, ie 'interwiki' or 'langlink'",
	"type": "binary",
	"options": {
	"length": 32,
	"notnull": true
	}
	},
	{
	"name": "si_key",
	"comment": "local key value, ie 'en' or 'wiktionary'",
	"type": "binary",
	"options": {
	"length": 32,
	"notnull": true
	}
	},
	{
	"name": "si_site",
	"comment": "Key on sites.site_id",
	"type": "integer",
	"options": {
	"unsigned": true,
	"notnull": true
	}
	}
	],
	"indexes": [
	{
	"name": "si_site",
	"columns": [
	"si_site"
	],
	"unique": false
	},
	{
	"name": "si_key",
	"columns": [
	"si_key"
	],
	"unique": false
	}
	],
	"pk": [
	"si_type",
	"si_key"
	]
	}
	}