| JanGanSRO |
28-08-2014 02:19 PM |
نفذ الامر دة علشان يعمل الجدول الخاص بالرانك اللى مربوط بالبرنامج
كود PHP:
USE [SHARD_HEAVY_TO]
GO
/****** Object: Table [dbo].[UniqueRanking] Script Date: 08/28/2014 13:17:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[UniqueRanking](
[CharName] [varchar](128) NOT NULL,
[Score] [int] NOT NULL,
[MOB_JUPITER_THE_EARTH1] [int] NOT NULL,
[MOB_RM_TAHOMET] [int] NOT NULL,
[MOB_KK_ISYUTARU] [int] NOT NULL,
[MOB_CH_TIGERWOMAN] [int] NOT NULL,
[MOB_AM_IVY_L3] [int] NOT NULL,
[MOB_EU_KERBEROS] [int] NOT NULL,
[MOB_AM_IVY] [int] NOT NULL,
[MOB_OA_URUCHI_L3] [int] NOT NULL,
[MOB_OA_URUCHI] [int] NOT NULL,
[MOB_JUPITER_JUPITER] [int] NOT NULL,
[MOB_JUPITER_YUNO] [int] NOT NULL,
[MOB_TK_BONELORD] [int] NOT NULL,
[MOB_RM_TAHOMET_L3] [int] NOT NULL,
[MOB_EV_WINTER_WHITEKNIGHT_20] [int] NOT NULL,
[MOB_JUPITER_BABILION] [int] NOT NULL,
[MOB_JUPITER_DARK_DOG] [int] NOT NULL,
[MOB_FW_MUJIGI_120] [int] NOT NULL,
[MOB_EU_KERBEROS_L3] [int] NOT NULL,
[MOB_CH_TIGERWOMAN_L3] [int] NOT NULL,
[MOB_KK_ISYUTARU_L3] [int] NOT NULL,
[MOB_TK_BONELORD_L3] [int] NOT NULL,
[MOB_FW_MUJIGI_135] [int] NOT NULL,
[MOB_TQ_BLACKSNAKE_L3] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_140] [int] NOT NULL,
[MOB_FW_TAESE_045] [int] NOT NULL,
[MOB_FW_TAESE_120] [int] NOT NULL,
[MOB_FW_TAESE_110] [int] NOT NULL,
[MOB_EV_WINTER_PRINCESS_100] [int] NOT NULL,
[MOB_FW_TAESE_001] [int] NOT NULL,
[MOB_SD_NEITH] [int] NOT NULL,
[MOB_SD_ISIS] [int] NOT NULL,
[MOB_TQ_WHITESNAKE] [int] NOT NULL,
[MOB_FW_TAESE_135] [int] NOT NULL,
[MOB_SD_SELKIS] [int] NOT NULL,
[MOB_EV_WINTER_WHITEKNIGHT_100] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_040] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_120] [int] NOT NULL,
[MOB_FW_TAESE_130] [int] NOT NULL,
[MOB_FW_TAESE_040] [int] NOT NULL,
[MOB_FW_TAESE_140] [int] NOT NULL,
[MOB_FW_TAESE_020] [int] NOT NULL,
[MOB_RM_SPIRITS_CLON] [int] NOT NULL,
[MOB_EV_WINTER_WHITEKNIGHT_80] [int] NOT NULL,
[MOB_FW_TAESE_111] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_020] [int] NOT NULL,
[MOB_FW_TAESE_005] [int] NOT NULL,
[MOB_FW_MUJIGI_130] [int] NOT NULL,
[MOB_FW_TAESE_003] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_100] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_108] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_109] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_104] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_105] [int] NOT NULL,
[MOB_FW_TAESE_010] [int] NOT NULL,
[MOB_FW_MUJIGI_010] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_130] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_041] [int] NOT NULL,
[MOB_EV_WINTER_PRINCESS_20] [int] NOT NULL,
[MOB_FW_TAESE_041] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_103] [int] NOT NULL,
[MOB_FW_TAESE_065] [int] NOT NULL,
[MOB_FW_TAESE_077] [int] NOT NULL,
[MOB_FW_TAESE_102] [int] NOT NULL,
[MOB_FW_TAESE_103] [int] NOT NULL,
[MOB_FW_TAESE_100] [int] NOT NULL,
[MOB_FW_MUJIGI_005] [int] NOT NULL,
[MOB_FW_TAESE_105] [int] NOT NULL,
[MOB_FW_TAESE_080] [int] NOT NULL,
[MOB_RM_SPIRITS_CLON3] [int] NOT NULL,
[MOB_RM_SPIRITS_CLON2] [int] NOT NULL,
[MOB_RM_SPIRITS] [int] NOT NULL,
[MOB_CREDDY_VOLKOFF] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA4] [int] NOT NULL,
[MOB_ARABIA_GIANT_DEMON] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA5] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA2] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA1] [int] NOT NULL,
[MOB_ARABIA_KIDEMONAS] [int] NOT NULL,
[MOB_CREDDY_WOLVERINE] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_001] [int] NOT NULL,
[MOB_FW_MUJIGI_001] [int] NOT NULL,
[MOB_RM_BONEROC] [int] NOT NULL,
[MOB_ARABIA_VENEFICA_DEMON] [int] NOT NULL,
[MOB_RM_ROC] [int] NOT NULL,
[MOB_ARABIA_THIEF_BOSS] [int] NOT NULL,
[MOB_MAG_1ROC] [int] NOT NULL,
[MOB_GOD_GHOST_UNDINE_B1] [int] NOT NULL,
[MOB_FW_MUJIGI_050] [int] NOT NULL,
[MOB_SD_HAROERIS] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA3] [int] NOT NULL,
[MOB_PHY_2ROC] [int] NOT NULL,
[MOB_SD_ANUBIS] [int] NOT NULL,
[MOB_SD_SETH] [int] NOT NULL,
[MOB_JUPITER_BAAL] [int] NOT NULL,
[MOB_EV_WINTER_PRINCESS_90] [int] NOT NULL,
[MOB_EV_WINTER_WHITEKNIGHT_90] [int] NOT NULL,
[MOB_AM_IVY_L2] [int] NOT NULL,
[MOB_NEW_UNIQUE_INT] [int] NOT NULL,
[MOB_NEW_UNIQUE_STR] [int] NOT NULL,
[MOB_ARABIA_MAD_GENERAL] [int] NOT NULL,
[MOB_CH_TIGERWOMAN_L2] [int] NOT NULL,
[MOB_ARABIA_LAUNATUNE] [int] NOT NULL,
[MOB_FW_MUJIGI_020] [int] NOT NULL,
[MOB_FW_MUJIGI_025] [int] NOT NULL,
[MOB_FW_MUJIGI_015] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_010] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_050] [int] NOT NULL,
[MOB_FW_MUJIGI_040] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_030] [int] NOT NULL,
[MOB_FW_MUJIGI_030] [int] NOT NULL,
[MOB_CH_MANGNYANG_EVIL] [int] NOT NULL,
[MOB_GOD_GHOST_UNDINE_B4] [int] NOT NULL,
[MOB_JOB_TAMPLE] [int] NOT NULL,
[MOB_ARABIA_GARDEN1] [int] NOT NULL,
[MOB_ARABIA_GARDEN2] [int] NOT NULL,
[MOB_ARABIA_GARDEN3] [int] NOT NULL,
[MOB_ARABIA_GEENIE] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_015] [int] NOT NULL,
[MOB_FW_MUJIGI_002] [int] NOT NULL,
[MOB_RM_TAHOMET_L2] [int] NOT NULL,
[MOB_PHY_1ANUPIS] [int] NOT NULL,
[MOB_PHY_1ISIS] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_Score] DEFAULT ((0)) FOR [Score]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_THE_EARTH1] DEFAULT ((0)) FOR [MOB_JUPITER_THE_EARTH1]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_TAHOMET] DEFAULT ((0)) FOR [MOB_RM_TAHOMET]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_KK_ISYUTARU] DEFAULT ((0)) FOR [MOB_KK_ISYUTARU]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CH_TIGERWOMAN] DEFAULT ((0)) FOR [MOB_CH_TIGERWOMAN]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_AM_IVY_L3] DEFAULT ((0)) FOR [MOB_AM_IVY_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EU_KERBEROS] DEFAULT ((0)) FOR [MOB_EU_KERBEROS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_AM_IVY] DEFAULT ((0)) FOR [MOB_AM_IVY]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_OA_URUCHI_L3] DEFAULT ((0)) FOR [MOB_OA_URUCHI_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_OA_URUCHI] DEFAULT ((0)) FOR [MOB_OA_URUCHI]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_JUPITER] DEFAULT ((0)) FOR [MOB_JUPITER_JUPITER]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_YUNO] DEFAULT ((0)) FOR [MOB_JUPITER_YUNO]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_TK_BONELORD] DEFAULT ((0)) FOR [MOB_TK_BONELORD]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_TAHOMET_L3] DEFAULT ((0)) FOR [MOB_RM_TAHOMET_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_20] DEFAULT ((0)) FOR [MOB_EV_WINTER_WHITEKNIGHT_20]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_BABILION] DEFAULT ((0)) FOR [MOB_JUPITER_BABILION]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_DARK_DOG] DEFAULT ((0)) FOR [MOB_JUPITER_DARK_DOG]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_120] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_120]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EU_KERBEROS_L3] DEFAULT ((0)) FOR [MOB_EU_KERBEROS_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CH_TIGERWOMAN_L3] DEFAULT ((0)) FOR [MOB_CH_TIGERWOMAN_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_KK_ISYUTARU_L3] DEFAULT ((0)) FOR [MOB_KK_ISYUTARU_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_TK_BONELORD_L3] DEFAULT ((0)) FOR [MOB_TK_BONELORD_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_135] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_135]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_TQ_BLACKSNAKE_L3] DEFAULT ((0)) FOR [MOB_TQ_BLACKSNAKE_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_140] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_140]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_045] DEFAULT ((0)) FOR [MOB_FW_TAESE_045]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_120] DEFAULT ((0)) FOR [MOB_FW_TAESE_120]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_110] DEFAULT ((0)) FOR [MOB_FW_TAESE_110]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_PRINCESS_100] DEFAULT ((0)) FOR [MOB_EV_WINTER_PRINCESS_100]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_001] DEFAULT ((0)) FOR [MOB_FW_TAESE_001]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_NEITH] DEFAULT ((0)) FOR [MOB_SD_NEITH]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_ISIS] DEFAULT ((0)) FOR [MOB_SD_ISIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_TQ_WHITESNAKE] DEFAULT ((0)) FOR [MOB_TQ_WHITESNAKE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_135] DEFAULT ((0)) FOR [MOB_FW_TAESE_135]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_SELKIS] DEFAULT ((0)) FOR [MOB_SD_SELKIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_100] DEFAULT ((0)) FOR [MOB_EV_WINTER_WHITEKNIGHT_100]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_040] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_040]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_120] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_120]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_130] DEFAULT ((0)) FOR [MOB_FW_TAESE_130]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_040] DEFAULT ((0)) FOR [MOB_FW_TAESE_040]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_140] DEFAULT ((0)) FOR [MOB_FW_TAESE_140]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_020] DEFAULT ((0)) FOR [MOB_FW_TAESE_020]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON] DEFAULT ((0)) FOR [MOB_RM_SPIRITS_CLON]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_80] DEFAULT ((0)) FOR [MOB_EV_WINTER_WHITEKNIGHT_80]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_111] DEFAULT ((0)) FOR [MOB_FW_TAESE_111]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_020] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_020]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_005] DEFAULT ((0)) FOR [MOB_FW_TAESE_005]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_130] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_130]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_003] DEFAULT ((0)) FOR [MOB_FW_TAESE_003]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_100] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_100]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_108] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_108]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_109] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_109]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_104] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_104]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_105] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_105]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_010] DEFAULT ((0)) FOR [MOB_FW_TAESE_010]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_010] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_010]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_130] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_130]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_041] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_041]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_PRINCESS_20] DEFAULT ((0)) FOR [MOB_EV_WINTER_PRINCESS_20]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_041] DEFAULT ((0)) FOR [MOB_FW_TAESE_041]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_103] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_103]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_065] DEFAULT ((0)) FOR [MOB_FW_TAESE_065]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_077] DEFAULT ((0)) FOR [MOB_FW_TAESE_077]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_102] DEFAULT ((0)) FOR [MOB_FW_TAESE_102]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_103] DEFAULT ((0)) FOR [MOB_FW_TAESE_103]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_100] DEFAULT ((0)) FOR [MOB_FW_TAESE_100]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_005] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_005]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_105] DEFAULT ((0)) FOR [MOB_FW_TAESE_105]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_080] DEFAULT ((0)) FOR [MOB_FW_TAESE_080]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON3] DEFAULT ((0)) FOR [MOB_RM_SPIRITS_CLON3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON2] DEFAULT ((0)) FOR [MOB_RM_SPIRITS_CLON2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS] DEFAULT ((0)) FOR [MOB_RM_SPIRITS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CREDDY_VOLKOFF] DEFAULT ((0)) FOR [MOB_CREDDY_VOLKOFF]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA4] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA4]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GIANT_DEMON] DEFAULT ((0)) FOR [MOB_ARABIA_GIANT_DEMON]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA5] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA5]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA2] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA1] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA1]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_KIDEMONAS] DEFAULT ((0)) FOR [MOB_ARABIA_KIDEMONAS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CREDDY_WOLVERINE] DEFAULT ((0)) FOR [MOB_CREDDY_WOLVERINE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_001] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_001]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_001] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_001]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_BONEROC] DEFAULT ((0)) FOR [MOB_RM_BONEROC]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_VENEFICA_DEMON] DEFAULT ((0)) FOR [MOB_ARABIA_VENEFICA_DEMON]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_ROC] DEFAULT ((0)) FOR [MOB_RM_ROC]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_THIEF_BOSS] DEFAULT ((0)) FOR [MOB_ARABIA_THIEF_BOSS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_MAG_1ROC] DEFAULT ((0)) FOR [MOB_MAG_1ROC]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_GOD_GHOST_UNDINE_B1] DEFAULT ((0)) FOR [MOB_GOD_GHOST_UNDINE_B1]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_050] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_050]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_HAROERIS] DEFAULT ((0)) FOR [MOB_SD_HAROERIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA3] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_PHY_2ROC] DEFAULT ((0)) FOR [MOB_PHY_2ROC]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_ANUBIS] DEFAULT ((0)) FOR [MOB_SD_ANUBIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_SETH] DEFAULT ((0)) FOR [MOB_SD_SETH]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_BAAL] DEFAULT ((0)) FOR [MOB_JUPITER_BAAL]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_PRINCESS_90] DEFAULT ((0)) FOR [MOB_EV_WINTER_PRINCESS_90]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_90] DEFAULT ((0)) FOR [MOB_EV_WINTER_WHITEKNIGHT_90]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_AM_IVY_L2] DEFAULT ((0)) FOR [MOB_AM_IVY_L2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_NEW_UNIQUE_INT] DEFAULT ((0)) FOR [MOB_NEW_UNIQUE_INT]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_NEW_UNIQUE_STR] DEFAULT ((0)) FOR [MOB_NEW_UNIQUE_STR]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MAD_GENERAL] DEFAULT ((0)) FOR [MOB_ARABIA_MAD_GENERAL]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CH_TIGERWOMAN_L2] DEFAULT ((0)) FOR [MOB_CH_TIGERWOMAN_L2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_LAUNATUNE] DEFAULT ((0)) FOR [MOB_ARABIA_LAUNATUNE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_020] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_020]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_025] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_025]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_015] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_015]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_010] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_010]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_050] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_050]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_040] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_040]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_030] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_030]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_030] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_030]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CH_MANGNYANG_EVIL] DEFAULT ((0)) FOR [MOB_CH_MANGNYANG_EVIL]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_GOD_GHOST_UNDINE_B4] DEFAULT ((0)) FOR [MOB_GOD_GHOST_UNDINE_B4]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JOB_TAMPLE] DEFAULT ((0)) FOR [MOB_JOB_TAMPLE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GARDEN1] DEFAULT ((0)) FOR [MOB_ARABIA_GARDEN1]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GARDEN2] DEFAULT ((0)) FOR [MOB_ARABIA_GARDEN2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GARDEN3] DEFAULT ((0)) FOR [MOB_ARABIA_GARDEN3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GEENIE] DEFAULT ((0)) FOR [MOB_ARABIA_GEENIE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_015] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_015]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_002] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_002]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_TAHOMET_L2] DEFAULT ((0)) FOR [MOB_RM_TAHOMET_L2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_PHY_1ANUPIS] DEFAULT ((0)) FOR [MOB_PHY_1ANUPIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_PHY_1ISIS] DEFAULT ((0)) FOR [MOB_PHY_1ISIS]
GO
و الامر دة كمان
كود PHP:
USE [SHARD_HEAVY_TO]
GO
/****** Object: Table [dbo].[UniqueKills] Script Date: 08/28/2014 13:24:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[UniqueKills](
[CharName16] [varchar](20) NOT NULL,
[Monster] [varchar](50) NOT NULL,
[Timestamp] [varchar](12) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
|
