GW Sql DB

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.5.9-log - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2013-12-19 18:56:46
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping database structure for guild_warz
DROP DATABASE IF EXISTS `guild_warz`;
CREATE DATABASE IF NOT EXISTS `guild_warz` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `guild_warz`;


-- Dumping structure for table guild_warz.zones
DROP TABLE IF EXISTS `zones`;
CREATE TABLE IF NOT EXISTS `zones` (
  `entry` bigint(10) NOT NULL AUTO_INCREMENT,
  `map_id` bigint(10) unsigned DEFAULT '0',
  `area_id` bigint(10) unsigned DEFAULT '0',
  `zone_id` bigint(10) unsigned DEFAULT '0',
  `guild_name` varchar(50) NOT NULL,
  `team` smallint(10) unsigned NOT NULL DEFAULT '0',
  `x` float NOT NULL DEFAULT '0',
  `y` float NOT NULL DEFAULT '0',
  `z` float NOT NULL DEFAULT '0',
  `building_count` tinyint(10) unsigned NOT NULL DEFAULT '0',
  `pig_count` tinyint(10) unsigned NOT NULL DEFAULT '0',
  `guard_count` tinyint(10) unsigned NOT NULL DEFAULT '0',
  `flag_id` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`entry`),
  UNIQUE KEY `entry` (`entry`)
) ENGINE=InnoDB AUTO_INCREMENT=829 DEFAULT CHARSET=latin1;

-- Dumping data for table guild_warz.zones: ~1 rows (approximately)
DELETE FROM `zones`;
/*!40000 ALTER TABLE `zones` DISABLE KEYS */;
INSERT INTO `zones` (`entry`, `map_id`, `area_id`, `zone_id`, `guild_name`, `team`, `x`, `y`, `z`, `building_count`, `pig_count`, `guard_count`, `flag_id`) VALUES
	(1, 0, 0, 0, 'SERVER', 0, 0, 0, 0, 0, 0, 0, 0);
/*!40000 ALTER TABLE `zones` ENABLE KEYS */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;