diff options
Diffstat (limited to 'updates/2.00-to-x.xx.sql')
| -rw-r--r-- | updates/2.00-to-x.xx.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql index 247aae9cf..314775494 100644 --- a/updates/2.00-to-x.xx.sql +++ b/updates/2.00-to-x.xx.sql @@ -13,6 +13,13 @@ CREATE TABLE variable ( PRIMARY KEY (name) ); +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) +); + CREATE TABLE watchdog ( id int(5) DEFAULT '0' NOT NULL auto_increment, user int(6) DEFAULT '0' NOT NULL, @@ -25,6 +32,8 @@ CREATE TABLE watchdog ( PRIMARY KEY (id) ); +ALTER TABLE users CHANGE rating rating decimal(8,2); + # 01/04/2001: CREATE TABLE access ( |