ALTER TABLE `zh_ledger_history` ADD COLUMN `bills_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '清单条数' AFTER `valid`, ADD COLUMN `pos_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '计量单元数量' AFTER `bills_count`; UPDATE `zh_tender` SET `had_map`=3 WHERE `had_map`=1; ALTER TABLE `zh_tender` ADD `map_pic` VARCHAR(255) NULL DEFAULT NULL COMMENT '静态图片地址' AFTER `had_map`;