1 files changed, 57 insertions, 0 deletions
diff --git a/sql/sqlite/patch-sites-drop_indexes.sql b/sql/sqlite/patch-sites-drop_indexes.sql
new file mode 100644
index 000000000000..1a92e6eec94f
--- /dev/null
+++ b/sql/sqlite/patch-sites-drop_indexes.sql
@@ -0,0 +1,57 @@
+-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
+-- Source: maintenance/abstractSchemaChanges/patch-sites-drop_indexes.json
+-- Do not modify this file directly.
+-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
+CREATE TEMPORARY TABLE /*_*/__temp__sites AS
+SELECT
+  site_id,
+  site_global_key,
+  site_type,
+  site_group,
+  site_source,
+  site_language,
+  site_protocol,
+  site_domain,
+  site_data,
+  site_forward,
+  site_config
+FROM /*_*/sites;
+DROP TABLE /*_*/sites;
+
+
+CREATE TABLE /*_*/sites (
+    site_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+    site_global_key BLOB NOT NULL,
+    site_type BLOB NOT NULL,
+    site_group BLOB NOT NULL,
+    site_source BLOB NOT NULL,
+    site_language BLOB NOT NULL,
+    site_protocol BLOB NOT NULL,
+    site_domain VARCHAR(255) NOT NULL,
+    site_data BLOB NOT NULL,
+    site_forward SMALLINT NOT NULL,
+    site_config BLOB NOT NULL
+  );
+INSERT INTO /*_*/sites (
+    site_id, site_global_key, site_type,
+    site_group, site_source, site_language,
+    site_protocol, site_domain, site_data,
+    site_forward, site_config
+  )
+SELECT
+  site_id,
+  site_global_key,
+  site_type,
+  site_group,
+  site_source,
+  site_language,
+  site_protocol,
+  site_domain,
+  site_data,
+  site_forward,
+  site_config
+FROM
+  /*_*/__temp__sites;
+DROP TABLE /*_*/__temp__sites;
+
+CREATE UNIQUE INDEX site_global_key ON /*_*/sites (site_global_key);