缺失的4个表.txt

来自「SQL语句,对于在老版本服务端上缺少的4个表的补充」· 文本 代码 · 共 80 行

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

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

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

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

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

CREATE TABLE [dbo].[arena_bonus_info] (

[idBonus] [int] NOT NULL ,
[min_level] [int] NOT NULL ,
[max_level] [int] NOT NULL ,
[item_house] [int] NOT NULL ,
[item_kind] [int] NOT NULL ,
[item_grade] [int] NOT NULL ,
[item_gain_rate] [real] NOT NULL ,
[exp_rate] [real] NOT NULL ,
[idGame] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[arena_game_info] (
[idGame] [int] NOT NULL ,
[arena_type] [int] NOT NULL ,
[play_time] [int] NOT NULL ,
[observe_money] [int] NOT NULL ,
[min_batting_money] [int] NOT NULL ,
[max_batting_money] [int] NOT NULL ,
[dividend_rate] [real] NOT NULL, 
[map_port] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[arena_info] (
[map_port] [int] NOT NULL ,
[map_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[wait_x] [int] NOT NULL ,
[wait_y] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[arena_team_info] (
[idTeam] [int] NOT NULL ,
[start_x] [int] NOT NULL ,
[start_y] [int] NOT NULL ,
[idHunt] [int] NOT NULL ,
[idGame] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[requital_item] (
[index] [int] NOT NULL ,
[count] [int] NOT NULL ,
[rate] [int] NOT NULL ,
[item_no_1] [int] NOT NULL ,
[item_no_2] [int] NOT NULL ,
[item_no_3] [int] NOT NULL ,
[item_no_4] [int] NOT NULL ,
[item_no_5] [int] NOT NULL ,
[Grade] [int] NOT NULL ,
[Kind1] [int] NOT NULL ,
[Kind2] [int] NOT NULL ,
[Kind3] [int] NOT NULL ,
[IsDynamic] [int] NOT NULL ,
[HighRare] [int] NOT NULL 
) ON [PRIMARY]
GO