From 8e098d502a8f0e413b9c085db27d6a62a6c0909f Mon Sep 17 00:00:00 2001
From: plegall <plg@piwigo.org>
Date: Thu, 3 Dec 2015 16:04:02 +0100
Subject: 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
---
 install/piwigo_structure-mysql.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'install/piwigo_structure-mysql.sql')

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
@@ -162,6 +162,18 @@ CREATE TABLE `piwigo_image_category` (
   KEY `image_category_i1` (`category_id`)
 ) 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`
 --
-- 
cgit v1.2.3

