| Index: trunk/phase3/maintenance/ora/tables.sql |
| — | — | @@ -163,7 +163,7 @@ |
| 164 | 164 | CREATE INDEX &mw_prefix.categorylinks_i01 ON &mw_prefix.categorylinks (cl_to,cl_sortkey,cl_from); |
| 165 | 165 | CREATE INDEX &mw_prefix.categorylinks_i02 ON &mw_prefix.categorylinks (cl_to,cl_timestamp); |
| 166 | 166 | |
| 167 | | -CREATE SEQUENCE category_cat_id_val; |
| | 167 | +CREATE SEQUENCE category_id_seq; |
| 168 | 168 | CREATE TABLE &mw_prefix.category ( |
| 169 | 169 | cat_id NUMBER NOT NULL, |
| 170 | 170 | cat_title VARCHAR2(255) NOT NULL, |
| Index: trunk/phase3/includes/Article.php |
| — | — | @@ -4074,7 +4074,7 @@ |
| 4075 | 4075 | } |
| 4076 | 4076 | $insertRows = array(); |
| 4077 | 4077 | foreach( $insertCats as $cat ) { |
| 4078 | | - $insertRows[] = array( 'cat_id' => $dbw->nextSequenceValue( 'category_cat_id_val' ), |
| | 4078 | + $insertRows[] = array( 'cat_id' => $dbw->nextSequenceValue( 'category_id_seq' ), |
| 4079 | 4079 | 'cat_title' => $cat ); |
| 4080 | 4080 | } |
| 4081 | 4081 | $dbw->insert( 'category', $insertRows, __METHOD__, 'IGNORE' ); |
| Index: trunk/phase3/includes/Category.php |
| — | — | @@ -246,7 +246,7 @@ |
| 247 | 247 | } else { |
| 248 | 248 | # Let's be sure that the row exists in the table. We don't need to |
| 249 | 249 | # do this if we got the row from the table in initialization! |
| 250 | | - $seqVal = $dbw->nextSequenceValue( 'category_cat_id_val' ); |
| | 250 | + $seqVal = $dbw->nextSequenceValue( 'category_id_seq' ); |
| 251 | 251 | $dbw->insert( |
| 252 | 252 | 'category', |
| 253 | 253 | array( 'cat_id' => $seqVal, |