aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-08-21 12:52:43 +0000
committerz0rglub <z0rglub@piwigo.org>2004-08-21 12:52:43 +0000
commitd4519a348fb8d4dd4af9704b8b6494b5f2b6260a (patch)
treea820044d89ad5698b617c78b18b6f5f06846ade5 /install
parent5b35869ada1e42e980f753fb7711b4fa51b0502e (diff)
- add files metadata support : use info for database fields
- distinction between directories synchronization and metadata synchronization git-svn-id: http://piwigo.org/svn/trunk@486 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install')
-rw-r--r--install/config.sql2
-rw-r--r--install/phpwebgallery_structure.sql1
2 files changed, 3 insertions, 0 deletions
diff --git a/install/config.sql b/install/config.sql
index f23f29ff6..987c8a4a5 100644
--- a/install/config.sql
+++ b/install/config.sql
@@ -27,3 +27,5 @@ INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('nb_line_page','3
INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('recent_period','7','Period within which pictures are displayed as new (in days)');
INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('auto_expand','false','Auto expand of the category tree');
INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('show_nb_comments','true','Show the number of comments under the thumbnails');
+INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('use_iptc','false','Use IPTC data during database synchronization with files metadata');
+INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('use_exif','true','Use EXIF data during database synchronization with files metadata');
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index f2072281b..06ea1cebf 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -136,6 +136,7 @@ CREATE TABLE phpwebgallery_images (
keywords varchar(255) default NULL,
storage_category_id smallint(5) unsigned default NULL,
representative_ext varchar(4) default NULL,
+ date_metadata_update date default NULL,
PRIMARY KEY (id),
KEY images_i2 (date_available),
KEY images_i1 (storage_category_id)