diff options
| author | plegall <plg@piwigo.org> | 2004-11-16 23:38:34 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2004-11-16 23:38:34 +0000 |
| commit | 1bf3753f1449eedc4bd39c79b6ca17dc4f396e76 (patch) | |
| tree | 7d7443b94356cd18a038b3f104f6e21a35d01279 /install | |
| parent | 973e0f8806cd6d569c01977ad5112e16cc7a7f6f (diff) | |
- images.path column added to reduce database access
- function mass_inserts moved from admin/remote_sites.php to
admin/include/function.php
- function mass_inserts used in admin/update.php
git-svn-id: http://piwigo.org/svn/trunk@606 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install')
| -rw-r--r-- | install/dbscheme.txt | 1 | ||||
| -rw-r--r-- | install/phpwebgallery_structure.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt index b190134b5..070f7f0bc 100644 --- a/install/dbscheme.txt +++ b/install/dbscheme.txt @@ -71,6 +71,7 @@ column:storage_category_id table:images type:smallint column:representative_ext table:images type:varchar nullable:Y length:4 binary:N column:date_metadata_update table:images type:date nullable:Y column:average_rate table:images type:float nullable:Y length:5,2 signed:N +column:path table:images type:varchar nullable:N length:255 binary:N column:user_id table:rate type:smallint nullable:N length:5 signed:N column:element_id table:rate type:mediumint nullable:N length:8 signed:N column:rate table:rate type:tinyint nullable:N length:2 signed:N diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index b45845675..d9dbf2161 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -140,6 +140,7 @@ CREATE TABLE phpwebgallery_images ( representative_ext varchar(4) default NULL, date_metadata_update date default NULL, average_rate float(5,2) unsigned default NULL, + path varchar(255) NOT NULL default '', PRIMARY KEY (id), KEY images_i2 (date_available), KEY images_i1 (storage_category_id), |