diff options
| author | leak <leak@bitmx.net> | 2012-03-28 16:39:59 +0200 |
|---|---|---|
| committer | leak <leak@bitmx.net> | 2012-03-28 16:39:59 +0200 |
| commit | b21725ecac647b0a5af79f1ef730a9cbaf5e4070 (patch) | |
| tree | 5189711feeae4a1a4e7e5150098bf811968b2cbf /sql/updates | |
| parent | 6763c237778a6fda4380ea1351ff3d79414acab9 (diff) | |
SQL: Auth db data type cleanup `account` / Storage engine switched to InnoDB
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/2012_03_28_00_auth_account.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/auth/2012_03_28_00_auth_account.sql b/sql/updates/auth/2012_03_28_00_auth_account.sql new file mode 100644 index 00000000000..199baac5178 --- /dev/null +++ b/sql/updates/auth/2012_03_28_00_auth_account.sql @@ -0,0 +1,13 @@ +ALTER TABLE `account` + CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identifier', + CHANGE `sessionkey` `sessionkey` VARCHAR(80) NOT NULL DEFAULT '', + CHANGE `v` `v` VARCHAR(64) NOT NULL DEFAULT '', + CHANGE `s` `s` VARCHAR(64) NOT NULL DEFAULT '', + CHANGE `email` `email` VARCHAR(254) NOT NULL DEFAULT '', + CHANGE `last_ip` `last_ip` VARCHAR(15) NOT NULL DEFAULT '127.0.0.1', + CHANGE `failed_logins` `failed_logins` INT(10) UNSIGNED NOT NULL DEFAULT '0', + CHANGE `online` `online` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + CHANGE `mutetime` `mutetime` BIGINT(20) NOT NULL DEFAULT '0', + CHANGE `os` `os` VARCHAR(3) NOT NULL DEFAULT '', + CHANGE `recruiter` `recruiter` INT(10) UNSIGNED NOT NULL DEFAULT '0', + ROW_FORMAT=DEFAULT ENGINE=INNODB; |