Код:
--
-- Структура таблицы `clanhall`
--
CREATE TABLE IF NOT EXISTS `clanhall` (
`id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(40) NOT NULL DEFAULT '',
`last_siege_date` int(10) unsigned NOT NULL,
`own_date` int(10) unsigned NOT NULL,
`siege_date` int(10) unsigned NOT NULL,
`auction_min_bid` bigint(20) NOT NULL,
`auction_length` int(11) NOT NULL,
`auction_desc` text,
`cycle` int(11) NOT NULL,
`paid_cycle` int(11) NOT NULL,
PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `clanhall`
--
INSERT INTO `clanhall` (`id`, `name`, `last_siege_date`, `own_date`, `siege_date`, `auction_min_bid`, `auction_length`, `auction_desc`, `cycle`, `paid_cycle`) VALUES
(21, 'Fortress of Resistance', 0, 0, 1371747600, 0, 0, '', 0, 0),
(22, 'Moonstone Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(23, 'Onyx Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(24, 'Topaz Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(25, 'Ruby Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(26, 'Crystal Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(27, 'Onyx Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(28, 'Sapphire Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(29, 'Moonstone Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(30, 'Emerald Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(31, 'The Atramental Barracks', 0, 0, 0, 0, 0, NULL, 0, 0),
(32, 'The Scarlet Barracks', 0, 0, 0, 0, 0, NULL, 0, 0),
(33, 'The Viridian Barracks', 0, 0, 0, 0, 0, NULL, 0, 0),
(34, 'Devastated Castle', 0, 0, 1371920400, 0, 0, '', 0, 0),
(35, 'Bandit Stronghold', 0, 0, 1371920400, 0, 0, '', 0, 0),
(36, 'The Golden Chamber', 0, 0, 0, 100000000, 1, '', 0, 0),
(37, 'The Silver Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(38, 'The Mithril Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(39, 'Silver Manor', 0, 0, 0, 0, 0, NULL, 0, 0),
(40, 'Gold Manor', 0, 0, 0, 0, 0, NULL, 0, 0),
(41, 'The Bronze Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(42, 'The Golden Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(43, 'The Silver Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(44, 'The Mithril Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(45, 'The Bronze Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(46, 'Silver Manor', 0, 0, 0, 0, 0, NULL, 0, 0),
(47, 'Moonstone Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(48, 'Onyx Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(49, 'Emerald Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(50, 'Sapphire Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(51, 'Mont Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(52, 'Astaire Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(53, 'Aria Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(54, 'Yiana Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(55, 'Roien Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(56, 'Luna Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(57, 'Traban Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(58, 'Eisen Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(59, 'Heavy Metal Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(60, 'Molten Ore Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(61, 'Titan Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(62, 'Rainbow Springs', 0, 0, 1371924000, 0, 0, '', 0, 0),
(63, 'Wild Beast Reserve', 0, 0, 1371920400, 0, 0, '', 0, 0),
(64, 'Fortress of the Dead', 0, 0, 1371909600, 0, 0, '', 0, 0);
Код:
CREATE TABLE IF NOT EXISTS `clanhall` (
`id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(40) NOT NULL DEFAULT '',
`last_siege_date` int(10) unsigned NOT NULL,
`own_date` int(10) unsigned NOT NULL,
`siege_date` int(10) unsigned NOT NULL,
`auction_min_bid` bigint(20) NOT NULL,
`auction_length` int(11) NOT NULL,
`auction_desc` text,
`cycle` int(11) NOT NULL,
`paid_cycle` int(11) NOT NULL,
PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `clanhall`
--
INSERT INTO `clanhall` (`id`, `name`, `last_siege_date`, `own_date`, `siege_date`, `auction_min_bid`, `auction_length`, `auction_desc`, `cycle`, `paid_cycle`) VALUES
(21, 'Fortress of Resistance', 0, 0, 1371747600, 0, 0, '', 0, 0),
(22, 'Moonstone Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(23, 'Onyx Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(24, 'Topaz Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(25, 'Ruby Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(26, 'Crystal Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(27, 'Onyx Hall', 0, 1369652400, 1371466800, 20000000, 7, '', 0, 0),
(28, 'Sapphire Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(29, 'Moonstone Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(30, 'Emerald Hall', 0, 1370862000, 0, 0, 0, '', 137, 137),
(31, 'The Atramental Barracks', 0, 0, 0, 0, 0, NULL, 0, 0),
(32, 'The Scarlet Barracks', 0, 0, 0, 0, 0, NULL, 0, 0),
(33, 'The Viridian Barracks', 0, 0, 0, 0, 0, NULL, 0, 0),
(34, 'Devastated Castle', 0, 0, 1371920400, 0, 0, '', 0, 0),
(35, 'Bandit Stronghold', 0, 0, 1371920400, 0, 0, '', 0, 0),
(36, 'The Golden Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(37, 'The Silver Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(38, 'The Mithril Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(39, 'Silver Manor', 0, 0, 0, 0, 0, NULL, 0, 0),
(40, 'Gold Manor', 0, 0, 0, 0, 0, NULL, 0, 0),
(41, 'The Bronze Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(42, 'The Golden Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(43, 'The Silver Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(44, 'The Mithril Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(45, 'The Bronze Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(46, 'Silver Manor', 0, 0, 0, 0, 0, NULL, 0, 0),
(47, 'Moonstone Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(48, 'Onyx Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(49, 'Emerald Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(50, 'Sapphire Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(51, 'Mont Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(52, 'Astaire Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(53, 'Aria Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(54, 'Yiana Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(55, 'Roien Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(56, 'Luna Chamber', 0, 0, 0, 0, 0, NULL, 0, 0),
(57, 'Traban Chamber', 0, 0, 0, 100000000, 7, '', 0, 0),
(58, 'Eisen Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(59, 'Heavy Metal Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(60, 'Molten Ore Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(61, 'Titan Hall', 0, 0, 0, 0, 0, NULL, 0, 0),
(62, 'Rainbow Springs', 0, 0, 1371924000, 0, 0, '', 0, 0),
(63, 'Wild Beast Reserve', 0, 0, 1371920400, 0, 0, '', 0, 0),
(64, 'Fortress of the Dead', 0, 0, 1371909600, 0, 0, '', 0, 0);
|