m4xcSgcU

1-- phpMyAdmin SQL Dump
2-- version 3.5.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas wygenerowania: 17 Paź 2016, 20:09
7-- Wersja serwera: 5.5.21-log
8-- Wersja PHP: 5.3.20
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Baza danych: `truck`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Struktura tabeli dla tabeli `vehicles`
21--
22
23CREATE TABLE IF NOT EXISTS `vehicles` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `model` int(11) NOT NULL,
26  `owner type` int(11) NOT NULL,
27  `owner_id` int(11) NOT NULL,
28  `lock` int(11) NOT NULL,
29  `color1` int(11) NOT NULL,
30  `color2` int(11) NOT NULL,
31  `x` float NOT NULL,
32  `y` float NOT NULL,
33  `z` float NOT NULL,
34  `a` float NOT NULL,
35  `hp` float NOT NULL,
36  `fuel` float NOT NULL,
37  `maxfuel` float NOT NULL,
38  `distance` float NOT NULL,
39  `paint` int(11) NOT NULL,
40  `block` int(11) NOT NULL,
41  `vw` int(11) NOT NULL,
42  `int` int(11) NOT NULL,
43  `tablica` varchar(10) NOT NULL,
44  `panels` int(11) NOT NULL,
45  `doors` int(11) NOT NULL,
46  `light` int(11) NOT NULL,
47  `tires` int(11) NOT NULL,
48  PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;