-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathobjects.sql
More file actions
297 lines (241 loc) · 6.12 KB
/
objects.sql
File metadata and controls
297 lines (241 loc) · 6.12 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
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
create table sb_backup_log
(
bak_id number,
bak_date date,
description varchar2(500 char),
changed_tables varchar2(4000 char),
created_by number
);
/
create unique index sb_backup_log_01 on sb_backup_log (bak_id);
/
--drop sequence sq_sb_backup_log_id;
create sequence sq_sb_backup_log_id nocache order;
/
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
create table sb_query_arrays
(
a_id number,
a_order_id number,
q_seq_from_id number,
q_seq_to_id number
);
/
create unique index sb_query_arrays_01 on sb_query_arrays (a_id, a_order_id);
/
create table sb_queries
(
q_group_id number,
q_sequence_id number,
q_text clob,
q_description varchar2(1000 char)
);
/
create unique index sb_queries_01 on sb_queries (q_group_id, q_sequence_id);
/
create table sb_query_groups
(
q_id number,
qg_id number,
qg_description varchar2(1000 char)
);
/
create unique index sb_query_groups_01 on sb_query_groups (q_id);
/
create unique index sb_query_groups_02 on sb_query_groups (qg_id);
/
-------------------------------------------------------------------------------
create table sb_query_arrays_bak
(
bak_id number,
a_id number,
a_order_id number,
q_seq_from_id number,
q_seq_to_id number
);
/
create index sb_query_arrays_bak_01 on sb_query_arrays_bak (bak_id);
/
create table sb_queries_bak
(
bak_id number,
q_group_id number,
q_sequence_id number,
q_text clob,
q_description varchar2(1000 char)
);
/
create index sb_queries_bak_01 on sb_queries_bak (bak_id);
/
create table sb_query_groups_bak
(
bak_id number,
q_id number,
qg_id number,
qg_description varchar2(1000 char)
);
/
create unique index sb_query_groups_bak_01 on sb_query_groups_bak (bak_id);
/
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
create table sb_condition_arrays
(
a_id number,
a_order_id number,
c_from_id number,
c_to_id number
);
/
create unique index sb_condition_arrays_01 on sb_condition_arrays (a_id, a_order_id);
/
create table sb_conditions
(
c_id number,
c_parent_id number,
c_bounds char(1),
condition varchar2(4000 char),
description varchar2(4000 char)
);
/
create unique index sb_conditions_01 on sb_conditions (c_id);
/
-------------------------------------------------------------------------------
create table sb_condition_arrays_bak
(
bak_id number,
a_id number,
a_order_id number,
c_from_id number,
c_to_id number
);
/
create index sb_condition_arrays_bak_01 on sb_condition_arrays_bak (bak_id);
/
create table sb_conditions_bak
(
bak_id number,
c_id number,
c_parent_id number,
c_bounds char(1),
condition varchar2(4000 char),
description varchar2(4000 char)
);
/
create index sb_conditions_bak_01 on sb_conditions_bak (bak_id);
/
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
create table sb_query_tags
(
t_id number,
tag varchar2(4000 char),
tag_value varchar2(4000 char),
tag_name varchar2(100 char),
tag_description varchar2(500 char),
tag_quoted char(1 char)
);
/
create unique index sb_query_tags_01 on sb_query_tags (t_id);
/
create unique index sb_query_tags_02 on sb_query_tags (tag);
/
create table sb_query_list_tags
(
l_id number,
t_from_id number,
t_to_id number
);
/
create unique index sb_query_list_tags_01 on sb_query_list_tags (l_id, t_from_id);
/
create table sb_query_list_tag_info
(
l_id number,
list_tag varchar2(4000 char),
tag_name varchar2(100 char),
tag_description varchar2(500 char)
);
/
create unique index sb_query_list_tag_info_01 on sb_query_list_tag_info (l_id);
/
create unique index sb_query_list_tag_info_02 on sb_query_list_tag_info (list_tag);
/
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
create table sb_query_tags_bak
(
bak_id number,
t_id number,
tag varchar2(4000 char),
tag_value varchar2(4000 char),
tag_name varchar2(100 char),
tag_description varchar2(500 char),
tag_quoted char(1 char)
);
/
create index sb_query_tags_bak_01 on sb_query_tags_bak (bak_id);
/
create table sb_query_list_tags_bak
(
bak_id number,
l_id number,
t_from_id number,
t_to_id number
);
/
create index sb_query_list_tags_bak_01 on sb_query_list_tags_bak (bak_id);
/
create table sb_query_list_tag_info_bak
(
bak_id number,
l_id number,
list_tag varchar2(4000 char),
tag_name varchar2(100 char),
tag_description varchar2(500 char)
);
/
create index sb_query_list_tag_info_bak_01 on sb_query_list_tag_info_bak (bak_id);
/
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
--drop sequence sq_sb_execution_id;
create sequence sq_sb_execution_id nocache order;
/
create table sb_execution_info
(
execution_id number(18),
batch_id number,
tmp_table_drop char(1) default '1',
exec_start_date date,
exec_end_date date,
created_date date,
created_by number
);
/
create index sb_execution_info_01 on sb_execution_info (execution_id);
/
create index sb_execution_info_02 on sb_execution_info (exec_start_date);
/
create table sb_log
(
log_id number(18),
log_date date,
execution_id number(18),
code_row_number number(18),
sql_row_count number(18),
log_text varchar2(4000 char),
q_text clob
);
/
create index sb_log_01 on sb_log (execution_id);
/
create unique index sb_log_02 on sb_log (log_date, log_id);
/
--drop sequence sq_sb_log_id;
create sequence sq_sb_log_id nocache order;
/