diff options
| author | z0rglub <z0rglub@piwigo.org> | 2004-06-25 20:34:39 +0000 |
|---|---|---|
| committer | z0rglub <z0rglub@piwigo.org> | 2004-06-25 20:34:39 +0000 |
| commit | 537af4c95944dc5205a8c1ac70a813c933fd2f4e (patch) | |
| tree | 893fc1128b78508f276ce97c78800d420cf933b0 /install/dbscheme.txt | |
| parent | 576c2cb2f89622330a17a73eb4df2feffbab278c (diff) | |
- moved index storage_category_id to images_i1
- new index images_i2 on images.date_available
git-svn-id: http://piwigo.org/svn/trunk@443 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
| -rw-r--r-- | install/dbscheme.txt | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt index 2b9b8addd..fb41c4e50 100644 --- a/install/dbscheme.txt +++ b/install/dbscheme.txt @@ -122,9 +122,10 @@ PK:user_group_pk table:user_group column:user_id PK:users_pk table:users column:id PK:waiting_pk table:waiting column:id -index:categories_i2 table:categories column:id_uppercat -index:image_category_i1 table:image_category column:image_id -index:image_category_i2 table:image_category column:category_id -index:storage_category_id table:images column:storage_category_id -index:sites_ui1 table:sites column:galleries_url -index:users_ui1 table:users column:username +index:categories_i2 table:categories column:id_uppercat +index:image_category_i1 table:image_category column:image_id +index:image_category_i2 table:image_category column:category_id +index:images_i2 table:images column:date_available +index:images_i1 table:images column:storage_category_id +index:sites_ui1 table:sites column:galleries_url +index:users_ui1 table:users column:username |