· 7 years ago · Jan 03, 2019, 06:50 PM
1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USER_PERSONAL_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
2drop table [dbo].[USER_PERSONAL_RANK]
3GO
4
5CREATE TABLE [dbo].[USER_PERSONAL_RANK] (
6 [nRank] [smallint] NOT NULL ,
7 [strPosition] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
8 [nElmoUP] [smallint] NOT NULL ,
9 [strElmoUserID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
10 [nElmoLoyaltyMonthly] [int] NULL ,
11 [nElmoCheck] [int] NOT NULL ,
12 [nKarusUP] [smallint] NOT NULL ,
13 [strKarusUserID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
14 [nKarusLoyaltyMonthly] [int] NULL ,
15 [nKarusCheck] [int] NOT NULL ,
16 [nSalary] [int] NOT NULL ,
17 [UpdateDate] [smalldatetime] NOT NULL
18) ON [PRIMARY]
19GO
20
21insert into [user_personal_rank] values ('1','Gold Knight ','0','MrsKajuu ','18487','1000000','3','TheNewComboStyLee ','20109','1000000','1000000','2012-01-26 23:28:00');
22insert into [user_personal_rank] values ('2','Silver Knight ','2','KaJuu ','15730','700000','-1','Thief ','15173','700000','700000','2012-01-26 23:28:00');
23insert into [user_personal_rank] values ('3','Silver Knight ','0','SeHzaD3 ','15443','700000','0','MrsGuardNietzsche ','12856','700000','700000','2012-01-26 23:28:00');
24insert into [user_personal_rank] values ('4','Silver Knight ','2','DeepHoLe ','13187','700000','3','ibofiko ','12326','700000','700000','2012-01-26 23:28:00');
25insert into [user_personal_rank] values ('5','Mirage Knight ','-3','366 ','11525','500000','-3','MADC0NY0UUUU ','11674','500000','500000','2012-01-26 23:28:00');
26insert into [user_personal_rank] values ('6','Mirage Knight ','-1','DanqeR0 ','11112','500000','2','AnarChist ','11531','500000','500000','2012-01-26 23:28:00');
27insert into [user_personal_rank] values ('7','Mirage Knight ','7','HoooLiqaN ','8889','500000','-1','Nietzsche ','10881','500000','500000','2012-01-26 23:28:00');
28insert into [user_personal_rank] values ('8','Mirage Knight ','4','ForbiddenLover ','8700','500000','-3','ImParthFindeR ','9886','500000','500000','2012-01-26 23:28:00');
29insert into [user_personal_rank] values ('9','Mirage Knight ','4','D2K ','8647','500000','16','UsingDecroLest ','9260','500000','500000','2012-01-26 23:28:00');
30insert into [user_personal_rank] values ('10','Shadow Knight ','101','StymphaLos ','8366','300000','0','SancTuM ','8748','300000','300000','2012-01-26 23:28:00');
31insert into [user_personal_rank] values ('11','Shadow Knight ','-2','AiSeEuTePego ','7450','300000','26','Jr_styliest ','8597','300000','300000','2012-01-26 23:28:00');
32insert into [user_personal_rank] values ('12','Shadow Knight ','-4','IkiRyo ','7066','300000','30','UsingThronLest ','8558','300000','300000','2012-01-26 23:28:00');
33insert into [user_personal_rank] values ('13','Shadow Knight ','5','HooLiqaN ','6791','300000','27','EzuqmuSand1nAmq ','8554','300000','300000','2012-01-26 23:28:00');
34insert into [user_personal_rank] values ('14','Shadow Knight ','28','lDrowninqPooLl ','6585','300000','-2','UnforgivenFailed ','8110','300000','300000','2012-01-26 23:28:00');
35insert into [user_personal_rank] values ('15','Shadow Knight ','25','HyperioN ','6585','300000','37','UsingTabangLest ','7707','300000','300000','2012-01-26 23:28:00');
36insert into [user_personal_rank] values ('16','Shadow Knight ','-9','Super3H ','6455','300000','-7','lEdmondDantesl ','7650','300000','300000','2012-01-26 23:28:00');
37insert into [user_personal_rank] values ('17','Shadow Knight ','62','SorryForKilled ','6308','300000','4','4IChirqeFz ','6069','300000','300000','2012-01-26 23:28:00');
38insert into [user_personal_rank] values ('18','Shadow Knight ','79','Tompit ','6050','300000','33','WeezeR ','5619','300000','300000','2012-01-26 23:28:00');
39insert into [user_personal_rank] values ('19','Shadow Knight ','5','Lethaeus ','5730','300000','-4','ExceIIentBreaker ','5579','300000','300000','2012-01-26 23:28:00');
40insert into [user_personal_rank] values ('20','Shadow Knight ','-9','TheRebellious ','5635','300000','3','PASA ','5575','300000','300000','2012-01-26 23:28:00');
41insert into [user_personal_rank] values ('21','Shadow Knight ','-5','IDayLWaLkeRI ','5412','300000','43','H4PP3R ','5501','300000','300000','2012-01-26 23:28:00');
42insert into [user_personal_rank] values ('22','Shadow Knight ','-2','BurakYilmaz ','5391','300000','-5','ExcellentAsassian ','4812','300000','300000','2012-01-26 23:28:00');
43insert into [user_personal_rank] values ('23','Shadow Knight ','-8','JacManiuS ','5383','300000','-3','SystemError ','4583','300000','300000','2012-01-26 23:28:00');
44insert into [user_personal_rank] values ('24','Shadow Knight ','101','BaZaR0V ','5284','300000','4','qRice ','4448','300000','300000','2012-01-26 23:28:00');
45insert into [user_personal_rank] values ('25','Shadow Knight ','-8','4TacH ','5272','300000','-14','HarDPLayer ','4447','300000','300000','2012-01-26 23:28:00');
46insert into [user_personal_rank] values ('26','Mist Knight ','-16','Str0ngChild ','5236','200000','39','UsingFreeLest ','4411','200000','200000','2012-01-26 23:28:00');
47insert into [user_personal_rank] values ('27','Mist Knight ','-8','BogazinSerinSulari ','4999','200000','53','BirResimKalsinBizden ','4356','200000','200000','2012-01-26 23:28:00');
48insert into [user_personal_rank] values ('28','Mist Knight ','71','JavieReL ','4959','200000','4','lEdmondGoKaNl ','4294','200000','200000','2012-01-26 23:28:00');
49insert into [user_personal_rank] values ('29','Mist Knight ','-7','MrBaroo ','4841','200000','-15','4Spawn ','4234','200000','200000','2012-01-26 23:28:00');
50insert into [user_personal_rank] values ('30','Mist Knight ','-5','Theseus ','4707','200000','-12','Cry ','4231','200000','200000','2012-01-26 23:28:00');
51insert into [user_personal_rank] values ('31','Mist Knight ','19','BasicFruttaR ','4583','200000','-5','Winner ','4159','200000','200000','2012-01-26 23:28:00');
52insert into [user_personal_rank] values ('32','Mist Knight ','0','Lucky_Pearl ','4275','200000','-10','KafaNereyeBiz0raya ','4157','200000','200000','2012-01-26 23:28:00');
53insert into [user_personal_rank] values ('33','Mist Knight ','60','ReBeLLiouS ','4191','200000','12','lEdmondQw4yKel ','3863','200000','200000','2012-01-26 23:28:00');
54insert into [user_personal_rank] values ('34','Mist Knight ','101','NoBodyYourRepLaCesLe ','4174','200000','101','EKOOOOOOOOOOOOOOOOO ','3860','200000','200000','2012-01-26 23:28:00');
55insert into [user_personal_rank] values ('35','Mist Knight ','101','NightBoss ','4095','200000','-19','LyRio ','3783','200000','200000','2012-01-26 23:28:00');
56insert into [user_personal_rank] values ('36','Mist Knight ','-10','ByComboMach1ne ','3816','200000','101','TheRion ','3778','200000','200000','2012-01-26 23:28:00');
57insert into [user_personal_rank] values ('37','Mist Knight ','2','ARAGAN ','3724','200000','-18','IWhereDontSunShine ','3772','200000','200000','2012-01-26 23:28:00');
58insert into [user_personal_rank] values ('38','Mist Knight ','-9',';ChemShid_ ','3644','200000','-9','BLackEgoo ','3544','200000','200000','2012-01-26 23:28:00');
59insert into [user_personal_rank] values ('39','Mist Knight ','5','Jypn0 ','3636','200000','18','K4S1RG4 ','3441','200000','200000','2012-01-26 23:28:00');
60insert into [user_personal_rank] values ('40','Mist Knight ','-3','LuoMajian ','3574','200000','-9','lEdmondQuel ','3263','200000','200000','2012-01-26 23:28:00');
61insert into [user_personal_rank] values ('41','Mist Knight ','-20','ElaniapoLis ','3486','200000','-17','4PornContRoL ','3253','200000','200000','2012-01-26 23:28:00');
62insert into [user_personal_rank] values ('42','Mist Knight ','56','CREEEPY ','3415','200000','-8','Blue ','3237','200000','200000','2012-01-26 23:28:00');
63insert into [user_personal_rank] values ('43','Mist Knight ','-20','Pasha ','3404','200000','1','BGA ','3218','200000','200000','2012-01-26 23:28:00');
64insert into [user_personal_rank] values ('44','Mist Knight ','-1','TheChristina ','3383','200000','26','RequemForADream ','3197','200000','200000','2012-01-26 23:28:00');
65insert into [user_personal_rank] values ('45','Mist Knight ','101','IFAUST_DeJaVu ','3382','200000','-18','_4CHarLessPriesT ','3112','200000','200000','2012-01-26 23:28:00');
66insert into [user_personal_rank] values ('46','Mist Knight ','101','OC:DalmaBanaxD ','3361','200000','37','lEdmondSAm3TCaN ','3039','200000','200000','2012-01-26 23:28:00');
67insert into [user_personal_rank] values ('47','Mist Knight ','19','XacKerR ','3360','200000','16','nAsh ','2999','200000','200000','2012-01-26 23:28:00');
68insert into [user_personal_rank] values ('48','Mist Knight ','-12','deviantART ','3200','200000','28','ImPossible ','2912','200000','200000','2012-01-26 23:28:00');
69insert into [user_personal_rank] values ('49','Mist Knight ','8','XDSag0 ','3097','200000','101','NowamBalgamGibi ','2850','200000','200000','2012-01-26 23:28:00');
70insert into [user_personal_rank] values ('50','Mist Knight ','34','OC:ComeAndSee ','3089','200000','11','IWIRodRiqez ','2799','200000','200000','2012-01-26 23:28:00');
71insert into [user_personal_rank] values ('51','Training Knight ','35','4execPoxi0nS ','3070','0','-13','NativeBank ','2731','0','0','2012-01-26 23:28:00');
72insert into [user_personal_rank] values ('52','Training Knight ','-25','xSanderv4n ','3062','0','30','lEdmondWrinkLesl ','2713','0','0','2012-01-26 23:28:00');
73insert into [user_personal_rank] values ('53','Training Knight ','-25','HelalOlsun ','3042','0','-23','lEdmondJuvenl ','2670','0','0','2012-01-26 23:28:00');
74insert into [user_personal_rank] values ('54','Training Knight ','101','_SoIHaveToLookAtCutS ','2871','0','-21','WeUsDeLy ','2509','0','0','2012-01-26 23:28:00');
75insert into [user_personal_rank] values ('55','Training Knight ','-25','CaptainGaziTurk ','2868','0','-20','lEdmondHomel ','2440','0','0','2012-01-26 23:28:00');
76insert into [user_personal_rank] values ('56','Training Knight ','101','Stephan ','2854','0','6','IEdmondExpansionI ','2420','0','0','2012-01-26 23:28:00');
77insert into [user_personal_rank] values ('57','Training Knight ','101','Shoppiee ','2854','0','-21','WeUsHeartLoca_ ','2361','0','0','2012-01-26 23:28:00');
78insert into [user_personal_rank] values ('58','Training Knight ','101','DieFORme ','2825','0','101','c0ch0N ','2327','0','0','2012-01-26 23:28:00');
79insert into [user_personal_rank] values ('59','Training Knight ','-28','CaptainB3rK ','2792','0','-20','JuBa ','2296','0','0','2012-01-26 23:28:00');
80insert into [user_personal_rank] values ('60','Training Knight ','0','ILawienRose ','2766','0','-17','JackSparroW ','2284','0','0','2012-01-26 23:28:00');
81insert into [user_personal_rank] values ('61','Training Knight ','-28','ImJheWeyRoN ','2677','0','101','HudavendigaR ','2278','0','0','2012-01-26 23:28:00');
82insert into [user_personal_rank] values ('62','Training Knight ','-27','IamGaTTaR_ ','2608','0','101','Phantaso ','2191','0','0','2012-01-26 23:28:00');
83insert into [user_personal_rank] values ('63','Training Knight ','-29','YuKSeKSaDaKaT ','2598','0','-22','WeUsTertip ','2118','0','0','2012-01-26 23:28:00');
84insert into [user_personal_rank] values ('64','Training Knight ','101','MinorMachine ','2581','0','101','Terlik ','2072','0','0','2012-01-26 23:28:00');
85insert into [user_personal_rank] values ('65','Training Knight ','-27','CaptainCukulata ','2501','0','101','RiskYourLife ','1988','0','0','2012-01-26 23:28:00');
86insert into [user_personal_rank] values ('66','Training Knight ','101','Prof ','2462','0','-17','KinqShadoW_ ','1985','0','0','2012-01-26 23:28:00');
87insert into [user_personal_rank] values ('67','Training Knight ','-9','Super2H ','2423','0','101','ICokmuSaglamNe ','1970','0','0','2012-01-26 23:28:00');
88insert into [user_personal_rank] values ('68','Training Knight ','-27','CaptainlxHerKuLxl ','2397','0','101','ShowTime ','1931','0','0','2012-01-26 23:28:00');
89insert into [user_personal_rank] values ('69','Training Knight ','9','TimeIsBadKeepYourAss ','2378','0','101','lEdmondReadLyl ','1911','0','0','2012-01-26 23:28:00');
90insert into [user_personal_rank] values ('70','Training Knight ','1','StronqStarR ','2314','0','-22','EagleIsAlone ','1906','0','0','2012-01-26 23:28:00');
91insert into [user_personal_rank] values ('71','Training Knight ','101','LOSTTSOL ','2305','0','-18','4RedTubE ','1887','0','0','2012-01-26 23:28:00');
92insert into [user_personal_rank] values ('72','Training Knight ','101','GirayKacar ','2267','0','-26','FuckPussy ','1882','0','0','2012-01-26 23:28:00');
93insert into [user_personal_rank] values ('73','Training Knight ','101','Sky ','2252','0','-5','UnstapLess ','1855','0','0','2012-01-26 23:28:00');
94insert into [user_personal_rank] values ('74','Training Knight ','-29','QnLyRadierGummi ','2211','0','-27','WeUsScheyTan ','1840','0','0','2012-01-26 23:28:00');
95insert into [user_personal_rank] values ('75','Training Knight ','101','OC:VurucU ','2201','0','101','Ayakkabi ','1829','0','0','2012-01-26 23:28:00');
96insert into [user_personal_rank] values ('76','Training Knight ','-30','ImGuard_ ','2194','0','101','X_Jeavito ','1780','0','0','2012-01-26 23:28:00');
97insert into [user_personal_rank] values ('77','Training Knight ','-10','LegendaryLord ','2173','0','-27','4KeezMovies ','1777','0','0','2012-01-26 23:28:00');
98insert into [user_personal_rank] values ('78','Training Knight ','-31','ImLeTHeSuNSHiNe ','2153','0','-23','KafaNereyeBizORaya ','1769','0','0','2012-01-26 23:28:00');
99insert into [user_personal_rank] values ('79','Training Knight ','101','WannaRock ','2140','0','-23','WeUs3HarFLi ','1724','0','0','2012-01-26 23:28:00');
100insert into [user_personal_rank] values ('80','Training Knight ','101','Champi ','2130','0','101','4RoadRunner ','1715','0','0','2012-01-26 23:28:00');
101insert into [user_personal_rank] values ('81','Training Knight ','101','Homes1ck ','2122','0','101','ice23 ','1704','0','0','2012-01-26 23:28:00');
102insert into [user_personal_rank] values ('82','Training Knight ','-34','QnLyLeTHeSuNSHiNe ','2118','0','-28','_4CHarLessT0SUN ','1660','0','0','2012-01-26 23:28:00');
103insert into [user_personal_rank] values ('83','Training Knight ','-34','CaptainStrongDangr ','2057','0','-25','FireHq ','1584','0','0','2012-01-26 23:28:00');
104insert into [user_personal_rank] values ('84','Training Knight ','-22','LeqenDProKinQ ','2045','0','101','TheLosTAnGeL ','1560','0','0','2012-01-26 23:28:00');
105insert into [user_personal_rank] values ('85','Training Knight ','101','SirWhoCares ','1999','0','-26','lEdmondDusmaNGotuNe ','1557','0','0','2012-01-26 23:28:00');
106insert into [user_personal_rank] values ('86','Training Knight ','-35','QnLyShinobi ','1934','0','-26','_JuBa ','1532','0','0','2012-01-26 23:28:00');
107insert into [user_personal_rank] values ('87','Training Knight ','101','BOSS ','1905','0','101','::_BROWN_:: ','1520','0','0','2012-01-26 23:28:00');
108insert into [user_personal_rank] values ('88','Training Knight ','101','KalpSizPic10 ','1902','0','101','AzAp ','1512','0','0','2012-01-26 23:28:00');
109insert into [user_personal_rank] values ('89','Training Knight ','-26','Shempazeeeee ','1870','0','101','::_WHiTE_:: ','1392','0','0','2012-01-26 23:28:00');
110insert into [user_personal_rank] values ('90','Training Knight ','-38','aRoMaTiC ','1815','0','-23','4BrazzeRs ','1356','0','0','2012-01-26 23:28:00');
111insert into [user_personal_rank] values ('91','Training Knight ','-38','QnLyFLeaNCE ','1804','0','-25','ProMaqiCc ','1348','0','0','2012-01-26 23:28:00');
112insert into [user_personal_rank] values ('92','Training Knight ','-38','KiracI ','1794','0','-6','Coexistence ','1332','0','0','2012-01-26 23:28:00');
113insert into [user_personal_rank] values ('93','Training Knight ','101','DoNumDakiKoBra ','1753','0','-24','WeUsSpeeDyGonZaLeS ','1297','0','0','2012-01-26 23:28:00');
114insert into [user_personal_rank] values ('94','Training Knight ','101','LancelotPriest ','1749','0','101','CaRiSMaTr ','1285','0','0','2012-01-26 23:28:00');
115insert into [user_personal_rank] values ('95','Training Knight ','-39','MarshallBruceMaMy ','1747','0','101','TSK:lUnstoppablel ','1267','0','0','2012-01-26 23:28:00');
116insert into [user_personal_rank] values ('96','Training Knight ','-41','QnLyJiggaBunny ','1720','0','101','TSK:InciCaps ','1221','0','0','2012-01-26 23:28:00');
117insert into [user_personal_rank] values ('97','Training Knight ','-9','TheCycLone ','1675','0','101','BegMeForMercy ','1214','0','0','2012-01-26 23:28:00');
118insert into [user_personal_rank] values ('98','Training Knight ','101','IamMALKOCOGLU ','1661','0','-23','IIUzKII ','1206','0','0','2012-01-26 23:28:00');
119insert into [user_personal_rank] values ('99','Training Knight ','-19','IChristmaS ','1645','0','-28','WeUsMuRaT ','1198','0','0','2012-01-26 23:28:00');
120insert into [user_personal_rank] values ('100','Training Knight ','-41','CaptainJustPlay ','1632','0','-28','WeUsLAZREYIZ ','1198','0','0','2012-01-26 23:28:00');