diff options
| -rw-r--r-- | updates/3.00-to-x.xx.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/updates/3.00-to-x.xx.sql b/updates/3.00-to-x.xx.sql new file mode 100644 index 000000000..41769c689 --- /dev/null +++ b/updates/3.00-to-x.xx.sql @@ -0,0 +1,23 @@ + +ALTER TABLE boxes DROP link; + +ALTER TABLE users RENAME AS user; +ALTER TABLE user DROP INDEX real_email; +ALTER TABLE user DROP fake_email; +ALTER TABLE user DROP nodes; +ALTER TABLE user DROP bio; +ALTER TABLE user DROP hash; +ALTER TABLE user ADD session varchar(32) DEFAULT '' NOT NULL; +ALTER TABLE user ADD jabber varchar(128) DEFAULT '' NULL; +ALTER TABLE user ADD drupal varchar(128) DEFAULT '' NULL; +ALTER TABLE user ADD init varchar(64) DEFAULT '' NULL; +ALTER TABLE user CHANGE passwd pass varchar(24) DEFAULT '' NOT NULL; +ALTER TABLE user CHANGE real_email mail varchar(64) DEFAULT '' NULL; +ALTER TABLE user CHANGE last_access timestamp int(11) DEFAULT '0' NOT NULL; +ALTER TABLE user CHANGE last_host hostname varchar(128) DEFAULT '' NOT NULL; +ALTER TABLE user CHANGE id uid int(10) unsigned DEFAULT '0' NOT NULL auto_increment; +ALTER TABLE user CHANGE url homepage varchar(128) DEFAULT '' NOT NULL; +UPDATE user SET status = 1 WHERE status = 2; +UPDATE user SET name = userid; +ALTER TABLE user DROP userid; +UPDATE user SET init = mail; |