aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure-mysql.sql
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2012-04-02 12:18:17 +0000
committerplegall <plg@piwigo.org>2012-04-02 12:18:17 +0000
commitb6362427746dc54980c10edf2e03850a33982535 (patch)
treeffa25b38dd0172e5680297848c0e80b8c5c575dd /install/piwigo_structure-mysql.sql
parentf318fe042e322f86ca2054aff614ef16daf7a20a (diff)
feature 2604: add images.rotation at database creation (not only during upgrade)
git-svn-id: http://piwigo.org/svn/trunk@13849 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/piwigo_structure-mysql.sql')
-rw-r--r--install/piwigo_structure-mysql.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql
index 914c58f6e..35a0cfe68 100644
--- a/install/piwigo_structure-mysql.sql
+++ b/install/piwigo_structure-mysql.sql
@@ -185,7 +185,7 @@ CREATE TABLE `piwigo_images` (
`filesize` mediumint(9) unsigned default NULL,
`width` smallint(9) unsigned default NULL,
`height` smallint(9) unsigned default NULL,
- `coi` char(4) default NULL COMMENT 'center of interest',
+ `coi` char(4) default NULL COMMENT 'center of interest',
`representative_ext` varchar(4) default NULL,
`date_metadata_update` date default NULL,
`rating_score` float(5,2) unsigned default NULL,
@@ -198,6 +198,7 @@ CREATE TABLE `piwigo_images` (
`level` tinyint unsigned NOT NULL default '0',
`md5sum` char(32) default NULL,
`added_by` smallint(5) NOT NULL default '0',
+ `rotation` tinyint unsigned default null,
PRIMARY KEY (`id`),
KEY `images_i2` (`date_available`),
KEY `images_i3` (`rating_score`),