YV7m46ic

1-- phpMyAdmin SQL Dump
2-- version 4.0.10.14
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Dec 24, 2016 at 11:26 PM
7-- Server version: 5.5.50-38.0-log
8-- PHP Version: 5.4.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `playarkc_json`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `Ptero_Character_BP_C`
27--
28
29CREATE TABLE IF NOT EXISTS `Ptero_Character_BP_C` (
30  `list_x` decimal(15,9) DEFAULT NULL,
31  `list_y` decimal(15,9) DEFAULT NULL,
32  `list_z` decimal(15,10) DEFAULT NULL,
33  `list_lat` decimal(3,1) DEFAULT NULL,
34  `list_lon` decimal(3,1) DEFAULT NULL,
35  `list_id` int(11) DEFAULT NULL,
36  `list_tamed` varchar(4) DEFAULT NULL,
37  `list_team` int(11) DEFAULT NULL,
38  `list_color0` int(11) DEFAULT NULL,
39  `list_color1` int(11) DEFAULT NULL,
40  `list_color2` int(11) DEFAULT NULL,
41  `list_color3` int(11) DEFAULT NULL,
42  `list_color4` int(11) DEFAULT NULL,
43  `list_color5` int(11) DEFAULT NULL,
44  `list_tamedAtTime` decimal(14,7) DEFAULT NULL,
45  `list_tamedTime` decimal(14,7) DEFAULT NULL,
46  `list_tribe` varchar(24) DEFAULT NULL,
47  `list_tamer` varchar(24) DEFAULT NULL,
48  `list_baseLevel` int(11) DEFAULT NULL,
49  `list_wildLevels_health` int(11) DEFAULT NULL,
50  `list_wildLevels_stamina` int(11) DEFAULT NULL,
51  `list_wildLevels_oxygen` int(11) DEFAULT NULL,
52  `list_wildLevels_food` int(11) DEFAULT NULL,
53  `list_wildLevels_weight` int(11) DEFAULT NULL,
54  `list_wildLevels_melee` int(11) DEFAULT NULL,
55  `list_wildLevels_speed` int(11) DEFAULT NULL,
56  `list_fullLevel` int(11) DEFAULT NULL,
57  `list_tamedLevels_speed` int(11) DEFAULT NULL,
58  `list_experience` decimal(17,11) DEFAULT NULL,
59  `list_female` varchar(4) DEFAULT NULL,
60  `list_tamedLevels_weight` int(11) DEFAULT NULL,
61  `list_name` varchar(24) DEFAULT NULL,
62  `list_tamedLevels_stamina` int(11) DEFAULT NULL,
63  `list_tamedLevels_melee` int(11) DEFAULT NULL,
64  `list_imprinter` varchar(12) DEFAULT NULL,
65  `list_imprintingQuality` decimal(12,11) DEFAULT NULL,
66  `list_tamedLevels_health` int(11) DEFAULT NULL,
67  `list_tamedLevels_food` int(11) DEFAULT NULL,
68  `list_playerId` int(11) DEFAULT NULL,
69  `list_ownerName` varchar(9) DEFAULT NULL
70) ENGINE=MyISAM DEFAULT CHARSET=utf8;
71
72/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
73/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
74/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;