diff options
Diffstat (limited to 'install')
| -rw-r--r-- | install/database.sql | 4 | ||||
| -rw-r--r-- | install/update.php | 12 |
2 files changed, 14 insertions, 2 deletions
diff --git a/install/database.sql b/install/database.sql index 6f70438f3..de1d096b2 100644 --- a/install/database.sql +++ b/install/database.sql @@ -453,6 +453,7 @@ CREATE TABLE IF NOT EXISTS `item` ( `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `owner_xchan` char(255) NOT NULL DEFAULT '', `author_xchan` char(255) NOT NULL DEFAULT '', + `mimetype` char(255) NOT NULL DEFAULT '', `title` char(255) NOT NULL DEFAULT '', `body` mediumtext NOT NULL, `app` char(255) NOT NULL DEFAULT '', @@ -503,6 +504,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `llink` (`llink`), KEY `expires` (`expires`), KEY `revision` (`revision`), + KEY `mimetype` (`mimetype`), FULLTEXT KEY `title` (`title`), FULLTEXT KEY `body` (`body`), FULLTEXT KEY `allow_cid` (`allow_cid`), @@ -774,7 +776,7 @@ CREATE TABLE IF NOT EXISTS `register` ( KEY `hash` (`hash`), KEY `created` (`created`), KEY `uid` (`uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `session` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, diff --git a/install/update.php b/install/update.php index 4973b92ff..d4d1bdf50 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1026 ); +define( 'UPDATE_VERSION' , 1027 ); /** * @@ -332,3 +332,13 @@ ADD `flags` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `folder` , add index ( folde return UPDATE_SUCCESS; return UPDATE_FAILED; } + +function update_r1026() { + $r = q("ALTER TABLE `item` ADD `mimetype` CHAR( 255 ) NOT NULL DEFAULT '' AFTER `author_xchan` , +ADD INDEX ( `mimetype` )"); + if($r) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +} + + |