diff options
Diffstat (limited to 'install')
| -rw-r--r-- | install/database.sql | 2 | ||||
| -rw-r--r-- | install/update.php | 9 |
2 files changed, 9 insertions, 2 deletions
diff --git a/install/database.sql b/install/database.sql index eb573fb4d..6be3a31aa 100644 --- a/install/database.sql +++ b/install/database.sql @@ -441,7 +441,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `resource_id` char(255) NOT NULL DEFAULT '', `resource_type` char(16) NOT NULL DEFAULT '', `attach` mediumtext NOT NULL, - `inform` mediumtext NOT NULL, + `sig` text NOT NULL DEFAULT '', `location` char(255) NOT NULL DEFAULT '', `coord` char(255) NOT NULL DEFAULT '', `comment_policy` char(255) NOT NULL DEFAULT '', diff --git a/install/update.php b/install/update.php index 8a583a947..20af0de45 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1076 ); +define( 'UPDATE_VERSION' , 1077 ); /** * @@ -859,3 +859,10 @@ ADD INDEX ( `channel_a_republish` )"); return UPDATE_SUCCESS; return UPDATE_FAILED; } + +function update_r1076() { + $r = q("ALTER TABLE `item` CHANGE `inform` `sig` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' "); + if($r) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +} |