Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL Workbench Synchronization
- -- Generated: 2015-12-08 16:17
- -- Model: New Model
- -- Version: 1.0
- -- Project: Name of the project
- -- Author: EOL
- SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
- SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
- SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
- CREATE SCHEMA IF NOT EXISTS `jinak` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
- CREATE TABLE IF NOT EXISTS `jinak`.`producto_tipo` (
- `id_tipo` INT(11) NOT NULL AUTO_INCREMENT,
- `nombre` VARCHAR(45) NULL DEFAULT NULL,
- PRIMARY KEY (`id_tipo`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = utf8
- COLLATE = utf8_general_ci;
- CREATE TABLE IF NOT EXISTS `jinak`.`usuarios` (
- `id_usuario` INT(11) NOT NULL,
- `codigo` VARCHAR(45) NULL DEFAULT NULL,
- `password` VARCHAR(45) NULL DEFAULT NULL,
- `nombre` VARCHAR(45) NULL DEFAULT NULL,
- PRIMARY KEY (`id_usuario`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = utf8
- COLLATE = utf8_general_ci;
- CREATE TABLE IF NOT EXISTS `jinak`.`producto` (
- `id_producto` INT(11) NOT NULL AUTO_INCREMENT,
- `cod_producto` VARCHAR(45) NOT NULL,
- `id_tipo` INT(11) NOT NULL,
- `nombre` VARCHAR(255) NULL DEFAULT NULL,
- `precio` VARCHAR(45) NULL DEFAULT NULL,
- `cantidad` VARCHAR(45) NULL DEFAULT NULL,
- PRIMARY KEY (`id_producto`, `cod_producto`),
- INDEX `fk_producto_producto_tipo1_idx` (`id_tipo` ASC),
- CONSTRAINT `fk_producto_tipo`
- FOREIGN KEY (`id_tipo`)
- REFERENCES `jinak`.`producto_tipo` (`id_tipo`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = utf8
- COLLATE = utf8_general_ci;
- CREATE TABLE IF NOT EXISTS `jinak`.`factura` (
- `cod_factura` INT(11) NOT NULL AUTO_INCREMENT,
- `cliente` VARCHAR(45) NULL DEFAULT NULL,
- `dni` VARCHAR(45) NULL DEFAULT NULL,
- `total` VARCHAR(45) NULL DEFAULT NULL,
- `metodo` VARCHAR(45) NULL DEFAULT NULL,
- `fecha` VARCHAR(10) NULL DEFAULT NULL,
- PRIMARY KEY (`cod_factura`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = utf8
- COLLATE = utf8_general_ci;
- CREATE TABLE IF NOT EXISTS `jinak`.`factura_detalle` (
- `id_fac_detalle` INT(11) NOT NULL AUTO_INCREMENT,
- `cod_factura` INT(11) NOT NULL,
- `cod_producto` VARCHAR(45) NULL DEFAULT NULL,
- `nombre_producto` VARCHAR(255) NULL DEFAULT NULL,
- `cantidad_producto` VARCHAR(45) NULL DEFAULT NULL,
- `precio_producto` VARCHAR(45) NULL DEFAULT NULL,
- `total` VARCHAR(45) NULL DEFAULT NULL,
- PRIMARY KEY (`id_fac_detalle`),
- INDEX `fk_factura_detalle_factura1_idx` (`cod_factura` ASC),
- CONSTRAINT `fk_factura_detalle_factura1`
- FOREIGN KEY (`cod_factura`)
- REFERENCES `jinak`.`factura` (`cod_factura`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = utf8
- COLLATE = utf8_general_ci;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement