 --
 
 INSERT INTO `shipments` (`id`, `transaction_id`, `address`, `province`, `city`, `district`, `zipcode`, `phone`, `total_shipment_left`, `additional_note`, `last_delivery_date`, `created_at`, `updated_at`) VALUES
-(5, 30, 'baru 2', 'q', 'w', 'e', 'r', '08348984ka', 0, NULL, NULL, '2017-10-03 16:47:05', '2017-10-06 17:26:24'),
-(7, 32, 'garde', 'adsf', 'adsf', 'adsf', '34343', '34344434', 1, NULL, '2017-10-09 20:12:14', '2017-10-06 02:57:42', '2017-10-09 13:12:14'),
-(8, 33, 'garde', 'adsf', 'adsf', 'adsf', '34343', '55454545', 6, NULL, NULL, '2017-10-06 03:00:53', '2017-10-06 03:00:53'),
-(9, 34, 'baru 2', 'q', 'w', 'e', 'r', '08348984ka', 3, NULL, NULL, '2017-10-06 03:19:43', '2017-10-08 10:52:02'),
-(10, 35, 'baru 2', 'q', 'w', 'e', 'r', '08348984ka', 3, 'jangan sobek ya', '2017-10-09 20:15:48', '2017-10-06 03:23:19', '2017-10-09 13:15:48'),
-(11, 36, 'baru 2', 'q', 'w', 'e', 'r', '08348984ka', 6, NULL, NULL, '2017-10-06 17:10:10', '2017-10-06 17:10:10'),
-(12, 37, 'baru 2', 'q', 'w', 'e', 'r', '08348984ka', 4, NULL, NULL, '2017-10-07 17:06:25', '2017-10-07 17:06:25'),
-(14, 39, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-08 07:14:17', '2017-10-08 07:14:17'),
-(15, 40, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-08 07:23:29', '2017-10-08 07:23:29'),
 (16, 41, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-08 08:05:51', '2017-10-08 08:05:51'),
-(17, 42, 'Citra Garden Blok A3 nomor 4', 'DKI Jakarta', 'Jakarta', 'Kalideres', '14045', '08349823434', 4, NULL, NULL, '2017-10-08 10:42:02', '2017-10-08 10:42:02'),
+(17, 42, 'Citra Garden Blok A3 nomor 4', 'DKI Jakarta', 'Jakarta', 'Kalideres', '14045', '08349823434', 3, NULL, '2017-10-11 22:41:17', '2017-10-08 10:42:02', '2017-10-11 15:41:17'),
 (18, 43, 'Citra Garden Blok A3 nomor 4', 'DKI Jakarta', 'Jakarta', 'Kalideres', '14045', '08349823434', 4, NULL, NULL, '2017-10-08 11:23:42', '2017-10-08 11:23:42'),
 (21, 46, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 6, NULL, NULL, '2017-10-09 17:25:34', '2017-10-09 17:25:34'),
 (22, 47, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 6, NULL, NULL, '2017-10-09 17:26:04', '2017-10-09 17:26:04'),
 (23, 48, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-10 04:10:16', '2017-10-10 04:10:16'),
 (24, 49, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 2, NULL, NULL, '2017-10-10 04:26:03', '2017-10-10 04:26:03'),
-(25, 50, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-10 04:27:47', '2017-10-10 04:27:47');
+(25, 50, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-10 04:27:47', '2017-10-10 04:27:47'),
+(26, 51, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-10 06:35:50', '2017-10-10 06:35:50'),
+(27, 52, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 6, 'Pagar putih', NULL, '2017-10-10 07:02:09', '2017-10-10 07:02:09'),
+(28, 53, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-11 05:50:24', '2017-10-11 05:50:24'),
+(29, 54, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 6, NULL, NULL, '2017-10-11 14:51:22', '2017-10-11 14:51:22'),
+(30, 55, 'Poris Garden Blok C2 Nomor 6', 'Banten', 'Tangerang', 'Cipondoh', '15149', '081294831113', 4, NULL, NULL, '2017-10-11 15:34:41', '2017-10-11 15:34:41');
 
 -- --------------------------------------------------------
 

-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `plan_id`, `subscribe_duration`, `price`, `status`, `bank_account`, `account_holder`, `account_number`, `time_bought`, `time_confirmed`, `time_approved`, `created_at`, `updated_at`) VALUES
(30, 2, 1, 3, 20111, 'approved', '', '', '', '2017-10-03 23:47:05', '2017-10-04 00:26:23', '2017-10-04 00:27:21', '2017-10-03 16:47:05', '2017-10-03 17:27:21'),
(32, 3, 3, 2, 42333, 'approved', '', '', '', '2017-10-06 09:57:41', '2017-10-06 09:57:53', '2017-10-06 09:58:31', '2017-10-06 02:57:41', '2017-10-06 02:58:31'),
(33, 3, 2, 3, 31222, 'to be approved', '', '', '', '2017-10-06 10:00:53', '2017-10-06 10:00:59', NULL, '2017-10-06 03:00:53', '2017-10-06 03:00:59'),
(34, 2, 1, 2, 20111, 'approved', '', '', '', '2017-10-06 10:19:43', '2017-10-06 10:19:45', '2017-10-06 10:20:31', '2017-10-06 03:19:43', '2017-10-06 03:20:31'),
(35, 2, 1, 3, 20111, 'approved', '', '', '', '2017-10-06 10:23:19', '2017-10-06 10:23:21', '2017-10-06 10:24:22', '2017-10-06 03:23:19', '2017-10-06 03:24:22'),
(36, 2, 2, 3, 31222, 'to be approved', '', '', '', '2017-10-07 00:10:10', '2017-10-07 00:11:51', NULL, '2017-10-06 17:10:10', '2017-10-06 17:11:51'),
(37, 2, 1, 2, 20111, 'to be approved', '', '', '', '2017-10-08 00:06:24', '2017-10-09 21:54:18', NULL, '2017-10-07 17:06:24', '2017-10-09 14:54:18'),
(39, 2, 2, 2, 31222, 'to be approved', '', '', '', '2017-10-08 14:14:17', '2017-10-09 21:54:12', NULL, '2017-10-08 07:14:17', '2017-10-09 14:54:12'),
(40, 2, 1, 2, 20111, 'to be approved', '', '', '', '2017-10-08 14:23:29', '2017-10-09 21:23:50', NULL, '2017-10-08 07:23:29', '2017-10-09 14:23:50'),
(41, 2, 2, 2, 31222, 'to be approved', 'BCA', 'Keny', '604930434', '2017-10-08 15:05:51', '2017-10-08 15:06:09', NULL, '2017-10-08 08:05:51', '2017-10-08 08:06:09'),
(42, 4, 2, 2, 31222, 'approved', 'BCA', 'Sinaga', '6059034', '2017-10-08 17:42:02', '2017-10-08 17:43:28', '2017-10-08 17:47:03', '2017-10-08 10:42:02', '2017-10-08 10:47:03'),
(43, 4, 1, 2, 20111, 'to be approved', 'BCA', 'Alvin Theodora', '124556', '2017-10-08 18:23:42', '2017-10-08 18:23:49', NULL, '2017-10-08 11:23:42', '2017-10-08 11:23:49'),
(46, 2, 2, 3, 31222, 'to be approved', 'MANDIRI', 'SELI', '94833223', '2017-10-10 00:25:34', '2017-10-10 11:18:52', NULL, '2017-10-09 17:25:34', '2017-10-10 04:18:52'),
(47, 2, 2, 3, 31222, 'to be approved', 'bca', 'kena', '34443433', '2017-10-10 00:26:04', '2017-10-10 10:55:05', NULL, '2017-10-09 17:26:04', '2017-10-10 03:55:05'),
(48, 2, 2, 2, 31222, 'to be approved', 'BCA', 'KENT', '68940511', '2017-10-10 11:10:16', '2017-10-10 11:17:05', NULL, '2017-10-10 04:10:16', '2017-10-10 04:17:05'),
(49, 2, 2, 1, 31222, 'to be approved', 'BNI', 'KENTSELI', '93484333', '2017-10-10 11:26:03', '2017-10-10 11:27:26', NULL, '2017-10-10 04:26:03', '2017-10-10 04:27:26'),
(50, 2, 3, 2, 42333, 'to be approved', 'bca', 'sina', '343443', '2017-10-10 11:27:47', '2017-10-10 11:37:33', NULL, '2017-10-10 04:27:47', '2017-10-10 04:37:33');

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


  `user_id` int(10) UNSIGNED NOT NULL,
  `plan_id` int(10) UNSIGNED NOT NULL,
  `subscribe_duration` int(11) NOT NULL,
  `coffee_grind_size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_account` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_holder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
