Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.42 KB | None | 0 0
  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
  15. CREATE 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 (приблизительно)
  26. DELETE FROM `data_load_item`;
  27. /*!40000 ALTER TABLE `data_load_item` DISABLE KEYS */;
  28. INSERT 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement