l2j-server-datapack/L2J_DataPack_BETA/sql/server/fort.sql

CREATE TABLE IF NOT EXISTS `fort` (
  `id` int(11) NOT NULL default 0,
  `name` varchar(25) NOT NULL,
  `siegeDate` bigint(13) unsigned NOT NULL DEFAULT '0',
  `lastOwnedTime` bigint(13) unsigned 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,
  `blood` int(3) NOT NULL default 0,
  `supplyLvL` int(2) NOT NULL default 0,
  PRIMARY KEY (`id`)
);

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