/hippo-migrate/do/00010-do_CreateData.sql

http://hdbc.googlecode.com/ · SQL · 25 lines · 20 code · 3 blank · 2 comment · 0 complexity · 2ac687e36983fa6ee3637aec8c911aa7 MD5 · raw file 

    

  1. VARIABLE v_pk  NUMBER;

    2. 

  2. 

    3. 

  3. BEGIN

    4. 

  4.     hippo.sp_log_version_change_begin('00010-do_CreateData.sql', &1, :v_pk);

    5. 

  5. END;

    6. 

  6. /

    7. 

  7. 

    8. 

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

    9. 

  9. CREATE TABLE hippo.data (

    10. 

  10. 	data_cd 		number CONSTRAINT pk_data PRIMARY KEY,

    11. 

  11. 	user_cd			number,

    12. 

  12. 	experiment_cd	number,

    13. 

  13. 	response		XMLType NOT NULL,

    14. 

  14. 	CONSTRAINT fk_data_to_users FOREIGN KEY (user_cd) REFERENCES hippo.users

    15. 

  15. );

    16. 

  16. ---------------------------------------------------------

    17. 

  17. 

    18. 

  18. BEGIN

    19. 

  19.     hippo.sp_update_version(10);

    20. 

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

    21. 

  21. EXCEPTION

    22. 

  22.     WHEN OTHERS THEN

    23. 

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

    24. 

  24. END;

    25. 

  25. /
    26.