diff options
| author | friendica <info@friendica.com> | 2013-02-10 19:00:22 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2013-02-10 19:00:22 -0800 |
| commit | 869b704b4019b49fdb5fb174fabd13b4e0e9aec0 (patch) | |
| tree | 0d81f107bbbc15d0eea778efb722701b8dde1f55 /install | |
| parent | 27c9288addb1630551633bdc4e631d4d01b5b93e (diff) | |
| download | volse-hubzilla-869b704b4019b49fdb5fb174fabd13b4e0e9aec0.tar.gz volse-hubzilla-869b704b4019b49fdb5fb174fabd13b4e0e9aec0.tar.bz2 volse-hubzilla-869b704b4019b49fdb5fb174fabd13b4e0e9aec0.zip | |
add mimetype to items
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; +} + + |