· 8 years ago · Jan 25, 2018, 02:14 AM
1-- MySQL Script generated by MySQL Workbench
2-- Wed Jan 24 23:10:41 2018
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema cds38533_taller_mecanico
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema cds38533_taller_mecanico
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `cds38533_taller_mecanico` DEFAULT CHARACTER SET utf8 ;
18USE `cds38533_taller_mecanico` ;
19
20-- -----------------------------------------------------
21-- Table `cds38533_taller_mecanico`.`vehiculo`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `cds38533_taller_mecanico`.`vehiculo` (
24 `id_vehiculo` INT(11) NOT NULL,
25 `patente` VARCHAR(6) NOT NULL,
26 `marca` VARCHAR(45) NOT NULL,
27 `modelo` VARCHAR(45) NOT NULL,
28 `ano` INT(11) NOT NULL,
29 `km_inicial` INT(11) NOT NULL,
30 `km_actual` INT(11) NOT NULL,
31 `eliminado` TINYINT(1) NOT NULL,
32 `fecha_eliminado` DATETIME NOT NULL,
33 PRIMARY KEY (`id_vehiculo`))
34ENGINE = InnoDB
35DEFAULT CHARACTER SET = utf8;
36
37
38-- -----------------------------------------------------
39-- Table `cds38533_taller_mecanico`.`alerta`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `cds38533_taller_mecanico`.`alerta` (
42 `id_alerta` INT(11) NOT NULL,
43 `fecha_alerta` DATETIME NOT NULL,
44 `leida` TINYINT(4) NOT NULL,
45 `tipo_mantencion` VARCHAR(120) NOT NULL,
46 `id_vehiculo` INT(11) NOT NULL,
47 PRIMARY KEY (`id_alerta`, `id_vehiculo`),
48 INDEX `fk_alerta_vehiculo1_idx` (`id_vehiculo` ASC),
49 CONSTRAINT `fk_alerta_vehiculo1`
50 FOREIGN KEY (`id_vehiculo`)
51 REFERENCES `cds38533_taller_mecanico`.`vehiculo` (`id_vehiculo`)
52 ON DELETE NO ACTION
53 ON UPDATE NO ACTION)
54ENGINE = InnoDB
55DEFAULT CHARACTER SET = utf8;
56
57
58-- -----------------------------------------------------
59-- Table `cds38533_taller_mecanico`.`orden_de_trabajo`
60-- -----------------------------------------------------
61CREATE TABLE IF NOT EXISTS `cds38533_taller_mecanico`.`orden_de_trabajo` (
62 `id_orden_de_trabajo` INT(11) NOT NULL,
63 `fecha_ot` DATETIME NOT NULL,
64 `tipo_mantencion` VARCHAR(120) NOT NULL,
65 `observaciones` VARCHAR(500) NULL DEFAULT NULL,
66 `id_vehiculo` INT(11) NOT NULL,
67 PRIMARY KEY (`id_orden_de_trabajo`, `id_vehiculo`),
68 INDEX `fk_orden_de_trabajo_vehiculo1_idx` (`id_vehiculo` ASC),
69 CONSTRAINT `fk_orden_de_trabajo_vehiculo1`
70 FOREIGN KEY (`id_vehiculo`)
71 REFERENCES `cds38533_taller_mecanico`.`vehiculo` (`id_vehiculo`)
72 ON DELETE NO ACTION
73 ON UPDATE NO ACTION)
74ENGINE = InnoDB
75DEFAULT CHARACTER SET = utf8;
76
77
78-- -----------------------------------------------------
79-- Table `cds38533_taller_mecanico`.`usuario`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `cds38533_taller_mecanico`.`usuario` (
82 `id_usuario` INT(11) NOT NULL,
83 `run` VARCHAR(10) NOT NULL,
84 `nombres` VARCHAR(45) NOT NULL COMMENT ' ',
85 `apellido_p` VARCHAR(45) NOT NULL,
86 `apellido_m` VARCHAR(45) NOT NULL,
87 `email` VARCHAR(45) NOT NULL,
88 `contrasena` VARCHAR(512) NOT NULL,
89 `admin` TINYINT(4) NOT NULL,
90 `first_login` TINYINT(4) NULL DEFAULT NULL,
91 PRIMARY KEY (`id_usuario`))
92ENGINE = InnoDB
93DEFAULT CHARACTER SET = utf8;
94
95
96-- -----------------------------------------------------
97-- Table `cds38533_taller_mecanico`.`vehiculo_en_mantencion`
98-- -----------------------------------------------------
99CREATE TABLE IF NOT EXISTS `cds38533_taller_mecanico`.`vehiculo_en_mantencion` (
100 `id_vehiculo_en_mantencion` INT(11) NOT NULL,
101 `fecha_mantencion` DATETIME NOT NULL,
102 `km_mantencion` DOUBLE NOT NULL,
103 `tipo_mantencion` VARCHAR(120) NOT NULL,
104 `observacion` VARCHAR(500) NULL DEFAULT NULL,
105 `finalizado` TINYINT(1) NOT NULL,
106 `id_orden_de_trabajo` INT(11) NOT NULL,
107 PRIMARY KEY (`id_vehiculo_en_mantencion`, `id_orden_de_trabajo`),
108 INDEX `fk_vehiculo_en_mantencion_orden_de_trabajo1_idx` (`id_orden_de_trabajo` ASC),
109 CONSTRAINT `fk_vehiculo_en_mantencion_orden_de_trabajo1`
110 FOREIGN KEY (`id_orden_de_trabajo`)
111 REFERENCES `cds38533_taller_mecanico`.`orden_de_trabajo` (`id_orden_de_trabajo`)
112 ON DELETE NO ACTION
113 ON UPDATE NO ACTION)
114ENGINE = InnoDB
115DEFAULT CHARACTER SET = utf8;
116
117
118-- -----------------------------------------------------
119-- Table `cds38533_taller_mecanico`.`insumo`
120-- -----------------------------------------------------
121CREATE TABLE IF NOT EXISTS `cds38533_taller_mecanico`.`insumo` (
122 `id_insumo` INT NOT NULL AUTO_INCREMENT,
123 `nombre` VARCHAR(80) NOT NULL,
124 `especificacion` VARCHAR(180) NOT NULL,
125 PRIMARY KEY (`id_insumo`))
126ENGINE = InnoDB;
127
128
129-- -----------------------------------------------------
130-- Table `cds38533_taller_mecanico`.`insumo_mantencion`
131-- -----------------------------------------------------
132CREATE TABLE IF NOT EXISTS `cds38533_taller_mecanico`.`insumo_mantencion` (
133 `id_insumo_mantencion` INT NOT NULL AUTO_INCREMENT,
134 `insumo_id_insumo` INT NOT NULL,
135 `id_vehiculo_en_mantencion` INT(11) NOT NULL,
136 `precio_unitario` INT NOT NULL,
137 `cantidad` INT NOT NULL,
138 PRIMARY KEY (`id_insumo_mantencion`),
139 INDEX `fk_insumo_mantencion_insumo1_idx` (`insumo_id_insumo` ASC),
140 INDEX `fk_insumo_mantencion_vehiculo_en_mantencion1_idx` (`id_vehiculo_en_mantencion` ASC),
141 CONSTRAINT `fk_insumo_mantencion_insumo1`
142 FOREIGN KEY (`insumo_id_insumo`)
143 REFERENCES `cds38533_taller_mecanico`.`insumo` (`id_insumo`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION,
146 CONSTRAINT `fk_insumo_mantencion_vehiculo_en_mantencion1`
147 FOREIGN KEY (`id_vehiculo_en_mantencion`)
148 REFERENCES `cds38533_taller_mecanico`.`vehiculo_en_mantencion` (`id_vehiculo_en_mantencion`)
149 ON DELETE NO ACTION
150 ON UPDATE NO ACTION)
151ENGINE = InnoDB;
152
153INSERT INTO `usuario` (`id_usuario`, `run`, `nombres`, `apellido_p`, `apellido_m`, `email`, `contrasena`, `admin`, `first_login`) VALUES
154(1, '18870549-9', 'JAVIER ALEJANDRO', 'CASTRO', 'ANGULO', 'JAVIER.CASTRO190494@GMAIL.COM', 'effb4919e52fd7445b982935bdc576bcf80b5770dbc05fd8fd24657ace8ad34dc1d532ac5ccc4872dfe9d607c6b2cfd70e3abe0147140a2a6b8108cf2c034fa3VDM/5ftqJPyNh3ZuDTWr+MnLY9weoLdk8209g3CwdcE=', 1, 0),
155(2, '14596316-8', 'DSI', 'TEAM', 'LTDA', 'XAVYCASTROA@GMAIL.COM', 'b6c9e878ebe3d364b1f9f3c0faedf3b63e09cb40342b0f7d24bf2cb13c5fdfb3fea09c198a40b08768918a5dba031997a62a27ab1c5241ca8da5c031c95c37dfI9/8XbpbkvHDFhoZ2hSnDsxPCw2AJhNvOEEkILk5FGg=', 1, 0),
156(3, '17997902-0', 'JOHNNY ANDRéS', 'VIDAL', 'VIDAL', 'J.VIDAL2412@GMAIL.COM', 'b6c9e878ebe3d364b1f9f3c0faedf3b63e09cb40342b0f7d24bf2cb13c5fdfb3fea09c198a40b08768918a5dba031997a62a27ab1c5241ca8da5c031c95c37dfI9/8XbpbkvHDFhoZ2hSnDsxPCw2AJhNvOEEkILk5FGg=', 1, 0),
157(4, '55555550', 'JAVIER', 'ELGUETA', 'MASIAS', 'JELGUETA.MASIAS@OUTLOOK.COM', 'c3c4713187213d255785ccc4414d1a024ba2c928506b74b20e299b91c082017f98943584db9d877220defcd55b5a63588f7a840b7673fff3c713d276435b15ffs7u6QBvqvyboGrrPS9j6UQ7r5CLIPOmaIvP2xbUH9Pk=', 1, 0);
158
159
160
161SET SQL_MODE=@OLD_SQL_MODE;
162SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
163SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;