k8LKeyRH

1
2# Dumping database structure for piskvorky
3CREATE DATABASE IF NOT EXISTS `piskvorky`;
4USE `piskvorky`;
5
6
7# Dumping structure for table piskvorky.accounts
8DROP TABLE IF EXISTS `accounts`;
9CREATE TABLE IF NOT EXISTS `accounts` (
10  `login` char(25) NOT NULL DEFAULT '',
11  `pwd` char(32) DEFAULT NULL,
12  `acc_level` int(10) DEFAULT NULL,
13  `win` int(10) NOT NULL DEFAULT '0',
14  `lose` int(10) NOT NULL DEFAULT '0',
15  `draw` int(10) NOT NULL DEFAULT '0',
16  `disconnect` int(10) NOT NULL DEFAULT '0',
17  PRIMARY KEY (`login`)
18) ENGINE=InnoDB DEFAULT CHARSET=latin1;
19
20# Data exporting was unselected.
21
22
23# Dumping structure for table piskvorky.games
24DROP TABLE IF EXISTS `games`;
25CREATE TABLE IF NOT EXISTS `games` (
26  `id` int(10) NOT NULL,
27  `player1` varchar(20) NOT NULL,
28  `player2` varchar(20) NOT NULL,
29  `win` tinyint(2) NOT NULL DEFAULT '0',
30  `start` datetime NOT NULL,
31  `end` datetime NOT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;