Changeset 974


Ignore:
Timestamp:
Dec 6, 2005, 11:18:08 PM (18 years ago)
Author:
plg
Message:
  • bug 209 fixed: upgrade script did not delete obsolete columns in users table. users.password column was not updated by upgrade script. To fix this bug, a new upgrade script from 1.5.0 was added even if database model did not change, it's just about fixing upgraded database.
Location:
branches/branch-1_5/install
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed
  • branches/branch-1_5/install/upgrade_1.4.0.php

    r911 r974  
    288288}
    289289
     290// delete obsolete users table colums
     291$queries = array(
     292  "
     293ALTER TABLE phpwebgallery_users
     294  DROP COLUMN status
     295;",
     296
     297  "
     298ALTER TABLE phpwebgallery_users
     299  DROP COLUMN nb_image_line
     300;",
     301
     302  "
     303ALTER TABLE phpwebgallery_users
     304  DROP COLUMN maxheight
     305;",
     306
     307  "
     308ALTER TABLE phpwebgallery_users
     309  DROP COLUMN language
     310;",
     311
     312  "
     313ALTER TABLE phpwebgallery_users
     314  DROP COLUMN nb_line_page
     315;",
     316
     317  "
     318ALTER TABLE phpwebgallery_users
     319  DROP COLUMN expand
     320;",
     321
     322  "
     323ALTER TABLE phpwebgallery_users
     324  DROP COLUMN template
     325;",
     326
     327  "
     328ALTER TABLE phpwebgallery_users
     329  DROP COLUMN maxwidth
     330;",
     331
     332  "
     333ALTER TABLE phpwebgallery_users
     334  DROP COLUMN show_nb_comments
     335;",
     336
     337  "
     338ALTER TABLE phpwebgallery_users
     339  DROP COLUMN recent_period
     340;",
     341
     342  "
     343ALTER TABLE phpwebgallery_users
     344  CHANGE COLUMN password password varchar(32) default NULL
     345;"
     346  );
     347
     348foreach ($queries as $query)
     349{
     350  $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query);
     351  pwg_query($query);
     352}
     353
    290354$infos = array();
    291355
  • branches/branch-1_5/install/upgrade_1.4.1.php

    r911 r974  
    288288}
    289289
     290// delete obsolete users table colums
     291$queries = array(
     292  "
     293ALTER TABLE phpwebgallery_users
     294  DROP COLUMN status
     295;",
     296
     297  "
     298ALTER TABLE phpwebgallery_users
     299  DROP COLUMN nb_image_line
     300;",
     301
     302  "
     303ALTER TABLE phpwebgallery_users
     304  DROP COLUMN maxheight
     305;",
     306
     307  "
     308ALTER TABLE phpwebgallery_users
     309  DROP COLUMN language
     310;",
     311
     312  "
     313ALTER TABLE phpwebgallery_users
     314  DROP COLUMN nb_line_page
     315;",
     316
     317  "
     318ALTER TABLE phpwebgallery_users
     319  DROP COLUMN expand
     320;",
     321
     322  "
     323ALTER TABLE phpwebgallery_users
     324  DROP COLUMN template
     325;",
     326
     327  "
     328ALTER TABLE phpwebgallery_users
     329  DROP COLUMN maxwidth
     330;",
     331
     332  "
     333ALTER TABLE phpwebgallery_users
     334  DROP COLUMN show_nb_comments
     335;",
     336
     337  "
     338ALTER TABLE phpwebgallery_users
     339  DROP COLUMN recent_period
     340;",
     341
     342  "
     343ALTER TABLE phpwebgallery_users
     344  CHANGE COLUMN password password varchar(32) default NULL
     345;"
     346  );
     347
     348foreach ($queries as $query)
     349{
     350  $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query);
     351  pwg_query($query);
     352}
     353
    290354$infos = array();
    291355
Note: See TracChangeset for help on using the changeset viewer.