donation db.sql

-- phpMyAdmin SQL Dump
-- version 4.0.4.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 23, 2015 at 05:32 PM
-- Server version: 5.5.32
-- PHP Version: 5.4.19

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `donation`
--
CREATE DATABASE IF NOT EXISTS `donation` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `donation`;

-- --------------------------------------------------------

--
-- Table structure for table `donate`
--

CREATE TABLE IF NOT EXISTS `donate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `donorId` int(10) unsigned NOT NULL,
  `moneyId` int(10) unsigned NOT NULL,
  `thingId` int(10) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `donate_donorid_foreign` (`donorId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `donate`
--

INSERT INTO `donate` (`id`, `donorId`, `moneyId`, `thingId`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 0, '2015-12-19 17:41:06', '2015-12-19 17:41:06'),
(2, 1, 2, 0, '2015-12-19 17:44:45', '2015-12-19 17:44:45'),
(3, 1, 0, 4, '2015-12-19 17:48:16', '2015-12-19 17:48:16'),
(4, 1, 0, 3, '2015-12-19 18:23:39', '2015-12-19 18:23:39'),
(5, 1, 4, 0, '2015-12-19 18:24:17', '2015-12-19 18:24:17'),
(6, 1, 0, 3, '2015-12-20 06:31:25', '2015-12-20 06:31:25'),
(7, 1, 0, 3, '2015-12-20 06:31:29', '2015-12-20 06:31:29'),
(8, 1, 0, 3, '2015-12-20 06:31:34', '2015-12-20 06:31:34'),
(9, 1, 3, 0, '2015-12-21 13:28:28', '2015-12-21 13:28:28');

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2014_10_12_000000_create_users_table', 1),
('2014_10_12_100000_create_password_resets_table', 1),
('2015_12_05_200000_create_problems_table', 1),
('2015_12_06_300000_add_cashier_columns', 1),
('2015_12_06_400000_create_money_table', 1),
('2015_12_12_500000_create_things_table', 1),
('2015_12_13_600000_create_donate_table', 1),
('2015_12_18_700000_add_fk_to_problems_table', 2);

-- --------------------------------------------------------

--
-- Table structure for table `money`
--

CREATE TABLE IF NOT EXISTS `money` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `organization` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cost` int(10) unsigned NOT NULL,
  `problemId` int(10) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `money_problemid_foreign` (`problemId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `money`
--

INSERT INTO `money` (`id`, `name`, `organization`, `phone`, `email`, `address`, `city`, `state`, `cost`, `problemId`, `created_at`, `updated_at`) VALUES
(1, 'Beverly Hills', 'Wuzrh', '3105559841', 'bhills_9841@mailinator.com', 'Dtusqx lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'Beverly Hills', 'CA', 9841, 2, '2015-12-19 17:41:07', '2015-12-19 17:41:07'),
(2, 'Beverly Hills', 'Xbdxo', '3105554176', 'bhills_4176@mailinator.com', 'Goqiwj lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'Beverly Hills', 'CA', 4176, 2, '2015-12-19 17:44:45', '2015-12-19 17:44:45'),
(3, 'Beverly Hills', 'Kdboi', '3105554476', 'bhills_4476@mailinator.com', 'Vnsmms lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'Beverly Hills', 'CA', 4476, 4, '2015-12-19 18:24:17', '2015-12-19 18:24:17'),
(4, 'Beverly Hills', 'Cuitd', '3105556022', 'bhills_6022@mailinator.com', 'Xafmul lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'Beverly Hills', 'CA', 6022, 3, '2015-12-21 13:28:28', '2015-12-21 13:28:28');

-- --------------------------------------------------------

--
-- Table structure for table `password_resets`
--

CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `problems`
--

CREATE TABLE IF NOT EXISTS `problems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `problem` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `severity` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cost` int(11) NOT NULL,
  `solved` int(10) unsigned NOT NULL DEFAULT '0',
  `userId` int(10) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `problems_phone_unique` (`phone`),
  KEY `problems_userid_foreign` (`userId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `problems`
--

INSERT INTO `problems` (`id`, `name`, `phone`, `address`, `problem`, `severity`, `cost`, `solved`, `userId`, `created_at`, `updated_at`) VALUES
(2, 'Beverly Hills', '3105550065', '0065 Beverly Dr', 'Awlqla lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'high', 65, 1, 2, '2015-12-18 15:35:57', '2015-12-21 14:10:26'),
(3, 'Beverly Hills', '3105557186', '7186 Beverly Dr', 'Qhtjed lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'high', 7186, 1, 2, '2015-12-18 15:36:16', '2015-12-19 08:37:43'),
(4, 'Waqas', '025998989', 'some address', 'Problem Detail', 'extreme', 989, 0, 2, '2015-12-19 09:58:06', '2015-12-19 09:58:06');

-- --------------------------------------------------------

--
-- Table structure for table `things`
--

CREATE TABLE IF NOT EXISTS `things` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quantity` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `problemId` int(10) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `things`
--

INSERT INTO `things` (`id`, `name`, `description`, `location`, `quantity`, `problemId`, `created_at`, `updated_at`) VALUES
(1, 'Beverly Hills', 'Ctgzij lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '8295 Beverly Dr', 'Kxosa', 4, '2015-12-19 17:48:16', '2015-12-19 17:48:16'),
(2, 'Beverly Hills', 'Qsnnxj lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '1476 Beverly Dr', 'Xnkmo', 3, '2015-12-19 18:23:39', '2015-12-19 18:23:39'),
(3, 'Beverly Hills', 'Dwgdri lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '1772 Beverly Dr', 'Eitmx', 3, '2015-12-20 06:31:25', '2015-12-20 06:31:25'),
(4, 'Beverly Hills', 'Dwgdri lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '1772 Beverly Dr', 'Eitmx', 3, '2015-12-20 06:31:29', '2015-12-20 06:31:29'),
(5, 'Beverly Hills', 'Dwgdri lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '1772 Beverly Dr', 'Eitmx', 3, '2015-12-20 06:31:34', '2015-12-20 06:31:34');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `donner` tinyint(1) NOT NULL,
  `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `stripe_active` tinyint(4) NOT NULL DEFAULT '0',
  `stripe_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stripe_subscription` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stripe_plan` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_four` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `subscription_ends_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `phone`, `address`, `donner`, `password`, `remember_token`, `created_at`, `updated_at`, `stripe_active`, `stripe_id`, `stripe_subscription`, `stripe_plan`, `last_four`, `trial_ends_at`, `subscription_ends_at`) VALUES
(1, 'Waqas Raza', 'donor@gmail.com', '03048346944', 'nust h-12', 1, '$2y$10$Zun.sbyg15ucY.ncEnguMuYvhaPxxKuy3GktnndYbSMuXFAjnGzhy', 'fGvZnFztJdKa8uOw4ViOrqrW9iN2JjE7OkwVgkCq6wY1oAIzAdAAWQl7pipE', '2015-12-18 15:28:39', '2015-12-21 17:24:11', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'Steve Austin', 'needy@gmail.com', '5096805330', 'street 32', 0, '$2y$10$tSFnnNDDiWZtlr2aqHvsS./qHSOE.dPk0BeT4xM0GTcIdNWRAqLWq', 'RcFYMb6uMwMwDrsvVBY7VgLSR0a3eO4Sm55SOP3PgJtELESWwHUO8CLR2Csf', '2015-12-18 15:29:07', '2015-12-21 17:10:29', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'Beverly Hills', 'bhills_3366@mailinator.com', '3105553366', '3366 Beverly Dr', 0, '$2y$10$mfccsoqr6IIoLoXHmLVi4eJ7xWCxpxHi0uih6z.3Ou5F0i2W8xa8.', NULL, '2015-12-20 06:59:50', '2015-12-20 06:59:50', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'Beverly Hills', 'bhills_4992@mailinator.com', '3105554992', '4992 Beverly Dr', 1, '$2y$10$0zmu03ZfPIQZw45CuNs7YeSMRbiT9bTRg3JB39euEPlC0rDwE0Mkq', NULL, '2015-12-20 07:01:13', '2015-12-20 07:01:13', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'Beverly Hills', 'bhills_9501@mailinator.com', '3105559501', '9501 Beverly Dr', 0, '$2y$10$qZUzQtb5s4M9juPQEUabiOxIFuts2nL6k7RPq7K1nMyYEWbRavWlO', NULL, '2015-12-20 13:11:59', '2015-12-20 13:11:59', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'Beverly Hills', 'bhills_9685@mailinator.com', '3105559685', '9685 Beverly Dr', 0, '$2y$10$YkmClzF84L7Za9kabB.E/e0YjAJQzIVDPvrpZex8k.ebWFlKYAx7W', NULL, '2015-12-20 13:12:44', '2015-12-20 13:12:44', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'Beverly Hills', 'bhills_6683@mailinator.com', '3105556683', '6683 Beverly Dr', 0, '$2y$10$ayI38zEc7daKs4sRSqa4yu2acqfDTiRq5qe/7E.x1wQIC6ZM7J21u', 'NVXuWIBda5crSirAnU9NyzOMkf401YhwxCEGeVGFs0bICsq13cFGqutCoGqi', '2015-12-20 13:14:01', '2015-12-20 13:14:18', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 'Beverly Hills', 'bhills_7547@mailinator.com', '3105557547', '7547 Beverly Dr', 1, '$2y$10$KtYvWgfX/7WrdP95c1xeceEmlrqsNsp04BcRP2EUJ0H6pNBMolRI2', 'RkNToSmDRkoD25Jz5Hk6IOYKeQNQETyd5Blo8F05WJDa9SVT1NFRF0hvuxEf', '2015-12-20 13:14:41', '2015-12-20 13:43:17', 0, NULL, NULL, NULL, NULL, NULL, NULL);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `donate`
--
ALTER TABLE `donate`
  ADD CONSTRAINT `donate_donorid_foreign` FOREIGN KEY (`donorId`) REFERENCES `users` (`id`);

--
-- Constraints for table `money`
--
ALTER TABLE `money`
  ADD CONSTRAINT `money_problemid_foreign` FOREIGN KEY (`problemId`) REFERENCES `problems` (`id`);

--
-- Constraints for table `problems`
--
ALTER TABLE `problems`
  ADD CONSTRAINT `problems_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`);

/*!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 */;