Changeset 13849


Ignore:
Timestamp:
04/02/12 14:18:17 (8 years ago)
Author:
plg
Message:

feature 2604: add images.rotation at database creation (not only during upgrade)

Location:
trunk/install
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/install/db/120-database.php

    r13843 r13849  
    2929$upgrade_description = 'rotation mode (code, not angle) is stored in the database'; 
    3030 
    31 $query = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN rotation tinyint DEFAULT NULL'; 
     31$query = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN rotation tinyint unsigned DEFAULT NULL'; 
    3232pwg_query($query); 
    3333 
  • trunk/install/piwigo_structure-mysql.sql

    r13467 r13849  
    186186  `width` smallint(9) unsigned default NULL, 
    187187  `height` smallint(9) unsigned default NULL, 
    188         `coi` char(4) default NULL COMMENT 'center of interest', 
     188  `coi` char(4) default NULL COMMENT 'center of interest', 
    189189  `representative_ext` varchar(4) default NULL, 
    190190  `date_metadata_update` date default NULL, 
     
    199199  `md5sum` char(32) default NULL, 
    200200  `added_by` smallint(5) NOT NULL default '0', 
     201  `rotation` tinyint unsigned default null, 
    201202  PRIMARY KEY  (`id`), 
    202203  KEY `images_i2` (`date_available`), 
Note: See TracChangeset for help on using the changeset viewer.