/*
================================================================================
档案代号: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;