Changeset 10341 for trunk


Ignore:
Timestamp:
Apr 12, 2011, 10:07:14 PM (13 years ago)
Author:
mistic100
Message:

bug:2224 change nb_image_page into smallint(3)

Location:
trunk/install
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/install/db/101-database.php

    r10199 r10341  
    3434  pwg_query('
    3535    ALTER TABLE '.USER_INFOS_TABLE.'
    36       ADD COLUMN `nb_image_page` tinyint(3) unsigned NOT NULL default \'15\'
     36      ADD COLUMN `nb_image_page` smallint(3) unsigned NOT NULL default \'15\'
    3737  ;');
    3838}

  • trunk/install/piwigo_structure-mysql.sql

    r10198 r10341  
    405405CREATE TABLE `piwigo_user_infos` (
    406406  `user_id` smallint(5) NOT NULL default '0',
    407   `nb_image_page` tinyint(3) unsigned NOT NULL default '15',
     407  `nb_image_page` smallint(3) unsigned NOT NULL default '15',
    408408  `status` enum('webmaster','admin','normal','generic','guest') NOT NULL default 'guest',
    409409  `language` varchar(50) NOT NULL default 'en_UK',
Note: See TracChangeset for help on using the changeset viewer.