View | Details | Raw Unified | Return to bug 8252 | Differences between
and this patch

Collapse All | Expand All

(-)a/dbscripts/xml/upgrade/2.4.0_preupdate_reviewrounds.xml (-5 / +1 lines)
 Lines 18-27    Link Here 
18
		</query>
18
		</query>
19
		<query driver="postgres7">
19
		<query driver="postgres7">
20
			DROP INDEX review_rounds_pkey;
20
			DROP INDEX review_rounds_pkey;
21
			ALTER TABLE review_rounds ADD review_round_id INT;
21
			ALTER TABLE review_rounds ADD review_round_id SERIAL;
22
			CREATE SEQUENCE review_rounds_review_round_id_seq_tmp;<!-- _tmp to avoid name clash when table is recreated by ADODB -->
23
			ALTER TABLE review_rounds ALTER COLUMN review_round_id SET DEFAULT NEXTVAL('review_rounds_review_round_id_seq_tmp');
24
			UPDATE review_rounds SET review_round_id = NEXTVAL('review_rounds_review_round_id_seq_tmp');
25
			ALTER TABLE review_rounds ADD PRIMARY KEY (review_round_id);
22
			ALTER TABLE review_rounds ADD PRIMARY KEY (review_round_id);
26
		</query>
23
		</query>
27
	</sql>
24
	</sql>
28
- 

Return to bug 8252