-- Here are the temporary tables that are being used by library-internal
-- functions. Read Tom Kyte's book if you want to understand why I'm using
-- temporary tables.

create global temporary table km_temp_questions
  (old_id integer ,
   new_id integer)   
   on commit delete rows ;

create global temporary table km_temp_object_types
  (old_id integer ,
   new_id integer)   
   on commit delete rows ;

create global temporary table km_temp_answer_options
  (old_id integer ,
   new_id integer)   
   on commit delete rows ;
