kpiajwqM

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--kary
17
18CREATE TABLE IF NOT EXISTS `mlrpg_kary` (
19`kolejnosc` int(11) NOT NULL,
20  `serial` text NOT NULL,
21  `powod` text CHARACTER SET utf8 NOT NULL,
22  `czas` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
23  `typ` text NOT NULL,
24  `aktywny` tinyint(1) NOT NULL DEFAULT '1'
25) ENGINE=InnoDB AUTO_INCREMENT=5095 DEFAULT CHARSET=latin1;
26
27
28
29--bany
30
31CREATE TABLE IF NOT EXISTS `mlrpg_bany` (
32  `serial` text NOT NULL,
33  `powod` text NOT NULL,
34  `czas` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
35  `typ` text NOT NULL,
36  `aktywny` tinyint(1) NOT NULL DEFAULT '1',
37`id` int(255) NOT NULL
38) ENGINE=InnoDB AUTO_INCREMENT=984 DEFAULT CHARSET=latin1;
39
40--sluzby
41
42CREATE TABLE IF NOT EXISTS `mlrpg_sluzby` (
43`-` int(255) NOT NULL,
44  `sluzba` varchar(125) CHARACTER SET utf16 COLLATE utf16_polish_ci NOT NULL,
45  `dbid` int(11) NOT NULL,
46  `aktywny` date NOT NULL,
47  `ranga` int(5) NOT NULL DEFAULT '1'
48) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=latin1;
49
50--core
51
52CREATE TABLE IF NOT EXISTS `mlrpg_coreusers` (
53`dbid` int(11) NOT NULL,
54  `nazwauzytkownika` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
55  `haslo` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
56  `pieniadze` int(11) NOT NULL DEFAULT '0',
57  `pieniadze_bank` int(25) NOT NULL DEFAULT '0',
58  `skin` int(11) NOT NULL DEFAULT '0',
59  `weave` int(11) NOT NULL DEFAULT '50',
60  `punktyreputacji` int(11) NOT NULL DEFAULT '0',
61  `a_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
62  `b_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
63  `c_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
64  `l_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
65  `aktualnie_pracuje` int(11) NOT NULL DEFAULT '0',
66  `godziny_przegrane` int(12) NOT NULL,
67  `mandaty` int(10) NOT NULL DEFAULT '0',
68  `konto_administracyjne` int(10) NOT NULL DEFAULT '0',
69  `serial` varchar(120) DEFAULT NULL,
70  `wyciszony` tinyint(1) NOT NULL DEFAULT '0',
71  `kod` text NOT NULL
72) ENGINE=InnoDB AUTO_INCREMENT=2585 DEFAULT CHARSET=latin1 COMMENT='coreusers';
73
74
75---tuner
76
77CREATE TABLE IF NOT EXISTS `mlrpg_tuner` (
78`id` int(10) unsigned NOT NULL,
79  `descr` varchar(32) CHARACTER SET utf8,
80  `dbid_wlasciciela` int(10) unsigned DEFAULT NULL,
81  `koszt` int(5) unsigned NOT NULL,
82  `zaplaconedo` date DEFAULT NULL,
83  `aktualizacja` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '',
84  `aktywne` tinyint(3) unsigned NOT NULL DEFAULT '1'
85) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
86
87
88---system pojazdow
89
90CREATE TABLE IF NOT EXISTS `mlrpg_system_pojazdow` (
91`id` int(11) NOT NULL,
92  `model` int(11) NOT NULL DEFAULT,
93  `zamrozony` int(11) NOT NULL DEFAULT '0',
94  `pozycja` varchar(82) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
95  `tekst` text CHARACTER SET utf32 COLLATE utf32_polish_ci NOT NULL,
96  `zycie` int(11) NOT NULL,
97  `paliwo` int(11) NOT NULL,
98  `mileage` int(11) NOT NULL DEFAULT '0',
99  `ostatni_kierowca` text NOT NULL,
100  `kolor` varchar(50) NOT NULL DEFAULT '255, 255, 255',
101  `kolor_swiatel` varchar(41) NOT NULL DEFAULT '255, 255, 255',
102  `paintjob` tinyint(1) NOT NULL DEFAULT '3',
103  `tuning` text NOT NULL,
104  `wypozyczony` varchar(255) CHARACTER SET utf32 COLLATE utf32_bin DEFAULT '0',
105  `tekstnarejestracji` text NOT NULL,
106  `wlasciciel` int(11) NOT NULL DEFAULT '0',
107  `wlascicielorganizacja` varchar(111) NOT NULL,
108  `parking_policyjny` int(11) NOT NULL DEFAULT '0',
109  `neon` int(11) NOT NULL DEFAULT '0',
110  `blokada` text NOT NULL,
111  `zarejestrowany` varchar(10) NOT NULL DEFAULT 'true',
112  `tp_do_parkingu` varchar(99) DEFAULT NULL,
113  `rh` tinyint(1) NOT NULL DEFAULT '0',
114  `mk2` tinyint(1) NOT NULL DEFAULT '0',
115  `mk1` tinyint(1) NOT NULL DEFAULT '0',
116  `naped` tinyint(1) NOT NULL DEFAULT '0',
117  `silnik` text NOT NULL
118) ENGINE=InnoDB AUTO_INCREMENT=5198 DEFAULT CHARSET=latin1;
119
120
121
122ALTER TABLE `mlrpg_tuner`
123 ADD PRIMARY KEY (`id`), ADD KEY `dbid_wlasciciela` (`dbid_wlasciciela`);
124
125
126ALTER TABLE `mlrpg_bany`
127 ADD PRIMARY KEY (`dbid`);
128
129ALTER TABLE `mlrpg_sluzby`
130 ADD PRIMARY KEY (`-`), ADD KEY `sluzba` (`aktywny`);
131
132ALTER TABLE `mlrpg_kary`
133 ADD PRIMARY KEY (`kolejnosc`);
134
135ALTER TABLE `mlrpg_system_pojazdow`
136 ADD PRIMARY KEY (`dbid`);
137 
138 ALTER TABLE `mlrpg_coreusers`
139 ADD PRIMARY KEY (`dbid`);
140
141
142
143ALTER TABLE `mlrpg_tuner`
144MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=89;
145
146ALTER TABLE `mlrpg_bany`
147MODIFY `id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=984;
148 
149ALTER TABLE `mlrpg_coreusers`
150MODIFY `dbid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2585;
151
152ALTER TABLE `mlrpg_sluzby`
153MODIFY `-` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=194;
154
155
156ALTER TABLE `mlrpg_system_pojazdow`
157MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5198;
158/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
159/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
160/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;