Файл: public_html/cave_list_town.sql
Строк: 98
/*
Navicat MySQL Data Transfer
Source Server : lenovo
Source
Server Version : 50525
Source Host : localhost:3306
Source
Database : test_site_1
Target Server Type : MYSQL
Target
Server Version : 50525
File Encoding : 65001
Date: 2014-10-19
19:47:25
*/
SET FOREIGN_KEY_CHECKS=0;
--
----------------------------
-- Table structure for `cave_list_town`
--
----------------------------
DROP TABLE IF EXISTS
`cave_list_town`;
CREATE TABLE `cave_list_town` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) DEFAULT NULL,
`monster` int(11)
DEFAULT NULL,
`next_battle` int(11) DEFAULT NULL,
`last_result`
varchar(255) DEFAULT NULL,
`action` int(11) DEFAULT '0',
`ident`
varchar(110) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
--
----------------------------
-- Records of cave_list_town
--
----------------------------
INSERT INTO `cave_list_town` VALUES ('38',
'45', '4', null, null, '0', null);
-- ----------------------------
--
Table structure for `cave_monsters_town`
--
----------------------------
DROP TABLE IF EXISTS
`cave_monsters_town`;
CREATE TABLE `cave_monsters_town` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`image`
varchar(255) DEFAULT NULL,
`health` int(11) DEFAULT NULL,
`power`
int(11) DEFAULT NULL,
`protect` int(11) DEFAULT NULL,
`ttl_win`
int(11) DEFAULT NULL,
`ttl_los` int(11) DEFAULT NULL,
`players`
int(11) DEFAULT NULL,
`award_exp` int(11) DEFAULT NULL,
`award_gold`
int(11) DEFAULT NULL,
`award_kr` int(11) DEFAULT NULL,
`award_ir`
int(11) DEFAULT NULL,
`wear` int(11) DEFAULT '0',
`procent_str`
int(11) DEFAULT '0',
`procent_hp` int(11) DEFAULT '0',
`procent_pr`
int(11) DEFAULT '0',
`level` int(11) DEFAULT '1',
PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
--
----------------------------
-- Records of cave_monsters_town
--
----------------------------
INSERT INTO `cave_monsters_town` VALUES ('3',
'Монстре #15', 'images/help.jpg', '150', '12455', '2425', '1', '1',
'1', '12313', '41242', '42342', '24324', '2', '87', '92', '95',
'1');
INSERT INTO `cave_monsters_town` VALUES ('4', 'Монстре #151',
'images/help.jpg', '15000', '12455', '2425', '1', '1', '3', '12313',
'41242', '42342', '24324', '2', '86', '75', '62', '1');
INSERT INTO
`cave_monsters_town` VALUES ('5', 'Монстре #152', 'images/help.jpg',
'15000', '12455', '2425', '1', '1', '3', '12313', '41242', '42342',
'24324', '2', '96', '62', '68', '1');
INSERT INTO `cave_monsters_town`
VALUES ('6', 'Монстре #153', 'images/help.jpg', '15000', '12455',
'2425', '1', '1', '3', '12313', '41242', '42342', '24324', '3', '144',
'143', '120', '1');
-- ----------------------------
-- Table structure
for `element_town`
-- ----------------------------
DROP TABLE IF EXISTS
`element_town`;
CREATE TABLE `element_town` (
`lost_id` int(3) NOT NULL
AUTO_INCREMENT,
`lost_name` varchar(30) NOT NULL,
`lost_level` int(2)
NOT NULL,
`lost_exp` int(10) NOT NULL,
`lost_race` int(1) NOT NULL,
`lost_create_time` varchar(50) NOT NULL,
`lost_create_user` varchar(20)
NOT NULL,
`lost_max_users` int(4) NOT NULL,
`lost_text_announce`
varchar(255) NOT NULL,
`lost_other_announce` varchar(100) NOT NULL,
`lost_treas_gold` bigint(15) NOT NULL,
`lost_treas_crist` bigint(15) NOT
NULL,
`lost_treas_iridiy` bigint(15) NOT NULL,
`lost_altar` int(3)
NOT NULL,
`lost_altar_time` bigint(30) NOT NULL,
`cave_id` int(11)
DEFAULT '0',
PRIMARY KEY (`lost_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3
DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of
element_town
-- ----------------------------
INSERT INTO `element_town`
VALUES ('1', 'драконы', '195', '2147483647', '1', '1407308129', '1',
'20', '13 минут битва', '1|||1407338285', '450900', '925000',
'4990', '141', '0', null);
INSERT INTO `element_town` VALUES ('2',
'qwewr', '1', '1633', '1', '1413118102', '45', '20', '<img
width=\"15\" height=\"15\"
src=\"/images/smiles/1.gif\"> <img width=\"15\"
height=\"15\" src=\"/images/smiles/2.gif\"> <img
width=\"15\" height=\"15\"
src=\"/images/smiles/3.gif\"> <img width=\"15\"
height=\"15\" src=\"/images/smiles/4.gif\"> <img
width=\"15\" height=\"15\"', '45|||1413120964', '0',
'0', '0', '1', '0', '4');