· 8 years ago · Mar 05, 2018, 06:14 PM
1```-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost Database: enumbra
4-- ------------------------------------------------------
5-- Server version 5.7.21-0ubuntu0.17.10.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `account_emailaddress`
20--
21
22DROP TABLE IF EXISTS `account_emailaddress`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `account_emailaddress` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `email` varchar(254) NOT NULL,
28 `verified` tinyint(1) NOT NULL,
29 `primary` tinyint(1) NOT NULL,
30 `user_id` int(11) NOT NULL,
31 PRIMARY KEY (`id`),
32 UNIQUE KEY `email` (`email`),
33 KEY `account_emailaddress_user_id_2c513194_fk_users_user_id` (`user_id`),
34 CONSTRAINT `account_emailaddress_user_id_2c513194_fk_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_user` (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Table structure for table `account_emailconfirmation`
40--
41
42DROP TABLE IF EXISTS `account_emailconfirmation`;
43/*!40101 SET @saved_cs_client = @@character_set_client */;
44/*!40101 SET character_set_client = utf8 */;
45CREATE TABLE `account_emailconfirmation` (
46 `id` int(11) NOT NULL AUTO_INCREMENT,
47 `created` datetime(6) NOT NULL,
48 `sent` datetime(6) DEFAULT NULL,
49 `key` varchar(64) NOT NULL,
50 `email_address_id` int(11) NOT NULL,
51 PRIMARY KEY (`id`),
52 UNIQUE KEY `key` (`key`),
53 KEY `account_emailconfirmation_email_address_id_5b7f8c58_fk` (`email_address_id`),
54 CONSTRAINT `account_emailconfirmation_email_address_id_5b7f8c58_fk` FOREIGN KEY (`email_address_id`) REFERENCES `account_emailaddress` (`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56/*!40101 SET character_set_client = @saved_cs_client */;
57
58--
59-- Table structure for table `auth_group`
60--
61
62DROP TABLE IF EXISTS `auth_group`;
63/*!40101 SET @saved_cs_client = @@character_set_client */;
64/*!40101 SET character_set_client = utf8 */;
65CREATE TABLE `auth_group` (
66 `id` int(11) NOT NULL AUTO_INCREMENT,
67 `name` varchar(80) NOT NULL,
68 PRIMARY KEY (`id`),
69 UNIQUE KEY `name` (`name`)
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71/*!40101 SET character_set_client = @saved_cs_client */;
72
73--
74-- Table structure for table `auth_group_permissions`
75--
76
77DROP TABLE IF EXISTS `auth_group_permissions`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `auth_group_permissions` (
81 `id` int(11) NOT NULL AUTO_INCREMENT,
82 `group_id` int(11) NOT NULL,
83 `permission_id` int(11) NOT NULL,
84 PRIMARY KEY (`id`),
85 UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
86 KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
87 CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
88 CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Table structure for table `auth_permission`
94--
95
96DROP TABLE IF EXISTS `auth_permission`;
97/*!40101 SET @saved_cs_client = @@character_set_client */;
98/*!40101 SET character_set_client = utf8 */;
99CREATE TABLE `auth_permission` (
100 `id` int(11) NOT NULL AUTO_INCREMENT,
101 `name` varchar(255) NOT NULL,
102 `content_type_id` int(11) NOT NULL,
103 `codename` varchar(100) NOT NULL,
104 PRIMARY KEY (`id`),
105 UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
106 CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
107) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
108/*!40101 SET character_set_client = @saved_cs_client */;
109
110--
111-- Table structure for table `django_admin_log`
112--
113
114DROP TABLE IF EXISTS `django_admin_log`;
115/*!40101 SET @saved_cs_client = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `django_admin_log` (
118 `id` int(11) NOT NULL AUTO_INCREMENT,
119 `action_time` datetime(6) NOT NULL,
120 `object_id` longtext,
121 `object_repr` varchar(200) NOT NULL,
122 `action_flag` smallint(5) unsigned NOT NULL,
123 `change_message` longtext NOT NULL,
124 `content_type_id` int(11) DEFAULT NULL,
125 `user_id` int(11) NOT NULL,
126 PRIMARY KEY (`id`),
127 KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
128 KEY `django_admin_log_user_id_c564eba6_fk_users_user_id` (`user_id`),
129 CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
130 CONSTRAINT `django_admin_log_user_id_c564eba6_fk_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_user` (`id`)
131) ENGINE=InnoDB DEFAULT CHARSET=latin1;
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134
135--
136-- Table structure for table `django_migrations`
137--
138
139DROP TABLE IF EXISTS `django_migrations`;
140/*!40101 SET @saved_cs_client = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `django_migrations` (
143 `id` int(11) NOT NULL AUTO_INCREMENT,
144 `app` varchar(255) NOT NULL,
145 `name` varchar(255) NOT NULL,
146 `applied` datetime(6) NOT NULL,
147 PRIMARY KEY (`id`)
148) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Table structure for table `django_session`
153--
154
155DROP TABLE IF EXISTS `django_session`;
156/*!40101 SET @saved_cs_client = @@character_set_client */;
157/*!40101 SET character_set_client = utf8 */;
158CREATE TABLE `django_session` (
159 `session_key` varchar(40) NOT NULL,
160 `session_data` longtext NOT NULL,
161 `expire_date` datetime(6) NOT NULL,
162 PRIMARY KEY (`session_key`),
163 KEY `django_session_expire_date_a5c62663` (`expire_date`)
164) ENGINE=InnoDB DEFAULT CHARSET=latin1;
165/*!40101 SET character_set_client = @saved_cs_client */;
166
167
168--
169-- Table structure for table `users_profile`
170--
171
172DROP TABLE IF EXISTS `users_profile`;
173/*!40101 SET @saved_cs_client = @@character_set_client */;
174/*!40101 SET character_set_client = utf8 */;
175CREATE TABLE `users_profile` (
176 `id` int(11) NOT NULL AUTO_INCREMENT,
177 `user_id` int(11) NOT NULL,
178 `bonus_enumbra` double NOT NULL,
179 `ref_code` varchar(30) NOT NULL,
180 `referral_enumbra` double NOT NULL,
181 `total_enumbra` double NOT NULL,
182 `bought_enumbra` double NOT NULL,
183 `invited_by_id` int(11) DEFAULT NULL,
184 PRIMARY KEY (`id`),
185 UNIQUE KEY `user_id` (`user_id`),
186 KEY `users_profile_invited_by_id_3ae04874` (`invited_by_id`),
187 CONSTRAINT `users_profile_invited_by_id_3ae04874_fk_users_user_id` FOREIGN KEY (`invited_by_id`) REFERENCES `users_user` (`id`),
188 CONSTRAINT `users_profile_user_id_2112e78d_fk_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_user` (`id`)
189) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
190/*!40101 SET character_set_client = @saved_cs_client */;
191
192--
193-- Table structure for table `users_user`
194--
195
196DROP TABLE IF EXISTS `users_user`;
197/*!40101 SET @saved_cs_client = @@character_set_client */;
198/*!40101 SET character_set_client = utf8 */;
199CREATE TABLE `users_user` (
200 `id` int(11) NOT NULL AUTO_INCREMENT,
201 `password` varchar(128) NOT NULL,
202 `last_login` datetime(6) DEFAULT NULL,
203 `is_superuser` tinyint(1) NOT NULL,
204 `username` varchar(150) NOT NULL,
205 `first_name` varchar(30) NOT NULL,
206 `last_name` varchar(150) NOT NULL,
207 `email` varchar(254) NOT NULL,
208 `is_staff` tinyint(1) NOT NULL,
209 `is_active` tinyint(1) NOT NULL,
210 `date_joined` datetime(6) NOT NULL,
211 `name` varchar(255) NOT NULL,
212 PRIMARY KEY (`id`),
213 UNIQUE KEY `username` (`username`)
214) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=latin1;
215/*!40101 SET character_set_client = @saved_cs_client */;
216
217--
218-- Table structure for table `users_user_groups`
219--
220
221DROP TABLE IF EXISTS `users_user_groups`;
222/*!40101 SET @saved_cs_client = @@character_set_client */;
223/*!40101 SET character_set_client = utf8 */;
224CREATE TABLE `users_user_groups` (
225 `id` int(11) NOT NULL AUTO_INCREMENT,
226 `user_id` int(11) NOT NULL,
227 `group_id` int(11) NOT NULL,
228 PRIMARY KEY (`id`),
229 UNIQUE KEY `users_user_groups_user_id_group_id_b88eab82_uniq` (`user_id`,`group_id`),
230 KEY `users_user_groups_group_id_9afc8d0e_fk_auth_group_id` (`group_id`),
231 CONSTRAINT `users_user_groups_group_id_9afc8d0e_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
232 CONSTRAINT `users_user_groups_user_id_5f6f5a90_fk_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_user` (`id`)
233) ENGINE=InnoDB DEFAULT CHARSET=latin1;
234/*!40101 SET character_set_client = @saved_cs_client */;
235
236--
237-- Table structure for table `users_user_user_permissions`
238--
239
240DROP TABLE IF EXISTS `users_user_user_permissions`;
241/*!40101 SET @saved_cs_client = @@character_set_client */;
242/*!40101 SET character_set_client = utf8 */;
243CREATE TABLE `users_user_user_permissions` (
244 `id` int(11) NOT NULL AUTO_INCREMENT,
245 `user_id` int(11) NOT NULL,
246 `permission_id` int(11) NOT NULL,
247 PRIMARY KEY (`id`),
248 UNIQUE KEY `users_user_user_permissions_user_id_permission_id_43338c45_uniq` (`user_id`,`permission_id`),
249 KEY `users_user_user_perm_permission_id_0b93982e_fk_auth_perm` (`permission_id`),
250 CONSTRAINT `users_user_user_perm_permission_id_0b93982e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
251 CONSTRAINT `users_user_user_permissions_user_id_20aca447_fk_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_user` (`id`)
252) ENGINE=InnoDB DEFAULT CHARSET=latin1;
253/*!40101 SET character_set_client = @saved_cs_client */;
254
255--
256-- Table structure for table `users_wallets`
257--
258
259DROP TABLE IF EXISTS `users_wallets`;
260/*!40101 SET @saved_cs_client = @@character_set_client */;
261/*!40101 SET character_set_client = utf8 */;
262CREATE TABLE `users_wallets` (
263 `id` int(11) NOT NULL AUTO_INCREMENT,
264 `type` varchar(4) NOT NULL,
265 `address` varchar(40) NOT NULL,
266 `user_id` int(11) NOT NULL,
267 PRIMARY KEY (`id`),
268 KEY `users_wallets_user_id_665d6717_fk_users_user_id` (`user_id`),
269 CONSTRAINT `users_wallets_user_id_665d6717_fk_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_user` (`id`)
270) ENGINE=InnoDB DEFAULT CHARSET=latin1;
271/*!40101 SET character_set_client = @saved_cs_client */;
272/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
273
274/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
275/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
276/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
277/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
278/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
279/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
280/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
281
282-- Dump completed on 2018-03-05 18:11:53
283```