//level and exp table
-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 15 Oct 2017 la 18:07
-- Versiune server: 10.1.26-MariaDB
-- PHP Version: 7.1.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `trucking`
--

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `explevel`
--

CREATE TABLE `explevel` (
  `ID` int(11) UNSIGNED NOT NULL,
  `pid` int(11) NOT NULL,
  `LevelT` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `LevelB` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `LevelPi` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `LevelPo` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `LevelM` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `LevelC` int(11) UNSIGNED DEFAULT '0',
  `LevelS` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `LevelL` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `LevelPB` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `LevelSo` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `LevelG` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `LevelTa` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `LevelPa` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnT` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnB` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnPi` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnPo` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnM` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnC` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnS` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnL` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnPB` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnSo` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnG` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnTa` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ExpEarnPa` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ExpNeedT` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedB` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedPi` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedPo` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedM` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedC` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedS` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedL` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedPB` int(11) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedSo` int(10) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedG` int(10) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedTa` int(10) UNSIGNED NOT NULL DEFAULT '100',
  `ExpNeedPa` int(10) UNSIGNED NOT NULL DEFAULT '100'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `explevel`
--


--
-- Indexes for dumped tables
--

--
-- Indexes for table `explevel`
--
ALTER TABLE `explevel`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `ID` (`ID`),
  ADD KEY `pid` (`pid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `explevel`
--
ALTER TABLE `explevel`
  MODIFY `ID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

/*!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 */;

//players table
-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 15 Oct 2017 la 18:07
-- Versiune server: 10.1.26-MariaDB
-- PHP Version: 7.1.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `trucking`
--

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `players`
--

CREATE TABLE `players` (
  `id` int(11) NOT NULL,
  `username` varchar(24) NOT NULL,
  `password` varchar(66) NOT NULL,
  `salt` varchar(17) NOT NULL,
  `IP` varchar(16) NOT NULL,
  `PlayerLevel` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
  `VPlayerLevel` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
  `PlayerJailed` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `MuteSeconds` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `RulesRead` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
  `Wanted` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `Gold` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `PlayerSkin` smallint(5) NOT NULL DEFAULT '-1',
  `TruckerLicense` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
  `BusLicense` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
  `MafiaLicense` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
  `PilotLicense` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
  `SoldatLicense` tinyint(11) UNSIGNED NOT NULL DEFAULT '0',
  `PlayerMoney` int(20) NOT NULL DEFAULT '0',
  `PlayerScore` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsTruckerJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsConvoyJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsBusDriverJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsPilotJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsMafiaJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsMafiaStolen` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsPoliceFined` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsPoliceJailed` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsCourierJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsRoadworkerJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsPboyJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsMetersDriven` float UNSIGNED NOT NULL DEFAULT '0',
  `StatsMedicJobs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `StatsSoferJobs` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `StatsGJobs` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `StatsTaxiJobs` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `StatsPadurarJobs` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `players`
--

--
-- Indexes for dumped tables
--

--
-- Indexes for table `players`
--
ALTER TABLE `players`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `players`
--
ALTER TABLE `players`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

/*!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 */;