USE [master]
GO
/****** Object:  Database [corpsmsm]    Script Date: 2022/3/9 11:11:16 ******/
CREATE DATABASE [corpsmsm]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'corpsmsm', FILENAME = N'D:\SQL_Data\corpsms\corpsmsm.mdf' , SIZE = 2GB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'corpsmsm_Log', FILENAME = N'D:\SQL_Data\corpsms\corpsmsm_Log.ldf' , SIZE = 256MB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
 WITH CATALOG_COLLATION = DATABASE_DEFAULT
GO
ALTER DATABASE [corpsmsm] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [corpsmsm].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [corpsmsm] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [corpsmsm] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [corpsmsm] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [corpsmsm] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [corpsmsm] SET ARITHABORT OFF 
GO
ALTER DATABASE [corpsmsm] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [corpsmsm] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [corpsmsm] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [corpsmsm] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [corpsmsm] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [corpsmsm] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [corpsmsm] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [corpsmsm] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [corpsmsm] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [corpsmsm] SET  DISABLE_BROKER 
GO
ALTER DATABASE [corpsmsm] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [corpsmsm] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [corpsmsm] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [corpsmsm] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [corpsmsm] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [corpsmsm] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [corpsmsm] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [corpsmsm] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [corpsmsm] SET  MULTI_USER 
GO
ALTER DATABASE [corpsmsm] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [corpsmsm] SET DB_CHAINING OFF 
GO
ALTER DATABASE [corpsmsm] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [corpsmsm] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
ALTER DATABASE [corpsmsm] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [corpsmsm] SET ACCELERATED_DATABASE_RECOVERY = OFF  
GO
EXEC sys.sp_db_vardecimal_storage_format N'corpsmsm', N'ON'
GO
ALTER DATABASE [corpsmsm] SET QUERY_STORE = OFF
GO
USE [corpsmsm]
GO
/****** Object:  User [smsselect]    Script Date: 2022/3/9 11:11:17 ******/
CREATE USER [smsselect] FOR LOGIN [smsselect] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  User [corpsms]    Script Date: 2022/3/9 11:11:17 ******/
CREATE USER [corpsms] FOR LOGIN [corpsms] WITH DEFAULT_SCHEMA=[dbo]
GO
ALTER ROLE [db_datareader] ADD MEMBER [smsselect]
GO
ALTER ROLE [db_owner] ADD MEMBER [corpsms]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MmsSend](
	[SendID] [int] NOT NULL,
	[MmsFileID] [int] NULL,
	[CorpID] [int] NULL,
	[UserID] [int] NULL,
	[GroupID] [nvarchar](16) NULL,
	[Status] [int] NULL,
	[MsgID] [nvarchar](32) NULL,
	[MsgType] [int] NULL,
	[SendRet] [int] NULL,
	[SendFCS] [int] NULL,
	[ReSendCount] [int] NULL,
	[Sender] [nvarchar](25) NULL,
	[SendNum] [nvarchar](25) NULL,
	[Recver] [nvarchar](25) NULL,
	[RecvNum] [nvarchar](25) NULL,
	[RecvNumType] [int] NULL,
	[SubTime] [datetime] NULL,
	[Timer] [datetime] NULL,
	[Priority] [int] NULL,
	[StatusReport] [int] NULL,
	[SendTime] [datetime] NULL,
	[RecvTime] [datetime] NULL,
	[RecvStatus] [nvarchar](128) NULL,
	[Title] [nvarchar](64) NULL,
	[mmSize] [int] NULL,
	[KF] [int] NULL,
	[Times] [int] NULL,
	[IP] [nvarchar](20) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MmsSendT]    Script Date: 2022/3/9 11:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MmsSendT](
	[SendID] [int] IDENTITY(10000000,1) NOT NULL,
	[MmsFileID] [int] NULL,
	[CorpID] [int] NULL,
	[UserID] [int] NULL,
	[GroupID] [nvarchar](16) NULL,
	[Status] [int] NULL,
	[MsgID] [nvarchar](32) NULL,
	[MsgType] [int] NULL,
	[SendRet] [int] NULL,
	[SendFCS] [int] NULL,
	[ReSendCount] [int] NULL,
	[Sender] [nvarchar](25) NULL,
	[SendNum] [nvarchar](25) NULL,
	[Recver] [nvarchar](25) NULL,
	[RecvNum] [nvarchar](25) NULL,
	[RecvNumType] [int] NULL,
	[SubTime] [datetime] NULL,
	[Timer] [datetime] NULL,
	[Priority] [int] NULL,
	[StatusReport] [int] NULL,
	[SendTime] [datetime] NULL,
	[RecvTime] [datetime] NULL,
	[RecvStatus] [nvarchar](128) NULL,
	[Title] [nvarchar](64) NULL,
	[mmSize] [int] NULL,
	[KF] [int] NULL,
	[Times] [int] NULL,
	[IP] [nvarchar](20) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SmsReport]    Script Date: 2022/3/9 11:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SmsReport](
	[SmsReportID] [int] IDENTITY(1,1) NOT NULL,
	[MsgID] [nvarchar](32) NULL,
	[ReportStatus] [int] NULL,
	[RecvStatus] [nvarchar](16) NULL,
	[SendFcs] [int] NULL,
	[ReportTime] [datetime] NULL,
	[Mobile] [nvarchar](16) NULL,
	[TDmsgType] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Index [IX_SmsReport]    Script Date: 2022/3/9 11:11:17 ******/
CREATE CLUSTERED INDEX [IX_SmsReport] ON [dbo].[SmsReport]
(
	[SmsReportID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SmsReport_SDK]    Script Date: 2022/3/9 11:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SmsReport_SDK](
	[SmsReport_SDKID] [int] IDENTITY(1,1) NOT NULL,
	[CorpID] [int] NULL,
	[UserID] [int] NULL,
	[SendID] [int] NULL,
	[MsgID] [nvarchar](32) NULL,
	[Mobile] [nvarchar](16) NULL,
	[ReportStatus] [int] NULL,
	[RecvStatus] [nvarchar](16) NULL,
	[SendFcs] [int] NULL,
	[ReportTime] [datetime] NULL,
	[TDMsgType] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Index [IX_SmsReport_SDK]    Script Date: 2022/3/9 11:11:17 ******/
CREATE CLUSTERED INDEX [IX_SmsReport_SDK] ON [dbo].[SmsReport_SDK]
(
	[SmsReport_SDKID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SmsReSend]    Script Date: 2022/3/9 11:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SmsReSend](
	[SendID] [int] NOT NULL,
	[CorpID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[MsgID] [nvarchar](32) NULL,
	[SendRet] [int] NULL,
	[ReSendCount] [int] NULL,
	[SendNum] [nvarchar](25) NULL,
	[RecvNum] [nvarchar](25) NULL,
	[RecvNumType] [int] NULL,
	[Msg] [nvarchar](180) NULL,
	[SubTime] [datetime] NULL,
	[SendTime] [datetime] NULL,
	[RecvTime] [datetime] NULL,
	[RecvStatus] [nvarchar](16) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[smssend]    Script Date: 2022/3/9 11:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[smssend](
	[SendID] [int] NOT NULL,
	[CorpID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[GroupID] [nvarchar](16) NULL,
	[Status] [int] NULL,
	[MsgID] [nvarchar](32) NULL,
	[SendRet] [int] NULL,
	[SendFCS] [int] NULL,
	[ReSendCount] [int] NULL,
	[Sender] [nvarchar](25) NULL,
	[SendNum] [nvarchar](25) NULL,
	[Recver] [nvarchar](25) NULL,
	[RecvNum] [nvarchar](25) NULL,
	[RecvNumType] [int] NULL,
	[Msg] [nvarchar](180) NULL,
	[MsgType] [int] NULL,
	[SubTime] [datetime] NULL,
	[Timer] [datetime] NULL,
	[Priority] [int] NULL,
	[StatusReport] [int] NULL,
	[OvrTime] [datetime] NULL,
	[SendTime] [datetime] NULL,
	[RecvTime] [datetime] NULL,
	[RecvStatus] [nvarchar](16) NULL,
	[KF] [int] NULL,
	[IP] [nvarchar](20) NULL
) ON [PRIMARY]
GO
/****** Object:  Index [sendid_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE CLUSTERED INDEX [sendid_index] ON [dbo].[smssend]
(
	[SendID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[smssendT]    Script Date: 2022/3/9 11:11:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[smssendT](
	[SendID] [int] IDENTITY(10000000,1) NOT NULL,
	[CorpID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[GroupID] [nvarchar](16) NULL,
	[Status] [int] NULL,
	[MsgID] [nvarchar](32) NULL,
	[SendRet] [int] NULL,
	[SendFCS] [int] NULL,
	[ReSendCount] [int] NULL,
	[Sender] [nvarchar](25) NULL,
	[SendNum] [nvarchar](25) NULL,
	[Recver] [nvarchar](25) NULL,
	[RecvNum] [nvarchar](25) NULL,
	[RecvNumType] [int] NULL,
	[Msg] [nvarchar](180) NULL,
	[MsgType] [int] NULL,
	[SubTime] [datetime] NULL,
	[Timer] [datetime] NULL,
	[Priority] [int] NULL,
	[StatusReport] [int] NULL,
	[OvrTime] [datetime] NULL,
	[SendTime] [datetime] NULL,
	[RecvTime] [datetime] NULL,
	[RecvStatus] [nvarchar](16) NULL,
	[KF] [int] NULL,
	[IP] [nvarchar](20) NULL
) ON [PRIMARY]
GO
/****** Object:  Index [sendid_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE CLUSTERED INDEX [sendid_index] ON [dbo].[smssendT]
(
	[SendID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [CorpID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [CorpID_index] ON [dbo].[MmsSend]
(
	[CorpID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [MmsFileID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [MmsFileID_index] ON [dbo].[MmsSend]
(
	[MmsFileID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [MsgID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [MsgID_index] ON [dbo].[MmsSend]
(
	[MsgID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [RecvNum_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [RecvNum_index] ON [dbo].[MmsSend]
(
	[RecvNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [SendID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SendID_index] ON [dbo].[MmsSend]
(
	[SendID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [SendTime_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SendTime_index] ON [dbo].[MmsSend]
(
	[SendTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [UserID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [UserID_index] ON [dbo].[MmsSend]
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [ALL]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [ALL] ON [dbo].[MmsSendT]
(
	[Priority] ASC,
	[SubTime] ASC,
	[SendRet] ASC,
	[Status] ASC,
	[Timer] ASC,
	[RecvNumType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [CorpID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [CorpID_index] ON [dbo].[MmsSendT]
(
	[CorpID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [MmsFileID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [MmsFileID_index] ON [dbo].[MmsSendT]
(
	[MmsFileID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [Priority_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [Priority_index] ON [dbo].[MmsSendT]
(
	[Priority] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [RecvNum_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [RecvNum_index] ON [dbo].[MmsSendT]
(
	[RecvNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [SendID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SendID_index] ON [dbo].[MmsSendT]
(
	[SendID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [SendRet_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SendRet_index] ON [dbo].[MmsSendT]
(
	[SendRet] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [SubTime_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SubTime_index] ON [dbo].[MmsSendT]
(
	[SubTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [Timer_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [Timer_index] ON [dbo].[MmsSendT]
(
	[Timer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [UserID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [UserID_index] ON [dbo].[MmsSendT]
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [IX_SmsReport_SDK_1]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [IX_SmsReport_SDK_1] ON [dbo].[SmsReport_SDK]
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [IX_SendID]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [IX_SendID] ON [dbo].[SmsReSend]
(
	[SendID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [CorpID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [CorpID_index] ON [dbo].[smssend]
(
	[CorpID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [MsgID_Index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [MsgID_Index] ON [dbo].[smssend]
(
	[MsgID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [RecvNum_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [RecvNum_index] ON [dbo].[smssend]
(
	[RecvNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SendNum_Index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SendNum_Index] ON [dbo].[smssend]
(
	[SendNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [SendTime_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SendTime_index] ON [dbo].[smssend]
(
	[SendTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [UserID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [UserID_index] ON [dbo].[smssend]
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [All_smssend]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [All_smssend] ON [dbo].[smssendT]
(
	[Status] ASC,
	[Timer] DESC,
	[SubTime] DESC,
	[SendRet] ASC,
	[RecvNumType] ASC,
	[Priority] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [CorpID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [CorpID_index] ON [dbo].[smssendT]
(
	[CorpID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [MsgID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [MsgID_index] ON [dbo].[smssendT]
(
	[MsgID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [Priority_SmsSend]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [Priority_SmsSend] ON [dbo].[smssendT]
(
	[Priority] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [RecvNum_Index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [RecvNum_Index] ON [dbo].[smssendT]
(
	[RecvNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SendNum_Index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SendNum_Index] ON [dbo].[smssendT]
(
	[SendNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [SendTime_Index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [SendTime_Index] ON [dbo].[smssendT]
(
	[SendTime] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [Status_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [Status_index] ON [dbo].[smssendT]
(
	[Status] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [Timer_smssend]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [Timer_smssend] ON [dbo].[smssendT]
(
	[Timer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object:  Index [UserID_index]    Script Date: 2022/3/9 11:11:17 ******/
CREATE NONCLUSTERED INDEX [UserID_index] ON [dbo].[smssendT]
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_MmsFileID]  DEFAULT ((0)) FOR [MmsFileID]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_CorpID]  DEFAULT ((0)) FOR [CorpID]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_UserID]  DEFAULT ((0)) FOR [UserID]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_MsgType]  DEFAULT ((0)) FOR [MsgType]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_SendRet]  DEFAULT ((0)) FOR [SendRet]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_SendFCS]  DEFAULT ((0)) FOR [SendFCS]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_RecvNumType]  DEFAULT ((0)) FOR [RecvNumType]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_StatusReport]  DEFAULT ((1)) FOR [StatusReport]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_PriceOne]  DEFAULT ((1)) FOR [KF]
GO
ALTER TABLE [dbo].[MmsSendT] ADD  CONSTRAINT [DF_MmsSendT_Times]  DEFAULT ((0)) FOR [Times]
GO
ALTER TABLE [dbo].[SmsReport] ADD  CONSTRAINT [DF_SmsReport_ReportStatus]  DEFAULT ((0)) FOR [ReportStatus]
GO
ALTER TABLE [dbo].[SmsReport] ADD  CONSTRAINT [DF_SmsReport_SendFcs]  DEFAULT ((0)) FOR [SendFcs]
GO
ALTER TABLE [dbo].[SmsReport] ADD  CONSTRAINT [DF_SmsReport_ReportTime]  DEFAULT (getdate()) FOR [ReportTime]
GO
ALTER TABLE [dbo].[SmsReport] ADD  DEFAULT ((0)) FOR [TDmsgType]
GO
ALTER TABLE [dbo].[SmsReport_SDK] ADD  CONSTRAINT [DF_SmsReport_SDK_ReportStatus]  DEFAULT ((0)) FOR [ReportStatus]
GO
ALTER TABLE [dbo].[SmsReport_SDK] ADD  CONSTRAINT [DF_SmsReport_SDK_SendFcs]  DEFAULT ((0)) FOR [SendFcs]
GO
ALTER TABLE [dbo].[SmsReport_SDK] ADD  CONSTRAINT [DF_SmsReport_SDK_ReportTime]  DEFAULT (getdate()) FOR [ReportTime]
GO
ALTER TABLE [dbo].[SmsReport_SDK] ADD  CONSTRAINT [DF_SmsReport_SDK_tdmsgtype]  DEFAULT ((0)) FOR [TDMsgType]
GO
ALTER TABLE [dbo].[smssend] ADD  CONSTRAINT [DF_smssend_StatusReport]  DEFAULT ((1)) FOR [StatusReport]
GO
USE [master]
GO
ALTER DATABASE [corpsmsm] SET  READ_WRITE 
GO