- 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.

1 files changed, 9 insertions, 1 deletions

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,