· 9 years ago · Jan 14, 2017, 05:56 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 01, 2015 at 08:28 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `sami`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `players`
27--
28
29CREATE TABLE IF NOT EXISTS `players` (
30 `ID` int(10) NOT NULL AUTO_INCREMENT,
31 `Username` varchar(24) NOT NULL,
32 `Password` varchar(129) NOT NULL,
33 `IP` varchar(16) NOT NULL,
34 `Admin` int(10) NOT NULL,
35 `VIP` int(10) NOT NULL,
36 `Kills` int(10) NOT NULL,
37 `Cookies` int(10) NOT NULL,
38 `Cakes` int(10) NOT NULL,
39 `Icecream` int(10) NOT NULL,
40 `Deaths` int(10) NOT NULL,
41 `Score` int(10) NOT NULL,
42 `Money` int(10) NOT NULL,
43 PRIMARY KEY (`ID`)
44) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
45
46-- --------------------------------------------------------
47
48--
49-- Tabelstructuur voor tabel `banlog`
50--
51
52CREATE TABLE IF NOT EXISTS `banlog` (
53 `time` varchar(50) NOT NULL,
54 `name` varchar(26) NOT NULL,
55 `ip` varchar(50) NOT NULL,
56 `reason` varchar(200) NOT NULL,
57 `admin` varchar(24) NOT NULL,
58 `banned` int(5) NOT NULL
59) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
60
61--
62-- Gegevens worden uitgevoerd voor tabel `banlog`
63--
64
65
66-- --------------------------------------------------------
67
68/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
69/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
70/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;