Profil

data/db_dagojek.sql

@@ -3,7 +3,7 @@
 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Oct 04, 2017 at 09:40 PM
+-- Generation Time: Oct 06, 2017 at 10:54 AM
 -- Server version: 10.0.31-MariaDB-0ubuntu0.16.04.2
 -- PHP Version: 7.0.22-0ubuntu0.16.04.1
 
@@ -37,7 +37,7 @@ CREATE TABLE `driver` (
 --
 
 INSERT INTO `driver` (`id`, `rating`, `sum_order`) VALUES
-  (1, 4.3, 121);
+(1, 4.3, 121);
 
 -- --------------------------------------------------------
 
@@ -67,6 +67,18 @@ CREATE TABLE `prefered_location` (
   `location` varchar(20) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
+--
+-- Dumping data for table `prefered_location`
+--
+
+INSERT INTO `prefered_location` (`id_driver`, `location`) VALUES
+(1, 'Cipaganti'),
+(1, 'Dago Asri'),
+(1, 'Dago Pojok'),
+(1, 'Lembang'),
+(1, 'Mantheos'),
+(1, 'Tubagus');
+
 -- --------------------------------------------------------
 
 --
@@ -89,7 +101,7 @@ CREATE TABLE `user` (
 --
 
 INSERT INTO `user` (`id`, `name`, `username`, `email`, `password`, `phone`, `photo`, `is_driver`) VALUES
-  (1, 'Fadhil Imam Kurnia', 'fadhilimamk', '13515146@std.stei.itb.ac.id', 'dtashfVATSaashdbgasdjy78123bahsVJSF72vsahsj', '085797490039', 'http://www.simian-risk.com/wp-content/themes/custom/images/empty-profile.png', 1);
+(1, 'Fadhil Imam Kurnia', 'fadhilimamk', '13515146@std.stei.itb.ac.id', 'dtashfVATSaashdbgasdjy78123bahsVJSF72vsahsj', '085797490039', '/img/profile/VGdWZUZ2dlJlUkM5eWpjVDcyQXJoZz09', 1);
 
 --
 -- Indexes for dumped tables
@@ -141,4 +153,4 @@ ALTER TABLE `driver`
 
 /*!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 */;
\ No newline at end of file
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;