Edit: /mnt/backup/sql/cash_default.sql (24885B)
-- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: cash_default
-- ------------------------------------------------------
-- Server version 5.5.43-0ubuntu0.14.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `api_keys`
--
DROP TABLE IF EXISTS `api_keys`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_keys` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`client_id` int(10) unsigned NOT NULL,
`client_key` varchar(32) NOT NULL,
`activated` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `client_id` (`client_id`),
KEY `client_key` (`client_key`),
KEY `activated` (`activated`)
) ENGINE=InnoDB AUTO_INCREMENT=454 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `api_keys`
--
LOCK TABLES `api_keys` WRITE;
/*!40000 ALTER TABLE `api_keys` DISABLE KEYS */;
INSERT INTO `api_keys` VALUES (453,1,'fe72d8fb87fc9a278457b9b4a13e04af','1');
/*!40000 ALTER TABLE `api_keys` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bills`
--
DROP TABLE IF EXISTS `bills`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bills` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`balance` double(14,2) DEFAULT '0.00',
`start_balance` double(14,2) NOT NULL DEFAULT '0.00',
`currency_id` int(10) unsigned NOT NULL,
`company_id` int(10) unsigned NOT NULL DEFAULT '0',
`owner_user_id` int(10) unsigned NOT NULL,
`deleted` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `currency_id` (`currency_id`),
KEY `company_id` (`company_id`),
KEY `owner_user_id` (`owner_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bills`
--
LOCK TABLES `bills` WRITE;
/*!40000 ALTER TABLE `bills` DISABLE KEYS */;
INSERT INTO `bills` VALUES (1,'Основной',0.00,0.00,1,1,1,'0');
/*!40000 ALTER TABLE `bills` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `company`
--
DROP TABLE IF EXISTS `company`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`phone` varchar(15) NOT NULL,
`deleted` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company`
--
LOCK TABLES `company` WRITE;
/*!40000 ALTER TABLE `company` DISABLE KEYS */;
INSERT INTO `company` VALUES (1,'WORK','+38','0');
/*!40000 ALTER TABLE `company` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `company_contractor`
--
DROP TABLE IF EXISTS `company_contractor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_contractor` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`company_id` int(10) unsigned NOT NULL,
`contractor_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `company_id` (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company_contractor`
--
LOCK TABLES `company_contractor` WRITE;
/*!40000 ALTER TABLE `company_contractor` DISABLE KEYS */;
INSERT INTO `company_contractor` VALUES (1,1,19),(2,1,1),(4,1,2);
/*!40000 ALTER TABLE `company_contractor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `company_order_types`
--
DROP TABLE IF EXISTS `company_order_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company_order_types` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`company_id` int(10) unsigned NOT NULL,
`order_type_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `company_id` (`company_id`),
KEY `order_type_id` (`order_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `company_order_types`
--
LOCK TABLES `company_order_types` WRITE;
/*!40000 ALTER TABLE `company_order_types` DISABLE KEYS */;
INSERT INTO `company_order_types` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,1,11),(12,1,12);
/*!40000 ALTER TABLE `company_order_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(30) CHARACTER SET cp1251 NOT NULL,
`value` varchar(100) CHARACTER SET cp1251 NOT NULL,
`comm` varchar(255) CHARACTER SET cp1251 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contractor`
--
DROP TABLE IF EXISTS `contractor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contractor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`type` enum('cont','obj') NOT NULL DEFAULT 'cont',
`phone` varchar(15) NOT NULL,
`email` varchar(50) NOT NULL,
`deleted` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contractor`
--
LOCK TABLES `contractor` WRITE;
/*!40000 ALTER TABLE `contractor` DISABLE KEYS */;
INSERT INTO `contractor` VALUES (1,'Я','cont','+','','0'),(2,'ОФИС','obj','+','','0');
/*!40000 ALTER TABLE `contractor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `currency`
--
DROP TABLE IF EXISTS `currency`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currency` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`code` varchar(10) NOT NULL,
`static` enum('0','1') NOT NULL,
`deleted` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `currency`
--
LOCK TABLES `currency` WRITE;
/*!40000 ALTER TABLE `currency` DISABLE KEYS */;
INSERT INTO `currency` VALUES (1,'грн','uah','0','0');
/*!40000 ALTER TABLE `currency` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `logs`
--
DROP TABLE IF EXISTS `logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`action` varchar(300) NOT NULL,
`users_login` varchar(20) NOT NULL,
`action_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip` varchar(20) NOT NULL,
`func` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `logs`
--
LOCK TABLES `logs` WRITE;
/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
INSERT INTO `logs` VALUES (1,'Вы вошли как sk','sk','2018-07-04 20:45:04','31.134.121.132','login_model->login'),(2,'Пользователь sk вышел с системы.','sk','2018-07-04 20:45:30','31.134.121.132','login_model->out'),(3,'Вы вошли как sk','sk','2018-07-04 20:45:33','31.134.121.132','login_model->login'),(4,'API CALL ping POST: \r\n','sk','2018-07-04 20:46:12','31.134.121.132','api->index'),(5,'Пользователь sk вышел с системы.','sk','2018-07-04 20:52:13','31.134.121.132','login_model->out'),(6,'Вы вошли как sk','sk','2018-07-04 20:52:16','31.134.121.132','login_model->login'),(7,'Пользователь sk создал приходный ордер 1','sk','2018-07-04 20:57:14','31.134.121.132','index_model->change_order'),(8,'Пользователь sk создал расходный ордер 2','sk','2018-07-04 20:57:29','31.134.121.132','index_model->change_order');
/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `order_types`
--
DROP TABLE IF EXISTS `order_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_types` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`owner_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL,
`incoming` enum('0','1') NOT NULL DEFAULT '0',
`type` enum('cont','obj') NOT NULL DEFAULT 'cont',
`static` enum('0','1') NOT NULL DEFAULT '0',
`deleted` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `owner_id` (`owner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `order_types`
--
LOCK TABLES `order_types` WRITE;
/*!40000 ALTER TABLE `order_types` DISABLE KEYS */;
INSERT INTO `order_types` VALUES (1,0,'Перевод со счета','1','cont','1','0'),(2,0,'Перевод на счет','0','cont','1','0'),(3,0,'Пополнение кассы','1','cont','0','0'),(4,0,'Изъятие из кассы','0','cont','0','0'),(5,0,'Расходы','0','cont','0','0'),(6,5,'Бензин','0','cont','0','0'),(7,5,'Интернет','0','cont','0','0'),(8,0,'Закупка','0','obj','0','0'),(9,8,'Профиль','0','obj','0','0'),(10,8,'Полотно','0','obj','0','0'),(11,8,'Закладные','0','obj','0','0'),(12,0,'Материал и работа','1','cont','0','0');
/*!40000 ALTER TABLE `order_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `order_types_contractor`
--
DROP TABLE IF EXISTS `order_types_contractor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_types_contractor` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`order_type_id` int(10) unsigned NOT NULL,
`contractor_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `company_id` (`order_type_id`),
KEY `contractor_id` (`contractor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `order_types_contractor`
--
LOCK TABLES `order_types_contractor` WRITE;
/*!40000 ALTER TABLE `order_types_contractor` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_types_contractor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orders`
--
DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`create_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`create_user_id` int(10) unsigned NOT NULL,
`edit_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`edit_user_id` int(10) unsigned NOT NULL DEFAULT '0',
`bill_id` int(10) unsigned NOT NULL,
`order_date` date NOT NULL,
`incoming` double(14,2) unsigned NOT NULL DEFAULT '0.00',
`consumption` double(14,2) unsigned NOT NULL DEFAULT '0.00',
`bill_before` double(14,2) NOT NULL DEFAULT '0.00',
`comment` varchar(255) NOT NULL,
`contractor_id` int(10) unsigned NOT NULL,
`order_type_id` int(10) unsigned NOT NULL,
`reduction_id` int(10) unsigned NOT NULL,
`deleted` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `bill_id` (`bill_id`),
KEY `order_type_id` (`order_type_id`),
KEY `contractor_id` (`contractor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders`
--
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (1,'2018-07-04 20:57:14',1,'1970-01-01 00:00:00',0,1,'2018-07-04',1.00,0.00,0.00,'ТЕСТ',1,3,0,'0'),(2,'2018-07-04 20:57:29',1,'1970-01-01 00:00:00',0,1,'2018-07-04',0.00,1.00,0.00,'ТЕСТ',1,4,0,'0');
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `permissions`
--
DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
`perm_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`perm_desc` varchar(50) NOT NULL,
`alias` varchar(50) NOT NULL,
`group` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`perm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `permissions`
--
LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'Доступ к WEB','index',404),(2,'Доступ к WEB','menu',2),(3,'Создание предприятия','menu_references_company_add',1),(4,'Настройки предприятия','menu_references_companys',1),(5,'Создание объектов','menu_references_objects',1),(6,'Создание контрагентов','menu_references_contractors',1),(7,'Создание типов проводок','menu_references_order_types',1),(8,'Справочник валют','menu_references_currencys',1),(9,'Режим ВЛАДЕЛЕЦ','menu_admin',0),(10,'Редактирование пользователей','admin_users',0),(11,'Права доступа','admin_roles',0),(12,'Логи','admin_logs',0),(13,'Настройки программы','admin_settings',111),(14,'Счета','reference_bills',404),(15,'Редактирование счета','reference_bill',5),(16,'Добавление счета','reference_add_bill',5),(17,'Сохранение счета','reference_save_bill',5),(18,'Удаление счета','reference_del_bill',5),(19,'Список и смена логинов','admin_access_login',2),(20,'Консоль','menu_admin_session',0),(21,'Переводы между счетами','admin_access_transfer',3),(22,'Отмена не подтвержденного перевода','admin_access_transfer_rollback',3),(23,'Удаление перевода','admin_access_transfer_delete',3),(24,'Режим БУХГАЛТЕР','buh',2),(25,'API','admin_api',0),(26,'Работа с базой','admin_db_tools',0),(27,'Сохранение в CSV','admin_access_csv',5),(28,'Печать','admin_access_print',5);
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reductions`
--
DROP TABLE IF EXISTS `reductions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reductions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_id` int(10) unsigned NOT NULL,
`bill_id` int(10) unsigned NOT NULL,
`summ` double(14,2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reductions`
--
LOCK TABLES `reductions` WRITE;
/*!40000 ALTER TABLE `reductions` DISABLE KEYS */;
/*!40000 ALTER TABLE `reductions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role_perm`
--
DROP TABLE IF EXISTS `role_perm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_perm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_id` int(10) unsigned NOT NULL,
`perm_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `role_id` (`role_id`),
KEY `perm_id` (`perm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role_perm`
--
LOCK TABLES `role_perm` WRITE;
/*!40000 ALTER TABLE `role_perm` DISABLE KEYS */;
INSERT INTO `role_perm` VALUES (1,1,1),(2,2,1),(3,1,2),(6,2,2),(8,3,1),(9,3,2),(10,3,3),(11,4,1),(12,4,2),(13,4,3),(14,4,5),(20,1,3),(21,1,13),(23,1,10),(24,1,11),(25,1,8),(26,1,6),(28,1,12),(29,1,5),(30,2,3),(36,2,7),(38,2,6),(39,2,5),(40,2,4),(41,2,14),(42,2,15),(43,2,16),(44,2,17),(45,2,18),(46,1,14),(47,1,15),(48,1,16),(49,1,17),(50,1,18),(60,1,19),(61,1,20),(62,1,21),(63,1,22),(64,1,23),(65,3,5),(66,3,4),(67,3,6),(68,3,7),(69,3,14),(70,3,15),(71,3,16),(72,3,17),(73,3,18),(74,3,21),(75,3,22),(77,1,7),(78,2,21),(79,2,22),(81,1,4),(82,1,9),(83,1,25),(84,1,26),(85,1,27),(87,2,24),(89,2,26),(90,3,24),(91,3,26),(92,3,25),(93,5,1),(94,5,2),(95,5,3),(96,5,4),(97,5,5),(98,5,6),(99,5,7),(100,5,14),(101,5,15),(102,5,16),(103,5,17),(104,5,18),(105,5,21),(106,5,22),(107,5,23),(108,5,24),(109,5,25),(110,5,26),(111,2,19);
/*!40000 ALTER TABLE `role_perm` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
`role_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`role_name` varchar(50) NOT NULL,
`static` enum('0','1') NOT NULL,
`deleted` enum('0','1') NOT NULL,
PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roles`
--
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'SU','1','0'),(2,'Главный бухгалтер','1','0'),(3,'Кассир','1','0'),(4,'Гость','1','0'),(5,'Бухгалтер','0','0');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transactions`
--
DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`order_from` int(10) unsigned NOT NULL,
`order_to` int(10) unsigned NOT NULL,
`transfer_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`transfer_from` int(10) unsigned NOT NULL,
`transfer_to` int(10) unsigned NOT NULL,
`summ` double(14,2) unsigned NOT NULL,
`create_user_id` int(10) unsigned NOT NULL,
`contractor_id` int(10) unsigned NOT NULL,
`accept_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`accept` enum('0','1') NOT NULL DEFAULT '0',
`comment` varchar(50) NOT NULL,
`deleted` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `create_user_id` (`create_user_id`),
KEY `transfer_from` (`transfer_from`),
KEY `transfer_to` (`transfer_to`),
KEY `contractor_id` (`contractor_id`),
KEY `accept` (`accept`),
KEY `order_from` (`order_from`),
KEY `order_to` (`order_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transactions`
--
LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_bills`
--
DROP TABLE IF EXISTS `user_bills`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_bills` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`bill_id` int(10) unsigned NOT NULL,
`show_bill_id` int(11) NOT NULL DEFAULT '0',
`edit_bill_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment_bill_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `bill_id` (`bill_id`),
KEY `show_bill_id` (`show_bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_bills`
--
LOCK TABLES `user_bills` WRITE;
/*!40000 ALTER TABLE `user_bills` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_bills` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_role`
--
DROP TABLE IF EXISTS `user_role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`role_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `role_id` (`role_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_role`
--
LOCK TABLES `user_role` WRITE;
/*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
INSERT INTO `user_role` VALUES (1,1,1);
/*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`login` varchar(15) NOT NULL,
`phone` varchar(15) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
`FIO` varchar(100) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`email_confirmed` enum('0','1') NOT NULL DEFAULT '0',
`balance` double(10,2) NOT NULL DEFAULT '0.00',
`max_days` int(10) unsigned NOT NULL DEFAULT '0',
`max_days_show` int(10) unsigned NOT NULL,
`block` enum('0','1') NOT NULL DEFAULT '0',
`ip` varchar(23) NOT NULL DEFAULT '',
`datereg` datetime NOT NULL,
`lastvisit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`online` enum('0','1') NOT NULL DEFAULT '0',
`sid` varchar(50) NOT NULL DEFAULT '',
`online_times` int(3) NOT NULL DEFAULT '0',
`country_id` int(10) unsigned NOT NULL DEFAULT '0',
`region_id` int(10) unsigned NOT NULL DEFAULT '0',
`city_id` int(10) unsigned NOT NULL DEFAULT '0',
`contractor_id` int(10) unsigned NOT NULL DEFAULT '0',
`rate` tinyint(4) NOT NULL DEFAULT '5',
`lang` varchar(2) NOT NULL DEFAULT 'ru',
`json` text,
`deleted` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `login` (`login`),
KEY `city_id` (`city_id`),
KEY `email_confirmed` (`email_confirmed`),
KEY `block` (`block`),
KEY `contractor_id` (`contractor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'sk','+380502212339','3d0a0b124a4a95a6d4d3fc067b652c492afaac70730d988cebd5be6e434036a9','Сергей Олегович','g0502212339@gmail.com','1',100.00,31,0,'0','31.134.121.132','2006-03-13 00:00:00','2018-07-04 19:52:16','0','8ujahak6hvhtjvt4td7lkbg761',1530737536,2,82,2645,19,5,'ru','{\"events\":{\"smson\":1,\"showphone\":1,\"emailon\":1,\"emailnews\":1,\"callon\":0},\"exchange\":{\"orders_only_for_me\":0,\"orders_first_for_me\":1}}',0);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-05-12 18:38:53