· 8 years ago · Jan 27, 2018, 04:24 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.6
3-- http://www.phpmyadmin.net
4--
5-- ХоÑÑ‚: 127.0.0.1:3306
6-- Ð’Ñ€ÐµÐ¼Ñ ÑозданиÑ: Янв 27 2018 г., 20:23
7-- ВерÑÐ¸Ñ Ñервера: 5.1.73-community-log
8-- ВерÑÐ¸Ñ PHP: 5.3.29
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- База данных: `part_crm`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Структура таблицы `cars`
21--
22
23CREATE TABLE IF NOT EXISTS `cars` (
24 `id` int(11) NOT NULL AUTO_INCREMENT,
25 `year` varchar(255) NOT NULL,
26 `brand` varchar(255) NOT NULL,
27 `model` varchar(255) NOT NULL,
28 `engine_vol` varchar(255) NOT NULL,
29 `fuel` varchar(255) NOT NULL,
30 `horsepower` varchar(255) NOT NULL,
31 `drive` varchar(255) NOT NULL,
32 `body` varchar(255) NOT NULL,
33 `gearbox` varchar(255) NOT NULL,
34 `body_code` varchar(255) NOT NULL,
35 `engine_code` varchar(255) NOT NULL,
36 `market` varchar(255) NOT NULL,
37 `completion` varchar(255) NOT NULL,
38 `vin` varchar(255) NOT NULL,
39 `customer_id` int(11) NOT NULL,
40 `update_time` int(11) NOT NULL,
41 PRIMARY KEY (`id`)
42) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
43
44--
45-- Дамп данных таблицы `cars`
46--
47
48INSERT INTO `cars` (`id`, `year`, `brand`, `model`, `engine_vol`, `fuel`, `horsepower`, `drive`, `body`, `gearbox`, `body_code`, `engine_code`, `market`, `completion`, `vin`, `customer_id`, `update_time`) VALUES
49(22, '2016', 'JEEP', 'Wrangler', '3.8', 'дизель', '360', 'полный', 'универÑал 4 дв.', 'ÐКПП', '', '', 'ЕС', 'ЛюкÑури', '1J4CHRG8Y1566777', 53, 0),
50(19, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 40, 0),
51(16, '1995', 'ниÑÑан', 'Ñкайлайн', '2.0', '', '', '', '', '', '', '', '', '', '', 43, 0),
52(21, '1998', 'Тойта', 'ПриуÑ', '1.6', 'бензин', '220', 'полный', '', 'автомат', '', '', '', '', '8888888888888888888', 53, 1512751199),
53(20, '2013', 'рено', 'даÑтер', 'корч', 'корч', '', '', '', '', '', '', '', '', 'vf32bkfwa72794783', 54, 0),
54(17, '', 'тойота', 'ауриÑ', '1,6', '', '', '', '', '', '', '', '', '', 'qwerfcd5436uhyhu', 44, 1510509197),
55(18, '', '', '', '', '', '', '', '', '', '', '', '', '', '123', 51, 0);
56
57-- --------------------------------------------------------
58
59--
60-- Структура таблицы `customers`
61--
62
63CREATE TABLE IF NOT EXISTS `customers` (
64 `id` int(11) NOT NULL AUTO_INCREMENT,
65 `manager_id` int(11) NOT NULL,
66 `surname` varchar(255) CHARACTER SET cp1251 NOT NULL,
67 `name` varchar(255) CHARACTER SET cp1251 NOT NULL,
68 `patronymic` varchar(255) CHARACTER SET cp1251 NOT NULL,
69 `city` varchar(255) CHARACTER SET cp1251 NOT NULL,
70 `address` varchar(255) CHARACTER SET cp1251 NOT NULL,
71 `phone` varchar(255) NOT NULL,
72 `phone2` varchar(255) CHARACTER SET cp1251 NOT NULL,
73 `phone3` varchar(255) CHARACTER SET cp1251 NOT NULL,
74 `email` varchar(255) CHARACTER SET cp1251 NOT NULL,
75 `birth_month` int(11) NOT NULL,
76 `birth_day` int(11) NOT NULL,
77 `birth_year` int(11) NOT NULL,
78 `sex` int(11) NOT NULL,
79 `email2` varchar(255) NOT NULL,
80 `icq_or_skype` varchar(255) NOT NULL,
81 `city2` varchar(255) NOT NULL,
82 `address2` varchar(255) NOT NULL,
83 `update_time` int(11) NOT NULL,
84 `description` text NOT NULL,
85 `time_zone` tinyint(4) NOT NULL,
86 `stopsms` set('0','1') NOT NULL DEFAULT '0',
87 `phone_code` int(1) NOT NULL DEFAULT '1',
88 PRIMARY KEY (`id`)
89) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;
90
91--
92-- Дамп данных таблицы `customers`
93--
94
95INSERT INTO `customers` (`id`, `manager_id`, `surname`, `name`, `patronymic`, `city`, `address`, `phone`, `phone2`, `phone3`, `email`, `birth_month`, `birth_day`, `birth_year`, `sex`, `email2`, `icq_or_skype`, `city2`, `address2`, `update_time`, `description`, `time_zone`, `stopsms`, `phone_code`) VALUES
96(49, 7, '', 'ivan', '', '', '', '79871325555', '89212345567', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
97(50, 8, 'Петров', 'ВаÑилий', 'Иванович', '', '', '79999999999', '55-55-55', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
98(51, 3, '', 'ÐлекÑей', '', '', '', '75298973348', '', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
99(52, 3, 'КовалевÑкаÑ', 'Ирина', '', '', '', '75295937456', '', '', '', 0, 0, 0, 2, '', '', '', '', 0, '', 0, '0', 1),
100(53, 3, '1058', 'ÐÐ»ÐµÐºÑ ÐœÐ°Ñ†Ðº', '', '', '', '71111111111', '37529999999', '', '', 0, 0, 0, 1, '', '', '', '', 1513022032, '', 0, '0', 1),
101(54, 3, 'Беденко', 'ÐлекÑей', '', '', '', '', '375336972751', '', '', 0, 0, 0, 1, '', '', '', '', 1512723348, '', 0, '0', 1),
102(55, 3, '', 'Ð’Ð¾Ð»Ð¾Ð´Ñ ÐºÑ€Ð°Ð¹Ñлер', '', '', '', '75295545544', ',', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
103(56, 4, 'Голопупкин', 'ФеликÑ', '', '', '', '79114875262', '7 (911) 487-5262', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
104(40, 8, 'иванов', 'иван', 'иванович', '', '', '77468855', '89107468855', '', '', 0, 0, 0, 1, '', '', '', '', 0, '10%', 0, '0', 1),
105(41, 8, 'люпо', 'аь', 'ыва', '', '', '77468855', '89769', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
106(42, 8, 'цфы', 'ен', 'лор', '', '', '7876098578', '7487', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
107(43, 7, 'пупкин', 'ваÑилий', '1', '', '', '79822234866', '7 918 2600914', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
108(44, 3, 'ИÑкаков', 'Матвей', 'Равильевич', '', '', '79224729995', '79324814911', '', '', 0, 0, 0, 1, '', '', '', '', 1511119442, 'Долго не забирает детали', 0, '0', 1),
109(45, 7, '', 'ivan', '', '', '', '79871325555', '89212345567', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
110(46, 8, '', 'Ðндрей', '', '', '', '79272165165', '7 (927) 216-5165', '', '', 0, 0, 0, 2, '', '', '', '', 1510677536, '', 0, '0', 1),
111(47, 8, '', 'Дима', '', '', '', '79245678899', '7 (924) 567-8899', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
112(57, 9, 'ТЕСТ', 'ТЕСТ', 'ываыва', '', '', '', '7 (234) 234-23-42', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
113(58, 9, 'апрапр', 'апрапр', 'апрапр', '', '', '', '7 (345) 345-34-53', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1),
114(59, 9, 'апрапр', 'апрапр', 'апрапр', '', '', '3453453453', '7 (345) 345-34-53', '', '', 0, 0, 0, 1, '', '', '', '', 0, '', 0, '0', 1);
115
116-- --------------------------------------------------------
117
118--
119-- Структура таблицы `orders`
120--
121
122CREATE TABLE IF NOT EXISTS `orders` (
123 `id` int(11) NOT NULL AUTO_INCREMENT,
124 `customers_id` int(11) NOT NULL,
125 `manager_id` int(11) NOT NULL,
126 `add_date` int(11) NOT NULL,
127 `status` tinyint(1) NOT NULL DEFAULT '1',
128 `execution_date` int(11) NOT NULL,
129 PRIMARY KEY (`id`)
130) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=121 ;
131
132--
133-- Дамп данных таблицы `orders`
134--
135
136INSERT INTO `orders` (`id`, `customers_id`, `manager_id`, `add_date`, `status`, `execution_date`) VALUES
137(87, 44, 7, 1510510149, 2, 1510510250),
138(90, 44, 7, 1511118976, 2, 1511119075),
139(97, 50, 8, 1511964598, 1, 0),
140(108, 53, 3, 1512723432, 1, 0),
141(92, 43, 7, 1511784084, 1, 0),
142(89, 43, 7, 1510823425, 1, 0),
143(91, 43, 7, 1511709466, 1, 0),
144(96, 40, 3, 1511957331, 1, 0),
145(86, 47, 8, 1510507033, 1, 0),
146(93, 40, 7, 1511784624, 1, 0),
147(106, 51, 3, 1512656880, 1, 0),
148(73, 40, 8, 1506766925, 2, 1506767003),
149(72, 40, 8, 1506766874, 2, 1506767511),
150(95, 40, 7, 1511785531, 2, 1511957156),
151(88, 43, 7, 1510554404, 1, 0),
152(105, 52, 3, 1512656779, 2, 1512724731),
153(104, 51, 3, 1512656329, 2, 1512656394),
154(78, 43, 7, 1508409860, 1, 0),
155(77, 43, 7, 1508409525, 2, 1508409609),
156(118, 53, 7, 1515509027, 1, 0),
157(107, 54, 3, 1512723261, 1, 0),
158(117, 53, 7, 1515508931, 1, 0),
159(116, 55, 4, 1514441968, 1, 0),
160(85, 47, 8, 1510507016, 1, 0),
161(84, 46, 8, 1510506639, 2, 1510506716),
162(83, 40, 7, 1510499164, 1, 0),
163(94, 40, 7, 1511785510, 1, 0),
164(103, 40, 9, 1512221487, 1, 0),
165(82, 43, 7, 1510496226, 2, 1510502365),
166(102, 40, 9, 1512221322, 1, 0),
167(70, 41, 8, 1506765128, 2, 1506765242),
168(69, 41, 8, 1506764870, 2, 1506765019),
169(115, 45, 4, 1514441410, 1, 0),
170(114, 54, 4, 1514280888, 1, 0),
171(101, 40, 7, 1512144219, 1, 0),
172(100, 40, 7, 1512123533, 1, 0),
173(113, 56, 4, 1514272055, 1, 0),
174(99, 44, 7, 1512032261, 1, 0),
175(112, 56, 4, 1514264137, 1, 0),
176(111, 53, 7, 1513019062, 1, 0),
177(110, 55, 3, 1512746087, 2, 1512746339),
178(98, 50, 8, 1511964760, 1, 0),
179(79, 44, 3, 1509182090, 1, 0),
180(109, 54, 3, 1512724757, 2, 1512724766),
181(81, 43, 8, 1510434202, 1, 0),
182(80, 45, 7, 1510159165, 2, 1510437487),
183(74, 42, 8, 1506767133, 2, 1506767289),
184(76, 40, 8, 1506767830, 2, 1506779256),
185(75, 40, 8, 1506767584, 2, 1506767622),
186(71, 42, 8, 1506766614, 2, 1506766711),
187(119, 55, 9, 1516282714, 1, 0),
188(120, 54, 9, 1516282727, 1, 0);
189
190-- --------------------------------------------------------
191
192--
193-- Структура таблицы `order_items`
194--
195
196CREATE TABLE IF NOT EXISTS `order_items` (
197 `id` int(11) NOT NULL AUTO_INCREMENT,
198 `order_id` int(11) NOT NULL,
199 `customer_id` int(11) NOT NULL,
200 `provider` int(11) NOT NULL,
201 `name` varchar(255) CHARACTER SET cp1251 NOT NULL,
202 `code` varchar(255) CHARACTER SET cp1251 NOT NULL,
203 `cost` decimal(10,2) NOT NULL,
204 `cost_purchase` decimal(10,2) NOT NULL,
205 `delivery` int(11) NOT NULL,
206 `status` tinyint(1) NOT NULL DEFAULT '1',
207 `update_time` int(11) NOT NULL,
208 PRIMARY KEY (`id`)
209) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=380 ;
210
211--
212-- Дамп данных таблицы `order_items`
213--
214
215INSERT INTO `order_items` (`id`, `order_id`, `customer_id`, `provider`, `name`, `code`, `cost`, `cost_purchase`, `delivery`, `status`, `update_time`) VALUES
216(339, 69, 41, 14, 'оÑÑŒ маÑтника', 'DDY050221С', '300.00', '280.00', 1506715200, 1, 0),
217(376, 114, 54, 23, 'Ñайлентблок', '10203', '10.00', '7.00', 1512676800, 1, 0),
218(377, 118, 53, 38, 'Колодки передние', 'GDB1654', '1200.00', '1000.00', 1515614400, 1, 0),
219(374, 110, 55, 37, 'шруÑ', 'pcv-1544', '50.00', '0.00', 1512676800, 1, 0),
220(373, 110, 55, 37, 'Ñальник', '1544021/S', '20.00', '15.00', 1512676800, 1, 0),
221(372, 109, 54, 23, 'Ñайлентблок', '10203', '10.00', '7.00', 1512676800, 1, 0),
222(371, 109, 54, 23, 'Ñайлентблок', '10203', '10.00', '7.00', 1512676800, 1, 0),
223(370, 107, 54, 23, 'Ñайлентблок', '10203', '10.00', '7.00', 1512676800, 2, 1512746389),
224(369, 107, 54, 23, 'Ñайлентблок', '10203', '10.00', '7.00', 1512676800, 2, 1512746392),
225(368, 105, 52, 36, 'радиатор', 'Cna2168', '150.00', '100.00', 1512590400, 3, 1512660533),
226(367, 104, 51, 18, 'шруÑ', 'Pvc-1466', '70.00', '50.00', 1512676800, 1, 0),
227(366, 103, 40, 24, 'перед', '', '55.00', '11.00', 1512244800, 1, 0),
228(365, 102, 40, 18, 'Бампер', '00', '5000.00', '2500.00', 1512244800, 2, 1512221371),
229(364, 96, 40, 21, 'dfk', '125', '500.00', '400.00', 1511985600, 1, 0),
230(363, 95, 40, 18, 'Поршень', '1234567890', '2100.00', '900.00', 1511899200, 3, 1511957152),
231(362, 92, 43, 17, 'колодки', '8774', '3200.00', '1800.00', 1508356800, 1, 0),
232(361, 91, 43, 17, 'колодки', '8774', '3200.00', '1800.00', 1508356800, 1, 1511783380),
233(360, 90, 44, 17, 'Шруз2', '21414', '160.00', '90.00', 1511208000, 2, 1511429393),
234(359, 90, 44, 17, 'Шруз', '21414', '110.00', '80.00', 1511208000, 4, 1511429523),
235(358, 89, 43, 17, 'колодки', '8774', '3200.00', '1800.00', 1508356800, 1, 0),
236(357, 88, 43, 17, 'колодки', '8774', '3200.00', '1800.00', 1508356800, 1, 0),
237(356, 87, 44, 14, 'ШароваÑ', '125578г', '1290.00', '800.00', 1510603200, 1, 1510510271),
238(355, 86, 47, 18, 'Фильтр маÑла', 'pbc001', '200.00', '120.00', 1510603200, 1, 1510507201),
239(354, 86, 47, 16, 'ТермоÑтат', 'van123', '500.00', '350.00', 1510603200, 1, 0),
240(353, 84, 46, 17, 'Колодки', 'fb013', '1400.00', '1150.00', 1510689600, 3, 1510589983),
241(352, 82, 43, 17, 'колодки', '8774', '3200.00', '1800.00', 1508356800, 1, 0),
242(351, 81, 43, 17, 'колодки', '8774', '3200.00', '1800.00', 1508356800, 3, 1510436079),
243(350, 80, 45, 18, 'Колодки передние', 'jhjxsv', '500.00', '430.00', 1510516800, 3, 1510437492),
244(349, 79, 44, 14, 'ÑˆÑ€ÑƒÑ Ð½Ð°Ñ€ÑƒÐ¶Ð½Ð¸Ð¹', '22115566', '500.00', '300.00', 1508875200, 2, 1510590392),
245(348, 77, 43, 17, 'колодки', '8774', '3200.00', '1800.00', 1508356800, 3, 1508409629),
246(347, 72, 40, 14, 'дл', 'шг', '564.00', '344.00', 1507060800, 1, 0),
247(346, 74, 42, 16, 'дло', '87', '567.00', '333.00', 1507492800, 1, 0),
248(345, 73, 40, 17, 'шгг', '765', '908.00', '655.00', 1507492800, 3, 1506779158),
249(344, 73, 40, 17, 'шгг', '765', '908.00', '655.00', 1507492800, 3, 1506779162),
250(343, 71, 42, 21, 'вал', '76544', '679.00', '555.00', 1506974400, 1, 0),
251(342, 71, 42, 21, 'вал', '76544', '679.00', '555.00', 1506974400, 1, 0),
252(341, 71, 42, 21, 'вал', '76544', '679.00', '555.00', 1506974400, 1, 0),
253(340, 70, 41, 31, 'кен', 'лдор', '890.00', '800.00', 1506888000, 1, 0),
254(378, 120, 54, 23, 'Ñайлентблок', '10203', '10.00', '7.00', 1512676800, 1, 0),
255(379, 120, 54, 23, 'Ñайлентблок', '10203', '10.00', '7.00', 1512676800, 1, 0);
256
257-- --------------------------------------------------------
258
259--
260-- Структура таблицы `payment_history`
261--
262
263CREATE TABLE IF NOT EXISTS `payment_history` (
264 `id` int(11) NOT NULL AUTO_INCREMENT,
265 `order_id` int(11) NOT NULL,
266 `customer_id` int(11) NOT NULL,
267 `payment` decimal(10,2) NOT NULL,
268 `manager_id` int(11) NOT NULL,
269 `date` int(11) NOT NULL,
270 `update_time` int(11) NOT NULL,
271 PRIMARY KEY (`id`)
272) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;
273
274--
275-- Дамп данных таблицы `payment_history`
276--
277
278INSERT INTO `payment_history` (`id`, `order_id`, `customer_id`, `payment`, `manager_id`, `date`, `update_time`) VALUES
279(52, 80, 45, '200.00', 7, 1510437476, 0),
280(50, 79, 44, '400.00', 3, 1509182374, 0),
281(60, 89, 43, '100.00', 7, 1511786232, 0),
282(51, 80, 45, '300.00', 7, 1510159484, 0),
283(47, 71, 42, '2037.00', 8, 1506766672, 0),
284(61, 94, 40, '2100.00', 3, 1511957210, 0),
285(54, 84, 46, '1000.00', 8, 1510506694, 0),
286(55, 86, 47, '500.00', 8, 1510507211, 0),
287(46, 70, 41, '800.00', 8, 1506765211, 0),
288(53, 82, 43, '300.00', 7, 1510497949, 0),
289(59, 89, 43, '2200.00', 7, 1511786199, 0),
290(49, 77, 43, '3200.00', 7, 1508409583, 0),
291(45, 69, 41, '300.00', 8, 1506764945, 0),
292(58, 89, 43, '1000.00', 7, 1511786174, 0),
293(57, 88, 43, '1.00', 7, 1510571371, 0),
294(67, 110, 55, '70.00', 3, 1512746317, 0),
295(66, 109, 54, '20.00', 3, 1512724764, 0),
296(65, 105, 52, '150.00', 3, 1512724728, 0),
297(56, 87, 44, '500.00', 7, 1510510242, 0),
298(64, 105, 52, '150.00', 3, 1512659908, 0),
299(63, 104, 51, '70.00', 3, 1512656390, 0),
300(62, 102, 40, '1500.00', 9, 1512221381, 0),
301(48, 73, 40, '1816.00', 8, 1506766980, 0);
302
303-- --------------------------------------------------------
304
305--
306-- Структура таблицы `providers`
307--
308
309CREATE TABLE IF NOT EXISTS `providers` (
310 `id` int(11) NOT NULL AUTO_INCREMENT,
311 `name` varchar(255) CHARACTER SET cp1251 NOT NULL,
312 `update_time` int(11) NOT NULL,
313 PRIMARY KEY (`id`)
314) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
315
316--
317-- Дамп данных таблицы `providers`
318--
319
320INSERT INTO `providers` (`id`, `name`, `update_time`) VALUES
321(38, 'Форум-Ðвто', 0),
322(36, 'МотекÑ', 0),
323(23, 'ОФИС', 0),
324(31, 'Ðрмтек', 1501426069),
325(37, 'Шате', 0);
326
327-- --------------------------------------------------------
328
329--
330-- Структура таблицы `requests`
331--
332
333CREATE TABLE IF NOT EXISTS `requests` (
334 `id` int(11) NOT NULL AUTO_INCREMENT,
335 `description` text NOT NULL,
336 `add_date` int(11) NOT NULL,
337 `manager_id` int(11) NOT NULL,
338 `customer_id` int(11) NOT NULL,
339 `update_date` int(11) NOT NULL,
340 `update_manager_id` int(11) NOT NULL,
341 `status` int(11) NOT NULL DEFAULT '1',
342 `importance` int(11) NOT NULL DEFAULT '2',
343 `execution_date` int(11) NOT NULL,
344 PRIMARY KEY (`id`)
345) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
346
347--
348-- Дамп данных таблицы `requests`
349--
350
351INSERT INTO `requests` (`id`, `description`, `add_date`, `manager_id`, `customer_id`, `update_date`, `update_manager_id`, `status`, `importance`, `execution_date`) VALUES
352(22, '<p>Поршень Ð’ÐЗ</p>', 1512144101, 7, 40, 0, 0, 1, 2, 0),
353(23, '<p>бампер перед', 1512221460, 9, 40, 1512221480, 9, 3, 2, 1512221487),
354(24, '<p>Ñайлентблоки передние на шаран</p><p><br></p>', 1512723210, 3, 54, 1512723239, 3, 3, 2, 1516282727),
355(25, '<p>мне надо термоÑтат</p>', 1512746256, 3, 51, 1512746285, 3, 1, 2, 0),
356(20, '<p>вал</p>', 1506767572, 8, 40, 1512056275, 7, 1, 2, 0),
357(21, '<p>необхдимо заказать запчаÑÑ‚ÑŒ</p><p><br></p>', 1508409458, 7, 43, 1511426997, 7, 3, 3, 1511784084),
358(18, '<p>колодки <b><i>Кайрон</i></b></p>', 1506764721, 8, 40, 1513019001, 7, 3, 3, 1511957331),
359(19, '<p>орп</p>', 1506767085, 8, 42, 1506767117, 8, 3, 2, 1506767133),
360(26, '<p>11111111111111111111111111111</p>', 1512750788, 7, 53, 1512750813, 7, 1, 1, 0),
361(27, '<p>22222222222222222</p>', 1512750799, 7, 53, 1512750803, 7, 1, 2, 0),
362(28, '<p>Колодки Мазда 3 R902PBK<br></p>', 1513018918, 7, 45, 0, 0, 1, 2, 0),
363(29, '<p>шина</p>', 1514441937, 4, 55, 1514441961, 4, 1, 2, 0);
364
365-- --------------------------------------------------------
366
367--
368-- Структура таблицы `request_items`
369--
370
371CREATE TABLE IF NOT EXISTS `request_items` (
372 `id` int(11) NOT NULL AUTO_INCREMENT,
373 `request_id` int(11) NOT NULL,
374 `customer_id` int(11) NOT NULL,
375 `manager_id` int(11) NOT NULL,
376 `provider` int(11) NOT NULL,
377 `name` varchar(255) NOT NULL,
378 `code` varchar(255) NOT NULL,
379 `cost` decimal(10,2) NOT NULL,
380 `cost_purchase` decimal(10,2) NOT NULL,
381 `delivery` int(11) NOT NULL,
382 `items` int(11) NOT NULL,
383 `update_time` int(11) NOT NULL,
384 PRIMARY KEY (`id`)
385) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
386
387--
388-- Дамп данных таблицы `request_items`
389--
390
391INSERT INTO `request_items` (`id`, `request_id`, `customer_id`, `manager_id`, `provider`, `name`, `code`, `cost`, `cost_purchase`, `delivery`, `items`, `update_time`) VALUES
392(37, 19, 42, 8, 16, 'дло', '87', '567.00', '333.00', 1507492800, 1, 0),
393(38, 21, 43, 7, 17, 'колодки', '8774', '3200.00', '1800.00', 1508356800, 1, 0),
394(39, 18, 40, 3, 21, 'dfk', '125', '500.00', '400.00', 1511985600, 1, 0),
395(40, 23, 40, 9, 24, 'перед', '', '55.00', '11.00', 1512244800, 1, 0),
396(41, 24, 54, 3, 23, 'Ñайлентблок', '10203', '10.00', '7.00', 1512676800, 2, 1516015796),
397(42, 25, 51, 3, 36, 'термоÑтат', '1336,z0', '50.00', '50.00', 1514145600, 1, 0);
398
399-- --------------------------------------------------------
400
401--
402-- Структура таблицы `settings`
403--
404
405CREATE TABLE IF NOT EXISTS `settings` (
406 `id` int(11) NOT NULL AUTO_INCREMENT,
407 `contract_performer` varchar(255) NOT NULL,
408 `contract_rules` text NOT NULL,
409 `time_zone` tinyint(4) NOT NULL,
410 `winter_time` set('0','1') NOT NULL DEFAULT '0' COMMENT '1 - вÑегда летнее времÑ',
411 `phone_code` int(1) NOT NULL DEFAULT '1',
412 `currency` int(1) NOT NULL DEFAULT '1',
413 PRIMARY KEY (`id`)
414) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
415
416--
417-- Дамп данных таблицы `settings`
418--
419
420INSERT INTO `settings` (`id`, `contract_performer`, `contract_rules`, `time_zone`, `winter_time`, `phone_code`, `currency`) VALUES
421(1, 'iiiiiiiiii', '<h3><b>УÑÐ»Ð¾Ð²Ð¸Ñ Ð¿Ð¾Ñтавки.</b></h3><p>1.Заказ деталей оÑущеÑтвлÑетÑÑ Ð¿Ð¾ данным техпаÑпорта Ð°Ð²Ñ‚Ð¾Ð¼Ð¾Ð±Ð¸Ð»Ñ Ð·Ð°ÐºÐ°Ð·Ñ‡Ð¸ÐºÐ°,при не ÑоответÑтвии фактичеÑким данным автомобилÑ,иÑполнитель ответÑтвенноÑти не неÑет.</p><p>2.При возврате детали не по вине иÑÐ¿Ð¾Ð»Ð½Ð¸Ñ‚ÐµÐ»Ñ Ñ Ð·Ð°ÐºÐ°Ð·Ñ‡Ð¸ÐºÐ° проиводитÑÑ ÑƒÐ´ÐµÑ€Ð¶Ð°Ð½Ð¸Ðµ в Ñумме от 10% до 30% в завиÑимоÑти от поÑтавщика.</p><p>3.Деталь не принимаетÑÑ Ð½Ð° возврат в Ñлучае,видимых признаков уÑтановки ее на транÑпортное ÑредÑтво,а так же порчи упаковки.</p><p>4.Гарантию на запчаÑти,уÑтановленные на ÑтанциÑÑ… техобÑÐ»ÑƒÐ¶Ð¸Ð²Ð°Ð½Ð¸Ñ Ð½Ðµ имеющих ÑоответÑтвующую лицензию и Ñертификат иÑполнитель не дает.</p><span style="background-color: initial;"><p><br></p><table id="table22981" width="100%"><tbody><tr><td width="50%" style="text-align: right;">ИÑполнитель: ____________</td><td width="50%" style="text-align: right;">Заказчик______________</td></tr></tbody></table><p></p></span>', 2, '1', 1, 2);
422
423-- --------------------------------------------------------
424
425--
426-- Структура таблицы `sms_marketing_helper_table`
427--
428
429CREATE TABLE IF NOT EXISTS `sms_marketing_helper_table` (
430 `id` int(11) NOT NULL AUTO_INCREMENT,
431 `customer_id` int(11) NOT NULL,
432 `birthday` smallint(6) NOT NULL,
433 `last_purchase` smallint(6) NOT NULL,
434 `amount` mediumint(9) NOT NULL,
435 `debt` mediumint(9) NOT NULL,
436 `total` smallint(6) NOT NULL,
437 PRIMARY KEY (`id`)
438) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
439
440-- --------------------------------------------------------
441
442--
443-- Структура таблицы `sms_marketing_massages`
444--
445
446CREATE TABLE IF NOT EXISTS `sms_marketing_massages` (
447 `id` int(11) NOT NULL AUTO_INCREMENT,
448 `id_task` int(11) NOT NULL,
449 `id_customer` int(11) NOT NULL,
450 `message` varchar(255) NOT NULL,
451 PRIMARY KEY (`id`)
452) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
453
454-- --------------------------------------------------------
455
456--
457-- Структура таблицы `sms_marketing_message_templates`
458--
459
460CREATE TABLE IF NOT EXISTS `sms_marketing_message_templates` (
461 `id` int(11) NOT NULL AUTO_INCREMENT,
462 `template` varchar(255) NOT NULL,
463 `update_time` int(11) NOT NULL,
464 PRIMARY KEY (`id`)
465) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
466
467-- --------------------------------------------------------
468
469--
470-- Структура таблицы `sms_marketing_task`
471--
472
473CREATE TABLE IF NOT EXISTS `sms_marketing_task` (
474 `id` int(11) NOT NULL AUTO_INCREMENT,
475 `name` varchar(255) NOT NULL,
476 `event` set('once','week','month','always') NOT NULL,
477 `event_val` tinyint(4) NOT NULL,
478 `sending_time` time NOT NULL,
479 `sending_date` date NOT NULL,
480 `condition` set('birthday','last_purchase','debt','amount','total','all') NOT NULL,
481 `condition_logic` set('<','=','>','interval','') NOT NULL,
482 `condition_val` int(11) NOT NULL,
483 `condition_val_max` int(11) NOT NULL,
484 `flag` set('0','1') NOT NULL DEFAULT '0',
485 `message_templates` varchar(255) NOT NULL,
486 `once` set('0','1') NOT NULL,
487 `status` set('0','1') NOT NULL DEFAULT '0',
488 PRIMARY KEY (`id`)
489) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
490
491-- --------------------------------------------------------
492
493--
494-- Структура таблицы `users`
495--
496
497CREATE TABLE IF NOT EXISTS `users` (
498 `id` int(11) NOT NULL AUTO_INCREMENT,
499 `login` varchar(255) NOT NULL,
500 `name` varchar(255) NOT NULL,
501 `password` varchar(255) NOT NULL,
502 `hash` varchar(255) NOT NULL,
503 `time` int(11) NOT NULL,
504 `ip` int(11) NOT NULL,
505 `protected_ip` int(11) NOT NULL,
506 `update_time` int(11) NOT NULL,
507 PRIMARY KEY (`id`)
508) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
509
510--
511-- Дамп данных таблицы `users`
512--
513
514INSERT INTO `users` (`id`, `login`, `name`, `password`, `hash`, `time`, `ip`, `protected_ip`, `update_time`) VALUES
515(1, '', 'Евгений', '9a2e382874ca9e362eb5f01626fbcf3d', '8d2fe97c6312001d778be53a66ecdc6d', 1483677889, 0, 0, 1483702060),
516(2, '', 'Гоглачев Евгений', '02d8496a061a67141a69be6dd6dfd6c4', '8048e89324b522c7de45058126eef4ef', 1500984858, 0, 0, 1509182446),
517(3, 'admin', 'Менеджер #3', '4a7f13cd6e462a67f3dc3761bc9d6bbd', '50aa588417e1c6cc22582d4b5b289815', 1512988860, 0, 0, 1470569964),
518(4, 'admin', 'Менеджер #4', '185cae1c4b6899437f1f58fe40a2ffd4', 'c3e59a504a51f74654f78952e7ed5420', 1516018091, 0, 0, 1470569987),
519(5, 'admin', 'Менеджер #5', '0eab6db8ca4049838639ca7b5bed1f60', 'f63095763e9511515b0f6f25219b19b7', 1514311964, 0, 0, 0),
520(6, 'admin', 'Менеджер #6', 'a7da32b8aac7eead8a6d3ea3780fa9a3', '1c7a8ce618758fb2df7a0417e7550f07', 1513803431, 0, 0, 0),
521(7, 'admin', 'Менеджер #7', '457d26a06bd468ad582e1a0061cbbdd5', '4bbae49d39ffdda063643fefb903fa14', 1515920239, 0, 0, 0),
522(8, 'admin', 'Менеджер #8', '5f4e34374ae1ab68733b8866a0b3b7e1', '22023e0074a78d09cd8afefb63b38820', 1514026329, 0, 0, 0),
523(9, 'admin', 'Менеджер #9', '4417b6af5c437fe0d6ead75029b52411', '02f7883fda20352d8caf1d1d822ffede', 1517076491, 0, 0, 0),
524(10, '', 'ÐлекÑандр-0=-=', '5cd238127f0e47d5ab9919d10d20112d', '88ee9e78328528af3efc573e581e54e4', 1471373403, 0, 0, 1510498216),
525(11, 'Бондаренко', 'Павел', '698d51a19d8a121ce581499d7b701668', '', 0, 0, 0, 0),
526(12, 'Pavel.MIRTIR', 'Бондаренко Павел', '698d51a19d8a121ce581499d7b701668', '', 0, 0, 0, 0),
527(13, '', 'СанÑ', '5583413443164b56500def9a533c7c70', '', 0, 0, 0, 1512723419),
528(14, 'ÑанÑ', 'СанÑ', 'cd6ed16ad56f1911bc8de535b268df8a', '', 0, 0, 0, 0),
529(15, 'леха', 'леха', '1d75e8bdb8a28a076c2bd25aa182dd80', '', 0, 0, 0, 0);