drop table plbtmtype; drop table pllinktype; drop table plattribute; drop table plenum; drop table plstatepool; drop table plversionrule; drop table pllifecycle; -- ÒµÎñÀàÐÍ create table PLBTMTYPE ( OID VARCHAR2(64) not null, NAME VARCHAR2(128) not null, LABEL VARCHAR2(256), DESCRIPTION VARCHAR2(256), TS TIMESTAMP(6), CREATOR VARCHAR2(64), CREATETIME TIMESTAMP(6), MODIFIER VARCHAR2(64), MODIFYTIME TIMESTAMP(6), CONTENT SYS.XMLTYPE ); -- Add comments to the table comment on table PLBTMTYPE is 'ÒµÎñÀàÐͱí'; -- Add comments to the columns comment on column PLBTMTYPE.NAME is 'Ãû³Æ'; comment on column PLBTMTYPE.LABEL is '±êʾ'; comment on column PLBTMTYPE.DESCRIPTION is 'ÃèÊö'; comment on column PLBTMTYPE.TS is 'TSËø'; comment on column PLBTMTYPE.CREATOR is '´´½¨ÈË'; comment on column PLBTMTYPE.CREATETIME is '´´½¨Ê±¼ä'; comment on column PLBTMTYPE.MODIFIER is 'ÐÞ¸ÄÈË'; comment on column PLBTMTYPE.MODIFYTIME is 'ÐÞ¸Äʱ¼ä'; comment on column PLBTMTYPE.CONTENT is 'ÄÚÈÝ'; -- Create/Recreate primary, unique and foreign key constraints alter table PLBTMTYPE add constraint PK_BTMTYPE primary key (OID); alter table PLBTMTYPE add constraint IDX_BTMTYPE_NAME unique (NAME); --Á´½ÓÀàÐÍ create table PLLINKTYPE ( OID VARCHAR2(64) not null, NAME VARCHAR2(128) not null, LABEL VARCHAR2(256), DESCRIPTION VARCHAR2(256), TS TIMESTAMP(6), CREATOR VARCHAR2(64), CREATETIME TIMESTAMP(6), MODIFIER VARCHAR2(64), MODIFYTIME TIMESTAMP(6), CONTENT SYS.XMLTYPE ); -- Add comments to the table comment on table PLLINKTYPE is 'Á´½ÓÀàÐͱí'; -- Add comments to the columns comment on column PLLINKTYPE.NAME is 'Ãû³Æ'; comment on column PLLINKTYPE.LABEL is '±êʾ'; comment on column PLLINKTYPE.DESCRIPTION is 'ÃèÊö'; comment on column PLLINKTYPE.TS is 'tsËø'; comment on column PLLINKTYPE.CREATOR is '´´½¨Õß'; comment on column PLLINKTYPE.CREATETIME is '´´½¨Ê±¼ä'; comment on column PLLINKTYPE.MODIFIER is 'ÐÞ¸ÄÕß'; comment on column PLLINKTYPE.MODIFYTIME is 'ÐÞ¸Äʱ¼ä'; comment on column PLLINKTYPE.CONTENT is 'ÄÚÈÝ'; -- Create/Recreate primary, unique and foreign key constraints alter table PLLINKTYPE add constraint PK_LINKTYPE primary key (OID); alter table PLLINKTYPE add constraint IDX_LINKTYPE_NAME unique (NAME); -- ÊôÐÔ³Ø create table PLATTRIBUTE ( OID VARCHAR2(64) not null, NAME VARCHAR2(128) not null, LABEL VARCHAR2(256), DESCRIPTION VARCHAR2(256), TS TIMESTAMP(6), CREATOR VARCHAR2(64), CREATETIME TIMESTAMP(6), MODIFIER VARCHAR2(64), MODIFYTIME TIMESTAMP(6), CONTENT SYS.XMLTYPE ); -- Add comments to the table comment on table PLATTRIBUTE is 'ÊôÐԳرí'; -- Add comments to the columns comment on column PLATTRIBUTE.NAME is 'Ãû³Æ'; comment on column PLATTRIBUTE.LABEL is '±êʾ'; comment on column PLATTRIBUTE.DESCRIPTION is 'ÃèÊö'; comment on column PLATTRIBUTE.TS is 'TSËø'; comment on column PLATTRIBUTE.CREATOR is '´´½¨Õß'; comment on column PLATTRIBUTE.CREATETIME is '´´½¨Ê±¼ä'; comment on column PLATTRIBUTE.MODIFIER is 'ÐÞ¸ÄÕß'; comment on column PLATTRIBUTE.MODIFYTIME is 'ÐÞ¸Äʱ¼ä'; comment on column PLATTRIBUTE.CONTENT is 'ÄÚÈÝ'; -- Create/Recreate primary, unique and foreign key constraints alter table PLATTRIBUTE add constraint PK_ATTRIBUTE primary key (OID); alter table PLATTRIBUTE add constraint IDX_ATTRIBUTE_NAME unique (NAME); -- ×´Ìå³Ø create table PLSTATEPOOL ( OID VARCHAR2(64) not null, NAME VARCHAR2(128) not null, LABEL VARCHAR2(256), DESCRIPTION VARCHAR2(256), TS TIMESTAMP(6), CREATOR VARCHAR2(64), CREATETIME TIMESTAMP(6), MODIFIER VARCHAR2(64), MODIFYTIME TIMESTAMP(6), CONTENT SYS.XMLTYPE ); -- Add comments to the table comment on table PLSTATEPOOL is '×´Ìå³Ø'; -- Add comments to the columns comment on column PLSTATEPOOL.NAME is 'Ãû³Æ'; comment on column PLSTATEPOOL.LABEL is '±êʾ'; comment on column PLSTATEPOOL.DESCRIPTION is 'ÃèÊö'; comment on column PLSTATEPOOL.TS is 'TSËø'; comment on column PLSTATEPOOL.CREATOR is '´´½¨ÈË'; comment on column PLSTATEPOOL.CREATETIME is '´´½¨Ê±¼ä'; comment on column PLSTATEPOOL.MODIFIER is 'ÐÞ¸ÄÈË'; comment on column PLSTATEPOOL.MODIFYTIME is 'ÐÞ¸Äʱ¼ä'; comment on column PLSTATEPOOL.CONTENT is 'ÄÚÈÝ'; -- Create/Recreate primary, unique and foreign key constraints alter table PLSTATEPOOL add constraint PK_STATEPOOL primary key (OID); alter table PLSTATEPOOL add constraint IDX_STATEPOOL_NAME unique (NAME); -- ÉúÃüÖÜÆÚ create table PLLIFECYCLE ( OID VARCHAR2(64) not null, NAME VARCHAR2(128) not null, LABEL VARCHAR2(256), DESCRIPTION VARCHAR2(256), TS TIMESTAMP(6), CREATOR VARCHAR2(64), CREATETIME TIMESTAMP(6), MODIFIER VARCHAR2(64), MODIFYTIME TIMESTAMP(6), CONTENT SYS.XMLTYPE ); -- Add comments to the table comment on table PLLIFECYCLE is 'ÉúÃüÖÜÆÚ'; -- Add comments to the columns comment on column PLLIFECYCLE.NAME is 'Ãû³Æ'; comment on column PLLIFECYCLE.LABEL is '±êʾ'; comment on column PLLIFECYCLE.DESCRIPTION is 'ÃèÊö'; comment on column PLLIFECYCLE.TS is 'TSËø'; comment on column PLLIFECYCLE.CREATOR is '´´½¨Õß'; comment on column PLLIFECYCLE.CREATETIME is '´´½¨Ê±¼ä'; comment on column PLLIFECYCLE.MODIFIER is 'ÐÞ¸ÄÕß'; comment on column PLLIFECYCLE.MODIFYTIME is 'ÐÞ¸Äʱ¼ä'; comment on column PLLIFECYCLE.CONTENT is 'ÄÚÈÝ'; -- Create/Recreate primary, unique and foreign key constraints alter table PLLIFECYCLE add constraint PK_LIFECYCLE primary key (OID); alter table PLLIFECYCLE add constraint IDX_LIFECYCLE_NAME unique (NAME); -- ö¾Ù create table PLENUM ( OID VARCHAR2(64) not null, NAME VARCHAR2(128) not null, LABEL VARCHAR2(256), TS TIMESTAMP(6), CREATOR VARCHAR2(64), CREATETIME TIMESTAMP(6), MODIFIER VARCHAR2(64), MODIFYTIME TIMESTAMP(6), CONTENT SYS.XMLTYPE ); -- Add comments to the table comment on table PLENUM is 'ö¾Ù'; -- Add comments to the columns comment on column PLENUM.NAME is 'Ãû³Æ'; comment on column PLENUM.LABEL is '±êʾ'; comment on column PLENUM.TS is 'TSËø'; comment on column PLENUM.CREATOR is '´´½¨Õß'; comment on column PLENUM.CREATETIME is '´´½¨Ê±¼ä'; comment on column PLENUM.MODIFIER is 'ÐÞ¸ÄÕß'; comment on column PLENUM.MODIFYTIME is 'ÐÞ¸Äʱ¼ä'; comment on column PLENUM.CONTENT is 'ÄÚÈÝ'; -- Create/Recreate primary, unique and foreign key constraints alter table PLENUM add constraint PK_ENUM primary key (OID); alter table PLENUM add constraint IDX_ENUM_NAME unique (NAME); -- °æ±¾¹æÔò create table PLVERSIONRULE ( OID VARCHAR2(64) not null, NAME VARCHAR2(128) not null, LABEL VARCHAR2(256), DESCRIPTION VARCHAR2(256), TS TIMESTAMP(6), CREATOR VARCHAR2(64), CREATETIME TIMESTAMP(6), MODIFIER VARCHAR2(64), MODIFYTIME TIMESTAMP(6), CONTENT SYS.XMLTYPE ); -- Add comments to the table comment on table PLVERSIONRULE is '°æ±¾¹æÔò'; -- Add comments to the columns comment on column PLVERSIONRULE.NAME is 'Ãû³Æ'; comment on column PLVERSIONRULE.LABEL is '±êʾ'; comment on column PLVERSIONRULE.DESCRIPTION is 'ÃèÊö'; comment on column PLVERSIONRULE.TS is 'TSËø'; comment on column PLVERSIONRULE.CREATOR is '´´½¨Õß'; comment on column PLVERSIONRULE.CREATETIME is '´´½¨Ê±¼ä'; comment on column PLVERSIONRULE.MODIFIER is 'ÐÞ¸ÄÕß'; comment on column PLVERSIONRULE.MODIFYTIME is 'ÐÞ¸Äʱ¼ä'; comment on column PLVERSIONRULE.CONTENT is 'ÄÚÈÝ'; -- Create/Recreate primary, unique and foreign key constraints alter table PLVERSIONRULE add constraint PK_VERSIONRULE primary key (OID); alter table PLVERSIONRULE add constraint IDX_VERSIONRULE_NAME unique (NAME);