Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- --------------------------------------------------------
- -- Хост: 127.0.0.1
- -- Версия сервера: 5.5.54-0+deb8u1 - (Debian)
- -- Операционная система: debian-linux-gnu
- -- HeidiSQL Версия: 9.5.0.5295
- -- --------------------------------------------------------
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET NAMES utf8 */;
- /*!50503 SET NAMES utf8mb4 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- -- Дамп структуры для таблица dev_company_6.data_load_item
- CREATE TABLE IF NOT EXISTS `data_load_item` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `url` varchar(2000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `rules` varchar(10000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `data_load_id` int(11) NOT NULL,
- `active` int(11) NOT NULL DEFAULT '1',
- `order` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- -- Дамп данных таблицы dev_company_6.data_load_item: ~27 rows (приблизительно)
- DELETE FROM `data_load_item`;
- /*!40000 ALTER TABLE `data_load_item` DISABLE KEYS */;
- INSERT INTO `data_load_item` (`id`, `url`, `rules`, `data_load_id`, `active`, `order`) VALUES
- (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),
- (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),
- (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),
- (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),
- (6, '/ut_new/hs/GetJSData/ArrayCatalogue/7', '{"table":"currency","incomeIdName":"ID","fields":{"income_id":"ID","code":"Код","name":"Наименование"}, "variables":{"create_at":["currentDateTime"]}}', 1, 0, 5),
- (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),
- (10, '', '{"table":"items", \r\n "variables":{"uid":["getConst","1"], "create_at":["currentDateTime"],"name":["getLocalizedJson", {"ru":"Наименование", "en":""}]}}', 2, 0, 1),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (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),
- (30, '/acc_luk2/hs/GetJSData/ArrayCatalogue/7', '{"table":"currency","incomeIdName":"ID","fields":{"income_id":"ID","code":"Код","name":"Наименование"}, "variables":{"create_at":["currentDateTime"]}}', 3, 0, 3);
- /*!40000 ALTER TABLE `data_load_item` ENABLE KEYS */;
- /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
- /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement