diff options
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), |