ok Now if you still have this problem Delete All querys In C:\Documents and Settings\Your PC Name\My Documents\SQL Server Management Studio Express\Projects then Delete The database and make new Data Base With name Silk and Copy This
and Paste Them As A new Query and dont do any thing in them and its Completed Data Not Needed To add Guild-Unions
Good Luck Sorry For bad English
/****** Object: Table [dbo].[character] Script Date: 08/28/2011 11:33:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING 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 ((15)),
[runspeed] [int] NULL CONSTRAINT [DF_karakterler_runspeed] DEFAULT ((50)),
[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 ((1)),
[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] [int] 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)),
[GuideData] [varchar](16) NULL CONSTRAINT [DF_character_GuideData] DEFAULT ((0)),
[StallModel] [int] NULL CONSTRAINT [DF_character_StallModel] DEFAULT ((0)),
[Storage_Expanded] [tinyint] NULL CONSTRAINT [DF_character_Storage_Expanded] DEFAULT ((0)),
[GuildJoining] [tinyint] NULL CONSTRAINT [DF_character_GuildJoining] DEFAULT ((0)),
[GuildTime] [datetime] NULL CONSTRAINT [DF_character_GuildTime] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF/****** Object: Table [dbo].[character_jobs] Script Date: 08/08/2011 17:03:40 ******/
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)),
[job_level] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF/****** Object: Table [dbo].[character_quests] Script Date: 08/08/2011 17:03:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[character_quests](
[id] [int] IDENTITY(1,1) NOT NULL,
[quest_owner] [int] NULL,
[quest_id] [int] NULL,
[quest_status] [tinyint] NULL,
[quest_step] [tinyint] NULL,
[quest_reward_id] [int] NULL
) ON [PRIMARY]/****** Object: Table [dbo].[character_rev] Script Date: 08/08/2011 17:03:47 ******/
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].[character_tickets] Script Date: 08/08/2011 17:03:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[character_tickets](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[item_id] [int] NULL,
[start_time] [datetime] NULL,
[end_time] [datetime] NULL,
[active] [tinyint] NULL CONSTRAINT [DF_character_tickets_active] DEFAULT ((0))
) ON [PRIMARY]/****** Object: Table [dbo].[char_items] Script Date: 08/08/2011 17:03:30 ******/
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,
[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)),
[BlueAmount] [int] NULL CONSTRAINT [DF_char_items_blue1] DEFAULT ((0)),
[blue1] [varchar](50) NULL CONSTRAINT [DF_char_items_blue_id_2] DEFAULT ((0)),
[blue1amount] [int] NULL CONSTRAINT [DF_char_items_phy_def] DEFAULT ((0)),
[blue2] [varchar](50) NULL CONSTRAINT [DF_char_items_mag_def] DEFAULT ((0)),
[blue2amount] [int] NULL CONSTRAINT [DF_char_items_block_ratio] DEFAULT ((0)),
[blue3] [varchar](50) NULL CONSTRAINT [DF_char_items_attack_ratio] DEFAULT ((0)),
[blue3amount] [int] NULL CONSTRAINT [DF_char_items_parry_ratio] DEFAULT ((0)),
[blue4] [varchar](50) NULL CONSTRAINT [DF_char_items_phy_attack] DEFAULT ((0)),
[blue4amount] [int] NULL CONSTRAINT [DF_char_items_mag_attack] DEFAULT ((0)),
[blue5] [varchar](50) NULL CONSTRAINT [DF_char_items_str_value] DEFAULT ((0)),
[blue5amount] [int] NULL CONSTRAINT [DF_char_items_int_value] DEFAULT ((0)),
[blue6] [varchar](50) NULL CONSTRAINT [DF_char_items_block_blue] DEFAULT ((0)),
[blue6amount] [int] NULL CONSTRAINT [DF_char_items_blue_immortal] DEFAULT ((0)),
[blue7] [varchar](50) NULL CONSTRAINT [DF_char_items_blue_repair] DEFAULT ((0)),
[blue7amount] [int] NULL CONSTRAINT [DF_char_items_blue_lucky] DEFAULT ((0)),
[blue8] [varchar](50) NULL CONSTRAINT [DF_char_items_blue_steady] DEFAULT ((0)),
[blue8amount] [int] NULL CONSTRAINT [DF_char_items_blue8amount] DEFAULT ((0)),
[blue9] [varchar](50) NULL CONSTRAINT [DF_char_items_blue9] DEFAULT ((0)),
[blue9amount] [int] NULL CONSTRAINT [DF_char_items_blue9amount] DEFAULT ((0)),
[storagetype] [int] NULL CONSTRAINT [DF_char_items_storagetype] DEFAULT ((0)),
[storageacc] [int] NULL CONSTRAINT [DF_char_items_storageacc] DEFAULT ((0)),
[modelid] [int] NULL CONSTRAINT [DF_char_items_modelid] DEFAULT ((0)),
[pet_storage_id] [int] NULL CONSTRAINT [DF_char_items_pet_storage_id] DEFAULT ((0)),
[charbound] [tinyint] NULL CONSTRAINT [DF_char_items_charbound] DEFAULT ((0)),
[guild_storage_id] [int] NULL CONSTRAINT [DF_char_items_guild_storage_id] 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].[friends] Script Date: 08/08/2011 17:03:51 ******/
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] [int] NULL,
[friend_name] [int] NULL,
[model_info] [int] NULL,
[group_name] [varchar](50) NULL CONSTRAINT [DF_friends_group_name] DEFAULT ('none')
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF/****** Object: Table [dbo].[friends_groups] Script Date: 08/08/2011 17:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[friends_groups](
[id] [int] IDENTITY(1,1) NOT NULL,
[playerid] [int] NULL,
[groupname] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF/****** Object: Table [dbo].[guild] Script Date: 08/08/2011 17:03:55 ******/
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,
[guild_storage_slots] [int] NULL CONSTRAINT [DF_guild_guild_storage_slots] DEFAULT ((0)),
[guild_war_gold_r] [int] NULL CONSTRAINT [DF_guild_guild_war_gold_r] DEFAULT ((0)),
[guild_master_id] [int] NULL,
[guild_icon] [varchar](50) NULL,
[guild_storage_gold] [bigint] NULL CONSTRAINT [DF_guild_guild_storage_gold] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF/****** Object: Table [dbo].[guild_members] Script Date: 08/08/2011 17:03:57 ******/
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_id] [int] NULL,
[guild_member_id] [int] NULL,
[guild_rank] [tinyint] NULL,
[guild_points] [int] NULL,
[guild_grant] [varchar](50) NULL,
[guild_fortress] [tinyint] NULL CONSTRAINT [DF_guild_members_guild_perm] DEFAULT ((0)),
[guild_perm_join] [tinyint] NULL CONSTRAINT [DF_guild_members_guild_perm_join] DEFAULT ((0)),
[guild_perm_withdraw] [tinyint] NULL CONSTRAINT [DF_guild_members_guild_perm_withdraw] DEFAULT ((0)),
[guild_perm_union] [tinyint] NULL CONSTRAINT [DF_guild_members_guild_perm_union] DEFAULT ((0)),
[guild_perm_storage] [tinyint] NULL CONSTRAINT [DF_guild_members_guild_perm_storage] DEFAULT ((0)),
[guild_perm_notice] [tinyint] NULL CONSTRAINT [DF_guild_members_guild_perm_notice] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF/****** Object: Table [dbo].[guild_storage] Script Date: 08/08/2011 17:03:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[guild_storage](
[id] [int] IDENTITY(1,1) NOT NULL,
[guildname] [varchar](50) NULL,
[itemid] [int] NULL CONSTRAINT [DF_guild_storage_itemid] DEFAULT ((0)),
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL CONSTRAINT [DF_guild_storage_plusvalue] DEFAULT ((0)),
[slot] [tinyint] NULL CONSTRAINT [DF_guild_storage_slot] DEFAULT ((0)),
[type] [tinyint] NULL CONSTRAINT [DF_guild_storage_type] DEFAULT ((0)),
[quantity] [smallint] NULL,
[durability] [int] NULL CONSTRAINT [DF_guild_storage_durability] DEFAULT ((0)),
[inavatar] [bigint] NULL CONSTRAINT [DF_guild_storage_inavatar] DEFAULT ((0)),
[BlueAmount] [int] NULL CONSTRAINT [DF_guild_storage_BlueAmount] DEFAULT ((0)),
[blue1] [int] NULL CONSTRAINT [DF_guild_storage_blue1] DEFAULT ((0)),
[blue1amount] [int] NULL CONSTRAINT [DF_guild_storage_blue1amount] DEFAULT ((0)),
[blue2] [int] NULL CONSTRAINT [DF_guild_storage_blue2] DEFAULT ((0)),
[blue2amount] [int] NULL CONSTRAINT [DF_guild_storage_blue2amount] DEFAULT ((0)),
[blue3] [int] NULL CONSTRAINT [DF_guild_storage_blue3] DEFAULT ((0)),
[blue3amount] [int] NULL CONSTRAINT [DF_guild_storage_blue3amount] DEFAULT ((0)),
[blue4] [int] NULL CONSTRAINT [DF_guild_storage_blue4] DEFAULT ((0)),
[blue4amount] [int] NULL CONSTRAINT [DF_guild_storage_blue4amount] DEFAULT ((0)),
[blue5] [int] NULL CONSTRAINT [DF_guild_storage_blue5] DEFAULT ((0)),
[blue5amount] [int] NULL CONSTRAINT [DF_guild_storage_blue5amount] DEFAULT ((0)),
[blue6] [int] NULL CONSTRAINT [DF_guild_storage_blue6] DEFAULT ((0)),
[blue6amount] [int] NULL CONSTRAINT [DF_guild_storage_blue6amount] DEFAULT ((0)),
[blue7] [int] NULL CONSTRAINT [DF_guild_storage_blue7] DEFAULT ((0)),
[blue7amount] [int] NULL CONSTRAINT [DF_guild_storage_blue7amount] DEFAULT ((0)),
[blue8] [int] NULL CONSTRAINT [DF_guild_storage_blue8] DEFAULT ((0)),
[blue8amount] [int] NULL CONSTRAINT [DF_guild_storage_blue8amount] DEFAULT ((0)),
[blue9] [int] NULL CONSTRAINT [DF_guild_storage_blue9] DEFAULT ((0)),
[blue9amount] [int] NULL CONSTRAINT [DF_guild_storage_blue9amount] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[guild_unions] Script Date: 08/08/2011 17:04:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[guild_unions](
[id] [int] IDENTITY(1,1) NOT NULL,
[union_leader] [int] NULL,
[union_guildid] [int] NULL,
[union_unique_id] [int] NULL CONSTRAINT [DF_guild_unions_union_unique_id] DEFAULT ((0))
) ON [PRIMARY]/****** Object: Table [dbo].[guild_war] Script Date: 08/08/2011 17:04:02 ******/
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: 08/08/2011 17:04:05 ******/
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: 08/08/2011 17:04:07 ******/
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: 08/08/2011 17:04:09 ******/
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: 08/08/2011 17:04:11 ******/
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 CONSTRAINT [DF_pets_pet_hp] DEFAULT ((0)),
[pet_hgp] [int] NULL CONSTRAINT [DF_pets_pet_hgp] DEFAULT ((0)),
[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)),
[pet_level] [tinyint] NULL CONSTRAINT [DF_pets_pet_level] DEFAULT ((1)),
[pet_experience] [bigint] NULL CONSTRAINT [DF_pets_pet_experience] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF/****** Object: Table [dbo].[rank_honor] Script Date: 08/08/2011 17:04:13 ******/
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: 08/08/2011 17:04:15 ******/
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: 08/08/2011 17:04:27 ******/
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: 08/08/2011 17:04:29 ******/
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: 08/08/2011 17:04:31 ******/
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].[settings] Script Date: 08/08/2011 17:04:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[settings](
[setname] [varchar](64) NOT NULL,
[setvalue] [varchar](2048) NULL,
CONSTRAINT [PK_settings] PRIMARY KEY CLUSTERED
(
[setname] 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: 08/28/2011 11:34:00 ******/
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,
[banreason] [varchar](50) NULL,
[ban] [int] NULL,
[silk] [int] NULL,
[gold] [bigint] NULL,
[checkinfo] [int] NULL CONSTRAINT [DF_users_check] DEFAULT ((0)),
[premsilk] [int] NULL CONSTRAINT [DF_users_premsilk] DEFAULT ((0)),
[jobtype] [tinyint] NULL CONSTRAINT [DF_users_jobtype] DEFAULT ((0)),
[warehouse_slots] [tinyint] NULL CONSTRAINT [DF_users_warehouse_slots] DEFAULT ((150)),
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
Quote:
Originally Posted by al3css
why you use SRx emulator? LOL! Use the official serverfiles..not this emulator anymore!
|
Bro not Easy To Use Offical Files On starting For the First Time


facebook.com\Mustafa.Morsi