summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-iw_api_and_wikiid.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/ibm_db2/patch-iw_api_and_wikiid.sql')
-rw-r--r--maintenance/ibm_db2/patch-iw_api_and_wikiid.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/ibm_db2/patch-iw_api_and_wikiid.sql b/maintenance/ibm_db2/patch-iw_api_and_wikiid.sql
new file mode 100644
index 00000000..1b1e3592
--- /dev/null
+++ b/maintenance/ibm_db2/patch-iw_api_and_wikiid.sql
@@ -0,0 +1,8 @@
+CREATE TABLE interwiki (
+ iw_prefix VARCHAR(32) NOT NULL UNIQUE,
+ iw_url CLOB(64K) INLINE LENGTH 4096 NOT NULL,
+ iw_api CLOB(64K) INLINE LENGTH 4096 NOT NULL,
+ iw_wikiid varchar(64) NOT NULL,
+ iw_local SMALLINT NOT NULL,
+ iw_trans SMALLINT NOT NULL DEFAULT 0
+);