diff options
author | plegall <plg@piwigo.org> | 2015-12-30 16:08:54 +0100 |
---|---|---|
committer | plegall <plg@piwigo.org> | 2015-12-30 16:08:54 +0100 |
commit | 6ba0148e646b2a193dc4111bb0a443d8c193e646 (patch) | |
tree | 382ecd35afae3522d07377df332f0ecfee1f5045 /install/piwigo_structure-mysql.sql | |
parent | f28420acfeb5d69e9ea39cd8d00cf9775d6cea54 (diff) | |
parent | 7b653c04d6cfb20366c3bb0e183a521b3c9d22d2 (diff) |
Merge branch 'feature/379-multiple-format'
Diffstat (limited to 'install/piwigo_structure-mysql.sql')
-rw-r--r-- | install/piwigo_structure-mysql.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql index b36844a8f..24c386abf 100644 --- a/install/piwigo_structure-mysql.sql +++ b/install/piwigo_structure-mysql.sql @@ -131,6 +131,7 @@ CREATE TABLE `piwigo_history` ( `image_id` mediumint(8) default NULL, `summarized` enum('true','false') default 'false', `image_type` enum('picture','high','other') default NULL, + `format_id` int(11) unsigned default NULL, PRIMARY KEY (`id`), KEY `history_i1` (`summarized`) ) ENGINE=MyISAM; @@ -163,6 +164,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` -- |