· 8 years ago · Aug 20, 2018, 09:34 PM
1CREATE TABLE IF NOT EXISTS korisnici(
2ID INT NOT NULL AUTO_INCREMENT,
3pe_ImeIgraca VARCHAR(32),
4pe_Lozinka VARCHAR(32),
5pe_Spol VARCHAR(32),
6pe_Porijeklo VARCHAR(32),
7pe_Godine INT NOT NULL,
8pe_Mail VARCHAR(32),
9pe_Level INT NOT NULL,
10pe_Skin INT NOT NULL,
11pe_Novac INT NOT NULL,
12pe_SatiIgre INT NOT NULL,
13pe_OrgSkin INT NOT NULL,
14pe_GameAdmin INT NOT NULL,
15pe_GameMaster INT NOT NULL,
16pe_AKod INT NOT NULL,
17pe_OruzjeSkil INT NOT NULL,
18pe_MoraCitat INT NOT NULL,
19pe_Hladno INT NOT NULL,
20pe_Utisan INT NOT NULL,
21pe_Lider INT NOT NULL,
22pe_Rank INT NOT NULL,
23pe_Organizacija INT NOT NULL,
24pe_Clan INT NOT NULL,
25pe_Materijali INT NOT NULL,
26pe_Skil INT NOT NULL,
27pe_Kazna INT NOT NULL,
28pe_SkillTAXI INT NOT NULL,
29pe_SkillKOSAC INT NOT NULL,
30pe_SkillBOLNICAR INT NOT NULL,
31pe_SkillMEH INT NOT NULL,
32pe_SkillVATRO INT NOT NULL,
33pe_SkillFARM INT NOT NULL,
34pe_SkillSMET INT NOT NULL,
35pe_SkillMLEKAR INT NOT NULL,
36pe_SkillRIBAR INT NOT NULL,
37pe_Droga INT NOT NULL,
38pe_Oruzje1 INT NOT NULL,
39pe_Oruzje2 INT NOT NULL,
40pe_Oruzje3 INT NOT NULL,
41pe_Oruzje4 INT NOT NULL,
42pe_Oruzje5 INT NOT NULL,
43pe_Metkovi1 INT NOT NULL,
44pe_Metkovi2 INT NOT NULL,
45pe_Metkovi3 INT NOT NULL,
46pe_Metkovi4 INT NOT NULL,
47pe_Metkovi5 INT NOT NULL,
48pe_OruzjeDoz INT NOT NULL,
49pe_PajDajovi INT NOT NULL,
50pe_Skinovi0 INT NOT NULL,
51pe_Skinovi1 INT NOT NULL,
52pe_Skinovi2 INT NOT NULL,
53pe_Skinovi3 INT NOT NULL,
54pe_Skinovi4 INT NOT NULL,
55pe_Skinovi5 INT NOT NULL,
56pe_Skinovi6 INT NOT NULL,
57pe_Skinovi7 INT NOT NULL,
58pe_Skinovi8 INT NOT NULL,
59pe_Skinovi9 INT NOT NULL,
60pe_Skinovi10 INT NOT NULL,
61pe_Skinovi11 INT NOT NULL,
62pe_PajDajovi1 INT NOT NULL,
63pe_MogucnostPKuce INT NOT NULL,
64pe_GradRank INT NOT NULL,
65pe_StrankaRank INT NOT NULL,
66pe_Zica INT NOT NULL,
67pe_BrojNews INT NOT NULL,
68pe_Kaciga INT NOT NULL,
69pe_VlasnikIRC INT NOT NULL,
70pe_VokiToki INT NOT NULL,
71pe_RadioB INT NOT NULL,
72pe_Ubijen INT NOT NULL,
73pe_Banovan INT NOT NULL,
74pe_VoziloKljuc INT NOT NULL,
75pe_VoziloKljuc2 INT NOT NULL,
76pe_VoziloKljuc3 INT NOT NULL,
77pe_KucaKljuc INT NOT NULL,
78pe_Wanted INT NOT NULL,
79pe_PljackaVreme INT NOT NULL,
80pe_BStil INT NOT NULL,
81pe_Marama INT NOT NULL,
82pe_Naocare INT NOT NULL,
83pe_EventUbistva INT NOT NULL,
84pe_EventSmrti INT NOT NULL,
85pe_EPrvoMesto INT NOT NULL,
86pe_EDrgoMesto INT NOT NULL,
87pe_ETreceMesto INT NOT NULL,
88pe_GKartica INT NOT NULL,
89pe_StanKljuc INT NOT NULL,
90pe_MotorKljuc INT NOT NULL,
91pe_MotorKljuc2 INT NOT NULL,
92pe_Uzatvoru INT NOT NULL,
93pe_UzatvoruVreme INT NOT NULL,
94pe_FirmaKljuc INT NOT NULL,
95pe_Sat INT NOT NULL,
96pe_Mobitel INT NOT NULL,
97pe_MobKredit INT NOT NULL,
98pe_Imenik INT NOT NULL,
99pe_Cigare INT NOT NULL,
100pe_Upaljac INT NOT NULL,
101pe_Povez INT NOT NULL,
102pe_Traka INT NOT NULL,
103pe_Kanap INT NOT NULL,
104pe_LetjelicaKljuc INT NOT NULL,
105pe_PloviloKljuc INT NOT NULL,
106pe_BiciklaKljuc INT NOT NULL,
107pe_LSD INT NOT NULL,
108pe_SjemeLSD INT NOT NULL,
109pe_PreradjevinaLSD INT NOT NULL,
110pe_PreradjevinaKoka INT NOT NULL,
111pe_Marihuana INT NOT NULL,
112pe_SjemeMarihuana INT NOT NULL,
113pe_Kokain INT NOT NULL,
114pe_SjemeKokain INT NOT NULL,
115pe_Maska INT NOT NULL,
116pe_Upozorenja INT NOT NULL,
117pe_BankaRacun INT NOT NULL,
118pe_NovacBanka INT NOT NULL,
119pe_Kredit INT NOT NULL,
120pe_IznosRate INT NOT NULL,
121pe_Exp INT NOT NULL,
122pe_Minute INT NOT NULL,
123pe_Posao INT NOT NULL,
124pe_Spawn INT NOT NULL,
125pe_PDSpawn INT NOT NULL,
126pe_OrgUgovor INT NOT NULL,
127pe_HotelKljuc INT NOT NULL,
128pe_VremePolaganje INT NOT NULL,
129pe_Marker1X DOUBLE NOT NULL,
130pe_Marker1Y DOUBLE NOT NULL,
131pe_Marker1Z DOUBLE NOT NULL,
132pe_BTime INT NOT NULL,
133pe_BTill INT NOT NULL,
134pe_Vozacka INT NOT NULL,
135pe_Motorska INT NOT NULL,
136pe_KamionskaC1 INT NOT NULL,
137pe_KamionskaC2 INT NOT NULL,
138pe_KamionskaC3 INT NOT NULL,
139pe_Brodska INT NOT NULL,
140pe_Letelica INT NOT NULL,
141pe_VikendicaKljuc INT NOT NULL,
142pe_Donator INT NOT NULL,
143pe_DonatorBodovi INT NOT NULL,
144PRIMARY KEY(`ID`)
145) ENGINE=InnoDB DEFAULT CHARSET=utf8