XRmNrV0j

1USE dbquebec;
2
3-- -----------------------------------------------------
4-- Table `tbtipofrete`
5-- -----------------------------------------------------
6CREATE TABLE IF NOT EXISTS `tbtipofrete` (
7  `dfid_tipofrete` INT(11) NOT NULL AUTO_INCREMENT,
8  `dfdescricao` VARCHAR(45) NULL DEFAULT NULL,
9  PRIMARY KEY (`dfid_tipofrete`))
10ENGINE = MyISAM
11DEFAULT CHARACTER SET = latin1;
12
13
14-- -----------------------------------------------------
15-- Table `tbfrete`
16-- -----------------------------------------------------
17CREATE TABLE IF NOT EXISTS `tbfrete` (
18  `dfid_frete` INT NOT NULL AUTO_INCREMENT,
19  `dfdescricao` VARCHAR(45) NULL,
20  `dfgris` DECIMAL(10,2) NULL,
21  `dfgrisminimo` DECIMAL(10,2) NULL,
22  `dfseguro` DECIMAL(10,2) NULL,
23  `dfsegurominimo` DECIMAL(10,2) NULL,
24  PRIMARY KEY (`dfid_frete`))
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `tbfaixafrete`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `tbfaixafrete` (
32  `dfid_faixafrete` INT(11) NOT NULL AUTO_INCREMENT,
33  `dffaixa_valor_ini` DECIMAL(10,2) NULL DEFAULT NULL,
34  `dffaixa_valor_fim` DECIMAL(10,2) NULL DEFAULT NULL,
35  `dfvlr_min_entrega` DECIMAL(10,2) NULL DEFAULT NULL,
36  `dfvlr_fator` DECIMAL(10,2) NULL DEFAULT NULL,
37  `dfid_tipofrete` INT(11) NOT NULL,
38  `dfid_frete` INT NOT NULL,
39  `dfexcedente` INT NULL,
40  PRIMARY KEY (`dfid_faixafrete`))
41ENGINE = MyISAM
42DEFAULT CHARACTER SET = latin1;