summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-rd_interwiki.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/ibm_db2/patch-rd_interwiki.sql')
-rw-r--r--maintenance/ibm_db2/patch-rd_interwiki.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/ibm_db2/patch-rd_interwiki.sql b/maintenance/ibm_db2/patch-rd_interwiki.sql
new file mode 100644
index 00000000..c162548c
--- /dev/null
+++ b/maintenance/ibm_db2/patch-rd_interwiki.sql
@@ -0,0 +1,8 @@
+CREATE TABLE redirect (
+ rd_from BIGINT NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
+ --REFERENCES page(page_id) ON DELETE CASCADE,
+ rd_namespace SMALLINT NOT NULL DEFAULT 0,
+ rd_title VARCHAR(255) NOT NULL DEFAULT '',
+ rd_interwiki varchar(32),
+ rd_fragment VARCHAR(255)
+);