· 8 years ago · Jul 20, 2018, 04:28 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jul 20, 2018 at 10:12 AM
7-- Server version: 5.5.58-0+deb8u1
8-- PHP Version: 5.6.30-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `mmm`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `plans`
27--
28
29CREATE TABLE IF NOT EXISTS `plans` (
30`id` int(11) NOT NULL,
31 `active` int(11) NOT NULL,
32 `token` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
33 `plan` varchar(132) COLLATE utf8_unicode_ci NOT NULL,
34 `plan_category_id` int(11) NOT NULL,
35 `description` text COLLATE utf8_unicode_ci NOT NULL,
36 `amount` decimal(16,8) NOT NULL,
37 `amount_setup` decimal(16,8) NOT NULL,
38 `pay_start` int(11) NOT NULL,
39 `pay_end` int(11) NOT NULL,
40 `pay_day` decimal(16,8) NOT NULL,
41 `points` int(11) NOT NULL,
42 `binary_pay` int(11) NOT NULL,
43 `amount_direct` decimal(16,8) NOT NULL,
44 `level_1` int(11) NOT NULL,
45 `level_2` int(11) NOT NULL,
46 `level_3` int(11) NOT NULL,
47 `level_4` int(11) NOT NULL,
48 `level_5` int(11) NOT NULL,
49 `level_6` int(11) NOT NULL,
50 `level_7` int(11) NOT NULL,
51 `created` datetime NOT NULL,
52 `updated` datetime NOT NULL
53) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
54
55--
56-- Dumping data for table `plans`
57--
58
59INSERT INTO `plans` (`id`, `active`, `token`, `plan`, `plan_category_id`, `description`, `amount`, `amount_setup`, `pay_start`, `pay_end`, `pay_day`, `points`, `binary_pay`, `amount_direct`, `level_1`, `level_2`, `level_3`, `level_4`, `level_5`, `level_6`, `level_7`, `created`, `updated`) VALUES
60(4, 1, '914365a86081702076acb38d247ac930', 'Start', 1, '90 pontos - mineracao compartilhada (GPU) -', '99.00000000', '0.00000000', 30, 365, '5.00000000', 90, 0, '0.00000000', 0, 0, 0, 0, 0, 0, 0, '2017-08-21 00:00:00', '2017-08-21 00:00:00'),
61(5, 1, '3bcba9c4c9a88f16fcaba0eea9287afd', 'Basic', 1, '300 pontos - mineracao compartilhada (GPU)', '399.00000000', '0.00000000', 30, 365, '5.00000000', 300, 0, '0.00000000', 0, 0, 0, 0, 0, 0, 0, '2017-08-21 00:00:00', '2017-08-21 00:00:00'),
62(6, 1, '056cc65f514c96e21e5675b2c3b319cf', 'Enterprise', 1, '700 pontos - mineracao compartilhada (GPU)', '799.00000000', '0.00000000', 30, 365, '5.00000000', 700, 0, '0.00000000', 0, 0, 0, 0, 0, 0, 0, '2017-08-21 00:00:00', '2017-08-21 00:00:00'),
63(7, 1, 'b368ec6608ab40d367ec340f9e21f168', 'Ultimate', 1, '1500 pontos - mineracao compartilhada (GPU)', '1599.00000000', '0.00000000', 30, 365, '5.00000000', 1500, 0, '0.00000000', 0, 0, 0, 0, 0, 0, 0, '2017-08-21 00:00:00', '2017-08-21 00:00:00'),
64(8, 1, '0b4d2ff7d76c76ee617131e09a5d5789', 'EXTREME', 1, '3000 pontos - mineracao compartilhada (GPU)', '3199.00000000', '0.00000000', 30, 365, '14.99000000', 3000, 0, '0.00000000', 0, 0, 0, 0, 0, 0, 0, '2017-08-21 00:00:00', '2017-08-21 00:00:00'),
65(9, 1, '5ea690ef4c4430744d06c4fbbd8ab11b', 'VISION', 1, '6000 pontos - mineracao compartilhada (GPU)', '6399.00000000', '0.00000000', 30, 365, '29.99000000', 6000, 0, '0.00000000', 0, 0, 0, 0, 0, 0, 0, '2017-08-21 00:00:00', '2017-08-21 00:00:00');
66
67--
68-- Indexes for dumped tables
69--
70
71--
72-- Indexes for table `plans`
73--
74ALTER TABLE `plans`
75 ADD PRIMARY KEY (`id`);
76
77--
78-- AUTO_INCREMENT for dumped tables
79--
80
81--
82-- AUTO_INCREMENT for table `plans`
83--
84ALTER TABLE `plans`
85MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
86/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
87/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
88/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;