-- Create Table Statement for 'Provider Account'
DROP TABLE IF EXISTS `PROVIDER_ACCOUNT`;
CREATE TABLE `PROVIDER_ACCOUNT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	NAME varchar,
	USERNAME varchar,
	PASSWORD varchar,
	OLD_PASSWORD varchar,
	FTP_HOST varchar,
	FTP_PORT int(11),
	INBOX varchar,
	OUTBOX varchar,
	HTTP_HOST varchar,
	HTTP_PORT int(11),
	PRIMARY_CONNECTION_TYPE varchar,
	SECONDARY_CONNECTION_TYPE varchar,
	PASSWORD_EXPIRATION_PERIOD int(11),
	PASSWORD_EXPIRATION_DATE datetime,
	PASSWORD_CHANGE_DATE datetime,
	IS_CHANGED tinyint(1),
	ENCRYPTION_PUBLIC_KEY_FILE_NAME varchar,
	ENCRYPTION_PRIVATE_KEY_FILE_NAME varchar,
	ENCRYPTION_PASS_PHRASE varchar,
	ENCRYPTION_EXPIRATION_DATE datetime,
	SSH_PRIVATE_KEY_FILE_NAME varchar,
	SSH_PASS_PHRASE varchar,
	ARCHIVE_PASSWORD varchar,
	SMTP_HOST varchar,
	SMTP_PORT int(11),
	SMTP_ENCRYPTION_CL varchar,
	SMTP_USERNAME varchar,
	SMTP_PASSWORD varchar,
	SMTP_FROM varchar,
	SMTP_TO varchar,
	SSL_CERTIFICATE_FILE_NAME varchar,
	SSL_PASSWORD varchar,
	ALTERNATIVE_CONNECTION_TYPE varchar,
	ALTERNATIVE_HTTP_HOST varchar,
	ALTERNATIVE_HTTP_PORT int(11),
	HTTP_HOST_BACKUP varchar,
	HTTP_PORT_BACKUP int(11),
	ALTERNATIVE_HTTP_HOST_BACKUP varchar,
	ALTERNATIVE_HTTP_PORT_BACKUP int(11),
	FILE_STORE_FK bigint(20),
	SSL_ALIAS varchar,
	SECONDARY_SSL_CERTIFICATE_FILE_NAME varchar,
	SECONDARY_SSL_PASSWORD varchar,
	SECONDARY_SSL_ALIAS varchar,
	HTTP_HOST varchar,
	HTTP_HOST varchar,
	SSL_ALIAS varchar,
	SECONDARY_SSL_CERTIFICATE_FILE_NAME varchar,
	SECONDARY_SSL_PASSWORD varchar,
	SECONDARY_SSL_ALIAS varchar,
	SSL_ALIAS varchar,
	SECONDARY_SSL_CERTIFICATE_FILE_NAME varchar,
	SECONDARY_SSL_PASSWORD varchar,
	SECONDARY_SSL_ALIAS varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;