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