diff options
| author | Michael Save <savetheinternet@tinyboard.org> | 2012-08-27 02:52:31 +1000 |
|---|---|---|
| committer | Michael Save <savetheinternet@tinyboard.org> | 2012-08-27 02:52:31 +1000 |
| commit | c96b27eb5ba544b0be4aec59af0b2b587cfaf06e (patch) | |
| tree | f010efb591375886203c97fbca62c3d8f3435ac0 /install.php | |
| parent | a9562075f6c17bc848f7a5b1923177ade75f3611 (diff) | |
use UNSIGNED for `id` columns
Diffstat (limited to 'install.php')
| -rw-r--r-- | install.php | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/install.php b/install.php index 1e872911..d580e97d 100644 --- a/install.php +++ b/install.php @@ -1,7 +1,7 @@ <?php // Installation/upgrade file -define('VERSION', 'v0.9.6-dev-5'); +define('VERSION', 'v0.9.6-dev-6'); require 'inc/functions.php'; @@ -212,6 +212,16 @@ if (file_exists($config['has_installed'])) { query("ALTER TABLE `antispam` CHANGE `hash` `hash` CHAR( 40 ) NOT NULL") or error(db_error()); case 'v0.9.6-dev-4': query("ALTER TABLE `news` DROP INDEX `id`, ADD PRIMARY KEY ( `id` )") or error(db_error()); + case 'v0.9.6-dev-5': + query("ALTER TABLE `bans` CHANGE `id` `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT") or error(db_error()); + query("ALTER TABLE `mods` CHANGE `id` `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT") or error(db_error()); + query("ALTER TABLE `news` CHANGE `id` `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT") or error(db_error()); + query("ALTER TABLE `noticeboard` CHANGE `id` `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT") or error(db_error()); + query("ALTER TABLE `pms` CHANGE `id` `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT") or error(db_error()); + query("ALTER TABLE `reports` CHANGE `id` `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT") or error(db_error()); + foreach ($boards as $board) { + query(sprintf("ALTER TABLE `posts_%s` CHANGE `id` `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT", $board['uri'])) or error(db_error()); + } case false: // Update version number file_write($config['has_installed'], VERSION); |