if not EXISTS( select * from information_schema.COLUMNS where table_name = 'TTRRMEMBERPICSTAGEDETAIL')  THEN  
CREATE TABLE TTRRMEMBERPICSTAGEDETAIL
(
	trnstage_code varchar(50) NULL,
	trncourse_code varchar(100) NULL,
	company_code varchar(50) NULL,
	emp_id varchar(50) NULL,
	pic_empId varchar(50) NULL,
	pic_order integer,
	pic_type varchar(10),
	is_submit varchar(1),
  	primary key (trnstage_code,trncourse_code,company_code,emp_id,pic_empId)
);
end if;

if not EXISTS( select * from information_schema.COLUMNS where table_name = 'TTRDMEMBEREVALUATEFINAL') THEN  
CREATE TABLE TTRDMEMBEREVALUATEFINAL
(
	trnevent_code varchar(50) NULL,
	trnstage_code varchar(50) NULL,
	company_code varchar(50) NULL,
	emp_id varchar(50) NULL,
	average decimal(5,2),
	grade_type varchar(20),
	created_date datetime,
	created_by varchar(50),
	modified_date datetime,
	modified_by varchar(50),
	primary key (trnevent_code,trnstage_code,company_code,emp_id)
  	
);
end if;


ALTER TABLE TTRRTRAINSTAGE
ADD COLUMN IF NOT EXISTS storeevaldata VARCHAR(10);

ALTER TABLE TTRRTRAINSTAGE
ADD COLUMN IF NOT EXISTS evalflow VARCHAR(10);

ALTER TABLE TTRRTRAINSTAGE
ADD COLUMN IF NOT EXISTS showothersubmit VARCHAR(1);

ALTER TABLE TTRDMEMBEREVALUATE
ADD COLUMN IF NOT EXISTS pic_empId VARCHAR(50);

ALTER TABLE TTRDMEMBEREVALUATEDET
ADD COLUMN IF NOT EXISTS pic_empId VARCHAR(50);

ALTER TABLE TTRDMEMBEREVALUATEDET
DROP PRIMARY KEY;