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 /update.php | |
| 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 'update.php')
| -rw-r--r-- | update.php | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/update.php b/update.php index 187662901..775bf7b92 100644 --- a/update.php +++ b/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1071 ); +define( 'UPDATE_VERSION' , 1072 ); /** * @@ -572,3 +572,11 @@ function update_1070() { q("ALTER TABLE `mail` CHANGE `body` `body` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL "); } +function update_1071() { + q("ALTER TABLE `photo` ADD INDEX ( `uid` ) "); + q("ALTER TABLE `photo` ADD INDEX ( `resource-id` ) "); + q("ALTER TABLE `photo` ADD INDEX ( `album` ) "); + q("ALTER TABLE `photo` ADD INDEX ( `scale` ) "); + q("ALTER TABLE `photo` ADD INDEX ( `profile` ) "); + +} |