编辑文件 - 227.sql

✏️ 正在编辑: 227.sql

路径: /srv/systems_dir/yuppiecred/data/database/227.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:  yuppie
 * Created: 18/07/2017
 */

CREATE TABLE `tb_esteira_contratos` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `cpf_corretor` VARCHAR(14) NOT NULL,
  `cpf_cliente` VARCHAR(14) NOT NULL,
  `nome_cliente` VARCHAR(45) NOT NULL,
  `banco` VARCHAR(20) NOT NULL,
  `anexo` VARCHAR(255) NOT NULL,
  `aprovado` TINYINT(4) NULL,
  `excluido` TINYINT(4) NULL DEFAULT 0,
  PRIMARY KEY (`id`));

ALTER TABLE `tb_esteira_contratos` 
CHANGE COLUMN `anexo` `anexo` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL ,
ADD COLUMN `valor` DECIMAL(15,2) NOT NULL AFTER `banco`;

ALTER TABLE `tb_esteira_contratos` 
ADD COLUMN `numero_proposta` VARCHAR(20) NOT NULL AFTER `aprovado`;

ALTER TABLE `tb_corretores` 
ADD COLUMN `nivel_esteira` TINYINT(3) NOT NULL DEFAULT 0 AFTER `ip`;

ALTER TABLE `tb_esteira_contratos` 
CHANGE COLUMN `cpf_corretor` `cpf_corretor` VARCHAR(14) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL ,
CHANGE COLUMN `cpf_cliente` `cpf_cliente` VARCHAR(14) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL ,
CHANGE COLUMN `nome_cliente` `nome_cliente` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL ,
CHANGE COLUMN `banco` `banco` VARCHAR(20) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL ,
CHANGE COLUMN `valor` `valor` DECIMAL(15,2) NULL ;

← 返回文件管理器