Changeset 1311


Ignore:
Timestamp:
May 15, 2006, 11:43:20 PM (18 years ago)
Author:
plg
Message:

bug 365 fixed: categories.rank was limited to 255 due to storage
limitation. Maximum is 65535 now (should be good for a long time).

Location:
branches/branch-1_6/install
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed

  • branches/branch-1_6/install/phpwebgallery_structure.sql

    r1158 r1311  
    2929  `comment` text,
    3030  `dir` varchar(255) default NULL,
    31   `rank` tinyint(3) unsigned default NULL,
     31  `rank` smallint(5) unsigned default NULL,
    3232  `status` enum('public','private') NOT NULL default 'public',
    3333  `site_id` tinyint(4) unsigned default '1',

  • branches/branch-1_6/install/upgrade_1.5.0.php

    r1209 r1311  
    301301  ADD COLUMN enabled_high enum('true','false') NOT NULL default 'true'
    302302;",
    303 
     303  "
     304ALTER TABLE ".PREFIX_TABLE."categories
     305  CHANGE COLUMN rank rank SMALLINT(5) UNSIGNED DEFAULT NULL
     306;",
    304307  // configuration table
    305308  "
Note: See TracChangeset for help on using the changeset viewer.