diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-02-12 03:02:41 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-02-12 03:02:41 +0000 |
| commit | c4de58830b6078d35faf262cb235b6f6930c0279 (patch) | |
| tree | 08d6d28116e5fa0bf74eb7b2ac01bdbd699d6f33 | |
| parent | e81fa52af2ccb91857f5712ca717c13c653ced33 (diff) | |
| download | forums-c4de58830b6078d35faf262cb235b6f6930c0279.tar forums-c4de58830b6078d35faf262cb235b6f6930c0279.tar.gz forums-c4de58830b6078d35faf262cb235b6f6930c0279.tar.bz2 forums-c4de58830b6078d35faf262cb235b6f6930c0279.tar.xz forums-c4de58830b6078d35faf262cb235b6f6930c0279.zip | |
Integrated as reqd into update_to_RC3.php
git-svn-id: file:///svn/phpbb/trunk@2097 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/update_to_RC1.php | 104 |
1 files changed, 0 insertions, 104 deletions
diff --git a/phpBB/update_to_RC1.php b/phpBB/update_to_RC1.php deleted file mode 100644 index 96830b5241..0000000000 --- a/phpBB/update_to_RC1.php +++ /dev/null @@ -1,104 +0,0 @@ -<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"; - $sql[] = "ALTER TABLE " . TOPICS_TABLE . " - MODIFY topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL"; - $sql[] = "UPDATE " . THEMES_TABLE . " - SET head_stylesheet = 'subSilver.css' - WHERE template_name = 'subSilver'"; - 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)"; - $sql[] = "UPDATE " . THEMES_TABLE . " - SET head_stylesheet = 'subSilver.css' - WHERE template_name = 'subSilver'"; - 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]"; - $sql[] = "UPDATE " . THEMES_TABLE . " - SET head_stylesheet = 'subSilver.css' - WHERE template_name = 'subSilver'"; - 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)"; - $sql[] = "UPDATE " . THEMES_TABLE . " - SET head_stylesheet = 'subSilver.css' - WHERE template_name = 'subSilver'"; - break; - - default: - die("No DB LAYER found!"); - break; -} - - $errored = false; - for($i = 0; $i < count($sql); $i++) - { - echo "Running >>> " . $sql[$i]; - - $result = $db->sql_query($sql[$i]); - - if( !$result ) - { - $errored = true; - $error = $db->sql_error(); - echo " :: <b>FAILED</b> <u>( " . $error['message'] . " )</u><br /><br />\n\n"; - } - else - { - echo " :: <b>COMPLETED</b><br /><br />\n\n"; - } - } - - if( $errored ) - { - echo "\n<br /><br />Errors occured! Please check and correct issues as required<br />\n"; - } - else - { - echo "\n<br /><br />\nCOMPLETE! Please delete this file before continuing!<br />\n"; - } - -?> -</body> -</html>
\ No newline at end of file |