rom1c77 commented on a change in pull request #2115:
URL: https://github.com/apache/incubator-shenyu/pull/2115#discussion_r716154311
##########
File path: shenyu-admin/src/main/resources/sql-script/oracle/schema.sql
##########
@@ -0,0 +1,2371 @@
+/* 删除表空间 */
+DROP TABLESPACE shenyu_data INCLUDING CONTENTS AND DATAFILES CASCADE
CONSTRAINTS;
+/* 删除用户 */
+DROP USER shenyu cascade;
+
+
+/*第2步：创建数据表空间 */
+create tablespace shenyu_data
+logging
+datafile 'D:\oracle\shenyu_data.dbf'
+size 50m
+autoextend on
+next 50m maxsize 20480m
+extent management local;
+
+/*第3步：创建用户并指定表空间 */
+create user shenyu identified by shenyu
+default tablespace shenyu_data;
+
+/*第4步：给用户授予权限 */
+grant connect,resource,dba to shenyu;
+
+create table SHENYU.APP_AUTH
+(
+ id VARCHAR2(128) not null,
+ app_key VARCHAR2(32) not null,
+ app_secret VARCHAR2(128) not null,
+ user_id VARCHAR2(128),
+ phone VARCHAR2(255),
+ ext_info VARCHAR2(1024),
+ open NUMBER(3) not null,
+ enabled NUMBER(3) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.APP_AUTH.id
+ is 'primary key id';
+comment on column SHENYU.APP_AUTH.app_key
+ is 'application identification key';
+comment on column SHENYU.APP_AUTH.app_secret
+ is 'encryption algorithm secret';
+comment on column SHENYU.APP_AUTH.user_id
+ is 'user id';
+comment on column SHENYU.APP_AUTH.phone
+ is 'phone number when the user applies';
+comment on column SHENYU.APP_AUTH.ext_info
+ is 'extended parameter json';
+comment on column SHENYU.APP_AUTH.open
+ is 'open auth path or not';
+comment on column SHENYU.APP_AUTH.enabled
+ is 'delete or not';
+comment on column SHENYU.APP_AUTH.date_created
+ is 'create time';
+comment on column SHENYU.APP_AUTH.date_updated
+ is 'update time';
+alter table SHENYU.APP_AUTH
+ add constraint PRIMARY primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.AUTH_PARAM
+(
+ id VARCHAR2(128) not null,
+ auth_id VARCHAR2(128),
+ app_name VARCHAR2(255) not null,
+ app_param VARCHAR2(255),
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.AUTH_PARAM.id
+ is 'primary key id';
+comment on column SHENYU.AUTH_PARAM.auth_id
+ is 'authentication table id';
+comment on column SHENYU.AUTH_PARAM.app_name
+ is 'business Module';
+comment on column SHENYU.AUTH_PARAM.app_param
+ is 'service module parameters (parameters that need to be passed by the
gateway) json type';
+comment on column SHENYU.AUTH_PARAM.date_created
+ is 'create time';
+comment on column SHENYU.AUTH_PARAM.date_updated
+ is 'update time';
+alter table SHENYU.AUTH_PARAM
+ add constraint PRIMARY_16 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.AUTH_PATH
+(
+ id VARCHAR2(128) not null,
+ auth_id VARCHAR2(128) not null,
+ app_name VARCHAR2(255) not null,
+ path VARCHAR2(255) not null,
+ enabled NUMBER(3) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.AUTH_PATH.id
+ is 'primary key id';
+comment on column SHENYU.AUTH_PATH.auth_id
+ is 'auth table id';
+comment on column SHENYU.AUTH_PATH.app_name
+ is 'module';
+comment on column SHENYU.AUTH_PATH.path
+ is 'path';
+comment on column SHENYU.AUTH_PATH.enabled
+ is 'whether pass 1 is';
+comment on column SHENYU.AUTH_PATH.date_created
+ is 'create time';
+comment on column SHENYU.AUTH_PATH.date_updated
+ is 'update time';
+alter table SHENYU.AUTH_PATH
+ add constraint PRIMARY_2 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.DASHBOARD_USER
+(
+ id VARCHAR2(128) not null,
+ user_name VARCHAR2(64) not null,
+ password VARCHAR2(128),
+ role NUMBER(10) not null,
+ enabled NUMBER(3) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.DASHBOARD_USER.id
+ is 'primary key id';
+comment on column SHENYU.DASHBOARD_USER.user_name
+ is 'user name';
+comment on column SHENYU.DASHBOARD_USER.password
+ is 'user password';
+comment on column SHENYU.DASHBOARD_USER.role
+ is 'role';
+comment on column SHENYU.DASHBOARD_USER.enabled
+ is 'delete or not';
+comment on column SHENYU.DASHBOARD_USER.date_created
+ is 'create time';
+comment on column SHENYU.DASHBOARD_USER.date_updated
+ is 'update time';
+alter table SHENYU.DASHBOARD_USER
+ add constraint PRIMARY_3 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+alter table SHENYU.DASHBOARD_USER
+ add constraint UNIQUE_USER_NAME unique (USER_NAME)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.DATA_PERMISSION
+(
+ id VARCHAR2(128) not null,
+ user_id VARCHAR2(128) not null,
+ data_id VARCHAR2(128) not null,
+ data_type NUMBER(10) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.DATA_PERMISSION.id
+ is 'primary key id';
+comment on column SHENYU.DATA_PERMISSION.user_id
+ is 'user primary key id';
+comment on column SHENYU.DATA_PERMISSION.data_id
+ is 'data(selector,rule) primary key id';
+comment on column SHENYU.DATA_PERMISSION.data_type
+ is '0 selector type , 1 rule type';
+comment on column SHENYU.DATA_PERMISSION.date_created
+ is 'create time';
+comment on column SHENYU.DATA_PERMISSION.date_updated
+ is 'update time';
+alter table SHENYU.DATA_PERMISSION
+ add constraint PRIMARY_4 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.META_DATA
+(
+ id VARCHAR2(128) not null,
+ app_name VARCHAR2(255) not null,
+ path VARCHAR2(255) not null,
+ path_desc VARCHAR2(255) not null,
+ rpc_type VARCHAR2(64) not null,
+ service_name VARCHAR2(255),
+ method_name VARCHAR2(255),
+ parameter_types VARCHAR2(255),
+ rpc_ext VARCHAR2(512),
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null,
+ enabled NUMBER(3) default '0' not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.META_DATA.id
+ is 'id';
+comment on column SHENYU.META_DATA.app_name
+ is 'application name';
+comment on column SHENYU.META_DATA.path
+ is 'path, cannot be repeated';
+comment on column SHENYU.META_DATA.path_desc
+ is 'path description';
+comment on column SHENYU.META_DATA.rpc_type
+ is 'rpc type';
+comment on column SHENYU.META_DATA.service_name
+ is 'service name';
+comment on column SHENYU.META_DATA.method_name
+ is 'method name';
+comment on column SHENYU.META_DATA.parameter_types
+ is 'parameter types are provided with multiple parameter types separated by
commas';
+comment on column SHENYU.META_DATA.rpc_ext
+ is 'rpc extended information, json format';
+comment on column SHENYU.META_DATA.date_created
+ is 'create time';
+comment on column SHENYU.META_DATA.date_updated
+ is 'update time';
+comment on column SHENYU.META_DATA.enabled
+ is 'enabled state';
+alter table SHENYU.META_DATA
+ add constraint PRIMARY_5 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.PERMISSION
+(
+ id VARCHAR2(128) not null,
+ object_id VARCHAR2(128) not null,
+ resource_id VARCHAR2(128) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.PERMISSION.id
+ is 'primary key id';
+comment on column SHENYU.PERMISSION.object_id
+ is 'user primary key id or role primary key id';
+comment on column SHENYU.PERMISSION.resource_id
+ is 'resource primary key id';
+comment on column SHENYU.PERMISSION.date_created
+ is 'create time';
+comment on column SHENYU.PERMISSION.date_updated
+ is 'update time';
+alter table SHENYU.PERMISSION
+ add constraint PRIMARY_6 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+create table SHENYU.PLUGIN
+(
+ id VARCHAR2(128) not null,
+ name VARCHAR2(62) not null,
+ config CLOB,
+ role VARCHAR2(64) not null,
+ sort NUMBER(10),
+ enabled NUMBER(3) default '0' not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.PLUGIN.id
+ is 'primary key id';
+comment on column SHENYU.PLUGIN.name
+ is 'plugin name';
+comment on column SHENYU.PLUGIN.config
+ is 'plugin configuration';
+comment on column SHENYU.PLUGIN.role
+ is 'plug-in role';
+comment on column SHENYU.PLUGIN.sort
+ is 'sort';
+comment on column SHENYU.PLUGIN.enabled
+ is 'whether to open (0, not open, 1 open)';
+comment on column SHENYU.PLUGIN.date_created
+ is 'create time';
+comment on column SHENYU.PLUGIN.date_updated
+ is 'update time';
+alter table SHENYU.PLUGIN
+ add constraint PRIMARY_7 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.PLUGIN_HANDLE
+(
+ id VARCHAR2(128) not null,
+ plugin_id VARCHAR2(128) not null,
+ field VARCHAR2(100) not null,
+ label VARCHAR2(100),
+ data_type NUMBER(5) default '1' not null,
+ type NUMBER(5),
+ sort NUMBER(10),
+ ext_obj VARCHAR2(1024),
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.PLUGIN_HANDLE.plugin_id
+ is 'plugin id';
+comment on column SHENYU.PLUGIN_HANDLE.field
+ is 'field';
+comment on column SHENYU.PLUGIN_HANDLE.label
+ is 'label';
+comment on column SHENYU.PLUGIN_HANDLE.data_type
+ is 'data type 1 number 2 string';
+comment on column SHENYU.PLUGIN_HANDLE.type
+ is 'type, 1 means selector, 2 means rule, 3 means plugin';
+comment on column SHENYU.PLUGIN_HANDLE.sort
+ is 'sort';
+comment on column SHENYU.PLUGIN_HANDLE.ext_obj
+ is 'extra configuration (json format data)';
+comment on column SHENYU.PLUGIN_HANDLE.date_created
+ is 'create time';
+comment on column SHENYU.PLUGIN_HANDLE.date_updated
+ is 'update time';
+alter table SHENYU.PLUGIN_HANDLE
+ add constraint PRIMARY_8 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+alter table SHENYU.PLUGIN_HANDLE
+ add constraint PLUGIN_ID_FIELD_TYPE unique (PLUGIN_ID, FIELD, TYPE)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU."RESOURCE"
+(
+ id VARCHAR2(128) not null,
+ parent_id VARCHAR2(128),
+ title VARCHAR2(128),
+ name VARCHAR2(32),
+ url VARCHAR2(32),
+ component VARCHAR2(32),
+ resource_type NUMBER(10) not null,
+ sort NUMBER(10) not null,
+ icon VARCHAR2(32),
+ is_leaf NUMBER(3) not null,
+ is_route NUMBER(10) not null,
+ perms VARCHAR2(64),
+ status NUMBER(10) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU."RESOURCE".id
+ is 'primary key id';
+comment on column SHENYU."RESOURCE".parent_id
+ is 'resource parent primary key id';
+comment on column SHENYU."RESOURCE".title
+ is 'title';
+comment on column SHENYU."RESOURCE".name
+ is 'route name';
+comment on column SHENYU."RESOURCE".url
+ is 'route url';
+comment on column SHENYU."RESOURCE".component
+ is 'component';
+comment on column SHENYU."RESOURCE".resource_type
+ is 'resource type eg 0:main menu 1:child menu 2:function button';
+comment on column SHENYU."RESOURCE".sort
+ is 'sort';
+comment on column SHENYU."RESOURCE".icon
+ is 'icon';
+comment on column SHENYU."RESOURCE".is_leaf
+ is 'leaf node 0:no 1:yes';
+comment on column SHENYU."RESOURCE".is_route
+ is 'route 1:yes 0:no';
+comment on column SHENYU."RESOURCE".perms
+ is 'button permission description sys:user:add(add)/sys:user:edit(edit)';
+comment on column SHENYU."RESOURCE".status
+ is 'status 1:enable 0:disable';
+comment on column SHENYU."RESOURCE".date_created
+ is 'create time';
+comment on column SHENYU."RESOURCE".date_updated
+ is 'update time';
+alter table SHENYU."RESOURCE"
+ add constraint PRIMARY_9 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.ROLE
+(
+ id VARCHAR2(128) not null,
+ role_name VARCHAR2(32) not null,
+ description VARCHAR2(255),
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.ROLE.id
+ is 'primary key id';
+comment on column SHENYU.ROLE.role_name
+ is 'role name';
+comment on column SHENYU.ROLE.description
+ is 'role describe';
+comment on column SHENYU.ROLE.date_created
+ is 'create time';
+comment on column SHENYU.ROLE.date_updated
+ is 'update time';
+alter table SHENYU.ROLE
+ add constraint PRIMARY_10 primary key (ID, ROLE_NAME)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.RULE
+(
+ id VARCHAR2(128) not null,
+ selector_id VARCHAR2(128) not null,
+ match_mode NUMBER(10) not null,
+ name VARCHAR2(128) not null,
+ enabled NUMBER(3) not null,
+ loged NUMBER(3) not null,
+ sort NUMBER(10) not null,
+ handle VARCHAR2(1024),
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.RULE.id
+ is 'primary key id';
+comment on column SHENYU.RULE.selector_id
+ is 'selector id';
+comment on column SHENYU.RULE.match_mode
+ is 'matching mode (0 and 1 or)';
+comment on column SHENYU.RULE.name
+ is 'rule name';
+comment on column SHENYU.RULE.enabled
+ is 'whether to open';
+comment on column SHENYU.RULE.loged
+ is 'whether to log or not';
+comment on column SHENYU.RULE.sort
+ is 'sort';
+comment on column SHENYU.RULE.handle
+ is 'processing logic (here for different plug-ins, there will be different
fields to identify different processes, all data in JSON format is stored)';
+comment on column SHENYU.RULE.date_created
+ is 'create time';
+comment on column SHENYU.RULE.date_updated
+ is 'update time';
+alter table SHENYU.RULE
+ add constraint PRIMARY_11 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+alter table SHENYU.RULE
+ add constraint UNIQUE_NAME unique (NAME)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.RULE_CONDITION
+(
+ id VARCHAR2(128) not null,
+ rule_id VARCHAR2(128) not null,
+ param_type VARCHAR2(64) not null,
+ operator VARCHAR2(64) not null,
+ param_name VARCHAR2(64) not null,
+ param_value VARCHAR2(64) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.RULE_CONDITION.id
+ is 'primary key id';
+comment on column SHENYU.RULE_CONDITION.rule_id
+ is 'rule id';
+comment on column SHENYU.RULE_CONDITION.param_type
+ is 'parameter type (post query uri, etc.)';
+comment on column SHENYU.RULE_CONDITION.operator
+ is 'matching character (=> <like match)';
+comment on column SHENYU.RULE_CONDITION.param_name
+ is 'parameter name';
+comment on column SHENYU.RULE_CONDITION.param_value
+ is 'parameter value';
+comment on column SHENYU.RULE_CONDITION.date_created
+ is 'create time';
+comment on column SHENYU.RULE_CONDITION.date_updated
+ is 'update time';
+alter table SHENYU.RULE_CONDITION
+ add constraint PRIMARY_12 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.SELECTOR
+(
+ id VARCHAR2(128) not null,
+ plugin_id VARCHAR2(128) not null,
+ name VARCHAR2(64) not null,
+ match_mode NUMBER(10) not null,
+ type NUMBER(10) not null,
+ sort NUMBER(10) not null,
+ handle VARCHAR2(1024),
+ enabled NUMBER(3) not null,
+ loged NUMBER(3) not null,
+ continued NUMBER(3) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.SELECTOR.id
+ is 'primary key id varchar';
+comment on column SHENYU.SELECTOR.plugin_id
+ is 'plugin id';
+comment on column SHENYU.SELECTOR.name
+ is 'selector name';
+comment on column SHENYU.SELECTOR.match_mode
+ is 'matching mode (0 and 1 or)';
+comment on column SHENYU.SELECTOR.type
+ is 'type (0, full flow, 1 custom flow)';
+comment on column SHENYU.SELECTOR.sort
+ is 'sort';
+comment on column SHENYU.SELECTOR.handle
+ is 'processing logic (here for different plug-ins, there will be different
fields to identify different processes, all data in JSON format is stored)';
+comment on column SHENYU.SELECTOR.enabled
+ is 'whether to open';
+comment on column SHENYU.SELECTOR.loged
+ is 'whether to print the log';
+comment on column SHENYU.SELECTOR.continued
+ is 'whether to continue execution';
+comment on column SHENYU.SELECTOR.date_created
+ is 'create time';
+comment on column SHENYU.SELECTOR.date_updated
+ is 'update time';
+alter table SHENYU.SELECTOR
+ add constraint PRIMARY_13 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+alter table SHENYU.SELECTOR
+ add constraint UNIQUE_NAME_16 unique (NAME)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.SELECTOR_CONDITION
+(
+ id VARCHAR2(128) not null,
+ selector_id VARCHAR2(128) not null,
+ param_type VARCHAR2(64) not null,
+ operator VARCHAR2(64) not null,
+ param_name VARCHAR2(64) not null,
+ param_value VARCHAR2(64) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.SELECTOR_CONDITION.id
+ is 'primary key id';
+comment on column SHENYU.SELECTOR_CONDITION.selector_id
+ is 'selector id';
+comment on column SHENYU.SELECTOR_CONDITION.param_type
+ is 'parameter type (to query uri, etc.)';
+comment on column SHENYU.SELECTOR_CONDITION.operator
+ is 'matching character (=> <like matching)';
+comment on column SHENYU.SELECTOR_CONDITION.param_name
+ is 'parameter name';
+comment on column SHENYU.SELECTOR_CONDITION.param_value
+ is 'parameter value';
+comment on column SHENYU.SELECTOR_CONDITION.date_created
+ is 'create time';
+comment on column SHENYU.SELECTOR_CONDITION.date_updated
+ is 'update time';
+alter table SHENYU.SELECTOR_CONDITION
+ add constraint PRIMARY_14 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.SHENYU_DICT
+(
+ id VARCHAR2(128) not null,
+ type VARCHAR2(100) not null,
+ dict_code VARCHAR2(100) not null,
+ dict_name VARCHAR2(100) not null,
+ dict_value VARCHAR2(100),
+ "desc" VARCHAR2(255),
+ sort NUMBER(10) not null,
+ enabled NUMBER(3),
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.SHENYU_DICT.id
+ is 'primary key id';
+comment on column SHENYU.SHENYU_DICT.type
+ is 'type';
+comment on column SHENYU.SHENYU_DICT.dict_code
+ is 'dictionary encoding';
+comment on column SHENYU.SHENYU_DICT.dict_name
+ is 'dictionary name';
+comment on column SHENYU.SHENYU_DICT.dict_value
+ is 'dictionary value';
+comment on column SHENYU.SHENYU_DICT."desc"
+ is 'dictionary description or remarks';
+comment on column SHENYU.SHENYU_DICT.sort
+ is 'sort';
+comment on column SHENYU.SHENYU_DICT.enabled
+ is 'whether it is enabled';
+comment on column SHENYU.SHENYU_DICT.date_created
+ is 'create time';
+comment on column SHENYU.SHENYU_DICT.date_updated
+ is 'update time';
+alter table SHENYU.SHENYU_DICT
+ add constraint PRIMARY_15 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+create table SHENYU.USER_ROLE
+(
+ id VARCHAR2(128) not null,
+ user_id VARCHAR2(128) not null,
+ role_id VARCHAR2(128) not null,
+ date_created DATE default SYSDATE not null,
+ date_updated DATE default SYSDATE not null
+)
+ tablespace USERS
+ pctfree 10
+ initrans 1
+ maxtrans 255;
+comment on column SHENYU.USER_ROLE.id
+ is 'primary key id';
+comment on column SHENYU.USER_ROLE.user_id
+ is 'user primary key';
+comment on column SHENYU.USER_ROLE.role_id
+ is 'role primary key';
+comment on column SHENYU.USER_ROLE.date_created
+ is 'create time';
+comment on column SHENYU.USER_ROLE.date_updated
+ is 'update time';
+alter table SHENYU.USER_ROLE
+ add constraint PRIMARY_1 primary key (ID)
+ using index
+ tablespace USERS
+ pctfree 10
+ initrans 2
+ maxtrans 255;
+
+
+insert into shenyu.DASHBOARD_USER (id, user_name, password, role, enabled,
date_created, date_updated)
Review comment:
okok, I create producer about insert ingro..
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
