aboutsummaryrefslogtreecommitdiffstats
path: root/install/db/9-database.php
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2006-04-19 20:54:13 +0000
committerplegall <plg@piwigo.org>2006-04-19 20:54:13 +0000
commit8789f41f8ccb31d0ec9f2c75996511e26abba8bc (patch)
tree2ca978b4642a0d8a9be3cf95d2c3cd4c93458278 /install/db/9-database.php
parentdab8075c964fb1ba0c8ffc0158c29446bca70142 (diff)
bug fixed: during installation, upgrades from install/db with complex
identifier (X.x) were not correctly inserted. bug fixed: available upgrades from install/db need to be inserted in #upgrade table. deletion: all upgrades from install/db coming from trunk are removed. new: complete upgrade from any previous release from 1.3.0 to 1.5.2 with automatic detection detection of the previous release. git-svn-id: http://piwigo.org/svn/branches/branch-1_6@1209 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--install/db/9-database.php90
1 files changed, 0 insertions, 90 deletions
diff --git a/install/db/9-database.php b/install/db/9-database.php
deleted file mode 100644
index 3abf384a3..000000000
--- a/install/db/9-database.php
+++ /dev/null
@@ -1,90 +0,0 @@
-<?php
-// +-----------------------------------------------------------------------+
-// | PhpWebGallery - a PHP based picture gallery |
-// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
-// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net |
-// +-----------------------------------------------------------------------+
-// | branch : BSF (Best So Far)
-// | file : $RCSfile$
-// | last update : $Date: 2005-09-21 00:04:57 +0200 (mer, 21 sep 2005) $
-// | last modifier : $Author: plg $
-// | revision : $Revision: 870 $
-// +-----------------------------------------------------------------------+
-// | This program is free software; you can redistribute it and/or modify |
-// | it under the terms of the GNU General Public License as published by |
-// | the Free Software Foundation |
-// | |
-// | This program is distributed in the hope that it will be useful, but |
-// | WITHOUT ANY WARRANTY; without even the implied warranty of |
-// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
-// | General Public License for more details. |
-// | |
-// | You should have received a copy of the GNU General Public License |
-// | along with this program; if not, write to the Free Software |
-// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
-// | USA. |
-// +-----------------------------------------------------------------------+
-
-if (!defined('PHPWG_ROOT_PATH'))
-{
- die('Hacking attempt!');
-}
-
-$upgrade_description =
- 'Column #image_category.is_storage replaces #images.storage_category_id';
-
-// +-----------------------------------------------------------------------+
-// | Upgrade content |
-// +-----------------------------------------------------------------------+
-
-$query = "
-ALTER TABLE ".PREFIX_TABLE."image_category
- ADD COLUMN is_storage ENUM('true','false') DEFAULT 'false'
-;";
-pwg_query($query);
-
-$query = '
-SELECT id, storage_category_id
- FROM '.PREFIX_TABLE.'images
-;';
-$result = pwg_query($query);
-
-$datas = array();
-
-while ($row = mysql_fetch_array($result))
-{
- array_push(
- $datas,
- array(
- 'image_id' => $row['id'],
- 'category_id' => $row['storage_category_id'],
- 'is_storage' => 'true',
- )
- );
-}
-
-mass_updates(
- PREFIX_TABLE.'image_category',
- array(
- 'primary' => array('image_id', 'category_id'),
- 'update' => array('is_storage')
- ),
- $datas
- );
-
-$query = '
-ALTER TABLE '.PREFIX_TABLE.'images
- DROP COLUMN storage_category_id
-;';
-pwg_query($query);
-
-// +-----------------------------------------------------------------------+
-// | End notification |
-// +-----------------------------------------------------------------------+
-
-echo
-"\n"
-.'Column '.PREFIX_TABLE.'image_category.is_storage created and filled'
-."\n"
-;
-?>