Skip to content

Commit b860917

Browse files
committed
docs(db): explain Oracle operation index name limit
1 parent 7d71f1f commit b860917

2 files changed

Lines changed: 2 additions & 0 deletions

File tree

‎db/init/oracle/schema.sql‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -420,6 +420,7 @@ comment on column OPERATION_RECORD_LOG.operation_type
420420
is 'operation type:create/update/delete/register...';
421421

422422
create index idx_operation_log_time on operation_record_log (operation_time);
423+
-- Keep the index name within Oracle's 30-character identifier limit.
423424
create index idx_operation_log_oper_time on operation_record_log (operator, operation_time);
424425

425426
create sequence operation_record_log_seq

‎db/upgrade/2.7.1-upgrade-2.7.2-oracle.sql‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -103,6 +103,7 @@ VALUES ('1960000000000001030','649330b6-c2d7-4edc-be8e-8a54df9eb385','68', NULL,
103103
-- add index to speed up the meta data path uniqueness check
104104
create index idx_meta_data_namespace_path on meta_data (namespace_id, path);
105105
create index idx_operation_log_time on operation_record_log (operation_time);
106+
-- Keep the index name within Oracle's 30-character identifier limit.
106107
create index idx_operation_log_oper_time on operation_record_log (operator, operation_time);
107108

108109
-- Retain the smallest existing id for each grant before enforcing uniqueness.

0 commit comments

Comments
 (0)