API: Always select rc_user from database (regardless of rcprop=user)

[lhc/web/wiklou.git] / maintenance / oracle / tables.sql

diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql
index 4c36fe1..7a8160f 100644 (file)
--- a/maintenance/oracle/tables.sql
+++ b/maintenance/oracle/tables.sql
@@ -248,8 +248,7 @@ CREATE TABLE &mw_prefix.archive (
   ar_id          NUMBER NOT NULL,
   ar_namespace   NUMBER    DEFAULT 0 NOT NULL,
   ar_title       VARCHAR2(255)         NOT NULL,
-  ar_comment     VARCHAR2(255),
-  ar_comment_id  NUMBER DEFAULT 0 NOT NULL,
+  ar_comment_id  NUMBER NOT NULL,
   ar_user        NUMBER          DEFAULT 0 NOT NULL,
   ar_user_text   VARCHAR2(255)         NULL,
   ar_actor       NUMBER          DEFAULT 0 NOT NULL,
@@ -497,8 +496,7 @@ CREATE TABLE &mw_prefix.ipblocks (
   ipb_by                NUMBER      DEFAULT 0 NOT NULL,
   ipb_by_text           VARCHAR2(255)      NULL,
   ipb_by_actor          NUMBER      DEFAULT 0 NOT NULL,
-  ipb_reason            VARCHAR2(255)      NULL,
-  ipb_reason_id         NUMBER DEFAULT 0 NOT NULL,
+  ipb_reason_id         NUMBER NOT NULL,
   ipb_timestamp         TIMESTAMP(6) WITH TIME ZONE  NOT NULL,
   ipb_auto              CHAR(1)         DEFAULT '0' NOT NULL,
   ipb_anon_only         CHAR(1)         DEFAULT '0' NOT NULL,
@@ -549,8 +547,7 @@ CREATE TABLE &mw_prefix.image (
   img_media_type   VARCHAR2(32),
   img_major_mime   VARCHAR2(32) DEFAULT 'unknown',
   img_minor_mime   VARCHAR2(100) DEFAULT 'unknown',
-  img_description  VARCHAR2(255),
-  img_description_id  NUMBER DEFAULT 0 NOT NULL,
+  img_description_id  NUMBER NOT NULL,
   img_user         NUMBER       DEFAULT 0 NOT NULL,
   img_user_text    VARCHAR2(255)      NULL,
   img_actor        NUMBER       DEFAULT 0 NOT NULL,
@@ -574,8 +571,7 @@ CREATE TABLE &mw_prefix.oldimage (
   oi_width         NUMBER      DEFAULT 0 NOT NULL,
   oi_height        NUMBER      DEFAULT 0 NOT NULL,
   oi_bits          NUMBER      DEFAULT 0 NOT NULL,
-  oi_description   VARCHAR2(255),
-  oi_description_id  NUMBER DEFAULT 0 NOT NULL,
+  oi_description_id  NUMBER NOT NULL,
   oi_user          NUMBER          DEFAULT 0 NOT NULL,
   oi_user_text     VARCHAR2(255)         NULL,
   oi_actor         NUMBER          DEFAULT 0 NOT NULL,
@@ -606,8 +602,7 @@ CREATE TABLE &mw_prefix.filearchive (
   fa_storage_key        VARCHAR2(64),
   fa_deleted_user       NUMBER          DEFAULT 0 NOT NULL,
   fa_deleted_timestamp  TIMESTAMP(6) WITH TIME ZONE  NOT NULL,
-  fa_deleted_reason     CLOB,
-  fa_deleted_reason_id  NUMBER DEFAULT 0 NOT NULL,
+  fa_deleted_reason_id  NUMBER NOT NULL,
   fa_size               NUMBER     DEFAULT 0 NOT NULL,
   fa_width              NUMBER     DEFAULT 0 NOT NULL,
   fa_height             NUMBER     DEFAULT 0 NOT NULL,
@@ -616,8 +611,7 @@ CREATE TABLE &mw_prefix.filearchive (
   fa_media_type         VARCHAR2(32) DEFAULT NULL,
   fa_major_mime         VARCHAR2(32) DEFAULT 'unknown',
   fa_minor_mime         VARCHAR2(100) DEFAULT 'unknown',
-  fa_description        VARCHAR2(255),
-  fa_description_id     NUMBER DEFAULT 0 NOT NULL,
+  fa_description_id     NUMBER NOT NULL,
   fa_user               NUMBER          DEFAULT 0 NOT NULL,
   fa_user_text          VARCHAR2(255)         NULL,
   fa_actor              NUMBER          DEFAULT 0 NOT NULL,
@@ -687,8 +681,7 @@ CREATE TABLE &mw_prefix.recentchanges (
   rc_actor           NUMBER          DEFAULT 0 NOT NULL,
   rc_namespace       NUMBER     DEFAULT 0 NOT NULL,
   rc_title           VARCHAR2(255)         NOT NULL,
-  rc_comment         VARCHAR2(255),
-  rc_comment_id      NUMBER DEFAULT 0 NOT NULL,
+  rc_comment_id      NUMBER NOT NULL,
   rc_minor           CHAR(1)         DEFAULT '0' NOT NULL,
   rc_bot             CHAR(1)         DEFAULT '0' NOT NULL,
   rc_new             CHAR(1)         DEFAULT '0' NOT NULL,
@@ -788,8 +781,7 @@ CREATE TABLE &mw_prefix.logging (
   log_namespace   NUMBER     DEFAULT 0 NOT NULL,
   log_title       VARCHAR2(255)         NOT NULL,
   log_page                             NUMBER,
-  log_comment     VARCHAR2(255),
-  log_comment_id  NUMBER DEFAULT 0 NOT NULL,
+  log_comment_id  NUMBER NOT NULL,
   log_params      CLOB,
   log_deleted     CHAR(1)      DEFAULT '0' NOT NULL
 );
@@ -906,8 +898,7 @@ CREATE TABLE &mw_prefix.protected_titles (
   pt_namespace   NUMBER           DEFAULT 0 NOT NULL,
   pt_title       VARCHAR2(255)    NOT NULL,
   pt_user        NUMBER                  NOT NULL,
-  pt_reason      VARCHAR2(255),
-  pt_reason_id   NUMBER DEFAULT 0 NOT NULL,
+  pt_reason_id   NUMBER NOT NULL,
   pt_timestamp   TIMESTAMP(6) WITH TIME ZONE  NOT NULL,
   pt_expiry      VARCHAR2(14) NOT NULL,
   pt_create_perm VARCHAR2(60) NOT NULL
@@ -946,23 +937,6 @@ CREATE UNIQUE INDEX &mw_prefix.change_tag_u06 ON &mw_prefix.change_tag (ct_rev_i
 
 CREATE INDEX &mw_prefix.change_tag_i02 ON &mw_prefix.change_tag (ct_tag_id,ct_rc_id,ct_rev_id,ct_log_id);
 
-CREATE TABLE &mw_prefix.tag_summary (
-  ts_id NUMBER NOT NULL,
-  ts_rc_id NUMBER NULL,
-  ts_log_id NUMBER NULL,
-  ts_rev_id NUMBER NULL,
-  ts_tags BLOB NOT NULL
-);
-ALTER TABLE &mw_prefix.tag_summary ADD CONSTRAINT &mw_prefix.tag_summary_pk PRIMARY KEY (ts_id);
-CREATE UNIQUE INDEX &mw_prefix.tag_summary_u01 ON &mw_prefix.tag_summary (ts_rc_id);
-CREATE UNIQUE INDEX &mw_prefix.tag_summary_u02 ON &mw_prefix.tag_summary (ts_log_id);
-CREATE UNIQUE INDEX &mw_prefix.tag_summary_u03 ON &mw_prefix.tag_summary (ts_rev_id);
-
-CREATE TABLE &mw_prefix.valid_tag (
-  vt_tag VARCHAR2(255) NOT NULL
-);
-ALTER TABLE &mw_prefix.valid_tag ADD CONSTRAINT &mw_prefix.valid_tag_pk PRIMARY KEY (vt_tag);
-
 -- This table is not used unless profiling is turned on
 --CREATE TABLE &mw_prefix.profiling (
 --  pf_count   NUMBER          DEFAULT 0 NOT NULL,