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/database.sql | |
| 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/database.sql')
| -rw-r--r-- | install/database.sql | 4 |
1 files changed, 3 insertions, 1 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, |