diff options
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 10 |
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, |