YLfRSnHC

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 г., 19:15
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
46--
47-- Структура таблицы `customers`
48--
49
50CREATE TABLE IF NOT EXISTS `customers` (
51  `id` int(11) NOT NULL AUTO_INCREMENT,
52  `manager_id` int(11) NOT NULL,
53  `surname` varchar(255) CHARACTER SET cp1251 NOT NULL,
54  `name` varchar(255) CHARACTER SET cp1251 NOT NULL,
55  `patronymic` varchar(255) CHARACTER SET cp1251 NOT NULL,
56  `city` varchar(255) CHARACTER SET cp1251 NOT NULL,
57  `address` varchar(255) CHARACTER SET cp1251 NOT NULL,
58  `phone` varchar(255) NOT NULL,
59  `phone2` varchar(255) CHARACTER SET cp1251 NOT NULL,
60  `phone3` varchar(255) CHARACTER SET cp1251 NOT NULL,
61  `email` varchar(255) CHARACTER SET cp1251 NOT NULL,
62  `birth_month` int(11) NOT NULL,
63  `birth_day` int(11) NOT NULL,
64  `birth_year` int(11) NOT NULL,
65  `sex` int(11) NOT NULL,
66  `email2` varchar(255) NOT NULL,
67  `icq_or_skype` varchar(255) NOT NULL,
68  `city2` varchar(255) NOT NULL,
69  `address2` varchar(255) NOT NULL,
70  `update_time` int(11) NOT NULL,
71  `description` text NOT NULL,
72  `time_zone` tinyint(4) NOT NULL,
73  `stopsms` set('0','1') NOT NULL DEFAULT '0',
74  `phone_code` int(1) NOT NULL DEFAULT '1',
75  PRIMARY KEY (`id`)
76) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;
77
78-- --------------------------------------------------------
79
80--
81-- Структура таблицы `orders`
82--
83
84CREATE TABLE IF NOT EXISTS `orders` (
85  `id` int(11) NOT NULL AUTO_INCREMENT,
86  `customers_id` int(11) NOT NULL,
87  `manager_id` int(11) NOT NULL,
88  `add_date` int(11) NOT NULL,
89  `status` tinyint(1) NOT NULL DEFAULT '1',
90  `execution_date` int(11) NOT NULL,
91  PRIMARY KEY (`id`)
92) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=121 ;
93
94-- --------------------------------------------------------
95
96--
97-- Структура таблицы `order_items`
98--
99
100CREATE TABLE IF NOT EXISTS `order_items` (
101  `id` int(11) NOT NULL AUTO_INCREMENT,
102  `order_id` int(11) NOT NULL,
103  `customer_id` int(11) NOT NULL,
104  `provider` int(11) NOT NULL,
105  `name` varchar(255) CHARACTER SET cp1251 NOT NULL,
106  `code` varchar(255) CHARACTER SET cp1251 NOT NULL,
107  `cost` decimal(10,2) NOT NULL,
108  `cost_purchase` decimal(10,2) NOT NULL,
109  `delivery` int(11) NOT NULL,
110  `status` tinyint(1) NOT NULL DEFAULT '1',
111  `update_time` int(11) NOT NULL,
112  PRIMARY KEY (`id`)
113) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=380 ;
114
115-- --------------------------------------------------------
116
117--
118-- Структура таблицы `payment_history`
119--
120
121CREATE TABLE IF NOT EXISTS `payment_history` (
122  `id` int(11) NOT NULL AUTO_INCREMENT,
123  `order_id` int(11) NOT NULL,
124  `customer_id` int(11) NOT NULL,
125  `payment` decimal(10,2) NOT NULL,
126  `manager_id` int(11) NOT NULL,
127  `date` int(11) NOT NULL,
128  `update_time` int(11) NOT NULL,
129  PRIMARY KEY (`id`)
130) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;
131
132-- --------------------------------------------------------
133
134--
135-- Структура таблицы `providers`
136--
137
138CREATE TABLE IF NOT EXISTS `providers` (
139  `id` int(11) NOT NULL AUTO_INCREMENT,
140  `name` varchar(255) CHARACTER SET cp1251 NOT NULL,
141  `update_time` int(11) NOT NULL,
142  PRIMARY KEY (`id`)
143) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
144
145-- --------------------------------------------------------
146
147--
148-- Структура таблицы `requests`
149--
150
151CREATE TABLE IF NOT EXISTS `requests` (
152  `id` int(11) NOT NULL AUTO_INCREMENT,
153  `description` text NOT NULL,
154  `add_date` int(11) NOT NULL,
155  `manager_id` int(11) NOT NULL,
156  `customer_id` int(11) NOT NULL,
157  `update_date` int(11) NOT NULL,
158  `update_manager_id` int(11) NOT NULL,
159  `status` int(11) NOT NULL DEFAULT '1',
160  `importance` int(11) NOT NULL DEFAULT '2',
161  `execution_date` int(11) NOT NULL,
162  PRIMARY KEY (`id`)
163) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
164
165-- --------------------------------------------------------
166
167--
168-- Структура таблицы `request_items`
169--
170
171CREATE TABLE IF NOT EXISTS `request_items` (
172  `id` int(11) NOT NULL AUTO_INCREMENT,
173  `request_id` int(11) NOT NULL,
174  `customer_id` int(11) NOT NULL,
175  `manager_id` int(11) NOT NULL,
176  `provider` int(11) NOT NULL,
177  `name` varchar(255) NOT NULL,
178  `code` varchar(255) NOT NULL,
179  `cost` decimal(10,2) NOT NULL,
180  `cost_purchase` decimal(10,2) NOT NULL,
181  `delivery` int(11) NOT NULL,
182  `items` int(11) NOT NULL,
183  `update_time` int(11) NOT NULL,
184  PRIMARY KEY (`id`)
185) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
186
187-- --------------------------------------------------------
188
189--
190-- Структура таблицы `settings`
191--
192
193CREATE TABLE IF NOT EXISTS `settings` (
194  `id` int(11) NOT NULL AUTO_INCREMENT,
195  `contract_performer` varchar(255) NOT NULL,
196  `contract_rules` text NOT NULL,
197  `time_zone` tinyint(4) NOT NULL,
198  `winter_time` set('0','1') NOT NULL DEFAULT '0' COMMENT '1 - всегда летнее время',
199  `phone_code` int(1) NOT NULL DEFAULT '1',
200  `currency` int(1) NOT NULL DEFAULT '1',
201  PRIMARY KEY (`id`)
202) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
203
204-- --------------------------------------------------------
205
206--
207-- Структура таблицы `sms_marketing_helper_table`
208--
209
210CREATE TABLE IF NOT EXISTS `sms_marketing_helper_table` (
211  `id` int(11) NOT NULL AUTO_INCREMENT,
212  `customer_id` int(11) NOT NULL,
213  `birthday` smallint(6) NOT NULL,
214  `last_purchase` smallint(6) NOT NULL,
215  `amount` mediumint(9) NOT NULL,
216  `debt` mediumint(9) NOT NULL,
217  `total` smallint(6) NOT NULL,
218  PRIMARY KEY (`id`)
219) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
220
221-- --------------------------------------------------------
222
223--
224-- Структура таблицы `sms_marketing_massages`
225--
226
227CREATE TABLE IF NOT EXISTS `sms_marketing_massages` (
228  `id` int(11) NOT NULL AUTO_INCREMENT,
229  `id_task` int(11) NOT NULL,
230  `id_customer` int(11) NOT NULL,
231  `message` varchar(255) NOT NULL,
232  PRIMARY KEY (`id`)
233) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
234
235-- --------------------------------------------------------
236
237--
238-- Структура таблицы `sms_marketing_message_templates`
239--
240
241CREATE TABLE IF NOT EXISTS `sms_marketing_message_templates` (
242  `id` int(11) NOT NULL AUTO_INCREMENT,
243  `template` varchar(255) NOT NULL,
244  `update_time` int(11) NOT NULL,
245  PRIMARY KEY (`id`)
246) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
247
248-- --------------------------------------------------------
249
250--
251-- Структура таблицы `sms_marketing_task`
252--
253
254CREATE TABLE IF NOT EXISTS `sms_marketing_task` (
255  `id` int(11) NOT NULL AUTO_INCREMENT,
256  `name` varchar(255) NOT NULL,
257  `event` set('once','week','month','always') NOT NULL,
258  `event_val` tinyint(4) NOT NULL,
259  `sending_time` time NOT NULL,
260  `sending_date` date NOT NULL,
261  `condition` set('birthday','last_purchase','debt','amount','total','all') NOT NULL,
262  `condition_logic` set('<','=','>','interval','') NOT NULL,
263  `condition_val` int(11) NOT NULL,
264  `condition_val_max` int(11) NOT NULL,
265  `flag` set('0','1') NOT NULL DEFAULT '0',
266  `message_templates` varchar(255) NOT NULL,
267  `once` set('0','1') NOT NULL,
268  `status` set('0','1') NOT NULL DEFAULT '0',
269  PRIMARY KEY (`id`)
270) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
271
272-- --------------------------------------------------------
273
274--
275-- Структура таблицы `users`
276--
277
278CREATE TABLE IF NOT EXISTS `users` (
279  `id` int(11) NOT NULL AUTO_INCREMENT,
280  `login` varchar(255) NOT NULL,
281  `name` varchar(255) NOT NULL,
282  `password` varchar(255) NOT NULL,
283  `hash` varchar(255) NOT NULL,
284  `time` int(11) NOT NULL,
285  `ip` int(11) NOT NULL,
286  `protected_ip` int(11) NOT NULL,
287  `update_time` int(11) NOT NULL,
288  PRIMARY KEY (`id`)
289) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;