diff options
| author | Friendika <info@friendika.com> | 2011-07-01 22:36:33 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-07-01 22:36:33 -0700 |
| commit | fb0e758ce79c5c6a70d41766e3581bf756881d03 (patch) | |
| tree | d41d5b2f75546f7fc3e7154a188b5909ed8eac5e /database.sql | |
| parent | ccb00d68827b1ec7ebc4e9c436e4f70354d1c9c4 (diff) | |
| download | volse-hubzilla-fb0e758ce79c5c6a70d41766e3581bf756881d03.tar.gz volse-hubzilla-fb0e758ce79c5c6a70d41766e3581bf756881d03.tar.bz2 volse-hubzilla-fb0e758ce79c5c6a70d41766e3581bf756881d03.zip | |
add some indexes to photos
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 5187f3c3e..c9f9ae77a 100644 --- a/database.sql +++ b/database.sql @@ -278,7 +278,12 @@ CREATE TABLE IF NOT EXISTS `photo` ( `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `uid` (`uid`), + KEY `resource-id` (`resource-id`), + KEY `album` (`album`), + KEY `scale` (`scale`), + KEY `profile` (`profile`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- |