/hippo-migrate/do/00008-do_CreateExperiments.sql

http://hdbc.googlecode.com/ · SQL · 26 lines · 21 code · 3 blank · 2 comment · 0 complexity · 8c1a487c1e3f518234fc3a525ec9aac0 MD5 · raw file 

    

  1. VARIABLE v_pk  NUMBER;

    2. 

  2. 

    3. 

  3. BEGIN

    4. 

  4.     hippo.sp_log_version_change_begin('00008-do_CreateExperiments.sql', &1, :v_pk);

    5. 

  5. END;

    6. 

  6. /

    7. 

  7. 

    8. 

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

    9. 

  9. CREATE TABLE hippo.experiments(

    10. 

  10. 	experiment_cd 		number CONSTRAINT pk_experiments PRIMARY KEY,

    11. 

  11. 	type 				varchar2(16 char),

    12. 

  12. 	title				varchar2(64 char) NOT NULL,

    13. 

  13. 	purpose				varchar2(128 char) NOT NULL,

    14. 

  14. 	method				varchar2(4000 char),

    15. 

  15. 	conclusion			varchar2(4000 char)

    16. 

  16. );

    17. 

  17. ---------------------------------------------------------

    18. 

  18. 

    19. 

  19. BEGIN

    20. 

  20.     hippo.sp_update_version(8);

    21. 

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

    22. 

  22. EXCEPTION

    23. 

  23.     WHEN OTHERS THEN

    24. 

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

    25. 

  25. END;

    26. 

  26. /
    27.