[code]

INSERT INTO `users` (`id`, `code_`, `username`, `old_password`, `passhash`, `secret`, `email`, `task_notice`, `mtelefon`, `added`, `last_login`, `last_api_login`, `last_access`, `last_api_access`, `editsecret`, `privacy`, `info`, `acceptpms`, `ip`, `class`, `work_class`, `competishon`, `class_sub`, `type`, `time_control`, `upr_control`, `website`, `avatars`, `gender`, `birthday`, `language`, `page`, `status`, `statist`, `static`, `off`) VALUES

(1, '1', 'Олександр Каліновський', '', '4f4c046d78d87ce62dd6ff809d819a40', 'fxHOIC2JmHt7Hv8niHtp', '1111111@gmail.com', 'off', '', '0000-00-00 00:00:00', '2020-11-18 11:21:51', '2019-09-02 11:26:53', '2020-11-26 13:11:10', '2019-09-17 11:16:12', '', 'normal', NULL, 'yes', '185.175.245.30', 250, '', '', 0, '', '2020-11-26', '2020-11-26', '', 'yes', '1', '0000-00-00', 'russian', 0, 'pending', 'no', 'no', 'yes'),

(2, '2', 'Анатолій Гончар', '', '162b26d4bf74a2854e46f022f967808c', 'Z5HBS9RxN1RNvXftaDe4', '11111111@gmail.com', 'off', '', '0000-00-00 00:00:00', '2021-01-12 21:00:08', '2019-09-17 09:55:40', '2021-01-12 21:00:16', '2019-09-19 14:02:30', '', 'normal', NULL, 'yes', '31.129.183.16', 250, '', '', 0, '', '2021-01-12', '2021-01-12', '', 'yes', '1', '0000-00-00', 'russian', 0, 'pending', 'no', 'no', 'yes'),

(3, '3', 'Губенко Антон', '', '3e828d0661375078a227de903030dc23', 'GVNIEzhrpzU7SvryGXCI', 'tosyan66@gmail.com', 'off', '0675019005', '2019-03-10 15:47:04', '2022-12-13 12:56:35', '2019-08-12 14:15:11', '2023-06-22 15:08:57', '2020-12-10 23:33:39', '', 'normal', '\r\n\r\n', 'yes', '218.215.63.71', 250, 'utype_dir;admin', '', 0, 'admins', NULL, '2023-06-22', '', 'yes', '1', '0000-00-00', 'russian', 0, 'confirmed', 'yes', 'no', 'no'),

(4, '4', 'Губенко Валентина', '', '362e02f2f5e70a0b1e4748ed6097c8eb', 'mXas98U14vb4ElAGvIGF', 'valgard60@gmail.com', '', '0675023458', '2019-03-10 15:48:52', '2024-04-22 12:20:13', '0000-00-00 00:00:00', '2024-04-23 15:01:17', '0000-00-00 00:00:00', '', 'normal', NULL, 'yes', '178.54.151.157', 250, 'utype_dir;admin', '', 0, 'admins', NULL, '2024-04-23', '', 'yes', '1', '0000-00-00', 'russian', 0, 'confirmed', 'yes', 'no', 'no'),

(5, '5', 'Осаволюк Валентина', '', '493573b75a76e42ef335e879749501f3', '1PYWMCU7hGJgOARUpOR2', 'valentynaos@gardiny.com.ua', '', '0964383529', '2019-03-10 15:50:58', '2019-06-06 14:22:01', '0000-00-00 00:00:00', '2019-06-28 16:52:49', '0000-00-00 00:00:00', '', 'normal', NULL, 'yes', '178.54.151.157', 240, '', '', 250, 'admins', NULL, '2019-06-28', '', 'yes', '1', '0000-00-00', 'russian', 0, 'confirmed', 'yes', 'no', 'yes'),


INSERT INTO `provider` (`id`, `name`, `provider_code`, `money`, `name_dir`, `name_cont`, `email`, `email_sub`, `telefon`, `m_telefon`, `pr_tel_cont`, `adres`, `jr_adres`, `edrpoy`, `tm_list`, `tov_group`, `valuta`, `pause`, `info`, `added`, `edited`, `off`) VALUES

(1, 'Алла Польща', '', '0.00', '', 'Губенко Валентина', 'valgard60@gmail.com', 'valgard60@gmail.com', '', '0675023458', '', '', '', '', 'шовк, гепюр', '', 'UAH', 0, '', '2019-04-19 06:36:11', '2021-05-05 15:16:32', 'no'),

(2, 'Гардини БЦ', '58', '0.00', '', 'Губенко ВМ', 'Гардини БЦ', 'valgard60@gmail.com', '', '', '', '', '', '', '', '', 'UAH', 0, '', '2019-04-22 21:57:23', '2021-05-14 09:17:34', 'no'),

(3, 'ФОП Гончар', '', '0.00', '', 'Гончар анатолій', 'gonchar.anatolij@gmail.com', 'gonchar.anatolij@gmail.com', '0504413350', '', '', '', '', '', '', '*1370*', 'UAH', 0, '', '2019-09-16 00:26:10', '0000-00-00 00:00:00', 'no'),

(4, 'Віта Верітас', '', '0.00', '', 'ппп', 'ппп', '', '', '', '', '', '', '', '', '', 'UAH', 0, '', '2019-09-18 14:54:46', '0000-00-00 00:00:00', 'no'),

(5, 'HANGZHOU Yitena import and export trade co ltd', '159', '0.00', '', 'ggg', 'ddd', '', '', '', '', '', '', '', '', '', 'USD', 0, '', '2019-09-18 15:07:07', '2021-06-22 14:30:55', 'no'),

(6, 'Київоблгаз', '', '0.00', '', 'Київоблгаз', 'Київоблгаз', '', '', '', '', '', '', '', '', '', 'UAH', 0, '', '2019-09-18 15:32:19', '0000-00-00 00:00:00', 'no'),

(7, 'Кардинал', '82', '11110.27', '', 'Володимир', 'Кардинал', 'dvv071982@gmail.com', '0504306234', '', '', '', '', '', '', '', 'UAH', 0, '', '2019-09-23 12:55:07', '2021-05-14 21:02:26', 'no'),

(8, 'Київ Карнизи', '79', '1469.66', '', 'Анна Вержбицька', 'svetan@gardiny.com.ua', '', '0800303005', '', '', '', '', '', '', '', 'USD', 0, '', '2019-09-23 13:00:00', '2021-04-13 14:21:23', 'no'),



INSERT INTO `client` (`id`, `cid`, `name`, `birth`, `info`, `adres`, `adres_home`, `adres_alt`, `adr_home`, `adr_obj1`, `adr_obj2`, `telefon`, `telefon_alt`, `m_telefon`, `email`, `reklama`, `diskont`, `diskont_bl`, `balance`, `money`, `klient_tip`, `klient_shop`, `tov_group`, `jr_name`, `jr_adres`, `edrpoy`, `user_add`, `designer`, `user`, `user_ak`, `added`, `contacted`, `edited`, `type`, `head`, `head_phone`, `legal_entity`, `iban`, `bank`, `mfo`, `manager`, `manager_phone`, `region`, `city`, `site`, `social_1`, `social_2`, `address_1`, `address_2`) VALUES

(4, '000017983', 'Калініна Людмила', '0000-00-00', '', 'Київ, Позняки, Мішуги, дом № 12, кв.216', '', '', '', '', '', '', '', '0506778892', '', '', '', 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, '2019-04-12 02:38:53', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(5, '000017984', 'Щербак Меланія', '0000-00-00', '', '', 'с. Іванівка', 'с. Іванівка', '', '', '', '', '', '0675018183', '', '', '', 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, '2019-04-12 02:38:53', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(6, '000017987', 'Мисловський Денис Володимирович', '0000-00-00', NULL, '', '', '', '||||||||||', '||||||||||', '||||||||||', '', '', '0982765236', '', '26', '', 0, 0, 0, 'lt_klient', '43', '', '', '', 0, 0, 33, 0, 0, '2019-04-12 02:38:53', '2023-02-16 11:22:33', '2023-03-09 15:45:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(7, '000017992', 'Лучак Василий', '0000-00-00', '', '', '', '', '', '', '', '', '', '0631679952', '', '', '', 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, '2019-04-12 02:38:53', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(8, '000017960', 'Крутоус', '0000-00-00', '', '', '', '', '', '', '', '', '', '0673238207', '', '', '', 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, '2019-04-12 02:38:53', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(9, '000017961', 'Волик Олександр Миколайович', '0000-00-00', '', '', '', '', 'Біла Церква||Пров Студенський||2||||111||', '||||||||||', '||||||||||', '', '', '0980762727', '', '30', '', 0, 0, 0, 'bs_klient', '43', '', '', '', 0, 0, 8, 0, 0, '2019-04-12 02:38:53', NULL, '2020-01-31 17:10:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(11, '000020972', 'Стретович', '0000-00-00', '', '', '', '', '', '', '', '', '', '0987009108', '', '', '', 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, '2019-04-12 02:38:53', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

[/code]