ALTER TABLE `company_field` ADD COLUMN `isp_id` bigint(20) DEFAULT NULL;
|
ALTER TABLE `company_field` ADD COLUMN `hosting_id` bigint(20) DEFAULT NULL;
|
|
ALTER TABLE `company_field` ADD INDEX `ispIdIndex`(`isp_id`);
|
ALTER TABLE `company_field` ADD INDEX `hostingIdIndex`(`hosting_id`);
|
|
CREATE TABLE `email_template`(
|
`id` BIGINT(11) AUTO_INCREMENT,
|
`title` VARCHAR (255) NOT NULL,
|
`template` mediumtext NOT NULL,
|
`register_id` BIGINT(20) NOT NULL,
|
`register_date` TIMESTAMP NULL,
|
`modify_id` BIGINT(20) NOT NULL,
|
`modify_date` TIMESTAMP NULL,
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
