-- 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