Advertisement
DevMakoto

JINAK

Dec 8th, 2015
324
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.89 KB | None | 0 0
  1. -- MySQL Workbench Synchronization
  2. -- Generated: 2015-12-08 16:17
  3. -- Model: New Model
  4. -- Version: 1.0
  5. -- Project: Name of the project
  6. -- Author: EOL
  7.  
  8. SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  9. SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  10. SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
  11.  
  12. CREATE SCHEMA IF NOT EXISTS `jinak` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
  13.  
  14. CREATE TABLE IF NOT EXISTS `jinak`.`producto_tipo` (
  15.   `id_tipo` INT(11) NOT NULL AUTO_INCREMENT,
  16.   `nombre` VARCHAR(45) NULL DEFAULT NULL,
  17.   PRIMARY KEY (`id_tipo`))
  18. ENGINE = InnoDB
  19. DEFAULT CHARACTER SET = utf8
  20. COLLATE = utf8_general_ci;
  21.  
  22. CREATE TABLE IF NOT EXISTS `jinak`.`usuarios` (
  23.   `id_usuario` INT(11) NOT NULL,
  24.   `codigo` VARCHAR(45) NULL DEFAULT NULL,
  25.   `password` VARCHAR(45) NULL DEFAULT NULL,
  26.   `nombre` VARCHAR(45) NULL DEFAULT NULL,
  27.   PRIMARY KEY (`id_usuario`))
  28. ENGINE = InnoDB
  29. DEFAULT CHARACTER SET = utf8
  30. COLLATE = utf8_general_ci;
  31.  
  32. CREATE TABLE IF NOT EXISTS `jinak`.`producto` (
  33.   `id_producto` INT(11) NOT NULL AUTO_INCREMENT,
  34.   `cod_producto` VARCHAR(45) NOT NULL,
  35.   `id_tipo` INT(11) NOT NULL,
  36.   `nombre` VARCHAR(255) NULL DEFAULT NULL,
  37.   `precio` VARCHAR(45) NULL DEFAULT NULL,
  38.   `cantidad` VARCHAR(45) NULL DEFAULT NULL,
  39.   PRIMARY KEY (`id_producto`, `cod_producto`),
  40.   INDEX `fk_producto_producto_tipo1_idx` (`id_tipo` ASC),
  41.   CONSTRAINT `fk_producto_tipo`
  42.     FOREIGN KEY (`id_tipo`)
  43.     REFERENCES `jinak`.`producto_tipo` (`id_tipo`)
  44.     ON DELETE NO ACTION
  45.     ON UPDATE NO ACTION)
  46. ENGINE = InnoDB
  47. DEFAULT CHARACTER SET = utf8
  48. COLLATE = utf8_general_ci;
  49.  
  50. CREATE TABLE IF NOT EXISTS `jinak`.`factura` (
  51.   `cod_factura` INT(11) NOT NULL AUTO_INCREMENT,
  52.   `cliente` VARCHAR(45) NULL DEFAULT NULL,
  53.   `dni` VARCHAR(45) NULL DEFAULT NULL,
  54.   `total` VARCHAR(45) NULL DEFAULT NULL,
  55.   `metodo` VARCHAR(45) NULL DEFAULT NULL,
  56.   `fecha` VARCHAR(10) NULL DEFAULT NULL,
  57.   PRIMARY KEY (`cod_factura`))
  58. ENGINE = InnoDB
  59. DEFAULT CHARACTER SET = utf8
  60. COLLATE = utf8_general_ci;
  61.  
  62. CREATE TABLE IF NOT EXISTS `jinak`.`factura_detalle` (
  63.   `id_fac_detalle` INT(11) NOT NULL AUTO_INCREMENT,
  64.   `cod_factura` INT(11) NOT NULL,
  65.   `cod_producto` VARCHAR(45) NULL DEFAULT NULL,
  66.   `nombre_producto` VARCHAR(255) NULL DEFAULT NULL,
  67.   `cantidad_producto` VARCHAR(45) NULL DEFAULT NULL,
  68.   `precio_producto` VARCHAR(45) NULL DEFAULT NULL,
  69.   `total` VARCHAR(45) NULL DEFAULT NULL,
  70.   PRIMARY KEY (`id_fac_detalle`),
  71.   INDEX `fk_factura_detalle_factura1_idx` (`cod_factura` ASC),
  72.   CONSTRAINT `fk_factura_detalle_factura1`
  73.     FOREIGN KEY (`cod_factura`)
  74.     REFERENCES `jinak`.`factura` (`cod_factura`)
  75.     ON DELETE NO ACTION
  76.     ON UPDATE NO ACTION)
  77. ENGINE = InnoDB
  78. DEFAULT CHARACTER SET = utf8
  79. COLLATE = utf8_general_ci;
  80.  
  81.  
  82. SET SQL_MODE=@OLD_SQL_MODE;
  83. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  84. SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement