-- Create Table Statement for 'Membership'
DROP TABLE IF EXISTS `MEMBERSHIP`;
CREATE TABLE `MEMBERSHIP` (
	ID bigint(20) NOT NULL,
	CODE varchar,
	NAME varchar,
	IS_ACTIVE tinyint(1),
	TYPE_CL varchar,
	IS_OPEN_END tinyint(1),
	INITIATION_FEE int(11),
	PAYMENT_COUNT int(11),
	DUES_AMOUNT int(11),
	RENEWAL_DUES_AMOUNT int(11),
	EXPIRATION_DAYS int(11),
	COMMISSION_PERCENT float,
	COMMISSION_DOLLAR int(11),
	DISCOUNT_OVERIDE_PERCENT float,
	DISCOUNT_DATE_START datetime,
	DISCOUNT_DATE_END datetime,
	DISCOUNT_DEFAULT_PERCENT float,
	DISCOUNT float,
	IS_EMPLOYEE_MEMBERSHIP tinyint(1),
	PAY_FIRST_MONTH tinyint(1),
	MEMBER_FEE_AT_POS tinyint(1),
	PRORATE_AT_POS tinyint(1),
	ALLOW_FREEZE tinyint(1),
	CUST_SETS_FREEZE tinyint(1),
	DAYS_BEFORE_CANCEL int(11),
	MEMBER_FEE_AT_POS_AFTER tinyint(1),
	PRORATE_AT_POS_AFTER tinyint(1),
	PAY_FIRST_MONTH_AFTER tinyint(1),
	UNFREEZE_PRORATE_AT_POS tinyint(1),
	UNFREEZE_PRORATE_AT_POS_AFTER tinyint(1),
	COMBO_ID varchar,
	MEMBERSHIP_CATEGORY varchar,
	REDEEM_POINTS tinyint(1),
	CANCELLATION_FEE int(11),
	FREEZE_FEE int(11),
	AVALAIBLE_FROM_DATE datetime,
	AVALAIBLE_TO_DATE datetime,
	IS_TAX1_APPLICABLE tinyint(1),
	IS_TAX2_APPLICABLE tinyint(1),
	IS_TAX3_APPLICABLE tinyint(1),
	IS_TAX5_APPLICABLE tinyint(1),
	IS_TAX4_APPLICABLE tinyint(1),
	LEVEL int(11),
	TERM int(11),
	CONTRACT_CL varchar,
	PRIMARY KEY ()
) ENGINE=InnoDB;