/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50088
Source Host           : localhost:3306
Source Database       : l2jdb1

Target Server Type    : MYSQL
Target Server Version : 50088
File Encoding         : 65001

Date: 2011-10-27 18:09:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `clan_data`
-- ----------------------------
DROP TABLE IF EXISTS `clan_data`;
CREATE TABLE `clan_data` (
  `clan_id` int(11) NOT NULL default '0',
  `clan_name` varchar(45) default NULL,
  `clan_level` int(11) default NULL,
  `hasCastle` int(11) default NULL,
  `hasHideout` int(11) default NULL,
  `ally_id` int(11) default NULL,
  `ally_name` varchar(45) default NULL,
  `leader_id` int(11) default NULL,
  `crest_id` int(11) default NULL,
  `crest_large_id` int(11) default NULL,
  `ally_crest_id` int(11) default NULL,
  `auction_bid_at` int(11) default NULL,
  PRIMARY KEY  (`clan_id`),
  KEY `leader_id` (`leader_id`),
  KEY `ally_id` (`ally_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of clan_data
-- ----------------------------
