-- カラム名の変更
-- ALTER TABLE table_name RENAME COLUMN old_colname TO new_colname ;

-- リソーステーブル
ALTER TABLE GEA05	RENAME COLUMN 	ROLE	TO	        ROLES	;
ALTER TABLE GEA05	MODIFY ROLES VARCHAR2(500) ;
ALTER TABLE GEA10	RENAME COLUMN 	NAME	TO	        NAME_JA	;
ALTER TABLE GEA10	ADD ( MAILAD VARCHAR2(100) );

-- 帳票システム
ALTER TABLE GE50	RENAME COLUMN 	OUTFILE	TO	        OUT_FILE	;
ALTER TABLE GE50	RENAME COLUMN 	OUTDIR 		TO	 OUT_DIR	;
ALTER TABLE GE51	RENAME COLUMN 	TEXT	TO	        TEXT_DATA	;
ALTER TABLE GE52	RENAME COLUMN 	COLUMN_NAME	TO	    CLM 	;
ALTER TABLE GE53	RENAME COLUMN 	OUTFILE	TO	        OUT_FILE	;
ALTER TABLE GE53	RENAME COLUMN 	OUTDIR 		TO	 OUT_DIR	;
ALTER TABLE GE55	RENAME COLUMN 	HOST	TO	        HOST_ID	;
ALTER TABLE GE58	RENAME COLUMN 	COLUMN_NAME	TO	    CLM 	;

-- メールモジュール
ALTER TABLE GE30	RENAME COLUMN 	HEADER	TO	        H_TXT	;
ALTER TABLE GE30	RENAME COLUMN 	FOOTER 		TO	 F_TXT	;
ALTER TABLE GE31	RENAME COLUMN 	CONTENT	TO	        CONTENTS	;
ALTER TABLE GE32	RENAME COLUMN 	CONTENT	TO	        CONTENTS	;
ALTER TABLE GE33	RENAME COLUMN 	MEMBER	TO			ADDRESS	;
ALTER TABLE GE33	RENAME COLUMN 	NAME	TO	        NAME_JA	;
ALTER TABLE GE33	RENAME COLUMN 	NM_KBN 		TO	 KBNAME	;

-- Excel取込WK(Excel取込を使用していない場合は、テーブルが存在していない可能性があります)
ALTER TABLE WKGE52_XIN	RENAME COLUMN 	COLUMN_NAME	TO	CLM 	;
