Skip to content
Snippets Groups Projects

Projekers - 13515051 - Girvandi Ilyas

Open Girvandi Ilyas requested to merge projekers/TugasBesar1_2017:master into master
Viewing commit 154f75e2
Show latest version
1 file
+ 5
5
Preferences
Compare changes
+ 5
5
@@ -61,7 +61,7 @@ CREATE TABLE `transaction` (
KEY `driver_id` (`driver_id`),
CONSTRAINT `transaction_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
CONSTRAINT `transaction_ibfk_2` FOREIGN KEY (`driver_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -70,7 +70,7 @@ CREATE TABLE `transaction` (
LOCK TABLES `transaction` WRITE;
/*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
INSERT INTO `transaction` VALUES (1,1,2,'Tubagus Ismail','Cisitu',5,'Oke banget','2017-09-01');
INSERT INTO `transaction` VALUES (1,1,2,'Tubagus Ismail','Cisitu',5,'Oke banget','2017-09-01'),(2,4,3,'Dago Asri','Kampus ITB',2,'Lambat banget nih','2017-10-01'),(3,1,3,'Cisitu','Plesiran',2,'Drivernya lambat pisan','2017-09-30'),(4,4,1,'Kopo','Ciwalk',5,'Perjalanan jauh tapi menyenangkan','2017-10-01');
/*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
UNLOCK TABLES;
@@ -91,7 +91,7 @@ CREATE TABLE `user` (
`isDriver` tinyint(1) NOT NULL,
`image` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -100,7 +100,7 @@ CREATE TABLE `user` (
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'pikachu','Pikachu','pikachu@gmail.com','abc123','081812341234',0,'pikachu.jpg'),(2,'ratata','Ratata','ratata@gmail.com','12345678','081234563456',1,'ratata.png');
INSERT INTO `user` VALUES (1,'pikachu','Pikachu','pikachu@gmail.com','abc123','081812341234',0,'pikachu.jpg'),(2,'ratata','Ratata','ratata@gmail.com','12345678','081234563456',1,'ratata.png'),(3,'bulbasaur','Bulbasaur','bulbasaur@gmail.com','abcdefg','081209870987',1,'bulbasaur.png'),(4,'charmander','Charmander','charmander@gmail.com','lkjhlkjh','098812341234',0,'charmander.png');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -113,4 +113,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-09-30 11:50:40
-- Dump completed on 2017-10-01 1:30:46