| Line 1... |
Line 1... |
| 1 |
--------------------------------------------------------
|
1 |
--------------------------------------------------------
|
| 2 |
-- File created - Wednesday-April-30-2014
|
2 |
-- File created - Tuesday-June-03-2014
|
| 3 |
--------------------------------------------------------
|
3 |
--------------------------------------------------------
|
| 4 |
--------------------------------------------------------
|
4 |
--------------------------------------------------------
|
| 5 |
-- DDL for Type RELMGR_NUMBER_TAB_T
|
5 |
-- DDL for Type RELMGR_NUMBER_TAB_T
|
| 6 |
--------------------------------------------------------
|
6 |
--------------------------------------------------------
|
| 7 |
|
7 |
|
| Line 37... |
Line 37... |
| 37 |
/
|
37 |
/
|
| 38 |
--------------------------------------------------------
|
38 |
--------------------------------------------------------
|
| 39 |
-- DDL for Sequence SEQ_ADDITIONAL_NOTES
|
39 |
-- DDL for Sequence SEQ_ADDITIONAL_NOTES
|
| 40 |
--------------------------------------------------------
|
40 |
--------------------------------------------------------
|
| 41 |
|
41 |
|
| 42 |
CREATE SEQUENCE "SEQ_ADDITIONAL_NOTES" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 34609 CACHE 20 ORDER NOCYCLE ;
|
42 |
CREATE SEQUENCE "SEQ_ADDITIONAL_NOTES" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 35029 CACHE 20 ORDER NOCYCLE ;
|
| 43 |
/
|
43 |
/
|
| 44 |
--------------------------------------------------------
|
44 |
--------------------------------------------------------
|
| 45 |
-- DDL for Sequence SEQ_BMCON_ID
|
45 |
-- DDL for Sequence SEQ_BMCON_ID
|
| 46 |
--------------------------------------------------------
|
46 |
--------------------------------------------------------
|
| 47 |
|
47 |
|
| 48 |
CREATE SEQUENCE "SEQ_BMCON_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 121 CACHE 20 NOORDER NOCYCLE ;
|
48 |
CREATE SEQUENCE "SEQ_BMCON_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 141 CACHE 20 NOORDER NOCYCLE ;
|
| 49 |
/
|
49 |
/
|
| 50 |
--------------------------------------------------------
|
50 |
--------------------------------------------------------
|
| 51 |
-- DDL for Sequence SEQ_BM_ID
|
51 |
-- DDL for Sequence SEQ_BM_ID
|
| 52 |
--------------------------------------------------------
|
52 |
--------------------------------------------------------
|
| 53 |
|
53 |
|
| Line 55... |
Line 55... |
| 55 |
/
|
55 |
/
|
| 56 |
--------------------------------------------------------
|
56 |
--------------------------------------------------------
|
| 57 |
-- DDL for Sequence SEQ_CR_ID
|
57 |
-- DDL for Sequence SEQ_CR_ID
|
| 58 |
--------------------------------------------------------
|
58 |
--------------------------------------------------------
|
| 59 |
|
59 |
|
| 60 |
CREATE SEQUENCE "SEQ_CR_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 84501 CACHE 20 ORDER NOCYCLE ;
|
60 |
CREATE SEQUENCE "SEQ_CR_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 85781 CACHE 20 ORDER NOCYCLE ;
|
| 61 |
/
|
61 |
/
|
| 62 |
--------------------------------------------------------
|
62 |
--------------------------------------------------------
|
| 63 |
-- DDL for Sequence SEQ_DAEMON_INSTRUCTION_ID
|
63 |
-- DDL for Sequence SEQ_DAEMON_INSTRUCTION_ID
|
| 64 |
--------------------------------------------------------
|
64 |
--------------------------------------------------------
|
| 65 |
|
65 |
|
| 66 |
CREATE SEQUENCE "SEQ_DAEMON_INSTRUCTION_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 148162 CACHE 20 ORDER NOCYCLE ;
|
66 |
CREATE SEQUENCE "SEQ_DAEMON_INSTRUCTION_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 149782 CACHE 20 ORDER NOCYCLE ;
|
| 67 |
/
|
67 |
/
|
| 68 |
--------------------------------------------------------
|
68 |
--------------------------------------------------------
|
| 69 |
-- DDL for Sequence SEQ_GBE_ID
|
69 |
-- DDL for Sequence SEQ_GBE_ID
|
| 70 |
--------------------------------------------------------
|
70 |
--------------------------------------------------------
|
| 71 |
|
71 |
|
| Line 85... |
Line 85... |
| 85 |
/
|
85 |
/
|
| 86 |
--------------------------------------------------------
|
86 |
--------------------------------------------------------
|
| 87 |
-- DDL for Sequence SEQ_PKG_ID
|
87 |
-- DDL for Sequence SEQ_PKG_ID
|
| 88 |
--------------------------------------------------------
|
88 |
--------------------------------------------------------
|
| 89 |
|
89 |
|
| 90 |
CREATE SEQUENCE "SEQ_PKG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 59025 CACHE 20 ORDER NOCYCLE ;
|
90 |
CREATE SEQUENCE "SEQ_PKG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 59385 CACHE 20 ORDER NOCYCLE ;
|
| 91 |
/
|
91 |
/
|
| 92 |
--------------------------------------------------------
|
92 |
--------------------------------------------------------
|
| 93 |
-- DDL for Sequence SEQ_PROJ_ID
|
93 |
-- DDL for Sequence SEQ_PROJ_ID
|
| 94 |
--------------------------------------------------------
|
94 |
--------------------------------------------------------
|
| 95 |
|
95 |
|
| 96 |
CREATE SEQUENCE "SEQ_PROJ_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 761 CACHE 20 ORDER NOCYCLE ;
|
96 |
CREATE SEQUENCE "SEQ_PROJ_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 781 CACHE 20 ORDER NOCYCLE ;
|
| 97 |
/
|
97 |
/
|
| 98 |
--------------------------------------------------------
|
98 |
--------------------------------------------------------
|
| 99 |
-- DDL for Sequence SEQ_PV_ID
|
99 |
-- DDL for Sequence SEQ_PV_ID
|
| 100 |
--------------------------------------------------------
|
100 |
--------------------------------------------------------
|
| 101 |
|
101 |
|
| 102 |
CREATE SEQUENCE "SEQ_PV_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 968148 CACHE 20 ORDER NOCYCLE ;
|
102 |
CREATE SEQUENCE "SEQ_PV_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 976908 CACHE 20 ORDER NOCYCLE ;
|
| 103 |
/
|
103 |
/
|
| 104 |
--------------------------------------------------------
|
104 |
--------------------------------------------------------
|
| 105 |
-- DDL for Sequence SEQ_RCON_ID
|
105 |
-- DDL for Sequence SEQ_RCON_ID
|
| 106 |
--------------------------------------------------------
|
106 |
--------------------------------------------------------
|
| 107 |
|
107 |
|
| 108 |
CREATE SEQUENCE "SEQ_RCON_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 24443 CACHE 20 ORDER NOCYCLE ;
|
108 |
CREATE SEQUENCE "SEQ_RCON_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 24903 CACHE 20 ORDER NOCYCLE ;
|
| 109 |
/
|
109 |
/
|
| 110 |
--------------------------------------------------------
|
110 |
--------------------------------------------------------
|
| 111 |
-- DDL for Sequence SEQ_RTAG_ID
|
111 |
-- DDL for Sequence SEQ_RTAG_ID
|
| 112 |
--------------------------------------------------------
|
112 |
--------------------------------------------------------
|
| 113 |
|
113 |
|
| 114 |
CREATE SEQUENCE "SEQ_RTAG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 29563 CACHE 20 ORDER NOCYCLE ;
|
114 |
CREATE SEQUENCE "SEQ_RTAG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 29943 CACHE 20 ORDER NOCYCLE ;
|
| 115 |
/
|
115 |
/
|
| 116 |
--------------------------------------------------------
|
116 |
--------------------------------------------------------
|
| 117 |
-- DDL for Sequence SEQ_SCHEDULED_ID
|
117 |
-- DDL for Sequence SEQ_SCHEDULED_ID
|
| 118 |
--------------------------------------------------------
|
118 |
--------------------------------------------------------
|
| 119 |
|
119 |
|
| 120 |
CREATE SEQUENCE "SEQ_SCHEDULED_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 26221 CACHE 20 ORDER NOCYCLE ;
|
120 |
CREATE SEQUENCE "SEQ_SCHEDULED_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 26581 CACHE 20 ORDER NOCYCLE ;
|
| 121 |
/
|
121 |
/
|
| 122 |
--------------------------------------------------------
|
122 |
--------------------------------------------------------
|
| 123 |
-- DDL for Sequence SEQ_SESSION_NUM
|
123 |
-- DDL for Sequence SEQ_SESSION_NUM
|
| 124 |
--------------------------------------------------------
|
124 |
--------------------------------------------------------
|
| 125 |
|
125 |
|
| 126 |
CREATE SEQUENCE "SEQ_SESSION_NUM" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 992162 CACHE 20 ORDER NOCYCLE ;
|
126 |
CREATE SEQUENCE "SEQ_SESSION_NUM" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 997862 CACHE 20 ORDER NOCYCLE ;
|
| 127 |
/
|
127 |
/
|
| 128 |
--------------------------------------------------------
|
128 |
--------------------------------------------------------
|
| 129 |
-- DDL for Sequence SEQ_UNIT_TESTS
|
129 |
-- DDL for Sequence SEQ_UNIT_TESTS
|
| 130 |
--------------------------------------------------------
|
130 |
--------------------------------------------------------
|
| 131 |
|
131 |
|
| 132 |
CREATE SEQUENCE "SEQ_UNIT_TESTS" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 346943 CACHE 20 ORDER NOCYCLE ;
|
132 |
CREATE SEQUENCE "SEQ_UNIT_TESTS" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 348883 CACHE 20 ORDER NOCYCLE ;
|
| 133 |
/
|
133 |
/
|
| 134 |
--------------------------------------------------------
|
134 |
--------------------------------------------------------
|
| 135 |
-- DDL for Sequence SEQ_USER_ID
|
135 |
-- DDL for Sequence SEQ_USER_ID
|
| 136 |
--------------------------------------------------------
|
136 |
--------------------------------------------------------
|
| 137 |
|
137 |
|
| Line 151... |
Line 151... |
| 151 |
/
|
151 |
/
|
| 152 |
--------------------------------------------------------
|
152 |
--------------------------------------------------------
|
| 153 |
-- DDL for Sequence SEQ_VTREE_ID
|
153 |
-- DDL for Sequence SEQ_VTREE_ID
|
| 154 |
--------------------------------------------------------
|
154 |
--------------------------------------------------------
|
| 155 |
|
155 |
|
| 156 |
CREATE SEQUENCE "SEQ_VTREE_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 26382 CACHE 20 ORDER NOCYCLE ;
|
156 |
CREATE SEQUENCE "SEQ_VTREE_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 26762 CACHE 20 ORDER NOCYCLE ;
|
| 157 |
/
|
157 |
/
|
| 158 |
--------------------------------------------------------
|
158 |
--------------------------------------------------------
|
| 159 |
-- DDL for Table ABT_ACTION_LOG
|
159 |
-- DDL for Table ABT_ACTION_LOG
|
| 160 |
--------------------------------------------------------
|
160 |
--------------------------------------------------------
|
| 161 |
|
161 |
|
| Line 872... |
Line 872... |
| 872 |
( "RCON_ID" NUMBER,
|
872 |
( "RCON_ID" NUMBER,
|
| 873 |
"RTAG_ID" NUMBER,
|
873 |
"RTAG_ID" NUMBER,
|
| 874 |
"GBE_ID" NUMBER,
|
874 |
"GBE_ID" NUMBER,
|
| 875 |
"DAEMON_HOSTNAME" VARCHAR2(50),
|
875 |
"DAEMON_HOSTNAME" VARCHAR2(50),
|
| 876 |
"DAEMON_MODE" CHAR(1 CHAR),
|
876 |
"DAEMON_MODE" CHAR(1 CHAR),
|
| 877 |
"GBE_BUILDFILTER" VARCHAR2(255)
|
877 |
"GBE_BUILDFILTER" VARCHAR2(255),
|
| - |
|
878 |
"BMCON_ID" NUMBER
|
| 878 |
) ;
|
879 |
) ;
|
| - |
|
880 |
|
| - |
|
881 |
COMMENT ON COLUMN "RELEASE_CONFIG"."GBE_ID" IS 'Do not use. Data should come from build_machine_config';
|
| - |
|
882 |
COMMENT ON COLUMN "RELEASE_CONFIG"."DAEMON_HOSTNAME" IS 'Do not use. Data should come from build_machine_config';
|
| - |
|
883 |
COMMENT ON COLUMN "RELEASE_CONFIG"."BMCON_ID" IS 'Link to the build_machine_config table';
|
| 879 |
/
|
884 |
/
|
| 880 |
--------------------------------------------------------
|
885 |
--------------------------------------------------------
|
| 881 |
-- DDL for Table RELEASE_CONTENT
|
886 |
-- DDL for Table RELEASE_CONTENT
|
| 882 |
--------------------------------------------------------
|
887 |
--------------------------------------------------------
|
| 883 |
|
888 |
|
| Line 1280... |
Line 1285... |
| 1280 |
|
1285 |
|
| 1281 |
CREATE INDEX "INX_UT_COMPLETED" ON "UNIT_TESTS" ("COMPLETION_DATE", "COMPLETED_BY")
|
1286 |
CREATE INDEX "INX_UT_COMPLETED" ON "UNIT_TESTS" ("COMPLETION_DATE", "COMPLETED_BY")
|
| 1282 |
;
|
1287 |
;
|
| 1283 |
/
|
1288 |
/
|
| 1284 |
--------------------------------------------------------
|
1289 |
--------------------------------------------------------
|
| 1285 |
-- DDL for Index INX_PV_ID_PKGDOC
|
1290 |
-- DDL for Index INX_PV_ID_PKGDOC
|
| 1286 |
--------------------------------------------------------
|
1291 |
--------------------------------------------------------
|
| 1287 |
|
1292 |
|
| 1288 |
CREATE INDEX "INX_PV_ID_PKGDOC" ON "PACKAGE_DOCUMENTS" ("PV_ID")
|
1293 |
CREATE INDEX "INX_PV_ID_PKGDOC" ON "PACKAGE_DOCUMENTS" ("PV_ID")
|
| 1289 |
;
|
1294 |
;
|
| 1290 |
/
|
1295 |
/
|
| 1291 |
--------------------------------------------------------
|
1296 |
--------------------------------------------------------
|
| 1292 |
-- DDL for Index UNQ_VIEW_SETTINGS
|
1297 |
-- DDL for Index UNQ_VIEW_SETTINGS
|
| 1293 |
--------------------------------------------------------
|
1298 |
--------------------------------------------------------
|
| 1294 |
|
1299 |
|
| 1295 |
CREATE UNIQUE INDEX "UNQ_VIEW_SETTINGS" ON "VIEW_SETTINGS" ("USER_ID", "VIEW_ID")
|
1300 |
CREATE UNIQUE INDEX "UNQ_VIEW_SETTINGS" ON "VIEW_SETTINGS" ("USER_ID", "VIEW_ID")
|
| 1296 |
;
|
1301 |
;
|
| 1297 |
/
|
1302 |
/
|
| 1298 |
--------------------------------------------------------
|
1303 |
--------------------------------------------------------
|
| 1299 |
-- DDL for Index INX_PP_PV_ID
|
1304 |
-- DDL for Index INX_PP_PV_ID
|
| 1300 |
--------------------------------------------------------
|
1305 |
--------------------------------------------------------
|
| 1301 |
|
1306 |
|
| 1302 |
CREATE INDEX "INX_PP_PV_ID" ON "PACKAGE_PATCHES" ("PV_ID")
|
1307 |
CREATE INDEX "INX_PP_PV_ID" ON "PACKAGE_PATCHES" ("PV_ID")
|
| 1303 |
;
|
1308 |
;
|
| 1304 |
/
|
1309 |
/
|
| 1305 |
--------------------------------------------------------
|
1310 |
--------------------------------------------------------
|
| 1306 |
-- DDL for Index PK_VIEWS
|
1311 |
-- DDL for Index PK_VIEWS
|
| 1307 |
--------------------------------------------------------
|
1312 |
--------------------------------------------------------
|
| 1308 |
|
1313 |
|
| 1309 |
CREATE UNIQUE INDEX "PK_VIEWS" ON "VIEWS" ("VIEW_ID")
|
1314 |
CREATE UNIQUE INDEX "PK_VIEWS" ON "VIEWS" ("VIEW_ID")
|
| 1310 |
;
|
1315 |
;
|
| 1311 |
/
|
1316 |
/
|
| 1312 |
--------------------------------------------------------
|
1317 |
--------------------------------------------------------
|
| 1313 |
-- DDL for Index PK_PACKAGES
|
1318 |
-- DDL for Index PK_PACKAGES
|
| 1314 |
--------------------------------------------------------
|
1319 |
--------------------------------------------------------
|
| 1315 |
|
1320 |
|
| 1316 |
CREATE UNIQUE INDEX "PK_PACKAGES" ON "PACKAGES" ("PKG_ID")
|
1321 |
CREATE UNIQUE INDEX "PK_PACKAGES" ON "PACKAGES" ("PKG_ID")
|
| 1317 |
;
|
1322 |
;
|
| 1318 |
/
|
1323 |
/
|
| 1319 |
--------------------------------------------------------
|
1324 |
--------------------------------------------------------
|
| 1320 |
-- DDL for Index PK_TEST_TYPES
|
1325 |
-- DDL for Index PK_TEST_TYPES
|
| 1321 |
--------------------------------------------------------
|
1326 |
--------------------------------------------------------
|
| 1322 |
|
1327 |
|
| 1323 |
CREATE UNIQUE INDEX "PK_TEST_TYPES" ON "TEST_TYPES" ("TEST_TYPE_ID")
|
1328 |
CREATE UNIQUE INDEX "PK_TEST_TYPES" ON "TEST_TYPES" ("TEST_TYPE_ID")
|
| 1324 |
;
|
1329 |
;
|
| 1325 |
/
|
1330 |
/
|
| 1326 |
--------------------------------------------------------
|
1331 |
--------------------------------------------------------
|
| 1327 |
-- DDL for Index UNQ_ACTTYPE_ID
|
1332 |
-- DDL for Index UNQ_ACTTYPE_ID
|
| 1328 |
--------------------------------------------------------
|
1333 |
--------------------------------------------------------
|
| 1329 |
|
1334 |
|
| 1330 |
CREATE UNIQUE INDEX "UNQ_ACTTYPE_ID" ON "ACTION_TYPE" ("ACTTYPE_ID")
|
1335 |
CREATE UNIQUE INDEX "UNQ_ACTTYPE_ID" ON "ACTION_TYPE" ("ACTTYPE_ID")
|
| 1331 |
;
|
1336 |
;
|
| 1332 |
/
|
1337 |
/
|
| 1333 |
--------------------------------------------------------
|
1338 |
--------------------------------------------------------
|
| 1334 |
-- DDL for Index INX_PROJ_ACTION_DATE_TIME
|
1339 |
-- DDL for Index INX_PROJ_ACTION_DATE_TIME
|
| 1335 |
--------------------------------------------------------
|
1340 |
--------------------------------------------------------
|
| 1336 |
|
1341 |
|
| 1337 |
CREATE INDEX "INX_PROJ_ACTION_DATE_TIME" ON "PROJECT_ACTION_LOG" ("ACTION_DATETIME")
|
1342 |
CREATE INDEX "INX_PROJ_ACTION_DATE_TIME" ON "PROJECT_ACTION_LOG" ("ACTION_DATETIME")
|
| 1338 |
;
|
1343 |
;
|
| 1339 |
/
|
1344 |
/
|
| 1340 |
--------------------------------------------------------
|
1345 |
--------------------------------------------------------
|
| 1341 |
-- DDL for Index INX_RC_PKG_STATE
|
1346 |
-- DDL for Index INX_RC_PKG_STATE
|
| 1342 |
--------------------------------------------------------
|
1347 |
--------------------------------------------------------
|
| 1343 |
|
1348 |
|
| 1344 |
CREATE INDEX "INX_RC_PKG_STATE" ON "RELEASE_CONTENT" ("PKG_STATE")
|
1349 |
CREATE INDEX "INX_RC_PKG_STATE" ON "RELEASE_CONTENT" ("PKG_STATE")
|
| 1345 |
;
|
1350 |
;
|
| 1346 |
/
|
1351 |
/
|
| 1347 |
--------------------------------------------------------
|
1352 |
--------------------------------------------------------
|
| 1348 |
-- DDL for Index PROCESSES_PK
|
1353 |
-- DDL for Index PROCESSES_PK
|
| 1349 |
--------------------------------------------------------
|
1354 |
--------------------------------------------------------
|
| 1350 |
|
1355 |
|
| 1351 |
CREATE UNIQUE INDEX "PROCESSES_PK" ON "PROCESSES" ("PROC_ID")
|
1356 |
CREATE UNIQUE INDEX "PROCESSES_PK" ON "PROCESSES" ("PROC_ID")
|
| 1352 |
;
|
1357 |
;
|
| 1353 |
/
|
1358 |
/
|
| 1354 |
--------------------------------------------------------
|
1359 |
--------------------------------------------------------
|
| 1355 |
-- DDL for Index INX_PACKAGE_DEPS_DPV_ID
|
1360 |
-- DDL for Index INX_PACKAGE_DEPS_DPV_ID
|
| 1356 |
--------------------------------------------------------
|
1361 |
--------------------------------------------------------
|
| 1357 |
|
1362 |
|
| 1358 |
CREATE INDEX "INX_PACKAGE_DEPS_DPV_ID" ON "PACKAGE_DEPENDENCIES" ("DPV_ID")
|
1363 |
CREATE INDEX "INX_PACKAGE_DEPS_DPV_ID" ON "PACKAGE_DEPENDENCIES" ("DPV_ID")
|
| 1359 |
;
|
1364 |
;
|
| 1360 |
/
|
1365 |
/
|
| 1361 |
--------------------------------------------------------
|
1366 |
--------------------------------------------------------
|
| 1362 |
-- DDL for Index INX_PACKAGES_PKG_VERSION
|
1367 |
-- DDL for Index INX_PACKAGES_PKG_VERSION
|
| 1363 |
--------------------------------------------------------
|
1368 |
--------------------------------------------------------
|
| 1364 |
|
1369 |
|
| 1365 |
CREATE INDEX "INX_PACKAGES_PKG_VERSION" ON "PACKAGE_VERSIONS" ("PKG_VERSION")
|
1370 |
CREATE INDEX "INX_PACKAGES_PKG_VERSION" ON "PACKAGE_VERSIONS" ("PKG_VERSION")
|
| 1366 |
;
|
1371 |
;
|
| 1367 |
/
|
1372 |
/
|
| 1368 |
--------------------------------------------------------
|
1373 |
--------------------------------------------------------
|
| 1369 |
-- DDL for Index UNQ_PACKAGE_METRICS
|
1374 |
-- DDL for Index UNQ_PACKAGE_METRICS
|
| 1370 |
--------------------------------------------------------
|
1375 |
--------------------------------------------------------
|
| 1371 |
|
1376 |
|
| 1372 |
CREATE UNIQUE INDEX "UNQ_PACKAGE_METRICS" ON "PACKAGE_METRICS" ("PV_ID")
|
1377 |
CREATE UNIQUE INDEX "UNQ_PACKAGE_METRICS" ON "PACKAGE_METRICS" ("PV_ID")
|
| 1373 |
;
|
1378 |
;
|
| 1374 |
/
|
1379 |
/
|
| 1375 |
--------------------------------------------------------
|
1380 |
--------------------------------------------------------
|
| 1376 |
-- DDL for Index UNQ_PLATFORM
|
1381 |
-- DDL for Index UNQ_PLATFORM
|
| 1377 |
--------------------------------------------------------
|
1382 |
--------------------------------------------------------
|
| 1378 |
|
1383 |
|
| 1379 |
CREATE UNIQUE INDEX "UNQ_PLATFORM" ON "PLATFORMS" ("NAME")
|
1384 |
CREATE UNIQUE INDEX "UNQ_PLATFORM" ON "PLATFORMS" ("NAME")
|
| 1380 |
;
|
1385 |
;
|
| 1381 |
/
|
1386 |
/
|
| 1382 |
--------------------------------------------------------
|
1387 |
--------------------------------------------------------
|
| 1383 |
-- DDL for Index UNQ_VIEWS
|
1388 |
-- DDL for Index UNQ_VIEWS
|
| 1384 |
--------------------------------------------------------
|
1389 |
--------------------------------------------------------
|
| 1385 |
|
1390 |
|
| 1386 |
CREATE UNIQUE INDEX "UNQ_VIEWS" ON "VIEWS" ("VIEW_NAME", "OWNER_ID")
|
1391 |
CREATE UNIQUE INDEX "UNQ_VIEWS" ON "VIEWS" ("VIEW_NAME", "OWNER_ID")
|
| 1387 |
;
|
1392 |
;
|
| 1388 |
/
|
1393 |
/
|
| 1389 |
--------------------------------------------------------
|
1394 |
--------------------------------------------------------
|
| 1390 |
-- DDL for Index PRODUCT_STATES_PK
|
1395 |
-- DDL for Index PRODUCT_STATES_PK
|
| 1391 |
--------------------------------------------------------
|
1396 |
--------------------------------------------------------
|
| 1392 |
|
1397 |
|
| 1393 |
CREATE UNIQUE INDEX "PRODUCT_STATES_PK" ON "PRODUCT_STATES" ("STATE_ID")
|
1398 |
CREATE UNIQUE INDEX "PRODUCT_STATES_PK" ON "PRODUCT_STATES" ("STATE_ID")
|
| 1394 |
;
|
1399 |
;
|
| Line 1398... |
Line 1403... |
| 1398 |
--------------------------------------------------------
|
1403 |
--------------------------------------------------------
|
| 1399 |
|
1404 |
|
| 1400 |
CREATE UNIQUE INDEX "PK_MESSAGE_BOARD" ON "MESSAGE_BOARD" ("MSG_ID")
|
1405 |
CREATE UNIQUE INDEX "PK_MESSAGE_BOARD" ON "MESSAGE_BOARD" ("MSG_ID")
|
| 1401 |
;
|
1406 |
;
|
| 1402 |
/
|
1407 |
/
|
| 1403 |
--------------------------------------------------------
|
1408 |
--------------------------------------------------------
|
| 1404 |
-- DDL for Index PK_BUILD_MACHINE_CONFIG
|
1409 |
-- DDL for Index PK_BUILD_MACHINE_CONFIG
|
| 1405 |
--------------------------------------------------------
|
1410 |
--------------------------------------------------------
|
| 1406 |
|
1411 |
|
| 1407 |
CREATE UNIQUE INDEX "PK_BUILD_MACHINE_CONFIG" ON "BUILD_MACHINE_CONFIG" ("BMCON_ID")
|
1412 |
CREATE UNIQUE INDEX "PK_BUILD_MACHINE_CONFIG" ON "BUILD_MACHINE_CONFIG" ("BMCON_ID")
|
| 1408 |
;
|
1413 |
;
|
| 1409 |
/
|
1414 |
/
|
| 1410 |
--------------------------------------------------------
|
1415 |
--------------------------------------------------------
|
| 1411 |
-- DDL for Index INX_MSGBOARD
|
1416 |
-- DDL for Index INX_MSGBOARD
|
| 1412 |
--------------------------------------------------------
|
1417 |
--------------------------------------------------------
|
| 1413 |
|
1418 |
|
| 1414 |
CREATE INDEX "INX_MSGBOARD" ON "MESSAGE_BOARD" ("EXPIRY_DATE", "DUE_DATE")
|
1419 |
CREATE INDEX "INX_MSGBOARD" ON "MESSAGE_BOARD" ("EXPIRY_DATE", "DUE_DATE")
|
| 1415 |
;
|
1420 |
;
|
| 1416 |
/
|
1421 |
/
|
| 1417 |
--------------------------------------------------------
|
1422 |
--------------------------------------------------------
|
| 1418 |
-- DDL for Index PK_VTREES
|
1423 |
-- DDL for Index PK_VTREES
|
| 1419 |
--------------------------------------------------------
|
1424 |
--------------------------------------------------------
|
| 1420 |
|
1425 |
|
| 1421 |
CREATE UNIQUE INDEX "PK_VTREES" ON "VTREES" ("VTREE_ID")
|
1426 |
CREATE UNIQUE INDEX "PK_VTREES" ON "VTREES" ("VTREE_ID")
|
| 1422 |
;
|
1427 |
;
|
| 1423 |
/
|
1428 |
/
|
| 1424 |
--------------------------------------------------------
|
1429 |
--------------------------------------------------------
|
| 1425 |
-- DDL for Index UNQ_UT_PART1
|
1430 |
-- DDL for Index UNQ_UT_PART1
|
| 1426 |
--------------------------------------------------------
|
1431 |
--------------------------------------------------------
|
| 1427 |
|
1432 |
|
| 1428 |
CREATE UNIQUE INDEX "UNQ_UT_PART1" ON "UNIT_TESTS" ("PV_ID", "TEST_ID")
|
1433 |
CREATE UNIQUE INDEX "UNQ_UT_PART1" ON "UNIT_TESTS" ("PV_ID", "TEST_ID")
|
| 1429 |
;
|
1434 |
;
|
| 1430 |
/
|
1435 |
/
|
| 1431 |
--------------------------------------------------------
|
1436 |
--------------------------------------------------------
|
| 1432 |
-- DDL for Index UNQ_BUILD_ENV
|
1437 |
-- DDL for Index UNQ_BUILD_ENV
|
| 1433 |
--------------------------------------------------------
|
1438 |
--------------------------------------------------------
|
| 1434 |
|
1439 |
|
| 1435 |
CREATE UNIQUE INDEX "UNQ_BUILD_ENV" ON "BUILD_ENVIRONMENTS" ("BE_NAME")
|
1440 |
CREATE UNIQUE INDEX "UNQ_BUILD_ENV" ON "BUILD_ENVIRONMENTS" ("BE_NAME")
|
| 1436 |
;
|
1441 |
;
|
| 1437 |
/
|
1442 |
/
|
| 1438 |
--------------------------------------------------------
|
1443 |
--------------------------------------------------------
|
| Line 1441... |
Line 1446... |
| 1441 |
|
1446 |
|
| 1442 |
CREATE INDEX "INX_ACTION_DATE_TIME" ON "ACTION_LOG" ("ACTION_DATETIME")
|
1447 |
CREATE INDEX "INX_ACTION_DATE_TIME" ON "ACTION_LOG" ("ACTION_DATETIME")
|
| 1443 |
;
|
1448 |
;
|
| 1444 |
/
|
1449 |
/
|
| 1445 |
--------------------------------------------------------
|
1450 |
--------------------------------------------------------
|
| 1446 |
-- DDL for Index UNQ_BUILD_MACHINE_CONFIG02
|
1451 |
-- DDL for Index UNQ_BUILD_MACHINE_CONFIG02
|
| 1447 |
--------------------------------------------------------
|
1452 |
--------------------------------------------------------
|
| 1448 |
|
1453 |
|
| 1449 |
CREATE UNIQUE INDEX "UNQ_BUILD_MACHINE_CONFIG02" ON "BUILD_MACHINE_CONFIG" ("MACHINE_HOSTNAME")
|
1454 |
CREATE UNIQUE INDEX "UNQ_BUILD_MACHINE_CONFIG02" ON "BUILD_MACHINE_CONFIG" ("MACHINE_HOSTNAME")
|
| 1450 |
;
|
1455 |
;
|
| 1451 |
/
|
1456 |
/
|
| 1452 |
--------------------------------------------------------
|
1457 |
--------------------------------------------------------
|
| 1453 |
-- DDL for Index BUILD_MACHINES_PK
|
1458 |
-- DDL for Index BUILD_MACHINES_PK
|
| 1454 |
--------------------------------------------------------
|
1459 |
--------------------------------------------------------
|
| 1455 |
|
1460 |
|
| 1456 |
CREATE UNIQUE INDEX "BUILD_MACHINES_PK" ON "BUILD_MACHINES" ("BM_ID")
|
1461 |
CREATE UNIQUE INDEX "BUILD_MACHINES_PK" ON "BUILD_MACHINES" ("BM_ID")
|
| 1457 |
;
|
1462 |
;
|
| 1458 |
/
|
1463 |
/
|
| 1459 |
--------------------------------------------------------
|
1464 |
--------------------------------------------------------
|
| 1460 |
-- DDL for Index INX_TTB_SESSION
|
1465 |
-- DDL for Index INX_TTB_SESSION
|
| 1461 |
--------------------------------------------------------
|
1466 |
--------------------------------------------------------
|
| 1462 |
|
1467 |
|
| 1463 |
CREATE INDEX "INX_TTB_SESSION" ON "TEMP_TREE_BROWSE" ("SESSION_NUM")
|
1468 |
CREATE INDEX "INX_TTB_SESSION" ON "TEMP_TREE_BROWSE" ("SESSION_NUM")
|
| 1464 |
;
|
1469 |
;
|
| 1465 |
/
|
1470 |
/
|
| 1466 |
--------------------------------------------------------
|
1471 |
--------------------------------------------------------
|
| 1467 |
-- DDL for Index UNQ_RTD
|
1472 |
-- DDL for Index UNQ_RTD
|
| 1468 |
--------------------------------------------------------
|
1473 |
--------------------------------------------------------
|
| 1469 |
|
1474 |
|
| 1470 |
CREATE INDEX "UNQ_RTD" ON "RUNTIME_DEPENDENCIES" ("PV_ID", "RTD_ID")
|
1475 |
CREATE INDEX "UNQ_RTD" ON "RUNTIME_DEPENDENCIES" ("PV_ID", "RTD_ID")
|
| 1471 |
;
|
1476 |
;
|
| 1472 |
/
|
1477 |
/
|
| 1473 |
--------------------------------------------------------
|
1478 |
--------------------------------------------------------
|
| 1474 |
-- DDL for Index INX_RL_RTAG_ID
|
1479 |
-- DDL for Index INX_RL_RTAG_ID
|
| 1475 |
--------------------------------------------------------
|
1480 |
--------------------------------------------------------
|
| 1476 |
|
1481 |
|
| 1477 |
CREATE INDEX "INX_RL_RTAG_ID" ON "RELEASE_LINKS" ("RTAG_ID")
|
1482 |
CREATE INDEX "INX_RL_RTAG_ID" ON "RELEASE_LINKS" ("RTAG_ID")
|
| 1478 |
;
|
1483 |
;
|
| Line 1566... |
Line 1571... |
| 1566 |
--------------------------------------------------------
|
1571 |
--------------------------------------------------------
|
| 1567 |
|
1572 |
|
| 1568 |
CREATE INDEX "INX_TES_PKGEXT" ON "TEMP_ENV_STATES" ("PKG_ID", "V_EXT")
|
1573 |
CREATE INDEX "INX_TES_PKGEXT" ON "TEMP_ENV_STATES" ("PKG_ID", "V_EXT")
|
| 1569 |
;
|
1574 |
;
|
| 1570 |
/
|
1575 |
/
|
| 1571 |
--------------------------------------------------------
|
1576 |
--------------------------------------------------------
|
| 1572 |
-- DDL for Index UNQ_BUILD_MACHINE_CONFIG01
|
1577 |
-- DDL for Index UNQ_BUILD_MACHINE_CONFIG01
|
| 1573 |
--------------------------------------------------------
|
1578 |
--------------------------------------------------------
|
| 1574 |
|
1579 |
|
| 1575 |
CREATE UNIQUE INDEX "UNQ_BUILD_MACHINE_CONFIG01" ON "BUILD_MACHINE_CONFIG" (LOWER("DISPLAY_NAME"))
|
1580 |
CREATE UNIQUE INDEX "UNQ_BUILD_MACHINE_CONFIG01" ON "BUILD_MACHINE_CONFIG" (LOWER("DISPLAY_NAME"))
|
| 1576 |
;
|
1581 |
;
|
| 1577 |
/
|
1582 |
/
|
| 1578 |
--------------------------------------------------------
|
1583 |
--------------------------------------------------------
|
| Line 1580... |
Line 1585... |
| 1580 |
--------------------------------------------------------
|
1585 |
--------------------------------------------------------
|
| 1581 |
|
1586 |
|
| 1582 |
CREATE UNIQUE INDEX "UNQ_RELEASE_LINKS" ON "RELEASE_LINKS" ("RTAG_ID", "REF_RTAG_ID")
|
1587 |
CREATE UNIQUE INDEX "UNQ_RELEASE_LINKS" ON "RELEASE_LINKS" ("RTAG_ID", "REF_RTAG_ID")
|
| 1583 |
;
|
1588 |
;
|
| 1584 |
/
|
1589 |
/
|
| 1585 |
--------------------------------------------------------
|
1590 |
--------------------------------------------------------
|
| 1586 |
-- DDL for Index UNQ_PKG_DOC
|
1591 |
-- DDL for Index UNQ_PKG_DOC
|
| 1587 |
--------------------------------------------------------
|
1592 |
--------------------------------------------------------
|
| 1588 |
|
1593 |
|
| 1589 |
CREATE UNIQUE INDEX "UNQ_PKG_DOC" ON "PACKAGE_DOCUMENTS" ("PV_ID", "DOC_NUM")
|
1594 |
CREATE UNIQUE INDEX "UNQ_PKG_DOC" ON "PACKAGE_DOCUMENTS" ("PV_ID", "DOC_NUM")
|
| 1590 |
;
|
1595 |
;
|
| 1591 |
/
|
1596 |
/
|
| 1592 |
--------------------------------------------------------
|
1597 |
--------------------------------------------------------
|
| Line 1594... |
Line 1599... |
| 1594 |
--------------------------------------------------------
|
1599 |
--------------------------------------------------------
|
| 1595 |
|
1600 |
|
| 1596 |
CREATE UNIQUE INDEX "DAEMON_INSTRUCTIONS_PK" ON "DAEMON_INSTRUCTIONS" ("DAEMON_INSTRUCTIONS_ID")
|
1601 |
CREATE UNIQUE INDEX "DAEMON_INSTRUCTIONS_PK" ON "DAEMON_INSTRUCTIONS" ("DAEMON_INSTRUCTIONS_ID")
|
| 1597 |
;
|
1602 |
;
|
| 1598 |
/
|
1603 |
/
|
| 1599 |
--------------------------------------------------------
|
1604 |
--------------------------------------------------------
|
| 1600 |
-- DDL for Index INX_DAEMON_INST_SCHED_DATETIME
|
1605 |
-- DDL for Index INX_DAEMON_INST_SCHED_DATETIME
|
| 1601 |
--------------------------------------------------------
|
1606 |
--------------------------------------------------------
|
| 1602 |
|
1607 |
|
| 1603 |
CREATE INDEX "INX_DAEMON_INST_SCHED_DATETIME" ON "DAEMON_INSTRUCTIONS" ("SCHEDULED_DATETIME")
|
1608 |
CREATE INDEX "INX_DAEMON_INST_SCHED_DATETIME" ON "DAEMON_INSTRUCTIONS" ("SCHEDULED_DATETIME")
|
| 1604 |
;
|
1609 |
;
|
| 1605 |
/
|
1610 |
/
|
| 1606 |
--------------------------------------------------------
|
1611 |
--------------------------------------------------------
|
| Line 1615... |
Line 1620... |
| 1615 |
--------------------------------------------------------
|
1620 |
--------------------------------------------------------
|
| 1616 |
|
1621 |
|
| 1617 |
CREATE UNIQUE INDEX "UNQ_VALIDATION_RULES" ON "VALIDATION_RULES" ("FIELD_NAME")
|
1622 |
CREATE UNIQUE INDEX "UNQ_VALIDATION_RULES" ON "VALIDATION_RULES" ("FIELD_NAME")
|
| 1618 |
;
|
1623 |
;
|
| 1619 |
/
|
1624 |
/
|
| 1620 |
--------------------------------------------------------
|
1625 |
--------------------------------------------------------
|
| 1621 |
-- DDL for Index BUILD_STANDARDS_ADDENDUM_PK
|
1626 |
-- DDL for Index BUILD_STANDARDS_ADDENDUM_PK
|
| 1622 |
--------------------------------------------------------
|
1627 |
--------------------------------------------------------
|
| 1623 |
|
1628 |
|
| 1624 |
CREATE UNIQUE INDEX "BUILD_STANDARDS_ADDENDUM_PK" ON "BUILD_STANDARDS_ADDENDUM" ("BSA_ID")
|
1629 |
CREATE UNIQUE INDEX "BUILD_STANDARDS_ADDENDUM_PK" ON "BUILD_STANDARDS_ADDENDUM" ("BSA_ID")
|
| 1625 |
;
|
1630 |
;
|
| 1626 |
/
|
1631 |
/
|
| 1627 |
--------------------------------------------------------
|
1632 |
--------------------------------------------------------
|
| Line 1637... |
Line 1642... |
| 1637 |
|
1642 |
|
| 1638 |
CREATE INDEX "INX_TES_TES_STATE" ON "TEMP_ENV_STATES" ("TES_STATE")
|
1643 |
CREATE INDEX "INX_TES_TES_STATE" ON "TEMP_ENV_STATES" ("TES_STATE")
|
| 1639 |
;
|
1644 |
;
|
| 1640 |
/
|
1645 |
/
|
| 1641 |
--------------------------------------------------------
|
1646 |
--------------------------------------------------------
|
| 1642 |
-- DDL for Index UNQ_AN_PART1
|
1647 |
-- DDL for Index UNQ_AN_PART1
|
| 1643 |
--------------------------------------------------------
|
1648 |
--------------------------------------------------------
|
| 1644 |
|
1649 |
|
| 1645 |
CREATE UNIQUE INDEX "UNQ_AN_PART1" ON "ADDITIONAL_NOTES" ("PV_ID", "NOTE_ID")
|
1650 |
CREATE UNIQUE INDEX "UNQ_AN_PART1" ON "ADDITIONAL_NOTES" ("PV_ID", "NOTE_ID")
|
| 1646 |
;
|
1651 |
;
|
| 1647 |
/
|
1652 |
/
|
| 1648 |
--------------------------------------------------------
|
1653 |
--------------------------------------------------------
|
| 1649 |
-- DDL for Index UNQ_RELEASE_CONTENTS
|
1654 |
-- DDL for Index UNQ_RELEASE_CONTENTS
|
| 1650 |
--------------------------------------------------------
|
1655 |
--------------------------------------------------------
|
| 1651 |
|
1656 |
|
| 1652 |
CREATE UNIQUE INDEX "UNQ_RELEASE_CONTENTS" ON "RELEASE_CONTENT" ("RTAG_ID", "PV_ID")
|
1657 |
CREATE UNIQUE INDEX "UNQ_RELEASE_CONTENTS" ON "RELEASE_CONTENT" ("RTAG_ID", "PV_ID")
|
| 1653 |
;
|
1658 |
;
|
| 1654 |
/
|
1659 |
/
|
| 1655 |
--------------------------------------------------------
|
1660 |
--------------------------------------------------------
|
| 1656 |
-- DDL for Index INX_ACTION_LOG_PV_ID
|
1661 |
-- DDL for Index INX_ACTION_LOG_PV_ID
|
| 1657 |
--------------------------------------------------------
|
1662 |
--------------------------------------------------------
|
| 1658 |
|
1663 |
|
| 1659 |
CREATE INDEX "INX_ACTION_LOG_PV_ID" ON "ACTION_LOG" ("PV_ID")
|
1664 |
CREATE INDEX "INX_ACTION_LOG_PV_ID" ON "ACTION_LOG" ("PV_ID")
|
| 1660 |
;
|
1665 |
;
|
| 1661 |
/
|
1666 |
/
|
| 1662 |
--------------------------------------------------------
|
1667 |
--------------------------------------------------------
|
| Line 1665... |
Line 1670... |
| 1665 |
|
1670 |
|
| 1666 |
CREATE UNIQUE INDEX "UNQ_TEST_TYPE_NAME" ON "TEST_TYPES" ("TEST_TYPE_NAME")
|
1671 |
CREATE UNIQUE INDEX "UNQ_TEST_TYPE_NAME" ON "TEST_TYPES" ("TEST_TYPE_NAME")
|
| 1667 |
;
|
1672 |
;
|
| 1668 |
/
|
1673 |
/
|
| 1669 |
--------------------------------------------------------
|
1674 |
--------------------------------------------------------
|
| 1670 |
-- DDL for Index PKNOTE_MANAGER1
|
1675 |
-- DDL for Index PKNOTE_MANAGER1
|
| 1671 |
--------------------------------------------------------
|
1676 |
--------------------------------------------------------
|
| 1672 |
|
1677 |
|
| 1673 |
CREATE UNIQUE INDEX "PKNOTE_MANAGER1" ON "NOTE_MANAGER" ("NID")
|
1678 |
CREATE UNIQUE INDEX "PKNOTE_MANAGER1" ON "NOTE_MANAGER" ("NID")
|
| 1674 |
;
|
1679 |
;
|
| 1675 |
/
|
1680 |
/
|
| 1676 |
--------------------------------------------------------
|
1681 |
--------------------------------------------------------
|
| 1677 |
-- DDL for Index INX_PACKAGES_V_MM
|
1682 |
-- DDL for Index INX_PACKAGES_V_MM
|
| 1678 |
--------------------------------------------------------
|
1683 |
--------------------------------------------------------
|
| 1679 |
|
1684 |
|
| 1680 |
CREATE INDEX "INX_PACKAGES_V_MM" ON "PACKAGE_VERSIONS" ("V_MM")
|
1685 |
CREATE INDEX "INX_PACKAGES_V_MM" ON "PACKAGE_VERSIONS" ("V_MM")
|
| 1681 |
;
|
1686 |
;
|
| 1682 |
/
|
1687 |
/
|
| 1683 |
--------------------------------------------------------
|
1688 |
--------------------------------------------------------
|
| 1684 |
-- DDL for Index INX_CODE_REVIEW
|
1689 |
-- DDL for Index INX_CODE_REVIEW
|
| 1685 |
--------------------------------------------------------
|
1690 |
--------------------------------------------------------
|
| 1686 |
|
1691 |
|
| 1687 |
CREATE UNIQUE INDEX "INX_CODE_REVIEW" ON "CODE_REVIEWS" ("PV_ID")
|
1692 |
CREATE UNIQUE INDEX "INX_CODE_REVIEW" ON "CODE_REVIEWS" ("PV_ID")
|
| 1688 |
;
|
1693 |
;
|
| 1689 |
/
|
1694 |
/
|
| 1690 |
--------------------------------------------------------
|
1695 |
--------------------------------------------------------
|
| 1691 |
-- DDL for Index UNQ_VTREES
|
1696 |
-- DDL for Index UNQ_VTREES
|
| 1692 |
--------------------------------------------------------
|
1697 |
--------------------------------------------------------
|
| 1693 |
|
1698 |
|
| 1694 |
CREATE UNIQUE INDEX "UNQ_VTREES" ON "VTREES" ("PROJ_ID", "VTREE_NAME")
|
1699 |
CREATE UNIQUE INDEX "UNQ_VTREES" ON "VTREES" ("PROJ_ID", "VTREE_NAME")
|
| 1695 |
;
|
1700 |
;
|
| 1696 |
/
|
1701 |
/
|
| 1697 |
--------------------------------------------------------
|
1702 |
--------------------------------------------------------
|
| 1698 |
-- DDL for Index INX_PACKAGE_DEPS_PKG_ID
|
1703 |
-- DDL for Index INX_PACKAGE_DEPS_PKG_ID
|
| 1699 |
--------------------------------------------------------
|
1704 |
--------------------------------------------------------
|
| 1700 |
|
1705 |
|
| 1701 |
CREATE INDEX "INX_PACKAGE_DEPS_PKG_ID" ON "PACKAGE_DEPENDENCIES" ("PKG_ID")
|
1706 |
CREATE INDEX "INX_PACKAGE_DEPS_PKG_ID" ON "PACKAGE_DEPENDENCIES" ("PKG_ID")
|
| 1702 |
;
|
1707 |
;
|
| 1703 |
/
|
1708 |
/
|
| 1704 |
--------------------------------------------------------
|
1709 |
--------------------------------------------------------
|
| Line 1706... |
Line 1711... |
| 1706 |
--------------------------------------------------------
|
1711 |
--------------------------------------------------------
|
| 1707 |
|
1712 |
|
| 1708 |
CREATE UNIQUE INDEX "UNQ_PROJECTS" ON "PROJECTS" ("PROJ_NAME")
|
1713 |
CREATE UNIQUE INDEX "UNQ_PROJECTS" ON "PROJECTS" ("PROJ_NAME")
|
| 1709 |
;
|
1714 |
;
|
| 1710 |
/
|
1715 |
/
|
| 1711 |
--------------------------------------------------------
|
1716 |
--------------------------------------------------------
|
| 1712 |
-- DDL for Index INX_PACKAGES_V_EXT
|
1717 |
-- DDL for Index INX_PACKAGES_V_EXT
|
| 1713 |
--------------------------------------------------------
|
1718 |
--------------------------------------------------------
|
| 1714 |
|
1719 |
|
| 1715 |
CREATE INDEX "INX_PACKAGES_V_EXT" ON "PACKAGE_VERSIONS" ("V_EXT")
|
1720 |
CREATE INDEX "INX_PACKAGES_V_EXT" ON "PACKAGE_VERSIONS" ("V_EXT")
|
| 1716 |
;
|
1721 |
;
|
| 1717 |
/
|
1722 |
/
|
| 1718 |
--------------------------------------------------------
|
1723 |
--------------------------------------------------------
|
| Line 1720... |
Line 1725... |
| 1720 |
--------------------------------------------------------
|
1725 |
--------------------------------------------------------
|
| 1721 |
|
1726 |
|
| 1722 |
CREATE UNIQUE INDEX "PK_PROJECTS" ON "PROJECTS" ("PROJ_ID")
|
1727 |
CREATE UNIQUE INDEX "PK_PROJECTS" ON "PROJECTS" ("PROJ_ID")
|
| 1723 |
;
|
1728 |
;
|
| 1724 |
/
|
1729 |
/
|
| 1725 |
--------------------------------------------------------
|
1730 |
--------------------------------------------------------
|
| 1726 |
-- DDL for Index INX_TES_PV
|
1731 |
-- DDL for Index INX_TES_PV
|
| 1727 |
--------------------------------------------------------
|
1732 |
--------------------------------------------------------
|
| 1728 |
|
1733 |
|
| 1729 |
CREATE INDEX "INX_TES_PV" ON "TEMP_ENV_STATES" ("PV_ID")
|
1734 |
CREATE INDEX "INX_TES_PV" ON "TEMP_ENV_STATES" ("PV_ID")
|
| 1730 |
;
|
1735 |
;
|
| 1731 |
/
|
1736 |
/
|
| 1732 |
--------------------------------------------------------
|
1737 |
--------------------------------------------------------
|
| Line 1735... |
Line 1740... |
| 1735 |
|
1740 |
|
| 1736 |
CREATE UNIQUE INDEX "UNQ_VTREE_WORLD" ON "VTREES_WORLD" ("WORLD_ID", "VTREE_ID")
|
1741 |
CREATE UNIQUE INDEX "UNQ_VTREE_WORLD" ON "VTREES_WORLD" ("WORLD_ID", "VTREE_ID")
|
| 1737 |
;
|
1742 |
;
|
| 1738 |
/
|
1743 |
/
|
| 1739 |
--------------------------------------------------------
|
1744 |
--------------------------------------------------------
|
| 1740 |
-- DDL for Index UNQ_IGW
|
1745 |
-- DDL for Index UNQ_IGW
|
| 1741 |
--------------------------------------------------------
|
1746 |
--------------------------------------------------------
|
| 1742 |
|
1747 |
|
| 1743 |
CREATE UNIQUE INDEX "UNQ_IGW" ON "IGNORE_WARNINGS" ("RTAG_ID", "PV_ID", "DPV_ID")
|
1748 |
CREATE UNIQUE INDEX "UNQ_IGW" ON "IGNORE_WARNINGS" ("RTAG_ID", "PV_ID", "DPV_ID")
|
| 1744 |
;
|
1749 |
;
|
| 1745 |
/
|
1750 |
/
|
| 1746 |
--------------------------------------------------------
|
1751 |
--------------------------------------------------------
|
| 1747 |
-- DDL for Index INX_DAEMON_INST_RTAG_ID
|
1752 |
-- DDL for Index INX_DAEMON_INST_RTAG_ID
|
| 1748 |
--------------------------------------------------------
|
1753 |
--------------------------------------------------------
|
| 1749 |
|
1754 |
|
| 1750 |
CREATE INDEX "INX_DAEMON_INST_RTAG_ID" ON "DAEMON_INSTRUCTIONS" ("RTAG_ID")
|
1755 |
CREATE INDEX "INX_DAEMON_INST_RTAG_ID" ON "DAEMON_INSTRUCTIONS" ("RTAG_ID")
|
| 1751 |
;
|
1756 |
;
|
| 1752 |
/
|
1757 |
/
|
| 1753 |
--------------------------------------------------------
|
1758 |
--------------------------------------------------------
|
| 1754 |
-- DDL for Index PK_NOTIFICATION_HISTORY
|
1759 |
-- DDL for Index PK_NOTIFICATION_HISTORY
|
| 1755 |
--------------------------------------------------------
|
1760 |
--------------------------------------------------------
|
| 1756 |
|
1761 |
|
| 1757 |
CREATE UNIQUE INDEX "PK_NOTIFICATION_HISTORY" ON "NOTIFICATION_HISTORY" ("RTAG_ID", "PV_ID", "USER_ID")
|
1762 |
CREATE UNIQUE INDEX "PK_NOTIFICATION_HISTORY" ON "NOTIFICATION_HISTORY" ("RTAG_ID", "PV_ID", "USER_ID")
|
| 1758 |
;
|
1763 |
;
|
| 1759 |
/
|
1764 |
/
|
| 1760 |
--------------------------------------------------------
|
1765 |
--------------------------------------------------------
|
| 1761 |
-- DDL for Index UNQ_PACKAGE_DEPENDENCIES
|
1766 |
-- DDL for Index UNQ_PACKAGE_DEPENDENCIES
|
| 1762 |
--------------------------------------------------------
|
1767 |
--------------------------------------------------------
|
| 1763 |
|
1768 |
|
| 1764 |
CREATE UNIQUE INDEX "UNQ_PACKAGE_DEPENDENCIES" ON "PACKAGE_DEPENDENCIES" ("PV_ID", "DPV_ID")
|
1769 |
CREATE UNIQUE INDEX "UNQ_PACKAGE_DEPENDENCIES" ON "PACKAGE_DEPENDENCIES" ("PV_ID", "DPV_ID")
|
| 1765 |
;
|
1770 |
;
|
| 1766 |
/
|
1771 |
/
|
| 1767 |
--------------------------------------------------------
|
1772 |
--------------------------------------------------------
|
| 1768 |
-- DDL for Index INX_PACKAGE_DEPS_PV_ID
|
1773 |
-- DDL for Index INX_PACKAGE_DEPS_PV_ID
|
| 1769 |
--------------------------------------------------------
|
1774 |
--------------------------------------------------------
|
| 1770 |
|
1775 |
|
| 1771 |
CREATE INDEX "INX_PACKAGE_DEPS_PV_ID" ON "PACKAGE_DEPENDENCIES" ("PV_ID")
|
1776 |
CREATE INDEX "INX_PACKAGE_DEPS_PV_ID" ON "PACKAGE_DEPENDENCIES" ("PV_ID")
|
| 1772 |
;
|
1777 |
;
|
| 1773 |
/
|
1778 |
/
|
| 1774 |
--------------------------------------------------------
|
1779 |
--------------------------------------------------------
|
| 1775 |
-- DDL for Index BUILD_STANDARDS_PK
|
1780 |
-- DDL for Index BUILD_STANDARDS_PK
|
| 1776 |
--------------------------------------------------------
|
1781 |
--------------------------------------------------------
|
| 1777 |
|
1782 |
|
| 1778 |
CREATE UNIQUE INDEX "BUILD_STANDARDS_PK" ON "BUILD_STANDARDS" ("BS_ID")
|
1783 |
CREATE UNIQUE INDEX "BUILD_STANDARDS_PK" ON "BUILD_STANDARDS" ("BS_ID")
|
| 1779 |
;
|
1784 |
;
|
| 1780 |
/
|
1785 |
/
|
| 1781 |
--------------------------------------------------------
|
1786 |
--------------------------------------------------------
|
| 1782 |
-- DDL for Index UNQ_CQ
|
1787 |
-- DDL for Index UNQ_CQ
|
| 1783 |
--------------------------------------------------------
|
1788 |
--------------------------------------------------------
|
| 1784 |
|
1789 |
|
| 1785 |
CREATE UNIQUE INDEX "UNQ_CQ" ON "CQ_ISSUES" ("PV_ID", "ISS_ID", "ISS_DB")
|
1790 |
CREATE UNIQUE INDEX "UNQ_CQ" ON "CQ_ISSUES" ("PV_ID", "ISS_ID", "ISS_DB")
|
| 1786 |
;
|
1791 |
;
|
| 1787 |
/
|
1792 |
/
|
| 1788 |
--------------------------------------------------------
|
1793 |
--------------------------------------------------------
|
| Line 1790... |
Line 1795... |
| 1790 |
--------------------------------------------------------
|
1795 |
--------------------------------------------------------
|
| 1791 |
|
1796 |
|
| 1792 |
CREATE UNIQUE INDEX "UNQ_PACKAGE_VERSIONS" ON "PACKAGE_VERSIONS" ("PKG_ID", "PKG_VERSION")
|
1797 |
CREATE UNIQUE INDEX "UNQ_PACKAGE_VERSIONS" ON "PACKAGE_VERSIONS" ("PKG_ID", "PKG_VERSION")
|
| 1793 |
;
|
1798 |
;
|
| 1794 |
/
|
1799 |
/
|
| 1795 |
--------------------------------------------------------
|
1800 |
--------------------------------------------------------
|
| 1796 |
-- DDL for Index INX_PV_ID_TEST_ID_PKGDOC
|
1801 |
-- DDL for Index INX_PV_ID_TEST_ID_PKGDOC
|
| 1797 |
--------------------------------------------------------
|
1802 |
--------------------------------------------------------
|
| 1798 |
|
1803 |
|
| 1799 |
CREATE INDEX "INX_PV_ID_TEST_ID_PKGDOC" ON "PACKAGE_DOCUMENTS" ("PV_ID", "TEST_ID")
|
1804 |
CREATE INDEX "INX_PV_ID_TEST_ID_PKGDOC" ON "PACKAGE_DOCUMENTS" ("PV_ID", "TEST_ID")
|
| 1800 |
;
|
1805 |
;
|
| 1801 |
/
|
1806 |
/
|
| 1802 |
--------------------------------------------------------
|
1807 |
--------------------------------------------------------
|
| Line 1805... |
Line 1810... |
| 1805 |
|
1810 |
|
| 1806 |
CREATE UNIQUE INDEX "UNQ_PACKAGE_PATCHES" ON "PACKAGE_PATCHES" ("PATCH_ID")
|
1811 |
CREATE UNIQUE INDEX "UNQ_PACKAGE_PATCHES" ON "PACKAGE_PATCHES" ("PATCH_ID")
|
| 1807 |
;
|
1812 |
;
|
| 1808 |
/
|
1813 |
/
|
| 1809 |
--------------------------------------------------------
|
1814 |
--------------------------------------------------------
|
| 1810 |
-- DDL for Index UNQ_REL_COMPONENTS
|
1815 |
-- DDL for Index UNQ_REL_COMPONENTS
|
| 1811 |
--------------------------------------------------------
|
1816 |
--------------------------------------------------------
|
| 1812 |
|
1817 |
|
| 1813 |
CREATE UNIQUE INDEX "UNQ_REL_COMPONENTS" ON "RELEASE_COMPONENTS" ("PV_ID", "FILE_NAME", "FILE_PATH")
|
1818 |
CREATE UNIQUE INDEX "UNQ_REL_COMPONENTS" ON "RELEASE_COMPONENTS" ("PV_ID", "FILE_NAME", "FILE_PATH")
|
| 1814 |
;
|
1819 |
;
|
| 1815 |
/
|
1820 |
/
|
| 1816 |
--------------------------------------------------------
|
1821 |
--------------------------------------------------------
|
| 1817 |
-- DDL for Index PK_PACKAGE_VERSIONS
|
1822 |
-- DDL for Index PK_PACKAGE_VERSIONS
|
| 1818 |
--------------------------------------------------------
|
1823 |
--------------------------------------------------------
|
| 1819 |
|
1824 |
|
| 1820 |
CREATE UNIQUE INDEX "PK_PACKAGE_VERSIONS" ON "PACKAGE_VERSIONS" ("PV_ID")
|
1825 |
CREATE UNIQUE INDEX "PK_PACKAGE_VERSIONS" ON "PACKAGE_VERSIONS" ("PV_ID")
|
| 1821 |
;
|
1826 |
;
|
| 1822 |
/
|
1827 |
/
|
| 1823 |
--------------------------------------------------------
|
1828 |
--------------------------------------------------------
|
| 1824 |
-- DDL for Index UNQ_RELEASE_METRICS
|
1829 |
-- DDL for Index UNQ_RELEASE_METRICS
|
| 1825 |
--------------------------------------------------------
|
1830 |
--------------------------------------------------------
|
| 1826 |
|
1831 |
|
| 1827 |
CREATE UNIQUE INDEX "UNQ_RELEASE_METRICS" ON "RELEASE_METRICS" ("RTAG_ID")
|
1832 |
CREATE UNIQUE INDEX "UNQ_RELEASE_METRICS" ON "RELEASE_METRICS" ("RTAG_ID")
|
| 1828 |
;
|
1833 |
;
|
| 1829 |
/
|
1834 |
/
|
| 1830 |
--------------------------------------------------------
|
1835 |
--------------------------------------------------------
|
| 1831 |
-- DDL for Index UNQ_BUILD_ORDER
|
1836 |
-- DDL for Index UNQ_BUILD_ORDER
|
| 1832 |
--------------------------------------------------------
|
1837 |
--------------------------------------------------------
|
| 1833 |
|
1838 |
|
| 1834 |
CREATE UNIQUE INDEX "UNQ_BUILD_ORDER" ON "BUILD_ORDER" ("RTAG_ID", "PV_ID", "STEP_NUM")
|
1839 |
CREATE UNIQUE INDEX "UNQ_BUILD_ORDER" ON "BUILD_ORDER" ("RTAG_ID", "PV_ID", "STEP_NUM")
|
| 1835 |
;
|
1840 |
;
|
| 1836 |
/
|
1841 |
/
|
| 1837 |
--------------------------------------------------------
|
1842 |
--------------------------------------------------------
|
| 1838 |
-- DDL for Index PK_BUILD_ENVIRONMENTS
|
1843 |
-- DDL for Index PK_BUILD_ENVIRONMENTS
|
| 1839 |
--------------------------------------------------------
|
1844 |
--------------------------------------------------------
|
| 1840 |
|
1845 |
|
| 1841 |
CREATE UNIQUE INDEX "PK_BUILD_ENVIRONMENTS" ON "BUILD_ENVIRONMENTS" ("BE_ID")
|
1846 |
CREATE UNIQUE INDEX "PK_BUILD_ENVIRONMENTS" ON "BUILD_ENVIRONMENTS" ("BE_ID")
|
| 1842 |
;
|
1847 |
;
|
| 1843 |
/
|
1848 |
/
|
| 1844 |
--------------------------------------------------------
|
1849 |
--------------------------------------------------------
|
| 1845 |
-- DDL for Index INX_PACKAGE_DEPS_DPKG_ID
|
1850 |
-- DDL for Index INX_PACKAGE_DEPS_DPKG_ID
|
| 1846 |
--------------------------------------------------------
|
1851 |
--------------------------------------------------------
|
| 1847 |
|
1852 |
|
| 1848 |
CREATE INDEX "INX_PACKAGE_DEPS_DPKG_ID" ON "PACKAGE_DEPENDENCIES" ("DPKG_ID")
|
1853 |
CREATE INDEX "INX_PACKAGE_DEPS_DPKG_ID" ON "PACKAGE_DEPENDENCIES" ("DPKG_ID")
|
| 1849 |
;
|
1854 |
;
|
| 1850 |
/
|
1855 |
/
|
| 1851 |
--------------------------------------------------------
|
1856 |
--------------------------------------------------------
|
| 1852 |
-- DDL for Index INX_RL_REFRTAG_ID
|
1857 |
-- DDL for Index INX_RL_REFRTAG_ID
|
| 1853 |
--------------------------------------------------------
|
1858 |
--------------------------------------------------------
|
| 1854 |
|
1859 |
|
| 1855 |
CREATE INDEX "INX_RL_REFRTAG_ID" ON "RELEASE_LINKS" ("REF_RTAG_ID")
|
1860 |
CREATE INDEX "INX_RL_REFRTAG_ID" ON "RELEASE_LINKS" ("REF_RTAG_ID")
|
| 1856 |
;
|
1861 |
;
|
| 1857 |
/
|
1862 |
/
|
| 1858 |
--------------------------------------------------------
|
1863 |
--------------------------------------------------------
|
| 1859 |
-- DDL for Index INX_RC_BASE_VIEW_ID
|
1864 |
-- DDL for Index INX_RC_BASE_VIEW_ID
|
| 1860 |
--------------------------------------------------------
|
1865 |
--------------------------------------------------------
|
| 1861 |
|
1866 |
|
| 1862 |
CREATE INDEX "INX_RC_BASE_VIEW_ID" ON "RELEASE_CONTENT" ("BASE_VIEW_ID")
|
1867 |
CREATE INDEX "INX_RC_BASE_VIEW_ID" ON "RELEASE_CONTENT" ("BASE_VIEW_ID")
|
| 1863 |
;
|
1868 |
;
|
| 1864 |
/
|
1869 |
/
|
| 1865 |
--------------------------------------------------------
|
1870 |
--------------------------------------------------------
|
| 1866 |
-- DDL for Index INX_DAEMON_INST_PV_ID
|
1871 |
-- DDL for Index INX_DAEMON_INST_PV_ID
|
| 1867 |
--------------------------------------------------------
|
1872 |
--------------------------------------------------------
|
| 1868 |
|
1873 |
|
| 1869 |
CREATE INDEX "INX_DAEMON_INST_PV_ID" ON "DAEMON_INSTRUCTIONS" ("PV_ID")
|
1874 |
CREATE INDEX "INX_DAEMON_INST_PV_ID" ON "DAEMON_INSTRUCTIONS" ("PV_ID")
|
| 1870 |
;
|
1875 |
;
|
| 1871 |
/
|
1876 |
/
|
| 1872 |
--------------------------------------------------------
|
1877 |
--------------------------------------------------------
|
| 1873 |
-- DDL for Index UNQ_PROJECT_EXT
|
1878 |
-- DDL for Index UNQ_PROJECT_EXT
|
| 1874 |
--------------------------------------------------------
|
1879 |
--------------------------------------------------------
|
| 1875 |
|
1880 |
|
| 1876 |
CREATE UNIQUE INDEX "UNQ_PROJECT_EXT" ON "PROJECT_EXTENTIONS" ("PROJ_ID", "EXT_NAME")
|
1881 |
CREATE UNIQUE INDEX "UNQ_PROJECT_EXT" ON "PROJECT_EXTENTIONS" ("PROJ_ID", "EXT_NAME")
|
| 1877 |
;
|
1882 |
;
|
| 1878 |
/
|
1883 |
/
|
| 1879 |
--------------------------------------------------------
|
1884 |
--------------------------------------------------------
|
| 1880 |
-- DDL for Index VCS_TYPE_PK
|
1885 |
-- DDL for Index VCS_TYPE_PK
|
| 1881 |
--------------------------------------------------------
|
1886 |
--------------------------------------------------------
|
| 1882 |
|
1887 |
|
| 1883 |
CREATE UNIQUE INDEX "VCS_TYPE_PK" ON "VCS_TYPE" ("VCS_TYPE_ID")
|
1888 |
CREATE UNIQUE INDEX "VCS_TYPE_PK" ON "VCS_TYPE" ("VCS_TYPE_ID")
|
| 1884 |
;
|
1889 |
;
|
| 1885 |
/
|
1890 |
/
|
| 1886 |
--------------------------------------------------------
|
1891 |
--------------------------------------------------------
|
| Line 1888... |
Line 1893... |
| 1888 |
--------------------------------------------------------
|
1893 |
--------------------------------------------------------
|
| 1889 |
|
1894 |
|
| 1890 |
CREATE INDEX "INX_PC_FILE_NAME" ON "PRODUCT_COMPONENTS" (UPPER("FILE_NAME"))
|
1895 |
CREATE INDEX "INX_PC_FILE_NAME" ON "PRODUCT_COMPONENTS" (UPPER("FILE_NAME"))
|
| 1891 |
;
|
1896 |
;
|
| 1892 |
/
|
1897 |
/
|
| 1893 |
--------------------------------------------------------
|
1898 |
--------------------------------------------------------
|
| 1894 |
-- DDL for Index PK_RELEASE_TAGS
|
1899 |
-- DDL for Index PK_RELEASE_TAGS
|
| 1895 |
--------------------------------------------------------
|
1900 |
--------------------------------------------------------
|
| 1896 |
|
1901 |
|
| 1897 |
CREATE UNIQUE INDEX "PK_RELEASE_TAGS" ON "RELEASE_TAGS" ("RTAG_ID")
|
1902 |
CREATE UNIQUE INDEX "PK_RELEASE_TAGS" ON "RELEASE_TAGS" ("RTAG_ID")
|
| 1898 |
;
|
1903 |
;
|
| 1899 |
/
|
1904 |
/
|
| 1900 |
--------------------------------------------------------
|
1905 |
--------------------------------------------------------
|
| Line 1909... |
Line 1914... |
| 1909 |
--------------------------------------------------------
|
1914 |
--------------------------------------------------------
|
| 1910 |
|
1915 |
|
| 1911 |
CREATE INDEX "INX_RCOMP_PV_ID" ON "RELEASE_COMPONENTS" ("PV_ID")
|
1916 |
CREATE INDEX "INX_RCOMP_PV_ID" ON "RELEASE_COMPONENTS" ("PV_ID")
|
| 1912 |
;
|
1917 |
;
|
| 1913 |
/
|
1918 |
/
|
| 1914 |
--------------------------------------------------------
|
1919 |
--------------------------------------------------------
|
| 1915 |
-- DDL for Index MICROSOFT_PK_DTPROPERTIES
|
1920 |
-- DDL for Index MICROSOFT_PK_DTPROPERTIES
|
| 1916 |
--------------------------------------------------------
|
1921 |
--------------------------------------------------------
|
| 1917 |
|
1922 |
|
| 1918 |
CREATE UNIQUE INDEX "MICROSOFT_PK_DTPROPERTIES" ON "MICROSOFTDTPROPERTIES" ("ID", "PROPERTY")
|
1923 |
CREATE UNIQUE INDEX "MICROSOFT_PK_DTPROPERTIES" ON "MICROSOFTDTPROPERTIES" ("ID", "PROPERTY")
|
| 1919 |
;
|
1924 |
;
|
| 1920 |
/
|
1925 |
/
|
| 1921 |
--------------------------------------------------------
|
1926 |
--------------------------------------------------------
|
| 1922 |
-- DDL for Index INX_UT_PV_TEST_TYPE
|
1927 |
-- DDL for Index INX_UT_PV_TEST_TYPE
|
| 1923 |
--------------------------------------------------------
|
1928 |
--------------------------------------------------------
|
| 1924 |
|
1929 |
|
| 1925 |
CREATE INDEX "INX_UT_PV_TEST_TYPE" ON "UNIT_TESTS" ("PV_ID", "TEST_TYPES_FK")
|
1930 |
CREATE INDEX "INX_UT_PV_TEST_TYPE" ON "UNIT_TESTS" ("PV_ID", "TEST_TYPES_FK")
|
| 1926 |
;
|
1931 |
;
|
| 1927 |
/
|
1932 |
/
|
| 1928 |
--------------------------------------------------------
|
1933 |
--------------------------------------------------------
|
| 1929 |
-- DDL for Index PK_WORLDS
|
1934 |
-- DDL for Index PK_WORLDS
|
| 1930 |
--------------------------------------------------------
|
1935 |
--------------------------------------------------------
|
| 1931 |
|
1936 |
|
| 1932 |
CREATE UNIQUE INDEX "PK_WORLDS" ON "WORLDS" ("WORLD_ID")
|
1937 |
CREATE UNIQUE INDEX "PK_WORLDS" ON "WORLDS" ("WORLD_ID")
|
| 1933 |
;
|
1938 |
;
|
| 1934 |
/
|
1939 |
/
|
| 1935 |
--------------------------------------------------------
|
1940 |
--------------------------------------------------------
|
| 1936 |
-- DDL for Index UNQ_AN_PART2
|
1941 |
-- DDL for Index UNQ_AN_PART2
|
| 1937 |
--------------------------------------------------------
|
1942 |
--------------------------------------------------------
|
| 1938 |
|
1943 |
|
| 1939 |
CREATE UNIQUE INDEX "UNQ_AN_PART2" ON "ADDITIONAL_NOTES" ("PV_ID", "NOTE_TITLE")
|
1944 |
CREATE UNIQUE INDEX "UNQ_AN_PART2" ON "ADDITIONAL_NOTES" ("PV_ID", "NOTE_TITLE")
|
| 1940 |
;
|
1945 |
;
|
| 1941 |
/
|
1946 |
/
|
| 1942 |
--------------------------------------------------------
|
1947 |
--------------------------------------------------------
|
| 1943 |
-- Constraints for Table RELEASE_TAGS
|
1948 |
-- Constraints for Table RELEASE_TAGS
|
| 1944 |
--------------------------------------------------------
|
1949 |
--------------------------------------------------------
|
| 1945 |
|
1950 |
|
| 1946 |
ALTER TABLE "RELEASE_TAGS" ADD CONSTRAINT "PK_RELEASE_TAGS" PRIMARY KEY ("RTAG_ID") ENABLE;
|
1951 |
ALTER TABLE "RELEASE_TAGS" ADD CONSTRAINT "PK_RELEASE_TAGS" PRIMARY KEY ("RTAG_ID") ENABLE;
|
| 1947 |
ALTER TABLE "RELEASE_TAGS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
|
1952 |
ALTER TABLE "RELEASE_TAGS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
|
| Line 1951... |
Line 1956... |
| 1951 |
ALTER TABLE "RELEASE_TAGS" MODIFY ("OFFICIAL" NOT NULL ENABLE);
|
1956 |
ALTER TABLE "RELEASE_TAGS" MODIFY ("OFFICIAL" NOT NULL ENABLE);
|
| 1952 |
ALTER TABLE "RELEASE_TAGS" MODIFY ("RTAG_NAME" NOT NULL ENABLE);
|
1957 |
ALTER TABLE "RELEASE_TAGS" MODIFY ("RTAG_NAME" NOT NULL ENABLE);
|
| 1953 |
ALTER TABLE "RELEASE_TAGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
1958 |
ALTER TABLE "RELEASE_TAGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 1954 |
/
|
1959 |
/
|
| 1955 |
--------------------------------------------------------
|
1960 |
--------------------------------------------------------
|
| 1956 |
-- Constraints for Table RIPPLE_FIELD_STATES
|
1961 |
-- Constraints for Table RIPPLE_FIELD_STATES
|
| 1957 |
--------------------------------------------------------
|
1962 |
--------------------------------------------------------
|
| 1958 |
|
1963 |
|
| 1959 |
ALTER TABLE "RIPPLE_FIELD_STATES" MODIFY ("STATE_ACRONYM" NOT NULL DISABLE);
|
1964 |
ALTER TABLE "RIPPLE_FIELD_STATES" MODIFY ("STATE_ACRONYM" NOT NULL DISABLE);
|
| 1960 |
ALTER TABLE "RIPPLE_FIELD_STATES" MODIFY ("STATE_ID" NOT NULL ENABLE);
|
1965 |
ALTER TABLE "RIPPLE_FIELD_STATES" MODIFY ("STATE_ID" NOT NULL ENABLE);
|
| 1961 |
/
|
1966 |
/
|
| 1962 |
--------------------------------------------------------
|
1967 |
--------------------------------------------------------
|
| 1963 |
-- Constraints for Table RUNTIME_DEPENDENCIES
|
1968 |
-- Constraints for Table RUNTIME_DEPENDENCIES
|
| 1964 |
--------------------------------------------------------
|
1969 |
--------------------------------------------------------
|
| 1965 |
|
1970 |
|
| 1966 |
ALTER TABLE "RUNTIME_DEPENDENCIES" MODIFY ("MOD_USER" NOT NULL ENABLE);
|
1971 |
ALTER TABLE "RUNTIME_DEPENDENCIES" MODIFY ("MOD_USER" NOT NULL ENABLE);
|
| 1967 |
ALTER TABLE "RUNTIME_DEPENDENCIES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
|
1972 |
ALTER TABLE "RUNTIME_DEPENDENCIES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
|
| 1968 |
ALTER TABLE "RUNTIME_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
1973 |
ALTER TABLE "RUNTIME_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 1969 |
/
|
1974 |
/
|
| 1970 |
--------------------------------------------------------
|
1975 |
--------------------------------------------------------
|
| 1971 |
-- Constraints for Table PACKAGE_PROCESSES
|
1976 |
-- Constraints for Table PACKAGE_PROCESSES
|
| 1972 |
--------------------------------------------------------
|
1977 |
--------------------------------------------------------
|
| 1973 |
|
1978 |
|
| 1974 |
ALTER TABLE "PACKAGE_PROCESSES" MODIFY ("PROC_ID" NOT NULL ENABLE);
|
1979 |
ALTER TABLE "PACKAGE_PROCESSES" MODIFY ("PROC_ID" NOT NULL ENABLE);
|
| 1975 |
ALTER TABLE "PACKAGE_PROCESSES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
1980 |
ALTER TABLE "PACKAGE_PROCESSES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 1976 |
/
|
1981 |
/
|
| 1977 |
--------------------------------------------------------
|
1982 |
--------------------------------------------------------
|
| Line 1985... |
Line 1990... |
| 1985 |
-- Constraints for Table RELEASE_COMPONENTS
|
1990 |
-- Constraints for Table RELEASE_COMPONENTS
|
| 1986 |
--------------------------------------------------------
|
1991 |
--------------------------------------------------------
|
| 1987 |
|
1992 |
|
| 1988 |
ALTER TABLE "RELEASE_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
1993 |
ALTER TABLE "RELEASE_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 1989 |
/
|
1994 |
/
|
| 1990 |
--------------------------------------------------------
|
1995 |
--------------------------------------------------------
|
| 1991 |
-- Constraints for Table VIEW_SETTINGS
|
1996 |
-- Constraints for Table VIEW_SETTINGS
|
| 1992 |
--------------------------------------------------------
|
1997 |
--------------------------------------------------------
|
| 1993 |
|
1998 |
|
| 1994 |
ALTER TABLE "VIEW_SETTINGS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
|
1999 |
ALTER TABLE "VIEW_SETTINGS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
|
| 1995 |
ALTER TABLE "VIEW_SETTINGS" MODIFY ("USER_ID" NOT NULL ENABLE);
|
2000 |
ALTER TABLE "VIEW_SETTINGS" MODIFY ("USER_ID" NOT NULL ENABLE);
|
| 1996 |
/
|
2001 |
/
|
| 1997 |
--------------------------------------------------------
|
2002 |
--------------------------------------------------------
|
| Line 2038... |
Line 2043... |
| 2038 |
|
2043 |
|
| 2039 |
ALTER TABLE "PRODUCT_STATES" ADD CONSTRAINT "PRODUCT_STATES_PK" PRIMARY KEY ("STATE_ID") ENABLE;
|
2044 |
ALTER TABLE "PRODUCT_STATES" ADD CONSTRAINT "PRODUCT_STATES_PK" PRIMARY KEY ("STATE_ID") ENABLE;
|
| 2040 |
ALTER TABLE "PRODUCT_STATES" MODIFY ("STATE" NOT NULL ENABLE);
|
2045 |
ALTER TABLE "PRODUCT_STATES" MODIFY ("STATE" NOT NULL ENABLE);
|
| 2041 |
ALTER TABLE "PRODUCT_STATES" MODIFY ("STATE_ID" NOT NULL ENABLE);
|
2046 |
ALTER TABLE "PRODUCT_STATES" MODIFY ("STATE_ID" NOT NULL ENABLE);
|
| 2042 |
/
|
2047 |
/
|
| 2043 |
--------------------------------------------------------
|
2048 |
--------------------------------------------------------
|
| 2044 |
-- Constraints for Table PRODUCT_COMPONENTS
|
2049 |
-- Constraints for Table PRODUCT_COMPONENTS
|
| 2045 |
--------------------------------------------------------
|
2050 |
--------------------------------------------------------
|
| 2046 |
|
2051 |
|
| 2047 |
ALTER TABLE "PRODUCT_COMPONENTS" MODIFY ("OS_ID" NOT NULL ENABLE);
|
2052 |
ALTER TABLE "PRODUCT_COMPONENTS" MODIFY ("OS_ID" NOT NULL ENABLE);
|
| 2048 |
ALTER TABLE "PRODUCT_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2053 |
ALTER TABLE "PRODUCT_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2049 |
/
|
2054 |
/
|
| 2050 |
--------------------------------------------------------
|
2055 |
--------------------------------------------------------
|
| 2051 |
-- Constraints for Table PACKAGE_PATCHES
|
2056 |
-- Constraints for Table PACKAGE_PATCHES
|
| 2052 |
--------------------------------------------------------
|
2057 |
--------------------------------------------------------
|
| 2053 |
|
2058 |
|
| 2054 |
ALTER TABLE "PACKAGE_PATCHES" MODIFY ("INSTALL_ORDER" NOT NULL ENABLE);
|
2059 |
ALTER TABLE "PACKAGE_PATCHES" MODIFY ("INSTALL_ORDER" NOT NULL ENABLE);
|
| 2055 |
ALTER TABLE "PACKAGE_PATCHES" MODIFY ("PATCH_ID" NOT NULL ENABLE);
|
2060 |
ALTER TABLE "PACKAGE_PATCHES" MODIFY ("PATCH_ID" NOT NULL ENABLE);
|
| 2056 |
ALTER TABLE "PACKAGE_PATCHES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2061 |
ALTER TABLE "PACKAGE_PATCHES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2057 |
/
|
2062 |
/
|
| 2058 |
--------------------------------------------------------
|
2063 |
--------------------------------------------------------
|
| 2059 |
-- Constraints for Table RUN_LEVEL_SCHEDULE
|
2064 |
-- Constraints for Table RUN_LEVEL_SCHEDULE
|
| 2060 |
--------------------------------------------------------
|
2065 |
--------------------------------------------------------
|
| 2061 |
|
2066 |
|
| 2062 |
ALTER TABLE "RUN_LEVEL_SCHEDULE" ADD PRIMARY KEY ("SCHEDULED_ID") ENABLE;
|
2067 |
ALTER TABLE "RUN_LEVEL_SCHEDULE" ADD PRIMARY KEY ("SCHEDULED_ID") ENABLE;
|
| 2063 |
ALTER TABLE "RUN_LEVEL_SCHEDULE" MODIFY ("SCHEDULED_ID" NOT NULL ENABLE);
|
2068 |
ALTER TABLE "RUN_LEVEL_SCHEDULE" MODIFY ("SCHEDULED_ID" NOT NULL ENABLE);
|
| 2064 |
/
|
2069 |
/
|
| 2065 |
--------------------------------------------------------
|
2070 |
--------------------------------------------------------
|
| Line 2077... |
Line 2082... |
| 2077 |
|
2082 |
|
| 2078 |
ALTER TABLE "NOTE_MANAGER" ADD CONSTRAINT "PKNOTE_MANAGER1" PRIMARY KEY ("NID") ENABLE;
|
2083 |
ALTER TABLE "NOTE_MANAGER" ADD CONSTRAINT "PKNOTE_MANAGER1" PRIMARY KEY ("NID") ENABLE;
|
| 2079 |
ALTER TABLE "NOTE_MANAGER" MODIFY ("NID" NOT NULL ENABLE);
|
2084 |
ALTER TABLE "NOTE_MANAGER" MODIFY ("NID" NOT NULL ENABLE);
|
| 2080 |
/
|
2085 |
/
|
| 2081 |
--------------------------------------------------------
|
2086 |
--------------------------------------------------------
|
| 2082 |
-- Constraints for Table BUILD_SERVICE_CONFIG
|
2087 |
-- Constraints for Table BUILD_SERVICE_CONFIG
|
| 2083 |
--------------------------------------------------------
|
2088 |
--------------------------------------------------------
|
| 2084 |
|
2089 |
|
| 2085 |
ALTER TABLE "BUILD_SERVICE_CONFIG" MODIFY ("CONFIG" NOT NULL ENABLE);
|
2090 |
ALTER TABLE "BUILD_SERVICE_CONFIG" MODIFY ("CONFIG" NOT NULL ENABLE);
|
| 2086 |
ALTER TABLE "BUILD_SERVICE_CONFIG" MODIFY ("SERVICE" NOT NULL ENABLE);
|
2091 |
ALTER TABLE "BUILD_SERVICE_CONFIG" MODIFY ("SERVICE" NOT NULL ENABLE);
|
| 2087 |
/
|
2092 |
/
|
| 2088 |
--------------------------------------------------------
|
2093 |
--------------------------------------------------------
|
| 2089 |
-- Constraints for Table GBE_MACHTYPE
|
2094 |
-- Constraints for Table GBE_MACHTYPE
|
| 2090 |
--------------------------------------------------------
|
2095 |
--------------------------------------------------------
|
| 2091 |
|
2096 |
|
| 2092 |
ALTER TABLE "GBE_MACHTYPE" MODIFY ("BM_ID" NOT NULL ENABLE);
|
2097 |
ALTER TABLE "GBE_MACHTYPE" MODIFY ("BM_ID" NOT NULL ENABLE);
|
| 2093 |
ALTER TABLE "GBE_MACHTYPE" ADD PRIMARY KEY ("GBE_ID") ENABLE;
|
2098 |
ALTER TABLE "GBE_MACHTYPE" ADD PRIMARY KEY ("GBE_ID") ENABLE;
|
| 2094 |
ALTER TABLE "GBE_MACHTYPE" MODIFY ("GBE_VALUE" NOT NULL ENABLE);
|
2099 |
ALTER TABLE "GBE_MACHTYPE" MODIFY ("GBE_VALUE" NOT NULL ENABLE);
|
| 2095 |
ALTER TABLE "GBE_MACHTYPE" MODIFY ("GBE_ID" NOT NULL ENABLE);
|
2100 |
ALTER TABLE "GBE_MACHTYPE" MODIFY ("GBE_ID" NOT NULL ENABLE);
|
| 2096 |
/
|
2101 |
/
|
| 2097 |
--------------------------------------------------------
|
2102 |
--------------------------------------------------------
|
| 2098 |
-- Constraints for Table ACTION_LOG
|
2103 |
-- Constraints for Table ACTION_LOG
|
| 2099 |
--------------------------------------------------------
|
2104 |
--------------------------------------------------------
|
| 2100 |
|
2105 |
|
| 2101 |
ALTER TABLE "ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
|
2106 |
ALTER TABLE "ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
|
| 2102 |
ALTER TABLE "ACTION_LOG" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2107 |
ALTER TABLE "ACTION_LOG" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2103 |
ALTER TABLE "ACTION_LOG" MODIFY ("ACTION_DATETIME" NOT NULL ENABLE);
|
2108 |
ALTER TABLE "ACTION_LOG" MODIFY ("ACTION_DATETIME" NOT NULL ENABLE);
|
| 2104 |
ALTER TABLE "ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
|
2109 |
ALTER TABLE "ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
|
| 2105 |
/
|
2110 |
/
|
| 2106 |
--------------------------------------------------------
|
2111 |
--------------------------------------------------------
|
| 2107 |
-- Constraints for Table ADDITIONAL_NOTES
|
2112 |
-- Constraints for Table ADDITIONAL_NOTES
|
| 2108 |
--------------------------------------------------------
|
2113 |
--------------------------------------------------------
|
| 2109 |
|
2114 |
|
| 2110 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("MOD_USER" NOT NULL ENABLE);
|
2115 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("MOD_USER" NOT NULL ENABLE);
|
| 2111 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
|
2116 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
|
| 2112 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("NOTE_TITLE" NOT NULL ENABLE);
|
2117 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("NOTE_TITLE" NOT NULL ENABLE);
|
| 2113 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2118 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2114 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("NOTE_ID" NOT NULL ENABLE);
|
2119 |
ALTER TABLE "ADDITIONAL_NOTES" MODIFY ("NOTE_ID" NOT NULL ENABLE);
|
| 2115 |
/
|
2120 |
/
|
| 2116 |
--------------------------------------------------------
|
2121 |
--------------------------------------------------------
|
| 2117 |
-- Constraints for Table BUILD_STANDARDS_ADDENDUM
|
2122 |
-- Constraints for Table BUILD_STANDARDS_ADDENDUM
|
| 2118 |
--------------------------------------------------------
|
2123 |
--------------------------------------------------------
|
| 2119 |
|
2124 |
|
| 2120 |
ALTER TABLE "BUILD_STANDARDS_ADDENDUM" ADD CONSTRAINT "BUILD_STANDARDS_ADDENDUM_PK" PRIMARY KEY ("BSA_ID") ENABLE;
|
2125 |
ALTER TABLE "BUILD_STANDARDS_ADDENDUM" ADD CONSTRAINT "BUILD_STANDARDS_ADDENDUM_PK" PRIMARY KEY ("BSA_ID") ENABLE;
|
| 2121 |
ALTER TABLE "BUILD_STANDARDS_ADDENDUM" MODIFY ("BS_ID" NOT NULL ENABLE);
|
2126 |
ALTER TABLE "BUILD_STANDARDS_ADDENDUM" MODIFY ("BS_ID" NOT NULL ENABLE);
|
| 2122 |
ALTER TABLE "BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_NAME" NOT NULL ENABLE);
|
2127 |
ALTER TABLE "BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_NAME" NOT NULL ENABLE);
|
| 2123 |
ALTER TABLE "BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_ID" NOT NULL ENABLE);
|
2128 |
ALTER TABLE "BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_ID" NOT NULL ENABLE);
|
| 2124 |
/
|
2129 |
/
|
| 2125 |
--------------------------------------------------------
|
2130 |
--------------------------------------------------------
|
| 2126 |
-- Constraints for Table TEST_TYPES
|
2131 |
-- Constraints for Table TEST_TYPES
|
| 2127 |
--------------------------------------------------------
|
2132 |
--------------------------------------------------------
|
| 2128 |
|
2133 |
|
| 2129 |
ALTER TABLE "TEST_TYPES" ADD CONSTRAINT "PK_TEST_TYPES" PRIMARY KEY ("TEST_TYPE_ID") ENABLE;
|
2134 |
ALTER TABLE "TEST_TYPES" ADD CONSTRAINT "PK_TEST_TYPES" PRIMARY KEY ("TEST_TYPE_ID") ENABLE;
|
| 2130 |
ALTER TABLE "TEST_TYPES" MODIFY ("TEST_TYPE_NAME" NOT NULL ENABLE);
|
2135 |
ALTER TABLE "TEST_TYPES" MODIFY ("TEST_TYPE_NAME" NOT NULL ENABLE);
|
| Line 2150... |
Line 2155... |
| 2150 |
--------------------------------------------------------
|
2155 |
--------------------------------------------------------
|
| 2151 |
-- Constraints for Table RELEASE_CONFIG
|
2156 |
-- Constraints for Table RELEASE_CONFIG
|
| 2152 |
--------------------------------------------------------
|
2157 |
--------------------------------------------------------
|
| 2153 |
|
2158 |
|
| 2154 |
ALTER TABLE "RELEASE_CONFIG" ADD PRIMARY KEY ("RCON_ID") ENABLE;
|
2159 |
ALTER TABLE "RELEASE_CONFIG" ADD PRIMARY KEY ("RCON_ID") ENABLE;
|
| 2155 |
ALTER TABLE "RELEASE_CONFIG" MODIFY ("GBE_ID" NOT NULL ENABLE);
|
- |
|
| 2156 |
ALTER TABLE "RELEASE_CONFIG" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2160 |
ALTER TABLE "RELEASE_CONFIG" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2157 |
ALTER TABLE "RELEASE_CONFIG" MODIFY ("RCON_ID" NOT NULL ENABLE);
|
2161 |
ALTER TABLE "RELEASE_CONFIG" MODIFY ("RCON_ID" NOT NULL ENABLE);
|
| 2158 |
/
|
2162 |
/
|
| 2159 |
--------------------------------------------------------
|
2163 |
--------------------------------------------------------
|
| 2160 |
-- Constraints for Table VIEWS
|
2164 |
-- Constraints for Table VIEWS
|
| Line 2171... |
Line 2175... |
| 2171 |
-- Constraints for Table JIRA_ISSUES
|
2175 |
-- Constraints for Table JIRA_ISSUES
|
| 2172 |
--------------------------------------------------------
|
2176 |
--------------------------------------------------------
|
| 2173 |
|
2177 |
|
| 2174 |
ALTER TABLE "JIRA_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2178 |
ALTER TABLE "JIRA_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2175 |
/
|
2179 |
/
|
| 2176 |
--------------------------------------------------------
|
2180 |
--------------------------------------------------------
|
| 2177 |
-- Constraints for Table PLATFORMS
|
2181 |
-- Constraints for Table PLATFORMS
|
| 2178 |
--------------------------------------------------------
|
2182 |
--------------------------------------------------------
|
| 2179 |
|
2183 |
|
| 2180 |
ALTER TABLE "PLATFORMS" MODIFY ("NAME" NOT NULL ENABLE);
|
2184 |
ALTER TABLE "PLATFORMS" MODIFY ("NAME" NOT NULL ENABLE);
|
| 2181 |
ALTER TABLE "PLATFORMS" MODIFY ("CODE" NOT NULL ENABLE);
|
2185 |
ALTER TABLE "PLATFORMS" MODIFY ("CODE" NOT NULL ENABLE);
|
| 2182 |
/
|
2186 |
/
|
| 2183 |
--------------------------------------------------------
|
2187 |
--------------------------------------------------------
|
| Line 2314... |
Line 2318... |
| 2314 |
|
2318 |
|
| 2315 |
ALTER TABLE "BUILD_STANDARDS" ADD CONSTRAINT "BUILD_STANDARDS_PK" PRIMARY KEY ("BS_ID") ENABLE;
|
2319 |
ALTER TABLE "BUILD_STANDARDS" ADD CONSTRAINT "BUILD_STANDARDS_PK" PRIMARY KEY ("BS_ID") ENABLE;
|
| 2316 |
ALTER TABLE "BUILD_STANDARDS" MODIFY ("BS_NAME" NOT NULL ENABLE);
|
2320 |
ALTER TABLE "BUILD_STANDARDS" MODIFY ("BS_NAME" NOT NULL ENABLE);
|
| 2317 |
ALTER TABLE "BUILD_STANDARDS" MODIFY ("BS_ID" NOT NULL ENABLE);
|
2321 |
ALTER TABLE "BUILD_STANDARDS" MODIFY ("BS_ID" NOT NULL ENABLE);
|
| 2318 |
/
|
2322 |
/
|
| 2319 |
--------------------------------------------------------
|
2323 |
--------------------------------------------------------
|
| 2320 |
-- Constraints for Table PACKAGE_BUILD_ENV
|
2324 |
-- Constraints for Table PACKAGE_BUILD_ENV
|
| 2321 |
--------------------------------------------------------
|
2325 |
--------------------------------------------------------
|
| 2322 |
|
2326 |
|
| 2323 |
ALTER TABLE "PACKAGE_BUILD_ENV" MODIFY ("BE_ID" NOT NULL ENABLE);
|
2327 |
ALTER TABLE "PACKAGE_BUILD_ENV" MODIFY ("BE_ID" NOT NULL ENABLE);
|
| 2324 |
ALTER TABLE "PACKAGE_BUILD_ENV" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2328 |
ALTER TABLE "PACKAGE_BUILD_ENV" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2325 |
/
|
2329 |
/
|
| 2326 |
--------------------------------------------------------
|
2330 |
--------------------------------------------------------
|
| Line 2332... |
Line 2336... |
| 2332 |
ALTER TABLE "VTREES" MODIFY ("VTREE_NAME" NOT NULL ENABLE);
|
2336 |
ALTER TABLE "VTREES" MODIFY ("VTREE_NAME" NOT NULL ENABLE);
|
| 2333 |
ALTER TABLE "VTREES" MODIFY ("PROJ_ID" NOT NULL ENABLE);
|
2337 |
ALTER TABLE "VTREES" MODIFY ("PROJ_ID" NOT NULL ENABLE);
|
| 2334 |
ALTER TABLE "VTREES" MODIFY ("VTREE_ID" NOT NULL ENABLE);
|
2338 |
ALTER TABLE "VTREES" MODIFY ("VTREE_ID" NOT NULL ENABLE);
|
| 2335 |
/
|
2339 |
/
|
| 2336 |
--------------------------------------------------------
|
2340 |
--------------------------------------------------------
|
| 2337 |
-- Constraints for Table NOTIFICATION_HISTORY
|
2341 |
-- Constraints for Table NOTIFICATION_HISTORY
|
| 2338 |
--------------------------------------------------------
|
2342 |
--------------------------------------------------------
|
| 2339 |
|
2343 |
|
| 2340 |
ALTER TABLE "NOTIFICATION_HISTORY" ADD CONSTRAINT "PK_NOTIFICATION_HISTORY" PRIMARY KEY ("RTAG_ID", "PV_ID", "USER_ID") ENABLE;
|
2344 |
ALTER TABLE "NOTIFICATION_HISTORY" ADD CONSTRAINT "PK_NOTIFICATION_HISTORY" PRIMARY KEY ("RTAG_ID", "PV_ID", "USER_ID") ENABLE;
|
| 2341 |
ALTER TABLE "NOTIFICATION_HISTORY" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
|
2345 |
ALTER TABLE "NOTIFICATION_HISTORY" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
|
| 2342 |
ALTER TABLE "NOTIFICATION_HISTORY" MODIFY ("USER_ID" NOT NULL ENABLE);
|
2346 |
ALTER TABLE "NOTIFICATION_HISTORY" MODIFY ("USER_ID" NOT NULL ENABLE);
|
| 2343 |
ALTER TABLE "NOTIFICATION_HISTORY" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2347 |
ALTER TABLE "NOTIFICATION_HISTORY" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2344 |
ALTER TABLE "NOTIFICATION_HISTORY" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2348 |
ALTER TABLE "NOTIFICATION_HISTORY" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2345 |
/
|
2349 |
/
|
| 2346 |
--------------------------------------------------------
|
2350 |
--------------------------------------------------------
|
| 2347 |
-- Constraints for Table RELEASE_LINKS
|
2351 |
-- Constraints for Table RELEASE_LINKS
|
| 2348 |
--------------------------------------------------------
|
2352 |
--------------------------------------------------------
|
| 2349 |
|
2353 |
|
| 2350 |
ALTER TABLE "RELEASE_LINKS" MODIFY ("REF_RTAG_ID" NOT NULL ENABLE);
|
2354 |
ALTER TABLE "RELEASE_LINKS" MODIFY ("REF_RTAG_ID" NOT NULL ENABLE);
|
| 2351 |
ALTER TABLE "RELEASE_LINKS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2355 |
ALTER TABLE "RELEASE_LINKS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2352 |
/
|
2356 |
/
|
| 2353 |
--------------------------------------------------------
|
2357 |
--------------------------------------------------------
|
| 2354 |
-- Constraints for Table PACKAGES
|
2358 |
-- Constraints for Table PACKAGES
|
| 2355 |
--------------------------------------------------------
|
2359 |
--------------------------------------------------------
|
| 2356 |
|
2360 |
|
| 2357 |
ALTER TABLE "PACKAGES" ADD CONSTRAINT "PK_PACKAGES" PRIMARY KEY ("PKG_ID") ENABLE;
|
2361 |
ALTER TABLE "PACKAGES" ADD CONSTRAINT "PK_PACKAGES" PRIMARY KEY ("PKG_ID") ENABLE;
|
| 2358 |
ALTER TABLE "PACKAGES" MODIFY ("PKG_NAME" NOT NULL ENABLE);
|
2362 |
ALTER TABLE "PACKAGES" MODIFY ("PKG_NAME" NOT NULL ENABLE);
|
| 2359 |
ALTER TABLE "PACKAGES" MODIFY ("PKG_ID" NOT NULL ENABLE);
|
2363 |
ALTER TABLE "PACKAGES" MODIFY ("PKG_ID" NOT NULL ENABLE);
|
| 2360 |
/
|
2364 |
/
|
| 2361 |
--------------------------------------------------------
|
2365 |
--------------------------------------------------------
|
| 2362 |
-- Constraints for Table REPEAT_SCHEDULE
|
2366 |
-- Constraints for Table REPEAT_SCHEDULE
|
| 2363 |
--------------------------------------------------------
|
2367 |
--------------------------------------------------------
|
| 2364 |
|
2368 |
|
| 2365 |
ALTER TABLE "REPEAT_SCHEDULE" ADD PRIMARY KEY ("RPT_ID") ENABLE;
|
2369 |
ALTER TABLE "REPEAT_SCHEDULE" ADD PRIMARY KEY ("RPT_ID") ENABLE;
|
| 2366 |
/
|
2370 |
/
|
| 2367 |
--------------------------------------------------------
|
2371 |
--------------------------------------------------------
|
| 2368 |
-- Constraints for Table PROJECTS
|
2372 |
-- Constraints for Table PROJECTS
|
| 2369 |
--------------------------------------------------------
|
2373 |
--------------------------------------------------------
|
| 2370 |
|
2374 |
|
| 2371 |
ALTER TABLE "PROJECTS" ADD CONSTRAINT "PK_PROJECTS" PRIMARY KEY ("PROJ_ID") ENABLE;
|
2375 |
ALTER TABLE "PROJECTS" ADD CONSTRAINT "PK_PROJECTS" PRIMARY KEY ("PROJ_ID") ENABLE;
|
| 2372 |
ALTER TABLE "PROJECTS" MODIFY ("PROJ_NAME" NOT NULL ENABLE);
|
2376 |
ALTER TABLE "PROJECTS" MODIFY ("PROJ_NAME" NOT NULL ENABLE);
|
| 2373 |
ALTER TABLE "PROJECTS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
|
2377 |
ALTER TABLE "PROJECTS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
|
| 2374 |
/
|
2378 |
/
|
| 2375 |
--------------------------------------------------------
|
2379 |
--------------------------------------------------------
|
| 2376 |
-- Constraints for Table LICENCING
|
2380 |
-- Constraints for Table LICENCING
|
| 2377 |
--------------------------------------------------------
|
2381 |
--------------------------------------------------------
|
| 2378 |
|
2382 |
|
| 2379 |
ALTER TABLE "LICENCING" MODIFY ("LICENCE" NOT NULL ENABLE);
|
2383 |
ALTER TABLE "LICENCING" MODIFY ("LICENCE" NOT NULL ENABLE);
|
| 2380 |
ALTER TABLE "LICENCING" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2384 |
ALTER TABLE "LICENCING" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2381 |
/
|
2385 |
/
|
| 2382 |
--------------------------------------------------------
|
2386 |
--------------------------------------------------------
|
| 2383 |
-- Constraints for Table MESSAGE_BOARD
|
2387 |
-- Constraints for Table MESSAGE_BOARD
|
| 2384 |
--------------------------------------------------------
|
2388 |
--------------------------------------------------------
|
| 2385 |
|
2389 |
|
| 2386 |
ALTER TABLE "MESSAGE_BOARD" ADD CONSTRAINT "PK_MESSAGE_BOARD" PRIMARY KEY ("MSG_ID") ENABLE;
|
2390 |
ALTER TABLE "MESSAGE_BOARD" ADD CONSTRAINT "PK_MESSAGE_BOARD" PRIMARY KEY ("MSG_ID") ENABLE;
|
| 2387 |
ALTER TABLE "MESSAGE_BOARD" MODIFY ("SUBMITION_DATE" NOT NULL ENABLE);
|
2391 |
ALTER TABLE "MESSAGE_BOARD" MODIFY ("SUBMITION_DATE" NOT NULL ENABLE);
|
| 2388 |
ALTER TABLE "MESSAGE_BOARD" MODIFY ("MSG_DETAILS" NOT NULL ENABLE);
|
2392 |
ALTER TABLE "MESSAGE_BOARD" MODIFY ("MSG_DETAILS" NOT NULL ENABLE);
|
| 2389 |
ALTER TABLE "MESSAGE_BOARD" MODIFY ("MSG_ID" NOT NULL ENABLE);
|
2393 |
ALTER TABLE "MESSAGE_BOARD" MODIFY ("MSG_ID" NOT NULL ENABLE);
|
| 2390 |
/
|
2394 |
/
|
| 2391 |
--------------------------------------------------------
|
2395 |
--------------------------------------------------------
|
| 2392 |
-- Constraints for Table PROJECT_ACTION_LOG
|
2396 |
-- Constraints for Table PROJECT_ACTION_LOG
|
| 2393 |
--------------------------------------------------------
|
2397 |
--------------------------------------------------------
|
| 2394 |
|
2398 |
|
| 2395 |
ALTER TABLE "PROJECT_ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
|
2399 |
ALTER TABLE "PROJECT_ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
|
| 2396 |
ALTER TABLE "PROJECT_ACTION_LOG" MODIFY ("PROJ_ID" NOT NULL ENABLE);
|
2400 |
ALTER TABLE "PROJECT_ACTION_LOG" MODIFY ("PROJ_ID" NOT NULL ENABLE);
|
| 2397 |
ALTER TABLE "PROJECT_ACTION_LOG" MODIFY ("ACTION_DATETIME" NOT NULL ENABLE);
|
2401 |
ALTER TABLE "PROJECT_ACTION_LOG" MODIFY ("ACTION_DATETIME" NOT NULL ENABLE);
|
| 2398 |
ALTER TABLE "PROJECT_ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
|
2402 |
ALTER TABLE "PROJECT_ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
|
| 2399 |
/
|
2403 |
/
|
| 2400 |
--------------------------------------------------------
|
2404 |
--------------------------------------------------------
|
| 2401 |
-- Constraints for Table ARCHIVE_DATA
|
2405 |
-- Constraints for Table ARCHIVE_DATA
|
| 2402 |
--------------------------------------------------------
|
2406 |
--------------------------------------------------------
|
| 2403 |
|
2407 |
|
| 2404 |
ALTER TABLE "ARCHIVE_DATA" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2408 |
ALTER TABLE "ARCHIVE_DATA" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2405 |
ALTER TABLE "ARCHIVE_DATA" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2409 |
ALTER TABLE "ARCHIVE_DATA" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2406 |
/
|
2410 |
/
|
| 2407 |
--------------------------------------------------------
|
2411 |
--------------------------------------------------------
|
| 2408 |
-- Constraints for Table VALIDATION_RULES
|
2412 |
-- Constraints for Table VALIDATION_RULES
|
| 2409 |
--------------------------------------------------------
|
2413 |
--------------------------------------------------------
|
| 2410 |
|
2414 |
|
| 2411 |
ALTER TABLE "VALIDATION_RULES" MODIFY ("IS_REQUIRED" NOT NULL ENABLE);
|
2415 |
ALTER TABLE "VALIDATION_RULES" MODIFY ("IS_REQUIRED" NOT NULL ENABLE);
|
| 2412 |
ALTER TABLE "VALIDATION_RULES" MODIFY ("FIELD_NAME" NOT NULL ENABLE);
|
2416 |
ALTER TABLE "VALIDATION_RULES" MODIFY ("FIELD_NAME" NOT NULL ENABLE);
|
| 2413 |
/
|
2417 |
/
|
| 2414 |
--------------------------------------------------------
|
2418 |
--------------------------------------------------------
|
| 2415 |
-- Constraints for Table LICENCES
|
2419 |
-- Constraints for Table LICENCES
|
| 2416 |
--------------------------------------------------------
|
2420 |
--------------------------------------------------------
|
| 2417 |
|
2421 |
|
| 2418 |
ALTER TABLE "LICENCES" ADD CONSTRAINT "PK_LICENCES" PRIMARY KEY ("LICENCE") ENABLE;
|
2422 |
ALTER TABLE "LICENCES" ADD CONSTRAINT "PK_LICENCES" PRIMARY KEY ("LICENCE") ENABLE;
|
| 2419 |
ALTER TABLE "LICENCES" MODIFY ("NAME" NOT NULL ENABLE);
|
2423 |
ALTER TABLE "LICENCES" MODIFY ("NAME" NOT NULL ENABLE);
|
| 2420 |
ALTER TABLE "LICENCES" MODIFY ("LICENCE" NOT NULL ENABLE);
|
2424 |
ALTER TABLE "LICENCES" MODIFY ("LICENCE" NOT NULL ENABLE);
|
| 2421 |
/
|
2425 |
/
|
| 2422 |
--------------------------------------------------------
|
2426 |
--------------------------------------------------------
|
| 2423 |
-- Constraints for Table MEMBERS_GROUP
|
2427 |
-- Constraints for Table MEMBERS_GROUP
|
| 2424 |
--------------------------------------------------------
|
2428 |
--------------------------------------------------------
|
| 2425 |
|
2429 |
|
| 2426 |
ALTER TABLE "MEMBERS_GROUP" MODIFY ("GROUP_EMAIL_ID" NOT NULL ENABLE);
|
2430 |
ALTER TABLE "MEMBERS_GROUP" MODIFY ("GROUP_EMAIL_ID" NOT NULL ENABLE);
|
| 2427 |
/
|
2431 |
/
|
| 2428 |
--------------------------------------------------------
|
2432 |
--------------------------------------------------------
|
| 2429 |
-- Constraints for Table CQ_ISSUES
|
2433 |
-- Constraints for Table CQ_ISSUES
|
| 2430 |
--------------------------------------------------------
|
2434 |
--------------------------------------------------------
|
| 2431 |
|
2435 |
|
| 2432 |
ALTER TABLE "CQ_ISSUES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
|
2436 |
ALTER TABLE "CQ_ISSUES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
|
| 2433 |
ALTER TABLE "CQ_ISSUES" MODIFY ("ISS_STATE" NOT NULL ENABLE);
|
2437 |
ALTER TABLE "CQ_ISSUES" MODIFY ("ISS_STATE" NOT NULL ENABLE);
|
| 2434 |
ALTER TABLE "CQ_ISSUES" MODIFY ("ISS_ID" NOT NULL ENABLE);
|
2438 |
ALTER TABLE "CQ_ISSUES" MODIFY ("ISS_ID" NOT NULL ENABLE);
|
| 2435 |
ALTER TABLE "CQ_ISSUES" MODIFY ("ISS_DB" NOT NULL ENABLE);
|
2439 |
ALTER TABLE "CQ_ISSUES" MODIFY ("ISS_DB" NOT NULL ENABLE);
|
| 2436 |
ALTER TABLE "CQ_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2440 |
ALTER TABLE "CQ_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2437 |
/
|
2441 |
/
|
| 2438 |
--------------------------------------------------------
|
2442 |
--------------------------------------------------------
|
| 2439 |
-- Constraints for Table ARCHIVE_ACTION_LOG
|
2443 |
-- Constraints for Table ARCHIVE_ACTION_LOG
|
| 2440 |
--------------------------------------------------------
|
2444 |
--------------------------------------------------------
|
| 2441 |
|
2445 |
|
| 2442 |
ALTER TABLE "ARCHIVE_ACTION_LOG" MODIFY ("DESCRIPTION" NOT NULL ENABLE);
|
2446 |
ALTER TABLE "ARCHIVE_ACTION_LOG" MODIFY ("DESCRIPTION" NOT NULL ENABLE);
|
| 2443 |
ALTER TABLE "ARCHIVE_ACTION_LOG" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2447 |
ALTER TABLE "ARCHIVE_ACTION_LOG" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2444 |
ALTER TABLE "ARCHIVE_ACTION_LOG" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
|
2448 |
ALTER TABLE "ARCHIVE_ACTION_LOG" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
|
| 2445 |
ALTER TABLE "ARCHIVE_ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
|
2449 |
ALTER TABLE "ARCHIVE_ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
|
| 2446 |
/
|
2450 |
/
|
| 2447 |
--------------------------------------------------------
|
2451 |
--------------------------------------------------------
|
| 2448 |
-- Constraints for Table CODE_REVIEWS
|
2452 |
-- Constraints for Table CODE_REVIEWS
|
| 2449 |
--------------------------------------------------------
|
2453 |
--------------------------------------------------------
|
| 2450 |
|
2454 |
|
| 2451 |
ALTER TABLE "CODE_REVIEWS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2455 |
ALTER TABLE "CODE_REVIEWS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2452 |
/
|
2456 |
/
|
| 2453 |
--------------------------------------------------------
|
2457 |
--------------------------------------------------------
|
| 2454 |
-- Constraints for Table PLANNED
|
2458 |
-- Constraints for Table PLANNED
|
| 2455 |
--------------------------------------------------------
|
2459 |
--------------------------------------------------------
|
| 2456 |
|
2460 |
|
| 2457 |
ALTER TABLE "PLANNED" ADD CONSTRAINT "UNIQUE_PV_RTAG" UNIQUE ("PV_ID", "RTAG_ID") ENABLE;
|
2461 |
ALTER TABLE "PLANNED" ADD CONSTRAINT "UNIQUE_PV_RTAG" UNIQUE ("PV_ID", "RTAG_ID") ENABLE;
|
| 2458 |
ALTER TABLE "PLANNED" MODIFY ("VIEW_ID" NOT NULL ENABLE);
|
2462 |
ALTER TABLE "PLANNED" MODIFY ("VIEW_ID" NOT NULL ENABLE);
|
| 2459 |
ALTER TABLE "PLANNED" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2463 |
ALTER TABLE "PLANNED" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2460 |
ALTER TABLE "PLANNED" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2464 |
ALTER TABLE "PLANNED" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2461 |
/
|
2465 |
/
|
| 2462 |
--------------------------------------------------------
|
2466 |
--------------------------------------------------------
|
| 2463 |
-- Constraints for Table VCS_TYPE
|
2467 |
-- Constraints for Table VCS_TYPE
|
| 2464 |
--------------------------------------------------------
|
2468 |
--------------------------------------------------------
|
| 2465 |
|
2469 |
|
| 2466 |
ALTER TABLE "VCS_TYPE" ADD CONSTRAINT "VCS_TYPE_PK" PRIMARY KEY ("VCS_TYPE_ID") ENABLE;
|
2470 |
ALTER TABLE "VCS_TYPE" ADD CONSTRAINT "VCS_TYPE_PK" PRIMARY KEY ("VCS_TYPE_ID") ENABLE;
|
| 2467 |
ALTER TABLE "VCS_TYPE" MODIFY ("TAG" NOT NULL ENABLE);
|
2471 |
ALTER TABLE "VCS_TYPE" MODIFY ("TAG" NOT NULL ENABLE);
|
| 2468 |
ALTER TABLE "VCS_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
|
2472 |
ALTER TABLE "VCS_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
|
| 2469 |
ALTER TABLE "VCS_TYPE" MODIFY ("VCS_TYPE_ID" NOT NULL ENABLE);
|
2473 |
ALTER TABLE "VCS_TYPE" MODIFY ("VCS_TYPE_ID" NOT NULL ENABLE);
|
| 2470 |
/
|
2474 |
/
|
| 2471 |
--------------------------------------------------------
|
2475 |
--------------------------------------------------------
|
| 2472 |
-- Constraints for Table BUILD_MACHINES
|
2476 |
-- Constraints for Table BUILD_MACHINES
|
| 2473 |
--------------------------------------------------------
|
2477 |
--------------------------------------------------------
|
| 2474 |
|
2478 |
|
| 2475 |
ALTER TABLE "BUILD_MACHINES" ADD CONSTRAINT "BUILD_MACHINES_PK" PRIMARY KEY ("BM_ID") ENABLE;
|
2479 |
ALTER TABLE "BUILD_MACHINES" ADD CONSTRAINT "BUILD_MACHINES_PK" PRIMARY KEY ("BM_ID") ENABLE;
|
| 2476 |
ALTER TABLE "BUILD_MACHINES" MODIFY ("BM_NAME" NOT NULL ENABLE);
|
2480 |
ALTER TABLE "BUILD_MACHINES" MODIFY ("BM_NAME" NOT NULL ENABLE);
|
| 2477 |
ALTER TABLE "BUILD_MACHINES" MODIFY ("BM_ID" NOT NULL ENABLE);
|
2481 |
ALTER TABLE "BUILD_MACHINES" MODIFY ("BM_ID" NOT NULL ENABLE);
|
| 2478 |
/
|
2482 |
/
|
| 2479 |
--------------------------------------------------------
|
2483 |
--------------------------------------------------------
|
| 2480 |
-- Constraints for Table PEGGED_VERSIONS
|
2484 |
-- Constraints for Table PEGGED_VERSIONS
|
| 2481 |
--------------------------------------------------------
|
2485 |
--------------------------------------------------------
|
| 2482 |
|
2486 |
|
| 2483 |
ALTER TABLE "PEGGED_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2487 |
ALTER TABLE "PEGGED_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2484 |
ALTER TABLE "PEGGED_VERSIONS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2488 |
ALTER TABLE "PEGGED_VERSIONS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2485 |
/
|
2489 |
/
|
| 2486 |
--------------------------------------------------------
|
2490 |
--------------------------------------------------------
|
| 2487 |
-- Constraints for Table DAEMON_INSTRUCTIONS
|
2491 |
-- Constraints for Table DAEMON_INSTRUCTIONS
|
| 2488 |
--------------------------------------------------------
|
2492 |
--------------------------------------------------------
|
| 2489 |
|
2493 |
|
| 2490 |
ALTER TABLE "DAEMON_INSTRUCTIONS" ADD CONSTRAINT "DAEMON_INSTRUCTIONS_UK1" UNIQUE ("OP_CODE", "RTAG_ID", "PV_ID") ENABLE;
|
2494 |
ALTER TABLE "DAEMON_INSTRUCTIONS" ADD CONSTRAINT "DAEMON_INSTRUCTIONS_UK1" UNIQUE ("OP_CODE", "RTAG_ID", "PV_ID") ENABLE;
|
| 2491 |
ALTER TABLE "DAEMON_INSTRUCTIONS" ADD CONSTRAINT "DAEMON_INSTRUCTIONS_PK" PRIMARY KEY ("DAEMON_INSTRUCTIONS_ID") ENABLE;
|
2495 |
ALTER TABLE "DAEMON_INSTRUCTIONS" ADD CONSTRAINT "DAEMON_INSTRUCTIONS_PK" PRIMARY KEY ("DAEMON_INSTRUCTIONS_ID") ENABLE;
|
| 2492 |
ALTER TABLE "DAEMON_INSTRUCTIONS" MODIFY ("OP_CODE" NOT NULL ENABLE);
|
2496 |
ALTER TABLE "DAEMON_INSTRUCTIONS" MODIFY ("OP_CODE" NOT NULL ENABLE);
|
| 2493 |
ALTER TABLE "DAEMON_INSTRUCTIONS" MODIFY ("DAEMON_INSTRUCTIONS_ID" NOT NULL ENABLE);
|
2497 |
ALTER TABLE "DAEMON_INSTRUCTIONS" MODIFY ("DAEMON_INSTRUCTIONS_ID" NOT NULL ENABLE);
|
| Line 2499... |
Line 2503... |
| 2499 |
ALTER TABLE "WORK_IN_PROGRESS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
|
2503 |
ALTER TABLE "WORK_IN_PROGRESS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
|
| 2500 |
ALTER TABLE "WORK_IN_PROGRESS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2504 |
ALTER TABLE "WORK_IN_PROGRESS" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2501 |
ALTER TABLE "WORK_IN_PROGRESS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2505 |
ALTER TABLE "WORK_IN_PROGRESS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2502 |
/
|
2506 |
/
|
| 2503 |
--------------------------------------------------------
|
2507 |
--------------------------------------------------------
|
| 2504 |
-- Constraints for Table BUILD_ENV_DOCUMENTS
|
2508 |
-- Constraints for Table BUILD_ENV_DOCUMENTS
|
| 2505 |
--------------------------------------------------------
|
2509 |
--------------------------------------------------------
|
| 2506 |
|
2510 |
|
| 2507 |
ALTER TABLE "BUILD_ENV_DOCUMENTS" MODIFY ("DOC_NUM" NOT NULL ENABLE);
|
2511 |
ALTER TABLE "BUILD_ENV_DOCUMENTS" MODIFY ("DOC_NUM" NOT NULL ENABLE);
|
| 2508 |
ALTER TABLE "BUILD_ENV_DOCUMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
|
2512 |
ALTER TABLE "BUILD_ENV_DOCUMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
|
| 2509 |
/
|
2513 |
/
|
| 2510 |
--------------------------------------------------------
|
2514 |
--------------------------------------------------------
|
| 2511 |
-- Constraints for Table BUILD_ORDER
|
2515 |
-- Constraints for Table BUILD_ORDER
|
| 2512 |
--------------------------------------------------------
|
2516 |
--------------------------------------------------------
|
| 2513 |
|
2517 |
|
| 2514 |
ALTER TABLE "BUILD_ORDER" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2518 |
ALTER TABLE "BUILD_ORDER" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2515 |
ALTER TABLE "BUILD_ORDER" MODIFY ("STEP_NUM" NOT NULL ENABLE);
|
2519 |
ALTER TABLE "BUILD_ORDER" MODIFY ("STEP_NUM" NOT NULL ENABLE);
|
| 2516 |
ALTER TABLE "BUILD_ORDER" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2520 |
ALTER TABLE "BUILD_ORDER" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2517 |
/
|
2521 |
/
|
| 2518 |
--------------------------------------------------------
|
2522 |
--------------------------------------------------------
|
| 2519 |
-- Constraints for Table PACKAGE_DEPENDENCIES
|
2523 |
-- Constraints for Table PACKAGE_DEPENDENCIES
|
| 2520 |
--------------------------------------------------------
|
2524 |
--------------------------------------------------------
|
| 2521 |
|
2525 |
|
| 2522 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("BUILD_TYPE" NOT NULL ENABLE);
|
2526 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("BUILD_TYPE" NOT NULL ENABLE);
|
| 2523 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("DPKG_ID" NOT NULL ENABLE);
|
2527 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("DPKG_ID" NOT NULL ENABLE);
|
| 2524 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("PKG_ID" NOT NULL ENABLE);
|
2528 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("PKG_ID" NOT NULL ENABLE);
|
| 2525 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("DPV_ID" NOT NULL ENABLE);
|
2529 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("DPV_ID" NOT NULL ENABLE);
|
| 2526 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
2530 |
ALTER TABLE "PACKAGE_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
|
| 2527 |
/
|
2531 |
/
|
| 2528 |
--------------------------------------------------------
|
2532 |
--------------------------------------------------------
|
| 2529 |
-- Constraints for Table PROCESSES
|
2533 |
-- Constraints for Table PROCESSES
|
| 2530 |
--------------------------------------------------------
|
2534 |
--------------------------------------------------------
|
| 2531 |
|
2535 |
|
| 2532 |
ALTER TABLE "PROCESSES" ADD CONSTRAINT "PROCESSES_PK" PRIMARY KEY ("PROC_ID") ENABLE;
|
2536 |
ALTER TABLE "PROCESSES" ADD CONSTRAINT "PROCESSES_PK" PRIMARY KEY ("PROC_ID") ENABLE;
|
| 2533 |
ALTER TABLE "PROCESSES" MODIFY ("PROC_NAME" NOT NULL ENABLE);
|
2537 |
ALTER TABLE "PROCESSES" MODIFY ("PROC_NAME" NOT NULL ENABLE);
|
| 2534 |
ALTER TABLE "PROCESSES" MODIFY ("PROC_ID" NOT NULL ENABLE);
|
2538 |
ALTER TABLE "PROCESSES" MODIFY ("PROC_ID" NOT NULL ENABLE);
|
| 2535 |
/
|
2539 |
/
|
| 2536 |
--------------------------------------------------------
|
2540 |
--------------------------------------------------------
|
| 2537 |
-- Constraints for Table BUILD_ENVIRONMENTS
|
2541 |
-- Constraints for Table BUILD_ENVIRONMENTS
|
| 2538 |
--------------------------------------------------------
|
2542 |
--------------------------------------------------------
|
| 2539 |
|
2543 |
|
| 2540 |
ALTER TABLE "BUILD_ENVIRONMENTS" ADD CONSTRAINT "PK_BUILD_ENVIRONMENTS" PRIMARY KEY ("BE_ID") ENABLE;
|
2544 |
ALTER TABLE "BUILD_ENVIRONMENTS" ADD CONSTRAINT "PK_BUILD_ENVIRONMENTS" PRIMARY KEY ("BE_ID") ENABLE;
|
| 2541 |
ALTER TABLE "BUILD_ENVIRONMENTS" MODIFY ("BE_NAME" NOT NULL ENABLE);
|
2545 |
ALTER TABLE "BUILD_ENVIRONMENTS" MODIFY ("BE_NAME" NOT NULL ENABLE);
|
| 2542 |
ALTER TABLE "BUILD_ENVIRONMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
|
2546 |
ALTER TABLE "BUILD_ENVIRONMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
|
| 2543 |
/
|
2547 |
/
|
| 2544 |
--------------------------------------------------------
|
2548 |
--------------------------------------------------------
|
| 2545 |
-- Constraints for Table DEPRECATED_PACKAGES
|
2549 |
-- Constraints for Table DEPRECATED_PACKAGES
|
| 2546 |
--------------------------------------------------------
|
2550 |
--------------------------------------------------------
|
| 2547 |
|
2551 |
|
| 2548 |
ALTER TABLE "DEPRECATED_PACKAGES" MODIFY ("COMMENTS" NOT NULL ENABLE);
|
2552 |
ALTER TABLE "DEPRECATED_PACKAGES" MODIFY ("COMMENTS" NOT NULL ENABLE);
|
| 2549 |
ALTER TABLE "DEPRECATED_PACKAGES" MODIFY ("PKG_ID" NOT NULL ENABLE);
|
2553 |
ALTER TABLE "DEPRECATED_PACKAGES" MODIFY ("PKG_ID" NOT NULL ENABLE);
|
| 2550 |
ALTER TABLE "DEPRECATED_PACKAGES" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
2554 |
ALTER TABLE "DEPRECATED_PACKAGES" MODIFY ("RTAG_ID" NOT NULL ENABLE);
|
| 2551 |
/
|
2555 |
/
|
| Line 3507... |
Line 3511... |
| 3507 |
|
3511 |
|
| 3508 |
/*================================================================================================*/
|
3512 |
/*================================================================================================*/
|
| 3509 |
FUNCTION get_osid (sosname IN VARCHAR2)
|
3513 |
FUNCTION get_osid (sosname IN VARCHAR2)
|
| 3510 |
RETURN NUMBER;
|
3514 |
RETURN NUMBER;
|
| 3511 |
|
3515 |
|
| 3512 |
/*================================================================================================*/
|
3516 |
/*================================================================================================*/
|
| 3513 |
PROCEDURE update_build_service_info (
|
3517 |
PROCEDURE update_build_service_info (
|
| 3514 |
sdatabaseserver IN VARCHAR2,
|
3518 |
sdatabaseserver IN VARCHAR2,
|
| 3515 |
sarchiveserver IN VARCHAR2,
|
3519 |
sarchiveserver IN VARCHAR2,
|
| 3516 |
smailserver IN VARCHAR2,
|
3520 |
smailserver IN VARCHAR2,
|
| 3517 |
smailsender IN VARCHAR2,
|
3521 |
smailsender IN VARCHAR2,
|
| 3518 |
faultmlist IN VARCHAR2,
|
3522 |
faultmlist IN VARCHAR2,
|
| Line 3537... |
Line 3541... |
| 3537 |
|
3541 |
|
| 3538 |
/*================================================================================================*/
|
3542 |
/*================================================================================================*/
|
| 3539 |
PROCEDURE update_buildmachine (nbm_id IN NUMBER, sbmvalue IN VARCHAR2);
|
3543 |
PROCEDURE update_buildmachine (nbm_id IN NUMBER, sbmvalue IN VARCHAR2);
|
| 3540 |
|
3544 |
|
| 3541 |
/*================================================================================================*/
|
3545 |
/*================================================================================================*/
|
| 3542 |
PROCEDURE add_daemon (
|
- |
|
| 3543 |
sdaemonhostname IN VARCHAR2,
|
- |
|
| 3544 |
nrtagid IN NUMBER,
|
- |
|
| 3545 |
ngbeid IN NUMBER,
|
- |
|
| 3546 |
sgbebuildfilter IN VARCHAR2
|
- |
|
| 3547 |
);
|
- |
|
| 3548 |
|
- |
|
| 3549 |
/*================================================================================================*/
|
- |
|
| 3550 |
PROCEDURE delete_daemon (srconidlist IN VARCHAR2);
|
3546 |
PROCEDURE delete_daemon (srconidlist IN VARCHAR2);
|
| 3551 |
|
3547 |
|
| 3552 |
/*================================================================================================*/
|
3548 |
/*================================================================================================*/
|
| 3553 |
PROCEDURE update_daemon (
|
- |
|
| 3554 |
sdaemonhostname IN VARCHAR2,
|
3549 |
PROCEDURE remove_daemon (srconidlist IN VARCHAR2);
|
| 3555 |
nrconid IN NUMBER,
|
- |
|
| 3556 |
ngbeid IN NUMBER,
|
- |
|
| 3557 |
sgbebuildfilter IN VARCHAR2
|
- |
|
| 3558 |
);
|
- |
|
| 3559 |
|
3550 |
|
| 3560 |
/*================================================================================================*/
|
3551 |
/*================================================================================================*/
|
| 3561 |
PROCEDURE insert_schedule_info (
|
3552 |
PROCEDURE insert_schedule_info (
|
| 3562 |
dschedulepause IN DATE,
|
3553 |
dschedulepause IN DATE,
|
| 3563 |
dscheduleresume IN DATE,
|
3554 |
dscheduleresume IN DATE,
|
| Line 3655... |
Line 3646... |
| 3655 |
nbmcon_id IN NUMBER,
|
3646 |
nbmcon_id IN NUMBER,
|
| 3656 |
sdaemon_mode IN VARCHAR2,
|
3647 |
sdaemon_mode IN VARCHAR2,
|
| 3657 |
sgbebuildfilter IN VARCHAR2
|
3648 |
sgbebuildfilter IN VARCHAR2
|
| 3658 |
);
|
3649 |
);
|
| 3659 |
|
3650 |
|
| - |
|
3651 |
/*================================================================================================*/
|
| - |
|
3652 |
PROCEDURE duplicate_daemon_config (
|
| - |
|
3653 |
nrtagid IN NUMBER,
|
| - |
|
3654 |
nbmcon_id IN NUMBER,
|
| - |
|
3655 |
sdaemonhostname IN VARCHAR2,
|
| - |
|
3656 |
ngbe_id IN NUMBER,
|
| - |
|
3657 |
sdaemon_mode IN VARCHAR2,
|
| - |
|
3658 |
sgbebuildfilter IN VARCHAR2
|
| - |
|
3659 |
);
|
| - |
|
3660 |
|
| 3660 |
/*================================================================================================*/
|
3661 |
/*================================================================================================*/
|
| 3661 |
PROCEDURE add_build_machine (
|
3662 |
PROCEDURE add_build_machine (
|
| 3662 |
sdisplay_name IN VARCHAR2,
|
3663 |
sdisplay_name IN VARCHAR2,
|
| 3663 |
smachine_hostname IN VARCHAR2,
|
3664 |
smachine_hostname IN VARCHAR2,
|
| 3664 |
ngbeid IN NUMBER,
|
3665 |
ngbeid IN NUMBER,
|
| Line 4743... |
Line 4744... |
| 4743 |
);
|
4744 |
);
|
| 4744 |
RAISE;
|
4745 |
RAISE;
|
| 4745 |
END;
|
4746 |
END;
|
| 4746 |
|
4747 |
|
| 4747 |
/*-------------------------------------------------------------------------------------------------------*/
|
4748 |
/*-------------------------------------------------------------------------------------------------------*/
|
| 4748 |
PROCEDURE update_build_service_info (
|
4749 |
PROCEDURE update_build_service_info (
|
| 4749 |
sdatabaseserver IN VARCHAR2,
|
4750 |
sdatabaseserver IN VARCHAR2,
|
| 4750 |
sarchiveserver IN VARCHAR2,
|
4751 |
sarchiveserver IN VARCHAR2,
|
| 4751 |
smailserver IN VARCHAR2,
|
4752 |
smailserver IN VARCHAR2,
|
| 4752 |
smailsender IN VARCHAR2,
|
4753 |
smailsender IN VARCHAR2,
|
| 4753 |
faultmlist IN VARCHAR2,
|
4754 |
faultmlist IN VARCHAR2,
|
| Line 4782... |
Line 4783... |
| 4782 |
|
4783 |
|
| 4783 |
UPDATE build_service_config
|
4784 |
UPDATE build_service_config
|
| 4784 |
SET config = ssbommanagement
|
4785 |
SET config = ssbommanagement
|
| 4785 |
WHERE service = 'SBOM MANAGEMENT';
|
4786 |
WHERE service = 'SBOM MANAGEMENT';
|
| 4786 |
END;
|
4787 |
END;
|
| - |
|
4788 |
|
| 4787 |
|
4789 |
|
| 4788 |
|
4790 |
|
| 4789 |
/*-------------------------------------------------------------------------------------------------------*/
|
4791 |
/*-------------------------------------------------------------------------------------------------------*/
|
| 4790 |
PROCEDURE add_gbe_machtype (sgbevalue IN VARCHAR2, sgbeclass IN NUMBER)
|
4792 |
PROCEDURE add_gbe_machtype (sgbevalue IN VARCHAR2, sgbeclass IN NUMBER)
|
| 4791 |
IS
|
4793 |
IS
|
| Line 4850... |
Line 4852... |
| 4850 |
SET bm_name = sbmvalue
|
4852 |
SET bm_name = sbmvalue
|
| 4851 |
WHERE bm_id = nbm_id;
|
4853 |
WHERE bm_id = nbm_id;
|
| 4852 |
END;
|
4854 |
END;
|
| 4853 |
|
4855 |
|
| 4854 |
/*-------------------------------------------------------------------------------------------------------*/
|
4856 |
/*-------------------------------------------------------------------------------------------------------*/
|
| 4855 |
--This function is obsolete. It was replaced by add_daemon_config. Done for DEVI-046806
|
- |
|
| 4856 |
PROCEDURE add_daemon (
|
- |
|
| 4857 |
sdaemonhostname IN VARCHAR2,
|
- |
|
| 4858 |
nrtagid IN NUMBER,
|
- |
|
| 4859 |
ngbeid IN NUMBER,
|
- |
|
| 4860 |
sgbebuildfilter IN VARCHAR2
|
- |
|
| 4861 |
)
|
- |
|
| 4862 |
IS
|
- |
|
| 4863 |
nrecordnumber NUMBER;
|
- |
|
| 4864 |
nrconid NUMBER;
|
- |
|
| 4865 |
BEGIN
|
- |
|
| 4866 |
-- Get RCON_ID
|
- |
|
| 4867 |
SELECT seq_rcon_id.NEXTVAL
|
- |
|
| 4868 |
INTO nrconid
|
- |
|
| 4869 |
FROM DUAL;
|
- |
|
| 4870 |
|
- |
|
| 4871 |
SELECT COUNT (*)
|
- |
|
| 4872 |
INTO nrecordnumber
|
- |
|
| 4873 |
FROM release_config
|
- |
|
| 4874 |
WHERE rtag_id = nrtagid;
|
- |
|
| 4875 |
|
- |
|
| 4876 |
IF nrecordnumber = 0
|
- |
|
| 4877 |
THEN
|
- |
|
| 4878 |
INSERT INTO release_config
|
- |
|
| 4879 |
(rcon_id, rtag_id, daemon_hostname, daemon_mode,
|
- |
|
| 4880 |
gbe_id, gbe_buildfilter
|
- |
|
| 4881 |
)
|
- |
|
| 4882 |
VALUES (nrconid, nrtagid, sdaemonhostname, 'M',
|
- |
|
| 4883 |
ngbeid, sgbebuildfilter
|
- |
|
| 4884 |
);
|
- |
|
| 4885 |
ELSE
|
- |
|
| 4886 |
INSERT INTO release_config
|
- |
|
| 4887 |
(rcon_id, rtag_id, daemon_hostname, daemon_mode,
|
- |
|
| 4888 |
gbe_id, gbe_buildfilter
|
- |
|
| 4889 |
)
|
- |
|
| 4890 |
VALUES (nrconid, nrtagid, sdaemonhostname, 'S',
|
- |
|
| 4891 |
ngbeid, sgbebuildfilter
|
- |
|
| 4892 |
);
|
- |
|
| 4893 |
END IF;
|
- |
|
| 4894 |
|
- |
|
| 4895 |
-- A newly configured daemon should initially be paused (DEVI-047277)
|
- |
|
| 4896 |
INSERT INTO run_level
|
- |
|
| 4897 |
(rcon_id, pause)
|
- |
|
| 4898 |
VALUES (nrconid, 1);
|
- |
|
| 4899 |
END;
|
- |
|
| 4900 |
|
- |
|
| 4901 |
/*-------------------------------------------------------------------------------------------------------*/
|
- |
|
| 4902 |
PROCEDURE delete_daemon (srconidlist IN VARCHAR2)
|
4857 |
PROCEDURE delete_daemon (srconidlist IN VARCHAR2)
|
| 4903 |
IS
|
4858 |
IS
|
| 4904 |
BEGIN
|
4859 |
BEGIN
|
| 4905 |
-- Entries in the daemon_action_log, run_level and abt_action_log tables must be deleted first.
|
4860 |
-- Entries in the daemon_action_log, run_level and abt_action_log tables must be deleted first.
|
| 4906 |
DELETE FROM daemon_action_log
|
4861 |
DELETE FROM daemon_action_log
|
| Line 4944... |
Line 4899... |
| 4944 |
FROM DUAL
|
4899 |
FROM DUAL
|
| 4945 |
));
|
4900 |
));
|
| 4946 |
END;
|
4901 |
END;
|
| 4947 |
|
4902 |
|
| 4948 |
/*-------------------------------------------------------------------------------------------------------*/
|
4903 |
/*-------------------------------------------------------------------------------------------------------*/
|
| 4949 |
--This function is obsolete. It was replaced by update_daemon_config for DEVI-046806
|
- |
|
| 4950 |
PROCEDURE update_daemon (
|
- |
|
| 4951 |
sdaemonhostname IN VARCHAR2,
|
4904 |
PROCEDURE remove_daemon (srconidlist IN VARCHAR2)
|
| 4952 |
nrconid IN NUMBER,
|
- |
|
| 4953 |
ngbeid IN NUMBER,
|
- |
|
| 4954 |
sgbebuildfilter IN VARCHAR2
|
- |
|
| 4955 |
)
|
- |
|
| 4956 |
IS
|
4905 |
IS
|
| - |
|
4906 |
oRconIdList RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();
|
| - |
|
4907 |
|
| 4957 |
BEGIN
|
4908 |
BEGIN
|
| - |
|
4909 |
|
| - |
|
4910 |
oRconIdList := IN_LIST_NUMBER ( srconidlist );
|
| - |
|
4911 |
|
| - |
|
4912 |
-- Break the linkage between the release_config and the build_machine_config
|
| - |
|
4913 |
|
| - |
|
4914 |
-- Delete the linkage between the two tables.
|
| 4958 |
UPDATE release_config
|
4915 |
UPDATE release_config
|
| 4959 |
SET daemon_hostname = sdaemonhostname,
|
4916 |
SET daemon_hostname = NULL,
|
| 4960 |
gbe_id = ngbeid,
|
4917 |
bmcon_id = NULL
|
| 4961 |
gbe_buildfilter = sgbebuildfilter
|
- |
|
| 4962 |
WHERE rcon_id = nrconid;
|
4918 |
WHERE rcon_id IN ( SELECT * FROM TABLE ( CAST ( oRconIdList AS RELMGR_NUMBER_TAB_t ) ) );
|
| 4963 |
END;
|
4919 |
END;
|
| 4964 |
|
4920 |
|
| 4965 |
/*-------------------------------------------------------------------------------------------------------*/
|
4921 |
/*-------------------------------------------------------------------------------------------------------*/
|
| 4966 |
PROCEDURE insert_schedule_info (
|
4922 |
PROCEDURE insert_schedule_info (
|
| 4967 |
dschedulepause IN DATE,
|
4923 |
dschedulepause IN DATE,
|
| Line 5407... |
Line 5363... |
| 5407 |
FROM build_machine_config
|
5363 |
FROM build_machine_config
|
| 5408 |
WHERE bmcon_id = nbmcon_id;
|
5364 |
WHERE bmcon_id = nbmcon_id;
|
| 5409 |
|
5365 |
|
| 5410 |
INSERT INTO release_config
|
5366 |
INSERT INTO release_config
|
| 5411 |
(rcon_id, rtag_id, daemon_hostname, daemon_mode,
|
5367 |
(rcon_id, rtag_id, daemon_hostname, daemon_mode,
|
| 5412 |
gbe_id, gbe_buildfilter)
|
5368 |
gbe_id, gbe_buildfilter, bmcon_id)
|
| 5413 |
VALUES (nrconid, nrtagid, sdaemonhostname, sdaemon_mode,
|
5369 |
VALUES (nrconid, nrtagid, sdaemonhostname, sdaemon_mode,
|
| 5414 |
ngbeid, sgbebuildfilter);
|
5370 |
ngbeid, sgbebuildfilter, nbmcon_id);
|
| 5415 |
|
5371 |
|
| 5416 |
-- A newly configured daemon should initially be paused (DEVI-047277)
|
5372 |
-- A newly configured daemon should initially be paused (DEVI-047277)
|
| 5417 |
INSERT INTO run_level
|
5373 |
INSERT INTO run_level
|
| 5418 |
(rcon_id, pause)
|
5374 |
(rcon_id, pause)
|
| 5419 |
VALUES (nrconid, 2);
|
5375 |
VALUES (nrconid, 2);
|
| Line 5439... |
Line 5395... |
| 5439 |
|
5395 |
|
| 5440 |
UPDATE release_config
|
5396 |
UPDATE release_config
|
| 5441 |
SET daemon_hostname = sdaemonhostname,
|
5397 |
SET daemon_hostname = sdaemonhostname,
|
| 5442 |
gbe_id = ngbeid,
|
5398 |
gbe_id = ngbeid,
|
| 5443 |
daemon_mode = sdaemon_mode,
|
5399 |
daemon_mode = sdaemon_mode,
|
| 5444 |
gbe_buildfilter = sgbebuildfilter
|
5400 |
gbe_buildfilter = sgbebuildfilter,
|
| - |
|
5401 |
bmcon_id = nbmcon_id
|
| 5445 |
WHERE rcon_id = nrconid;
|
5402 |
WHERE rcon_id = nrconid;
|
| 5446 |
END;
|
5403 |
END;
|
| 5447 |
|
5404 |
|
| 5448 |
|
5405 |
|
| 5449 |
/*-------------------------------------------------------------------------------------------------------*/
|
5406 |
/*-------------------------------------------------------------------------------------------------------*/
|
| Line 5471... |
Line 5428... |
| 5471 |
);
|
5428 |
);
|
| 5472 |
|
5429 |
|
| 5473 |
END;
|
5430 |
END;
|
| 5474 |
|
5431 |
|
| 5475 |
/*-------------------------------------------------------------------------------------------------------*/
|
5432 |
/*-------------------------------------------------------------------------------------------------------*/
|
| - |
|
5433 |
PROCEDURE duplicate_daemon_config (
|
| - |
|
5434 |
nrtagid IN NUMBER,
|
| - |
|
5435 |
nbmcon_id IN NUMBER,
|
| - |
|
5436 |
sdaemonhostname IN VARCHAR2,
|
| - |
|
5437 |
ngbe_id IN NUMBER,
|
| - |
|
5438 |
sdaemon_mode IN VARCHAR2,
|
| - |
|
5439 |
sgbebuildfilter IN VARCHAR2
|
| - |
|
5440 |
)
|
| - |
|
5441 |
IS
|
| - |
|
5442 |
nrecordnumber NUMBER;
|
| - |
|
5443 |
nrconid NUMBER;
|
| - |
|
5444 |
BEGIN
|
| - |
|
5445 |
|
| - |
|
5446 |
-- Get RCON_ID
|
| - |
|
5447 |
SELECT seq_rcon_id.NEXTVAL
|
| - |
|
5448 |
INTO nrconid
|
| - |
|
5449 |
FROM DUAL;
|
| - |
|
5450 |
|
| - |
|
5451 |
INSERT INTO release_config
|
| - |
|
5452 |
(rcon_id, rtag_id, daemon_hostname, daemon_mode,
|
| - |
|
5453 |
gbe_id, gbe_buildfilter, bmcon_id)
|
| - |
|
5454 |
VALUES (nrconid, nrtagid, sdaemonhostname, sdaemon_mode,
|
| - |
|
5455 |
ngbe_id, sgbebuildfilter, nbmcon_id);
|
| - |
|
5456 |
|
| - |
|
5457 |
-- A newly configured daemon should initially be disabled (DEVI-047277)
|
| - |
|
5458 |
INSERT INTO run_level
|
| - |
|
5459 |
(rcon_id, pause)
|
| - |
|
5460 |
VALUES (nrconid, 2);
|
| - |
|
5461 |
|
| - |
|
5462 |
END;
|
| - |
|
5463 |
/*-------------------------------------------------------------------------------------------------------*/
|
| 5476 |
PROCEDURE delete_build_machine (sbmcon_id_list IN VARCHAR2)
|
5464 |
PROCEDURE delete_build_machine (sbmcon_id_list IN VARCHAR2)
|
| 5477 |
IS
|
5465 |
IS
|
| 5478 |
BEGIN
|
5466 |
BEGIN
|
| 5479 |
DELETE FROM build_machine_config
|
5467 |
DELETE FROM build_machine_config
|
| 5480 |
WHERE bmcon_id IN (
|
5468 |
WHERE bmcon_id IN (
|
| Line 9349... |
Line 9337... |
| 9349 |
RconId NUMBER;
|
9337 |
RconId NUMBER;
|
| 9350 |
|
9338 |
|
| 9351 |
-- this cursor gets the source release daemon configurations, ensuring that the
|
9339 |
-- this cursor gets the source release daemon configurations, ensuring that the
|
| 9352 |
-- first record will be the master daemon, and subsequent records will be the slaves.
|
9340 |
-- first record will be the master daemon, and subsequent records will be the slaves.
|
| 9353 |
CURSOR curSrcReleaseConfigs IS
|
9341 |
CURSOR curSrcReleaseConfigs IS
|
| 9354 |
SELECT daemon_hostname, gbe_id, gbe_buildfilter
|
9342 |
SELECT daemon_hostname, gbe_id, gbe_buildfilter, bmcon_id, daemon_mode
|
| 9355 |
FROM RELEASE_CONFIG rc
|
9343 |
FROM RELEASE_CONFIG rc
|
| 9356 |
WHERE rc.RTAG_ID = nSourceRtagId
|
9344 |
WHERE rc.RTAG_ID = nSourceRtagId
|
| 9357 |
ORDER BY rc.daemon_mode;
|
9345 |
ORDER BY rc.daemon_mode;
|
| 9358 |
recSrcReleaseConfigs curSrcReleaseConfigs%ROWTYPE;
|
9346 |
recSrcReleaseConfigs curSrcReleaseConfigs%ROWTYPE;
|
| 9359 |
|
9347 |
|
| Line 9454... |
Line 9442... |
| 9454 |
|
9442 |
|
| 9455 |
--Import Release Configuration Information
|
9443 |
--Import Release Configuration Information
|
| 9456 |
OPEN curSrcReleaseConfigs;
|
9444 |
OPEN curSrcReleaseConfigs;
|
| 9457 |
FETCH curSrcReleaseConfigs INTO recSrcReleaseConfigs;
|
9445 |
FETCH curSrcReleaseConfigs INTO recSrcReleaseConfigs;
|
| 9458 |
|
9446 |
|
| 9459 |
WHILE curSrcReleaseConfigs%FOUND
|
9447 |
WHILE curSrcReleaseConfigs%FOUND
|
| 9460 |
LOOP
|
9448 |
LOOP
|
| 9461 |
-- add a daemon to the target release
|
9449 |
-- add a daemon to the target release
|
| - |
|
9450 |
PK_BUILDAPI.duplicate_daemon_config( nTargetRtagId,
|
| - |
|
9451 |
recSrcReleaseConfigs.bmcon_id,
|
| - |
|
9452 |
recSrcReleaseConfigs.daemon_hostname,
|
| - |
|
9453 |
recSrcReleaseConfigs.gbe_id,
|
| - |
|
9454 |
recSrcReleaseConfigs.daemon_mode ,
|
| 9462 |
PK_BUILDAPI.add_daemon( recSrcReleaseConfigs.daemon_hostname, nTargetRtagId, recSrcReleaseConfigs.gbe_id, recSrcReleaseConfigs.gbe_buildfilter );
|
9455 |
recSrcReleaseConfigs.gbe_buildfilter );
|
| 9463 |
|
9456 |
|
| 9464 |
FETCH curSrcReleaseConfigs INTO recSrcReleaseConfigs;
|
9457 |
FETCH curSrcReleaseConfigs INTO recSrcReleaseConfigs;
|
| 9465 |
END LOOP;
|
9458 |
END LOOP;
|
| 9466 |
|
9459 |
|
| 9467 |
CLOSE curSrcReleaseConfigs;
|
9460 |
CLOSE curSrcReleaseConfigs;
|
| Line 13738... |
Line 13731... |
| 13738 |
SELECT dep.*,
|
13731 |
SELECT dep.*,
|
| 13739 |
LEVEL AS LEVEL_NUM
|
13732 |
LEVEL AS LEVEL_NUM
|
| 13740 |
FROM PACKAGE_DEPENDENCIES dep
|
13733 |
FROM PACKAGE_DEPENDENCIES dep
|
| 13741 |
START WITH dep.PV_ID IN (
|
13734 |
START WITH dep.PV_ID IN (
|
| 13742 |
|
13735 |
|
| 13743 |
69124,63479,60048,49566,49562,54351,63560,54360,46053,59753,97060,97061,100883,78236,75241,92371,92372,105682,135506,127204,135615,136498,137571,61534,76540,96787,133102,96770,96771,116692,133768,61537,88935,110216,96797,69469,98123,111626,96802,100289,97233,97623,135801,69700,77808,43026,77809,43027,100825,126854,105589,96405,102105,133770,134408,91177,91179,96822,96824,48031,78965,78936,78935,79114,76620,125164,61804,96826,61977,67592,72594,134415,135804,65097,64850,64851,64879,64881,64882,64884,67612,67613,67614,67615,68501,68502,68503,68516,68518,68519,68521,71974,68659,69764,68662,68661,68757,69765,69766,69767,71975,71976,71977,71978,71979,71980,75149,71982,71983,75153,75158,71986,75160,75161,75162,72418,72419,71987,71988,71990,75164,72420,72421,72423,72424,72425,75165,75181,75182,83285,75184,75201,75220,75240,75260,75280,75242,76320,75320,76340,76321,82031,76341,76342,76344,76345,76806,76350,76810,76811,76360,76361,76362,76380,76637,76638,76639,76647,76649,76812,76650,78261,76815,77603,76818,76846,76847,76848,76849,77604,77606,77016,77607,77608,77609,78518,77671,77610,78519,78520,78205,78206,77795,78262,78263,78666,78521,78669,78767,78768,78770,78771,82032,79471,78772,82033,80856,80210,80898,82449,80211,80212,80214,80215,80216,80611,80217,82034,82035,80749,80750,82036,94266,82037,82038,82039,82040,82041,82042,82043,82044,82045,82046,82450,82296,82297,82451,82047,82298,82299,82300,82452,82453,82454,82455,82456,82457,82769,82458,82459,82770,82460,82461,82771,83286,85069,83543,83544,83287,85070,84959,85071,85072,84960,85073,85074,84975,85194,85075,85195,85196,85197,85198,85199,94267,85231,85237,94268,94269,94270,94271,94273,94274,94275,94276,94277,94278,94279,94280,94281,94282,94283,94284,94285,94286,94287,94288,94289,94290,94291,94292,94293,94294,94295,94296,94297,94298,94299,94300,94301,94302,94303,94304,94305,94306,94307,94308,94309,94310,94311,94312,94313,94314,94315,94316,94634,94317,94635,97035,94319,94320,94636,94637,94322,96536,96552,96554,96555,96556,96568,96569,96570,96571,96572,96573,96574,96575,96576,96577,96578,96579,96580,96581,96582,96583,96584,96585,96586,96818,97435,96819,96820,97599,97436,97437,97438,97439,97440,97434,97723,97640,97641,97642,97724,97725,97729,97743,97825,98097,98098,98099,98100,97999,98049,98101,98102,98103,99506,98268,98207,99507,99508,99509,99159,99510,99511,99512,102883,99513,99514,100243,99515,99880,99562,99563,99676,99677,99678,99881,99882,99883,99884,100244,100245,100623,100247,100624,100625,100626,100885,100719,100886,100887,100888,100889,100890,100990,100991,101301,101603,110065,101605,102180,102627,102181,102182,102183,102184,102185,102186,102187,102188,102189,102190,102191,104378,102192,104379,102193,102379,102380,102381,102884,102410,102411,102628,102465,102629,102630,102885,102886,102887,104380,104381,104382,104383,104384,104385,104387,110063,104389,106409,104561,104594,104660,105088,105089,105090,105091,105093,105097,105673,105768,106410,109314,106173,110064,137890,106433,106960,109080,111665,122015,110954,116763,110066,116764,110123,111867,110713,116765,111666,116869,111667,111668,116766,116767,115142,115143,121477,113924,114594,116768,115144,116769,115170,115172,115171,115644,120042,120043,116092,116870,116871,118382,116872,116876,120044,118026,119364,121485,120045,120416,121478,120417,122016,124577,129495,123602,123600,124578,124579,124580,124581,124784,125238,127096,127097,129496,129497,128036,128415,129498,129499,129914,130063,130064,130680,130681,131333,131488,133886,132219,132477,132478,133887,136537,136552,136538,136539,136540,136553,136554,136555,137869,85076,80857,62418,64889,64890,64891,64893,68666,68667,68668,68670,68671,68672,68673,72019,72020,72023,72024,72227,77745,77746,77747,77748,77749,77750,77751,77798,78773,80751,82464,82465,83288,92874,92875,92876,92877,92878,94122,94123,96290,96882,96883,97554,97514,97726,98008,98009,98051,99193,100248,99608,100249,100250,100670,100671,100672,101059,101061,101607,102194,102195,102412,102413,102633,104390,104391,106421,104560,104595,105767,106174,106426,109081,122017,137851,110712,116873,11514
|
13736 |
69124,63479,60048,49566,49562,54351,63560,54360,46053,59753,97060,97061,100883,78236,75241,92371,92372,105682,135506,127204,135615,136498,137571,61534,76540,96787,133102,96770,96771,116692,133768,61537,88935,110216,96797,69469,98123,111626,96802,100289,97233,97623,135801,69700,77808,43026,77809,43027,100825,126854,105589,96405,102105,133770,134408,91177,91179,96822,96824,48031,78965,78936,78935,79114,76620,125164,61804,96826,61977,67592,72594,134415,135804,65097,64850,64851,64879,64881,64882,64884,67612,67613,67614,67615,68501,68502,68503,68516,68518,68519,68521,71974,68659,69764,68662,68661,68757,69765,69766,69767,71975,71976,71977,71978,71979,71980,75149,71982,71983,75153,75158,71986,75160,75161,75162,72418,72419,71987,71988,71990,75164,72420,72421,72423,72424,72425,75165,75181,75182,83285,75184,75201,75220,75240,75260,75280,75242,76320,75320,76340,76321,82031,76341,76342,76344,76345,76806,76350,76810,76811,76360,76361,76362,76380,76637,76638,76639,76647,76649,76812,76650,78261,76815,77603,76818,76846,76847,76848,76849,77604,77606,77016,77607,77608,77609,78518,77671,77610,78519,78520,78205,78206,77795,78262,78263,78666,78521,78669,78767,78768,78770,78771,82032,79471,78772,82033,80856,80210,80898,82449,80211,80212,80214,80215,80216,80611,80217,82034,82035,80749,80750,82036,94266,82037,82038,82039,82040,82041,82042,82043,82044,82045,82046,82450,82296,82297,82451,82047,82298,82299,82300,82452,82453,82454,82455,82456,82457,82769,82458,82459,82770,82460,82461,82771,83286,85069,83543,83544,83287,85070,84959,85071,85072,84960,85073,85074,84975,85194,85075,85195,85196,85197,85198,85199,94267,85231,85237,94268,94269,94270,94271,94273,94274,94275,94276,94277,94278,94279,94280,94281,94282,94283,94284,94285,94286,94287,94288,94289,94290,94291,94292,94293,94294,94295,94296,94297,94298,94299,94300,94301,94302,94303,94304,94305,94306,94307,94308,94309,94310,94311,94312,94313,94314,94315,94316,94634,94317,94635,97035,94319,94320,94636,94637,94322,96536,96552,96554,96555,96556,96568,96569,96570,96571,96572,96573,96574,96575,96576,96577,96578,96579,96580,96581,96582,96583,96584,96585,96586,96818,97435,96819,96820,97599,97436,97437,97438,97439,97440,97434,97723,97640,97641,97642,97724,97725,97729,97743,97825,98097,98098,98099,98100,97999,98049,98101,98102,98103,99506,98268,98207,99507,99508,99509,99159,99510,99511,99512,102883,99513,99514,100243,99515,99880,99562,99563,99676,99677,99678,99881,99882,99883,99884,100244,100245,100623,100247,100624,100625,100626,100885,100719,100886,100887,100888,100889,100890,100990,100991,101301,101603,110065,101605,102180,102627,102181,102182,102183,102184,102185,102186,102187,102188,102189,102190,102191,104378,102192,104379,102193,102379,102380,102381,102884,102410,102411,102628,102465,102629,102630,102885,102886,102887,104380,104381,104382,104383,104384,104385,104387,110063,104389,106409,104561,104594,104660,105088,105089,105090,105091,105093,105097,105673,105768,106410,109314,106173,110064,137890,106433,106960,109080,111665,122015,110954,116763,110066,116764,110123,111867,110713,116765,111666,116869,111667,111668,116766,116767,115142,115143,121477,113924,114594,116768,115144,116769,115170,115172,115171,115644,120042,120043,116092,116870,116871,118382,116872,116876,120044,118026,119364,121485,120045,120416,121478,120417,122016,124577,129495,123602,123600,124578,124579,124580,124581,124784,125238,127096,127097,129496,129497,128036,128415,129498,129499,129914,130063,130064,130680,130681,131333,131488,133886,132219,132477,132478,133887,136537,136552,136538,136539,136540,136553,136554,136555,137869,85076,80857,62418,64889,64890,64891,64893,68666,68667,68668,68670,68671,68672,68673,72019,72020,72023,72024,72227,77745,77746,77747,77748,77749,77750,77751,77798,78773,80751,82464,82465,83288,92874,92875,92876,92877,92878,94122,94123,96290,96882,96883,97554,97514,97726,98008,98009,98051,99193,100248,99608,100249,100250,100670,100671,100672,101059,101061,101607,102194,102195,102412,102413,102633,104390,104391,106421,104560,104595,105767,106174,106426,109081,122017,137851,110712,116873,115145,115146,114597,115645,116095,120046,123551,122018,124584,124585,129500,129501,129502,128417,129503,129915,130066,131487,133897,133882,133883,136559,85078,100673,63475,78264,78265,78266,78267,78775,80753,94118,94119,94120,94121,96888,100251,100252,102631,102590,102632,65229,43366,69139,132551,59764,127129,101196,96830,61535,105433,96833,96835,96839,83795,77723,126868,99146,70188,117523,117524,117525,99237,100854,100855,137314,137315,96868,138232,138233,69709,96907,130854,119208,69520,124772,96878,60049,47875,70354,59371,54558,59849,33893,43087,43134,33894,60054,24345,49563,49558,97474,84982,31770,30950,49926,60050,52670,59846,59891,30966,59744,61988,59745,59881,59746,59741,47449,59747,64101,63480,63562,105382,105383,60052,48955,49561,49556,47401,65896,65906,65909,65985,108670,68697,68698,59754,59752,59751,62526,59805,59799,66981,46050,59756,46044,59806,46051,59807,82290,66980,59808,46046,61536,88834,70260,111081,105409,66093,66095,66094,47440,65778,59750,56748,99152,78409
|
| 13744 |
5,115146,114597,115645,116095,120046,123551,122018,124584,124585,129500,129501,129502,128417,129503,129915,130066,131487,133897,133882,133883,136559,85078,100673,63475,78264,78265,78266,78267,78775,80753,94118,94119,94120,94121,96888,100251,100252,102631,102590,102632,65229,43366,69139,132551,59764,127129,101196,96830,61535,105433,96833,96835,96839,83795,77723,126868,99146,70188,117523,117524,117525,99237,100854,100855,137314,137315,96868,138232,138233,69709,96907,130854,119208,69520,124772,96878,60049,47875,70354,59371,54558,59849,33893,43087,43134,33894,60054,24345,49563,49558,97474,84982,31770,30950,49926,60050,52670,59846,59891,30966,59744,61988,59745,59881,59746,59741,47449,59747,64101,63480,63562,105382,105383,60052,48955,49561,49556,47401,65896,65906,65909,65985,108670,68697,68698,59754,59752,59751,62526,59805,59799,66981,46050,59756,46044,59806,46051,59807,82290,66980,59808,46046,61536,88834,70260,111081,105409,66093,66095,66094,47440,65778,59750,56748,99152,78409
|
- |
|
| 13745 |
|
13737 |
|
| 13746 |
)
|
13738 |
)
|
| 13747 |
CONNECT BY PRIOR dep.DPV_ID = dep.PV_ID
|
13739 |
CONNECT BY PRIOR dep.DPV_ID = dep.PV_ID
|
| 13748 |
) qry,
|
13740 |
) qry,
|
| 13749 |
PACKAGES pkg,
|
13741 |
PACKAGES pkg,
|