-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathquery.sql
90 lines (59 loc) · 8.58 KB
/
query.sql
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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
##Categorias
Insert into `dbApiRest`.`Categorias` (`Id_Categoria`,`Nombre_Categoria`,`Str_img`,`createdAt`,`updatedAt`)
values('1','Botiquines','asd', '2018-03-31 00:13:33','2018-03-31 00:13:33');
Insert into `dbApiRest`.`Categorias` (`Id_Categoria`,`Nombre_Categoria`,`Str_img`,`createdAt`,`updatedAt`)
values('2','Anaqueles','asd', '2018-03-31 00:13:33','2018-03-31 00:13:33');
Insert into `dbApiRest`.`Categorias` (`Id_Categoria`,`Nombre_Categoria`,`Str_img`,`createdAt`,`updatedAt`)
values('3','Cajas para dinero','asd', '2018-03-31 00:13:33','2018-03-31 00:13:33');
Insert into `dbApiRest`.`Categorias` (`Id_Categoria`,`Nombre_Categoria`,`Str_img`,`createdAt`,`updatedAt`)
values('4','Alhajeros','asd', '2018-03-31 00:13:33','2018-03-31 00:13:33');
Insert into `dbApiRest`.`Categorias` (`Id_Categoria`,`Nombre_Categoria`,`Str_img`,`createdAt`,`updatedAt`)
values('5','Guardallaves','asd', '2018-03-31 00:13:33','2018-03-31 00:13:33');
##Productos
Insert into `dbApiRest`.`Productos` (`Id_prod`,`Nombre`,`Descripcion`,`Precio`, `Stock`,`Estatus`,
`Alto`, `Largo`, `Ancho`,`createdAt`,`updatedAt`, `CategoriaIdCategoria`)
values('1','Botiquin mini','BOT', 120, 300,'A', 12,12,12,'2018-03-31 00:13:33','2018-03-31 00:13:33',1);
Insert into `dbApiRest`.`Productos` (`Id_prod`,`Nombre`,`Descripcion`,`Precio`, `Stock`,`Estatus`,
`Alto`, `Largo`, `Ancho`,`createdAt`,`updatedAt`, `CategoriaIdCategoria`)
values('2','Botiquin Med','BOT', 120, 300,'A', 12,12,12,'2018-03-31 00:13:33','2018-03-31 00:13:33',1);
Insert into `dbApiRest`.`Productos` (`Id_prod`,`Nombre`,`Descripcion`,`Precio`, `Stock`,`Estatus`,
`Alto`, `Largo`, `Ancho`,`createdAt`,`updatedAt`, `CategoriaIdCategoria`)
values('3','Botiquin Familiar','BOT', 120, 300,'A', 12,12,12,'2018-03-31 00:13:33','2018-03-31 00:13:33',1);
Insert into `dbApiRest`.`Productos` (`Id_prod`,`Nombre`,`Descripcion`,`Precio`, `Stock`,`Estatus`,
`Alto`, `Largo`, `Ancho`,`createdAt`,`updatedAt`, `CategoriaIdCategoria`)
values('4','Botiquin Industrial','BOT', 120, 300,'A', 12,12,12,'2018-03-31 00:13:33','2018-03-31 00:13:33',1);
##Colores
Insert into `dbApiRest`.`Colores` (`Id_Color`,`Nombre_Color`,`createdAt`,`updatedAt`)
values('1','Azul amartillado','2018-03-31 00:13:33','2018-03-31 00:13:33');
Insert into `dbApiRest`.`Colores` (`Id_Color`,`Nombre_Color`,`createdAt`,`updatedAt`)
values('2','Gris','2018-03-31 00:13:33','2018-03-31 00:13:33');
Insert into `dbApiRest`.`Colores` (`Id_Color`,`Nombre_Color`,`createdAt`,`updatedAt`)
values('3','Rojo','2018-03-31 00:13:33','2018-03-31 00:13:33');
Insert into `dbApiRest`.`Colores` (`Id_Color`,`Nombre_Color`,`createdAt`,`updatedAt`)
values('4','Blanco regrigerador','2018-03-31 00:13:33','2018-03-31 00:13:33');
##Clientes
INSERT INTO `dbApiRest`.`Clientes` (`RFC`, `Password`, `Nombre`, `Ap_Pat`, `Ap_Mat`, `Calle`, `Colonia`, `Numero`, `Ciudad`, `Estado`, `Cp`, `Telefono`, `Email`, `createdAt`, `updatedAt`) VALUES ('BIBJ961129HDFRRN09', '12345', 'Juan', 'Brito', 'Brito', 'Calle', 'Colonia', '1', 'Ciudad', 'CDMX', '1', '1', 'jesu291196@gmail.com', '2018-03-31 00:13:33', '2018-03-31 00:13:33');
INSERT INTO `dbApiRest`.`Clientes` (`RFC`, `Password`, `Nombre`, `Ap_Pat`, `Ap_Mat`, `Calle`, `Colonia`, `Numero`, `Ciudad`, `Estado`, `Cp`, `Telefono`, `Email`, `createdAt`, `updatedAt`) VALUES ('BIBJ961', '12345', 'Jesus', 'Brito', 'Brito', 'Calle', 'Colonia', '1', 'Ciudad', 'CDMX', '1', '1', 'jesus291196@gmail.co', '2018-03-31 00:13:33', '2018-03-31 00:13:33');
INSERT INTO `dbApiRest`.`Clientes` (`RFC`, `Password`, `Nombre`, `Ap_Pat`, `Ap_Mat`, `Calle`, `Colonia`, `Numero`, `Ciudad`, `Estado`, `Cp`, `Telefono`, `Email`, `createdAt`, `updatedAt`) VALUES ('BIBJ96', '12345', 'Juan', 'Brito', 'Brito', 'Calle', 'Colonia', '1', 'Ciudad', 'CDMX', '1', '1', 'jesus291196@gmail.c', '2018-03-31 00:13:33', '2018-03-31 00:13:33');
INSERT INTO `dbApiRest`.`Clientes` (`RFC`, `Password`, `Nombre`, `Ap_Pat`, `Ap_Mat`, `Calle`, `Colonia`, `Numero`, `Ciudad`, `Estado`, `Cp`, `Telefono`, `Email`, `createdAt`, `updatedAt`) VALUES ('BIBJ9', '12345', 'Juan', 'Brito', 'Brito', 'Calle', 'Colonia', '1', 'Ciudad', 'CDMX', '1', '1', 'jesus291196@gmail', '2018-03-31 00:13:33', '2018-03-31 00:13:33');
##Ventas
INSERT INTO `dbApiRest`.`Ventas` (`No_Venta`, `Fecha`, `Estatus`, `No_Rastreo`, `Costo_envio`, `Subtotal`, `Iva`, `Total`, `createdAt`, `updatedAt`, `ClienteRFC`) VALUES ('1', '2018-03-31 00:13:33', 'P', '12', '50', '1000', '160', '1160', '2018-03-31 00:13:33', '2018-03-31 00:13:33', 'BIBJ961129HDFRRN09');
INSERT INTO `dbApiRest`.`Ventas` (`No_Venta`, `Fecha`, `Estatus`, `No_Rastreo`, `Costo_envio`, `Subtotal`, `Iva`, `Total`, `createdAt`, `updatedAt`, `ClienteRFC`) VALUES ('2', '2018-03-31 00:13:33', 'P', '12', '50', '1000', '160', '1160', '2018-03-31 00:13:33', '2018-03-31 00:13:33', 'BIBJ961129HDFRRN09');
INSERT INTO `dbApiRest`.`Ventas` (`No_Venta`, `Fecha`, `Estatus`, `No_Rastreo`, `Costo_envio`, `Subtotal`, `Iva`, `Total`, `createdAt`, `updatedAt`, `ClienteRFC`) VALUES ('3', '2018-03-31 00:13:33', 'P', '12', '50', '1000', '160', '1160', '2018-03-31 00:13:33', '2018-03-31 00:13:33', 'BIBJ961129HDFRRN09');
INSERT INTO `dbApiRest`.`Ventas` (`No_Venta`, `Fecha`, `Estatus`, `No_Rastreo`, `Costo_envio`, `Subtotal`, `Iva`, `Total`, `createdAt`, `updatedAt`, `ClienteRFC`) VALUES ('4', '2018-04-01 00:13:33', 'P', '12', '50', '1000', '160', '1160', '2018-03-31 00:13:33', '2018-03-31 00:13:33', 'BIBJ961129HDFRRN09');
INSERT INTO `dbApiRest`.`Ventas` (`No_Venta`, `Fecha`, `Estatus`, `No_Rastreo`, `Costo_envio`, `Subtotal`, `Iva`, `Total`, `createdAt`, `updatedAt`, `ClienteRFC`) VALUES ('5', '2018-04-20 00:13:33', 'P', '12', '50', '1000', '160', '1160', '2018-03-31 00:13:33', '2018-03-31 00:13:33', 'BIBJ961129HDFRRN09');
INSERT INTO `dbApiRest`.`Ventas` (`No_Venta`, `Fecha`, `Estatus`, `No_Rastreo`, `Costo_envio`, `Subtotal`, `Iva`, `Total`, `createdAt`, `updatedAt`, `ClienteRFC`) VALUES ('6', '2018-04-30 00:13:33', 'P', '12', '50', '1000', '160', '1160', '2018-03-31 00:13:33', '2018-03-31 00:13:33', 'BIBJ961129HDFRRN09');
##Detalle venta
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('2', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '2', '2', '1');
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('3', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '2', '2', '1');
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('4', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '2', '1', '2');
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('5', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '3', '2', '2');
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('6', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '1', '3', '3');
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('7', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '3', '2', '3');
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('8', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '3', '2', '4');
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('9', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '1', '3', '5');
INSERT INTO `dbApiRest`.`Detalle_Venta` (`Id_Detalle`, `Cantidad`, `Subtotal`, `Precio`, `createdAt`, `updatedAt`, `ColoreIdColor`, `ProductoIdProd`, `VentaNoVenta`) VALUES ('10', '5', '100', '30', '2018-03-31 00:13:33', '2018-03-31 00:13:33', '3', '2', '6');
CREATE DATABASE dbApiRest;
Create user 'eComLoc'@'localhost' identified by 'juaeu¡o¡o' ;
GRANT ALL PRIVILEGES ON dbApiRest.* TO 'eComLoc'@'localhost';
FLUSH PRIVILEGES;