fix admin: db sql script.
@@ -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,
