/*
MySQL Data Transfer
Source Host: localhost
Source Database: l2jmack
Target Host: localhost
Target Database: l2jmack
Date: 26/6/2010 19:09:08
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for 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 
-- ----------------------------
INSERT INTO `castle` VALUES ('5', 'Aden', '0', '0', '1278802830000', '7', '20');
INSERT INTO `castle` VALUES ('2', 'Dion', '0', '0', '1278795630000', '7', '18');
INSERT INTO `castle` VALUES ('3', 'Giran', '0', '0', '1279479690000', '1', '16');
INSERT INTO `castle` VALUES ('1', 'Gludio', '0', '0', '1279393230000', '7', '16');
INSERT INTO `castle` VALUES ('7', 'Goddard', '0', '0', '1278882025000', '1', '18');
INSERT INTO `castle` VALUES ('6', 'Innadril', '0', '0', '1279479625000', '1', '16');
INSERT INTO `castle` VALUES ('4', 'Oren', '0', '0', '1279479625000', '1', '16');
INSERT INTO `castle` VALUES ('8', 'Rune', '0', '0', '1278802825000', '7', '20');
INSERT INTO `castle` VALUES ('9', 'Schuttgart', '0', '0', '1279407625000', '7', '20');
