db/init/oracle/schema.sql [2795:2882]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
create table cluster_master
(
    id                   varchar(128)   not null,
    master_host          varchar(255)   not null,
    master_port          varchar(255)   not null,
    context_path          varchar(255)   not null,
    date_created      timestamp(3) default SYSDATE not null,
    date_updated      timestamp(3) default SYSDATE not null,
    PRIMARY KEY (id)
)
;
-- Add comments to the columns
comment
on column alert_receiver.id
  is 'primary key id';
comment
on column alert_receiver.master_host
  is 'master host';
comment
on column alert_receiver.master_port
  is 'master port';
comment
on column alert_receiver.context_path
  is 'master context_path';
comment
on column alert_receiver.date_created
  is 'create time';
comment
on column alert_receiver.date_updated
  is 'update time';




INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840474', '1357956838021890048', 'SHENYU.MENU.SYSTEM.MANAGMENT.NAMESPACE', 'namespace', '/config/namespace', 'namespace', 1, 0, 'appstore', 0, 0, '', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840475', '1792749362445840474', 'SHENYU.BUTTON.SYSTEM.ADD', '', '', '', 2, 0, '', 1, 0, 'system:namespace:add', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840476', '1792749362445840474', 'SHENYU.BUTTON.SYSTEM.LIST', '', '', '', 2, 1, '', 1, 0, 'system:namespace:list', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840477', '1792749362445840474', 'SHENYU.BUTTON.SYSTEM.DELETE', '', '', '', 2, 2, '', 1, 0, 'system:namespace:delete', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840478', '1792749362445840474', 'SHENYU.BUTTON.SYSTEM.EDIT', '', '', '', 2, 3, '', 1, 0, 'system:namespace:edit', 1);


INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343252', '1346358560427216896', '1792749362445840474');
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343253', '1346358560427216896', '1792749362445840475');
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343254', '1346358560427216896', '1792749362445840476');
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343255', '1346358560427216896', '1792749362445840477');
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343256', '1346358560427216896', '1792749362445840478');

CREATE TABLE namespace (
                           id VARCHAR2(128) NOT NULL,
                           namespace_id VARCHAR2(50) NOT NULL,
                           name VARCHAR2(255) NOT NULL,
                           description VARCHAR2(255),
                           date_created      timestamp(3) default SYSDATE not null,
                           date_updated      timestamp(3) default SYSDATE not null,
                           CONSTRAINT pk_namespace PRIMARY KEY (id)
);


COMMENT ON COLUMN namespace.id IS 'namespace primary key';
COMMENT ON COLUMN namespace.namespace_id IS 'namespace id';
COMMENT ON COLUMN namespace.name IS 'namespace name';
COMMENT ON COLUMN namespace.description IS 'namespace desc';
COMMENT ON COLUMN namespace.date_created IS 'create time';
COMMENT ON COLUMN namespace.date_updated IS 'update time';

INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace(id)) */ INTO `namespace` (`id`, `namespace_id`, `name`, `description`) VALUES ('1', '649330b6-c2d7-4edc-be8e-8a54df9eb385', 'default', 'default-namespace');


CREATE TABLE namespace_plugin_rel (
                               id VARCHAR2(128) COLLATE utf8mb4_unicode_ci NOT NULL,
                               namespace_id VARCHAR2(50) COLLATE utf8mb4_unicode_ci NOT NULL,
                               plugin_id VARCHAR2(128) COLLATE utf8mb4_unicode_ci NOT NULL,
                               config CLOB COLLATE utf8mb4_unicode_ci,
                               sort NUMBER(11),
                               enabled NUMBER(4,0) NOT NULL DEFAULT 0 CHECK (enabled IN (0, 1)),
                               date_created      timestamp(3) default SYSDATE not null,
                               date_updated      timestamp(3) default SYSDATE not null,
                               CONSTRAINT pk_namespace_plugin_rel PRIMARY KEY (id)
);

COMMENT ON COLUMN namespace_plugin_rel.id IS 'Primary key ID';
COMMENT ON COLUMN namespace_plugin_rel.namespace_id IS 'Namespace ID';
COMMENT ON COLUMN namespace_plugin_rel.plugin_id IS 'Plugin ID';
COMMENT ON COLUMN namespace_plugin_rel.config IS 'Plugin configuration';
COMMENT ON COLUMN namespace_plugin_rel.sort IS 'Sort order';
COMMENT ON COLUMN namespace_plugin_rel.enabled IS 'Whether the plugin is enabled (0 = not open, 1 = open)';
COMMENT ON COLUMN namespace_plugin_rel.date_created IS 'Creation time';
COMMENT ON COLUMN namespace_plugin_rel.date_updated IS 'Update time';
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



db/upgrade/2.6.1-upgrade-2.7.0-oracle.sql [97:183]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
create table cluster_master
(
    id                   varchar(128)   not null,
    master_host          varchar(255)   not null,
    master_port          varchar(255)   not null,
    context_path          varchar(255)   not null,
    date_created      timestamp(3) default SYSDATE not null,
    date_updated      timestamp(3) default SYSDATE not null,
    PRIMARY KEY (id)
)
;
-- Add comments to the columns
comment
on column alert_receiver.id
  is 'primary key id';
comment
on column alert_receiver.master_host
  is 'master host';
comment
on column alert_receiver.master_port
  is 'master port';
comment
on column alert_receiver.context_path
  is 'master context_path';
comment
on column alert_receiver.date_created
  is 'create time';
comment
on column alert_receiver.date_updated
  is 'update time';



INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840474', '1357956838021890048', 'SHENYU.MENU.SYSTEM.MANAGMENT.NAMESPACE', 'namespace', '/config/namespace', 'namespace', 1, 0, 'appstore', 0, 0, '', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840475', '1792749362445840474', 'SHENYU.BUTTON.SYSTEM.ADD', '', '', '', 2, 0, '', 1, 0, 'system:namespace:add', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840476', '1792749362445840474', 'SHENYU.BUTTON.SYSTEM.LIST', '', '', '', 2, 1, '', 1, 0, 'system:namespace:list', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840477', '1792749362445840474', 'SHENYU.BUTTON.SYSTEM.DELETE', '', '', '', 2, 2, '', 1, 0, 'system:namespace:delete', 1);
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX("resource" (id)) */ INTO "resource"  (id, parent_id, title, name, url, component, resource_type, sort, icon, is_leaf, is_route, perms, status) VALUES ('1792749362445840478', '1792749362445840474', 'SHENYU.BUTTON.SYSTEM.EDIT', '', '', '', 2, 3, '', 1, 0, 'system:namespace:edit', 1);


INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343252', '1346358560427216896', '1792749362445840474');
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343253', '1346358560427216896', '1792749362445840475');
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343254', '1346358560427216896', '1792749362445840476');
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343255', '1346358560427216896', '1792749362445840477');
INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (permission(id)) */ INTO permission (id, object_id, resource_id) VALUES ('1792779493541343256', '1346358560427216896', '1792749362445840478');

CREATE TABLE namespace (
                             id VARCHAR2(128) NOT NULL,
                             namespace_id VARCHAR2(50) NOT NULL,
                             name VARCHAR2(255) NOT NULL,
                             description VARCHAR2(255),
                             date_created      timestamp(3) default SYSDATE not null,
                             date_updated      timestamp(3) default SYSDATE not null,
                             CONSTRAINT pk_namespace PRIMARY KEY (id)
);


COMMENT ON COLUMN namespace.id IS 'namespace primary key';
COMMENT ON COLUMN namespace.namespace_id IS 'namespace id';
COMMENT ON COLUMN namespace.name IS 'namespace name';
COMMENT ON COLUMN namespace.description IS 'namespace desc';
COMMENT ON COLUMN namespace.date_created IS 'create time';
COMMENT ON COLUMN namespace.date_updated IS 'update time';

INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX (namespace(id)) */ INTO `namespace` (`id`, `namespace_id`, `name`, `description`) VALUES ('1', '649330b6-c2d7-4edc-be8e-8a54df9eb385', 'default', 'default-namespace');


CREATE TABLE namespace_plugin_rel (
                                      id VARCHAR2(128) COLLATE utf8mb4_unicode_ci NOT NULL,
                                      namespace_id VARCHAR2(50) COLLATE utf8mb4_unicode_ci NOT NULL,
                                      plugin_id VARCHAR2(128) COLLATE utf8mb4_unicode_ci NOT NULL,
                                      config CLOB COLLATE utf8mb4_unicode_ci,
                                      sort NUMBER(11),
                                      enabled NUMBER(4,0) NOT NULL DEFAULT 0 CHECK (enabled IN (0, 1)),
                                      date_created      timestamp(3) default SYSDATE not null,
                                      date_updated      timestamp(3) default SYSDATE not null,
                                      CONSTRAINT pk_namespace_plugin_rel PRIMARY KEY (id)
);

COMMENT ON COLUMN namespace_plugin_rel.id IS 'Primary key ID';
COMMENT ON COLUMN namespace_plugin_rel.namespace_id IS 'Namespace ID';
COMMENT ON COLUMN namespace_plugin_rel.plugin_id IS 'Plugin ID';
COMMENT ON COLUMN namespace_plugin_rel.config IS 'Plugin configuration';
COMMENT ON COLUMN namespace_plugin_rel.sort IS 'Sort order';
COMMENT ON COLUMN namespace_plugin_rel.enabled IS 'Whether the plugin is enabled (0 = not open, 1 = open)';
COMMENT ON COLUMN namespace_plugin_rel.date_created IS 'Creation time';
COMMENT ON COLUMN namespace_plugin_rel.date_updated IS 'Update time';
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



