· 8 years ago · Feb 16, 2018, 06:56 PM
1
2CREATE TABLE IF NOT EXISTS `character` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `id_account` int(11) NOT NULL DEFAULT '0',
5 `secret` text NOT NULL,
6 `x` int(11) NOT NULL,
7 `y` int(11) NOT NULL,
8 `floor` int(11) NOT NULL DEFAULT '0',
9 `avatar` text NOT NULL,
10 `first_name` varchar(20) NOT NULL,
11 `last_name` varchar(20) NOT NULL,
12 `level` int(11) NOT NULL DEFAULT '1',
13 `exp_status` int(11) NOT NULL DEFAULT '1',
14 `grazia` int(11) NOT NULL DEFAULT '1',
15 `hp` bigint(255) NOT NULL,
16 `hp_max` bigint(255) NOT NULL,
17 `status_base_hp` int(11) NOT NULL,
18 `status_base_atk` int(11) NOT NULL,
19 `status_base_atk_magic` int(11) NOT NULL,
20 `status_base_def` int(11) NOT NULL,
21 `status_base_def_magic` int(11) NOT NULL,
22 `status_base_dex` int(11) NOT NULL,
23 `status_equip_hp` bigint(255) NOT NULL,
24 `status_equip_atk` bigint(255) NOT NULL,
25 `status_equip_def` bigint(255) NOT NULL,
26 `status_equip_atk_magic` bigint(255) NOT NULL,
27 `status_equip_def_magic` bigint(255) NOT NULL,
28 `status_equip_dex` bigint(255) NOT NULL,
29 /*vers means gold*/
30 `vers` bigint(255) NOT NULL DEFAULT '0',
31 `fightingpoints` bigint(255) NOT NULL DEFAULT '0',
32 `head` int(11) NOT NULL DEFAULT '-1',
33 `ear_left` int(11) NOT NULL DEFAULT '-1',
34 `ear_right` int(11) NOT NULL DEFAULT '-1',
35 `necklace` int(11) NOT NULL DEFAULT '-1',
36 `hand_left` int(11) NOT NULL DEFAULT '-1',
37 `hand_right` int(11) NOT NULL DEFAULT '-1',
38 `chest` int(11) NOT NULL DEFAULT '-1',
39 `feet` int(11) NOT NULL DEFAULT '-1',
40 `divinitytype` enum('sole','pioggia','tempesta') NOT NULL DEFAULT 'sole',
41 `razzia_level` int(11) NOT NULL DEFAULT '0',
42 `razzia_points` bigint(255) NOT NULL DEFAULT '0',
43 `forgin_level` int(11) NOT NULL DEFAULT '0',
44 `forgin_points` bigint(255) NOT NULL DEFAULT '0',
45 `alchemic_level` int(11) NOT NULL DEFAULT '0',
46 `alchemic_points` bigint(255) NOT NULL DEFAULT '0',
47 `cooking_level` int(11) NOT NULL DEFAULT '0',
48 `cooking_points` bigint(255) NOT NULL DEFAULT '0',
49 `id_group` text NOT NULL,
50 `create_time` datetime NOT NULL,
51 PRIMARY KEY (`id`),
52) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
53
54
55--
56-- Struttura della tabella `items`
57--
58
59CREATE TABLE IF NOT EXISTS `items` (
60 `id` int(11) NOT NULL AUTO_INCREMENT,
61 `title` varchar(30) DEFAULT NULL,
62 `description` text,
63 `avatar` text,
64 `level_max` int(11) NOT NULL DEFAULT '0',
65 `hp_max` bigint(255) DEFAULT NULL,
66 `atk_max` bigint(255) DEFAULT '0',
67 `atk_magic_max` bigint(255) DEFAULT '0',
68 `def_max` bigint(255) DEFAULT NULL,
69 `def_magic_max` bigint(255) DEFAULT '0',
70 `dex_max` bigint(255) DEFAULT NULL,
71 `head` enum('yes','no') NOT NULL DEFAULT 'no',
72 `ear_left` enum('yes','no') NOT NULL DEFAULT 'no',
73 `ear_right` enum('yes','no') NOT NULL DEFAULT 'no',
74 `necklace` enum('yes','no') NOT NULL DEFAULT 'no',
75 `hand_left` enum('yes','no') NOT NULL DEFAULT 'no',
76 `hand_right` enum('yes','no') NOT NULL DEFAULT 'no',
77 `chest` enum('yes','no') NOT NULL DEFAULT 'no',
78 `feet` enum('yes','no') NOT NULL DEFAULT 'no',
79 `type` enum('unvendible','treasure','craftable','potion','equipable') NOT NULL DEFAULT 'treasure',
80 /*item_craft = {"id_item":"3"}...*/
81 `items_craft` text NOT NULL DEFAULT 'no',
82 `razziable` enum('yes','no') NOT NULL DEFAULT 'no',
83 `durability` int(11) NOT NULL DEFAULT '0',
84 /*valore di vendita in vers*/
85 `cost` bigint(255) NOT NULL DEFAULT '0',
86 PRIMARY KEY (`id`)
87) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
88
89
90--
91-- Struttura della tabella `mobs`
92--
93
94CREATE TABLE IF NOT EXISTS `mobs` (
95 `id` int(11) NOT NULL AUTO_INCREMENT,
96 `level` int(255) NOT NULL,
97 `name` varchar(30) NOT NULL,
98 `avatar` text NOT NULL,
99 `hp` bigint(255) NOT NULL,
100 `hp_max` bigint(255) NOT NULL,
101 `atk` bigint(255) NOT NULL,
102 `dex` bigint(255) NOT NULL,
103 `vers` bigint(255) NOT NULL,
104 `vers_max` bigint(255) NOT NULL,
105 `place` enum('adventure','boss','event') NOT NULL DEFAULT 'adventure',
106 `event_id`int(11) NOT NULL,
107 /*drops: {"item_id":"1","prob":"10","when":"battle/die"}*/
108 `drops` text NOT NULL,
109 PRIMARY KEY (`id`)
110) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
111
112
113--
114-- Struttura della tabella `account`
115--
116
117CREATE TABLE IF NOT EXISTS `account` (
118 `id` int(11) NOT NULL AUTO_INCREMENT,
119 `username` varchar(20) NOT NULL,
120 `password` text NOT NULL,
121 `log_device` enum('mobile','pc') NOT NULL DEFAULT 'mobile',
122 `current_client_id` text NOT NULL,
123 `last_client_id` text not null,
124 `last_log` datetime NOT NULL,
125 PRIMARY KEY (`id`)
126) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
127
128
129--
130-- Struttura della tabella `meteo`
131--
132
133CREATE TABLE IF NOT EXISTS `meteo` (
134 `id` int(11) NOT NULL AUTO_INCREMENT,
135 /*floor == 0 in evento*/
136 `floor` int(11) NOT NULL,
137 `shiny` int(11) NOT NULL,
138 `umidity` int(11) NOT NULL,
139 `temperature` int(11) NOT NULL,
140 `wind_force` int(11) NOT NULL,
141 PRIMARY KEY (`id`)
142) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;