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

1 files changed, 20 insertions, 20 deletions

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"