create table ut_suite_cache

/*

utPLSQL - Version 3

Copyright 2016 - 2021 utPLSQL Project

Licensed under the Apache License, Version 2.0 (the "License"):

you may not use this file except in compliance with the License.

You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software

distributed under the License is distributed on an "AS IS" BASIS,

WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

See the License for the specific language governing permissions and

limitations under the License.

*/

of ut_suite_cache_row

nested table warnings store as ut_suite_cache_warnings

nested table before_all_list store as ut_suite_cache_before_all

nested table after_all_list store as ut_suite_cache_after_all

nested table before_each_list store as ut_suite_cache_before_each

nested table after_each_list store as ut_suite_cache_after_each

nested table before_test_list store as ut_suite_cache_before_test

nested table after_test_list store as ut_suite_cache_after_test

nested table expected_error_codes store as ut_suite_cache_throws

nested table tags store as ut_suite_cache_tags return as locator

/

alter table ut_suite_cache modify (object_owner not null, path not null, self_type not null, object_name not null, name not null, parse_time not null)

/

alter table ut_suite_cache add constraint ut_suite_cache_pk primary key (id)

/

alter table ut_suite_cache add constraint ut_suite_cache_uk1 unique (object_owner, path)

/

alter table ut_suite_cache add constraint ut_suite_cache_uk2 unique (object_owner, object_name, line_no)

/

alter table ut_suite_cache add constraint ut_suite_cache_schema_fk foreign key (object_owner, object_name)

references ut_suite_cache_package(object_owner, object_name) on delete cascade

/