inidata.txt

北京铁路局住房分配系统,数据库为MSSql2000,依次执行crebas4.sql

delete from fptjb
insert fptjb(bh,mc,bz) values('01','分局分配','')
insert fptjb(bh,mc,bz) values('02','路局分配','')
insert fptjb(bh,mc,bz) values('03','其他分配','')
insert fptjb(bh,mc,bz) values('04','拆迁安置','')
insert fptjb(bh,mc,bz) values('05','出售数量','')
insert fptjb(bh,mc,bz) values('06','其他用途','')
insert fptjb(bh,mc,bz) values('88','总计','')
delete from fwytb
insert fwytb(bh,mc,bz) values('01','职工分配','')
insert fwytb(bh,mc,bz) values('02','奖励分配','')
insert fwytb(bh,mc,bz) values('03','拆迁分配','')
insert fwytb(bh,mc,bz) values('04','领导干部','')
insert fwytb(bh,mc,bz) values('05','社会用房','')
insert fwytb(bh,mc,bz) values('06','公用房屋','')
insert fwytb(bh,mc,bz) values('07','机动房屋','')
insert fwytb(bh,mc,bz) values('08','其他用房','')
insert fwytb(bh,mc,bz) values('99','总计','')
delete from fwhxb
insert fwhxb(bh,mc,bz) values('01','一居室','')
insert fwhxb(bh,mc,bz) values('02','二居室','')
insert fwhxb(bh,mc,bz) values('03','三居室','')
insert fwhxb(bh,mc,bz) values('04','复式二居室','')
insert fwhxb(bh,mc,bz) values('05','复式三居室','')
delete from fwcxb
insert fwcxb(bh,mc,bz) values('01','东向','')
insert fwcxb(bh,mc,bz) values('02','南向','')
insert fwcxb(bh,mc,bz) values('03','西向','')
insert fwcxb(bh,mc,bz) values('04','北向','')
delete from fpzb
Insert fpzb(FPTJBH,FPCS,YJSL,EJSL,SJSL,FSEJ,FSSJ,QT,HJ) 
      Values ('01','1',0,0,0,0,0,0,0)
Insert fpzb(FPTJBH,FPCS,YJSL,EJSL,SJSL,FSEJ,FSSJ,QT,HJ) 
      Values ('02','1',0,0,0,0,0,0,0)
Insert fpzb(FPTJBH,FPCS,YJSL,EJSL,SJSL,FSEJ,FSSJ,QT,HJ) 
      Values ('03','1',0,0,0,0,0,0,0)
Insert fpzb(FPTJBH,FPCS,YJSL,EJSL,SJSL,FSEJ,FSSJ,QT,HJ) 
      Values ('04','1',0,0,0,0,0,0,0)
Insert fpzb(FPTJBH,FPCS,YJSL,EJSL,SJSL,FSEJ,FSSJ,QT,HJ) 
      Values ('05','1',0,0,0,0,0,0,0)
Insert fpzb(FPTJBH,FPCS,YJSL,EJSL,SJSL,FSEJ,FSSJ,QT,HJ) 
      Values ('06','1',0,0,0,0,0,0,0)
Insert fpzb(FPTJBH,FPCS,YJSL,EJSL,SJSL,FSEJ,FSSJ,QT,HJ) 
      Values ('88','1',0,0,0,0,0,0,0)
delete from fjfpb
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','01',0,0,0,0,0,0,0)
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','02',0,0,0,0,0,0,0)
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','03',0,0,0,0,0,0,0)
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','04',0,0,0,0,0,0,0)
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','05',0,0,0,0,0,0,0)
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','06',0,0,0,0,0,0,0)
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','07',0,0,0,0,0,0,0)
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','08',0,0,0,0,0,0,0)
insert fjfpb(fptjbh,ytbh,yjsl,ejsl,sjsl,fsej,fssj,qt,hj)
  values('01','99',0,0,0,0,0,0,0)
insert userid 
  values('001','system','pass','11111111111111111111',1)