--
-- Host: localhost    Database: localhost
-- ------------------------------------------------------


--
-- Table structure for table `application_business_profs`
--

CREATE TABLE `application_business_profs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `application_business_profs`
--


--
-- Table structure for table `application_images`
--

CREATE TABLE `application_images` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `application_images`
--


--
-- Table structure for table `contactuses`
--

CREATE TABLE `contactuses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `referial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contactuses`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (25,'2018_04_03_160110_create_questions_table',1),(57,'2014_10_12_000000_create_users_table',2),(58,'2014_10_12_100000_create_password_resets_table',2),(59,'2018_03_22_213436_create_subscriptions_table',2),(60,'2018_03_23_125005_create_contactuses_table',2),(61,'2019_02_01_082827_create_the_entreprenuers_table',2),(62,'2019_02_01_082848_create_the_enterprises_table',2),(63,'2019_02_01_085812_create_problem_inovation_section2s_table',2),(64,'2019_02_05_203222_create_application_images_table',3),(65,'2019_02_05_203327_create_application_business_profs_table',3);

--
-- Table structure for table `problem_inovation_section2s`
--

CREATE TABLE `problem_inovation_section2s` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `sector_of_problem` text COLLATE utf8mb4_unicode_ci,
  `sunstainable_dev_goal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_problem` text COLLATE utf8mb4_unicode_ci,
  `social_innovation` text COLLATE utf8mb4_unicode_ci,
  `competitive_advantage_on_solution` text COLLATE utf8mb4_unicode_ci,
  `save_flag` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `problem_inovation_section2s`
--

INSERT INTO `problem_inovation_section2s` VALUES (1,1,'khkkjkjkjkj','[\"No Poverty\",\"Zero Hunger\",\"Good Health and well-being\"]','hvghcjchh','cddcd','dsdsdsdsd',1,'2019-02-05 15:55:06','2019-02-05 16:43:50');

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `qn_status` int(11) NOT NULL DEFAULT '0',
  `eligibity_qn1` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibity_qn2` text COLLATE utf8mb4_unicode_ci,
  `eligibity_qn3` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibity_qn4` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eligibity_qn5` text COLLATE utf8mb4_unicode_ci,
  `eligibity_qn6` text COLLATE utf8mb4_unicode_ci,
  `eligibity_status` int(11) NOT NULL DEFAULT '0',
  `problem_qn1` text COLLATE utf8mb4_unicode_ci,
  `problem_qn2` text COLLATE utf8mb4_unicode_ci,
  `problem_status` int(11) NOT NULL DEFAULT '0',
  `solution_qn1` text COLLATE utf8mb4_unicode_ci,
  `solution_qn2` text COLLATE utf8mb4_unicode_ci,
  `solution_qn3` text COLLATE utf8mb4_unicode_ci,
  `solution_qn4` text COLLATE utf8mb4_unicode_ci,
  `solution_qn5` text COLLATE utf8mb4_unicode_ci,
  `solution_qn6` text COLLATE utf8mb4_unicode_ci,
  `solution_qn7` text COLLATE utf8mb4_unicode_ci,
  `solution_status` int(11) NOT NULL DEFAULT '0',
  `founder_qn1` text COLLATE utf8mb4_unicode_ci,
  `founder_qn2` text COLLATE utf8mb4_unicode_ci,
  `founder_qn3` text COLLATE utf8mb4_unicode_ci,
  `founder_qn4` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `founder_qn5` text COLLATE utf8mb4_unicode_ci,
  `founder_qn6` text COLLATE utf8mb4_unicode_ci,
  `founder_qn7` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `founder_qn8` text COLLATE utf8mb4_unicode_ci,
  `founder_qn9` text COLLATE utf8mb4_unicode_ci,
  `founder_qn10` text COLLATE utf8mb4_unicode_ci,
  `founder_qn11` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `founder_qn12` text COLLATE utf8mb4_unicode_ci,
  `founder_status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `questions`
--


--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sub_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `the_enterprises`
--

CREATE TABLE `the_enterprises` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `business_concept` text COLLATE utf8mb4_unicode_ci,
  `links` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `founder_or_cofounder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `files` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_of_capital` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revenue_generation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_and_market` text COLLATE utf8mb4_unicode_ci,
  `beneficiary` text COLLATE utf8mb4_unicode_ci,
  `beneficiary_life_improval` text COLLATE utf8mb4_unicode_ci,
  `solution_improve_society` text COLLATE utf8mb4_unicode_ci,
  `envision` text COLLATE utf8mb4_unicode_ci,
  `skills_needed` text COLLATE utf8mb4_unicode_ci,
  `save_flag` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `benefit_estimates` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `the_enterprises`
--

INSERT INTO `the_enterprises` VALUES (1,1,'sxscskcks',NULL,NULL,NULL,'null','null','xzxzxz','cdckdckdkcd','jghgjjjgjggjj','cdcdcdc','cdcdcd','null',0,'2019-02-05 16:54:31','2019-02-05 17:31:21','dcdcdcdc');

--
-- Table structure for table `the_entreprenuers`
--

CREATE TABLE `the_entreprenuers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `education` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `social_enterprise_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year_founded` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `founder_or_cofounder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inspiration` text COLLATE utf8mb4_unicode_ci,
  `formally_registerd` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_of_org` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `org_reg_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year_org_registered` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tin_availability` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tin_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `org_link_one` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `org_link_two` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `org_link_three` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buss_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referal_channel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `save_flag` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `the_entreprenuers`
--

INSERT INTO `the_entreprenuers` VALUES (1,1,'jndndnd','737373848','25 to 34','male','Kigamboni','University','English','nbfnbnbsnbfns','2018-09-23','Founder','nbbbjbjbj','Yes','Company Limited','3433343','2017-08-21','Yes','132-456-675-3434','jkjkjkjkjkkk',',dkmkdkdmcdk','ckdmdkcmdcm','Dar es salaam','[\"WhatsApp\",\"Facebook\",\"Twitter\"]',1,'2019-02-05 05:22:38','2019-02-05 15:24:37');


