/*-------------------------------------------
by :bansm
date:2009-5-19 17:59
---------------------------------------------------------*/
/*sql语句说明--------------------------------*/
/*SQL> create table a(a1 int,a2 int,a3 int, a4 int);
表已创建。
为表添加主键
SQL> alter table a add constraint pk_a primary key (a1,a2);
alter table add OADOCTYPE constraint pk_DOCTYPESPELL primary key (DOCTYPESPELL);
表已更改。
为表添加外键
SQL> create table b (a1 int,a2 int,a3 int, a4 int,
2 constraint fk_b foreign key(a1,a2) references a(a1,a2));
表已创建。
SQL>
为表添加注释
SQL>comment on table OADOCTYPE
is '系统';
为表的字段添加注释
SQL> comment on column OADOCTYPE.DOCTYPESPELL is '公文简写';
SQL> alter table OADOCTYPE add constraint pk_DOCTYPESPELL primary key (DOCTYPESPELL);
*/
/*修改表*/
/*增加公文类型表 */
/*------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
/*修改:OAARCHIVESINFO — OA公文信息表*/
alter table OAARCHIVESINFO add(
GDFLAG INTEGER,
READDEP VARCHAR2(100),
READPER VARCHAR2(100),
COAPP VARCHAR2(200),
NOWPER VARCHAR2(50),
AGOPER VARCHAR2(50),
QFFLAG INTEGER,
DOCTYPESPELL VARCHAR2(50),
QFPER VARCHAR2(50)
);
comment table OAARCHIVESINFO is 'OA公文信息表';
comment on column OAARCHIVESINFO.ARCHIVESID is '公文ID';
comment on column OAARCHIVESINFO.DOCTYPESPELL is '公文类型简写';
comment on column OAARCHIVESINFO.GDFLAG is '归档标志';
comment on column OAARCHIVESINFO.READDEP is '阅读权限部门';
comment on column OAARCHIVESINFO.READPER is '阅读权限部人';
comment on column OAARCHIVESINFO.COAPP is '公文流程记录人';
comment on column OAARCHIVESINFO.NOWPER is '当前批阅人';
comment on column OAARCHIVESINFO.AGOPER is '上一批阅人';
comment on column OAARCHIVESINFO.QFFLAG is '签发标志';
comment on column OAARCHIVESINFO.QFPER is '签发人';
alter table OAARCHIVESINFO add constraint PK_OAARCHIVESINFO primary key (ARCHIVESID);
alter table OAARCHIVESINFO
add constraint FK_OAARCHIV_REFERENCE_OADOCTYP foreign key (DOCTYPESPELL)
references OADOCTYPE (DOCTYPESPELL);