X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Foracle%2Ftables.sql;h=12f6518ad70cbb0eb9042b3e142590de7f579f28;hb=937ae6444a683a3b0aaf14c21f529ad0e91419ef;hp=36be16e4fdbb66033c4a935e60a3d669689708b7;hpb=d0a40e9a780f5ad5c147fbd2315a24ff32a22b65;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql index 36be16e4fd..12f6518ad7 100644 --- a/maintenance/oracle/tables.sql +++ b/maintenance/oracle/tables.sql @@ -69,7 +69,6 @@ CREATE TABLE &mw_prefix.page ( page_namespace NUMBER DEFAULT 0 NOT NULL, page_title VARCHAR2(255) NOT NULL, page_restrictions VARCHAR2(255), - page_counter NUMBER DEFAULT 0 NOT NULL, page_is_redirect CHAR(1) DEFAULT '0' NOT NULL, page_is_new CHAR(1) DEFAULT '0' NOT NULL, page_random NUMBER(15,14) NOT NULL, @@ -247,7 +246,6 @@ CREATE UNIQUE INDEX &mw_prefix.iwlinks_ui02 ON &mw_prefix.iwlinks (iwl_prefix, i CREATE TABLE &mw_prefix.site_stats ( ss_row_id NUMBER NOT NULL , - ss_total_views NUMBER DEFAULT 0, ss_total_edits NUMBER DEFAULT 0, ss_good_articles NUMBER DEFAULT 0, ss_total_pages NUMBER DEFAULT -1, @@ -257,10 +255,6 @@ CREATE TABLE &mw_prefix.site_stats ( ); CREATE UNIQUE INDEX &mw_prefix.site_stats_u01 ON &mw_prefix.site_stats (ss_row_id); -CREATE TABLE &mw_prefix.hitcounter ( - hc_id NUMBER NOT NULL -); - CREATE SEQUENCE ipblocks_ipb_id_seq; CREATE TABLE &mw_prefix.ipblocks ( ipb_id NUMBER NOT NULL,