--Actions
|
CREATE TABLE PLACTION (
|
PLOID VARCHAR2(64) not null,
|
PLCODE VARCHAR2(64) not null,
|
PLNAME VARCHAR2(128) not null,
|
PLBSURL VARCHAR2(128),
|
PLCSCLASS VARCHAR2(128),
|
PLDESC VARCHAR2(255),
|
PLTYPETYPE VARCHAR2(32) not null,
|
PLCREATETIME TIMESTAMP(6) not null,
|
PLCREATEUSER VARCHAR2(64) not null,
|
PLMODIFYTIME TIMESTAMP(6) not null,
|
PLMODIFYUSER VARCHAR2(64) not null,
|
PLLICENSORS VARCHAR2(64),
|
PLACTIONCLS VARCHAR2(64),
|
CONSTRAINT PK_ACTION PRIMARY KEY(PLOID)
|
);
|
--Ô²Ù×÷¼ÓÈë²ÎÊý
|
comment on table PLACTION is 'Action';
|
comment on column PLACTION.PLOID
|
is 'ID';
|
comment on column PLACTION.PLCODE
|
is '±àÂë';
|
comment on column PLACTION.PLNAME
|
is 'Ãû³Æ';
|
comment on column PLACTION.PLBSADAPTER
|
is 'BSϵͳ½âÎöÆ÷';
|
comment on column PLACTION.PLORGNIZATIONTYPE
|
is 'CSϵͳ½âÎöÆ÷';
|
comment on column PLACTION.PLDESC
|
is 'ÃèÊö';
|
comment on column PLACTION.PLCREATETIME
|
is '´´½¨Ê±¼ä';
|
comment on column PLACTION.PLCREATEUSER
|
is '´´½¨Õß';
|
comment on column PLACTION.PLMODIFYTIME
|
is 'ÐÞ¸Äʱ¼ä';
|
comment on column PLACTION.PLMODIFYUSER
|
is 'ÐÞ¸ÄÕß';
|
comment on column PLACTION.PLLICENSORS
|
is 'ÊÚȨÕß';
|
comment on column PLACTION.PLACTIONCLS
|
is 'ËùÊô·ÖÀà';
|
|
--action·ÖÀà
|
create table PLACTIONCLS
|
(
|
OID VARCHAR2(36) not null,
|
NAME VARCHAR2(100),
|
PID VARCHAR2(36),
|
DESCRIPTION VARCHAR2(500),
|
CREATOR VARCHAR2(50),
|
CREATETIME DATE default sysdate not null,
|
SERIALNO NUMBER
|
);
|
-- Add comments to the table
|
comment on table PLACTIONCLS
|
is 'action·ÖÀà';
|
-- Add comments to the columns
|
comment on column PLACTIONCLS.OID
|
is 'oid';
|
comment on column PLACTIONCLS.NAME
|
is 'Ãû³Æ';
|
comment on column PLACTIONCLS.PID
|
is '¸¸ID';
|
comment on column PLACTIONCLS.DESCRIPTION
|
is 'ÃèÊö';
|
comment on column PLACTIONCLS.CREATOR
|
is '´´½¨Õß';
|
comment on column PLACTIONCLS.CREATETIME
|
is '´´½¨Ê±¼ä';
|
comment on column PLACTIONCLS.SERIALNO
|
is 'ÐòºÅ';
|
alter table PLACTIONCLS
|
add constraint PRIMARY_PLACTIONCLS primary key (OID);
|
|
--action²ÎÊý
|
create table PLACTIONPARAM
|
(
|
OID VARCHAR2(64) not null,
|
NAME VARCHAR2(100),
|
DEFAULTVALUE VARCHAR2(500),
|
DESCRIPTION VARCHAR2(1000),
|
ACTION VARCHAR2(64)
|
);
|
-- Add comments to the table
|
comment on table PLACTIONPARAM
|
is 'action²ÎÊý';
|
-- Add comments to the columns
|
comment on column PLACTIONPARAM.OID
|
is 'oid';
|
comment on column PLACTIONPARAM.NAME
|
is 'Ãû³Æ';
|
comment on column PLACTIONPARAM.DEFAULTVALUE
|
is 'ĬÈÏÖµ';
|
comment on column PLACTIONPARAM.DESCRIPTION
|
is 'ÃèÊö';
|
comment on column PLACTIONPARAM.ACTION
|
is 'action oid';
|
-- Create/Recreate primary, unique and foreign key constraints
|
alter table PLACTIONPARAM
|
add constraint PRIMARY_PLACTIONPARAM primary key (OID);
|
|
--Ò³Ã涨Òå
|
CREATE TABLE PLPAGElayoutDEFINATION (
|
PLOID VARCHAR2(64) not null,
|
PLCODE VARCHAR2(64) not null,
|
PLNAME VARCHAR2(128) not null,
|
PLRELATEDTYPE VARCHAR2(64) not null,
|
PLDESC VARCHAR2(255),
|
PLISSHOWTAB NUMBER,
|
PLISSHOWFORM NUMBER,
|
PLISSHOWNAVIGATOR NUMBER,
|
PLCREATETIME TIMESTAMP(6) not null,
|
PLCREATEUSER VARCHAR2(64) not null,
|
PLMODIFYTIME TIMESTAMP(6) not null,
|
PLMODIFYUSER VARCHAR2(64) not null,
|
PLLICENSORS VARCHAR2(64),
|
CONSTRAINT PK_PAGEDEFINATION PRIMARY KEY(PLOID)
|
);
|
-- Add comments to the table
|
comment on table PLPAGELAYOUTDEFINATION
|
is 'Ò³Ãæ²¼¾Ö¶¨Òå';
|
-- Add comments to the columns
|
comment on column PLPAGELAYOUTDEFINATION.PLOID
|
is 'ID';
|
comment on column PLPAGELAYOUTDEFINATION.PLCODE
|
is 'ÉÏÏÂÎıàÂë';
|
comment on column PLPAGELAYOUTDEFINATION.PLNAME
|
is 'Ãû³Æ';
|
comment on column PLPAGELAYOUTDEFINATION.PLRELATEDTYPE
|
is '¹ØÁªÀàÐÍ';
|
comment on column PLPAGELAYOUTDEFINATION.PLDESC
|
is 'ÃèÊö';
|
comment on column PLPAGELAYOUTDEFINATION.PLISSHOWTAB
|
is 'ÊÇ·ñÏÔʾtabÒ³£¬1£¬ÏÔʾ£»0¡¢²»ÏÔʾ';
|
comment on column PLPAGELAYOUTDEFINATION.PLISSHOWFORM
|
is 'ÊÇ·ñÏÔʾform£¬1£¬ÏÔʾ£»0¡¢²»ÏÔʾ';
|
comment on column PLPAGELAYOUTDEFINATION.PLISSHOWNAVIGATOR
|
is 'ÊÇ·ñÏÔʾµ¼º½£¬1£¬ÏÔʾ£»0¡¢²»ÏÔʾ';
|
comment on column PLPAGELAYOUTDEFINATION.PLCREATETIME
|
is '´´½¨Ê±¼ä';
|
comment on column PLPAGELAYOUTDEFINATION.PLCREATEUSER
|
is '´´½¨Õß';
|
comment on column PLPAGELAYOUTDEFINATION.PLMODIFYTIME
|
is 'ÐÞ¸Äʱ¼ä';
|
comment on column PLPAGELAYOUTDEFINATION.PLMODIFYUSER
|
is 'ÐÞ¸ÄÕß';
|
comment on column PLPAGELAYOUTDEFINATION.PLLICENSORS
|
is 'ÊÚȨÕß';
|
|
--ҳǩ
|
create table PLTABPAGE
|
(
|
PLOID VARCHAR2(64) not null,
|
PLCODE VARCHAR2(64) not null,
|
PLNAME VARCHAR2(128) not null,
|
PLISOPEN NUMBER not null,
|
PLLABEL VARCHAR2(128),
|
PLDESC VARCHAR2(255),
|
PLSEQ NUMBER not null,
|
PLPAGEDEFINATIONOID VARCHAR2(64) not null,
|
PLCREATETIME TIMESTAMP(6) not null,
|
PLCREATEUSER VARCHAR2(64) not null,
|
PLMODIFYTIME TIMESTAMP(6) not null,
|
PLMODIFYUSER VARCHAR2(64) not null,
|
PLLICENSORS VARCHAR2(64),
|
PLOPENEXPRESSION VARCHAR2(512),
|
PLAREATYPE NUMBER default 3 not null,
|
PLUIPARSER VARCHAR2(2000),
|
PLEXTATTR VARCHAR2(4000)
|
);
|
-- Add comments to the table
|
comment on table PLTABPAGE
|
is 'ҳǩ';
|
-- Add comments to the columns
|
comment on column PLTABPAGE.PLOID
|
is 'ID';
|
comment on column PLTABPAGE.PLCODE
|
is 'ҳǩ±àÂë';
|
comment on column PLTABPAGE.PLNAME
|
is 'Ãû³Æ';
|
comment on column PLTABPAGE.PLISOPEN
|
is 'ÊÇ·ñÆôÓãº1´ú±íÆôÓã¬0´ú±í²»Æô¶¯';
|
comment on column PLTABPAGE.PLLABEL
|
is '¶àÓï±êʾ';
|
comment on column PLTABPAGE.PLDESC
|
is 'ÃèÊö';
|
comment on column PLTABPAGE.PLSEQ
|
is 'ҳǩ˳Ðò';
|
comment on column PLTABPAGE.PLPAGEDEFINATIONOID
|
is 'ҳǩÉÏÏÂÎļþoid';
|
comment on column PLTABPAGE.PLCREATETIME
|
is '´´½¨Ê±¼ä';
|
comment on column PLTABPAGE.PLCREATEUSER
|
is '´´½¨Õß';
|
comment on column PLTABPAGE.PLMODIFYTIME
|
is 'ÐÞ¸Äʱ¼ä';
|
comment on column PLTABPAGE.PLMODIFYUSER
|
is 'ÐÞ¸ÄÕß';
|
comment on column PLTABPAGE.PLLICENSORS
|
is 'ÊÚȨÕß';
|
comment on column PLTABPAGE.PLOPENEXPRESSION
|
is '¿ØÖÆÏÔʾµÄ±í´ïʽ£¬Îª¿ÕʱĬÈÏÏÔʾ';
|
comment on column PLTABPAGE.PLAREATYPE
|
is '1´ú±íµ¼º½Çø¡¢2´ú±íÖ÷Êý¾ÝÇø¡¢3´ú±íҳǩÇø';
|
comment on column PLTABPAGE.PLUIPARSER
|
is 'UI½âÎöÆ÷£¬Ó÷ֺÅ;·Ö¸ô¸÷×éÖµ£¬Ã¿×éÓÃðºÅ:·Ö¸ô½âÎöÆ÷ÀàÀà±ðÃû³ÆÓë½âÎöÀàÖµ£¬Ê¾Àý£ºjava_cs:xx;java_bs:xxx;net_cs:xxx;net_bs:xxx;net_cs:xxx;mobile_cs:xxx;mobile_bs:xxx;';
|
comment on column PLTABPAGE.PLEXTATTR
|
is 'À©Õ¹ÊôÐÔ£¬Ó÷ֺÅ;·Ö¸ô¸÷×éÖµ£¬Ã¿×éÓÃðºÅ:·Ö¸ôÀ©Õ¹ÊôÐÔÃû³ÆÓëÀ©Õ¹ÊôÐÔÖµ£¬Ê¾Àý£ºext1:xxx;ext2:xxx;ext3:xxx;extn:xxx;';
|
-- Create/Recreate primary, unique and foreign key constraints
|
alter table PLTABPAGE
|
add constraint PK_TABPAGE primary key (PLOID);
|
|
--×é¼þ¶¨Òå
|
create table PLPAGEDEFINATION
|
(
|
PLOID VARCHAR2(64) not null,
|
PLPAGECONTEXTOID VARCHAR2(64) not null,
|
PLTYPE NUMBER not null,
|
PLDEFINATION CLOB,
|
PLNAME VARCHAR2(128),
|
PLDESC VARCHAR2(256),
|
PLSEQ NUMBER default 1
|
);
|
-- Add comments to the table
|
comment on table PLPAGEDEFINATION
|
is 'UI¶¨Òå';
|
-- Add comments to the columns
|
comment on column PLPAGEDEFINATION.PLOID
|
is 'ID';
|
comment on column PLPAGEDEFINATION.PLPAGECONTEXTOID
|
is 'ÉÏÏÂÎļþOID';
|
comment on column PLPAGEDEFINATION.PLTYPE
|
is 'Ò³ÃæÀàÐÍ£¬1£º´ú±íµ¼º½Ê÷£»2£º´ú±íÖ÷ÄÚÈÝÇø£»3£º´ú±íҳǩÇø';
|
comment on column PLPAGEDEFINATION.PLDEFINATION
|
is 'Ò³Ã涨ÒåµÄXMLÎļþ';
|
comment on column PLPAGEDEFINATION.PLNAME
|
is 'Ãû³Æ';
|
comment on column PLPAGEDEFINATION.PLDESC
|
is 'ÃèÊö';
|
comment on column PLPAGEDEFINATION.PLSEQ
|
is '˳Ðò';
|
-- Create/Recreate primary, unique and foreign key constraints
|
alter table PLPAGEDEFINATION
|
add constraint PK_PAGEDEFINATION primary key (PLOID);
|
|
--ҳǩ°´Å¥
|
create table PLTABBUTTON
|
(
|
PLOID VARCHAR2(64) not null,
|
PLTABLEOID VARCHAR2(64),
|
PLPAGEOID VARCHAR2(64),
|
PLACTIONOID VARCHAR2(64) not null,
|
PLLABEL VARCHAR2(128),
|
PLDESC VARCHAR2(255),
|
PLSEQ NUMBER not null,
|
PLCREATETIME TIMESTAMP(6) not null,
|
PLCREATEUSER VARCHAR2(64) not null,
|
PLMODIFYTIME TIMESTAMP(6) not null,
|
PLMODIFYUSER VARCHAR2(64) not null,
|
PLLICENSORS VARCHAR2(64),
|
PLAREATYPE VARCHAR2(64),
|
PLDISPLAYMODE VARCHAR2(15) default 'textandimage',
|
PLICONPATH VARCHAR2(200),
|
AUTHORIZATION CHAR(1),
|
PLPARENTOID VARCHAR2(64),
|
PLSHOW CHAR(1) default 0
|
);
|
-- Add comments to the table
|
comment on table PLTABBUTTON
|
is 'ҳǩ°´Å¥';
|
-- Add comments to the columns
|
comment on column PLTABBUTTON.PLOID
|
is 'ID';
|
comment on column PLTABBUTTON.PLTABLEOID
|
is 'ÊÓͼOID, ¶ÔÓ¦PORTAL_VIµÄID';
|
comment on column PLTABBUTTON.PLPAGEOID
|
is 'ҳǩOID';
|
comment on column PLTABBUTTON.PLACTIONOID
|
is 'ACTION OID';
|
comment on column PLTABBUTTON.PLLABEL
|
is '¶àÓï±êʾ';
|
comment on column PLTABBUTTON.PLDESC
|
is 'ÃèÊö';
|
comment on column PLTABBUTTON.PLSEQ
|
is '˳ÐòºÅ';
|
comment on column PLTABBUTTON.PLCREATETIME
|
is '´´½¨Ê±¼ä';
|
comment on column PLTABBUTTON.PLCREATEUSER
|
is '´´½¨Õß';
|
comment on column PLTABBUTTON.PLMODIFYTIME
|
is 'ÐÞ¸Äʱ¼ä';
|
comment on column PLTABBUTTON.PLMODIFYUSER
|
is 'ÐÞ¸ÄÕß';
|
comment on column PLTABBUTTON.PLLICENSORS
|
is 'ÊÚȨÕß';
|
comment on column PLTABBUTTON.PLAREATYPE
|
is 'tab´ú±ítabҳǩ£¬navigator´ú±íµ¼º½Çø£¬form´ú±íformnavigatorTree´ú±íµ¼º½Ê÷';
|
comment on column PLTABBUTTON.PLDISPLAYMODE
|
is 'ÏÔʾ·½Ê½ ÎÄ×Ö£ºtext ͼ±ê£ºimage ÎÄ×ÖºÍͼ±ê textandimage';
|
comment on column PLTABBUTTON.PLICONPATH
|
is 'ͼ±ê·¾¶';
|
comment on column PLTABBUTTON.AUTHORIZATION
|
is 'ÊÇ·ñÐèÒªÊÚȨ 0£ºÊÇ 1£º·ñ';
|
comment on column PLTABBUTTON.PLPARENTOID
|
is '¸¸°´Å¥OID';
|
comment on column PLTABBUTTON.PLSHOW
|
is 'ÊÇ·ñÏÔʾ£¬0:ÏÔʾ£¬1:²»ÏÔʾ';
|
-- Create/Recreate primary, unique and foreign key constraints
|
alter table PLTABBUTTON
|
add constraint PK_TABBUTTON primary key (PLOID);
|
|
--Command²ÎÊý
|
create table PLCOMMANDPARAMETER
|
(
|
PLOID VARCHAR2(64) not null,
|
PLCOMMANDOID VARCHAR2(64) not null,
|
PLKEY VARCHAR2(64) not null,
|
PLVALUE VARCHAR2(600) not null,
|
PLCREATETIME TIMESTAMP(6) not null,
|
PLCREATEUSER VARCHAR2(64) not null,
|
PLMODIFYTIME TIMESTAMP(6) not null,
|
PLMODIFYUSER VARCHAR2(64) not null,
|
PLLICENSORS VARCHAR2(64)
|
);
|
-- Add comments to the table
|
comment on table PLCOMMANDPARAMETER
|
is 'Command²ÎÊý';
|
-- Add comments to the columns
|
comment on column PLCOMMANDPARAMETER.PLCOMMANDOID
|
is '¹¦ÄܵãOID';
|
comment on column PLCOMMANDPARAMETER.PLKEY
|
is '²ÎÊýÖ÷¼ü';
|
comment on column PLCOMMANDPARAMETER.PLVALUE
|
is '²ÎÊýÖµ';
|
comment on column PLCOMMANDPARAMETER.PLCREATETIME
|
is '´´½¨Ê±¼ä';
|
comment on column PLCOMMANDPARAMETER.PLCREATEUSER
|
is '´´½¨Õß';
|
comment on column PLCOMMANDPARAMETER.PLMODIFYTIME
|
is 'ÐÞ¸Äʱ¼ä';
|
comment on column PLCOMMANDPARAMETER.PLMODIFYUSER
|
is 'ÐÞ¸ÄÕß';
|
comment on column PLCOMMANDPARAMETER.PLLICENSORS
|
is 'ÊÚȨÕß';
|
-- Create/Recreate primary, unique and foreign key constraints
|
alter table PLCOMMANDPARAMETER
|
add constraint PK_COMMANDPARAMETER primary key (PLOID);
|
|
--±íµ¥ÁÐ±í¶¨Òå
|
create table PORTAL_VI
|
(
|
ID VARCHAR2(36) not null,
|
TYPEFLAG NUMBER(1) default 0,
|
TYPENAME VARCHAR2(48) not null,
|
VINAME VARCHAR2(255) not null,
|
VITYPE VARCHAR2(36) not null,
|
PRM CLOB
|
);
|
-- Add comments to the table
|
comment on table PORTAL_VI
|
is '±íµ¥ÁÐ±í¶¨Òå';
|
-- Add comments to the columns
|
comment on column PORTAL_VI.TYPEFLAG
|
is '0: ÒµÎñÀàÐÍ; 1: Á´½ÓÀàÐÍ. ĬÈÏ0';
|
comment on column PORTAL_VI.TYPENAME
|
is 'ÀàÐÍÃû';
|
comment on column PORTAL_VI.VINAME
|
is 'ÊÓͼÃû';
|
comment on column PORTAL_VI.VITYPE
|
is 'ÊÓͼÀàÐÍ: ÊäÈë±íµ¥»ò·ÖÒ³Áбí';
|
comment on column PORTAL_VI.PRM
|
is '¶¨ÒåÏêÇé';
|
-- Create/Recreate primary, unique and foreign key constraints
|
alter table PORTAL_VI
|
add primary key (ID);
|
|
--²éѯÊôÐÔ·¶Î§Ä£°å¶¨Òå
|
create table PLATFORM_QTD
|
(
|
QTDNAME VARCHAR2(32) not null,
|
CREATOR VARCHAR2(32),
|
CREATETIME DATE,
|
BTMNAME VARCHAR2(32),
|
ABNAMES VARCHAR2(4000),
|
LINKTYPENAME VARCHAR2(32)
|
);
|
-- Add comments to the table
|
comment on table PLATFORM_QTD
|
is '²éѯÊôÐÔÄ£°å¶¨Òå';
|
-- Add comments to the columns
|
comment on column PLATFORM_QTD.QTDNAME
|
is 'Ãû³Æ';
|
comment on column PLATFORM_QTD.CREATOR
|
is '´´½¨Õß';
|
comment on column PLATFORM_QTD.CREATETIME
|
is '´´½¨Ê±¼ä';
|
comment on column PLATFORM_QTD.BTMNAME
|
is 'ÒµÎñÀàÐÍÃû³Æ';
|
comment on column PLATFORM_QTD.ABNAMES
|
is '±ðÃû';
|
comment on column PLATFORM_QTD.LINKTYPENAME
|
is 'Á´½ÓÀàÐÍÃû³Æ';
|
-- Create/Recreate primary, unique and foreign key constraints
|
alter table PLATFORM_QTD
|
add constraint QTD_PK primary key (QTDNAME)£»
|
|
--²éѯģ°å
|
create table PLATFORM_QT
|
(
|
QTNAME VARCHAR2(32) not null,
|
BTMNAME VARCHAR2(32),
|
CREATOR VARCHAR2(32),
|
CREATETIME DATE,
|
LEVELFLAG NUMBER,
|
QTUITEXT CLOB,
|
QTTEXT CLOB
|
);
|
-- Add comments to the columns
|
comment on column PLATFORM_QT.QTNAME
|
is 'Ãû³Æ';
|
comment on column PLATFORM_QT.BTMNAME
|
is 'ÒµÎñÀàÐÍÃû³Æ';
|
comment on column PLATFORM_QT.CREATOR
|
is '´´½¨Õß';
|
comment on column PLATFORM_QT.CREATETIME
|
is '´´½¨Ê±¼ä';
|
comment on column PLATFORM_QT.LEVELFLAG
|
is '²ã¼¶';
|
comment on column PLATFORM_QT.QTUITEXT
|
is '²éѯÊôÐÔÅäÖÃÐÅÏ¢';
|
comment on column PLATFORM_QT.QTTEXT
|
is 'È«²éѯģ°åÐÅÏ¢';
|
alter table PLATFORM_QT
|
add constraint QT_PK primary key (QTNAME)£»
|
|
--ÒµÎñÀàÐͶÔÓ¦²Ù×÷±í
|
create table PLTYPEACTION
|
(
|
PLOID VARCHAR2(50 CHAR),
|
TYPENAME VARCHAR2(50 CHAR),
|
ACTIONOID VARCHAR2(50 CHAR)
|
);
|
-- Add comments to the table
|
comment on table PLTYPEACTION
|
is 'ÒµÎñÀàÐͶÔÓ¦²Ù×÷±í';
|
-- Add comments to the columns
|
comment on column PLTYPEACTION.PLOID
|
is 'oid';
|
comment on column PLTYPEACTION.TYPENAME
|
is 'ÒµÎñÀàÐÍÃû³Æ';
|
comment on column PLTYPEACTION.ACTIONOID
|
is 'action¶ÔÓ¦µÄid';
|
alter table PLTYPEACTION
|
add constraint TYPEACTION_PK primary key (PLOID)£»
|
|
--ÒµÎñÀàÐÍÊý¾ÝÊÚȨ
|
create table PLATFORM_TYPERIGHT
|
(
|
ID VARCHAR2(50) not null,
|
USERS VARCHAR2(3000),
|
USERGROUPS VARCHAR2(3000),
|
USERROLES VARCHAR2(3000),
|
IDENTIFIER VARCHAR2(100),
|
EXPRESSIONTOSQL VARCHAR2(4000),
|
ISGRANT CHAR(1),
|
RULETEXT VARCHAR2(4000),
|
SENIORRULETEXT VARCHAR2(4000),
|
RULENAME VARCHAR2(100),
|
RULETYPE VARCHAR2(2),
|
LEXPRESSIONTOSQL VARCHAR2(4000),
|
LRULETEXT VARCHAR2(4000),
|
LSENIORRULETEXT VARCHAR2(4000)
|
);
|
-- Add comments to the table
|
comment on table PLATFORM_TYPERIGHT
|
is 'ÒµÎñÀàÐÍÊÚȨ';
|
-- Add comments to the columns
|
comment on column PLATFORM_TYPERIGHT.ID
|
is 'id';
|
comment on column PLATFORM_TYPERIGHT.USERS
|
is 'Óû§£¬Í¨¹ý¶ººÅ·Ö¸ô';
|
comment on column PLATFORM_TYPERIGHT.USERGROUPS
|
is '²¿·Ö£¬Í¨¹ý¶ººÅ·Ö¸ô';
|
comment on column PLATFORM_TYPERIGHT.USERROLES
|
is '½ÇÉ«£¬Í¨¹ý¶ººÅ·Ö¸ô';
|
comment on column PLATFORM_TYPERIGHT.IDENTIFIER
|
is '²Ù×÷±êʾ';
|
comment on column PLATFORM_TYPERIGHT.EXPRESSIONTOSQL
|
is 'Ìõ¼þ±í´ïʽ';
|
comment on column PLATFORM_TYPERIGHT.ISGRANT
|
is 'ÊÇ·ñÊÚȨ';
|
comment on column PLATFORM_TYPERIGHT.RULETEXT
|
is 'УÑé¹æÔòÎı¾';
|
comment on column PLATFORM_TYPERIGHT.RULENAME
|
is '¹æÔòÃû³Æ';
|
comment on column PLATFORM_TYPERIGHT.RULETYPE
|
is '¹æÔòÀàÐÍ';
|
-- Create/Recreate primary, unique and foreign key constraints
|
alter table PLATFORM_TYPERIGHT
|
add constraint PRIMARY_OID primary key (ID);
|
