· 8 years ago · Jul 31, 2018, 06:14 AM
1ALTER TABLE `products_other`
2 ADD INDEX `products_bar_code` (`products_bar_code`),
3 ADD INDEX `products_code` (`products_code`);
4
5ALTER TABLE `categories_extra`
6 ADD COLUMN `digital_documents_suppliers_settings_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'ÐаÑтройки Ñлектронного документооборота' AFTER `is_promo`;
7
8ALTER TABLE `incomes`
9 ADD COLUMN `digital_documents_suppliers_settings_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'ÐаÑтройки Ñлектронного документооборота' AFTER `last_date_update`;
10
11/*
12INSERT INTO `entities_groups` (`entities_groups_title`, `entities_groups_description`) VALUES ('Ðлектронный документооборот', '');
13SET @groupId = LAST_INSERT_ID();
14INSERT INTO `entities` (`entities_groups_id`, `entities_title`, `entities_name`) VALUES (@groupId, 'Ðлектронный документ', 'digital_documents');
15SET @entityId = LAST_INSERT_ID();
16INSERT INTO `entities_types` (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entityId, 'default', 'default');
17
18UPDATE `statuses` SET `statuses_name`='Получено' WHERE `statuses_id`=141;
19INSERT INTO `statuses` (`statuses_name`, `statuses_name_latin`) VALUES ('Проверено', 'Checked');
20SET @statusId1 = LAST_INSERT_ID();
21INSERT INTO `statuses` (`statuses_name`, `statuses_name_latin`) VALUES ('ПодпиÑано', 'Signed');
22SET @statusId2 = LAST_INSERT_ID();
23INSERT INTO `entities_statuses` (`entities_id`, `statuses_id`) VALUES
24 (@entityId, 141),
25 (@entityId, 10),
26 (@entityId, @statusId1),
27 (@entityId, @statusId2)
28;
29
30INSERT INTO `entities` (`entities_groups_id`, `entities_title`, `entities_name`) VALUES
31 ('39', 'натройки поÑтавщика по ÐДО', 'digital_documents_suppliers_settings');
32SET @entityId = LAST_INSERT_ID();
33INSERT INTO `entities_types` (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entityId, 'default', 'default');
34INSERT INTO `entities_statuses` (`entities_id`, `statuses_id`) VALUES
35 (@entityId, 1),
36 (@entityId, 9),
37 (@entityId, 16)
38;
39*/
40
41DROP TABLE IF EXISTS `digital_documents_companies`;
42CREATE TABLE `digital_documents_companies` (
43 `digital_documents_companies_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
44 `digital_documents_companies_name` VARCHAR(256) NOT NULL,
45 PRIMARY KEY (`digital_documents_companies_id`)
46)
47 COMMENT='СервиÑÑ‹ обмена Ñлектронными документами'
48 COLLATE='utf8_general_ci'
49;
50
51DROP TABLE IF EXISTS `digital_documents_unique_fields`;
52CREATE TABLE `digital_documents_unique_fields` (
53 `digital_documents_unique_fields_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
54 `digital_documents_unique_fields_name` VARCHAR(50) NOT NULL,
55 PRIMARY KEY (`digital_documents_unique_fields_id`)
56)
57 COMMENT='Уникальное поле товара Ñлектронного документа'
58 COLLATE='utf8_general_ci'
59;
60
61DROP TABLE IF EXISTS `digital_documents`;
62CREATE TABLE `digital_documents` (
63 `digital_documents_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID документа',
64 `digital_documents_1c_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'ID документа в 1С',
65 `digital_documents_companies_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID ÑервиÑа документооборота',
66 `digital_documents_status` INT(10) UNSIGNED NOT NULL DEFAULT 141,
67 `date_added` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
68 `objects_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID объекта, которому принадлежит документ (акциÑ, поÑтавка)',
69 `entities_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID ÑущноÑти объекта',
70 `entities_types_id` INT(10) UNSIGNED NOT NULL DEFAULT '235',
71 PRIMARY KEY (`digital_documents_id`),
72 UNIQUE INDEX `digital_documents_1c_id` (`digital_documents_1c_id`),
73 INDEX `digital_documents_companies_id` (`digital_documents_companies_id`),
74 INDEX `objects_id_entities_id` (`objects_id`, `entities_id`),
75 INDEX `digital_documents_status` (`digital_documents_status`)
76)
77 COMMENT='Ðлектронные документы'
78 COLLATE='utf8_general_ci'
79 ENGINE=InnoDB
80;
81
82DROP TABLE IF EXISTS `digital_documents_status_history`;
83CREATE TABLE `digital_documents_status_history` (
84 `digital_documents_status_history_id` INT(11) NOT NULL AUTO_INCREMENT,
85 `object_id` INT(11) NOT NULL DEFAULT '0',
86 `customers_id` INT(11) NOT NULL DEFAULT '0',
87 `status_id` INT(11) NOT NULL DEFAULT '0',
88 `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
89 `parent_id` INT(11) NOT NULL DEFAULT '0',
90 PRIMARY KEY (`digital_documents_status_history_id`),
91 INDEX `object_id` (`object_id`),
92 INDEX `status_id` (`status_id`),
93 INDEX `date_added` (`date_added`)
94)
95 COLLATE='utf8_general_ci'
96 ENGINE=InnoDB
97;
98
99DROP TABLE IF EXISTS `digital_documents_to_objects`;
100CREATE TABLE `digital_documents_to_objects` (
101 `digital_documents_to_objects_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
102 `digital_documents_id` INT UNSIGNED NOT NULL COMMENT 'ID документа',
103 `object_id` INT UNSIGNED NOT NULL COMMENT 'ID объекта документа(product_attribute, income_attribute)',
104 `entities_id` INT UNSIGNED NOT NULL COMMENT 'ID ÑущноÑти документа',
105 `digital_documents_to_objects_count` INT UNSIGNED NOT NULL COMMENT 'Кол-во Ñлекментов объекта документа',
106 `date_added` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата добавлениÑ',
107 PRIMARY KEY (`digital_documents_to_objects_id`),
108 INDEX `digital_documents_id` (`digital_documents_id`),
109 INDEX `object_id_entities_id` (`object_id`, `entities_id`)
110)
111 COMMENT='Содержимое документа'
112 COLLATE='utf8_general_ci'
113;
114
115INSERT INTO `digital_documents_companies` (`digital_documents_companies_name`) VALUES ('Synerdocs');
116
117INSERT INTO `digital_documents_unique_fields` (`digital_documents_unique_fields_name`) VALUES
118 ('Ð¡Ð¸Ð½Ñ…Ñ€Ð¾Ð½Ð¸Ð·Ð°Ñ†Ð¸Ñ Ð¿Ð¾ Ðртикул'),
119 ('Ð¡Ð¸Ð½Ñ…Ñ€Ð¾Ð½Ð¸Ð·Ð°Ñ†Ð¸Ñ Ð¿Ð¾ Код'),
120 ('Ð¡Ð¸Ð½Ñ…Ñ€Ð¾Ð½Ð¸Ð·Ð°Ñ†Ð¸Ñ Ð¿Ð¾ ШК')
121;
122
123DROP TABLE IF EXISTS `digital_documents_suppliers_settings`;
124CREATE TABLE `digital_documents_suppliers_settings` (
125 `digital_documents_suppliers_settings_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
126 `suppliers_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID поÑтавщика',
127 `digital_documents_companies_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID ÑервиÑа обмена Ñлектронными документами',
128 `digital_documents_unique_fields_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID уникального Ð¿Ð¾Ð»Ñ Ñ‚Ð¾Ð²Ð°Ñ€Ð°',
129 `suppliers_service_code` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'ID поÑтавщика в рамках учаÑтника ÐДО',
130 `customers_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID пользователÑ, который добавил запиÑÑŒ',
131 `date_added` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
132 `digital_documents_suppliers_settings_status` INT(10) UNSIGNED NOT NULL DEFAULT '1',
133 `entities_types_id` INT(10) UNSIGNED NOT NULL DEFAULT '236',
134 PRIMARY KEY (`digital_documents_suppliers_settings_id`),
135 INDEX `digital_documents_unique_fields_id` (`digital_documents_unique_fields_id`),
136 INDEX `digital_documents_companies_id` (`digital_documents_companies_id`),
137 INDEX `suppliers_id` (`suppliers_id`),
138 INDEX `digital_documents_suppliers_settings_status` (`digital_documents_suppliers_settings_status`)
139)
140 COMMENT='натройки поÑтавщика по Ñлектронному документообороту'
141 COLLATE='utf8_general_ci'
142 ENGINE=InnoDB
143;
144
145DROP TABLE IF EXISTS `digital_documents_suppliers_settings_status_history`;
146CREATE TABLE `digital_documents_suppliers_settings_status_history` (
147 `digital_documents_suppliers_settings_status_history_id` INT(11) NOT NULL AUTO_INCREMENT,
148 `object_id` INT(11) NOT NULL DEFAULT '0',
149 `customers_id` INT(11) NOT NULL DEFAULT '0',
150 `status_id` INT(11) NOT NULL DEFAULT '0',
151 `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
152 `parent_id` INT(11) NOT NULL DEFAULT '0',
153 PRIMARY KEY (`digital_documents_suppliers_settings_status_history_id`),
154 INDEX `object_id` (`object_id`),
155 INDEX `status_id` (`status_id`),
156 INDEX `date_added` (`date_added`)
157)
158 COLLATE='utf8_general_ci'
159 ENGINE=InnoDB
160;
161
162INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('partner', 'supplier-cabinet', 'edit-digital-documents-settings');
163SET @ruleId = LAST_INSERT_ID();
164INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'sale', 'update-digital-documentation');
165SET @ruleId1 = LAST_INSERT_ID();
166INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('call', 'shop', 'update-digital-documentation');
167SET @ruleId2 = LAST_INSERT_ID();
168
169INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`) VALUES
170 (27, @ruleId),
171 (37, @ruleId),
172 (114, @ruleId),
173 (27, @ruleId1),
174 (114, @ruleId1),
175 (27, @ruleId2),
176 (114, @ruleId2)
177;
178
179DROP TABLE IF EXISTS `fias_to_kladr_region_codes`;
180CREATE TABLE `fias_to_kladr_region_codes` (
181 `fias_id` INT(10) UNSIGNED NOT NULL,
182 `kladr_region_code` INT(10) UNSIGNED NOT NULL,
183 PRIMARY KEY (`fias_id`)
184)
185 COMMENT='СоответÑтвие фиаÑа и кода региона в кладр'
186 ENGINE=InnoDB
187;
188
189insert into fias_to_kladr_region_codes
190 select f.id, t.region_code from ((SELECT 1 as region_code, 'd8327a56-80de-4df2-815c-4f6ab1224c50' as AOGUID)
191 UNION
192 (SELECT 2 as region_code, '6f2cbfd8-692a-4ee4-9b16-067210bde3fc' as AOGUID)
193 UNION
194 (SELECT 3 as region_code, 'a84ebed3-153d-4ba9-8532-8bdf879e1f5a' as AOGUID)
195 UNION
196 (SELECT 4 as region_code, '5c48611f-5de6-4771-9695-7e36a4e7529d' as AOGUID)
197 UNION
198 (SELECT 5 as region_code, '0bb7fa19-736d-49cf-ad0e-9774c4dae09b' as AOGUID)
199 UNION
200 (SELECT 6 as region_code, 'b2d8cd20-cabc-4deb-afad-f3c4b4d55821' as AOGUID)
201 UNION
202 (SELECT 7 as region_code, '1781f74e-be4a-4697-9c6b-493057c94818' as AOGUID)
203 UNION
204 (SELECT 8 as region_code, '491cde9d-9d76-4591-ab46-ea93c079e686' as AOGUID)
205 UNION
206 (SELECT 9 as region_code, '61b95807-388a-4cb1-9bee-889f7cf811c8' as AOGUID)
207 UNION
208 (SELECT 10 as region_code, '248d8071-06e1-425e-a1cf-d1ff4c4a14a8' as AOGUID)
209 UNION
210 (SELECT 11 as region_code, 'c20180d9-ad9c-46d1-9eff-d60bc424592a' as AOGUID)
211 UNION
212 (SELECT 12 as region_code, 'de2cbfdf-9662-44a4-a4a4-8ad237ae4a3e' as AOGUID)
213 UNION
214 (SELECT 13 as region_code, '37a0c60a-9240-48b5-a87f-0d8c86cdb6e1' as AOGUID)
215 UNION
216 (SELECT 14 as region_code, 'c225d3db-1db6-4063-ace0-b3fe9ea3805f' as AOGUID)
217 UNION
218 (SELECT 15 as region_code, 'de459e9c-2933-4923-83d1-9c64cfd7a817' as AOGUID)
219 UNION
220 (SELECT 16 as region_code, '0c089b04-099e-4e0e-955a-6bf1ce525f1a' as AOGUID)
221 UNION
222 (SELECT 17 as region_code, '026bc56f-3731-48e9-8245-655331f596c0' as AOGUID)
223 UNION
224 (SELECT 18 as region_code, '52618b9c-bcbb-47e7-8957-95c63f0b17cc' as AOGUID)
225 UNION
226 (SELECT 19 as region_code, '8d3f1d35-f0f4-41b5-b5b7-e7cadf3e7bd7' as AOGUID)
227 UNION
228 (SELECT 20 as region_code, 'de67dc49-b9ba-48a3-a4cc-c2ebfeca6c5e' as AOGUID)
229 UNION
230 (SELECT 21 as region_code, '878fc621-3708-46c7-a97f-5a13a4176b3e' as AOGUID)
231 UNION
232 (SELECT 22 as region_code, '8276c6a1-1a86-4f0d-8920-aba34d4cc34a' as AOGUID)
233 UNION
234 (SELECT 23 as region_code, 'd00e1013-16bd-4c09-b3d5-3cb09fc54bd8' as AOGUID)
235 UNION
236 (SELECT 24 as region_code, 'db9c4f8b-b706-40e2-b2b4-d31b98dcd3d1' as AOGUID)
237 UNION
238 (SELECT 25 as region_code, '43909681-d6e1-432d-b61f-ddac393cb5da' as AOGUID)
239 UNION
240 (SELECT 26 as region_code, '327a060b-878c-4fb4-8dc4-d5595871a3d8' as AOGUID)
241 UNION
242 (SELECT 27 as region_code, '7d468b39-1afa-41ec-8c4f-97a8603cb3d4' as AOGUID)
243 UNION
244 (SELECT 28 as region_code, '844a80d6-5e31-4017-b422-4d9c01e9942c' as AOGUID)
245 UNION
246 (SELECT 29 as region_code, '294277aa-e25d-428c-95ad-46719c4ddb44' as AOGUID)
247 UNION
248 (SELECT 30 as region_code, '83009239-25cb-4561-af8e-7ee111b1cb73' as AOGUID)
249 UNION
250 (SELECT 31 as region_code, '639efe9d-3fc8-4438-8e70-ec4f2321f2a7' as AOGUID)
251 UNION
252 (SELECT 32 as region_code, 'f5807226-8be0-4ea8-91fc-39d053aec1e2' as AOGUID)
253 UNION
254 (SELECT 33 as region_code, 'b8837188-39ee-4ff9-bc91-fcc9ed451bb3' as AOGUID)
255 UNION
256 (SELECT 34 as region_code, 'da051ec8-da2e-4a66-b542-473b8d221ab4' as AOGUID)
257 UNION
258 (SELECT 35 as region_code, 'ed36085a-b2f5-454f-b9a9-1c9a678ee618' as AOGUID)
259 UNION
260 (SELECT 36 as region_code, 'b756fe6b-bbd3-44d5-9302-5bfcc740f46e' as AOGUID)
261 UNION
262 (SELECT 37 as region_code, '0824434f-4098-4467-af72-d4f702fed335' as AOGUID)
263 UNION
264 (SELECT 38 as region_code, '6466c988-7ce3-45e5-8b97-90ae16cb1249' as AOGUID)
265 UNION
266 (SELECT 39 as region_code, '90c7181e-724f-41b3-b6c6-bd3ec7ae3f30' as AOGUID)
267 UNION
268 (SELECT 40 as region_code, '18133adf-90c2-438e-88c4-62c41656de70' as AOGUID)
269 UNION
270 (SELECT 41 as region_code, 'd02f30fc-83bf-4c0f-ac2b-5729a866a207' as AOGUID)
271 UNION
272 (SELECT 42 as region_code, '393aeccb-89ef-4a7e-ae42-08d5cebc2e30' as AOGUID)
273 UNION
274 (SELECT 43 as region_code, '0b940b96-103f-4248-850c-26b6c7296728' as AOGUID)
275 UNION
276 (SELECT 44 as region_code, '15784a67-8cea-425b-834a-6afe0e3ed61c' as AOGUID)
277 UNION
278 (SELECT 45 as region_code, '4a3d970f-520e-46b9-b16c-50d4ca7535a8' as AOGUID)
279 UNION
280 (SELECT 46 as region_code, 'ee594d5e-30a9-40dc-b9f2-0add1be44ba1' as AOGUID)
281 UNION
282 (SELECT 47 as region_code, '6d1ebb35-70c6-4129-bd55-da3969658f5d' as AOGUID)
283 UNION
284 (SELECT 48 as region_code, '1490490e-49c5-421c-9572-5673ba5d80c8' as AOGUID)
285 UNION
286 (SELECT 49 as region_code, '9c05e812-8679-4710-b8cb-5e8bd43cdf48' as AOGUID)
287 UNION
288 (SELECT 50 as region_code, '29251dcf-00a1-4e34-98d4-5c47484a36d4' as AOGUID)
289 UNION
290 (SELECT 51 as region_code, '1c727518-c96a-4f34-9ae6-fd510da3be03' as AOGUID)
291 UNION
292 (SELECT 52 as region_code, '88cd27e2-6a8a-4421-9718-719a28a0a088' as AOGUID)
293 UNION
294 (SELECT 53 as region_code, 'e5a84b81-8ea1-49e3-b3c4-0528651be129' as AOGUID)
295 UNION
296 (SELECT 54 as region_code, '1ac46b49-3209-4814-b7bf-a509ea1aecd9' as AOGUID)
297 UNION
298 (SELECT 55 as region_code, '05426864-466d-41a3-82c4-11e61cdc98ce' as AOGUID)
299 UNION
300 (SELECT 56 as region_code, '8bcec9d6-05bc-4e53-b45c-ba0c6f3a5c44' as AOGUID)
301 UNION
302 (SELECT 57 as region_code, '5e465691-de23-4c4e-9f46-f35a125b5970' as AOGUID)
303 UNION
304 (SELECT 58 as region_code, 'c99e7924-0428-4107-a302-4fd7c0cca3ff' as AOGUID)
305 UNION
306 (SELECT 59 as region_code, '4f8b1a21-e4bb-422f-9087-d3cbf4bebc14' as AOGUID)
307 UNION
308 (SELECT 60 as region_code, 'f6e148a1-c9d0-4141-a608-93e3bd95e6c4' as AOGUID)
309 UNION
310 (SELECT 61 as region_code, 'f10763dc-63e3-48db-83e1-9c566fe3092b' as AOGUID)
311 UNION
312 (SELECT 62 as region_code, '963073ee-4dfc-48bd-9a70-d2dfc6bd1f31' as AOGUID)
313 UNION
314 (SELECT 63 as region_code, 'df3d7359-afa9-4aaa-8ff9-197e73906b1c' as AOGUID)
315 UNION
316 (SELECT 64 as region_code, 'df594e0e-a935-4664-9d26-0bae13f904fe' as AOGUID)
317 UNION
318 (SELECT 65 as region_code, 'aea6280f-4648-460f-b8be-c2bc18923191' as AOGUID)
319 UNION
320 (SELECT 66 as region_code, '92b30014-4d52-4e2e-892d-928142b924bf' as AOGUID)
321 UNION
322 (SELECT 67 as region_code, 'e8502180-6d08-431b-83ea-c7038f0df905' as AOGUID)
323 UNION
324 (SELECT 68 as region_code, 'a9a71961-9363-44ba-91b5-ddf0463aebc2' as AOGUID)
325 UNION
326 (SELECT 69 as region_code, '61723327-1c20-42fe-8dfa-402638d9b396' as AOGUID)
327 UNION
328 (SELECT 70 as region_code, '889b1f3a-98aa-40fc-9d3d-0f41192758ab' as AOGUID)
329 UNION
330 (SELECT 71 as region_code, 'd028ec4f-f6da-4843-ada6-b68b3e0efa3d' as AOGUID)
331 UNION
332 (SELECT 72 as region_code, '54049357-326d-4b8f-b224-3c6dc25d6dd3' as AOGUID)
333 UNION
334 (SELECT 73 as region_code, 'fee76045-fe22-43a4-ad58-ad99e903bd58' as AOGUID)
335 UNION
336 (SELECT 74 as region_code, '27eb7c10-a234-44da-a59c-8b1f864966de' as AOGUID)
337 UNION
338 (SELECT 75 as region_code, 'b6ba5716-eb48-401b-8443-b197c9578734' as AOGUID)
339 UNION
340 (SELECT 76 as region_code, 'a84b2ef4-db03-474b-b552-6229e801ae9b' as AOGUID)
341 UNION
342 (SELECT 77 as region_code, '0c5b2444-70a0-4932-980c-b4dc0d3f02b5' as AOGUID)
343 UNION
344 (SELECT 78 as region_code, 'c2deb16a-0330-4f05-821f-1d09c93331e6' as AOGUID)
345 UNION
346 (SELECT 79 as region_code, '1b507b09-48c9-434f-bf6f-65066211c73e' as AOGUID)
347 UNION
348 (SELECT 80 as region_code, '53ec9705-ec3e-4cbf-921f-229968e10aeb' as AOGUID)
349 UNION
350 (SELECT 81 as region_code, 'e3d95b95-cc2d-440d-95c6-65577fae076e' as AOGUID)
351 UNION
352 (SELECT 82 as region_code, '1e97910c-34fb-428a-a113-13a0024684ae' as AOGUID)
353 UNION
354 (SELECT 83 as region_code, '89db3198-6803-4106-9463-cbf781eff0b8' as AOGUID)
355 UNION
356 (SELECT 84 as region_code, '29a47e2d-7606-481d-98d5-444e755dec34' as AOGUID)
357 UNION
358 (SELECT 85 as region_code, 'c2f0810a-d71e-4af6-85f1-e0bbd81b3e4d' as AOGUID)
359 UNION
360 (SELECT 86 as region_code, 'd66e5325-3a25-4d29-ba86-4ca351d9704b' as AOGUID)
361 UNION
362 (SELECT 87 as region_code, 'f136159b-404a-4f1f-8d8d-d169e1374d5c' as AOGUID)
363 UNION
364 (SELECT 88 as region_code, '2d7468f0-bec1-4571-85f3-bdefd62b3d50' as AOGUID)
365 UNION
366 (SELECT 89 as region_code, '826fa834-3ee8-404f-bdbc-13a5221cfb6e' as AOGUID)
367 UNION
368 (SELECT 91 as region_code, 'bd8e6511-e4b9-4841-90de-6bbc231a789e' as AOGUID)
369 UNION
370 (SELECT 92 as region_code, '6fdecb78-893a-4e3f-a5ba-aa062459463b' as AOGUID)
371 UNION
372 (SELECT 99 as region_code, '63ed1a35-4be6-4564-a1ec-0c51f7383314' as AOGUID)
373 ) as t
374 JOIN fias as f on f.AOGUID = t.AOGUID
375;
376
377/*
378INSERT INTO `suppliers_report_type` (`suppliers_report_type_groups_id`, `name`, `title`, `append_files`, `need_categories_id`) VALUES
379 ('1', 'preliminary_digital_document', 'Первичный документ ÐДО', 'Y', 'Y')
380;*/