-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy paths-06-ilap-main-triggers.sql
72 lines (66 loc) · 3.12 KB
/
s-06-ilap-main-triggers.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
--@Autor: Carlos A. Hernández A. & Mmmgo A. Moreno Guerra
--@Fecha creación: 17/Junio/2020
--@Descripción: Creación de trigger para implementar transparencia de insercio
clear screen
whenever sqlerror exit rollback
Prompt ==============================
Prompt Creando triggers en cahabdd_s1
Prompt ==============================
connect ilap_bdd/ilap_bdd@cahabdd_s1
@06-triggers/s-06-ilap-sucursal-trigger.sql
@06-triggers/s-06-ilap-cah-s1-sucursal-taller-trigger.sql
@06-triggers/s-06-ilap-cah-s1-sucursal-venta-trigger.sql
@06-triggers/s-06-ilap-laptop-trigger.sql
@06-triggers/s-06-ilap-laptop-inventario-trigger.sql
@06-triggers/s-06-ilap-historico-status-laptop-trigger.sql
@06-triggers/s-06-ilap-cah-s1-servicio-laptop-trigger.sql
@06-triggers/s-06-netmax-tipo-almacenamiento-trigger.sql
@06-triggers/s-06-netmax-tipo-monitor-trigger.sql
@06-triggers/s-06-netmax-tipo-procesador-trigger.sql
@06-triggers/s-06-netmax-tipo-tarjeta-video-trigger.sql
Prompt ==============================
Prompt Creando triggers en cahabdd_s2
Prompt ==============================
connect ilap_bdd/ilap_bdd@cahabdd_s2
@06-triggers/s-06-ilap-sucursal-trigger.sql
@06-triggers/s-06-ilap-cah-s2-sucursal-taller-trigger.sql
@06-triggers/s-06-ilap-cah-s2-sucursal-venta-trigger.sql
@06-triggers/s-06-ilap-laptop-trigger.sql
@06-triggers/s-06-ilap-laptop-inventario-trigger.sql
@06-triggers/s-06-ilap-historico-status-laptop-trigger.sql
@06-triggers/s-06-ilap-cah-s2-servicio-laptop-trigger.sql
@06-triggers/s-06-netmax-tipo-almacenamiento-trigger.sql
@06-triggers/s-06-netmax-tipo-monitor-trigger.sql
@06-triggers/s-06-netmax-tipo-procesador-trigger.sql
@06-triggers/s-06-netmax-tipo-tarjeta-video-trigger.sql
Prompt ==============================
Prompt Creando triggers en mamgbd_s1
Prompt ==============================
connect ilap_bdd/ilap_bdd@mamgbd_s1
@06-triggers/s-06-ilap-sucursal-trigger.sql
@06-triggers/s-06-ilap-mmg-s1-sucursal-taller-trigger.sql
@06-triggers/s-06-ilap-mmg-s1-sucursal-venta-trigger.sql
@06-triggers/s-06-ilap-laptop-trigger.sql
@06-triggers/s-06-ilap-laptop-inventario-trigger.sql
@06-triggers/s-06-ilap-historico-status-laptop-trigger.sql
@06-triggers/s-06-ilap-mmg-s1-servicio-laptop-trigger.sql
@06-triggers/s-06-netmax-tipo-almacenamiento-trigger.sql
@06-triggers/s-06-netmax-tipo-monitor-trigger.sql
@06-triggers/s-06-netmax-tipo-procesador-trigger.sql
@06-triggers/s-06-netmax-tipo-tarjeta-video-trigger.sql
Prompt ==============================
Prompt Creando triggers en mamgbd_s2
Prompt ==============================
connect ilap_bdd/ilap_bdd@mamgbd_s2
@06-triggers/s-06-ilap-sucursal-trigger.sql
@06-triggers/s-06-ilap-mmg-s2-sucursal-taller-trigger.sql
@06-triggers/s-06-ilap-mmg-s2-sucursal-venta-trigger.sql
@06-triggers/s-06-ilap-mmg-s2-laptop-trigger.sql
@06-triggers/s-06-ilap-laptop-inventario-trigger.sql
@06-triggers/s-06-ilap-historico-status-laptop-trigger.sql
@06-triggers/s-06-ilap-mmg-s2-servicio-laptop-trigger.sql
@06-triggers/s-06-netmax-tipo-almacenamiento-trigger.sql
@06-triggers/s-06-netmax-tipo-monitor-trigger.sql
@06-triggers/s-06-netmax-tipo-procesador-trigger.sql
@06-triggers/s-06-netmax-tipo-tarjeta-video-trigger.sql
Prompt Listo!