/* ================================================================================ 档案代号:gay_file 档案名称:系统使用语言资料表 档案目的:记录系统内现用语言 (文字) 种类资料 上游档案: 下游档案: ============.========================.========================================== */ create table gay_file ( gay01 varchar2(1) NOT NULL, /*语言别 */ gay02 varchar2(1), /*no use */ gay03 varchar2(80), /*语言名称 (以该语言本身表示) */ gay04 varchar2(1), /*鼎新语言包注记 */ gayacti varchar2(1), /*资料有效码 */ gaydate date, /*最近修改日 */ gaygrup varchar2(10), /*资料所有部门 */ gaymodu varchar2(10), /*资料修改者 */ gayuser varchar2(10) /*资料所有者 */ ); create unique index gay_pk on gay_file (gay01); alter table gay_file add constraint gay_pk primary key (gay01) enable validate; grant select on gay_file to public; grant index on gay_file to public; grant update on gay_file to public; grant delete on gay_file to public; grant insert on gay_file to public; |