AVF6nPsq

1/*
2SQLyog Community Edition- MySQL GUI v8.1 
3MySQL - 5.5.23-1~dotdeb.0 : Database - deathbans
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14CREATE DATABASE /*!32312 IF NOT EXISTS*/`deathbans` /*!40100 DEFAULT CHARACTER SET latin1 */;
15
16USE `deathbans`;
17
18/*Table structure for table `deathbans` */
19
20DROP TABLE IF EXISTS `deathbans`;
21
22CREATE TABLE `deathbans` (
23  `id` int(10) NOT NULL AUTO_INCREMENT,
24  `player` varchar(64) NOT NULL,
25  `cause` varchar(64) NOT NULL,
26  `by` varchar(64) NOT NULL,
27  `date` bigint(10) NOT NULL,
28  `active` int(10) NOT NULL DEFAULT '1',
29  PRIMARY KEY (`id`)
30) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
31
32/*Data for the table `deathbans` */
33
34LOCK TABLES `deathbans` WRITE;
35
36insert  into `deathbans`(id,player,cause,by,date,active) values (1,'Giusallo','ENTITY_ATTACK','MadMockers',1345077901251,0),(2,'Giusallo','ENTITY_ATTACK','MadMockers',1345079442134,0),(3,'Giusallo','ENTITY_ATTACK','MadMockers',1345080225600,0),(4,'Giusallo','ENTITY_ATTACK','MadMockers',1345081318147,1);
37
38UNLOCK TABLES;
39
40/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;