| 1234567891011121314151617181920212223 |
- 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');
|
