source: trunk/install/db/52-database.php @ 2297

Last change on this file since 2297 was 2297, checked in by plg, 16 years ago

Modification: new header on PHP files, PhpWebGallery renamed Piwigo.

  • Property svn:eol-style set to LF
  • Property svn:keywords set to Author Date Id Revision
File size: 4.2 KB
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | Piwigo - a PHP based picture gallery                                  |
4// +-----------------------------------------------------------------------+
5// | Copyright(C) 2008      Piwigo Team                  http://piwigo.org |
6// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
7// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
8// +-----------------------------------------------------------------------+
9// | This program is free software; you can redistribute it and/or modify  |
10// | it under the terms of the GNU General Public License as published by  |
11// | the Free Software Foundation                                          |
12// |                                                                       |
13// | This program is distributed in the hope that it will be useful, but   |
14// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
15// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
16// | General Public License for more details.                              |
17// |                                                                       |
18// | You should have received a copy of the GNU General Public License     |
19// | along with this program; if not, write to the Free Software           |
20// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
21// | USA.                                                                  |
22// +-----------------------------------------------------------------------+
23// +-----------------------------------------------------------------------+
24// | PhpWebGallery - a PHP based picture gallery                           |
25// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
26// | Copyright (C) 2003-2007 PhpWebGallery Team - http://phpwebgallery.net |
27// +-----------------------------------------------------------------------+
28// | branch        : BSF (Best So Far)
29// | file          : $Id: 52-database.php 2297 2008-04-04 22:57:23Z plg $
30// | last update   : $Date: 2008-04-04 22:57:23 +0000 (Fri, 04 Apr 2008) $
31// | last modifier : $Author: plg $
32// | revision      : $Revision: 2297 $
33// +-----------------------------------------------------------------------+
34// | This program is free software; you can redistribute it and/or modify  |
35// | it under the terms of the GNU General Public License as published by  |
36// | the Free Software Foundation                                          |
37// |                                                                       |
38// | This program is distributed in the hope that it will be useful, but   |
39// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
40// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
41// | General Public License for more details.                              |
42// |                                                                       |
43// | You should have received a copy of the GNU General Public License     |
44// | along with this program; if not, write to the Free Software           |
45// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
46// | USA.                                                                  |
47// +-----------------------------------------------------------------------+
48
49if (!defined('PHPWG_ROOT_PATH'))
50{
51  die('Hacking attempt!');
52}
53
54$upgrade_description = 'Replace #history.is_high by #history.image_type';
55
56include_once(PHPWG_ROOT_PATH.'include/constants.php');
57
58// +-----------------------------------------------------------------------+
59// |                            Upgrade content                            |
60// +-----------------------------------------------------------------------+
61
62$query = "
63ALTER TABLE ".HISTORY_TABLE."
64  ADD COLUMN image_type ENUM('picture', 'high', 'other') DEFAULT NULL
65;";
66pwg_query($query);
67
68$query = "
69UPDATE ".HISTORY_TABLE."
70  SET image_type = 'high'
71  WHERE is_high = 'true'
72;";
73pwg_query($query);
74
75$query = "
76UPDATE ".HISTORY_TABLE."
77  SET image_type = 'picture'
78  WHERE is_high = 'false'
79;";
80pwg_query($query);
81
82$query = "
83ALTER TABLE ".HISTORY_TABLE."
84  DROP COLUMN is_high
85;";
86pwg_query($query);
87
88echo
89"\n"
90.'"'.$upgrade_description.'"'.', ended'
91."\n"
92;
93
94?>
Note: See TracBrowser for help on using the repository browser.