qkrHhugC

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               5.5.9-log - MySQL Community Server (GPL)
4-- Server OS:                    Win32
5-- HeidiSQL Version:             9.2.0.4947
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-- Dumping structure for table toplist.monthly_income
14CREATE TABLE IF NOT EXISTS `monthly_income` (
15  `month` varchar(255) NOT NULL DEFAULT '',
16  `amount` int(11) DEFAULT '0',
17  PRIMARY KEY (`month`)
18) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19
20-- Data exporting was unselected.
21
22
23-- Dumping structure for table toplist.transaction_logs
24CREATE TABLE IF NOT EXISTS `transaction_logs` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `transaction` varchar(255) NOT NULL DEFAULT '',
27  `account_id` int(11) DEFAULT NULL,
28  `message` varchar(255) DEFAULT NULL,
29  `price` varchar(255) DEFAULT NULL,
30  `timestamp` int(11) DEFAULT NULL,
31  `status` varchar(50) NOT NULL DEFAULT '0',
32  PRIMARY KEY (`id`,`transaction`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35-- Data exporting was unselected.
36/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
37/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
38/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;