diff options
| author | David M <davidmj@users.sourceforge.net> | 2007-06-19 15:24:40 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2007-06-19 15:24:40 +0000 |
| commit | 65442c6bdddb2f8e5329bc9c340a070f197cfc0b (patch) | |
| tree | e614b6232b4011af9bcf6615660ceb85116ba74c /phpBB/install/convertors/functions_phpbb20.php | |
| parent | 22b970ef1e5675b7e74e6a2505c9fede44ed453c (diff) | |
| download | forums-65442c6bdddb2f8e5329bc9c340a070f197cfc0b.tar forums-65442c6bdddb2f8e5329bc9c340a070f197cfc0b.tar.gz forums-65442c6bdddb2f8e5329bc9c340a070f197cfc0b.tar.bz2 forums-65442c6bdddb2f8e5329bc9c340a070f197cfc0b.tar.xz forums-65442c6bdddb2f8e5329bc9c340a070f197cfc0b.zip | |
#12555
git-svn-id: file:///svn/phpbb/trunk@7783 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/convertors/functions_phpbb20.php')
| -rw-r--r-- | phpBB/install/convertors/functions_phpbb20.php | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/phpBB/install/convertors/functions_phpbb20.php b/phpBB/install/convertors/functions_phpbb20.php index ec282c8f46..eca72b64bd 100644 --- a/phpBB/install/convertors/functions_phpbb20.php +++ b/phpBB/install/convertors/functions_phpbb20.php @@ -287,6 +287,20 @@ function phpbb_insert_forums() case 'mssql_odbc': $db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' OFF'); break; + + case 'oracle': + $result = $db->sql_query('SELECT MAX(forum_id) as max_id FROM ' . FORUMS_TABLE); + $row = $db->sql_fetchrow($result); + $db->sql_freeresult($result); + + $largest_id = (int) $row['max_id']; + + if ($largest_id) + { + $db->sql_query('DROP SEQUENCE ' . FORUMS_TABLE . '_seq'); + $db->sql_query('CREATE SEQUENCE ' . FORUMS_TABLE . '_seq START WITH ' . ($largest_id + 1)); + } + break; } } |