📄 setup.sql

📁 cmpp源代码
💻 SQL
字号:
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'cmpp')
	DROP DATABASE [cmpp]
GO

CREATE DATABASE [cmpp]  ON (NAME = N'Cmpp_Data', FILENAME = N'c:\cmpp.mdf' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Cmpp_Log', FILENAME = N'c:\cmpp_log.ldf' , SIZE = 1, FILEGROWTH = 10%)
 COLLATE Chinese_PRC_CI_AS
GO

exec sp_dboption N'cmpp', N'autoclose', N'false'
GO

exec sp_dboption N'cmpp', N'bulkcopy', N'false'
GO

exec sp_dboption N'cmpp', N'trunc. log', N'true'
GO

exec sp_dboption N'cmpp', N'torn page detection', N'true'
GO

exec sp_dboption N'cmpp', N'read only', N'false'
GO

exec sp_dboption N'cmpp', N'dbo use', N'false'
GO

exec sp_dboption N'cmpp', N'single', N'false'
GO

exec sp_dboption N'cmpp', N'autoshrink', N'true'
GO

exec sp_dboption N'cmpp', N'ANSI null default', N'false'
GO

exec sp_dboption N'cmpp', N'recursive triggers', N'false'
GO

exec sp_dboption N'cmpp', N'ANSI nulls', N'false'
GO

exec sp_dboption N'cmpp', N'concat null yields null', N'false'
GO

exec sp_dboption N'cmpp', N'cursor close on commit', N'false'
GO

exec sp_dboption N'cmpp', N'default to local cursor', N'false'
GO

exec sp_dboption N'cmpp', N'quoted identifier', N'false'
GO

exec sp_dboption N'cmpp', N'ANSI warnings', N'false'
GO

exec sp_dboption N'cmpp', N'auto create statistics', N'true'
GO

exec sp_dboption N'cmpp', N'auto update statistics', N'true'
GO

if( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) )
	exec sp_dboption N'cmpp', N'db chaining', N'false'
GO

use [cmpp]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RECEIVED]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[RECEIVED]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RECEIVEWAIT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[RECEIVEWAIT]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[REPORTED]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[REPORTED]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[REPORTWAIT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[REPORTWAIT]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SENDED]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SENDED]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SENDWAIT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SENDWAIT]
GO

CREATE TABLE [dbo].[RECEIVED] (
	[id] [int] NOT NULL ,
	[UserCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReceiveTime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SendTime] [datetime] NULL ,
	[Message] [varchar] (140) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SmsFlag] [smallint] NOT NULL ,
	[MsgFmt] [smallint] NULL ,
	[ServiceId] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsReport] [smallint] NULL ,
	[Report_MsgID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Report_Stat] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Report_Submittime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Report_Donetime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Report_DestTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Status] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[RECEIVEWAIT] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[UserCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReceiveTime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SendTime] [datetime] NULL ,
	[Message] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Retry] [smallint] NULL ,
	[SmsFlag] [smallint] NULL ,
	[ServiceId] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgFmt] [smallint] NULL ,
	[IsReport] [smallint] NULL ,
	[Report_MsgID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Report_Stat] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Report_Submittime] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Report_Donetime] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Report_DestTermID] [varchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[REPORTED] (
	[id] [int] NOT NULL ,
	[UserCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sub] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dlvrd] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Submittime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Donetime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stat] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Err] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[REPORTWAIT] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[UserCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sub] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dlvrd] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Submittime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Donetime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stat] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Err] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SENDED] (
	[id] [int] NOT NULL ,
	[UserCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SendTime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Schedule] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Expire] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Message] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ServiceId] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NeedReport] [tinyint] NULL ,
	[Priority] [smallint] NULL ,
	[ChargeTermId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[SourceName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SourceId] [int] NULL ,
	[SmsFlag] [smallint] NULL ,
	[LastTime] [datetime] NULL ,
	[Status] [int] NULL ,
	[FMT] [int] NULL ,
	[UDHI] [int] NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgSubId] [int] NULL ,
	[MsgCount] [int] NULL ,
	[MsgIndex] [int] NULL ,
	[RepDlvrd] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[RepSubmittime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[RepDonetime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[RepStat] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SENDWAIT] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[UserCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SendTime] [datetime] NULL ,
	[Schedule] [datetime] NULL ,
	[Expire] [datetime] NULL ,
	[Message] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ServiceId] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NeedReport] [tinyint] NULL ,
	[Priority] [smallint] NULL ,
	[ChargeTermId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[SourceName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SourceId] [int] NULL ,
	[SmsFlag] [smallint] NULL ,
	[Retry] [smallint] NULL ,
	[FMT] [int] NULL ,
	[UDHI] [int] NULL ,
	[LinkID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MsgSubId] [int] NULL ,
	[MsgCount] [int] NULL ,
	[MsgIndex] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[RECEIVEWAIT] WITH NOCHECK ADD 
	CONSTRAINT [PK_receivewait] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[REPORTED] WITH NOCHECK ADD 
	CONSTRAINT [PK_REPORTED] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[REPORTWAIT] WITH NOCHECK ADD 
	CONSTRAINT [PK_reportwait] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SENDWAIT] WITH NOCHECK ADD 
	CONSTRAINT [PK_sendwait] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

 CREATE  CLUSTERED  INDEX [IX_RECEIVED_0] ON [dbo].[RECEIVED]([id]) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_SENDED_0] ON [dbo].[SENDED]([MsgId]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[RECEIVED] ADD 
	CONSTRAINT [DF_RECEIVED_SendTime] DEFAULT (getdate()) FOR [SendTime],
	CONSTRAINT [DF_received_SmsFlag] DEFAULT (0) FOR [SmsFlag],
	CONSTRAINT [PK_RECEIVED] PRIMARY KEY  NONCLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[RECEIVEWAIT] ADD 
	CONSTRAINT [DF_RECEIVEWAIT_UserCode] DEFAULT ('') FOR [UserCode],
	CONSTRAINT [DF_RECEIVEWAIT_MsgId] DEFAULT ('') FOR [MsgId],
	CONSTRAINT [DF_RECEIVEWAIT_ReceiveTime] DEFAULT (getdate()) FOR [ReceiveTime],
	CONSTRAINT [DF_RECEIVEWAIT_SendTime] DEFAULT (getdate()) FOR [SendTime],
	CONSTRAINT [DF_RECEIVEWAIT_Message] DEFAULT ('') FOR [Message],
	CONSTRAINT [DF_RECEIVEWAIT_Mobile] DEFAULT ('') FOR [Mobile],
	CONSTRAINT [DF_RECEIVEWAIT_retry] DEFAULT (0) FOR [Retry],
	CONSTRAINT [DF_receivewait_SmsFlag] DEFAULT (0) FOR [SmsFlag],
	CONSTRAINT [DF_RECEIVEWAIT_ServiceId] DEFAULT ('') FOR [ServiceId],
	CONSTRAINT [DF_RECEIVEWAIT_MsgFmt] DEFAULT (8) FOR [MsgFmt],
	CONSTRAINT [DF_RECEIVEWAIT_IsReport] DEFAULT (0) FOR [IsReport],
	CONSTRAINT [DF_RECEIVEWAIT_Report_MsgID] DEFAULT ('') FOR [Report_MsgID],
	CONSTRAINT [DF_RECEIVEWAIT_Report_Stat] DEFAULT ('') FOR [Report_Stat],
	CONSTRAINT [DF_RECEIVEWAIT_Report_Submittime] DEFAULT ('') FOR [Report_Submittime],
	CONSTRAINT [DF_RECEIVEWAIT_Report_Donetime] DEFAULT ('') FOR [Report_Donetime],
	CONSTRAINT [DF_RECEIVEWAIT_Report_DestTermID] DEFAULT ('') FOR [Report_DestTermID],
	CONSTRAINT [DF_RECEIVEWAIT_LinkID] DEFAULT ('') FOR [LinkID]
GO

ALTER TABLE [dbo].[REPORTWAIT] ADD 
	CONSTRAINT [DF_REPORTWAIT_UserCode] DEFAULT ('') FOR [UserCode],
	CONSTRAINT [DF_REPORTWAIT_MsgID] DEFAULT ('') FOR [MsgID],
	CONSTRAINT [DF_REPORTWAIT_Sub] DEFAULT ('') FOR [Sub],
	CONSTRAINT [DF_REPORTWAIT_Dlvrd] DEFAULT ('') FOR [Dlvrd],
	CONSTRAINT [DF_REPORTWAIT_Submittime] DEFAULT ('') FOR [Submittime],
	CONSTRAINT [DF_REPORTWAIT_Donetime] DEFAULT ('') FOR [Donetime],
	CONSTRAINT [DF_REPORTWAIT_Stat] DEFAULT ('') FOR [Stat],
	CONSTRAINT [DF_REPORTWAIT_Err] DEFAULT ('') FOR [Err]
GO

ALTER TABLE [dbo].[SENDED] ADD 
	CONSTRAINT [DF_SENDED_ChargeTermId] DEFAULT ('') FOR [ChargeTermId],
	CONSTRAINT [DF_sended_SmsFlag] DEFAULT (0) FOR [SmsFlag],
	CONSTRAINT [DF_SENDED_LastTime] DEFAULT (getdate()) FOR [LastTime],
	CONSTRAINT [DF_SENDED_Status] DEFAULT (0) FOR [Status],
	CONSTRAINT [DF_SENDED_LinkID] DEFAULT ('') FOR [LinkID],
	CONSTRAINT [DF_SENDED_MsgSubId] DEFAULT (1) FOR [MsgSubId],
	CONSTRAINT [DF_SENDED_MsgCount] DEFAULT (1) FOR [MsgCount],
	CONSTRAINT [DF_SENDED_MsgIndex] DEFAULT (1) FOR [MsgIndex],
	CONSTRAINT [DF_SENDED_RepDlvrd] DEFAULT ('') FOR [RepDlvrd],
	CONSTRAINT [DF_SENDED_RepSubmittime] DEFAULT ('') FOR [RepSubmittime],
	CONSTRAINT [DF_SENDED_RepDonetime] DEFAULT ('') FOR [RepDonetime],
	CONSTRAINT [DF_SENDED_RepStat] DEFAULT ('') FOR [RepStat]
GO

 CREATE  INDEX [IX_SENDED_1] ON [dbo].[SENDED]([id]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SENDWAIT] ADD 
	CONSTRAINT [DF_SENDWAIT_UserCode] DEFAULT (880011) FOR [UserCode],
	CONSTRAINT [DF_SENDWAIT_SendTime] DEFAULT (getdate()) FOR [SendTime],
	CONSTRAINT [DF_SENDWAIT_Message] DEFAULT ('hello') FOR [Message],
	CONSTRAINT [DF_SENDWAIT_Mobile] DEFAULT ('13851771993') FOR [Mobile],
	CONSTRAINT [DF_sendwait_ServiceId] DEFAULT ('Test') FOR [ServiceId],
	CONSTRAINT [DF_SENDWAIT_NeedReport] DEFAULT (1) FOR [NeedReport],
	CONSTRAINT [DF_sendwait_Priority] DEFAULT (1) FOR [Priority],
	CONSTRAINT [DF_SENDWAIT_ChargeTermId] DEFAULT ('') FOR [ChargeTermId],
	CONSTRAINT [DF_sendwait_FeeType] DEFAULT ('01') FOR [FeeType],
	CONSTRAINT [DF_sendwait_FeeCode] DEFAULT ('000000') FOR [FeeCode],
	CONSTRAINT [DF_SENDWAIT_SourceName] DEFAULT ('SPID') FOR [SourceName],
	CONSTRAINT [DF_SENDWAIT_SourceId] DEFAULT (0) FOR [SourceId],
	CONSTRAINT [DF_sendwait_SmsFlag] DEFAULT (0) FOR [SmsFlag],
	CONSTRAINT [DF_sendwait_Retry] DEFAULT (0) FOR [Retry],
	CONSTRAINT [DF_SENDWAIT_FMT] DEFAULT (15) FOR [FMT],
	CONSTRAINT [DF_SENDWAIT_UDHI] DEFAULT (0) FOR [UDHI],
	CONSTRAINT [DF_SENDWAIT_LinkID] DEFAULT ('') FOR [LinkID],
	CONSTRAINT [DF_SENDWAIT_SubId] DEFAULT (1) FOR [MsgSubId],
	CONSTRAINT [DF_SENDWAIT_Count] DEFAULT (1) FOR [MsgCount],
	CONSTRAINT [DF_SENDWAIT_MsgIndex] DEFAULT (1) FOR [MsgIndex]
GO
💿 文件大小 577 K
👤 上传用户 cz6891297
📂 所属分类手机短信编程
🏷️ 相关标签

#cmpp #源代码
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -