/****** Object: Table [dbo].[char_items] Script Date: 12/15/2010 22:19:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[char_items](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[itemid] [int] NULL CONSTRAINT [DF_char_items_itemid] DEFAULT ((0)),
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL CONSTRAINT [DF_char_items_plusvalue] DEFAULT ((0)),
[slot] [tinyint] NULL,
[type] [tinyint] NULL CONSTRAINT [DF_char_items_type] DEFAULT ((0)),
[quantity] [smallint] NULL CONSTRAINT [DF_char_items_quantity] DEFAULT ((1)),
[durability] [int] NULL CONSTRAINT [DF_char_items_durability] DEFAULT ((30)),
[inavatar] [bigint] NULL CONSTRAINT [DF_char_items_inavatar] DEFAULT ((0)),
[phy_re] [tinyint] NULL CONSTRAINT [DF_char_items_blue1] DEFAULT ((0)),
[mag_re] [tinyint] NULL CONSTRAINT [DF_char_items_blue_id_2] DEFAULT ((0)),
[phy_def] [tinyint] NULL CONSTRAINT [DF_char_items_phy_def] DEFAULT ((0)),
[mag_def] [tinyint] NULL CONSTRAINT [DF_char_items_mag_def] DEFAULT ((0)),
[block_ratio] [tinyint] NULL CONSTRAINT [DF_char_items_block_ratio] DEFAULT ((0)),
[attack_ratio] [tinyint] NULL CONSTRAINT [DF_char_items_attack_ratio] DEFAULT ((0)),
[parry_ratio] [tinyint] NULL CONSTRAINT [DF_char_items_parry_ratio] DEFAULT ((0)),
[phy_attack] [tinyint] NULL CONSTRAINT [DF_char_items_phy_attack] DEFAULT ((0)),
[mag_attack] [tinyint] NULL CONSTRAINT [DF_char_items_mag_attack] DEFAULT ((0)),
[str_value] [tinyint] NULL CONSTRAINT [DF_char_items_str_value] DEFAULT ((0)),
[int_value] [tinyint] NULL CONSTRAINT [DF_char_items_int_value] DEFAULT ((0)),
[block_blue] [tinyint] NULL CONSTRAINT [DF_char_items_block_blue] DEFAULT ((0)),
CONSTRAINT [PK_char_items] 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
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character] Script Date: 12/15/2010 22:19:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[character](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [nvarchar](50) NOT NULL,
[name] [nvarchar](50) NOT NULL,
[chartype] [int] NOT NULL,
[volume] [tinyint] NOT NULL,
[level] [tinyint] NOT NULL CONSTRAINT [DF_karakterler_level] DEFAULT ((1)),
[strength] [smallint] NOT NULL CONSTRAINT [DF_karakterler_strength] DEFAULT ((20)),
[intelligence] [smallint] NOT NULL CONSTRAINT [DF_karakterler_intelligence] DEFAULT ((20)),
[attribute] [smallint] NOT NULL CONSTRAINT [DF_karakterler_attribute] DEFAULT ((0)),
[hp] [int] NOT NULL CONSTRAINT [DF_karakterler_hp] DEFAULT ((200)),
[mp] [int] NOT NULL CONSTRAINT [DF_karakterler_mp] DEFAULT ((200)),
[gold] [bigint] NOT NULL CONSTRAINT [DF_karakterler_gold] DEFAULT ((0)),
[experience] [bigint] NOT NULL CONSTRAINT [DF_karakterler_expirience] DEFAULT ((0)),
[spbar] [int] NOT NULL CONSTRAINT [DF_karakterler_sbpar] DEFAULT ((0)),
[sp] [int] NOT NULL CONSTRAINT [DF_karakterler_sp] DEFAULT ((0)),
[gm] [tinyint] NOT NULL CONSTRAINT [DF_karakterler_gm] DEFAULT ((0)),
[xsect] [tinyint] NULL CONSTRAINT [DF_karakterler_xsect] DEFAULT ((168)),
[ysect] [tinyint] NULL CONSTRAINT [DF_karakterler_ysect] DEFAULT ((97)),
[unknown3] [nvarchar](50) NULL,
[xpos] [int] NULL CONSTRAINT [DF_karakterler_xpos] DEFAULT ((911)),
[ypos] [int] NULL CONSTRAINT [DF_karakterler_ypos] DEFAULT ((1083)),
[zpos] [int] NULL CONSTRAINT [DF_karakterler_zpos] DEFAULT ((-32)),
[s_hp] [int] NOT NULL CONSTRAINT [DF_karakterler_s_hp] DEFAULT ((200)),
[s_mp] [int] NOT NULL CONSTRAINT [DF_karakterler_s_mp] DEFAULT ((200)),
[min_phyatk] [int] NULL,
[max_phyatk] [int] NULL,
[min_magatk] [int] NULL,
[max_magatk] [int] NULL,
[phydef] [smallint] NULL,
[magdef] [smallint] NULL,
[hit] [smallint] NULL,
[parry] [smallint] NULL,
[unknown] [nvarchar](50) NULL,
[walkspeed] [int] NULL CONSTRAINT [DF_karakterler_walkspeed] DEFAULT ((17)),
[runspeed] [int] NULL CONSTRAINT [DF_karakterler_runspeed] DEFAULT ((70)),
[berserkspeed] [int] NULL CONSTRAINT [DF_karakterler_berserkerspeed] DEFAULT ((100)),
[berserkbar] [tinyint] NULL CONSTRAINT [DF_karakterler_berserkerbar] DEFAULT ((0)),
[unknown2] [nvarchar](50) NULL,
[mag_absord] [smallint] NULL CONSTRAINT [DF_karakterler_mag_absord] DEFAULT ((0)),
[phy_absord] [smallint] NULL CONSTRAINT [DF_karakterler_phy_absord] DEFAULT ((0)),
[savearea] [tinyint] NULL CONSTRAINT [DF_karakterler_savearea] DEFAULT ((3)),
[title] [tinyint] NULL CONSTRAINT [DF_karakterler_title] DEFAULT ((0)),
[deleted] [tinyint] NULL CONSTRAINT [DF_karakterler_deleted] DEFAULT ((0)),
[deletedtime] [datetime] NULL CONSTRAINT [DF_karakterler_deletedtime] DEFAULT ('10.10.2010'),
[Slots] [int] NULL CONSTRAINT [DF_karakterler_Slots] DEFAULT ((45)),
[Pvpstate] [tinyint] NULL CONSTRAINT [DF_character_Pkstate] DEFAULT ((0)),
[Action] [int] NULL CONSTRAINT [DF_character_Action] DEFAULT ((0)),
[Online] [tinyint] NULL CONSTRAINT [DF_character_Online] DEFAULT ((1)),
[DailyPK] [tinyint] NULL CONSTRAINT [DF_character_DailyPK] DEFAULT ((0)),
[PkLevel] [tinyint] NULL CONSTRAINT [DF_character_PkLevel] DEFAULT ((0)),
[MurderLevel] [tinyint] NULL CONSTRAINT [DF_character_MurderLevel] DEFAULT ((0))
) ON [PRIMARY]
/****** Object: Table [dbo].[character_guides] Script Date: 12/15/2010 22:19:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_guides](
[id] [int] IDENTITY(1,1) NOT NULL,
[Guide_Name] [varchar](50) NULL,
[Guide_Owner] [varchar](50) NULL,
[Guide_Status] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_jobs] Script Date: 12/15/2010 22:19:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_jobs](
[id] [int] IDENTITY(1,1) NOT NULL,
[character_name] [varchar](50) NULL,
[job_alias] [varchar](50) NULL CONSTRAINT [DF_character_jobs_job_alias] DEFAULT ((0)),
[job_type] [tinyint] NULL,
[job_experience] [int] NULL CONSTRAINT [DF_character_jobs_job_experience] DEFAULT ((0)),
[job_rank] [tinyint] NULL CONSTRAINT [DF_character_jobs_job_rank] DEFAULT ((0)),
[job_state] [int] NULL CONSTRAINT [DF_character_jobs_job_state] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_quests] Script Date: 12/15/2010 22:19:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_quests](
[id] [int] IDENTITY(1,1) NOT NULL,
[character] [varchar](50) NULL,
[quest_id] [int] NULL,
[quest_status] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_rev] Script Date: 12/15/2010 22:19:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_rev](
[id] [int] IDENTITY(1,1) NOT NULL,
[charname] [varchar](50) NULL,
[revxsec] [tinyint] NULL,
[revysec] [tinyint] NULL,
[revx] [int] NULL,
[revy] [int] NULL,
[revz] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[friends] Script Date: 12/15/2010 22:19:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[friends](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [varchar](50) NULL,
[friend_name] [varchar](50) NULL,
[model_info] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[guild] Script Date: 12/15/2010 22:19:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[guild](
[id] [int] IDENTITY(1,1) NOT NULL,
[guild_name] [varchar](50) NULL,
[guild_level] [tinyint] NULL,
[guild_points] [int] NULL,
[guild_news_t] [varchar](50) NULL,
[guild_news_m] [varchar](50) NULL,
[guild_members_t] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[guild_members] Script Date: 12/15/2010 22:19:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[guild_members](
[id] [int] IDENTITY(1,1) NOT NULL,
[guild_name] [varchar](50) NULL,
[guild_member_id] [int] NULL,
[guild_rank] [tinyint] NULL,
[guild_points] [int] NULL,
[guild_auth] [tinyint] NULL,
[guild_grant] [varchar](50) NULL,
[guild_p] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[guild_storage] Script Date: 12/15/2010 22:19:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[guild_storage](
[id] [int] IDENTITY(1,1) NOT NULL,
[guild_id] [int] NULL,
[storage_id] [int] NULL,
[item_id] [int] NULL,
[item_plus] [tinyint] NULL,
[item_durability] [int] NULL,
[item_slot] [tinyint] NULL,
[item_type] [tinyint] NULL,
[item_quantity] [smallint] NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[guild_war] Script Date: 12/15/2010 22:19:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[guild_war](
[id] [int] NULL,
[guild_id] [int] NULL,
[guild_id_2] [int] NULL,
[status] [tinyint] NULL,
[war_gold] [bigint] NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[mastery] Script Date: 12/15/2010 22:19:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mastery](
[owner] [int] NULL,
[mastery] [int] NULL,
[level] [tinyint] NULL CONSTRAINT [DF_mastery_level] DEFAULT ((0))
) ON [PRIMARY]
/****** Object: Table [dbo].[message] Script Date: 12/15/2010 22:19:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[message](
[id] [int] IDENTITY(1,1) NOT NULL,
[sender] [varchar](50) NULL,
[receiver] [varchar](50) NULL,
[message] [text] NULL,
[status] [tinyint] NULL,
[time] [datetime] NULL,
[idinfo] [tinyint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[news] Script Date: 12/15/2010 22:19:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[news](
[id] [int] IDENTITY(1,1) NOT NULL,
[head] [text] NULL,
[text] [text] NULL,
[day] [smallint] NULL,
[month] [smallint] NULL,
CONSTRAINT [PK_news] 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] TEXTIMAGE_ON [PRIMARY]
/****** Object: Table [dbo].[pets] Script Date: 12/15/2010 22:19:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pets](
[id] [int] IDENTITY(1,1) NOT NULL,
[playerid] [int] NULL,
[pet_type] [tinyint] NULL,
[pet_name] [varchar](50) NULL,
[pet_state] [tinyint] NULL,
[pet_hp] [int] NULL,
[pet_hgp] [int] NULL,
[pet_itemid] [int] NULL,
[pet_slots] [tinyint] NULL CONSTRAINT [DF_pets_pet_slots] DEFAULT ((28)),
[pet_time] [datetime] NULL,
[pet_active] [tinyint] NULL CONSTRAINT [DF_pets_pet_active] DEFAULT ((0)),
[pet_unique] [int] NULL,
[pet_check] [varchar](50) NULL CONSTRAINT [DF_pets_pet_check] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[pets_storage] Script Date: 12/15/2010 22:19:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pets_storage](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[itemid] [int] NULL,
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL,
[slot] [tinyint] NULL,
[type] [tinyint] NULL,
[quantity] [smallint] NULL CONSTRAINT [DF_pets_storage_quantity] DEFAULT ((0)),
[durability] [int] NULL CONSTRAINT [DF_pets_storage_durability] DEFAULT ((0)),
[blue_values_1] [tinyint] NULL,
[pet_id] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[rank_honor] Script Date: 12/15/2010 22:19:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rank_honor](
[id] [int] IDENTITY(1,1) NOT NULL,
[rank_icon] [tinyint] NULL,
[rank_name] [varchar](50) NULL,
[rank_level] [tinyint] NULL,
[rank_level_c] [tinyint] NULL,
[rank_graduates] [int] NULL,
[rank_position] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[rank_job_activity] Script Date: 12/15/2010 22:19:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rank_job_activity](
[id] [int] IDENTITY(1,1) NOT NULL,
[job_type] [tinyint] NULL,
[job_rank] [tinyint] NULL,
[job_name] [varchar](50) NULL,
[job_level] [tinyint] NULL,
[job_exp] [int] NULL,
[job_title] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[rank_job_donate] Script Date: 12/15/2010 22:19:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rank_job_donate](
[id] [int] IDENTITY(1,1) NOT NULL,
[job_type] [tinyint] NULL,
[job_rank] [tinyint] NULL,
[job_name] [varchar](50) NULL,
[job_level] [tinyint] NULL,
[job_donate] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[saved_skills] Script Date: 12/15/2010 22:19:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[saved_skills](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [varchar](50) NULL,
[skillid] [int] NULL,
[level] [int] NULL CONSTRAINT [DF_saved_skills_level] DEFAULT ((1)),
CONSTRAINT [PK_saved_skills] 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
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[server] Script Date: 12/15/2010 22:20:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[server](
[id] [int] NOT NULL,
[serverid] [smallint] NULL,
[name] [varchar](50) NULL,
[users_current] [smallint] NULL,
[users_max] [smallint] NULL,
[state] [tinyint] NULL,
[ip] [varchar](20) NULL,
[port] [smallint] NULL,
[type] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[storage_items] Script Date: 12/15/2010 22:20:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[storage_items](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[itemid] [int] NULL,
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL CONSTRAINT [DF_storage_items_plusvalue] DEFAULT ((0)),
[slot] [tinyint] NULL,
[type] [tinyint] NULL CONSTRAINT [DF_storage_items_type] DEFAULT ((0)),
[quantity] [smallint] NULL CONSTRAINT [DF_storage_items_quantity] DEFAULT ((1)),
[durability] [int] NULL CONSTRAINT [DF_storage_items_durability] DEFAULT ((30)),
CONSTRAINT [PK_storage_items] 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
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[users] Script Date: 12/15/2010 22:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[users](
[userid] [int] IDENTITY(1,1) NOT NULL,
[id] [varchar](50) NOT NULL,
[password] [varchar](50) NOT NULL,
[online] [tinyint] NOT NULL,
[unknown] [tinyint] NULL,
[unknown2] [int] NULL,
[silk] [int] NULL,
[gold] [bigint] NULL,
CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED
(
[userid] 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
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[users_ban] Script Date: 12/15/2010 22:20:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[users_ban](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](50) NULL,
[ipadress] [varchar](50) NULL,
[reason] [text] NULL,
[endtime] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
|