FteZcATe

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:20
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 `doors`
21--
22
23CREATE TABLE IF NOT EXISTS `doors` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `ownetype` int(11) NOT NULL,
26  `owner` int(11) NOT NULL,
27  `enterx` float NOT NULL,
28  `entery` float NOT NULL,
29  `enterz` float NOT NULL,
30  `enterang` float NOT NULL,
31  `enterint` int(11) NOT NULL,
32  `entervw` int(11) NOT NULL,
33  `exitx` float NOT NULL,
34  `exity` float NOT NULL,
35  `exitz` float NOT NULL,
36  `exitang` float NOT NULL,
37  `exitint` int(11) NOT NULL,
38  `exitvw` int(11) NOT NULL,
39  `lock` int(11) NOT NULL,
40  `pickupid` int(11) NOT NULL,
41  `name` varchar(50) NOT NULL,
42  `garage` int(11) NOT NULL,
43  `envw` int(11) NOT NULL,
44  `exvw` int(11) NOT NULL,
45  `url` varchar(64) NOT NULL,
46  `alarm` int(11) NOT NULL,
47  `enter_info` varchar(128) NOT NULL,
48  `value` int(11) NOT NULL,
49  `rent` int(11) NOT NULL,
50  PRIMARY KEY (`id`)
51) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;