· 9 years ago · Oct 11, 2016, 09:34 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : LineageTwo
5Source Server Version : 50173
6Source Host : 185.71.66.192:3306
7Source Database : x1200
8
9Target Server Type : MYSQL
10Target Server Version : 50173
11File Encoding : 65001
12
13Date: 2016-10-12 00:28:19
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `clanhall`
20-- ----------------------------
21DROP TABLE IF EXISTS `clanhall`;
22CREATE TABLE `clanhall` (
23 `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
24 `name` varchar(40) NOT NULL DEFAULT '',
25 `last_siege_date` bigint(20) NOT NULL,
26 `own_date` bigint(20) NOT NULL,
27 `siege_date` bigint(20) NOT NULL,
28 `auction_min_bid` bigint(20) NOT NULL,
29 `auction_length` int(11) NOT NULL,
30 `auction_desc` text,
31 `cycle` int(11) NOT NULL,
32 `paid_cycle` int(11) NOT NULL,
33 PRIMARY KEY (`id`,`name`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36-- ----------------------------
37-- Records of clanhall
38-- ----------------------------
39INSERT INTO `clanhall` VALUES ('21', 'Fortress of Resistance', '0', '0', '1476716400000', '0', '0', '', '0', '0');
40INSERT INTO `clanhall` VALUES ('22', 'Moonstone Hall', '0', '1466979080823', '1470657600000', '20000000', '7', '', '1560', '48');
41INSERT INTO `clanhall` VALUES ('23', 'Onyx Hall', '0', '1446308403498', '1452513600000', '20000000', '7', '', '601', '97');
42INSERT INTO `clanhall` VALUES ('24', 'Topaz Hall', '0', '0', '1444046400000', '20000000', '7', '', '0', '0');
43INSERT INTO `clanhall` VALUES ('25', 'Ruby Hall', '0', '1475542887782', '0', '0', '0', '', '935', '95');
44INSERT INTO `clanhall` VALUES ('26', 'Crystal Hall', '0', '0', '1444046400000', '20000000', '7', '', '0', '0');
45INSERT INTO `clanhall` VALUES ('27', 'Onyx Hall', '0', '0', '1444046400000', '20000000', '7', '', '0', '0');
46INSERT INTO `clanhall` VALUES ('28', 'Sapphire Hall', '0', '1476003075446', '0', '0', '0', '', '192', '24');
47INSERT INTO `clanhall` VALUES ('29', 'Moonstone Hall', '0', '0', '1444046400000', '20000000', '7', '', '0', '0');
48INSERT INTO `clanhall` VALUES ('30', 'Emerald Hall', '0', '0', '1444046400000', '8000000', '7', '', '0', '0');
49INSERT INTO `clanhall` VALUES ('31', 'The Atramental Barracks', '0', '1467238787691', '1470657600000', '8000000', '7', '', '866', '26');
50INSERT INTO `clanhall` VALUES ('32', 'The Scarlet Barracks', '0', '0', '1444046400000', '8000000', '7', '', '0', '0');
51INSERT INTO `clanhall` VALUES ('33', 'The Viridian Barracks', '0', '0', '1444046400000', '8000000', '7', '', '0', '0');
52INSERT INTO `clanhall` VALUES ('34', 'Devastated Castle', '0', '0', '1477148400000', '0', '0', '', '0', '0');
53INSERT INTO `clanhall` VALUES ('35', 'Bandit Stronghold', '0', '0', '1477162800000', '0', '0', '', '0', '0');
54INSERT INTO `clanhall` VALUES ('36', 'The Golden Chamber', '0', '1473976751394', '1474286400000', '50000000', '7', '', '0', '0');
55INSERT INTO `clanhall` VALUES ('37', 'The Silver Chamber', '0', '1474237335499', '1474891200000', '50000000', '7', '', '439', '103');
56INSERT INTO `clanhall` VALUES ('38', 'The Mithril Chamber', '0', '1469287990351', '1468843200000', '50000000', '7', '', '0', '0');
57INSERT INTO `clanhall` VALUES ('39', 'Silver Manor', '0', '1453986408388', '1455537600000', '50000000', '7', '', '444', '108');
58INSERT INTO `clanhall` VALUES ('40', 'Gold Manor', '0', '1468076064821', '1470657600000', '50000000', '7', '', '630', '126');
59INSERT INTO `clanhall` VALUES ('41', 'The Bronze Chamber', '0', '0', '1444046400000', '50000000', '7', '', '0', '0');
60INSERT INTO `clanhall` VALUES ('42', 'The Golden Chamber', '0', '1453333154482', '1455537600000', '50000000', '7', '', '621', '117');
61INSERT INTO `clanhall` VALUES ('43', 'The Silver Chamber', '0', '1444972471394', '1445256000000', '50000000', '7', '', '0', '0');
62INSERT INTO `clanhall` VALUES ('44', 'The Mithril Chamber', '0', '1475791525988', '0', '0', '0', '', '119', '119');
63INSERT INTO `clanhall` VALUES ('45', 'The Bronze Chamber', '0', '1447058839219', '1452513600000', '50000000', '7', '', '411', '75');
64INSERT INTO `clanhall` VALUES ('46', 'Silver Manor', '0', '0', '1444046400000', '50000000', '7', '', '0', '0');
65INSERT INTO `clanhall` VALUES ('47', 'Moonstone Hall', '0', '1475496000002', '0', '0', '0', '', '564', '60');
66INSERT INTO `clanhall` VALUES ('48', 'Onyx Hall', '0', '1475496000005', '0', '0', '0', '', '2924', '68');
67INSERT INTO `clanhall` VALUES ('49', 'Emerald Hall', '0', '1475496000004', '0', '0', '0', '', '4385', '17');
68INSERT INTO `clanhall` VALUES ('50', 'Sapphire Hall', '0', '1475496000005', '0', '0', '0', '', '971', '131');
69INSERT INTO `clanhall` VALUES ('51', 'Mont Chamber', '0', '1475542887873', '1476100800000', '50000000', '7', '', '0', '0');
70INSERT INTO `clanhall` VALUES ('52', 'Astaire Chamber', '0', '0', '1444046400000', '50000000', '7', '', '0', '0');
71INSERT INTO `clanhall` VALUES ('53', 'Aria Chamber', '0', '1468076064869', '1470657600000', '50000000', '7', '', '630', '126');
72INSERT INTO `clanhall` VALUES ('54', 'Yiana Chamber', '0', '1472533040695', '1474891200000', '50000000', '7', '', '586', '82');
73INSERT INTO `clanhall` VALUES ('55', 'Roien Chamber', '0', '0', '1444046400000', '50000000', '7', '', '0', '0');
74INSERT INTO `clanhall` VALUES ('56', 'Luna Chamber', '0', '0', '1444046400000', '50000000', '7', '', '0', '0');
75INSERT INTO `clanhall` VALUES ('57', 'Traban Chamber', '0', '0', '1444046400000', '50000000', '7', '', '0', '0');
76INSERT INTO `clanhall` VALUES ('58', 'Eisen Hall', '0', '1445237639352', '1452513600000', '20000000', '7', '', '896', '56');
77INSERT INTO `clanhall` VALUES ('59', 'Heavy Metal Hall', '0', '1476003075518', '0', '0', '0', '', '736', '64');
78INSERT INTO `clanhall` VALUES ('60', 'Molten Ore Hall', '0', '1475791526047', '1475496000000', '20000000', '7', '', '0', '0');
79INSERT INTO `clanhall` VALUES ('61', 'Titan Hall', '0', '1472533040696', '1474891200000', '20000000', '7', '', '586', '82');
80INSERT INTO `clanhall` VALUES ('62', 'Rainbow Springs', '0', '0', '1477162800000', '0', '0', '', '0', '0');
81INSERT INTO `clanhall` VALUES ('63', 'Wild Beast Reserve', '0', '0', '1477159200000', '0', '0', '', '0', '0');
82INSERT INTO `clanhall` VALUES ('64', 'Fortress of the Dead', '0', '0', '1477148400000', '0', '0', '', '0', '0');