[SQL]ALTER TABLE `fqq_official`.`boc_contract`
ADD COLUMN `city_id` int(11) NULL AFTER `status`,
ADD COLUMN `tem_id` int(11) NULL AFTER `city_id`,
ADD COLUMN `appointment_id` int(11) UNSIGNED NULL COMMENT '预约id' AFTER `tem_id`,
ADD COLUMN `photo` varchar(255) NULL AFTER `appointment_id`,
ADD COLUMN `video` varchar(255) NULL AFTER `photo`,
ADD COLUMN `sign` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否签署' AFTER `photo`,
ADD COLUMN `md5` varchar(255) CHARACTER SET utf8 NULL DEFAULT NULL AFTER `sign`,
ADD COLUMN `contractNo` int(11) NULL COMMENT '合同编号' AFTER `md5`,
ADD COLUMN `deal_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '成交总价万元' AFTER `contractNo`,
ADD COLUMN `intermediary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '总服务费' AFTER `deal_price`,
ADD COLUMN `certificates` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '办证费' AFTER `intermediary`,
ADD COLUMN `mortgage` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '按揭费' AFTER `certificates`,
ADD COLUMN `sprice` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '服务费' AFTER `mortgage`,
ADD COLUMN `has_update` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '合同内容是否有修改0已修改' AFTER `sprice`,
ADD COLUMN `filename2` varchar(50) NULL COMMENT '审核文件路径' AFTER `has_update`;
受影响的行: 0
时间: 0.070s
[SQL]
ALTER TABLE `fqq_official`.`boc_contract_log`
ADD COLUMN `filename` varchar(255) NULL AFTER `timeline`,
ADD COLUMN `md5` varchar(255) NULL AFTER `filename`,
ADD COLUMN `deal_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '成交总价万元' AFTER `md5`,
ADD COLUMN `intermediary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '办证费' AFTER `deal_price`,
ADD COLUMN `mortgage` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '按揭费' AFTER `intermediary`,
ADD COLUMN `sprice` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '服务费' AFTER `mortgage`;
受影响的行: 0
时间: 0.042s
[SQL]
ALTER TABLE `fqq_official`.`boc_director`
ADD COLUMN `contract_check` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '合同是否需要审核0不需要1需要' AFTER `is_two_agency`;
受影响的行: 0
时间: 0.040s
[SQL]
UPDATE boc_contract SET contractNo = id+0056122;
受影响的行: 314
时间: 0.064s
[SQL]
CREATE TABLE `boc_contract_tem` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`city_id` int(11) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL COMMENT '合同名',
`version` varchar(255) NOT NULL COMMENT '版本号',
`created_at` int(11) DEFAULT NULL,
`updated_at` int(11) DEFAULT NULL,
`audit` tinyint(1) DEFAULT NULL COMMENT '0未审核1审核2拒绝9作废',
`filename` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
受影响的行: 0
时间: 0.012s