- 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.


git-svn-id: http://piwigo.org/svn/branches/branch-1_5@974 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 64 insertions, 0 deletions

diff --git a/install/upgrade_1.4.0.php b/install/upgrade_1.4.0.php
index a5f8f38c6..615e0d4ec 100644
--- a/install/upgrade_1.4.0.php
+++ b/install/upgrade_1.4.0.php
@@ -287,6 +287,70 @@ foreach ($queries as $query)
   pwg_query($query);
 }
 
+// delete obsolete users table colums
+$queries = array(
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN status
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN nb_image_line
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN maxheight
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN language
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN nb_line_page
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN expand
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN template
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN maxwidth
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN show_nb_comments
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  DROP COLUMN recent_period
+;",
+
+  "
+ALTER TABLE phpwebgallery_users
+  CHANGE COLUMN password password varchar(32) default NULL
+;"
+  );
+
+foreach ($queries as $query)
+{
+  $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query);
+  pwg_query($query);
+}
+
 $infos = array();
 
 if ($prefix_thumbnail != 'TN-')