-- Adminer 4.7.3 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `actions_valentine_dreams`;
CREATE TABLE `actions_valentine_dreams` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(14) COLLATE utf8_unicode_ci NOT NULL,
  `dream` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dream_details` text COLLATE utf8_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rating` int(11) DEFAULT NULL,
  `answer` text COLLATE utf8_unicode_ci,
  `login` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(5) NOT NULL,
  `moderator` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `moder_login` int(14) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `email` (`email`),
  KEY `phone` (`phone`),
  KEY `date_updated` (`date_updated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `action_ideas_for_wishes`;
CREATE TABLE `action_ideas_for_wishes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `email` varchar(128) NOT NULL,
  `phone` varchar(14) NOT NULL,
  `idea` text NOT NULL,
  `for_whom` varchar(255) NOT NULL,
  `holidays` varchar(255) NOT NULL,
  `present` int(5) NOT NULL,
  `rating` int(11) NOT NULL,
  `login` varchar(14) NOT NULL,
  `status` int(5) NOT NULL,
  `moderator` varchar(128) NOT NULL,
  `moder_login` varchar(14) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `action_newyear_2020`;
CREATE TABLE `action_newyear_2020` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(100) DEFAULT NULL,
  `email` char(100) DEFAULT NULL,
  `phone` char(20) NOT NULL,
  `level` int(11) DEFAULT NULL,
  `levels` char(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `action_newyear_2020` (`id`, `name`, `email`, `phone`, `level`, `levels`) VALUES
(5,	NULL,	NULL,	'380953607133',	0,	NULL);

DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `password` varchar(32) NOT NULL,
  `is_root_admin` tinyint(1) NOT NULL DEFAULT '0',
  `is_risk_manager` tinyint(1) NOT NULL DEFAULT '0',
  `is_kassa` tinyint(1) NOT NULL,
  `fio` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `app_raiting`;
CREATE TABLE `app_raiting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` smallint(4) NOT NULL,
  `month` tinyint(1) NOT NULL,
  `count` int(11) NOT NULL,
  `rating` decimal(2,1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `app_reviews`;
CREATE TABLE `app_reviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `review_id` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `rating` tinyint(1) NOT NULL,
  `last_modified` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `oblast` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `contacts`;
CREATE TABLE `contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `value` varchar(255) NOT NULL,
  `type` enum('email','tel') NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `activate_code` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `value` (`value`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `cookies`;
CREATE TABLE `cookies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cookie_id` varchar(23) NOT NULL,
  `body` text NOT NULL,
  `loans` text NOT NULL,
  `last_login` varchar(14) NOT NULL,
  `logged_on` datetime DEFAULT NULL,
  `applyforloan` datetime DEFAULT NULL,
  `confirmcontract` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cookie_id` (`cookie_id`),
  KEY `date_updated` (`date_updated`),
  KEY `cookie_id_2` (`cookie_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `credits`;
CREATE TABLE `credits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `createDate` datetime NOT NULL,
  `status` enum('new','user_confirm','approved','cancel','payment_sent','closed','user_confirm2') NOT NULL,
  `days` int(11) NOT NULL,
  `startDate` date NOT NULL,
  `returnDate` date NOT NULL,
  `approvedBy` varchar(255) NOT NULL,
  `amount` decimal(7,2) NOT NULL,
  `amount_payed` decimal(7,2) NOT NULL,
  `percent` decimal(7,2) NOT NULL,
  `percent_payed` decimal(7,2) NOT NULL,
  `penalty` decimal(7,2) NOT NULL,
  `penalty_payed` decimal(7,2) NOT NULL,
  `credit_card` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `id_manager` int(11) NOT NULL,
  `id_office` int(11) NOT NULL,
  `id_pack` int(11) NOT NULL,
  `cancel_code` int(11) NOT NULL,
  `is_long` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `is_restruct` tinyint(1) NOT NULL,
  `percent_per_day` float NOT NULL DEFAULT '1.9',
  `penaltyCount` int(11) NOT NULL,
  `longCount` int(11) NOT NULL,
  `restructDate` date NOT NULL,
  `longDate` date DEFAULT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `realStartDate` date DEFAULT NULL,
  `realAmount` decimal(8,2) DEFAULT NULL,
  `realDays` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `credits_pack`;
CREATE TABLE `credits_pack` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `max_amount` decimal(10,0) NOT NULL,
  `max_days` int(11) NOT NULL,
  `min_age` int(11) NOT NULL,
  `max_age` int(11) NOT NULL,
  `percent` decimal(4,2) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `credit_cards`;
CREATE TABLE `credit_cards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `number` varchar(255) NOT NULL,
  `expMonth` varchar(255) NOT NULL,
  `expYear` varchar(255) NOT NULL,
  `cvv` varchar(255) NOT NULL,
  `holder` varchar(50) NOT NULL,
  `verify` tinyint(1) NOT NULL,
  `type` enum('visa','mastercard') NOT NULL,
  `rc_id` varchar(255) NOT NULL,
  `rc_token` varchar(255) NOT NULL,
  `norder` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `documents`;
CREATE TABLE `documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_office` int(11) NOT NULL,
  `creationDateTime` datetime NOT NULL,
  `type` int(11) NOT NULL,
  `doc_number` int(11) NOT NULL,
  `doc_name` varchar(255) NOT NULL,
  `doc_comment` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `confirmed` int(11) NOT NULL,
  `id_credit` int(11) NOT NULL,
  `rah` int(11) NOT NULL,
  `vars` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_credit` (`id_credit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `firebase_messages`;
CREATE TABLE `firebase_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `body` varchar(255) NOT NULL,
  `option` varchar(255) NOT NULL,
  `link` varchar(100) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `firebase_users`;
CREATE TABLE `firebase_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `device_token` varchar(255) NOT NULL,
  `user_token` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `device_token` (`device_token`),
  KEY `date_updated` (`date_updated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `google_stars`;
CREATE TABLE `google_stars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `mark` tinyint(4) NOT NULL DEFAULT '5',
  `bot` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `logs`;
CREATE TABLE `logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_row` int(11) NOT NULL,
  `data` text NOT NULL,
  `who` int(11) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `logs_api`;
CREATE TABLE `logs_api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_time` datetime NOT NULL,
  `prefix` varchar(20) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `method` varchar(20) DEFAULT NULL,
  `data` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `oblast`;
CREATE TABLE `oblast` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `office`;
CREATE TABLE `office` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `last_user` int(11) NOT NULL,
  `last_user_date` datetime NOT NULL,
  `is_busy` tinyint(1) NOT NULL,
  `delta` decimal(8,2) NOT NULL,
  `rah` varchar(255) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `last_user` (`last_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `office_managers`;
CREATE TABLE `office_managers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminid` int(11) NOT NULL,
  `officeid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `adminid` (`adminid`),
  KEY `officeid` (`officeid`),
  CONSTRAINT `office_managers_ibfk_1` FOREIGN KEY (`adminid`) REFERENCES `admins` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `office_managers_ibfk_2` FOREIGN KEY (`officeid`) REFERENCES `office` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `office_money`;
CREATE TABLE `office_money` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` decimal(8,2) NOT NULL,
  `creationDateTime` datetime NOT NULL,
  `id_manager` int(11) NOT NULL,
  `id_office` int(11) NOT NULL,
  `comment` text NOT NULL,
  `rah` int(11) NOT NULL,
  `docid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `docid` (`docid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `pages_rating`;
CREATE TABLE `pages_rating` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `positive_reviews` int(11) NOT NULL,
  `negative_reviews` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_id` (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `partners_cookies`;
CREATE TABLE `partners_cookies` (
  `id` int(14) NOT NULL,
  `customer_id` varchar(40) NOT NULL,
  `affiliate_name` varchar(30) NOT NULL,
  `affiliate` text NOT NULL,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `partners_operations`;
CREATE TABLE `partners_operations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_date` date NOT NULL,
  `created_time` time NOT NULL DEFAULT '00:00:00',
  `name` varchar(50) NOT NULL,
  `user` varchar(50) NOT NULL,
  `method_id` tinyint(4) DEFAULT NULL,
  `loan_id` int(10) DEFAULT NULL,
  `flag_posted` tinyint(1) DEFAULT NULL,
  `is_repeated` tinyint(1) DEFAULT NULL,
  `arrived_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_date_name_method` (`created_date`,`name`,`method_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `partners_users`;
CREATE TABLE `partners_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `company` varchar(50) NOT NULL,
  `info` varchar(100) NOT NULL,
  `accesses` varchar(100) NOT NULL,
  `password` varchar(50) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `payments`;
CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `credit_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `bonus` decimal(8,2) NOT NULL,
  `long` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `reviews`;
CREATE TABLE `reviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ru',
  `page_id` int(11) DEFAULT '0',
  `type` int(11) DEFAULT '0',
  `city` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `review` text COLLATE utf8_unicode_ci NOT NULL,
  `rating` int(5) DEFAULT NULL,
  `answer` text COLLATE utf8_unicode_ci,
  `login` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(5) NOT NULL,
  `moderator` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `moder_login` int(14) DEFAULT NULL,
  `moder_date` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `schedules`;
CREATE TABLE `schedules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_credit` int(11) NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `date` date NOT NULL,
  `is_payed` int(11) NOT NULL,
  `payed` decimal(8,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `social_networks`;
CREATE TABLE `social_networks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `network` varchar(255) NOT NULL,
  `data` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `userid` (`userid`,`network`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `temp_mails`;
CREATE TABLE `temp_mails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_name` varchar(100) NOT NULL,
  `active` tinyint(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `domain_name` (`domain_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `tokens`;
CREATE TABLE `tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `dateCreate` datetime NOT NULL,
  `dateUpdate` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyhash` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `regdate` datetime NOT NULL,
  `firstName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `thirdName` varchar(255) NOT NULL,
  `bdate` date NOT NULL,
  `family` int(11) NOT NULL,
  `kids` int(11) NOT NULL,
  `people` int(11) NOT NULL,
  `education` int(11) NOT NULL,
  `education_faculty` int(11) NOT NULL,
  `passport` varchar(255) NOT NULL,
  `passport_date` date NOT NULL,
  `passport_who` varchar(255) NOT NULL,
  `inn` varchar(10) NOT NULL,
  `sex` int(11) NOT NULL,
  `lang` varchar(2) NOT NULL,
  `lastNameChange` tinyint(1) NOT NULL,
  `lastNamePrev` varchar(255) NOT NULL,
  `birthday_city` varchar(255) NOT NULL,
  `address_reg` text NOT NULL,
  `address_fact` text NOT NULL,
  `address_same` tinyint(1) NOT NULL DEFAULT '1',
  `im_flat` varchar(255) NOT NULL,
  `im_auto` varchar(255) NOT NULL,
  `im_autogos` varchar(255) NOT NULL,
  `work` text NOT NULL,
  `income_amount` varchar(255) NOT NULL,
  `income_period` int(11) NOT NULL,
  `income_date` date NOT NULL,
  `minus_amount` varchar(255) NOT NULL,
  `minus_credit` varchar(255) NOT NULL,
  `is_other_credit` tinyint(1) NOT NULL,
  `status` enum('new','2nd','loyalty','repeat') NOT NULL,
  `comment` text NOT NULL,
  `is_black` tinyint(1) NOT NULL,
  `id_office` int(11) NOT NULL,
  `id_manager` int(11) NOT NULL,
  `block_till` date NOT NULL,
  `tel_contacts` text NOT NULL,
  `card` varchar(4) NOT NULL,
  `workType` int(11) NOT NULL,
  `eduName` varchar(255) NOT NULL,
  `eduSpec` varchar(255) NOT NULL,
  `eduFac` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sex` (`sex`),
  KEY `inn` (`inn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `user_comments`;
CREATE TABLE `user_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `creationDateTime` datetime NOT NULL,
  `id_admin` int(11) NOT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 2019-12-05 15:26:45