· 5 years ago · May 10, 2020, 08:18 PM
1CREATE TABLE IF NOT EXISTS `wood` (
2 `id` int(255) NOT NULL AUTO_INCREMENT,
3 `name` char(50) NOT NULL,
4 `img` char(40) NOT NULL,
5 `price` double NOT NULL DEFAULT '0',
6 `mass` double NOT NULL DEFAULT '0',
7 `iznos_max` int(255) NOT NULL DEFAULT '1',
8 PRIMARY KEY (`id`),
9 KEY `id` (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=370 ;
11
12
13CREATE TABLE IF NOT EXISTS `inv` (
14 `id` int(11) NOT NULL AUTO_INCREMENT,
15 `owner` char(30) NOT NULL,
16 `object_id` smallint(6) NOT NULL DEFAULT '0',
17 `object_type` char(15) NOT NULL,
18 `object_razdel` char(10) NOT NULL,
19 `slot` char(30) NOT NULL,
20 `gift` tinyint(2) NOT NULL DEFAULT '0',
21 `wear` tinyint(2) NOT NULL DEFAULT '0',
22 `iznos` smallint(6) NOT NULL DEFAULT '0',
23 `gift_author` char(30) NOT NULL,
24 `iznos_max` smallint(6) NOT NULL DEFAULT '0',
25 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
26 `term` char(30) NOT NULL,
27 `msg` char(250) NOT NULL,
28 `is_modified` tinyint(3) NOT NULL DEFAULT '0',
29 `noremont` tinyint(2) NOT NULL DEFAULT '0',
30 `gravirovka` char(50) NOT NULL,
31 `bs` tinyint(2) NOT NULL DEFAULT '0',
32 `runas` char(50) NOT NULL,
33 `edited` tinyint(2) NOT NULL DEFAULT '0',
34 `add_xp` smallint(6) NOT NULL DEFAULT '0',
35 `name` char(50) NOT NULL,
36 `name_rus` char(100) NOT NULL,
37 `name_aze` char(100) NOT NULL,
38 `name_tur` char(100) NOT NULL,
39 `img` char(50) NOT NULL,
40 `price` float NOT NULL DEFAULT '0',
41 `gos_price` float NOT NULL DEFAULT '0',
42 `mass` float NOT NULL DEFAULT '0',
43 `min_sila` smallint(6) NOT NULL DEFAULT '0',
44 `min_lovkost` smallint(6) NOT NULL DEFAULT '0',
45 `min_udacha` smallint(6) NOT NULL DEFAULT '0',
46 `min_power` smallint(6) NOT NULL DEFAULT '0',
47 `min_intellekt` smallint(6) NOT NULL DEFAULT '0',
48 `min_vospriyatie` smallint(6) NOT NULL DEFAULT '0',
49 `min_level` tinyint(4) NOT NULL DEFAULT '0',
50 `max_level` int(255) NOT NULL DEFAULT '0',
51 `min_sword_vl` tinyint(4) NOT NULL DEFAULT '0',
52 `min_staff_vl` tinyint(4) NOT NULL DEFAULT '0',
53 `min_axe_vl` tinyint(4) NOT NULL DEFAULT '0',
54 `min_fail_vl` tinyint(4) NOT NULL DEFAULT '0',
55 `min_knife_vl` tinyint(4) NOT NULL DEFAULT '0',
56 `min_spear_vl` tinyint(4) NOT NULL DEFAULT '0',
57 `min_fire` tinyint(4) NOT NULL DEFAULT '0',
58 `min_water` tinyint(4) NOT NULL DEFAULT '0',
59 `min_air` tinyint(4) NOT NULL DEFAULT '0',
60 `min_earth` tinyint(4) NOT NULL DEFAULT '0',
61 `min_svet` tinyint(4) NOT NULL DEFAULT '0',
62 `min_tma` tinyint(4) NOT NULL DEFAULT '0',
63 `min_gray` tinyint(4) NOT NULL DEFAULT '0',
64 `add_fire` tinyint(4) NOT NULL DEFAULT '0',
65 `add_water` tinyint(4) NOT NULL DEFAULT '0',
66 `add_air` tinyint(4) NOT NULL DEFAULT '0',
67 `add_earth` tinyint(4) NOT NULL DEFAULT '0',
68 `add_svet` tinyint(4) NOT NULL DEFAULT '0',
69 `add_tma` tinyint(4) NOT NULL DEFAULT '0',
70 `add_gray` tinyint(4) NOT NULL DEFAULT '0',
71 `add_sila` smallint(6) NOT NULL DEFAULT '0',
72 `add_lovkost` smallint(6) NOT NULL DEFAULT '0',
73 `add_udacha` smallint(6) NOT NULL DEFAULT '0',
74 `add_intellekt` smallint(6) NOT NULL DEFAULT '0',
75 `add_duxovnost` smallint(6) NOT NULL DEFAULT '0',
76 `add_hp` smallint(6) NOT NULL DEFAULT '0',
77 `add_mana` smallint(6) NOT NULL DEFAULT '0',
78 `protect_head` smallint(6) NOT NULL DEFAULT '0',
79 `protect_arm` smallint(6) NOT NULL DEFAULT '0',
80 `protect_corp` smallint(6) NOT NULL DEFAULT '0',
81 `protect_poyas` smallint(6) NOT NULL DEFAULT '0',
82 `protect_legs` smallint(6) NOT NULL DEFAULT '0',
83 `protect_rej` smallint(6) NOT NULL DEFAULT '0',
84 `protect_drob` smallint(6) NOT NULL DEFAULT '0',
85 `protect_kol` smallint(6) NOT NULL DEFAULT '0',
86 `protect_rub` smallint(6) NOT NULL DEFAULT '0',
87 `protect_fire` smallint(6) NOT NULL DEFAULT '0',
88 `protect_water` smallint(6) NOT NULL DEFAULT '0',
89 `protect_air` smallint(6) NOT NULL DEFAULT '0',
90 `protect_earth` smallint(6) NOT NULL DEFAULT '0',
91 `protect_svet` smallint(6) NOT NULL DEFAULT '0',
92 `protect_tma` smallint(6) NOT NULL DEFAULT '0',
93 `protect_gray` smallint(6) NOT NULL DEFAULT '0',
94 `protect_mag` smallint(6) NOT NULL DEFAULT '0',
95 `protect_udar` smallint(6) NOT NULL DEFAULT '0',
96 `shieldblock` smallint(6) NOT NULL DEFAULT '0',
97 `krit` smallint(6) NOT NULL DEFAULT '0',
98 `akrit` smallint(6) NOT NULL DEFAULT '0',
99 `uvorot` smallint(6) NOT NULL DEFAULT '0',
100 `auvorot` smallint(6) NOT NULL DEFAULT '0',
101 `parry` smallint(6) NOT NULL DEFAULT '0',
102 `counter` smallint(6) NOT NULL DEFAULT '0',
103 `add_rej` smallint(6) NOT NULL DEFAULT '0',
104 `add_drob` smallint(6) NOT NULL DEFAULT '0',
105 `add_kol` smallint(6) NOT NULL DEFAULT '0',
106 `add_rub` smallint(6) NOT NULL DEFAULT '0',
107 `add_fire_att` smallint(6) NOT NULL DEFAULT '0',
108 `add_air_att` smallint(6) NOT NULL DEFAULT '0',
109 `add_watet_att` smallint(6) NOT NULL DEFAULT '0',
110 `add_earth_att` smallint(6) NOT NULL DEFAULT '0',
111 `ms_udar` smallint(6) NOT NULL DEFAULT '0',
112 `ms_krit` smallint(6) NOT NULL DEFAULT '0',
113 `ms_mag` smallint(6) NOT NULL DEFAULT '0',
114 `ms_fire` smallint(6) NOT NULL DEFAULT '0',
115 `ms_water` smallint(6) NOT NULL DEFAULT '0',
116 `ms_air` smallint(6) NOT NULL DEFAULT '0',
117 `ms_earth` smallint(6) NOT NULL DEFAULT '0',
118 `ms_svet` smallint(6) NOT NULL DEFAULT '0',
119 `ms_tma` smallint(6) NOT NULL DEFAULT '0',
120 `ms_gray` smallint(6) NOT NULL DEFAULT '0',
121 `ms_rej` smallint(6) NOT NULL DEFAULT '0',
122 `ms_drob` smallint(6) NOT NULL DEFAULT '0',
123 `ms_kol` smallint(6) NOT NULL DEFAULT '0',
124 `ms_rub` smallint(6) NOT NULL DEFAULT '0',
125 `min_attack` smallint(6) NOT NULL DEFAULT '0',
126 `max_attack` smallint(6) NOT NULL DEFAULT '0',
127 `proboy` smallint(6) NOT NULL DEFAULT '0',
128 `add_oruj` smallint(6) NOT NULL DEFAULT '0',
129 `add_sword_vl` tinyint(4) NOT NULL DEFAULT '0',
130 `add_staff_vl` tinyint(4) NOT NULL DEFAULT '0',
131 `add_axe_vl` tinyint(4) NOT NULL DEFAULT '0',
132 `add_fail_vl` tinyint(4) NOT NULL DEFAULT '0',
133 `add_knife_vl` tinyint(4) NOT NULL DEFAULT '0',
134 `add_spear_vl` tinyint(4) NOT NULL DEFAULT '0',
135 `need_orden` tinyint(4) NOT NULL DEFAULT '0',
136 `sex` char(8) NOT NULL,
137 `art` tinyint(4) NOT NULL DEFAULT '0',
138 `podzemka` tinyint(4) NOT NULL DEFAULT '0',
139 `is_personal` tinyint(4) NOT NULL DEFAULT '0',
140 `personal_owner` char(30) NOT NULL,
141 `personal_art` tinyint(4) NOT NULL DEFAULT '0',
142 `two_hand` tinyint(4) NOT NULL DEFAULT '0',
143 `second_hand` tinyint(4) NOT NULL DEFAULT '0',
144 `add_ups` smallint(6) NOT NULL DEFAULT '0',
145 `add_umenie` smallint(6) NOT NULL DEFAULT '0',
146 `add_mf` smallint(6) NOT NULL DEFAULT '0',
147 `is_add_mf` int(11) NOT NULL DEFAULT '0',
148 `is_add_ups` int(11) NOT NULL DEFAULT '0',
149 `magic_id` int(11) NOT NULL DEFAULT '0',
150 `daily_iznos` tinyint(4) NOT NULL DEFAULT '0',
151 `clan_id` char(100) NOT NULL,
152 `wearable` tinyint(4) NOT NULL DEFAULT '0',
153 `is_manat` tinyint(4) NOT NULL DEFAULT '0',
154 `is_glava` tinyint(4) NOT NULL DEFAULT '0',
155 `klass` char(10) NOT NULL,
156 `br_rgb` text NOT NULL,
157 `br_css` text NOT NULL,
158 `voin` int(255) NOT NULL,
159 `mag` int(255) NOT NULL,
160 `luboya` int(255) NOT NULL,
161 PRIMARY KEY (`id`),
162 KEY `id` (`id`),
163 KEY `object_id` (`object_id`),
164 KEY `object_type` (`object_type`),
165 KEY `iznos` (`iznos`),
166 KEY `term` (`term`),
167 KEY `date` (`date`),
168 KEY `gift` (`gift`),
169 KEY `bs` (`bs`),
170 KEY `owner` (`owner`),
171 KEY `runas` (`runas`),
172 KEY `object_razdel` (`object_razdel`),
173 KEY `name` (`name`),
174 KEY `min_level` (`min_level`),
175 KEY `clan_id` (`clan_id`),
176 KEY `is_manat` (`is_manat`),
177 KEY `is_add_mf` (`is_add_mf`,`is_add_ups`)
178) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;