-- Create Table Statement for 'Email Template'
DROP TABLE IF EXISTS `EMAIL_TEMPLATE`;
CREATE TABLE `EMAIL_TEMPLATE` (
	ID bigint(20) NOT NULL,
	TEMPLATE_CODE varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SUBJECT varchar,
	TEMPLATE_CONTENT varchar,
	SCOPE_CL varchar,
	NOTIFICATION_CODE varchar,
	NOTIFICATION_CODE varchar,
	OWNER_CL varchar,
	CONTENT_CL varchar,
	LOCALE_CL varchar,
	TEMPLATE_CODE varchar,
	NOTIFICATION_CODE varchar,
	OWNER_CL varchar,
	CONTENT_CL varchar,
	NOTIFICATION_CODE varchar,
	OWNER_CL varchar,
	CONTENT_CL varchar,
	LOCALE_CL varchar,
	MEDIUM_CL varchar,
	MEDIUM_CL varchar,
	TEMPLATE_CL varchar,
	TEMPLATE_CL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;