labmis_usr.sql

十分完善地实现了实验室管理系统

create table dbo.labmis_usr
       (usr nvarchar(10) not null,
       pws nvarchar(10) not null) ;
 
alter table dbo.labmis_usr
       add constraint usr primary key  nonclustered
       (usr) ;
 
insert into dbo.pbcattbl
        (pbt_tnam, pbt_tid, pbt_ownr,
       pbd_fhgt, pbd_fwgt, pbd_fitl, pbd_funl, pbd_fchr, pbd_fptc, pbd_ffce,
       pbh_fhgt, pbh_fwgt, pbh_fitl, pbh_funl, pbh_fchr, pbh_fptc, pbh_ffce,
       pbl_fhgt, pbl_fwgt, pbl_fitl, pbl_funl, pbl_fchr, pbl_fptc, pbl_ffce,
       pbt_cmnt)
       values  ( 'labmis_usr',
       object_id('dbo.labmis_usr'),
        'dbo',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
        -12,  400,  'N',  'N',  0,  34,
        'Arial',
       ' ') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_usr',
        object_id('dbo.labmis_usr'),
        'dbo',  'usr', 1,
        'Usr:', 0 ,
        'Usr', 0,
       23 , '',
       0 , 77 , 293 ,
        '', 'N',
        '',
        ' ',
        '', '') ;
 
insert into dbo.pbcatcol
       (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam,
       pbc_cid, pbc_labl, pbc_lpos, pbc_hdr,
       pbc_hpos, pbc_jtfy, pbc_mask, pbc_case,
       pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap,
       pbc_init, pbc_cmnt, pbc_edit, pbc_tag)
        values  ( 'labmis_usr',
        object_id('dbo.labmis_usr'),
        'dbo',  'pws', 2,
        'Pws:', 0 ,
        'Pws', 0,
       23 , '',
       0 , 77 , 293 ,
        '', 'N',
        '',
        ' ',
        '', '') ;