· 8 years ago · Dec 01, 2017, 05:28 PM
1-- MySQL Script generated by MySQL Workbench
2-- 12/01/17 11:25:21
3-- Model: New Model Version: 1.0
4SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
5SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
6SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
7
8-- -----------------------------------------------------
9-- Schema mydb
10-- -----------------------------------------------------
11CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
12USE `mydb` ;
13
14-- -----------------------------------------------------
15-- Table `mydb`.`CLIENTES`
16-- -----------------------------------------------------
17CREATE TABLE IF NOT EXISTS `mydb`.`CLIENTES` (
18 `idCliente` INT NOT NULL AUTO_INCREMENT,
19 `Nombre` VARCHAR(25) NULL,
20 `Apellido` VARCHAR(25) NULL,
21 `Direcciòn` VARCHAR(45) NULL,
22 `Correo` VARCHAR(45) NULL,
23 `Telefono` INT(8) NULL,
24 PRIMARY KEY (`idCliente`),
25 UNIQUE INDEX `idCliente_UNIQUE` (`idCliente` ASC))
26ENGINE = InnoDB;
27
28
29-- -----------------------------------------------------
30-- Table `mydb`.`LOGINS`
31-- -----------------------------------------------------
32CREATE TABLE IF NOT EXISTS `mydb`.`LOGINS` (
33 `idLogin` INT NOT NULL AUTO_INCREMENT,
34 `idCliente` INT NULL,
35 `Usuario` VARCHAR(45) NULL,
36 `Contraseña` VARCHAR(45) NULL,
37 PRIMARY KEY (`idLogin`),
38 UNIQUE INDEX `idLOGINS_UNIQUE` (`idLogin` ASC),
39 INDEX `idCliente_idx` (`idCliente` ASC),
40 CONSTRAINT `idCliente`
41 FOREIGN KEY (`idCliente`)
42 REFERENCES `mydb`.`CLIENTES` (`idCliente`)
43 ON DELETE NO ACTION
44 ON UPDATE NO ACTION)
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `mydb`.`ENVIOS`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `mydb`.`ENVIOS` (
52 `idEnvio` INT NOT NULL AUTO_INCREMENT,
53 `idCliente` INT NULL,
54 `FechaEnvio` DATE NULL,
55 `Hora` TIME NULL,
56 PRIMARY KEY (`idEnvio`),
57 UNIQUE INDEX `idEnvios_UNIQUE` (`idEnvio` ASC),
58 INDEX `idCliente_idx` (`idCliente` ASC),
59 CONSTRAINT `idCliente`
60 FOREIGN KEY (`idCliente`)
61 REFERENCES `mydb`.`CLIENTES` (`idCliente`)
62 ON DELETE NO ACTION
63 ON UPDATE NO ACTION)
64ENGINE = InnoDB;
65
66
67-- -----------------------------------------------------
68-- Table `mydb`.`CATEGORIAS`
69-- -----------------------------------------------------
70CREATE TABLE IF NOT EXISTS `mydb`.`CATEGORIAS` (
71 `idCategoria` INT NOT NULL AUTO_INCREMENT,
72 `Nombre` VARCHAR(25) NULL,
73 `Descripciòn` VARCHAR(75) NULL,
74 `Imagen` VARCHAR(20) NULL,
75 PRIMARY KEY (`idCategoria`),
76 UNIQUE INDEX `idCategoria_UNIQUE` (`idCategoria` ASC))
77ENGINE = InnoDB;
78
79
80-- -----------------------------------------------------
81-- Table `mydb`.`PRODUCTOS`
82-- -----------------------------------------------------
83CREATE TABLE IF NOT EXISTS `mydb`.`PRODUCTOS` (
84 `idProducto` INT NOT NULL AUTO_INCREMENT,
85 `idCategoria` INT NULL,
86 `Nombre` VARCHAR(25) NULL,
87 `Imagen` VARCHAR(20) NULL,
88 `Descripciòn` VARCHAR(75) NULL,
89 `Precio` DECIMAL(6) NULL,
90 PRIMARY KEY (`idProducto`),
91 UNIQUE INDEX `idProductos_UNIQUE` (`idProducto` ASC),
92 INDEX `idCategoria_idx` (`idCategoria` ASC),
93 CONSTRAINT `idCategoria`
94 FOREIGN KEY (`idCategoria`)
95 REFERENCES `mydb`.`CATEGORIAS` (`idCategoria`)
96 ON DELETE NO ACTION
97 ON UPDATE NO ACTION)
98ENGINE = InnoDB;
99
100
101-- -----------------------------------------------------
102-- Table `mydb`.`PEDIDOS`
103-- -----------------------------------------------------
104CREATE TABLE IF NOT EXISTS `mydb`.`PEDIDOS` (
105 `idPedido` INT NOT NULL AUTO_INCREMENT,
106 `idProducto` INT NULL,
107 `Cantidad` INT NULL,
108 PRIMARY KEY (`idPedido`),
109 INDEX `idProductos_idx` (`idProducto` ASC),
110 CONSTRAINT `idProductos`
111 FOREIGN KEY (`idProducto`)
112 REFERENCES `mydb`.`PRODUCTOS` (`idProducto`)
113 ON DELETE NO ACTION
114 ON UPDATE NO ACTION)
115ENGINE = InnoDB;
116
117
118-- -----------------------------------------------------
119-- Table `mydb`.`ORDENES`
120-- -----------------------------------------------------
121CREATE TABLE IF NOT EXISTS `mydb`.`ORDENES` (
122 `idOrden` INT NOT NULL AUTO_INCREMENT,
123 `idProducto` INT NULL,
124 `idCliente` INT NULL,
125 `idPedidos` INT NULL,
126 `FormaPago` VARCHAR(25) NULL,
127 `Fecha` DATE NULL,
128 `Estado` VARCHAR(15) NULL,
129 `Total` INT NULL,
130 `Cantidad` INT NULL,
131 `idEnvio` INT NULL,
132 PRIMARY KEY (`idOrden`),
133 UNIQUE INDEX `idOrdenes_UNIQUE` (`idOrden` ASC),
134 INDEX `idCliente_idx` (`idCliente` ASC),
135 INDEX `idEnvios_idx` (`idEnvio` ASC),
136 INDEX `idPedidos_idx` (`idPedidos` ASC),
137 INDEX `idProductos_idx` (`idProducto` ASC),
138 CONSTRAINT `idCliente`
139 FOREIGN KEY (`idCliente`)
140 REFERENCES `mydb`.`CLIENTES` (`idCliente`)
141 ON DELETE NO ACTION
142 ON UPDATE NO ACTION,
143 CONSTRAINT `idEnvios`
144 FOREIGN KEY (`idEnvio`)
145 REFERENCES `mydb`.`ENVIOS` (`idEnvio`)
146 ON DELETE NO ACTION
147 ON UPDATE NO ACTION,
148 CONSTRAINT `idPedidos`
149 FOREIGN KEY (`idPedidos`)
150 REFERENCES `mydb`.`PEDIDOS` (`idPedido`)
151 ON DELETE NO ACTION
152 ON UPDATE NO ACTION,
153 CONSTRAINT `idProductos`
154 FOREIGN KEY (`idProducto`)
155 REFERENCES `mydb`.`PEDIDOS` (`idProducto`)
156 ON DELETE NO ACTION
157 ON UPDATE NO ACTION)
158ENGINE = InnoDB;
159
160
161-- -----------------------------------------------------
162-- Table `mydb`.`ADMINS`
163-- -----------------------------------------------------
164CREATE TABLE IF NOT EXISTS `mydb`.`ADMINS` (
165 `idAdmin` INT NOT NULL AUTO_INCREMENT,
166 `Usuario` VARCHAR(25) NULL,
167 `Contraseña` VARCHAR(40) NULL,
168 PRIMARY KEY (`idAdmin`),
169 UNIQUE INDEX `idAdmin_UNIQUE` (`idAdmin` ASC))
170ENGINE = InnoDB;
171
172
173-- -----------------------------------------------------
174-- Table `mydb`.`PROVEEDORES`
175-- -----------------------------------------------------
176CREATE TABLE IF NOT EXISTS `mydb`.`PROVEEDORES` (
177 `idProveedor` INT NOT NULL,
178 `Nombre` VARCHAR(30) NULL,
179 `Direccion` VARCHAR(50) NULL,
180 `Telefono` INT(8) NULL,
181 `Representante` VARCHAR(85) NULL,
182 `Saldo` DECIMAL(7) NULL,
183 PRIMARY KEY (`idProveedor`))
184ENGINE = InnoDB;
185
186
187-- -----------------------------------------------------
188-- Table `mydb`.`COMPRAS`
189-- -----------------------------------------------------
190CREATE TABLE IF NOT EXISTS `mydb`.`COMPRAS` (
191 `idCompra` INT NOT NULL AUTO_INCREMENT,
192 `Factura` INT NOT NULL,
193 `idProveedor` INT NULL,
194 `idProducto` INT NULL,
195 `Cantidad` INT NULL,
196 `Precio` DECIMAL(6) NULL,
197 `Fecha` DATE NULL,
198 PRIMARY KEY (`idCompra`),
199 UNIQUE INDEX `Factura_UNIQUE` (`Factura` ASC),
200 INDEX `idProducto_idx` (`idProducto` ASC),
201 INDEX `idProveedor_idx` (`idProveedor` ASC),
202 CONSTRAINT `idProducto`
203 FOREIGN KEY (`idProducto`)
204 REFERENCES `mydb`.`PRODUCTOS` (`idProducto`)
205 ON DELETE NO ACTION
206 ON UPDATE NO ACTION,
207 CONSTRAINT `idProveedor`
208 FOREIGN KEY (`idProveedor`)
209 REFERENCES `mydb`.`PROVEEDORES` (`idProveedor`)
210 ON DELETE NO ACTION
211 ON UPDATE NO ACTION)
212ENGINE = InnoDB;
213
214
215-- -----------------------------------------------------
216-- Table `mydb`.`Existencia`
217-- -----------------------------------------------------
218CREATE TABLE IF NOT EXISTS `mydb`.`Existencia` (
219 `idProducto` INT NOT NULL,
220 `Cantidad` INT NULL,
221 PRIMARY KEY (`idProducto`),
222 CONSTRAINT `idProducto`
223 FOREIGN KEY (`idProducto`)
224 REFERENCES `mydb`.`PRODUCTOS` (`idProducto`)
225 ON DELETE NO ACTION
226 ON UPDATE NO ACTION)
227ENGINE = InnoDB;
228
229
230SET SQL_MODE=@OLD_SQL_MODE;
231SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
232SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;