summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-iw_api_and_wikiid.sql
blob: 1b1e3592d6fa7ed2884205eb6916a82b1a8f586a (plain)
1
2
3
4
5
6
7
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
);