-- MySQL dump 10.13 Distrib 5.7.25, for Linux (x86_64) -- -- Host: localhost Database: db_dmn -- ------------------------------------------------------ -- Server version 5.7.25-0ubuntu0.18.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `activities` -- DROP TABLE IF EXISTS `activities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activities` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `description` text, `published` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_activities_uid` (`uid`), KEY `user_id` (`user_id`), CONSTRAINT `activities_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activities` -- LOCK TABLES `activities` WRITE; /*!40000 ALTER TABLE `activities` DISABLE KEYS */; INSERT INTO `activities` VALUES ('d820336d4c','2019-01-28 22:54:13','2019-01-28 22:54:13',11,2,'une autre activité',NULL),('fdb15a0659','2019-02-07 09:23:10','2019-02-07 09:23:10',12,2,'Une dernier activité je ne sais pas pourquoi çà ne marchait pas',0); /*!40000 ALTER TABLE `activities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `alembic_version` -- DROP TABLE IF EXISTS `alembic_version`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alembic_version` ( `version_num` varchar(32) NOT NULL, PRIMARY KEY (`version_num`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `alembic_version` -- LOCK TABLES `alembic_version` WRITE; /*!40000 ALTER TABLE `alembic_version` DISABLE KEYS */; INSERT INTO `alembic_version` VALUES ('df2e5edc74a0'); /*!40000 ALTER TABLE `alembic_version` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `educations` -- DROP TABLE IF EXISTS `educations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `educations` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `formation` varchar(190) NOT NULL, `location` varchar(190) NOT NULL, `school` varchar(190) NOT NULL, `user_id` int(11) DEFAULT NULL, `description` text, `published` tinyint(1) DEFAULT NULL, `begin_at` datetime DEFAULT NULL, `end_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_educations_uid` (`uid`), KEY `user_id` (`user_id`), CONSTRAINT `educations_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `educations` -- LOCK TABLES `educations` WRITE; /*!40000 ALTER TABLE `educations` DISABLE KEYS */; INSERT INTO `educations` VALUES ('4049839db3','2019-01-31 10:49:50','2019-02-05 10:00:02',6,'Langage python et big data','Paris','Université de Paris 13',2,'The above Session is associated with our SQLite-enabled Engine, but it hasn’t opened any connections yet. When it’s first used, it retrieves a connection from a pool of connections maintained by the Engine, and holds onto it until we commit all changes and/or close the session object.',1,'1997-03-02 00:00:00','2006-03-02 00:00:00'),('63b2a4a6f7','2019-01-31 10:51:32','2019-01-31 22:26:25',9,'developpeent java','Paris','université de dmn',2,'education.published= form.published.dataeducation.published= form.published.dataeducation.published= form.published.data\r\neducation.published= form.published.dataeducation.published= form.published.dataflskjsdflks dfmkdslj',1,'1992-01-01 00:00:00','2002-01-01 00:00:00'),('ff2a42c975','2019-01-31 22:27:06','2019-01-31 22:27:06',16,'Adding and Updating Object','Lille','Université de Paris',2,'education.published= form.published.data education.published= form.published.data\r\neducation.published= form.published.data\r\neducation.published= form.published.data\r\n',1,'2000-02-02 00:00:00','2021-02-02 00:00:00'),('d6ba27cdd8','2019-02-05 10:00:59','2019-02-05 10:01:10',17,'Langage java et kotlin','Conakry','GANC',2,'Je n\'ai rien apris laba, rien du tout',0,'2004-04-02 00:00:00','2007-11-05 00:00:00'); /*!40000 ALTER TABLE `educations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emails` -- DROP TABLE IF EXISTS `emails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emails` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `published` tinyint(1) DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `email_from` varchar(150) NOT NULL, `email_to` varchar(150) NOT NULL, `subject` varchar(190) NOT NULL, `message` text NOT NULL, `name` varchar(190) NOT NULL, `phone` varchar(190) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `folder` varchar(50) DEFAULT NULL, `read` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_emails_uid` (`uid`), KEY `user_id` (`user_id`), CONSTRAINT `emails_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emails` -- LOCK TABLES `emails` WRITE; /*!40000 ALTER TABLE `emails` DISABLE KEYS */; INSERT INTO `emails` VALUES ('f523bfe5bd','2019-02-07 12:18:58','2019-02-07 12:18:58',0,1,'ndalaba@gmail.com','dmn@ndalaba.com','test','tesksd fsklfsdflkjsdflkmjsd','N\'Dalaba Diallo',NULL,2,NULL,NULL),('d3123c2127','2019-02-07 16:13:30','2019-02-07 16:13:30',0,2,'ndalaba@ymail.com','dmn@ndalaba.com','Un autre test','Je test l\'envoie de message','Diallo N\'Dalaba',NULL,2,'INBOX',0),('902275f301','2019-02-07 16:18:40','2019-02-07 16:18:40',0,3,'ndalaba@ymail.com','dmn@ndalaba.com','Un autre test','Je test l\'envoie de message','Diallo N\'Dalaba',NULL,2,'INBOX',0),('3544c44241','2019-02-07 16:19:11','2019-02-07 16:19:11',0,4,'ndalaba@ymail.com','dmn@ndalaba.com','Un autre test','Je test l\'envoie de message','Diallo N\'Dalaba',NULL,2,'INBOX',0),('2ec657ea95','2019-02-07 16:19:45','2019-02-07 16:19:45',0,5,'ndalaba@gmail.com','dmn@ndalaba.com',' kgj slkgj','lkgj mlkdjmlkdjfdlkfjdmlkfj','N\'Dalaba Diallo',NULL,2,'INBOX',0),('81e118d27e','2019-02-07 16:22:08','2019-02-07 16:22:08',0,6,'ndalaba@gmail.com','dmn@ndalaba.com',' kgj slkgj','lkgj mlkdjmlkdjfdlkfjdmlkfj','N\'Dalaba Diallo',NULL,2,'INBOX',0),('0deb265a0d','2019-02-07 16:26:49','2019-02-07 16:26:49',0,7,'ndalaba@ymail.com','dmn@ndalaba.com','uiy uiy','iuyi yiuyoyoiuyoiy','Mamadou N\\\'Dalaba Diallo',NULL,2,'INBOX',0); /*!40000 ALTER TABLE `emails` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `hobbies` -- DROP TABLE IF EXISTS `hobbies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hobbies` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(190) NOT NULL, `icon` varchar(190) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `description` text, `published` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_hobbies_uid` (`uid`), KEY `user_id` (`user_id`), CONSTRAINT `hobbies_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `hobbies` -- LOCK TABLES `hobbies` WRITE; /*!40000 ALTER TABLE `hobbies` DISABLE KEYS */; INSERT INTO `hobbies` VALUES ('dc14cdbda3','2019-02-05 20:36:37','2019-02-05 20:36:37',1,'Regarder la Télé','li_tv',2,'J\'aime surtout regarder les matchs de football, et regarder des films',1); /*!40000 ALTER TABLE `hobbies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(190) NOT NULL, `location` varchar(190) NOT NULL, `company` varchar(190) NOT NULL, `user_id` int(11) DEFAULT NULL, `description` text, `published` tinyint(1) DEFAULT NULL, `begin_at` datetime DEFAULT NULL, `end_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_jobs_uid` (`uid`), KEY `user_id` (`user_id`), CONSTRAINT `jobs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; INSERT INTO `jobs` VALUES ('1acfe5b1b1','2019-02-05 20:47:36','2019-02-05 20:47:36',1,'Application de gestion','Conakry, Guinée','Afrimarine',2,'J\'ai lfait dlfj mlkjakldj mflkj maljdkl famlkdjf mlkjdfddfdf',1,'2011-03-02 00:00:00','2012-10-02 00:00:00'); /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `services` -- DROP TABLE IF EXISTS `services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `services` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `service` varchar(190) NOT NULL, `icon` varchar(190) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `description` text, `detail` text, `published` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_services_uid` (`uid`), KEY `user_id` (`user_id`), CONSTRAINT `services_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `services` -- LOCK TABLES `services` WRITE; /*!40000 ALTER TABLE `services` DISABLE KEYS */; INSERT INTO `services` VALUES ('7ecac1d3cd','2019-02-05 20:53:41','2019-02-05 20:53:41',1,'Design','fa fa-image',2,'fsdk sdmlkfjsd flksdjf msdlkfjsdfs fmslkfj sklf dfjsdf\r\nsdfj sdlfjsdmflkj','fksdjf mslkfjmslfjqlkjfsdm fjqlkd jflqjmlfkqj sdf\r\nfdslfjdslkfdsjkljsdfksdfds',1),('9f67f92204','2019-02-07 00:00:56','2019-02-07 09:17:45',3,'Markeing digital','fa fa-edit',2,'fkdsj flksfj smdflj sdlfksjdflk fj','
- dlfk jdlfkjdf\r\njdfd fjldj\r\nd
- fl mfd\r\njdfdlfjdl\r\njdflkdfjl
- lkjkl wjlkwxmjxwlkj
\r\n
',1); /*!40000 ALTER TABLE `services` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `skills` -- DROP TABLE IF EXISTS `skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skills` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `skill` varchar(190) NOT NULL, `level` varchar(190) NOT NULL, `experience` int(11) DEFAULT NULL, `description` text, `user_id` int(11) DEFAULT NULL, `published` tinyint(1) DEFAULT NULL, `percent` int(11) DEFAULT NULL, `techno` varchar(190) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_skills_uid` (`uid`), KEY `user_id` (`user_id`), CONSTRAINT `skills_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `skills` -- LOCK TABLES `skills` WRITE; /*!40000 ALTER TABLE `skills` DISABLE KEYS */; INSERT INTO `skills` VALUES ('f76b398b7b','2019-02-05 21:10:25','2019-02-07 10:08:22',1,'Developpement Web','Avancé',5,'Je fais du php depuis le debut ',2,1,80,'PHP, Javascript'),('d1caebac74','2019-02-05 21:13:55','2019-02-07 10:09:29',3,'Programmation','Intermédiaire',2,'Pour le java c\'est autre chose',2,1,60,'Python, Java'),('7d6f2e6092','2019-02-05 21:19:06','2019-02-07 10:10:23',4,'Webdesing','100',8,'odspf sdmfsdùfmlsdkfùlm',2,1,70,'HMTL, CSS'); /*!40000 ALTER TABLE `skills` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(60) DEFAULT NULL, `job` varchar(60) DEFAULT NULL, `location` varchar(150) DEFAULT NULL, `email` varchar(60) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `role` varchar(60) DEFAULT NULL, `password_hash` varchar(130) DEFAULT NULL, `photo` varchar(130) DEFAULT NULL, `bio` text, `facebook` varchar(150) DEFAULT NULL, `github` varchar(150) DEFAULT NULL, `twitter` varchar(150) DEFAULT NULL, `linkedin` varchar(150) DEFAULT NULL, `published` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_users_uid` (`uid`), UNIQUE KEY `phone` (`phone`), UNIQUE KEY `photo` (`photo`), UNIQUE KEY `ix_users_email` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES ('a6c5a240','2019-01-27 00:44:11','2019-02-07 16:32:08',2,'N\'Dalaba Diallo','Développeur','1 allée des Saules, 93200 Saint Denis, France','contact@ndalaba.com','07 68 51 58 86',NULL,'pbkdf2:sha256:50000$HioRB5wW$9345dcf702286763018672736e23dedce01869305a47b9218b98395948d9a584','upload/users/cb8e0b94bd0e8a02.jpeg','Développeur depuis plus de 5 ans , j\'aime ce que je fais ','https://www.facebook.com/ndalaba','https://github.com/ndalaba','https://www.twitter.com/ndalaba','https://www.linkedin.com/in/n-dalaba-diallo-3b214523/',NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `works` -- DROP TABLE IF EXISTS `works`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `works` ( `uid` varchar(30) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(190) NOT NULL, `techno` varchar(190) NOT NULL, `user_id` int(11) DEFAULT NULL, `description` text, `image` varchar(190) DEFAULT NULL, `published` tinyint(1) DEFAULT NULL, `url` varchar(190) DEFAULT NULL, `category` varchar(190) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ix_works_uid` (`uid`), KEY `user_id` (`user_id`), CONSTRAINT `works_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `works` -- LOCK TABLES `works` WRITE; /*!40000 ALTER TABLE `works` DISABLE KEYS */; INSERT INTO `works` VALUES ('597bcb768b','2019-02-05 21:43:04','2019-02-07 10:39:46',1,'Application de gestion','Html/css, java, javascript',2,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce a auctor sem. Suspendisse egestas nulla eget nunc commodo, et blandit ante tristique. Aliquam dignissim nulla tellus, sed pellentesque libero pellentesque et.
Donec nec sem mattis, suscipit ligula id, porttitor tortor. Maecenas sed egestas odio, vitae euismod nulla. Duis viverra blandit mi quis rhoncus. Aenean vitae turpis et tortor elementum blandit. \r\n\r\ndignissim nulla tellus, sed pellentesque libero pellentesque et.
Donec nec sem mattis, suscipit ligula id, porttitor tortor. Maecenas sed egestas odio, vitae euismod nulla. Duis viverra blandit mi quis rhoncus. Aenean vitae turpis et tortor elementum blandit.
','upload/works/f55b60589cb9186d.jpg',1,'https://www.piaafrica.com/','Application web'),('313969ed93','2019-02-07 10:35:01','2019-02-07 10:40:46',3,'Afrimarine','HMTL, CSS',2,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce a auctor sem. Suspendisse egestas nulla eget nunc commodo, et
blandit ante tristique. Aliquam dignissim nulla tellus, sed pellentesque libero pellentesque et. Donec nec sem mattis, suscipit ligula id, porttitor tortor. Maecenas sed egestas odio, vitae euismod nulla. Duis viverra blandit mi quis rhoncus.
Aenean vitae turpis et tortor elementum blandit. \r\n\r\ndignissim nulla tellus, sed pellentesque libero pellentesque et. Donec nec sem mattis, suscipit ligula id, porttitor tortor. Maecenas sed egestas odio, vitae euismod nulla. Duis viverra blandit mi quis rhoncus. Aenean vitae turpis et tortor elementum blandit.
','upload/works/bcdbde0a042aed4b.jpg',1,'http://afrimarine-guinea.com','Site web'); /*!40000 ALTER TABLE `works` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2019-02-07 19:21:17