/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 50153
Source Host           : localhost:3306
Source Database       : l2jdb

Target Server Type    : MYSQL
Target Server Version : 50153
File Encoding         : 65001

Date: 2011-11-26 15:02:30
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `castle`
-- ----------------------------
DROP TABLE IF EXISTS `castle`;
CREATE TABLE `castle` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(25) NOT NULL,
  `taxPercent` int(11) NOT NULL DEFAULT '15',
  `treasury` int(11) NOT NULL DEFAULT '0',
  `siegeDate` decimal(20,0) NOT NULL DEFAULT '0',
  `siegeDayOfWeek` int(11) NOT NULL DEFAULT '7',
  `siegeHourOfDay` int(11) NOT NULL DEFAULT '20',
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of castle
-- ----------------------------
INSERT INTO `castle` VALUES ('5', 'Aden', '0', '0', '1322326800000', '7', '20');
INSERT INTO `castle` VALUES ('2', 'Dion', '0', '0', '1322326800000', '7', '20');
INSERT INTO `castle` VALUES ('3', 'Giran', '0', '0', '1322398800000', '1', '16');
INSERT INTO `castle` VALUES ('1', 'Gludio', '10', '0', '1322326800000', '7', '20');
INSERT INTO `castle` VALUES ('7', 'Goddard', '0', '0', '1322398800000', '1', '16');
INSERT INTO `castle` VALUES ('6', 'Innadril', '0', '0', '1322398800000', '1', '16');
INSERT INTO `castle` VALUES ('4', 'Oren', '0', '0', '1322398800000', '1', '16');
INSERT INTO `castle` VALUES ('8', 'Rune', '0', '0', '1323536400000', '7', '20');
