alter table members_courses add column mem_course_no serial;
alter table members_courses drop constraint members_courses_mem_no_course_no_pkey;
alter table members_courses add constraint members_courses_mem_course_no_pkey PRIMARY KEY (mem_course_no);