 -- Dumping data for table `users`
 --
 
-INSERT INTO `users` (`user_id`, `firstname`, `lastname`, `username`, `email`, `password`, `gender`, `br_id`, `ustype_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
-(1, 'Grace ', 'Braganza', 'grace14322', 'grace14322@gmail.com', '15e5c87b18c1289d45bb4a72961b58e8', '2', 1, 1, '2016-04-02 07:19:55', '2016-04-02 07:19:55', '2016-04-02 07:19:55'),
-(8, 'Baby Anne', 'Lutap', 'babyanne', 'babyanne@gmail.com', '832fffb6f80ba56424734b88c85f78e1', '2', 1, 2, '2016-04-02 06:01:07', '2016-04-02 06:01:07', '2016-04-02 06:01:07'),
-(9, 'Jamir', 'Medina', 'jamir', 'jamir@gmail.com', 'c6f2088059e98c3da5e0f1529e915d09', '1', 1, 3, '2016-04-02 06:04:03', '2016-04-02 06:04:03', '2016-04-02 06:04:03'),
-(10, 'Armand', 'Navarro', 'armand', 'armand@yahoo.com', 'd138f04ec7016a21acc2ae19ddc708bc', '1', 2, 2, '2016-03-31 05:00:48', '2016-03-31 05:00:48', '2016-03-31 05:00:48'),
-(11, 'Gab', 'Perez', 'gab', 'gab@yahoo.com', '639bee393eecbc62256936a8e64d17b1', '1', 2, 3, '2016-03-27 23:56:47', '2016-03-27 23:56:47', '2016-03-27 23:56:47'),
-(12, 'Kristine', 'Rose', 'krose', 'krose@yahoo.com', '34259bb17ed44affeaa8e4ba4352bb0b', '2', 2, 3, '2016-03-27 23:49:22', '2016-03-27 23:49:22', '2016-03-27 23:49:22');
+INSERT INTO `users` (`user_id`, `firstname`, `lastname`, `username`, `email`, `password`, `gender`, `avatar`, `br_id`, `ustype_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
+(1, 'Grace', 'Braganza', 'grace14322', 'grace14322@gmail.com', '15e5c87b18c1289d45bb4a72961b58e8', '2', '', 1, 1, '2016-03-20 11:46:40', '2016-03-20 11:46:40', '2016-03-20 11:46:40'),
+(8, 'Baby Anne', 'Lutap', 'babyanne', 'babyanne@gmail.com', '832fffb6f80ba56424734b88c85f78e1', '2', '', 1, 2, '2016-03-20 11:46:19', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
+(9, 'Jamir', 'Medina', 'jamir', 'jeimzm@gmail.com', 'c6f2088059e98c3da5e0f1529e915d09', '1', '', 1, 3, '2016-03-27 19:06:57', '2016-03-27 19:06:57', '2016-03-27 19:06:57'),
+(10, 'Armando', 'Caroso', 'armang', 'armang@gmail.com', 'ef10b80bd18dfaccdba2d58c96261788', '1', '', 1, 3, '2016-03-20 12:08:34', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
+(11, 'Listerine', 'list', 'listerine', 'listerine@gmail.com', '163ef5bd3efb84b84be5dee2f2903521', '1', '', 2, 3, '2016-03-23 13:57:02', '2016-03-23 13:57:02', '2016-03-23 13:57:02'),
+(12, 'Kristine', 'Rose', 'krose', 'krose@yahoo.com', '34259bb17ed44affeaa8e4ba4352bb0b', '2', '', 2, 2, '2016-03-25 10:33:39', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
 
 -- --------------------------------------------------------
 

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 02, 2016 at 12:06 PM
-- Server version: 5.6.25
-- PHP Version: 5.5.27


  `tr_id` varchar(255) NOT NULL,
  `pr_id` int(11) NOT NULL,
  `item_quantity` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`item_id`, `tr_id`, `pr_id`, `item_quantity`) VALUES
(1, 'pT3GMBPMoWn', 5, 1),
(2, 'GHaSdMefs8J', 2, 1),
(3, 'GHaSdMefs8J', 4, 22);

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

