晓风彩票程序源码 旗舰版彩票销售网站模板

if not exists(select 1 from syscolumns where name = 'BuyOperator_id' and id = object_id('Scheme')) alter table Scheme add [BuyOperator_id] int GO if not exists(select 1 from syscolumns where name = 'WinOperator_id' and id = object_id('Scheme')) alter table Scheme add [WinOperator_id] int GO if not exists(select 1 from syscolumns where name = 'AcceptOperator_id' and id = object_id('UserDistill')) alter table UserDistill add [AcceptOperator_id] int GO if not exists(select 1 from syscolumns where name = 'PayOperator_id' and id = object_id('UsersDetail')) alter table UsersDetail add [PayOperator_id] int GO if not exists(select 1 from syscolumns where name = 'LotteryBuyRightsList' and id = object_id('Users')) alter table Users add [LotteryBuyRightsList] varchar(1000) default '[-1]' GO if not exists(select 1 from syscolumns where name = 'IsOpen' and id = object_id('Isuse')) alter table Isuse add [IsOpen] bit default 0 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_BuildLotteryNumber_SSQ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[P_BuildLotteryNumber_SSQ] GO declare @VersionNumber varchar(100) select @VersionNumber = [Value] from [Options] where [Key] = 'DatabaseVersionNumber' if @VersionNumber < '4.01004' begin update Isuse set IsOpen = 0 where ltrim(rtrim(WinLotteryNumber)) = '' update Isuse set IsOpen = 1 where ltrim(rtrim(WinLotteryNumber)) <> '' update [Lottery] set Type_id = 8 where [id] = 6 update [Lottery] set IntervalType = '天' where [id] = 26 update [Lottery] set WinLotteryExemple = '01 02 03 04 05 06 + 01 02 03 04' where [id] = 5 update [Users] set LotteryBuyRightsList = '[-1]' where LotteryBuyRightsList is null or LotteryBuyRightsList = '' update Scheme set BuyOperator_id = 1 where BuyOperator_id is null and LotteryBuyed = 1 update Scheme set WinOperator_id = 1 where WinOperator_id is null and not WinDescription is null update UserDistill set AcceptOperator_id = 1 where AcceptOperator_id is null update UsersDetail set PayOperator_id = 1 where PayOperator_id is null end GO declare @VersionNumber varchar(100) select @VersionNumber = [Value] from [Options] where [Key] = 'DatabaseVersionNumber' if @VersionNumber < '4.01006' begin if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WaitSendEmail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) CREATE TABLE [dbo].[WaitSendEmail] ( [id] [bigint] IDENTITY (1, 1) NOT NULL , [MailTo] [image] NULL , [Subject] [image] NULL , [Body] [image] NULL , [isSended] [bit] NULL default 0 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] end GO declare @VersionNumber varchar(100) select @VersionNumber = [Value] from [Options] where [Key] = 'DatabaseVersionNumber' if @VersionNumber < '4.01007' begin if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UsersPayOutDetail_99Bill]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) CREATE TABLE [dbo].[UsersPayOutDetail_99Bill] ( [id] [bigint] IDENTITY (1, 1) NOT NULL , [Distill_id] [int] NULL , [DealCharge] [money] NULL default 0 , [DebitCharge] [money] NULL default 0 , [CreditCharge] [money] NULL default 0 , [DealID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL default '' , [ResultFlag] [bit] NULL default 0 , [FailureCause] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL default '' ) ON [PRIMARY] end GO declare @VersionNumber varchar(100) select @VersionNumber = [Value] from [Options] where [Key] = 'DatabaseVersionNumber' if @VersionNumber < '4.01007' begin CREATE TABLE #TempOptions ( [id] [int] NULL , [Key] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [ValueImage] [image] NULL , [Value] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] insert into #TempOptions select * from [dbo].[Options] order by [id] drop table [dbo].[Options] CREATE TABLE [dbo].[Options] ( [id] [int] NULL , [Key] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [ValueImage] [image] NULL , [Value] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] insert into [dbo].[Options] ([id], [Key], [ValueImage], [Value]) select * from #TempOptions order by [id] declare @OldOptions_RowCount int set @OldOptions_RowCount = @@ROWCOUNT drop table #TempOptions if @OldOptions_RowCount = 28 begin insert into [dbo].[Options] ([id], [Key], [Value]) values (29, 'ShowTopAD', 'True') insert into [dbo].[Options] ([id], [Key], [Value]) values (30, 'TopADImage', 'TopAD.gif') insert into [dbo].[Options] ([id], [Key], [Value]) values (31, 'ShowSumBuyMoney', 'True') insert into [dbo].[Options] ([id], [Key], [Value]) values (1001, '*****发送方邮箱参数设置*********************', '**************************') insert into [dbo].[Options] ([id], [Key], [Value]) values (1002, 'EmailServer_From', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1003, 'EmailServer_EmailServer', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1004, 'EmailServer_User', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1005, 'EmailServer_Password', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1101, '*****短信ISP*********************', '**************************') insert into [dbo].[Options] ([id], [Key], [Value]) values (1102, 'ISP_HostName', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1103, 'ISP_HostPort', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1104, 'ISP_UserID', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1105, 'ISP_UserPassword', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1106, 'ISP_RegCode', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1107, 'ISP_ServiceNumber', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1201, '*****是否发送邮件选项*********************', '**************************') insert into [dbo].[Options] ([id], [Key], [Value]) values (1202, 'isRegisterSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1203, 'isRegisterAdvSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1204, 'isForgetPasswordSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1205, 'isUserEditSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1206, 'isUserEditAdvSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1207, 'isBuy_InitiateSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1208, 'isBuy_DSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1209, 'isBuy_JoinSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1210, 'isChaseSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1211, 'isChaseExecSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1212, 'isDistillSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1213, 'isDistillAcceptSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1214, 'isDistillNoAcceptSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1215, 'isQuashSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1216, 'isQuashSchemeSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1217, 'isQuashChaseSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1218, 'isQuashChaseAllSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1219, 'isWinSendEmail', '') insert into [dbo].[Options] ([id], [Key], [Value]) values (1301, '*****是否发送短信选项*********************', '**************************') inser