/*
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:10:20
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `clanhall_functions`
-- ----------------------------
DROP TABLE IF EXISTS `clanhall_functions`;
CREATE TABLE `clanhall_functions` (
  `hall_id` int(2) NOT NULL default '0',
  `type` int(1) NOT NULL default '0',
  `lvl` int(3) NOT NULL default '0',
  `lease` int(10) NOT NULL default '0',
  `rate` decimal(20,0) NOT NULL default '0',
  `endTime` decimal(20,0) NOT NULL default '0',
  `inDebt` int(1) NOT NULL default '0',
  PRIMARY KEY  (`hall_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of clanhall_functions
-- ----------------------------
