SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;


--
--- baza danych mtalife
--



CREATE TABLE IF NOT EXISTS `mlrpg_coreusers` (
`dbid` int(11) NOT NULL,
  `nazwauzytkownika` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
  `haslo` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
  `pieniadze` int(11) NOT NULL DEFAULT '0',
  `pieniadze_bank` int(25) NOT NULL DEFAULT '0',
  `skin` int(11) NOT NULL DEFAULT '0',
  `weave` int(11) NOT NULL DEFAULT '50',
  `punktyreputacji` int(11) NOT NULL DEFAULT '0',
  `a_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
  `b_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
  `c_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
  `l_prawo_jazdy` int(11) NOT NULL DEFAULT '0',
  `aktualnie_pracuje` int(11) NOT NULL DEFAULT '0',
  `godziny_przegrane` int(12) NOT NULL,
  `mandaty` int(10) NOT NULL DEFAULT '0',
  `konto_administracyjne` int(10) NOT NULL DEFAULT '0',
  `serial` varchar(120) DEFAULT NULL,
  `wyciszony` tinyint(1) NOT NULL DEFAULT '0',
  `kod` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2585 DEFAULT CHARSET=latin1 COMMENT='coreusers';


---tuner

CREATE TABLE IF NOT EXISTS `mlrpg_tuner` (
`id` int(10) unsigned NOT NULL,
  `descr` varchar(32) CHARACTER SET utf8,
  `dbid_wlasciciela` int(10) unsigned DEFAULT NULL,
  `koszt` int(5) unsigned NOT NULL,
  `zaplaconedo` date DEFAULT NULL,
  `aktualizacja` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '',
  `aktywne` tinyint(3) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;


---system pojazdow

CREATE TABLE IF NOT EXISTS `mlrpg_system_pojazdow` (
`id` int(11) NOT NULL,
  `model` int(11) NOT NULL DEFAULT,
  `zamrozony` int(11) NOT NULL DEFAULT '0',
  `pozycja` varchar(82) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
  `tekst` text CHARACTER SET utf32 COLLATE utf32_polish_ci NOT NULL,
  `zycie` int(11) NOT NULL,
  `paliwo` int(11) NOT NULL,
  `mileage` int(11) NOT NULL DEFAULT '0',
  `ostatni_kierowca` text NOT NULL,
  `kolor` varchar(50) NOT NULL DEFAULT '255, 255, 255',
  `kolor_swiatel` varchar(41) NOT NULL DEFAULT '255, 255, 255',
  `paintjob` tinyint(1) NOT NULL DEFAULT '3',
  `tuning` text NOT NULL,
  `wypozyczony` varchar(255) CHARACTER SET utf32 COLLATE utf32_bin DEFAULT '0',
  `tekstnarejestracji` text NOT NULL,
  `wlasciciel` int(11) NOT NULL DEFAULT '0',
  `wlascicielorganizacja` varchar(111) NOT NULL,
  `parking_policyjny` int(11) NOT NULL DEFAULT '0',
  `neon` int(11) NOT NULL DEFAULT '0',
  `blokada` text NOT NULL,
  `zarejestrowany` varchar(10) NOT NULL DEFAULT 'true',
  `tp_do_parkingu` varchar(99) DEFAULT NULL,
  `rh` tinyint(1) NOT NULL DEFAULT '0',
  `mk2` tinyint(1) NOT NULL DEFAULT '0',
  `mk1` tinyint(1) NOT NULL DEFAULT '0',
  `naped` tinyint(1) NOT NULL DEFAULT '0',
  `silnik` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5198 DEFAULT CHARSET=latin1;



ALTER TABLE `mlrpg_tuner`
 ADD PRIMARY KEY (`id`), ADD KEY `dbid_wlasciciela` (`dbid_wlasciciela`);


ALTER TABLE `mlrpg_bany`
 ADD PRIMARY KEY (`dbid`);

ALTER TABLE `mlrpg_sluzby`
 ADD PRIMARY KEY (`-`), ADD KEY `code` (`actived`);

ALTER TABLE `mlrpg_kary`
 ADD PRIMARY KEY (`kolejnosc`);

ALTER TABLE `mlrpg_system_pojazdow`
 ADD PRIMARY KEY (`dbid`);

 ALTER TABLE `mlrpg_coreusers`
 ADD PRIMARY KEY (`dbid`);



ALTER TABLE `mlrpg_tuner`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=89;

ALTER TABLE `mlrpg_bany`
MODIFY `dbid` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=984;

ALTER TABLE `mlrpg_coreusers`
MODIFY `dbid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2585;

ALTER TABLE `mlrpg_sluzby`
MODIFY `-` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=194;


ALTER TABLE `mlrpg_system_pojazdow`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5198;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;