--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);