✏️ 正在编辑: 199.sql
路径:
/srv/systems_dir/yuppiecred/data/database/199.sql
提示:
您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ /** * Author: Gleydson * Created: 29/03/2017 */ ALTER TABLE `tb_rotas` ADD COLUMN `valor_hospedagem` DECIMAL(15,2) NULL, ADD COLUMN `valor_refeicao` DECIMAL(15,2) NULL, ADD COLUMN `valor_combustivel` DECIMAL(15,2) NULL, ADD COLUMN `consumo_veiculo` DECIMAL(15,2) NULL; ALTER TABLE `tb_solicitacao_recurso` ADD COLUMN `rota_id` INT(11) NOT NULL AFTER `prazo`, ADD COLUMN `periodo_de` DATE NOT NULL AFTER `rota_id`, ADD COLUMN `periodo_a` DATE NOT NULL AFTER `periodo_de`; CREATE TABLE `tb_visitas_rota` ( `id` INT NOT NULL AUTO_INCREMENT, `rota_id` INT(11) NOT NULL, `corretor_id` INT(11) NOT NULL, `cidade` VARCHAR(45) NULL, `uf` VARCHAR(45) NULL , `resumo` VARCHAR(45) NULL, `data` DATE NULL, `excluido` TINYINT(4) NOT NULL DEFAULT 0, PRIMARY KEY (`id`));
💾 保存文件
← 返回文件管理器