This is an automated email from the ASF dual-hosted git repository.
xiaoyu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shenyu.git
The following commit(s) were added to refs/heads/master by this push:
new db332370b fix admin: db sql script. (#3833)
db332370b is described below
commit db332370b2addaea3cdcb48dccd32a0b1d6b2118
Author: Seth <[email protected]>
AuthorDate: Thu Aug 11 21:48:11 2022 +0800
fix admin: db sql script. (#3833)
---
db/init/oracle/schema.sql | 14 +++++++-------
1 file changed, 7 insertions(+), 7 deletions(-)
diff --git a/db/init/oracle/schema.sql b/db/init/oracle/schema.sql
index f6a61983a..d58c130b6 100644
--- a/db/init/oracle/schema.sql
+++ b/db/init/oracle/schema.sql
@@ -513,17 +513,17 @@ comment on column PERMISSION.date_updated
create table "resource"
(
id VARCHAR2(128) not null,
- parent_id VARCHAR2(128),
- title VARCHAR2(128),
- name VARCHAR2(32),
- url VARCHAR2(32),
- component VARCHAR2(32),
+ parent_id VARCHAR2(128) not null,
+ title VARCHAR2(128) not null,
+ name VARCHAR2(32) not null,
+ url VARCHAR2(32) not null,
+ component VARCHAR2(32) not null,
resource_type NUMBER(10) not null,
sort NUMBER(10) not null,
- icon VARCHAR2(32),
+ icon VARCHAR2(32) not null,
is_leaf NUMBER(3) not null,
is_route NUMBER(10) not null,
- perms VARCHAR2(64),
+ perms VARCHAR2(64) not null,
status NUMBER(10) not null,
date_created timestamp(3) default SYSDATE not null,
date_updated timestamp(3) default SYSDATE not null,
