aaa.sql

来自「cmpp协议的delphi解析cmpp协议的点歌系统」· SQL 代码 · 共 109 行

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

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

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

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

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

CREATE TABLE [dbo].[Dg_now_data] (
	[Src_terminal_id] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_terminal_id] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[send_name] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Play_time] [datetime] NULL ,
	[Star_id] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bless_id] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Song_id] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Star_txt] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bless_txt] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Song_txt] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[Play_order] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sequence_id] [int] NULL ,
	[Flow_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Play_num] [smallint] NULL ,
	[Source_addr] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Handle] [int] NULL ,
	[Ivr_machine] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ivr_channel] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ivr_state] [smallint] NULL ,
	[Star_path] [varchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bless_path] [varchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[Song_path] [varchar] (256) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dg_song_name] (
	[Path_id] [int] NOT NULL ,
	[Song_id] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Flag] [smallint] NOT NULL ,
	[Song_name] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dg_song_path] (
	[Path_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Path_name] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dg_source_data] (
	[Src_terminal_id] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_terminal_id] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[send_name] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Play_time] [datetime] NULL ,
	[Star_id] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bless_id] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Song_id] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Star_txt] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bless_txt] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Song_txt] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[Play_order] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sequence_id] [int] NULL ,
	[Flow_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Play_num] [smallint] NULL ,
	[Source_addr] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Handle] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dg_waiting_data] (
	[Src_terminal_id] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dest_terminal_id] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[send_name] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Play_time] [datetime] NULL ,
	[Star_id] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bless_id] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Song_id] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Star_txt] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bless_txt] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Song_txt] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[Play_order] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sequence_id] [int] NULL ,
	[Flow_id] [int] IDENTITY (1, 1) NOT NULL ,
	[Play_num] [smallint] NULL ,
	[Source_addr] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Handle] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Dg_now_data] WITH NOCHECK ADD 
	CONSTRAINT [DF_Dg_now_data_Play_num] DEFAULT (0) FOR [Play_num],
	CONSTRAINT [DF_Dg_now_data_Ivr_state] DEFAULT (0) FOR [Ivr_state]
GO