83Mx7Ad1

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               5.5.16 - MySQL Community Server (GPL)
4-- Server OS:                    Win32
5-- HeidiSQL version:             7.0.0.4197
6-- Date/time:                    2012-09-28 21:08:54
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 dayz
15CREATE DATABASE IF NOT EXISTS `dayz` /*!40100 DEFAULT CHARACTER SET utf8 */;
16USE `dayz`;
17
18
19-- Dumping structure for table dayz.objects
20CREATE TABLE IF NOT EXISTS `objects` (
21  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
22  `uid` varchar(50) NOT NULL DEFAULT '0' COMMENT 'Object game generated ID',
23  `pos` varchar(255) NOT NULL DEFAULT '[]' COMMENT 'Postition of the object',
24  `inventory` varchar(2048) NOT NULL DEFAULT '[]',
25  `health` varchar(1024) NOT NULL DEFAULT '[]' COMMENT 'Broken parts of the object',
26  `fuel` double NOT NULL DEFAULT '0' COMMENT 'Ammount of fuel. 0-1',
27  `damage` double NOT NULL DEFAULT '0' COMMENT 'Overall damage value. 0-1',
28  `otype` varchar(255) NOT NULL DEFAULT 'none' COMMENT 'Type of the object',
29  `oid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Owner of the object. Only relevant for tents',
30  `instance` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance number in which object resides',
31  `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last update to the object',
32  PRIMARY KEY (`id`) USING BTREE
33) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
34
35-- Dumping data for table dayz.objects: 1 rows
36/*!40000 ALTER TABLE `objects` DISABLE KEYS */;
37INSERT INTO `objects` (`id`, `uid`, `pos`, `inventory`, `health`, `fuel`, `damage`, `otype`, `oid`, `instance`, `lastupdate`) VALUES
38	(20, '7', '[312,[10347.9,2160.22,0.00143862]]', '[]', '[]', 1, 0, 'UH1H_DZ', 0, 1, '2012-09-28 21:07:08'),
39	(21, '7', '[290,[7096.38,2560.91,0.00143433]]', '[]', '[]', 1, 0, 'UH1H_DZ', 0, 1, '2012-09-28 21:07:30');
40/*!40000 ALTER TABLE `objects` ENABLE KEYS */;
41/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
42/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
43/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;