<?php
class CampaignProfileTable extends Table
{

	const C_TABLE                       = "CAMPAIGN_PROFILE";
	const C_ID                          = "CAMPAIGN_PROFILE_ID";
	const C_PK              			= "CAMPAIGN_PROFILE_ID";
	const C_CODE              			= "CAMPAIGN_PROFILE_CODE";
	const C_NAME                        = "CAMPAIGN_PROFILE_NAME";
	const C_URL                         = "CAMPAIGN_PROFILE_URL";
	const C_LOGO_PATH                   = "CAMPAIGN_PROFILE_LOGO_PATH";
	const C_SIGNATURE_PATH              = "CAMPAIGN_PROFILE_SIGNATURE_PATH";
	const C_STATUS                      = "CAMPAIGN_PROFILE_STATUS";

	const C_MAIL_SERVER                 = "CAMPAIGN_PROFILE_EMAIL_SERVER";
	const C_MAIL_PORT                   = "CAMPAIGN_PROFILE_EMAIL_SERVER_PORT";
	const C_MAIL_SENDER                 = "CAMPAIGN_PROFILE_EMAIL_SERVER_SENDER";
	const C_MAIL_PASSWORD               = "CAMPAIGN_PROFILE_EMAIL_SERVER_PASSWORD";
	const C_MAIL_EA                     = "CAMPAIGN_PROFILE_EMAIL_SERVER_EA";
	const C_MAIL_SSL                    = "CAMPAIGN_PROFILE_EMAIL_SERVER_SSL";
	const C_MAIL_OAUTH                  = "CAMPAIGN_PROFILE_EMAIL_SERVER_OAUTH";
	const C_MAIL_TENANT_ID              = "CAMPAIGN_PROFILE_EMAIL_SERVER_TENANT_ID";
}

class CampaignProfileTableDetail extends TableDetail
{
	const C_ID                          = "identity||NO|";
	const C_CODE                        = "nvarchar|100|NO|''";
	const C_NAME                        = "nvarchar|255|NO|''";
	const C_URL                         = "nvarchar|255|NO|''";
	const C_LOGO_PATH                   = "nvarchar|255|NO|''";
	const C_SIGNATURE_PATH                   = "nvarchar|255|NO|''";
	const C_STATUS                      = "int||NO|(0)";

	const C_MAIL_SERVER                 = "nvarchar|100|NO|''";
	const C_MAIL_PORT                   = "nvarchar|100|NO|''";
	const C_MAIL_SENDER                 = "nvarchar|100|NO|''";
	const C_MAIL_PASSWORD               = "nvarchar|100|NO|''";
	const C_MAIL_EA                     = "int||NO|(0)";
	const C_MAIL_SSL                    = "int||NO|(0)";
	const C_MAIL_OAUTH                  = "nvarchar|50|NO|'NO'";
	const C_MAIL_TENANT_ID              = "nvarchar|100|NO|''";
}

class CampaignProfileTableDescription extends TableDescription
{
	const C_ID                          = "Campaign Profile ID";
	const C_CODE                        = "Campaign Profile Code";
	const C_NAME                        = "Campaign Profile Name";
	const C_URL                         = "Campaign Profile Url";
	const C_LOGO_PATH                   = "Campaign Profile Logo Path";
	const C_SIGNATURE_PATH              = "Campaign Profile Signature Path";
	const C_STATUS                      = "Campaign Profile Status";
	
	const C_MAIL_SERVER                 = "Mail Server";
	const C_MAIL_PORT                   = "Mail Port";
	const C_MAIL_SENDER                 = "Mail Sender";
	const C_MAIL_PASSWORD               = "Mail Password";
	const C_MAIL_EA                     = "Mail EA";
	const C_MAIL_SSL                    = "Mail SSL";
	const C_MAIL_OAUTH                  = "Mail OAuth";
	const C_MAIL_TENANT_ID              = "Mail Tenant ID";
}
