2yTaCMqn

· 9 years ago · Oct 28, 2016, 11:12 PM
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:31
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 `players`
21--
22
23CREATE TABLE IF NOT EXISTS `players` (
24  `player_uid` int(11) NOT NULL AUTO_INCREMENT,
25  `nick` varchar(20) NOT NULL,
26  `aj` int(11) NOT NULL,
27  `ban` int(11) NOT NULL,
28  `block` int(11) NOT NULL,
29  `bw` int(11) NOT NULL,
30  `hp` float NOT NULL,
31  `bank` int(11) NOT NULL,
32  `sex` int(11) NOT NULL,
33  `last_x` float NOT NULL,
34  `last_y` float NOT NULL,
35  `last_z` float NOT NULL,
36  `last_a` float NOT NULL,
37  `last_int` int(11) NOT NULL,
38  `last_vw` int(11) NOT NULL,
39  `last_door` int(11) NOT NULL,
40  `last_type` int(11) NOT NULL,
41  `skin` int(11) NOT NULL,
42  `lskin` int(11) NOT NULL,
43  `online` int(11) NOT NULL,
44  `warns` int(11) NOT NULL,
45  `admin` int(11) NOT NULL,
46  `score` int(11) NOT NULL,
47  `seen` int(11) NOT NULL,
48  `logged` int(11) NOT NULL,
49  `g1` int(11) NOT NULL,
50  `g2` int(11) NOT NULL,
51  `g3` int(11) NOT NULL,
52  `g4` int(11) NOT NULL,
53  `g5` int(11) NOT NULL,
54  PRIMARY KEY (`player_uid`)
55) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;