fix协议封装挑战-数据库脚本

declare @tname varchar(8000)set @tname=''select @tname=@tname+Name+','from sysobjects where xtype='U'select @tname='drop table '+ left(@tname,len(@tname)-1)exec(@tname)create table TabRole(   RId int primary key identity(1,1),   RName varchar(25),   RDesc varchar(200) ); insert into TabRole(rname,rdesc)values('会员管理','会员管理');insert into TabRole(rname,rdesc)values('会员组管理','会员组管理');insert into TabRole(rname,rdesc)values('交易会员管理','交易会员管理');insert into TabRole(rname,rdesc)values('客户主任管理','客户主任管理');insert into TabRole(rname,rdesc)values('出入金管理','出入金管理');insert into TabRole(rname,rdesc)values('银行出入金管理','银行出入金管理');insert into TabRole(rname,rdesc)values('资金明细管理','资金明细管理');insert into TabRole(rname,rdesc)values('在线会员管理','在线会员管理');insert into TabRole(rname,rdesc)values('交易管理','交易管理');insert into TabRole(rname,rdesc)values('订单管理','订单管理');insert into TabRole(rname,rdesc)values('会员交易','会员交易');insert into TabRole(rname,rdesc)values('订单统计','订单统计');insert into TabRole(rname,rdesc)values('市场管理','市场管理');insert into TabRole(rname,rdesc)values('交易市场管理','交易市场管理');insert into TabRole(rname,rdesc)values('交易品种管理','交易品种管理');insert into TabRole(rname,rdesc)values('交易时间管理','交易时间管理');insert into TabRole(rname,rdesc)values('公告管理','公告管理');insert into TabRole(rname,rdesc)values('资源管理','资源管理');insert into TabRole(rname,rdesc)values('银行类型管理','银行类型管理');insert into TabRole(rname,rdesc)values('证件类型管理','证件类型管理');insert into TabRole(rname,rdesc)values('系统管理','系统管理');insert into TabRole(rname,rdesc)values('管理员管理','管理员管理');insert into TabRole(rname,rdesc)values('url权限配置','url权限配置');insert into TabRole(rname,rdesc)values('登入日志管理','登入日志管理');insert into TabRole(rname,rdesc)values('操作日志管理','操作日志管理');insert into TabRole(rname,rdesc)values('开销户日志','开销户日志');create table TabMenu( Mid int primary key identity(1,1), Mparent int, Mname varchar(255), Mlink varchar(255) );   create table tabMenuRole(  MRid int primary key identity(1,1),  mid int,  rid int );   insert into TabMenu(Mname,Mlink)values('会员管理','');  insert into TabMenu(Mname,Mlink,Mparent)values('会员组管理','admin/memberGroup/list',(select Mid from Tabmenu where Mname='会员管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('交易会员管理','admin/member/list',(select Mid from Tabmenu where Mname='会员管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('客户主任管理','admin/customer/list',(select Mid from Tabmenu where Mname='会员管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('出入金管理','admin/paiement/list',(select Mid from Tabmenu where Mname='会员管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('银行出入金管理','admin/paiementBank/list',(select Mid from Tabmenu where Mname='会员管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('资金明细管理','admin/fundLog/list',(select Mid from Tabmenu where Mname='会员管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('在线会员管理','admin/onlineMember/list',(select Mid from Tabmenu where Mname='会员管理'));  insert into TabMenu(Mname,Mlink)values('交易管理','');  insert into TabMenu(Mname,Mlink,Mparent)values('订单管理','admin/order/list',(select Mid from Tabmenu where Mname='交易管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('会员交易','admin/transaction/list',(select Mid from Tabmenu where Mname='交易管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('订单统计','admin/statistics/list',(select Mid from Tabmenu where Mname='交易管理'));  insert into TabMenu(Mname,Mlink)values('市场管理','');  insert into TabMenu(Mname,Mlink,Mparent)values('交易市场管理','admin/market/list',(select Mid from Tabmenu where Mname='市场管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('交易品种管理','admin/product/list',(select Mid from Tabmenu where Mname='市场管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('交易时间管理','admin/transTime/list',(select Mid from Tabmenu where Mname='市场管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('公告管理','admin/announce/list',(select Mid from Tabmenu where Mname='市场管理'));   insert into TabMenu(Mname,Mlink)values('资源管理','');  insert into TabMenu(Mname,Mlink,Mparent)values('银行类型管理','admin/bankType/list',(select Mid from Tabmenu where Mname='资源管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('证件类型管理','admin/certType/list',(select Mid from Tabmenu where Mname='资源管理'));  insert into TabMenu(Mname,Mlink)values('系统管理','');  insert into TabMenu(Mname,Mlink,Mparent)values('管理员管理','admin/admin/list',(select Mid from Tabmenu where Mname='系统管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('url权限配置','admin/resource/list',(select Mid from Tabmenu where Mname='系统管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('登入日志管理','admin/loginLog/list',(select Mid from Tabmenu where Mname='系统管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('操作日志管理','admin/opLog/list',(select Mid from Tabmenu where Mname='系统管理'));  insert into TabMenu(Mname,Mlink,Mparent)values('开销户日志','admin/accountHistory/list',(select Mid from Tabmenu where Mname='系统管理'));   insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='会员管理'),(select rid from tabrole where rname='会员管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='会员组管理'),(select rid from tabrole where rname='会员组管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='交易会员管理'),(select rid from tabrole where rname='交易会员管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='客户主任管理'),(select rid from tabrole where rname='客户主任管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='出入金管理'),(select rid from tabrole where rname='出入金管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='银行出入金管理'),(select rid from tabrole where rname='银行出入金管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='资金明细管理'),(select rid from tabrole where rname='资金明细管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='在线会员管理'),(select rid from tabrole where rname='在线会员管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='交易管理'),(select rid from tabrole where rname='交易管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='订单管理'),(select rid from tabrole where rname='订单管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='会员交易'),(select rid from tabrole where rname='会员交易')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='订单统计'),(select rid from tabrole where rname='订单统计')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='市场管理'),(select rid from tabrole where rname='市场管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='交易市场管理'),(select rid from tabrole where rname='交易市场管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='交易品种管理'),(select rid from tabrole where rname='交易品种管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='交易时间管理'),(select rid from tabrole where rname='交易时间管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='公告管理'),(select rid from tabrole where rname='公告管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='资源管理'),(select rid from tabrole where rname='资源管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='银行类型管理'),(select rid from tabrole where rname='银行类型管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='证件类型管理'),(select rid from tabrole where rname='证件类型管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='系统管理'),(select rid from tabrole where rname='系统管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='管理员管理'),(select rid from tabrole where rname='管理员管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='url权限配置'),(select rid from tabrole where rname='url权限配置')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='登入日志管理'),(select rid from tabrole where rname='登入日志管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='操作日志管理'),(select rid from tabrole where rname='操作日志管理')); insert into tabMenuRole(mid,rid)values((select Mid from Tabmenu where Mname='开销户日志'),(select rid from tabrole where rname='开销户日志'));  create table TabAdmin( Aid int primary key identity(1,1), ALgid varchar(25), Apwd varchar(25), AEnable bit, AName varchar(30), AMobile varchar(12), ARegTime datetime default Getdate(), AoverTime datetime, APurview varchar(200), ARemark varchar(200) ); insert into TabAdmin(algid,apwd,AEnable)values('admin','123456',1);  create table TabAdminRole( arid int primary key identity(1,1),  aid int,  rid int  );  insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='会员管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='会员组管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='交易会员管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='客户主任管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='出入金管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='资金明细管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='在线会员管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='交易管理')); insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='订单管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='会员交易'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='订单统计'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='市场管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='交易市场管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='交易品种管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='交易时间管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='公告管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='资源管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='银行类型管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='证件类型管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='管理员管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='url权限配置'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='登入日志管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='操作日志管理'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='开销户日志'));insert into tabadminrole(aid,rid)values((select aid from TabAdmin where algid='admin'),(select rid from tabrole where rname='系统管理'));  create table tabResource(RId int primary key identity(1,1),RUrl varchar(200),Rsort int,Rfilter varchar(200));insert into tabResource(rurl,rsort,rfilter)values('/admins/admin/**',1,'roles[管理员管理]');insert into tabResource(rurl,rsort,rfilter)values('/admins/announce/**',2,'roles[公告管理]');insert into tabResource(rurl,rsort,rfilter)values('/admins/log/**',3,'roles[日志管理]');insert into tabResource(rurl,rsort,rfilter)values('/admins/member/**',4,'roles[会员管理]');insert into tabResource(rurl,rsort,rfilter)values('/admins/memberGroup/**',5,'roles[会员组管理]');insert into tabResource(rurl,rsort,rfilter)values('/admins/resource/**',6,'roles[资源管理]');insert into tabResource(rurl,rsort,rfilter)values('/admins/**',7,'authc');--系统公告表create table TabAnnounce (AIdInt primary key identity(1,1),--系统公告数据库唯一标识主键ATitleVarchar(100),--公告标题AContent Varchar(8000),--公告内容AAlertint,--0.表示系统直接弹出公告  1.表示用户登录后查看公告ABeginTimeDateTime,--开始时间AEndTimeDateTime,--结束时间AUpdateTimeDateTime,--修改时间APromulgatorint,--发布者为登录发布用户名ADestTypeInt,--0.全体会员  1.管理员  2.对应组员，3对应会员AMemberId int);    --公告对应组create table NoticeOfGroup(NId int primary key identity(1,1), --标识主键NDestId int,--组IDNAnnounceId int--公告ID); --用户信息表 CREATE TABLE TabUser ([UId] int primary key identity(1,1) ,[ULgId] varchar(25) NULL  ,[UPwd] varchar(60) NULL ,[UName] varchar(10) NULL ,[USex] char(1) NULL DEFAULT ((0)) ,[UStatus] int NULL DEFAULT ((0)) ,[UGroup] int NULL ,UBalance Decimal(18,2),UAmtFrozen Decimal(18,2),UCertType varchar(2),UCertId varchar(30),UBirthD dateTime,UBkAcctId int,UcttId int,UType char(1),UOverTime datetime);insert into TabUser(ULgId,UPwd,UStatus)values('hxp','111111',1);insert into TabUser(ULgId,UPwd,UStatus,UType)values('test','111111',1,'G');insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='会员管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='会员组管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='交易会员管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='客户主任管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='出入金管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='资金明细管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='在线会员管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='交易管理')); insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='订单管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='会员交易'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='市场管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='交易市场管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='交易品种管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='交易时间管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='公告管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='资源管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='银行类型管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='证件类型管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='管理员管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='url权限配置'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='登入日志管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='操作日志管理'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='开销户日志'));insert into TabUserRole(uid,rid)values((select uid from TabUser where ulgid='test'),(select rid from tabrole where rname='系统管理'));create table TabUserRole(URId int primary key identity(1,1) ,uid int,rid int);--用户组信息表CREATE TABLE TabGroup ([GId] int NOT NULL primary key identity(1,1),[GGrade] int NULL ,[GName] varchar(60) NULL ,GDesc varchar(200),GOwnerUId int,GRegTime datetime DEFAULT Getdate(),GBaseGId int);create table tabOnlineUser(OUId int  primary key identity(1,1),OUUId int,OULgId varchar(25),OULoginT datetime DEFAULT Getdate(),OUIP varchar(18));create table TabContactInfo(CIId int  primary key identity(1,1),CIUId int,CIName varchar(30),CIMobile varchar(12),CITelNo varchar(20),CIEmail varchar(30),CIPostCode varchar(12),CIAddress varchar(100),CIOther varchar(100));create table TabAcctADHis(AHId int  primary key identity(1,1),AHUId int,AHLgId varchar(30),AHOPType char(1),AHOPTime datetime default GetDate(),AHOperatorType char(1),AHOperator varchar(30),AHOPIP varchar(18));create table TabBankAcct(BAId int  primary key identity(1,1),BAUId int,BASitNo varchar(30),BAName varchar(30),BABkType varchar(10),BAAcctNo varchar(26),BABkAddr varchar(100),BABkCountry varchar(10) default 'CHN',BABkProvince varchar(10),BABkCity varchar(10),BABkBranchNo varchar(20),BAOverTime datetime);create table TabBankType(BTId  int  primary key identity(1,1),BTCode varchar(10),BTName varchar(30),BTEnable bit default '1');insert into TabBankType(BTCode,BTName,BTEnable)values('BOC','中国银行',1);insert into TabBankType(BTCode,BTName,BTEnable)values('CCB','建设银行',1);insert into TabBankType(BTCode,BTName,BTEnable)values('ABC','农业银行',1);insert into TabBankType(BTCode,BTName,BTEnable)values('ICBC','工商银行',1);create table TabCertType(CTId int  primary key identity(1,1),CTCode varchar(2),CTName varchar(30),CTEnable bit default '1');insert into TabCertType(CTCode,CTName,CTEnable)values('10','身份证',1);insert into TabCertType(CTCode,CTName,CTEnable)values('11','护照',1);insert into TabCertType(CTCode,CTName,CTEnable)values('12','军官证',1);insert into TabCertType(CTCode,CTName,CTEnable)values('13','士兵证',1);insert into TabCertType(CTCode,CTName,CTEnable)values('14','回乡证',1);insert into TabCertType(CTCode,CTName,CTEnable)values('15','户口本',1);insert into TabCertType(CTCode,CTName,CTEnable)values('16','营业执照',1);insert into TabCertType(CTCode,CTName,CTEnable)values('17','企业法人代码证书代码',1);insert into TabCertType(CTCode,CTName,CTEnable)values('20','其他',1);create table TabHPaiement(PId int  primary key identity(1,1),PmLgId varchar(30),PmType char(1),PmAmt Decimal(18,2),PmHSrc char(1),PmHOperator varchar(30),PmRemark varchar(100),PmRemainBal Decimal(18,2),PmFSeqNo varchar(30),PmBkSeqNo varchar(30),PmTime datetime default Getdate());create table TabFundLog(FLId int  primary key identity(1,1),FLUId int,FLAmount Decimal(18,2),FLTime datetime default Getdate(),FLBalance Decimal(18,2),FLpType varchar(6),FLaType varchar(10),FLIP varchar(20),FLLog varchar(200)); create table TabLoginLog(  LLId int  primary key identity(1,1),  LLType char(1),  LLLgId varchar(30),  LLLog varchar(200),  LLIP varchar(18),  LLTime datetime default Getdate(),  LLStatus char(1)); create table TabSysOPLog(SLId int  primary key identity(1,1),SLActType char(1),SLLgId varchar(30),SLFunId varchar(8),SLData varchar(100),SLLog varchar(200),SLTime datetime default Getdate(),SLIP varchar(18));create table TabOrder(OId int primary key identity(1,1),Mid int,OState varchar(25),OTransType varchar(20),PId int,OType int,OPrice float,OQuantity int,OEnterDate  datetime default Getdate(),OValidDate datetime,OWaitTrans int,OAlreadyTrans int,OSendCondition int,UId int,OApplyType varchar(20),OApplyId int,oServerOrderId varchar(30),OLastPrice float, #上一次价格OLastAmt int,#上一次数量OLastState varchar(1) #上一次状态);insert into taborder(ocode,ostate,otranstype,oprice,oquantity)values(34088,'未成交','buy',10.2,50);create table TabOrderUpdate(OUId int primary key identity(1,1),OId int,OUPrice float,OUQuantity int,OUTime datetime default Getdate());create table TabDealRecord(DRId int primary key identity(1,1),OId int,DRPrice float,DRQuantity int,DRTime datetime default Getdate());create table TabProduct(PId int primary key identity(1,1),Mid int,PCode varchar(25),PName varchar(100),PQuantity int,PFormerPrice float,PFormerSum float,PLUTime datetime);insert into TabProduct(mid,pcode,pname,pquantity,pformerprice,pformersum,plutime)values(1,'111','222',11,11.11,11.1,Getdate()); create table TabMarket(MId int primary key identity(1,1),MCode varchar(25),MName varchar(100));create table TabSpecTransTime(STTId int primary key identity(1,1),STTReason varchar(100),STTStart datetime,STTEnd datetime,STTType int);insert into TabMarket(MCode,MName)values('cs','创硕');create table TabSendCondition(SCId  int primary key identity(1,1),SCType int,SCTriggerPrice float,SCEarnStop float,SCLossStop float);create table TabPriceTip(PTId int primary key identity(1,1),pid int ,PTPrice float,PTInputTime datetime,PTType int,PTTipTime datetime);create table TabRemainMsg(   RMId int primary key identity(1,1),   RMMsg blob );create table TabStockHold(SHId int primary key identity(1,1),PId int,SHAmt int,UId  int);create table TabFreezeRecord(FRId int primary key identity(1,1),UId int,OId int,FRAmt float,FRDate datetime default Getdate(),FRDesc varchar(200));