SQL創(chuàng)建腳本如下:
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[MessageModule]( [Id] [uniqueidentifier] NOT NULL, [Name] [nvarchar](50) NULL, [Type] [nvarchar](50) NULL, [TypeNo] [nvarchar](50) NULL, [Channel] [nvarchar](50) NULL, [Param] [nvarchar](50) NULL, [Content] [nvarchar](max) NULL, [CreatedBy] [uniqueidentifier] NULL, [CreatedOn] [datetime] NULL, [ModifiedBy] [uniqueidentifier] NULL, [ModifiedOn] [datetime] NULL, [IsDeleted] [bit] NULL, [TypeId] [uniqueidentifier] NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO
在這之前是已經(jīng)開發(fā)了一個(gè)發(fā)送短信的API接口供客戶調(diào)用了的,也就是說調(diào)用方(客戶),不會(huì)修改代碼,只能我這邊來修