X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Fpostgres%2Ftables.sql;h=5391bd94a3bc0bdaa0d70b4901788db38760f7b1;hb=5f8edb2c0a24b88b84f66b851b63a01b36b1a12c;hp=400050e7a1f5dc1d4b7e05d4d8acb1d6c46899f6;hpb=a15fe7dd93cfcd9510b54b8481b4c3aa891ac380;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 400050e7a1..5391bd94a3 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -81,7 +81,6 @@ CREATE TABLE page ( page_namespace SMALLINT NOT NULL, page_title TEXT NOT NULL, page_restrictions TEXT, - page_counter BIGINT NOT NULL DEFAULT 0, page_is_redirect SMALLINT NOT NULL DEFAULT 0, page_is_new SMALLINT NOT NULL DEFAULT 0, page_random NUMERIC(15,14) NOT NULL DEFAULT RANDOM(), @@ -262,7 +261,6 @@ CREATE INDEX langlinks_lang_title ON langlinks (ll_lang,ll_title); CREATE TABLE site_stats ( ss_row_id INTEGER NOT NULL UNIQUE, - ss_total_views INTEGER DEFAULT 0, ss_total_edits INTEGER DEFAULT 0, ss_good_articles INTEGER DEFAULT 0, ss_total_pages INTEGER DEFAULT -1, @@ -272,10 +270,6 @@ CREATE TABLE site_stats ( ss_images INTEGER DEFAULT 0 ); -CREATE TABLE hitcounter ( - hc_id BIGINT NOT NULL -); - CREATE SEQUENCE ipblocks_ipb_id_seq; CREATE TABLE ipblocks (