l2j-server-datapack/sql/fort.sql

-- ----------------------------
-- Table structure for fort
-- ----------------------------
CREATE TABLE IF NOT EXISTS `fort` (
  `id` int(11) NOT NULL default 0,
  `name` varchar(25) NOT NULL,
  `siegeDate` decimal(20,0) NOT NULL default 0,
  `lastOwnedTime` decimal(20,0) NOT NULL default 0,
  `owner` int(11) NOT NULL default 0,
  `fortType` int(1) NOT NULL default 0,
  `state` int(1) NOT NULL default 0,
  `castleId` int(1) NOT NULL default 0,
  PRIMARY KEY (`id`)
);

-- ----------------------------
-- Records 
-- ----------------------------
INSERT IGNORE INTO `fort` VALUES 
(101,'Shanty',0,0,0,0,0,0),
(102,'Southern',0,0,0,1,0,0),
(103,'Hive',0,0,0,0,0,0),
(104,'Valley',0,0,0,1,0,0),
(105,'Ivory',0,0,0,0,0,0),
(106,'Narsell',0,0,0,0,0,0),
(107,'Bayou',0,0,0,1,0,0),
(108,'White Sands',0,0,0,0,0,0),
(109,'Borderland',0,0,0,1,0,0),
(110,'Swamp',0,0,0,1,0,0),
(111,'Archaic',0,0,0,0,0,0),
(112,'Floran',0,0,0,1,0,0),
(113,'Cloud Mountain',0,0,0,1,0,0),
(114,'Tanor',0,0,0,0,0,0),
(115,'Dragonspine',0,0,0,0,0,0),
(116,'Antharas',0,0,0,1,0,0),
(117,'Western',0,0,0,1,0,0),
(118,'Hunters',0,0,0,1,0,0),
(119,'Aaru',0,0,0,0,0,0),
(120,'Demon',0,0,0,0,0,0),
(121,'Monastic',0,0,0,0,0,0);