sql20070327tlf01.sql

BBS功能模块

delete from HtmlLabelIndex where id= 19665
GO
delete from HtmlLabelInfo where indexid= 19665
GO
INSERT INTO HtmlLabelIndex values(19665,'Interface Setting')
GO
INSERT INTO HtmlLabelInfo VALUES(19665,'短信接口',7)
GO
INSERT INTO HtmlLabelInfo VALUES(19665,'Interface Setting',8)
GO
EXECUTE MMConfig_U_ByInfoInsert 11,31
GO
EXECUTE MMInfo_Insert 530,19665,'短信接口','/interface/Interface.jsp','mainFrame',11,1,31,0,'',0,'',0,'','',0,'','',9
GO
create table sms_config ( sendurl varchar(200),
                          spnumber varchar(50),
                          password varchar(50)
                          )
GO
insert into sms_config(sendurl) values('http://218.31.157.18:9090/APUserSMS.jws?wsdl')
GO