· 6 years ago · Jun 16, 2019, 12:52 AM
1mysql> ALTER TABLE project_erc20token DROP INDEX unique_token_data;
2ERROR 1553 (HY000): Cannot drop index 'unique_token_data': needed in a foreign key constraint
3
4-- MySQL dump 10.13 Distrib 5.7.26, for Linux (x86_64)
5--
6-- Host: localhost Database: crypto4ngo
7-- ------------------------------------------------------
8-- Server version 5.7.26-0ubuntu0.19.04.1
9
10/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
11/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
12/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
13/*!40101 SET NAMES utf8 */;
14/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
15/*!40103 SET TIME_ZONE='+00:00' */;
16/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
17/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
18/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
19/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
20
21--
22-- Table structure for table `auth_group`
23--
24
25DROP TABLE IF EXISTS `auth_group`;
26/*!40101 SET @saved_cs_client = @@character_set_client */;
27/*!40101 SET character_set_client = utf8 */;
28CREATE TABLE `auth_group` (
29 `id` int(11) NOT NULL AUTO_INCREMENT,
30 `name` varchar(150) NOT NULL,
31 PRIMARY KEY (`id`),
32 UNIQUE KEY `name` (`name`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `auth_group`
38--
39
40LOCK TABLES `auth_group` WRITE;
41/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
42/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `auth_group_permissions`
47--
48
49DROP TABLE IF EXISTS `auth_group_permissions`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `auth_group_permissions` (
53 `id` int(11) NOT NULL AUTO_INCREMENT,
54 `group_id` int(11) NOT NULL,
55 `permission_id` int(11) NOT NULL,
56 PRIMARY KEY (`id`),
57 UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
58 KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
59 CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
60 CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
61) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `auth_group_permissions`
66--
67
68LOCK TABLES `auth_group_permissions` WRITE;
69/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
70/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `auth_permission`
75--
76
77DROP TABLE IF EXISTS `auth_permission`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `auth_permission` (
81 `id` int(11) NOT NULL AUTO_INCREMENT,
82 `name` varchar(255) NOT NULL,
83 `content_type_id` int(11) NOT NULL,
84 `codename` varchar(100) NOT NULL,
85 PRIMARY KEY (`id`),
86 UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
87 CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
88) ENGINE=InnoDB DEFAULT CHARSET=latin1;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Dumping data for table `auth_permission`
93--
94
95LOCK TABLES `auth_permission` WRITE;
96/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
97/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
98UNLOCK TABLES;
99
100--
101-- Table structure for table `django_admin_log`
102--
103
104DROP TABLE IF EXISTS `django_admin_log`;
105/*!40101 SET @saved_cs_client = @@character_set_client */;
106/*!40101 SET character_set_client = utf8 */;
107CREATE TABLE `django_admin_log` (
108 `id` int(11) NOT NULL AUTO_INCREMENT,
109 `action_time` datetime(6) NOT NULL,
110 `object_id` longtext,
111 `object_repr` varchar(200) NOT NULL,
112 `action_flag` smallint(5) unsigned NOT NULL,
113 `change_message` longtext NOT NULL,
114 `content_type_id` int(11) DEFAULT NULL,
115 `user_id` int(11) NOT NULL,
116 PRIMARY KEY (`id`),
117 KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
118 KEY `django_admin_log_user_id_c564eba6_fk_user_user_id` (`user_id`),
119 CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
120 CONSTRAINT `django_admin_log_user_id_c564eba6_fk_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `user_user` (`id`)
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Dumping data for table `django_admin_log`
126--
127
128LOCK TABLES `django_admin_log` WRITE;
129/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */;
130/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */;
131UNLOCK TABLES;
132
133--
134-- Table structure for table `django_content_type`
135--
136
137DROP TABLE IF EXISTS `django_content_type`;
138/*!40101 SET @saved_cs_client = @@character_set_client */;
139/*!40101 SET character_set_client = utf8 */;
140CREATE TABLE `django_content_type` (
141 `id` int(11) NOT NULL AUTO_INCREMENT,
142 `app_label` varchar(100) NOT NULL,
143 `model` varchar(100) NOT NULL,
144 PRIMARY KEY (`id`),
145 UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
146) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147/*!40101 SET character_set_client = @saved_cs_client */;
148
149--
150-- Dumping data for table `django_content_type`
151--
152
153LOCK TABLES `django_content_type` WRITE;
154/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
155/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
156UNLOCK TABLES;
157
158--
159-- Table structure for table `django_migrations`
160--
161
162DROP TABLE IF EXISTS `django_migrations`;
163/*!40101 SET @saved_cs_client = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE `django_migrations` (
166 `id` int(11) NOT NULL AUTO_INCREMENT,
167 `app` varchar(255) NOT NULL,
168 `name` varchar(255) NOT NULL,
169 `applied` datetime(6) NOT NULL,
170 PRIMARY KEY (`id`)
171) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
172/*!40101 SET character_set_client = @saved_cs_client */;
173
174--
175-- Dumping data for table `django_migrations`
176--
177
178LOCK TABLES `django_migrations` WRITE;
179/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
180INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2019-06-02 23:48:08.042378'),(2,'contenttypes','0002_remove_content_type_name','2019-06-02 23:48:08.109635'),(3,'auth','0001_initial','2019-06-02 23:48:08.175753'),(4,'auth','0002_alter_permission_name_max_length','2019-06-02 23:48:08.340695'),(5,'auth','0003_alter_user_email_max_length','2019-06-02 23:48:08.355964'),(6,'auth','0004_alter_user_username_opts','2019-06-02 23:48:08.365035'),(7,'auth','0005_alter_user_last_login_null','2019-06-02 23:48:08.372186'),(8,'auth','0006_require_contenttypes_0002','2019-06-02 23:48:08.374797'),(9,'auth','0007_alter_validators_add_error_messages','2019-06-02 23:48:08.379832'),(10,'auth','0008_alter_user_username_max_length','2019-06-02 23:48:08.386091'),(11,'auth','0009_alter_user_last_name_max_length','2019-06-02 23:48:08.391981'),(12,'user','0001_initial','2019-06-02 23:48:08.454908'),(13,'admin','0001_initial','2019-06-02 23:48:08.702918'),(14,'admin','0002_logentry_remove_auto_add','2019-06-02 23:48:08.814770'),(15,'admin','0003_logentry_add_action_flag_choices','2019-06-02 23:48:08.837096'),(16,'auth','0010_alter_group_name_max_length','2019-06-02 23:48:08.853074'),(17,'auth','0011_update_proxy_permissions','2019-06-02 23:48:08.864174'),(18,'project','0001_initial','2019-06-02 23:48:08.907983'),(19,'project','0002_project_user','2019-06-02 23:48:09.008687'),(20,'project','0003_auto_20180329_0214','2019-06-02 23:48:09.147515'),(21,'project','0004_auto_20180330_0432','2019-06-02 23:48:09.221409'),(22,'project','0005_auto_20180331_2048','2019-06-02 23:48:09.296913'),(23,'project','0006_project_disabled','2019-06-02 23:48:09.352610'),(24,'project','0007_auto_20180405_1811','2019-06-02 23:48:09.492833'),(25,'project','0008_projectversion_owner','2019-06-02 23:48:09.538680'),(26,'project','0009_auto_20180405_1957','2019-06-02 23:48:09.600958'),(27,'project','0010_auto_20180405_1958','2019-06-02 23:48:09.666514'),(28,'project','0011_auto_20181212_0029','2019-06-02 23:48:09.733264'),(29,'project','0012_auto_20190426_1926','2019-06-02 23:48:09.753808'),(30,'project','0013_paymenturls','2019-06-02 23:48:09.785307'),(31,'project','0014_auto_20190427_1253','2019-06-02 23:48:09.899803'),(32,'project','0015_auto_20190427_1255','2019-06-02 23:48:09.955520'),(33,'project','0016_auto_20190427_1256','2019-06-02 23:48:10.028208'),(34,'project','0017_auto_20190427_1308','2019-06-02 23:48:10.088524'),(35,'project','0018_auto_20190510_1306','2019-06-02 23:48:10.169626'),(36,'project','0019_auto_20190510_1319','2019-06-02 23:48:10.294121'),(37,'project','0020_auto_20190510_1406','2019-06-02 23:48:10.319996'),(38,'project','0021_auto_20190523_1329','2019-06-02 23:48:10.329473'),(39,'project','0022_auto_20190524_0749','2019-06-02 23:48:10.508430'),(40,'project','0023_auto_20190525_1012','2019-06-02 23:48:10.518815'),(41,'project','0024_auto_20190525_2307','2019-06-02 23:48:10.531579'),(42,'project','0025_auto_20190526_0752','2019-06-02 23:48:10.538459'),(43,'project','0026_auto_20190527_0238','2019-06-02 23:48:10.705232'),(44,'project','0027_project_current_erc20_wallet','2019-06-02 23:48:10.860732'),(45,'project','0028_auto_20190527_1941','2019-06-02 23:48:10.955087'),(46,'project','0029_remove_project_current_erc20_token','2019-06-02 23:48:10.994059');
181/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
182UNLOCK TABLES;
183
184--
185-- Table structure for table `project_erc20token`
186--
187
188DROP TABLE IF EXISTS `project_erc20token`;
189/*!40101 SET @saved_cs_client = @@character_set_client */;
190/*!40101 SET character_set_client = utf8 */;
191CREATE TABLE `project_erc20token` (
192 `id` int(11) NOT NULL AUTO_INCREMENT,
193 `created` datetime(6) NOT NULL,
194 `owner` varchar(42) NOT NULL,
195 `contract_address` varchar(42) NOT NULL,
196 `contract_symbol` varchar(255) NOT NULL,
197 `contract_name` varchar(255) NOT NULL,
198 `project_id` int(11) NOT NULL,
199 `wallet_id` int(11) DEFAULT NULL,
200 `unqiue_hack` char(32) NOT NULL,
201 PRIMARY KEY (`id`),
202 UNIQUE KEY `unique_token_data` (`project_id`,`contract_address`,`contract_symbol`,`contract_name`,`owner`),
203 UNIQUE KEY `unqiue_hack` (`unqiue_hack`),
204 UNIQUE KEY `wallet_id` (`wallet_id`),
205 CONSTRAINT `project_erc20token_project_id_d389b8fb_fk_project_project_id` FOREIGN KEY (`project_id`) REFERENCES `project_project` (`id`),
206 CONSTRAINT `project_erc20token_wallet_id_db01a319_fk_project_e` FOREIGN KEY (`wallet_id`) REFERENCES `project_ethereumwallet` (`id`)
207) ENGINE=InnoDB DEFAULT CHARSET=latin1;
208/*!40101 SET character_set_client = @saved_cs_client */;
209
210--
211-- Dumping data for table `project_erc20token`
212--
213
214LOCK TABLES `project_erc20token` WRITE;
215/*!40000 ALTER TABLE `project_erc20token` DISABLE KEYS */;
216/*!40000 ALTER TABLE `project_erc20token` ENABLE KEYS */;
217UNLOCK TABLES;
218
219--
220-- Table structure for table `project_ethereumwallet`
221--
222
223DROP TABLE IF EXISTS `project_ethereumwallet`;
224/*!40101 SET @saved_cs_client = @@character_set_client */;
225/*!40101 SET character_set_client = utf8 */;
226CREATE TABLE `project_ethereumwallet` (
227 `id` int(11) NOT NULL AUTO_INCREMENT,
228 `created` datetime(6) NOT NULL,
229 `address` varchar(42) NOT NULL,
230 `project_id` int(11) NOT NULL,
231 PRIMARY KEY (`id`),
232 UNIQUE KEY `unique_ethereum_data` (`project_id`,`address`),
233 CONSTRAINT `project_ethereumwallet_project_id_f02b3077_fk_project_project_id` FOREIGN KEY (`project_id`) REFERENCES `project_project` (`id`)
234) ENGINE=InnoDB DEFAULT CHARSET=latin1;
235/*!40101 SET character_set_client = @saved_cs_client */;
236
237--
238-- Dumping data for table `project_ethereumwallet`
239--
240
241LOCK TABLES `project_ethereumwallet` WRITE;
242/*!40000 ALTER TABLE `project_ethereumwallet` DISABLE KEYS */;
243/*!40000 ALTER TABLE `project_ethereumwallet` ENABLE KEYS */;
244UNLOCK TABLES;
245
246--
247-- Table structure for table `project_paymenturl`
248--
249
250DROP TABLE IF EXISTS `project_paymenturl`;
251/*!40101 SET @saved_cs_client = @@character_set_client */;
252/*!40101 SET character_set_client = utf8 */;
253CREATE TABLE `project_paymenturl` (
254 `id` int(11) NOT NULL AUTO_INCREMENT,
255 `order` int(10) unsigned NOT NULL,
256 `url` varchar(200) NOT NULL,
257 `title` varchar(255) NOT NULL,
258 `project_version_id` int(11) NOT NULL,
259 PRIMARY KEY (`id`),
260 KEY `project_paymenturls_order_7c405be4` (`order`),
261 KEY `project_paymenturls_project_version_id_82ae8cc8_fk_project_p` (`project_version_id`),
262 CONSTRAINT `project_paymenturls_project_version_id_82ae8cc8_fk_project_p` FOREIGN KEY (`project_version_id`) REFERENCES `project_projectversion` (`id`)
263) ENGINE=InnoDB DEFAULT CHARSET=latin1;
264/*!40101 SET character_set_client = @saved_cs_client */;
265
266--
267-- Dumping data for table `project_paymenturl`
268--
269
270LOCK TABLES `project_paymenturl` WRITE;
271/*!40000 ALTER TABLE `project_paymenturl` DISABLE KEYS */;
272/*!40000 ALTER TABLE `project_paymenturl` ENABLE KEYS */;
273UNLOCK TABLES;
274
275--
276-- Table structure for table `project_project`
277--
278
279DROP TABLE IF EXISTS `project_project`;
280/*!40101 SET @saved_cs_client = @@character_set_client */;
281/*!40101 SET character_set_client = utf8 */;
282CREATE TABLE `project_project` (
283 `id` int(11) NOT NULL AUTO_INCREMENT,
284 `created` datetime(6) NOT NULL,
285 `updated` datetime(6) NOT NULL,
286 `user_id` int(11) NOT NULL,
287 `disabled` tinyint(1) NOT NULL,
288 `current_erc20_wallet_id` int(11) DEFAULT NULL,
289 PRIMARY KEY (`id`),
290 KEY `project_project_user_id_8710107a_fk_user_user_id` (`user_id`),
291 KEY `project_project_current_erc20_wallet_6187e471_fk_project_e` (`current_erc20_wallet_id`),
292 CONSTRAINT `project_project_current_erc20_wallet_6187e471_fk_project_e` FOREIGN KEY (`current_erc20_wallet_id`) REFERENCES `project_ethereumwallet` (`id`),
293 CONSTRAINT `project_project_user_id_8710107a_fk_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `user_user` (`id`)
294) ENGINE=InnoDB DEFAULT CHARSET=latin1;
295/*!40101 SET character_set_client = @saved_cs_client */;
296
297--
298-- Dumping data for table `project_project`
299--
300
301LOCK TABLES `project_project` WRITE;
302/*!40000 ALTER TABLE `project_project` DISABLE KEYS */;
303/*!40000 ALTER TABLE `project_project` ENABLE KEYS */;
304UNLOCK TABLES;
305
306--
307-- Table structure for table `project_projectversion`
308--
309
310DROP TABLE IF EXISTS `project_projectversion`;
311/*!40101 SET @saved_cs_client = @@character_set_client */;
312/*!40101 SET character_set_client = utf8 */;
313CREATE TABLE `project_projectversion` (
314 `id` int(11) NOT NULL AUTO_INCREMENT,
315 `created` datetime(6) NOT NULL,
316 `title` varchar(200) NOT NULL,
317 `description` longtext NOT NULL,
318 `money_usage` longtext NOT NULL,
319 `allow_advertisement` tinyint(1) NOT NULL,
320 `allow_press_releases` tinyint(1) NOT NULL,
321 `ownership` smallint(6) NOT NULL,
322 `country` varchar(2) NOT NULL,
323 `organization_name` varchar(255) NOT NULL,
324 `organization_number` varchar(20) NOT NULL,
325 `project_id` int(11) NOT NULL,
326 `url` varchar(200) NOT NULL,
327 `bitcoin_address` varchar(35) DEFAULT NULL,
328 PRIMARY KEY (`id`),
329 KEY `project_projectversion_project_id_b2445cad_fk_project_project_id` (`project_id`),
330 CONSTRAINT `project_projectversion_project_id_b2445cad_fk_project_project_id` FOREIGN KEY (`project_id`) REFERENCES `project_project` (`id`)
331) ENGINE=InnoDB DEFAULT CHARSET=latin1;
332/*!40101 SET character_set_client = @saved_cs_client */;
333
334--
335-- Dumping data for table `project_projectversion`
336--
337
338LOCK TABLES `project_projectversion` WRITE;
339/*!40000 ALTER TABLE `project_projectversion` DISABLE KEYS */;
340/*!40000 ALTER TABLE `project_projectversion` ENABLE KEYS */;
341UNLOCK TABLES;
342
343--
344-- Table structure for table `user_user`
345--
346
347DROP TABLE IF EXISTS `user_user`;
348/*!40101 SET @saved_cs_client = @@character_set_client */;
349/*!40101 SET character_set_client = utf8 */;
350CREATE TABLE `user_user` (
351 `id` int(11) NOT NULL AUTO_INCREMENT,
352 `password` varchar(128) NOT NULL,
353 `last_login` datetime(6) DEFAULT NULL,
354 `is_superuser` tinyint(1) NOT NULL,
355 `username` varchar(150) NOT NULL,
356 `first_name` varchar(30) NOT NULL,
357 `last_name` varchar(150) NOT NULL,
358 `email` varchar(254) NOT NULL,
359 `is_staff` tinyint(1) NOT NULL,
360 `is_active` tinyint(1) NOT NULL,
361 `date_joined` datetime(6) NOT NULL,
362 `ssh_pubkey` longtext NOT NULL,
363 `pgp_pubkey` longtext NOT NULL,
364 `show_email` tinyint(1) NOT NULL,
365 `show_keys` tinyint(1) NOT NULL,
366 PRIMARY KEY (`id`),
367 UNIQUE KEY `username` (`username`)
368) ENGINE=InnoDB DEFAULT CHARSET=latin1;
369/*!40101 SET character_set_client = @saved_cs_client */;
370
371--
372-- Dumping data for table `user_user`
373--
374
375LOCK TABLES `user_user` WRITE;
376/*!40000 ALTER TABLE `user_user` DISABLE KEYS */;
377/*!40000 ALTER TABLE `user_user` ENABLE KEYS */;
378UNLOCK TABLES;
379
380--
381-- Table structure for table `user_user_groups`
382--
383
384DROP TABLE IF EXISTS `user_user_groups`;
385/*!40101 SET @saved_cs_client = @@character_set_client */;
386/*!40101 SET character_set_client = utf8 */;
387CREATE TABLE `user_user_groups` (
388 `id` int(11) NOT NULL AUTO_INCREMENT,
389 `user_id` int(11) NOT NULL,
390 `group_id` int(11) NOT NULL,
391 PRIMARY KEY (`id`),
392 UNIQUE KEY `user_user_groups_user_id_group_id_bb60391f_uniq` (`user_id`,`group_id`),
393 KEY `user_user_groups_group_id_c57f13c0_fk_auth_group_id` (`group_id`),
394 CONSTRAINT `user_user_groups_group_id_c57f13c0_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
395 CONSTRAINT `user_user_groups_user_id_13f9a20d_fk_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `user_user` (`id`)
396) ENGINE=InnoDB DEFAULT CHARSET=latin1;
397/*!40101 SET character_set_client = @saved_cs_client */;
398
399--
400-- Dumping data for table `user_user_groups`
401--
402
403LOCK TABLES `user_user_groups` WRITE;
404/*!40000 ALTER TABLE `user_user_groups` DISABLE KEYS */;
405/*!40000 ALTER TABLE `user_user_groups` ENABLE KEYS */;
406UNLOCK TABLES;
407
408--
409-- Table structure for table `user_user_user_permissions`
410--
411
412DROP TABLE IF EXISTS `user_user_user_permissions`;
413/*!40101 SET @saved_cs_client = @@character_set_client */;
414/*!40101 SET character_set_client = utf8 */;
415CREATE TABLE `user_user_user_permissions` (
416 `id` int(11) NOT NULL AUTO_INCREMENT,
417 `user_id` int(11) NOT NULL,
418 `permission_id` int(11) NOT NULL,
419 PRIMARY KEY (`id`),
420 UNIQUE KEY `user_user_user_permissions_user_id_permission_id_64f4d5b8_uniq` (`user_id`,`permission_id`),
421 KEY `user_user_user_permi_permission_id_ce49d4de_fk_auth_perm` (`permission_id`),
422 CONSTRAINT `user_user_user_permi_permission_id_ce49d4de_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
423 CONSTRAINT `user_user_user_permissions_user_id_31782f58_fk_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `user_user` (`id`)
424) ENGINE=InnoDB DEFAULT CHARSET=latin1;
425/*!40101 SET character_set_client = @saved_cs_client */;
426
427--
428-- Dumping data for table `user_user_user_permissions`
429--
430
431LOCK TABLES `user_user_user_permissions` WRITE;
432/*!40000 ALTER TABLE `user_user_user_permissions` DISABLE KEYS */;
433/*!40000 ALTER TABLE `user_user_user_permissions` ENABLE KEYS */;
434UNLOCK TABLES;
435
436--
437-- Dumping events for database 'crypto4ngo'
438--
439
440--
441-- Dumping routines for database 'crypto4ngo'
442--
443/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
444
445/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
446/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
447/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
448/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
449/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
450/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
451/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
452
453-- Dump completed on 2019-06-03 3:06:39