maintenance/oracle/archives/patch-drop-ar_text.sql

   1 -- T33223: Remove obsolete ar_text and ar_flags columns
   2 -- (and make ar_text_id not nullable and default 0)
   3
   4 define mw_prefix='{$wgDBprefix}';
   5
   6 ALTER TABLE &mw_prefix.archive DROP (ar_text, ar_flags);
   7 ALTER TABLE &mw_prefix.archive MODIFY ar_text_id NUMBER DEFAULT 0 NOT NULL;