diff options
author | Arthur Schiwon <blizzz@owncloud.com> | 2013-03-25 20:54:45 +0400 |
---|---|---|
committer | Arthur Schiwon <blizzz@owncloud.com> | 2013-03-25 20:54:45 +0400 |
commit | 707de3e644c6e9119135c4784b11ec29d2edbced (patch) | |
tree | 5a39bf05896988afe7efae9c8780f98a4d7370f6 | |
parent | 19a65f6c3f41b6a62513232fab4ce24d95d0b036 (diff) |
Add Index to properties table for better performance on upgrade
-rw-r--r-- | db_structure.xml | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/db_structure.xml b/db_structure.xml index 3ce41096d9e..0f3def9fcd9 100644 --- a/db_structure.xml +++ b/db_structure.xml @@ -651,6 +651,22 @@ <length>255</length> </field> + <index> + <name>property_index</name> + <field> + <name>propertyname</name> + <sorting>ascending</sorting> + </field> + <field> + <name>propertypath</name> + <sorting>ascending</sorting> + </field> + <field> + <name>userid</name> + <sorting>ascending</sorting> + </field> + </index> + </declaration> </table> |