diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-14 02:07:23 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-14 02:07:23 +0000 |
| commit | 16df4a91ee3d316058a4fd2d420594f98ba82987 (patch) | |
| tree | 1dda3f6a0f17c9ebeec51f30f0cbb1097274e281 | |
| parent | c47ba954695019295b2cd766b63e7ae1d8e3328f (diff) | |
| download | forums-16df4a91ee3d316058a4fd2d420594f98ba82987.tar forums-16df4a91ee3d316058a4fd2d420594f98ba82987.tar.gz forums-16df4a91ee3d316058a4fd2d420594f98ba82987.tar.bz2 forums-16df4a91ee3d316058a4fd2d420594f98ba82987.tar.xz forums-16df4a91ee3d316058a4fd2d420594f98ba82987.zip | |
This file must be run before using any of the updated session stuff, also fixes the search results problem
git-svn-id: file:///svn/phpbb/trunk@1562 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/update_to_RC1.php | 78 |
1 files changed, 78 insertions, 0 deletions
diff --git a/phpBB/update_to_RC1.php b/phpBB/update_to_RC1.php new file mode 100644 index 0000000000..8c74297763 --- /dev/null +++ b/phpBB/update_to_RC1.php @@ -0,0 +1,78 @@ +<html> +<body> +<?php + +$phpbb_root_path = "./"; +include($phpbb_root_path . 'extension.inc'); +include($phpbb_root_path . 'common.'.$phpEx); + +$sql = array(); + +switch(SQL_LAYER) +{ + case 'mysql': + case 'mysql4': + $sql[] = "ALTER TABLE " . USERS_TABLE . " + ADD COLUMN user_session_time int(11) DEFAULT '0' NOT NULL, + ADD COLUMN user_session_page smallint(5) DEFAULT '0' NOT NULL, + ADD INDEX (user_session_time)"; + $sql[] = "ALTER TABLE " . SEARCH_TABLE . " + MODIFY search_id int(11) NOT NULL"; + break; + + case 'postgresql': + $sql[] = "ALTER TABLE " . USERS_TABLE . " + ADD COLUMN user_session_time int4"; + $sql[] = "ALTER TABLE " . USERS_TABLE . " + ADD COLUMN user_session_page int2"; + $sql[] = "ALTER TABLE " . USERS_TABLE . " + ALTER COLUMN user_session_time SET DEFAULT '0'"; + $sql[] = "ALTER TABLE " . USERS_TABLE . " + ALTER COLUMN user_session_page SET DEFAULT '0'"; + $sql[] = "CREATE INDEX user_session_time_" . $table_prefix . "users_index + ON " . USERS_TABLE . " (user_session_time)"; + break; + + case 'mssql-odbc': + case 'mssql': + $sql[] = "ALTER TABLE " . USERS_TABLE . " ADD + user_session_time int NOT NULL, + user_session_page smallint NOT NULL, + CONSTRAINT [DF_" . $table_prefix . "users_user_session_time] DEFAULT (0) FOR [user_session_time], + CONSTRAINT [DF_" . $table_prefix . "users_user_session_page] DEFAULT (0) FOR [user_session_page]"; + $sql[] = "CREATE INDEX [IX_" . $table_prefix . "users] + ON [" . USERS_TABLE . "]([user_session_time]) ON [PRIMARY]"; + break; + + case 'msaccess': + $sql[] = "ALTER TABLE " . USERS_TABLE . " ADD + user_session_time int NOT NULL, + user_session_page smallint NOT NULL"; + $sql[] = "CREATE INDEX user_session_time + ON " . USERS_TABLE . " (user_session_time)"; + break; + + default: + die("No DB LAYER found!"); + break; +} + + for($i = 0; $i < count($sql); $i++) + { + echo "Running :: " . $sql[$i] . "<br />\n"; + + $result = $db->sql_query($sql[$i]); + + if( !$result ) + { + $error = $db->sql_error(); + die("Failed executing statement<br />\nError :: " . $error['message'] . "<br />\nSQL :: " . $sql[$i]); + } + + } + + echo "\n<br /><br />\nCOMPLETE! Please delete this file before continuing!<br />\n"; + +?> +</body> +</html>
\ No newline at end of file |