/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 

    

  1. VARIABLE v_pk  NUMBER;

    2. 

  2. 

    3. 

  3. BEGIN

    4. 

  4.     hippo.sp_log_version_change_begin('00015-do_ConcludedToBoolean.sql', &1, :v_pk);

    5. 

  5. END;

    6. 

  6. /

    7. 

  7. 

    8. 

  8. ---- ddl below ------------------------------------------

    9. 

  9. ALTER TABLE hippo.experiments DROP (concluded);

    10. 

  10. ALTER TABLE hippo.experiments ADD (concluded CHAR(1) NOT NULL);

    11. 

  11. ---------------------------------------------------------

    12. 

  12. 

    13. 

  13. BEGIN

    14. 

  14.     hippo.sp_update_version(14);

    15. 

  15.     hippo.sp_log_version_change_finish(:v_pk, 'success');

    16. 

  16. EXCEPTION

    17. 

  17.     WHEN OTHERS THEN

    18. 

  18.         hippo.sp_log_version_change_finish(:v_pk, 'fail');

    19. 

  19. END;

    20. 

  20. /
    21.