UGZJKTyS

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4
5/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
6/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
7/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
8/*!40101 SET NAMES utf8 */;
9
10
11--
12--- baza danych mtalife
13--
14
15
16
17CREATE TABLE IF NOT EXISTS `mlrpg_coreusers` (
18`dbid` int(11) NOT NULL,
19  `nazwauzytkownika` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
20  `haslo` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
21  `pieniadze` int(11) NOT NULL DEFAULT '0',
22  `pieniadze_bank` int(25) NOT NULL DEFAULT '0',
23  `skin` int(11) NOT NULL DEFAULT '0',
24  `weave` int(11) NOT NULL DEFAULT '50',
25  `punktyreputacji` int(11) NOT NULL DEFAULT '0',
26  `a_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
27  `b_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
28  `c_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
29  `l_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
30  `aktualnie_pracuje` int(11) NOT NULL DEFAULT '0',
31  `godziny_przegrane` int(12) NOT NULL,
32  `mandaty` int(10) NOT NULL DEFAULT '0',
33  `konto_administracyjne` int(10) NOT NULL DEFAULT '0',
34  `serial` varchar(120) DEFAULT NULL,
35  `wyciszony` tinyint(1) NOT NULL DEFAULT '0',
36  `kod` text NOT NULL
37) ENGINE=InnoDB AUTO_INCREMENT=2585 DEFAULT CHARSET=latin1 COMMENT='coreusers';
38
39
40---tuner
41
42CREATE TABLE IF NOT EXISTS `mlrpg_tuner` (
43`id` int(10) unsigned NOT NULL,
44  `descr` varchar(32) CHARACTER SET utf8,
45  `dbid_wlasciciela` int(10) unsigned DEFAULT NULL,
46  `koszt` int(5) unsigned NOT NULL,
47  `zaplaconedo` date DEFAULT NULL,
48  `aktualizacja` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '',
49  `aktywne` tinyint(3) unsigned NOT NULL DEFAULT '1'
50) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
51
52
53---system pojazdow
54
55CREATE TABLE IF NOT EXISTS `mlrpg_system_pojazdow` (
56`id` int(11) NOT NULL,
57  `model` int(11) NOT NULL DEFAULT,
58  `zamrozony` int(11) NOT NULL DEFAULT '0',
59  `pozycja` varchar(82) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
60  `tekst` text CHARACTER SET utf32 COLLATE utf32_polish_ci NOT NULL,
61  `zycie` int(11) NOT NULL,
62  `paliwo` int(11) NOT NULL,
63  `mileage` int(11) NOT NULL DEFAULT '0',
64  `ostatni_kierowca` text NOT NULL,
65  `kolor` varchar(50) NOT NULL DEFAULT '255, 255, 255',
66  `kolor_swiatel` varchar(41) NOT NULL DEFAULT '255, 255, 255',
67  `paintjob` tinyint(1) NOT NULL DEFAULT '3',
68  `tuning` text NOT NULL,
69  `wypozyczony` varchar(255) CHARACTER SET utf32 COLLATE utf32_bin DEFAULT '0',
70  `tekstnarejestracji` text NOT NULL,
71  `wlasciciel` int(11) NOT NULL DEFAULT '0',
72  `wlascicielorganizacja` varchar(111) NOT NULL,
73  `parking_policyjny` int(11) NOT NULL DEFAULT '0',
74  `neon` int(11) NOT NULL DEFAULT '0',
75  `blokada` text NOT NULL,
76  `zarejestrowany` varchar(10) NOT NULL DEFAULT 'true',
77  `tp_do_parkingu` varchar(99) DEFAULT NULL,
78  `rh` tinyint(1) NOT NULL DEFAULT '0',
79  `mk2` tinyint(1) NOT NULL DEFAULT '0',
80  `mk1` tinyint(1) NOT NULL DEFAULT '0',
81  `naped` tinyint(1) NOT NULL DEFAULT '0',
82  `silnik` text NOT NULL
83) ENGINE=InnoDB AUTO_INCREMENT=5198 DEFAULT CHARSET=latin1;
84
85
86
87ALTER TABLE `mlrpg_tuner`
88 ADD PRIMARY KEY (`id`), ADD KEY `dbid_wlasciciela` (`dbid_wlasciciela`);
89
90
91ALTER TABLE `mlrpg_bany`
92 ADD PRIMARY KEY (`dbid`);
93
94ALTER TABLE `mlrpg_sluzby`
95 ADD PRIMARY KEY (`-`), ADD KEY `code` (`actived`);
96
97ALTER TABLE `mlrpg_kary`
98 ADD PRIMARY KEY (`kolejnosc`);
99
100ALTER TABLE `mlrpg_system_pojazdow`
101 ADD PRIMARY KEY (`dbid`);
102 
103 ALTER TABLE `mlrpg_coreusers`
104 ADD PRIMARY KEY (`dbid`);
105
106
107
108ALTER TABLE `mlrpg_tuner`
109MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=89;
110
111ALTER TABLE `mlrpg_bany`
112MODIFY `dbid` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=984;
113 
114ALTER TABLE `mlrpg_coreusers`
115MODIFY `dbid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2585;
116
117ALTER TABLE `mlrpg_sluzby`
118MODIFY `-` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=194;
119
120
121ALTER TABLE `mlrpg_system_pojazdow`
122MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5198;
123/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
124/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
125/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;