-- tmpcourse table used for import from courses text files
-- drop table course.tmpcourse;
create table course.tmpcourse
(
   code           text null,
   name_en        text null,
   name_sv        text null,
   short_name     text null,
   points         text null,
   parts          text null,
   edu_area       text null,
   subject_group  text null,
   adv_level      text null,
   classification text null,
   prerequisites  text null,
   successors     text null,
   faculty        text null,
   department     text null,
   division       text null,
   subject_area   text null,
   area_manager   text null,
   leader         text null,
   examiner       text null,
   assistant      text null,
   administrator  text null,
   assistants     text null,
   edu_category   text null,
   programme      text null,
   ovf            text null,
   nr_students    text null,
   times_per_year text null,
   period         text null,
   week           text null,
   block          text null,
   pedagogy       text null,
   fo_h           text null,
   le_h           text null,
   gu_h           text null,
   ss_h           text null,
   s_h            text null,
   ovn_h          text null,
   lab_h          text null,
   examination    text null,
   ida_category   text null,
   key_sv         text null,
   key_en         text null,
   url            text null,
   system         text null,
   software       text null,
   hardware       text null,
   quota          text null,
   comment_ext    text null,
   comment_int    text null,
   expired        text null,
   replaced_by    text null,
   delimiter      text null
)
