Repository navigation
Expand file tree
/
Copy pathSM1.sql
More file actions
131 lines (119 loc) · 6.06 KB
/
Copy pathSM1.sql
File metadata and controls
131 lines (119 loc) · 6.06 KB
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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
--------------------------------------------------------
-- Archivo creado - lunes-agosto-31-2020
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Table CIUDADES
--------------------------------------------------------
CREATE TABLE "TORRES"."CIUDADES"
( "CIUDADID" NUMBER(*,0),
"NOMBRECIUDAD" VARCHAR2(50 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table BENEFICIARIOS
--------------------------------------------------------
CREATE TABLE "TORRES"."BENEFICIARIOS"
( "BENEFICIARIOID" NUMBER(*,0),
"NOMBRE" VARCHAR2(75 BYTE),
"EDAD" NUMBER,
"CIUDADID" NUMBER(*,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table AYUDAS
--------------------------------------------------------
CREATE TABLE "TORRES"."AYUDAS"
( "AYUDAID" NUMBER(*,0),
"BENEFICIARIOID" NUMBER(*,0),
"MONTO" NUMBER,
"MOTIVO" VARCHAR2(25 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index SYS_C007619
--------------------------------------------------------
CREATE UNIQUE INDEX "TORRES"."SYS_C007619" ON "TORRES"."CIUDADES" ("CIUDADID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index SYS_C007622
--------------------------------------------------------
CREATE UNIQUE INDEX "TORRES"."SYS_C007622" ON "TORRES"."BENEFICIARIOS" ("BENEFICIARIOID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index SYS_C007626
--------------------------------------------------------
CREATE UNIQUE INDEX "TORRES"."SYS_C007626" ON "TORRES"."AYUDAS" ("AYUDAID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Trigger AYUDAS_TRG
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "TORRES"."AYUDAS_TRG"
BEFORE INSERT ON AYUDAS
FOR EACH ROW
BEGIN
<<COLUMN_SEQUENCES>>
BEGIN
IF INSERTING AND :NEW.AYUDAID IS NULL THEN
SELECT AYUDAS_SEQ.NEXTVAL INTO :NEW.AYUDAID FROM SYS.DUAL;
END IF;
END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "TORRES"."AYUDAS_TRG" ENABLE;
--------------------------------------------------------
-- Constraints for Table CIUDADES
--------------------------------------------------------
ALTER TABLE "TORRES"."CIUDADES" ADD PRIMARY KEY ("CIUDADID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "TORRES"."CIUDADES" MODIFY ("NOMBRECIUDAD" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table BENEFICIARIOS
--------------------------------------------------------
ALTER TABLE "TORRES"."BENEFICIARIOS" ADD PRIMARY KEY ("BENEFICIARIOID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "TORRES"."BENEFICIARIOS" MODIFY ("EDAD" NOT NULL ENABLE);
ALTER TABLE "TORRES"."BENEFICIARIOS" MODIFY ("NOMBRE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table AYUDAS
--------------------------------------------------------
ALTER TABLE "TORRES"."AYUDAS" ADD PRIMARY KEY ("AYUDAID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "TORRES"."AYUDAS" MODIFY ("MOTIVO" NOT NULL ENABLE);
ALTER TABLE "TORRES"."AYUDAS" MODIFY ("MONTO" NOT NULL ENABLE);
--------------------------------------------------------
-- Ref Constraints for Table BENEFICIARIOS
--------------------------------------------------------
ALTER TABLE "TORRES"."BENEFICIARIOS" ADD FOREIGN KEY ("CIUDADID")
REFERENCES "TORRES"."CIUDADES" ("CIUDADID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table AYUDAS
--------------------------------------------------------
ALTER TABLE "TORRES"."AYUDAS" ADD FOREIGN KEY ("BENEFICIARIOID")
REFERENCES "TORRES"."BENEFICIARIOS" ("BENEFICIARIOID") ENABLE;