-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 20, 2017 at 09:18 PM
-- Server version: 10.1.19-MariaDB
-- PHP Version: 5.5.38

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

--
-- Database: `inceputzero`
--

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

--
-- Table structure for table `cars`
--

CREATE TABLE `cars` (
  `ID` int(11) NOT NULL,
  `Model` int(11) NOT NULL,
  `Locationx` float NOT NULL,
  `Locationy` float NOT NULL,
  `Locationz` float NOT NULL,
  `Angle` float NOT NULL,
  `ColorOne` int(11) NOT NULL,
  `ColorTwo` int(11) NOT NULL,
  `Owner` varchar(25) NOT NULL,
  `Value` int(11) NOT NULL,
  `License` varchar(15) NOT NULL DEFAULT 'LS-01-RGM',
  `Alarm` int(11) NOT NULL,
  `Lockk` int(11) NOT NULL,
  `mod0` int(11) NOT NULL DEFAULT '0',
  `mod1` int(11) NOT NULL DEFAULT '0',
  `mod2` int(11) NOT NULL DEFAULT '0',
  `mod3` int(11) NOT NULL DEFAULT '0',
  `mod4` int(11) NOT NULL DEFAULT '0',
  `mod5` int(11) NOT NULL DEFAULT '0',
  `mod6` int(11) NOT NULL DEFAULT '0',
  `mod7` int(11) NOT NULL DEFAULT '0',
  `mod8` int(11) NOT NULL DEFAULT '0',
  `mod9` int(11) NOT NULL DEFAULT '0',
  `mod10` int(11) NOT NULL DEFAULT '0',
  `mod11` int(11) NOT NULL DEFAULT '0',
  `mod12` int(11) NOT NULL DEFAULT '0',
  `mod13` int(11) NOT NULL DEFAULT '0',
  `paintjob` int(11) NOT NULL DEFAULT '0',
  `KM` int(11) NOT NULL DEFAULT '0',
  `Userid` int(11) NOT NULL DEFAULT '0',
  `Confiscated` int(2) NOT NULL,
  `Spawned` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `ID` int(10) NOT NULL,
  `Nume` varchar(25) NOT NULL,
  `Parola` varchar(25) NOT NULL,
  `IP` varchar(16) NOT NULL,
  `Age` int(10) NOT NULL,
  `Admin` varchar(11) NOT NULL,
  `Helper` varchar(11) NOT NULL,
  `Tester` varchar(11) NOT NULL,
  `LastIP` varchar(16) NOT NULL,
  `ContBlocat` varchar(10) NOT NULL,
  `Car` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`ID`, `Nume`, `Parola`, `IP`, `Age`, `Admin`, `Helper`, `Tester`, `LastIP`, `ContBlocat`, `Car`) VALUES
(1, 'zEr0', 'test123', '127.0.0.1', 0, '1', '', '', '', '', ''),
(12, 'zEr0test', 'test1234', '127.0.0.1', 15, '7', '1', '1', '127.0.0.1', '2', '0');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cars`
--
ALTER TABLE `cars`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cars`
--
ALTER TABLE `cars`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
/*!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 */;