diff options
author | plegall <plg@piwigo.org> | 2009-01-06 21:31:04 +0000 |
---|---|---|
committer | plegall <plg@piwigo.org> | 2009-01-06 21:31:04 +0000 |
commit | 680efc25ed280394bc398b6ab66b8dbccb8f11d5 (patch) | |
tree | 65e1114fe12de372b1582299c56b44ab659e0577 /install/db/37-database.php | |
parent | 19d096853d16040892fefb9bbf1182b390e59fb1 (diff) |
Code administration: convert all text files to Unix file format (CR as eol
and not CRLF)
git-svn-id: http://piwigo.org/svn/branches/2.0@3054 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/db/37-database.php')
-rw-r--r-- | install/db/37-database.php | 40 |
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" |