5npgZi0C

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