群发数据库脚本.txt

我上传的程序为:群发数据管理软件的数据处理.软件可以自己从界面操作,把自己要导入的数据导入数据库.并且有导成的功能

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

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

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

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

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

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

CREATE TABLE [dbo].[comnum] (
	[com] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[num] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dingshi] (
	[id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[num] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[data] [char] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[flag] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[comport] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ip] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tcpport] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dtime] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custid] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[numtype] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[failsms] (
	[id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[num] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[data] [char] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[flag] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[comport] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ip] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tcpport] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dtime] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custid] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[numtype] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[recv] (
	[id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[num] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[data] [char] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[flag] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[comport] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ip] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tcpport] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dtime] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custid] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[numtype] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[send] (
	[id] [bigint] IDENTITY (1, 1) NOT NULL ,
	[num] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[data] [char] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[flag] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[comport] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ip] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tcpport] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dtime] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custid] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[numtype] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[succsms] (
	[id] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[num] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[data] [char] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[flag] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[comport] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ip] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tcpport] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dtime] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custid] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[numtype] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO