#38 10-24 新增表-- http://47.122.19.251:9999/project/panel/1

  CREATE TABLE `scp_org_email_setting` (    
   `ORGANIZATION_EMAIL_ID` varchar(64) NOT NULL COMMENT 'id',
   `REL_TENANT_ID` bigint(20) DEFAULT NULL COMMENT '多租户id',
    `ORG_CODE` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '机构编码', 
    `ORG_SETTING_ID` varchar(64) NOT NULL,
    `EMAIL_NAME` varchar(255) DEFAULT NULL COMMENT '邮箱名称', 
    `SMTP_PORT` int(11) DEFAULT '25' COMMENT '端口',
    `SMTP` varchar(255) DEFAULT NULL COMMENT 'SMTP', 
    `ORG_COUNT` bigint(1) DEFAULT NULL COMMENT '企业邮箱每日总发送上限',
    `USER_COUNT` bigint(1) DEFAULT NULL COMMENT '企业邮箱每人每日发送上限',
    `CREATE_BY` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '录入人',
    `CREATE_DATE` datetime DEFAULT NULL COMMENT '录入时间',
    `UPDATE_BY` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '更新人',
    `UPDATE_DATE` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
     PRIMARY KEY (`ORGANIZATION_EMAIL_ID`)

} ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='企业邮箱基础配置';

ALTER TABLE srp_accounts ADD COLUMN VALUE_GRADE varchar(100) DEFAULT NULL COMMENT '客户价值等级'; ALTER TABLE srp_accounts ADD COLUMN EMAIL_STATE varchar(20) DEFAULT NULL COMMENT '邮箱校验结果';