First-Java-Project/EjercicioCarros4255.sql at main · LuisC111/First-Java-Project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
CREATE DATABASE `ejerciciocarros4255`;
USE `ejerciciocarros`;
CREATE TABLE `categoria` (
  `CATID` int(11) NOT NULL AUTO_INCREMENT,
  `CATIPO` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`CATID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `datospersonales` (
  `DATID` int(11) NOT NULL AUTO_INCREMENT,
  `USUID` int(11) DEFAULT NULL,
  `DATNOMBRE` varchar(50) DEFAULT NULL,
  `DATAPELLIDO` varchar(50) DEFAULT NULL,
  `DATIPOID` varchar(20) DEFAULT NULL,
  `DATNUMEROID` varchar(20) DEFAULT NULL,
  `DATELEFONO` varchar(20) DEFAULT NULL,
  `DATCORREO` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`DATID`),
  KEY `FK_RELATIONSHIP_1` (`USUID`),
  CONSTRAINT `FK_RELATIONSHIP_1` FOREIGN KEY (`USUID`) REFERENCES `usuario` (`USUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `rol` (
  `ROLID` int(11) NOT NULL AUTO_INCREMENT,
  `ROLTIPO` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ROLID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

CREATE TABLE `usuario` (
  `USUID` int(11) NOT NULL AUTO_INCREMENT,
  `USULOGIN` varchar(20) DEFAULT NULL unique,
  `USUPASSWORD` varchar(20) DEFAULT NULL unique,
  PRIMARY KEY (`USUID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

CREATE TABLE `usuario_rol` (
  `ROLID` int(11) NOT NULL,
  `USUID` int(11) NOT NULL,
  PRIMARY KEY (`ROLID`,`USUID`),
  KEY `FK_RELATIONSHIP_2` (`USUID`),
  CONSTRAINT `FK_RELATIONSHIP_2` FOREIGN KEY (`USUID`) REFERENCES `usuario` (`USUID`),
  CONSTRAINT `FK_RELATIONSHIP_3` FOREIGN KEY (`ROLID`) REFERENCES `rol` (`ROLID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `vehiculo` (
  `VEHPLACA` varchar(10) NOT NULL,
  `DATID` int(11) DEFAULT NULL,
  `CATID` int(11) DEFAULT NULL,
  `VEHMODELO` int(11) DEFAULT NULL,
  `VEHMARCA` varchar(50) DEFAULT NULL,
  `VEHESTADO` varchar(30) DEFAULT NULL,
  `VEHPRECIO` int(11) DEFAULT NULL,
  PRIMARY KEY (`VEHPLACA`),
  KEY `FK_REFERENCE_5` (`CATID`),
  KEY `FK_REFERENCE_6` (`DATID`),
  CONSTRAINT `FK_REFERENCE_5` FOREIGN KEY (`CATID`) REFERENCES `categoria` (`CATID`),
  CONSTRAINT `FK_REFERENCE_6` FOREIGN KEY (`DATID`) REFERENCES `datospersonales` (`DATID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


insert rol values (default,"Administrador"),
(default,"Comprador"),
(default,"Vendedor");