up1.sql

这是用PB6开发的一个POS管理系统

create table OperatorRights
(
    Operator           TSTAFF                not null,
    Name               Varchar(30)           not null,
    PName              varchar(30)           not null,
    IsOperator         char(1)               not null
        default '1',
    ModifyDate         TDATE                 not null
        default getdate(),
    constraint PK_OPERATORRIGHTS primary key (Operator, Name)
)
go

/* ============================================================ */
/*   Table: MultiGoods                                          */
/* ============================================================ */
create table MultiGoods
(
    GoodsNo            TGoods                not null,
    BarCode            TGoods                not null,
    UseFlag            char(1)               not null
        default '1',
    ModifyDate         TDate                 not null
        default getdate(),
    constraint PK_MULTIGOODS primary key (GoodsNo, BarCode)
)
go

/* ============================================================ */
/*   Table: Report                                              */
/* ============================================================ */
create table Report
(
    name               varchar(40)           not null,
    reportno	       varchar(8)            not null,
    dispname           varchar(50)           not null,
    printdw            varchar(50)           not null,
    qwindow            varchar(50)           null    ,
    pblname            varchar(30)           null    ,
    constraint PK_REPORT primary key (name)
)
go

/* ============================================================ */
/*   Table: ProcessDayEnd                                       */
/* ============================================================ */
create table ProcessDayEnd
(
    seqno                  int  Primary key not null,
    ProcessSql         varchar(300)          null    ,
    ProcessFlag        char(1)               null    
        default '1',
    Remark             varchar(100)          null    
)
go

insert OperatorRights(    
    Operator,
    Name,
    PName)
select '9999',name,pname from funcs