From dae5c2208c936c82b07eea35ce95f0aba03f5413 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 7 Apr 2001 20:00:21 +0000 Subject: - improved rating module: it now shows some basic statistics :-) - updated database files - removed affialiate-site and drupal-site module: maintain them by hand through a box for now will you. --- database/database.mysql | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'database') diff --git a/database/database.mysql b/database/database.mysql index e2aed1caf..89f3ac0f7 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -219,12 +219,20 @@ CREATE TABLE users ( history text NOT NULL, hash varchar(12) DEFAULT '' NOT NULL, timezone varchar(8), - rating decimal(8,4), + rating decimal(8,2), language char(2) DEFAULT '' NOT NULL, access varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (id) ); +DROP TABLE IF EXISTS rating; +CREATE TABLE rating ( + user int(6) DEFAULT '0' NOT NULL, + new int(6) DEFAULT '0' NOT NULL, + old int(6) DEFAULT '0' NOT NULL, + PRIMARY KEY (user) +); + DROP TABLE IF EXISTS variable; CREATE TABLE variable ( name varchar(32) DEFAULT '' NOT NULL, -- cgit v1.2.3