diff options
Diffstat (limited to 'updates/2.00-to-x.xx.sql')
| -rw-r--r-- | updates/2.00-to-x.xx.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql index 501c4bfe0..b43d97ead 100644 --- a/updates/2.00-to-x.xx.sql +++ b/updates/2.00-to-x.xx.sql @@ -265,3 +265,16 @@ ALTER TABLE book ADD log text NOT NULL; ALTER TABLE node DROP pid; ALTER TABLE node DROP log; DROP TABLE headlines; + +# 20/06/01 +CREATE TABLE role ( + rid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + name varchar(32) DEFAULT '' NOT NULL, + perm text DEFAULT '' NOT NULL, + UNIQUE name (name), + PRIMARY KEY (rid) +); + +ALTER TABLE users ADD role varchar(32) DEFAULT '' NOT NULL; +ALTER TABLE users DROP access; +UPDATE users SET role = 'registered user'; |