-- Create Table Statement for 'Merchant Announcement'
DROP TABLE IF EXISTS `IAPP_MERCHANT_ANNOUNCEMENT`;
CREATE TABLE `IAPP_MERCHANT_ANNOUNCEMENT` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	BEGIN_DATE datetime,
	END_DATE datetime,
	PRIORITY int(11),
	PORTFOLIO_CODE int(11),
	DESCRIPTION varchar,
	MERCHANTS_FK int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;