diff options
| author | plegall <plg@piwigo.org> | 2015-12-03 16:04:02 +0100 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2015-12-03 16:04:02 +0100 |
| commit | 8e098d502a8f0e413b9c085db27d6a62a6c0909f (patch) | |
| tree | 04bdf84e30becac7b8ed7b0b98fa7696b9979d5e /install/piwigo_structure-mysql.sql | |
| parent | 27389102d1275cdefcaee9c5a4a93297fc797b8c (diff) | |
feature #379 multiple format, step 1: add formats
* new table piwigo_image_format (each photo can have 0 to many formats)
* only compatible with synchronization for now. Formats must be in sub-directory pwg_format
* formats are visible on edition page only for now
Diffstat (limited to '')
| -rw-r--r-- | install/piwigo_structure-mysql.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql index b36844a8f..a452068a0 100644 --- a/install/piwigo_structure-mysql.sql +++ b/install/piwigo_structure-mysql.sql @@ -163,6 +163,18 @@ CREATE TABLE `piwigo_image_category` ( ) ENGINE=MyISAM; -- +-- Table structure for table `piwigo_image_format` +-- + +CREATE TABLE `piwigo_image_format` ( + `format_id` int(11) unsigned NOT NULL auto_increment, + `image_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ext` varchar(255) NOT NULL, + `filesize` mediumint(9) unsigned DEFAULT NULL, + PRIMARY KEY (`format_id`) +) ENGINE=MyISAM; + +-- -- Table structure for table `piwigo_image_tag` -- |