📄 tmp_new.sql

📁 cmpp协议的delphi解析cmpp协议的点歌系统
💻 SQL
字号:
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'playsong')
	DROP DATABASE [playsong]
GO

CREATE DATABASE [playsong]  ON (NAME = N'playsong_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\playsong_Data.MDF' , SIZE = 26, FILEGROWTH = 10%) LOG ON (NAME = N'playsong_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\playsong_Log.LDF' , SIZE = 28, FILEGROWTH = 10%)
 COLLATE Chinese_PRC_CI_AS
GO

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

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

exec sp_dboption N'playsong', N'trunc. log', N'false'
GO

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

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

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

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

exec sp_dboption N'playsong', N'autoshrink', N'false'
GO

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

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

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

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

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

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

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

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

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

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

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

use [playsong]
GO

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

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

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_ivr_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 ,
	[Start_time] [datetime] NULL ,
	[End_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 ,
	[Err_txt] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stat] [char] (7) 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 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dg_ivr_tmp_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 ,
	[Start_time] [datetime] NULL ,
	[End_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 ,
	[Err_txt] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stat] [char] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[Isdel] [smallint] 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 
) ON [PRIMARY]
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_ivr_tmp_data] ADD 
	CONSTRAINT [DF_Dg_ivr_tmp_data_Isdel] DEFAULT (0) FOR [Isdel]
GO

ALTER TABLE [dbo].[Dg_now_data] 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
💿 文件大小 351 K
👤 上传用户 gjq2000
📂 所属分类 Delphi控件源码
🏷️ 相关标签

#cmpp #delphi #协议 #点歌系统
⌨️ 快捷键说明

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