diff options
| author | Savetheinternet <savetheinternet@tinyboard.org> | 2011-07-14 11:20:41 +1000 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@tinyboard.org> | 2011-07-14 11:20:41 +1000 |
| commit | bee3dc280d39386e81df6e143e80670aa917bac0 (patch) | |
| tree | 774f2a1528d0f1657dae1fa01315a782733dc063 /install.php | |
| parent | 66d06015e343607db1f62df76d0a4bae13725513 (diff) | |
made `filehash` TEXT instead of a varchar (fixed maximum length)
Diffstat (limited to 'install.php')
| -rw-r--r-- | install.php | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/install.php b/install.php index 23736d42..148ba9dd 100644 --- a/install.php +++ b/install.php @@ -1,6 +1,6 @@ <?php // Installation/upgrade file - define('VERSION', 'v0.9.3-dev-2'); + define('VERSION', 'v0.9.3-dev-3'); require 'inc/functions.php'; require 'inc/display.php'; @@ -76,6 +76,11 @@ case 'v0.9.3-dev-1': query("ALTER TABLE `mods` ADD `boards` TEXT NOT NULL") or error(db_error()); query("UPDATE `mods` SET `boards` = '*'") or error(db_error()); + case 'v0.9.3-dev-2': + $boards = listBoards(); + foreach($boards as &_$board) { + query(sprintf("ALTER TABLE `posts_%s` CHANGE `filehash` `filehash` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL", $_board['uri'])) or error(db_error()); + } case false: // Update version number file_write($config['has_installed'], VERSION); |