3uvJNser

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-10-29 00:36:35
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  `originalid` int(10) NOT NULL DEFAULT '0',
22  `id` int(10) DEFAULT NULL,
23  `steamid` int(20) DEFAULT NULL,
24  `defindex` int(10) DEFAULT NULL,
25  `level` int(10) DEFAULT NULL,
26  `quality` int(10) DEFAULT NULL,
27  `inventory` int(10) DEFAULT NULL,
28  `quantity` int(10) DEFAULT NULL,
29  PRIMARY KEY (`originalid`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31
32# Dumping data for table tf2tw.items: ~0 rows (approximately)
33/*!40000 ALTER TABLE `items` DISABLE KEYS */;
34/*!40000 ALTER TABLE `items` ENABLE KEYS */;
35
36
37# Dumping structure for table tf2tw.store
38CREATE TABLE IF NOT EXISTS `store` (
39  `steamid` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
40  `st` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
41  `si` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
42  PRIMARY KEY (`steamid`)
43) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
44
45# Dumping data for table tf2tw.store: 3 rows
46/*!40000 ALTER TABLE `store` DISABLE KEYS */;
47/*!40000 ALTER TABLE `store` ENABLE KEYS */;
48/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
49/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
50/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;