feature 2604: add images.rotation at database creation (not only duri…

…ng upgrade) git-svn-id: http://piwigo.org/svn/trunk@13849 68402e56-0260-453c-a942-63ccdbb3a9ee
Piwigo · Apr 2, 2012 · b636242 · b636242
1 parent f318fe0
commit b636242
Show file tree

Hide file tree

Showing 2 changed files with 3 additions and 2 deletions.
diff --git a/install/db/120-database.php b/install/db/120-database.php
@@ -28,7 +28,7 @@
 
 $upgrade_description = 'rotation mode (code, not angle) is stored in the database';
 
-$query = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN rotation tinyint DEFAULT NULL';
+$query = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN rotation tinyint unsigned DEFAULT NULL';
 pwg_query($query);
 
 echo

diff --git 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`),