· 6 years ago · Aug 13, 2019, 03:22 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.1.21-MariaDB - mariadb.org binary distribution
4-- Server OS: Win32
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for ventas
16DROP DATABASE IF EXISTS `ventas`;
17CREATE DATABASE IF NOT EXISTS `ventas` /*!40100 DEFAULT CHARACTER SET utf8 */;
18USE `ventas`;
19
20
21-- Dumping structure for table ventas.administrador
22DROP TABLE IF EXISTS `administrador`;
23CREATE TABLE IF NOT EXISTS `administrador` (
24 `idAdmin` int(11) NOT NULL AUTO_INCREMENT,
25 `nombreAdmin` varchar(150) NOT NULL,
26 `password` varchar(150) NOT NULL,
27 `rol` varchar(50) NOT NULL,
28 `intentos` int(11) NOT NULL DEFAULT '0',
29 `fechaCreado` date NOT NULL,
30 PRIMARY KEY (`idAdmin`)
31) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
32
33
34
35-- Data exporting was unselected.
36-- Dumping structure for table ventas.categorias
37DROP TABLE IF EXISTS `categorias`;
38CREATE TABLE IF NOT EXISTS `categorias` (
39 `idCategoria` int(11) NOT NULL AUTO_INCREMENT,
40 `nombreCategoria` varchar(50) NOT NULL,
41 PRIMARY KEY (`idCategoria`)
42) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
43
44-- OK
45-- Data exporting was unselected.
46-- Dumping structure for table ventas.provincia
47DROP TABLE IF EXISTS `provincia`;
48CREATE TABLE IF NOT EXISTS `provincia` (
49 `idProvincia` int(11) NOT NULL,
50 `nombreProvincia` varchar(50) NOT NULL,
51 PRIMARY KEY (`idProvincia`)
52) ENGINE=InnoDB DEFAULT CHARSET=utf8;
53
54
55-- Data exporting was unselected.
56-- Dumping structure for table ventas.pass
57DROP TABLE IF EXISTS `pass`;
58CREATE TABLE IF NOT EXISTS `pass` (
59 `idpass` int(11) NOT NULL AUTO_INCREMENT,
60 `password` varchar(50) NOT NULL,
61 `idAdmin` int(11) NOT NULL,
62 PRIMARY KEY (`idpass`)
63) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
64
65
66
67-- Data exporting was unselected.
68-- Dumping structure for table ventas.ciudad
69DROP TABLE IF EXISTS `ciudad`;
70CREATE TABLE IF NOT EXISTS `ciudad` (
71 `idCiudad` int(11) NOT NULL,
72 `nombreCiudad` varchar(60) NOT NULL,
73 `codPostal` int(4) NOT NULL,
74 `idProvincia` int(11) NOT NULL,
75 PRIMARY KEY (`idCiudad`),
76 KEY `codPostal` (`codPostal`),
77 KEY `FK_ciudad_provincia` (`idProvincia`),
78 CONSTRAINT `FK_ciudad_provincia` FOREIGN KEY (`idProvincia`) REFERENCES `provincia` (`idProvincia`) ON DELETE CASCADE ON UPDATE CASCADE
79) ENGINE=InnoDB DEFAULT CHARSET=utf8;
80
81
82-- Data exporting was unselected.
83-- Dumping structure for table ventas.clientes
84DROP TABLE IF EXISTS `clientes`;
85CREATE TABLE IF NOT EXISTS `clientes` (
86 `idCliente` int(11) NOT NULL AUTO_INCREMENT,
87 `nombreCliente` varchar(150) NOT NULL,
88 `apellidoCliente` varchar(150) NOT NULL,
89 `idProvincia` int(11) NOT NULL,
90 `estado` int(11) NOT NULL DEFAULT '1',
91 `usuarioCliente` varchar(50) NOT NULL,
92 `passwordCliente` varchar(50) NOT NULL,
93 `telefono` varchar(50) NOT NULL,
94 `emailCliente` varchar(50) NOT NULL,
95 `direccion` varchar(50) NOT NULL,
96 `idCiudad` int(11) NOT NULL,
97 `cuit` int(11) NOT NULL,
98 PRIMARY KEY (`idCliente`),
99 KEY `FK_clientes_provincia` (`idProvincia`),
100 KEY `FK_clientes_ciudad` (`idCiudad`),
101 CONSTRAINT `FK_clientes_ciudad` FOREIGN KEY (`idCiudad`) REFERENCES `ciudad` (`idCiudad`) ON DELETE CASCADE ON UPDATE CASCADE,
102 CONSTRAINT `FK_clientes_provincia` FOREIGN KEY (`idProvincia`) REFERENCES `provincia` (`idProvincia`) ON DELETE CASCADE ON UPDATE CASCADE
103) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
104
105
106
107-- Data exporting was unselected.
108-- Dumping structure for table ventas.proveedores
109DROP TABLE IF EXISTS `proveedores`;
110CREATE TABLE IF NOT EXISTS `proveedores` (
111 `idProveedor` int(11) NOT NULL AUTO_INCREMENT,
112 `nombreProveedor` varchar(100) NOT NULL,
113 `apellidoProveedor` varchar(100) NOT NULL,
114 `nombreEmpresa` varchar(100) DEFAULT NULL,
115 `telefonoProveedor` varchar(100) NOT NULL,
116 `direccionProveedor` varchar(100) NOT NULL,
117 `idCiudad` int(11) NOT NULL,
118 PRIMARY KEY (`idProveedor`),
119 KEY `FK_proveedores_ciudad` (`idCiudad`),
120 CONSTRAINT `FK_proveedores_ciudad` FOREIGN KEY (`idCiudad`) REFERENCES `ciudad` (`idCiudad`) ON DELETE CASCADE ON UPDATE CASCADE
121) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
122
123
124
125
126-- Data exporting was unselected.
127-- Dumping structure for table ventas.productos
128DROP TABLE IF EXISTS `productos`;
129CREATE TABLE IF NOT EXISTS `productos` (
130 `idProducto` int(11) NOT NULL AUTO_INCREMENT,
131 `nombreProducto` varchar(50) NOT NULL,
132 `idProveedor` int(11) NOT NULL,
133 `precioProducto` double NOT NULL,
134 `idCategoria` int(11) NOT NULL,
135 PRIMARY KEY (`idProducto`),
136 KEY `FK_productos_categorias` (`idCategoria`),
137 KEY `FK_productos_proveedores` (`idProveedor`),
138 CONSTRAINT `FK_productos_categorias` FOREIGN KEY (`idCategoria`) REFERENCES `categorias` (`idCategoria`) ON DELETE CASCADE ON UPDATE CASCADE,
139 CONSTRAINT `FK_productos_proveedores` FOREIGN KEY (`idProveedor`) REFERENCES `proveedores` (`idProveedor`) ON DELETE CASCADE ON UPDATE CASCADE
140) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
141
142
143
144
145-- Data exporting was unselected.
146-- Dumping structure for table ventas.detalles
147DROP TABLE IF EXISTS `detalles`;
148CREATE TABLE IF NOT EXISTS `detalles` (
149 `idDetalle` int(11) NOT NULL AUTO_INCREMENT,
150 `idCliente` int(11) NOT NULL,
151 `idProducto` int(11) NOT NULL,
152 `fechaVenta` date NOT NULL,
153 `precioVenta` double NOT NULL,
154 `cantidadKilos` int(11) NOT NULL,
155 `totalVenta` double NOT NULL,
156 `numFac` int(110) NOT NULL,
157 `tipoFactura` varchar(5) NOT NULL,
158 PRIMARY KEY (`idDetalle`),
159 KEY `FK_detalles_clientes` (`idCliente`),
160 KEY `FK_detalles_productos` (`idProducto`),
161 CONSTRAINT `FK_detalles_clientes` FOREIGN KEY (`idCliente`) REFERENCES `clientes` (`idCliente`) ON DELETE CASCADE ON UPDATE CASCADE,
162 CONSTRAINT `FK_detalles_productos` FOREIGN KEY (`idProducto`) REFERENCES `productos` (`idProducto`) ON DELETE CASCADE ON UPDATE CASCADE
163) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=latin1;
164
165-- Data exporting was unselected.
166-- Dumping structure for table ventas.factura
167DROP TABLE IF EXISTS `factura`;
168CREATE TABLE IF NOT EXISTS `factura` (
169 `idFactura` int(11) NOT NULL AUTO_INCREMENT,
170 `numFac` int(110) NOT NULL,
171 `fechaVenta` date NOT NULL,
172 `idCliente` int(11) NOT NULL,
173 `idAdmin` int(11) NOT NULL,
174 `totalVenta` double NOT NULL,
175 `tipoFactura` varchar(50) NOT NULL,
176 PRIMARY KEY (`idFactura`),
177 KEY `FK_factura_clientes` (`idCliente`),
178 KEY `FK_factura_administrador` (`idAdmin`),
179 CONSTRAINT `FK_factura_administrador` FOREIGN KEY (`idAdmin`) REFERENCES `administrador` (`idAdmin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
180 CONSTRAINT `FK_factura_clientes` FOREIGN KEY (`idCliente`) REFERENCES `clientes` (`idCliente`) ON DELETE NO ACTION ON UPDATE NO ACTION
181) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;
182
183-- Data exporting was unselected.
184-- Dumping structure for table ventas.inventario
185DROP TABLE IF EXISTS `inventario`;
186CREATE TABLE IF NOT EXISTS `inventario` (
187 `idInventario` int(11) NOT NULL AUTO_INCREMENT,
188 `cantidadIngresada` int(11) NOT NULL,
189 `precioVenta` double NOT NULL,
190 `idProducto` int(11) NOT NULL,
191 PRIMARY KEY (`idInventario`),
192 KEY `FK_inventario_productos` (`idProducto`),
193 CONSTRAINT `FK_inventario_productos` FOREIGN KEY (`idProducto`) REFERENCES `productos` (`idProducto`) ON DELETE CASCADE ON UPDATE CASCADE
194) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
195
196
197
198
199
200-- Data exporting was unselected.
201-- Dumping structure for table ventas.temp
202DROP TABLE IF EXISTS `temp`;
203CREATE TABLE IF NOT EXISTS `temp` (
204 `idTemp` int(11) NOT NULL AUTO_INCREMENT,
205 `idProducto` int(11) NOT NULL,
206 `idCliente` int(11) NOT NULL,
207 `precioVenta` double NOT NULL,
208 `cantidad` int(11) NOT NULL,
209 `iva` double NOT NULL,
210 `totalVenta` double NOT NULL,
211 `numFac` int(11) NOT NULL,
212 `fechaVenta` date NOT NULL,
213 `unidad` int(11) NOT NULL,
214 `tipoFactura` varchar(5) NOT NULL,
215 PRIMARY KEY (`idTemp`),
216 KEY `FK_temp_productos` (`idProducto`),
217 KEY `FK_temp_clientes` (`idCliente`),
218 CONSTRAINT `FK_temp_clientes` FOREIGN KEY (`idCliente`) REFERENCES `clientes` (`idCliente`) ON DELETE CASCADE ON UPDATE CASCADE,
219 CONSTRAINT `FK_temp_productos` FOREIGN KEY (`idProducto`) REFERENCES `productos` (`idProducto`) ON DELETE CASCADE ON UPDATE CASCADE
220) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
221
222-- Data exporting was unselected.
223/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
224/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
225/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;