yili-apps/com.actionsoft.apps.addons.xpages/db/1.1/oracle.sql
shangxiaoran@qq.com 2608324b68 初始化应用
2022-06-28 01:22:45 +08:00

4 lines
450 B
SQL
Executable File

CREATE TABLE APP_ACT_LINK_QUICKLY(ID CHAR(36) NOT NULL,GROUPKEY CHAR(36) ,VIEWTYPE NUMBER(10,0),LOCKED VARCHAR2(36),PRIMARY KEY (ID));
CREATE TABLE APP_ACT_LINK_QUICKLY_FUNCTION(ID CHAR(36) NOT NULL,PID CHAR(36),LINKNAME VARCHAR2(200) ,LINKTYPE NUMBER(10,0),LINKURL VARCHAR2(2000),LINKTARGET CHAR(36) ,ICONURL VARCHAR2(250),ORDERINDEX NUMBER(10,0),USERID VARCHAR2(36),GROUPNAME VARCHAR2(64),EXT1 VARCHAR2(250),EXT2 VARCHAR2(250),PRIMARY KEY (ID));