WXhF6cRS

1-- --------------------------------------------------------
2-- Хост:                         127.0.0.1
3-- Версия сервера:               5.6.31-log - MySQL Community Server (GPL)
4-- ОС Сервера:                   Win32
5-- HeidiSQL Версия:              9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Дамп структуры для таблица c4l.market_cash
14CREATE TABLE IF NOT EXISTS `market_cash` (
15  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
16  `user_id` int(10) unsigned NOT NULL,
17  `balance` int(10) unsigned NOT NULL,
18  PRIMARY KEY (`id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21-- Экспортируемые данные не выделены.
22
23
24-- Дамп структуры для таблица c4l.market_operation
25CREATE TABLE IF NOT EXISTS `market_operation` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `cash_id` int(10) unsigned NOT NULL,
28  `user_id` int(10) unsigned NOT NULL,
29  `rebound` tinyint(1) unsigned NOT NULL DEFAULT '0',
30  `amount` double(10,2) NOT NULL DEFAULT '0.00',
31  `source_cash_id` int(10) unsigned DEFAULT NULL,
32  `outside_transaction_id` varchar(255) DEFAULT NULL,
33  `outside_transaction_provider` varchar(255) DEFAULT NULL,
34  `outside_transaction_data` text,
35  `manual_user_id` int(10) unsigned DEFAULT NULL,
36  `manual_comment` text,
37  `manual_data` text,
38  `dt_create` datetime NOT NULL,
39  `dt_update` datetime NOT NULL,
40  `data` text,
41  PRIMARY KEY (`id`)
42) ENGINE=InnoDB DEFAULT CHARSET=utf8;
43
44-- Экспортируемые данные не выделены.
45
46
47-- Дамп структуры для таблица c4l.market_operation_history
48CREATE TABLE IF NOT EXISTS `market_operation_history` (
49  `id` int(11) NOT NULL AUTO_INCREMENT,
50  `cash_id` int(10) unsigned NOT NULL,
51  `user_id` int(10) unsigned NOT NULL,
52  `rebound` tinyint(1) unsigned NOT NULL DEFAULT '0',
53  `amount` double(10,2) unsigned NOT NULL DEFAULT '0.00',
54  `source_cash_id` int(10) unsigned DEFAULT NULL,
55  `outside_transaction_id` varchar(255) DEFAULT NULL,
56  `outside_transaction_provider` varchar(255) DEFAULT NULL,
57  `outside_transaction_data` text,
58  `manual_user_id` int(10) unsigned DEFAULT NULL,
59  `manual_comment` text,
60  `manual_data` text,
61  `dt_create` datetime NOT NULL,
62  `dt_update` datetime NOT NULL,
63  `data` text,
64  PRIMARY KEY (`id`)
65) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
66
67-- Экспортируемые данные не выделены.
68
69
70-- Дамп структуры для таблица c4l.market_task
71CREATE TABLE IF NOT EXISTS `market_task` (
72  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
73  `type` enum('expect','trust') NOT NULL DEFAULT 'expect',
74  `cash_id` int(10) unsigned NOT NULL,
75  `user_id` int(10) unsigned NOT NULL,
76  `operation_id` int(11) DEFAULT NULL,
77  `amount` float(10,2) unsigned NOT NULL,
78  `dt_create` datetime NOT NULL,
79  `dt_update` datetime NOT NULL,
80  `dt_expires` datetime NOT NULL,
81  `create_user_id` int(10) unsigned NOT NULL,
82  `update_user_id` int(10) unsigned NOT NULL,
83  `data` text,
84  `recipient_user_id` int(10) unsigned DEFAULT NULL,
85  `recipient_cash_id` int(10) unsigned DEFAULT NULL,
86  `subject_key` varchar(255) DEFAULT NULL,
87  `subject_id` int(10) unsigned DEFAULT NULL,
88  `subject_data` text,
89  PRIMARY KEY (`id`)
90) ENGINE=InnoDB DEFAULT CHARSET=utf8;
91
92-- Экспортируемые данные не выделены.
93/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
94/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
95/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;