· 6 years ago · Apr 23, 2019, 03:08 PM
1-- --------------------------------------------------------
2-- ХоÑÑ‚: 127.0.0.1
3-- ВерÑÐ¸Ñ Ñервера: 5.5.54-0+deb8u1 - (Debian)
4-- ÐžÐ¿ÐµÑ€Ð°Ñ†Ð¸Ð¾Ð½Ð½Ð°Ñ ÑиÑтема: debian-linux-gnu
5-- HeidiSQL ВерÑиÑ: 9.5.0.5295
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Дамп Ñтруктуры Ð´Ð»Ñ Ñ‚Ð°Ð±Ð»Ð¸Ñ†Ð° dev_company_6.data_load_item
15CREATE TABLE IF NOT EXISTS `data_load_item` (
16 `id` int(11) NOT NULL AUTO_INCREMENT,
17 `url` varchar(2000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
18 `rules` varchar(10000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
19 `data_load_id` int(11) NOT NULL,
20 `active` int(11) NOT NULL DEFAULT '1',
21 `order` int(11) NOT NULL,
22 PRIMARY KEY (`id`)
23) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
24
25-- Дамп данных таблицы dev_company_6.data_load_item: ~27 rows (приблизительно)
26DELETE FROM `data_load_item`;
27/*!40000 ALTER TABLE `data_load_item` DISABLE KEYS */;
28INSERT INTO `data_load_item` (`id`, `url`, `rules`, `data_load_id`, `active`, `order`) VALUES
29 (1, '/utnew2018/hs/GetJSData/ArrayCatalogue/2', '{"table":"organizations","incomeIdName":"ID","fields":{"income_id":"ID","code":"ИÐÐ"}, "variables":{"uid":["getConst","1"], "name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}], "create_at":["currentDateTime"]}}', 1, 1, 1),
30 (3, '/bkgr_acc/hs/GetJSData/ArrayCatalogue/3', '{"table":"contractors", "incomeIdName":"ИÐÐ",\r\n"filter":{"ИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ИÐÐ","code":"КПП","edrpou":"ИÐÐ","title":"ÐаименованиеПолное","is_delete":"ПометкаУдалениÑ"},\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 10),
31 (4, '/ut_new/hs/GetJSData/ArrayCatalogue/4', '{"table":"bank", "incomeIdName":"ID",\r\n\r\n"fields":{"income_id":"ID", "mfo":"БИК" },\r\n "variables":{"import_template_id":["getConst","1"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 1, 1, 4),
32 (5, '/ut_new/hs/GetJSData/ArrayCatalogue/5', '{"table":"accounts","incomeIdName":"ID",\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_oid":"OwnerID","income_bank_id":"bankID","income_currency_id":"valyutaID", "is_delete":"ПометкаУдалениÑ","title":"ÐомерСчета"},\r\n\r\n\r\n"foreignFields":{"valyutaID":"currency.income_id","OwnerID":"organizations.income_id","bankID":"bank.income_id"}, "foreignKeys":{"oid":"OwnerID", "bank_id":"bankID","currency_id":"valyutaID"},\r\n\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 1, 1, 7),
33 (6, '/ut_new/hs/GetJSData/ArrayCatalogue/7', '{"table":"currency","incomeIdName":"ID","fields":{"income_id":"ID","code":"Код","name":"Ðаименование"}, "variables":{"create_at":["currentDateTime"]}}', 1, 0, 5),
34 (8, '/bkgr_acc/hs/GetJSData/ArrayCatalogue/6', '{"table":"accounts_other","incomeIdName":"ID",\r\n"filter":{"ВладелецИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_kid":"ВладелецИÐÐ", "title":"ÐомерСчета","bank_name":"БанкÐаименование","is_delete":"ПометкаУдалениÑ","mfo":"БанкБИК"},\r\n\r\n"foreignFields":{"ВладелецИÐÐ":"contractors.income_id"}, "foreignKeys":{"kid":"ВладелецИÐÐ"},\r\n "variables":{"uid":["getConst","1"], "currency_id":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 20),
35 (10, '', '{"table":"items", \r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}', 2, 0, 1),
36 (11, '/dvgr_acc/hs/GetJSData/ArrayCatalogue/3', '{"table":"contractors", "incomeIdName":"ИÐÐ",\r\n"filter":{"ИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ИÐÐ","code":"КПП","edrpou":"ИÐÐ","title":"ÐаименованиеПолное","is_delete":"ПометкаУдалениÑ"},\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 11),
37 (12, '/luk_acc/hs/GetJSData/ArrayCatalogue/3', '{"table":"contractors", "incomeIdName":"ИÐÐ",\r\n"filter":{"ИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ИÐÐ","code":"КПП","edrpou":"ИÐÐ","title":"ÐаименованиеПолное","is_delete":"ПометкаУдалениÑ"},\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 12),
38 (13, '/ooobk_acc/hs/GetJSData/ArrayCatalogue/3', '{"table":"contractors", "incomeIdName":"ИÐÐ",\r\n"filter":{"ИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ИÐÐ","code":"КПП","edrpou":"ИÐÐ","title":"ÐаименованиеПолное","is_delete":"ПометкаУдалениÑ"},\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 13),
39 (14, '/pan_acc/hs/GetJSData/ArrayCatalogue/3', '{"table":"contractors", "incomeIdName":"ИÐÐ",\r\n"filter":{"ИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ИÐÐ","code":"КПП","edrpou":"ИÐÐ","title":"ÐаименованиеПолное","is_delete":"ПометкаУдалениÑ"},\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 14),
40 (15, '/trend_acc/hs/GetJSData/ArrayCatalogue/3', '{"table":"contractors", "incomeIdName":"ИÐÐ",\r\n"filter":{"ИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ИÐÐ","code":"КПП","edrpou":"ИÐÐ","title":"ÐаименованиеПолное","is_delete":"ПометкаУдалениÑ"},\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 15),
41 (16, '/dvgr_acc/hs/GetJSData/ArrayCatalogue/6', '{"table":"accounts_other","incomeIdName":"ID",\r\n"filter":{"ВладелецИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_kid":"ВладелецИÐÐ", "title":"ÐомерСчета","bank_name":"БанкÐаименование","is_delete":"ПометкаУдалениÑ","mfo":"БанкБИК"},\r\n\r\n"foreignFields":{"ВладелецИÐÐ":"contractors.income_id"}, "foreignKeys":{"kid":"ВладелецИÐÐ"},\r\n "variables":{"uid":["getConst","1"], "currency_id":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 21),
42 (17, '/luk_acc/hs/GetJSData/ArrayCatalogue/6', '{"table":"accounts_other","incomeIdName":"ID",\r\n"filter":{"ВладелецИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_kid":"ВладелецИÐÐ", "title":"ÐомерСчета","bank_name":"БанкÐаименование","is_delete":"ПометкаУдалениÑ","mfo":"БанкБИК"},\r\n\r\n"foreignFields":{"ВладелецИÐÐ":"contractors.income_id"}, "foreignKeys":{"kid":"ВладелецИÐÐ"},\r\n "variables":{"uid":["getConst","1"], "currency_id":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 22),
43 (18, '/ooobk_acc/hs/GetJSData/ArrayCatalogue/6', '{"table":"accounts_other","incomeIdName":"ID",\r\n"filter":{"ВладелецИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_kid":"ВладелецИÐÐ", "title":"ÐомерСчета","bank_name":"БанкÐаименование","is_delete":"ПометкаУдалениÑ","mfo":"БанкБИК"},\r\n\r\n"foreignFields":{"ВладелецИÐÐ":"contractors.income_id"}, "foreignKeys":{"kid":"ВладелецИÐÐ"},\r\n "variables":{"uid":["getConst","1"], "currency_id":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 23),
44 (19, '/pan_acc/hs/GetJSData/ArrayCatalogue/6', '{"table":"accounts_other","incomeIdName":"ID",\r\n"filter":{"ВладелецИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_kid":"ВладелецИÐÐ", "title":"ÐомерСчета","bank_name":"БанкÐаименование","is_delete":"ПометкаУдалениÑ","mfo":"БанкБИК"},\r\n\r\n"foreignFields":{"ВладелецИÐÐ":"contractors.income_id"}, "foreignKeys":{"kid":"ВладелецИÐÐ"},\r\n "variables":{"uid":["getConst","1"], "currency_id":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 24),
45 (20, '/trend_acc/hs/GetJSData/ArrayCatalogue/6', '{"table":"accounts_other","incomeIdName":"ID",\r\n"filter":{"ВладелецИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_kid":"ВладелецИÐÐ", "title":"ÐомерСчета","bank_name":"БанкÐаименование","is_delete":"ПометкаУдалениÑ","mfo":"БанкБИК"},\r\n\r\n"foreignFields":{"ВладелецИÐÐ":"contractors.income_id"}, "foreignKeys":{"kid":"ВладелецИÐÐ"},\r\n "variables":{"uid":["getConst","1"], "currency_id":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 25),
46 (21, '', '{"table":"applications",\r\n"transCrossToFlat":{"firstRowRightFrom":["3","Date"], "bodyRightFrom":["3","Sum"]},\r\n"date":["Date"],\r\n"catalogs":[["item_id","ru"]],\r\n"fields":{\r\n"item_id":"СтатьÑ",\r\n"add_catalog2_id":"Вид",\r\n"sum":"Sum",\r\n"date_pay":"Date"\r\n}\r\n}', 2, 1, 1),
47 (22, '/acc_nik/hs/GetJSData/ArrayCatalogue/3', '{"table":"contractors", "incomeIdName":"ИÐÐ",\r\n"filter":{"ИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ИÐÐ","edrpou":"ИÐÐ","title":"ÐаименованиеПолное","is_delete":"ПометкаУдалениÑ"},\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 16),
48 (23, '/acc_nik/hs/GetJSData/ArrayCatalogue/6', '{"table":"accounts_other","incomeIdName":"ID",\r\n"filter":{"ВладелецИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_kid":"ВладелецИÐÐ", "title":"ÐомерСчета","bank_name":"БанкÐаименование","is_delete":"ПометкаУдалениÑ","mfo":"БанкБИК"},\r\n\r\n"foreignFields":{"ВладелецИÐÐ":"contractors.income_id"}, "foreignKeys":{"kid":"ВладелецИÐÐ"},\r\n "variables":{"uid":["getConst","1"], "currency_id":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 26),
49 (24, '/utnew2018/hs/GetJSData/ArrayCatalogue/5', '{"table":"accounts","incomeIdName":"ID",\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_oid":"OwnerID","income_bank_id":"bankID","income_currency_id":"valyutaID", "is_delete":"ПометкаУдалениÑ","title":"ÐомерСчета"},\r\n\r\n\r\n"foreignFields":{"valyutaID":"currency.income_id","OwnerID":"organizations.income_id","bankID":"bank.income_id"}, "foreignKeys":{"oid":"OwnerID", "bank_id":"bankID","currency_id":"valyutaID"},\r\n\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 1, 1, 6),
50 (25, '/acc_luk2/hs/GetJSData/ArrayCatalogue/2', '{"table":"organizations","incomeIdName":"ID","fields":{"income_id":"ID","code_kpp":"КПП","code":"ИÐÐ"}, "variables":{"uid":["getConst","1"], "name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}], "create_at":["currentDateTime"]}}', 3, 1, 1),
51 (26, '/acc_luk2/hs/GetJSData/ArrayCatalogue/5', '{"table":"accounts","incomeIdName":"ID",\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_oid":"OwnerID","income_bank_id":"bankID", "is_delete":"ПометкаУдалениÑ","title":"ÐомерСчета"},\r\n"acceptableValuesForColumn":{"OwnerID":["574ad7cb-ba72-11e8-8c22-a4bf0109d682"]},\r\n"foreignFields":{"valyutaID":"currency.income_id","OwnerID":"organizations.income_id"}, "foreignKeys":{"oid":"OwnerID"},\r\n\r\n "variables":{"uid":["getConst","1"],"currency_id":["getConst","15"], "bank_id":["getConst","7382"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 27),
52 (27, '/acc_luk2/hs/GetJSData/ArrayCatalogue/3', '{"table":"contractors", "incomeIdName":"ИÐÐ",\r\n"filter":{"ИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ИÐÐ","code":"КПП","edrpou":"ИÐÐ","title":"ÐаименованиеПолное","is_delete":"ПометкаУдалениÑ"},\r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 17),
53 (28, '/acc_luk2/hs/GetJSData/ArrayCatalogue/6', '{"table":"accounts_other","incomeIdName":"ID",\r\n"filter":{"ВладелецИÐÐ":""},\r\n"bool":["ПометкаУдалениÑ"],\r\n"fields":{"income_id":"ID", "income_kid":"ВладелецИÐÐ", "title":"ÐомерСчета","bank_name":"БанкÐаименование","is_delete":"ПометкаУдалениÑ","mfo":"БанкБИК"},\r\n\r\n"foreignFields":{"ВладелецИÐÐ":"contractors.income_id"}, "foreignKeys":{"kid":"ВладелецИÐÐ"},\r\n "variables":{"uid":["getConst","1"], "currency_id":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 28),
54 (29, '/acc_luk2/hs/GetJSData/ArrayCatalogue/4', '{"table":"bank", "incomeIdName":"ID",\r\n\r\n"fields":{"income_id":"ID", "mfo":"БИК" },\r\n "variables":{"import_template_id":["getConst","1"],"name":["getLocalizedJson", {"ru":"Ðаименование", "en":""}]}}\r\n', 3, 1, 2),
55 (30, '/acc_luk2/hs/GetJSData/ArrayCatalogue/7', '{"table":"currency","incomeIdName":"ID","fields":{"income_id":"ID","code":"Код","name":"Ðаименование"}, "variables":{"create_at":["currentDateTime"]}}', 3, 0, 3);
56/*!40000 ALTER TABLE `data_load_item` ENABLE KEYS */;
57
58/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
59/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
60/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;