z1b2c9NE

1
2# --------------------------------------------------------
3# Host:                         127.0.0.1
4# Server version:               5.5.8
5# Server OS:                    Win32
6# HeidiSQL version:             6.0.0.3603
7# Date/time:                    2011-11-05 09:28:53
8# --------------------------------------------------------
9
10/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
11/*!40101 SET NAMES utf8 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14
15# Dumping database structure for tf2tw
16CREATE DATABASE IF NOT EXISTS `tf2tw` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `tf2tw`;
18
19
20# Dumping structure for table tf2tw.items
21CREATE TABLE IF NOT EXISTS `items` (
22  `steamid` varchar(18) NOT NULL,
23  `itemid` varchar(15) NOT NULL,
24  `description` varchar(100) NOT NULL,
25  `grouped` char(1) NOT NULL DEFAULT '0',
26  `timestamp` varchar(20) NOT NULL,
27  PRIMARY KEY (`itemid`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29
30# Dumping data for table tf2tw.items: ~137 rows (approximately)
31/*!40000 ALTER TABLE `items` DISABLE KEYS */;
32/*!40000 ALTER TABLE `items` ENABLE KEYS */;
33/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
34/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
35/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;