00015-undo_ConcludedToBoolean.sql

/hippo-migrate/undo/00015-undo_ConcludedToBoolean.sql

http://hdbc.googlecode.com/
SQL | 20 lines | 15 code | 3 blank | 2 comment | 0 complexity | 540c25d08100fa587f49b5130aac23f7 MD5 | raw file

 1VARIABLE v_pk  NUMBER;
 2
 3BEGIN
 4    hippo.sp_log_version_change_begin('00015-do_ConcludedToBoolean.sql', &1, :v_pk);
 5END;
 6/
 7
 8---- ddl below ------------------------------------------
 9ALTER TABLE hippo.experiments DROP (concluded);
10ALTER TABLE hippo.experiments ADD (concluded CHAR(1) NOT NULL);
11---------------------------------------------------------
12
13BEGIN
14    hippo.sp_update_version(14);
15    hippo.sp_log_version_change_finish(:v_pk, 'success');
16EXCEPTION
17    WHEN OTHERS THEN
18        hippo.sp_log_version_change_finish(:v_pk, 'fail');
19END;
20/