CREATE TABLE IF NOT EXISTS `castle` (
  `id` INT NOT NULL default 0,
  `name` varchar(25) NOT NULL,
  `taxPercent` INT NOT NULL default 15,
  `treasury` BIGINT NOT NULL default 0,
  `siegeDate` bigint(13) unsigned NOT NULL DEFAULT '0',
  `regTimeOver` enum('true','false') DEFAULT 'true' NOT NULL,
  `regTimeEnd` bigint(13) unsigned NOT NULL DEFAULT '0',
  `showNpcCrest` enum('true','false') DEFAULT 'false' NOT NULL,
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
);

INSERT IGNORE INTO `castle` VALUES
(1,'Gludio',0,0,0,'true',0,'false'),
(2,'Dion',0,0,0,'true',0,'false'),
(3,'Giran',0,0,0,'true',0,'false'),
(4,'Oren',0,0,0,'true',0,'false'),
(5,'Aden',0,0,0,'true',0,'false'),
(6,'Innadril',0,0,0,'true',0,'false'),
(7,'Goddard',0,0,0,'true',0,'false'),
(8,'Rune',0,0,0,'true',0,'false'),
(9,'Schuttgart',0,0,0,'true',0,'false');