X-Git-Url: https://git.cyclocoop.org/%27.%24link.%27?a=blobdiff_plain;f=maintenance%2Foracle%2Ftables.sql;h=30ae0105397e5b9ca7257a3c746e8c47ec1b208f;hb=21c6ae1163b07da7ac49938f50613c0e1cf262c3;hp=e69c79bf59ec3c77f6f2cbf716567c5a4745ed91;hpb=1a9ba829a5fbf40c0c2835efd441aaa70f9c319b;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql
index e69c79bf59..30ae010539 100644
--- a/maintenance/oracle/tables.sql
+++ b/maintenance/oracle/tables.sql
@@ -248,7 +248,6 @@ CREATE TABLE &mw_prefix.archive (
   ar_id          NUMBER NOT NULL,
   ar_namespace   NUMBER    DEFAULT 0 NOT NULL,
   ar_title       VARCHAR2(255)         NOT NULL,
-  ar_text        CLOB,
   ar_comment     VARCHAR2(255),
   ar_comment_id  NUMBER DEFAULT 0 NOT NULL,
   ar_user        NUMBER          DEFAULT 0 NOT NULL,
@@ -256,9 +255,8 @@ CREATE TABLE &mw_prefix.archive (
   ar_actor       NUMBER          DEFAULT 0 NOT NULL,
   ar_timestamp   TIMESTAMP(6) WITH TIME ZONE  NOT NULL,
   ar_minor_edit  CHAR(1)         DEFAULT '0' NOT NULL,
-  ar_flags       VARCHAR2(255),
   ar_rev_id      NUMBER NOT NULL,
-  ar_text_id     NUMBER,
+  ar_text_id     NUMBER DEFAULT 0 NOT NULL,
   ar_deleted     CHAR(1)      DEFAULT '0' NOT NULL,
   ar_len         NUMBER,
   ar_page_id     NUMBER,