62,244
社区成员




USE [TEST]
GO
/****** Object: Table [dbo].[tbl_monster] Script Date: 07/08/2014 15:30:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_monster](
[id] [int] IDENTITY(1,1) NOT NULL,
[land_id] [int] NOT NULL,
[name] [nvarchar](50) NULL,
[blood] [int] NULL,
[bloodadd] [int] NULL,
[attack] [int] NULL,
[attackadd] [int] NULL,
[exp] [int] NULL,
[expadd] [int] NULL,
CONSTRAINT [PK_tbl_monster] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[tbl_land] Script Date: 07/08/2014 15:30:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_land](
[id] [int] IDENTITY(1,1) NOT NULL,
[landEName] [nvarchar](50) NULL,
[landCName] [nvarchar](50) NULL,
CONSTRAINT [PK_tbl_land] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[tbl_item] Script Date: 07/08/2014 15:30:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_item](
[id] [int] IDENTITY(1,1) NOT NULL,
[item_name] [nvarchar](50) NULL,
[item_type] [nvarchar](50) NULL,
[item_description] [nvarchar](50) NULL,
CONSTRAINT [PK_tbl_item] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO