MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `local_auth_account`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_type_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `credit` decimal(20, 2) NOT NULL DEFAULT 0.00,
  `params` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `closed` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE,
  INDEX `account_type_id`(`account_type_id`, `params`) USING BTREE
);

CREATE TABLE `local_auth_account_journal`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT 0,
  `amount` decimal(20, 2) NULL DEFAULT NULL,
  `date` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `source_type` smallint(6) UNSIGNED NOT NULL DEFAULT 0,
  `source_id` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `cash_id` int(11) NOT NULL DEFAULT 0,
  `comment` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `balance` decimal(20, 2) NULL DEFAULT NULL,
  `action_date` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `date`(`date`, `id`) USING BTREE,
  INDEX `account_id_date`(`account_id`, `date`) USING BTREE,
  INDEX `source_type`(`account_id`, `source_type`) USING BTREE,
  INDEX `source_type_date`(`account_id`, `source_type`, `date`) USING BTREE,
  INDEX `account_id_id`(`account_id`, `id`) USING BTREE
);

CREATE TABLE `trm_in_card_client`  (
  `global_id` int(11) NOT NULL DEFAULT 0,
  `card` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `client` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `version` int(11) NOT NULL DEFAULT 0,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`global_id`, `card`) USING BTREE,
  INDEX `client`(`client`, `deleted`) USING BTREE,
  INDEX `version`(`global_id`, `version`, `deleted`) USING BTREE
);

CREATE TABLE `trm_in_cards`  (
  `global_id` int(11) NOT NULL DEFAULT 0,
  `id` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `start_card_code` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `stop_card_code` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `date_from` datetime(0) NULL DEFAULT NULL,
  `date_till` datetime(0) NULL DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `version` int(11) NOT NULL DEFAULT 0,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`global_id`, `id`) USING BTREE,
  INDEX `code`(`start_card_code`, `stop_card_code`) USING BTREE,
  INDEX `version`(`global_id`, `version`, `deleted`) USING BTREE
);

INSERT INTO `local_auth_account`(`id`, `account_type_id`, `name`, `credit`, `params`, `closed`) VALUES (1196537, 33, 'ClAcc.5319EEDB-B323-4D78-A5B4-AA7038EAE09F.33', 0.00, '5319EEDB-B323-4D78-A5B4-AA7038EAE09F', NULL);
INSERT INTO `local_auth_account`(`id`, `account_type_id`, `name`, `credit`, `params`, `closed`) VALUES (1196538, 32, 'ClAcc.5319EEDB-B323-4D78-A5B4-AA7038EAE09F.32', 0.00, '5319EEDB-B323-4D78-A5B4-AA7038EAE09F', NULL);
INSERT INTO `local_auth_account`(`id`, `account_type_id`, `name`, `credit`, `params`, `closed`) VALUES (1196607, 5, 'ClAcc.5319EEDB-B323-4D78-A5B4-AA7038EAE09F.5', 0.00, '5319EEDB-B323-4D78-A5B4-AA7038EAE09F', NULL);
INSERT INTO `local_auth_account`(`id`, `account_type_id`, `name`, `credit`, `params`, `closed`) VALUES (2946172, 5, 'ClAcc.889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816.5', 0.00, '889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816', NULL);
INSERT INTO `local_auth_account`(`id`, `account_type_id`, `name`, `credit`, `params`, `closed`) VALUES (2946173, 33, 'ClAcc.889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816.33', 0.00, '889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816', NULL);
INSERT INTO `local_auth_account`(`id`, `account_type_id`, `name`, `credit`, `params`, `closed`) VALUES (2951359, 32, 'ClAcc.889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816.32', 0.00, '889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816', NULL);
SELECT * FROM local_auth_account;

INSERT INTO `trm_in_cards`(`global_id`, `id`, `start_card_code`, `stop_card_code`, `date_from`, `date_till`, `active`, `version`, `deleted`) VALUES (0, 145620, '99999000069953', NULL, '2020-04-02 12:04:28', NULL, 1, 23850, 0);
INSERT INTO `trm_in_cards`(`global_id`, `id`, `start_card_code`, `stop_card_code`, `date_from`, `date_till`, `active`, `version`, `deleted`) VALUES (0, 221543, '99999000086922', NULL, '2020-12-02 16:06:57', NULL, 1, 38044, 0);
SELECT * FROM trm_in_cards;

INSERT INTO `trm_in_card_client`(`global_id`, `card`, `client`, `version`, `deleted`) VALUES (0, 145620, '5319EEDB-B323-4D78-A5B4-AA7038EAE09F', 23815, 0);
INSERT INTO `trm_in_card_client`(`global_id`, `card`, `client`, `version`, `deleted`) VALUES (0, 221543, '889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816', 38002, 0);
SELECT * FROM trm_in_card_client;

INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (6794769, 1196537, 34.90, '2020-04-04 13:15:06', 1, '9817', 207003002, 'UnC: Начисление скидки на счет клиента', 34.90, '2020-04-04 13:15:30');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (6846082, 1196537, 32.44, '2020-04-11 18:23:06', 1, '12274', 207003001, 'Начисление скидки на счет клиента', 67.34, '2020-04-11 18:23:15');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (6889157, 1196537, 80.70, '2020-04-17 15:55:21', 1, '12952', 207003001, 'Начисление скидки на счет клиента', 148.04, '2020-04-17 15:55:34');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (6897344, 1196537, 4.01, '2020-04-18 13:59:54', 1, '11058', 207003002, 'Начисление скидки на счет клиента', 152.05, '2020-04-18 14:00:17');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (6987371, 1196537, 4.67, '2020-04-30 18:36:52', 1, '14994', 207003001, 'Начисление скидки на счет клиента', 156.72, '2020-04-30 18:36:54');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7019075, 1196537, 1.92, '2020-05-02 17:32:42', 1, '15417', 207003001, 'Начисление скидки на счет клиента', 158.64, '2020-05-02 17:32:43');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7121444, 1196537, 2.07, '2020-05-16 17:44:07', 1, '5161', 219001002, 'Начисление скидки на счет клиента', 160.71, '2020-05-16 17:44:23');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7168994, 1196537, 1.84, '2020-05-23 15:13:17', 1, '21503', 219001001, 'Начисление скидки на счет клиента', 162.55, '2020-05-23 15:13:30');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7200605, 1196537, 2.25, '2020-05-28 18:57:02', 1, '7589', 219001002, 'Начисление скидки на счет клиента', 164.80, '2020-05-28 18:57:13');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7302622, 1196537, 2.77, '2020-06-11 19:07:07', 1, '26341', 219001001, 'Начисление скидки на счет клиента', 167.57, '2020-06-11 19:07:26');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7535977, 1196537, 3.66, '2020-07-03 20:44:48', 1, '349855', 208003004, 'Начисление скидки на счет клиента', 171.23, '2020-07-03 20:44:56');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7553443, 1196537, 6.29, '2020-07-05 15:18:03', 1, '15479', 219001002, 'Начисление скидки на счет клиента', 177.52, '2020-07-05 15:18:31');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7601720, 1196537, 31.31, '2020-07-09 13:14:14', 1, '16498', 219001002, 'Начисление скидки на счет клиента', 208.83, '2020-07-09 13:14:32');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7710043, 1196537, 2.06, '2020-07-17 13:42:15', 1, '18306', 219001002, 'Начисление скидки на счет клиента', 210.89, '2020-07-17 13:42:30');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7739162, 1196537, 8.25, '2020-07-19 15:21:09', 1, '34707', 219001001, 'Начисление скидки на счет клиента', 219.14, '2020-07-19 15:21:30');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7788121, 1196537, 3.36, '2020-07-23 13:37:05', 1, '35491', 219001001, 'Начисление скидки на счет клиента', 222.50, '2020-07-23 13:37:17');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7829468, 1196537, 1.88, '2020-07-26 15:15:52', 1, '20273', 219001002, 'Начисление скидки на счет клиента', 224.38, '2020-07-26 15:16:03');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7891364, 1196537, 6.91, '2020-07-31 13:43:19', 1, '21791', 219001002, 'Начисление скидки на счет клиента', 231.29, '2020-07-31 13:43:40');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (7950723, 1196537, 11.61, '2020-08-02 15:44:42', 1, '356904', 208003004, 'Начисление скидки на счет клиента', 242.90, '2020-08-02 15:45:05');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8119445, 1196537, 3.77, '2020-08-14 19:40:35', 1, '374233', 208003002, 'Начисление скидки на счет клиента', 246.67, '2020-08-14 19:40:57');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8137994, 1196537, 6.56, '2020-08-16 13:17:32', 1, '26599', 219001002, 'Начисление скидки на счет клиента', 253.23, '2020-08-16 13:17:38');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8262692, 1196537, 18.08, '2020-08-25 13:16:56', 1, '39876', 219001001, 'Начисление скидки на счет клиента', 271.31, '2020-08-25 13:17:02');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8404091, 1196537, 7.03, '2020-09-01 19:31:11', 1, '312559', 201002003, 'Начисление скидки на счет клиента', 278.34, '2020-09-01 19:31:36');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8460971, 1196537, 5.88, '2020-09-05 16:07:25', 1, '328948', 201002005, 'Начисление скидки на счет клиента', 284.22, '2020-09-05 16:07:52');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8493461, 1196537, 2.11, '2020-09-07 19:48:25', 1, '42712', 219001001, 'Начисление скидки на счет клиента', 286.33, '2020-09-07 19:48:59');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8506622, 1196537, 5.93, '2020-09-08 19:14:25', 1, '335543', 201002004, 'Начисление скидки на счет клиента', 292.26, '2020-09-08 19:14:54');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8541232, 1196537, 3.31, '2020-09-11 13:24:32', 1, '336358', 201002004, 'Начисление скидки на счет клиента', 295.57, '2020-09-11 13:24:49');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (8570803, 1196537, 5.77, '2020-09-13 12:25:35', 1, '33860', 219001002, 'Начисление скидки на счет клиента', 301.34, '2020-09-13 12:25:47');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (9683489, 1196537, 5.39, '2020-11-20 19:03:50', 1, '401292', 208003002, 'Начисление скидки на счет клиента', 306.73, '2020-11-20 19:05:50');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (9752456, 1196537, 8.87, '2020-11-25 13:15:55', 1, '53195', 219001002, 'Начисление скидки на счет клиента', 315.60, '2020-11-25 13:16:22');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (9971628, 1196537, 6.37, '2020-12-06 15:27:22', 1, '401360', 208003003, 'Начисление скидки на счет клиента', 321.97, '2020-12-06 15:27:40');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (10214447, 1196537, 28.88, '2020-12-20 15:37:29', 1, '58075', 219001002, 'Начисление скидки на счет клиента', 350.85, '2020-12-20 15:37:37');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (10434306, 1196537, 8.36, '2020-12-31 11:11:37', 1, '387685', 208003004, 'Начисление скидки на счет клиента', 359.21, '2020-12-31 11:11:46');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (10494016, 1196537, 8.07, '2021-01-01 15:20:54', 1, '366183', 201002005, 'Начисление скидки на счет клиента', 367.28, '2021-01-01 15:21:01');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (10503938, 1196537, 4.56, '2021-01-02 16:41:35', 1, '63408', 219001001, 'Начисление скидки на счет клиента', 371.84, '2021-01-02 16:41:50');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (10606061, 1196537, 12.58, '2021-01-09 16:23:14', 1, '447976', 208003001, 'Начисление скидки на счет клиента', 384.42, '2021-01-09 16:23:28');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11189356, 1196537, 27.88, '2021-02-09 19:08:14', 1, '417300', 206002001, 'Начисление скидки на счет клиента', 412.30, '2021-02-09 19:08:27');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11343450, 1196537, 15.17, '2021-02-17 18:59:00', 1, '392808', 201002004, 'Начисление скидки на счет клиента', 427.47, '2021-02-17 18:57:02');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11394625, 1196537, 19.60, '2021-02-20 13:34:16', 1, '430814', 201002001, 'Начисление скидки на счет клиента', 447.07, '2021-02-20 13:34:35');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11613675, 1196537, 18.72, '2021-03-01 18:38:31', 1, '464481', 208003001, 'Начисление скидки на счет клиента', 465.79, '2021-03-01 18:38:45');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11384926, 2946173, 8.49, '2021-02-19 18:43:43', 1, '671817', 1015001, 'Начисление скидки на счет клиента', 8.49, '2021-02-19 18:40:43');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11405609, 2946173, 16.16, '2021-02-20 18:05:03', 1, '672025', 1015001, 'Начисление скидки на счет клиента', 24.65, '2021-02-20 18:01:57');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11412903, 2946173, 9.29, '2021-02-21 10:52:33', 1, '422368', 208003003, 'Начисление скидки на счет клиента', 33.94, '2021-02-21 10:52:40');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11441440, 2946173, 13.58, '2021-02-22 15:40:55', 1, '672418', 1015001, 'Начисление скидки на счет клиента', 47.52, '2021-02-22 15:37:38');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11525235, 2946173, 12.52, '2021-02-26 18:44:31', 1, '673298', 1015001, 'Начисление скидки на счет клиента', 60.04, '2021-02-26 18:41:13');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11525395, 2946173, 5.79, '2021-02-26 18:45:49', 1, '463407', 208003001, 'Начисление скидки на счет клиента', 65.83, '2021-02-26 18:45:58');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11539703, 2946173, 3.41, '2021-02-27 15:40:31', 1, '435670', 234001001, 'Начисление скидки на счет клиента', 69.24, '2021-02-27 15:39:38');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11549366, 2946173, 3.00, '2021-02-27 19:58:33', 1, '424876', 208003003, 'Начисление скидки на счет клиента', 72.24, '2021-02-27 19:58:40');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11559238, 2946173, 1.20, '2021-02-28 16:23:21', 1, '464174', 208003001, 'Начисление скидки на счет клиента', 73.44, '2021-02-28 16:23:38');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11614063, 2946173, 3.67, '2021-03-01 18:51:58', 1, '424360', 208003002, 'Начисление скидки на счет клиента', 77.11, '2021-03-01 18:52:14');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11652270, 2946173, 4.37, '2021-03-03 18:47:47', 1, '425993', 208003003, 'Начисление скидки на счет клиента', 81.48, '2021-03-03 18:48:06');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11931710, 2946173, 10.41, '2021-03-17 18:56:02', 1, '676773', 1015001, 'Начисление скидки на счет клиента', 96.98, '2021-03-17 18:52:20');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11931791, 2946173, 5.09, '2021-03-17 18:55:24', 1, '469707', 208003001, 'Начисление скидки на счет клиента', 86.57, '2021-03-17 18:55:38');
INSERT INTO `local_auth_account_journal`(`id`, `account_id`, `amount`, `date`, `source_type`, `source_id`, `cash_id`, `comment`, `balance`, `action_date`) VALUES (11955595, 2946173, 6.55, '2021-03-18 20:40:56', 1, '429813', 208003002, 'Начисление скидки на счет клиента', 103.53, '2021-03-18 20:41:02');
SELECT * FROM local_auth_account_journal;

id	account_type_id	name	params	closed
1196537	33	ClAcc.5319EEDB-B323-4D78-A5B4-AA7038EAE09F.33	5319EEDB-B323-4D78-A5B4-AA7038EAE09F	null
1196538	32	ClAcc.5319EEDB-B323-4D78-A5B4-AA7038EAE09F.32	5319EEDB-B323-4D78-A5B4-AA7038EAE09F	null
1196607	5	ClAcc.5319EEDB-B323-4D78-A5B4-AA7038EAE09F.5	5319EEDB-B323-4D78-A5B4-AA7038EAE09F	null
2946172	5	ClAcc.889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816.5	889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816	null
2946173	33	ClAcc.889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816.33	889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816	null
2951359	32	ClAcc.889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816.32	889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816	null

global_id	id	start_card_code	stop_card_code	date_from	date_till	active	version	deleted
0	145620	99999000069953	null	2020-04-02 12:04:28	null	1	23850	0
0	221543	99999000086922	null	2020-12-02 16:06:57	null	1	38044	0

global_id	card	client	version	deleted
0	145620	5319EEDB-B323-4D78-A5B4-AA7038EAE09F	23815	0
0	221543	889B6DAB-A3CD-47BD-B18B-8AEBE1B1B816	38002	0

id	account_id	amount	date	source_type	source_id	cash_id	comment	balance	action_date
6794769	1196537	34.90	2020-04-04 13:15:06	1	9817	207003002	556e433a20d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	34.90	2020-04-04 13:15:30
6846082	1196537	32.44	2020-04-11 18:23:06	1	12274	207003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	67.34	2020-04-11 18:23:15
6889157	1196537	80.70	2020-04-17 15:55:21	1	12952	207003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	148.04	2020-04-17 15:55:34
6897344	1196537	4.01	2020-04-18 13:59:54	1	11058	207003002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	152.05	2020-04-18 14:00:17
6987371	1196537	4.67	2020-04-30 18:36:52	1	14994	207003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	156.72	2020-04-30 18:36:54
7019075	1196537	1.92	2020-05-02 17:32:42	1	15417	207003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	158.64	2020-05-02 17:32:43
7121444	1196537	2.07	2020-05-16 17:44:07	1	5161	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	160.71	2020-05-16 17:44:23
7168994	1196537	1.84	2020-05-23 15:13:17	1	21503	219001001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	162.55	2020-05-23 15:13:30
7200605	1196537	2.25	2020-05-28 18:57:02	1	7589	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	164.80	2020-05-28 18:57:13
7302622	1196537	2.77	2020-06-11 19:07:07	1	26341	219001001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	167.57	2020-06-11 19:07:26
7535977	1196537	3.66	2020-07-03 20:44:48	1	349855	208003004	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	171.23	2020-07-03 20:44:56
7553443	1196537	6.29	2020-07-05 15:18:03	1	15479	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	177.52	2020-07-05 15:18:31
7601720	1196537	31.31	2020-07-09 13:14:14	1	16498	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	208.83	2020-07-09 13:14:32
7710043	1196537	2.06	2020-07-17 13:42:15	1	18306	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	210.89	2020-07-17 13:42:30
7739162	1196537	8.25	2020-07-19 15:21:09	1	34707	219001001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	219.14	2020-07-19 15:21:30
7788121	1196537	3.36	2020-07-23 13:37:05	1	35491	219001001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	222.50	2020-07-23 13:37:17
7829468	1196537	1.88	2020-07-26 15:15:52	1	20273	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	224.38	2020-07-26 15:16:03
7891364	1196537	6.91	2020-07-31 13:43:19	1	21791	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	231.29	2020-07-31 13:43:40
7950723	1196537	11.61	2020-08-02 15:44:42	1	356904	208003004	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	242.90	2020-08-02 15:45:05
8119445	1196537	3.77	2020-08-14 19:40:35	1	374233	208003002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	246.67	2020-08-14 19:40:57
8137994	1196537	6.56	2020-08-16 13:17:32	1	26599	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	253.23	2020-08-16 13:17:38
8262692	1196537	18.08	2020-08-25 13:16:56	1	39876	219001001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	271.31	2020-08-25 13:17:02
8404091	1196537	7.03	2020-09-01 19:31:11	1	312559	201002003	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	278.34	2020-09-01 19:31:36
8460971	1196537	5.88	2020-09-05 16:07:25	1	328948	201002005	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	284.22	2020-09-05 16:07:52
8493461	1196537	2.11	2020-09-07 19:48:25	1	42712	219001001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	286.33	2020-09-07 19:48:59
8506622	1196537	5.93	2020-09-08 19:14:25	1	335543	201002004	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	292.26	2020-09-08 19:14:54
8541232	1196537	3.31	2020-09-11 13:24:32	1	336358	201002004	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	295.57	2020-09-11 13:24:49
8570803	1196537	5.77	2020-09-13 12:25:35	1	33860	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	301.34	2020-09-13 12:25:47
9683489	1196537	5.39	2020-11-20 19:03:50	1	401292	208003002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	306.73	2020-11-20 19:05:50
9752456	1196537	8.87	2020-11-25 13:15:55	1	53195	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	315.60	2020-11-25 13:16:22
9971628	1196537	6.37	2020-12-06 15:27:22	1	401360	208003003	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	321.97	2020-12-06 15:27:40
10214447	1196537	28.88	2020-12-20 15:37:29	1	58075	219001002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	350.85	2020-12-20 15:37:37
10434306	1196537	8.36	2020-12-31 11:11:37	1	387685	208003004	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	359.21	2020-12-31 11:11:46
10494016	1196537	8.07	2021-01-01 15:20:54	1	366183	201002005	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	367.28	2021-01-01 15:21:01
10503938	1196537	4.56	2021-01-02 16:41:35	1	63408	219001001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	371.84	2021-01-02 16:41:50
10606061	1196537	12.58	2021-01-09 16:23:14	1	447976	208003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	384.42	2021-01-09 16:23:28
11189356	1196537	27.88	2021-02-09 19:08:14	1	417300	206002001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	412.30	2021-02-09 19:08:27
11343450	1196537	15.17	2021-02-17 18:59:00	1	392808	201002004	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	427.47	2021-02-17 18:57:02
11384926	2946173	8.49	2021-02-19 18:43:43	1	671817	1015001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	8.49	2021-02-19 18:40:43
11394625	1196537	19.60	2021-02-20 13:34:16	1	430814	201002001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	447.07	2021-02-20 13:34:35
11405609	2946173	16.16	2021-02-20 18:05:03	1	672025	1015001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	24.65	2021-02-20 18:01:57
11412903	2946173	9.29	2021-02-21 10:52:33	1	422368	208003003	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	33.94	2021-02-21 10:52:40
11441440	2946173	13.58	2021-02-22 15:40:55	1	672418	1015001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	47.52	2021-02-22 15:37:38
11525235	2946173	12.52	2021-02-26 18:44:31	1	673298	1015001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	60.04	2021-02-26 18:41:13
11525395	2946173	5.79	2021-02-26 18:45:49	1	463407	208003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	65.83	2021-02-26 18:45:58
11539703	2946173	3.41	2021-02-27 15:40:31	1	435670	234001001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	69.24	2021-02-27 15:39:38
11549366	2946173	3.00	2021-02-27 19:58:33	1	424876	208003003	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	72.24	2021-02-27 19:58:40
11559238	2946173	1.20	2021-02-28 16:23:21	1	464174	208003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	73.44	2021-02-28 16:23:38
11613675	1196537	18.72	2021-03-01 18:38:31	1	464481	208003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	465.79	2021-03-01 18:38:45
11614063	2946173	3.67	2021-03-01 18:51:58	1	424360	208003002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	77.11	2021-03-01 18:52:14
11652270	2946173	4.37	2021-03-03 18:47:47	1	425993	208003003	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	81.48	2021-03-03 18:48:06
11931710	2946173	10.41	2021-03-17 18:56:02	1	676773	1015001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	96.98	2021-03-17 18:52:20
11931791	2946173	5.09	2021-03-17 18:55:24	1	469707	208003001	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	86.57	2021-03-17 18:55:38
11955595	2946173	6.55	2021-03-18 20:40:56	1	429813	208003002	d09dd0b0d187d0b8d181d0bbd0b5d0bdd0b8d0b520d181d0bad0b8d0b4d0bad0b820d0bdd0b020d181d187d0b5d18220d0bad0bbd0b8d0b5d0bdd182d0b0	103.53	2021-03-18 20:41:02