aboutsummaryrefslogtreecommitdiffstats
path: root/install/db
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2009-01-06 21:39:04 +0000
committerplegall <plg@piwigo.org>2009-01-06 21:39:04 +0000
commitbe3c66f112170f1865cd7041836cd598959133e5 (patch)
tree312b7d62ede7deefdc2e8d6d5908e800aad4e55c /install/db
parent1b711ad2365b47cb1f1969cad2195c180ad62609 (diff)
merge r3054 from branch 2.0 to trunk
Code administration: convert all text files to Unix file format (CR as eol and not CRLF) git-svn-id: http://piwigo.org/svn/trunk@3055 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/db')
-rw-r--r--install/db/33-database.php14
-rw-r--r--install/db/37-database.php40
-rw-r--r--install/db/61-database.php2
3 files changed, 28 insertions, 28 deletions
diff --git a/install/db/33-database.php b/install/db/33-database.php
index 2a972f92f..4efd0f9ed 100644
--- a/install/db/33-database.php
+++ b/install/db/33-database.php
@@ -26,7 +26,7 @@ if (!defined('PHPWG_ROOT_PATH'))
die('Hacking attempt!');
}
-$upgrade_description = 'Add column #group.is_default';
+$upgrade_description = 'Add column #group.is_default';
include_once(PHPWG_ROOT_PATH.'include/constants.php');
@@ -35,12 +35,12 @@ include_once(PHPWG_ROOT_PATH.'include/constants.php');
// +-----------------------------------------------------------------------+
echo "Add column is_default on ".GROUPS_TABLE;
-$query = '
-alter table '.GROUPS_TABLE.' add column
-`is_default` enum(\'true\',\'false\') NOT NULL default \'false\'
-;';
-pwg_query($query);
-
+$query = '
+alter table '.GROUPS_TABLE.' add column
+`is_default` enum(\'true\',\'false\') NOT NULL default \'false\'
+;';
+pwg_query($query);
+
echo
"\n"
diff --git a/install/db/37-database.php b/install/db/37-database.php
index 1fde4ccf9..f58d555ff 100644
--- a/install/db/37-database.php
+++ b/install/db/37-database.php
@@ -26,7 +26,7 @@ if (!defined('PHPWG_ROOT_PATH'))
die('Hacking attempt!');
}
-$upgrade_description = 'Cache user categories update';
+$upgrade_description = 'Cache user categories update';
include_once(PHPWG_ROOT_PATH.'include/constants.php');
@@ -34,25 +34,25 @@ include_once(PHPWG_ROOT_PATH.'include/constants.php');
// | Upgrade content |
// +-----------------------------------------------------------------------+
-echo "Create table ".USER_CACHE_CATEGORIES_TABLE;
-$query = '
-CREATE TABLE '.USER_CACHE_CATEGORIES_TABLE.' (
- `user_id` smallint(5) NOT NULL default \'0\',
- `cat_id` smallint(5) unsigned NOT NULL default \'0\',
- `is_child_date_last` enum(\'true\',\'false\') NOT NULL default \'false\',
- `max_date_last` datetime default NULL,
- `count_images` mediumint(8) unsigned default 0,
- `count_categories` mediumint(8) unsigned default 0,
- PRIMARY KEY (`user_id`, `cat_id`)
-) TYPE=MyISAM;';
-pwg_query($query);
-
-echo "Update table cache ".USER_CACHE_TABLE;
-$query = '
-UPDATE '.USER_CACHE_TABLE.'
- SET need_update = \'true\'
-;';
-pwg_query($query);
+echo "Create table ".USER_CACHE_CATEGORIES_TABLE;
+$query = '
+CREATE TABLE '.USER_CACHE_CATEGORIES_TABLE.' (
+ `user_id` smallint(5) NOT NULL default \'0\',
+ `cat_id` smallint(5) unsigned NOT NULL default \'0\',
+ `is_child_date_last` enum(\'true\',\'false\') NOT NULL default \'false\',
+ `max_date_last` datetime default NULL,
+ `count_images` mediumint(8) unsigned default 0,
+ `count_categories` mediumint(8) unsigned default 0,
+ PRIMARY KEY (`user_id`, `cat_id`)
+) TYPE=MyISAM;';
+pwg_query($query);
+
+echo "Update table cache ".USER_CACHE_TABLE;
+$query = '
+UPDATE '.USER_CACHE_TABLE.'
+ SET need_update = \'true\'
+;';
+pwg_query($query);
echo
"\n"
diff --git a/install/db/61-database.php b/install/db/61-database.php
index 84a6dc886..491843d05 100644
--- a/install/db/61-database.php
+++ b/install/db/61-database.php
@@ -37,7 +37,7 @@ include_once(PHPWG_ROOT_PATH.'include/constants.php');
$query = "
alter table ".GROUPS_TABLE."
- add UNIQUE KEY `groups_ui1` (`name`)
+ add UNIQUE KEY `groups_ui1` (`name`)
;";
pwg_query($query);