p1VE18z1

1DROP TABLE IF EXISTS `pemain`;
2
3CREATE TABLE `pemain` (
4	`id_pemain` int(11) NOT NULL,
5	`id_klub` int(11) NOT NULL,
6	`nama_depan` VARCHAR(50) NOT NULL,
7	`nama_belakang` VARCHAR(50) NOT NULL,
8	`tanggal_lahir` date NOT NULL,
9	`warga_negara` VARCHAR(50) NOT NULL,
10	`nomor_punggung` int(11) NOT NULL,
11	PRIMARY KEY (`id_pemain`),
12	CONSTRAINT `fk_pemain` FOREIGN KEY (`id_klub`) REFERENCES `klub` (`id_klub`) ON DELETE NO ACTION ON UPDATE NO ACTION
13	
14) ENGINE=InnoDB DEFAULT CHARSET=utf8;
15
16INSERT INTO `pemain` VALUES (1, 1, 'cristiano', 'messi', '1988-03-31', 'spanyol', 3),
17(2, 2, 'lionel', 'ramos', '1983-04-06', 'jepang', 21),
18(3, 3, 'sergio', 'benzema', '1977-05-21', 'australia', 1),
19(4, 4, 'karim', 'ji sung', '1990-07-12', 'argentina', 20),
20(5, 5, 'park', 'ronaldo', '1987-09-10', 'denmark', 9),
21(6, 1, 'bang', 'jago', '2000-12-02', 'indonesia', 10),
22(7, 2, 'kim', 'jong un', '1960-11-06', 'korea utara', 20),
23(8, 3, 'vladimir', 'putin', '1965-08-07', 'rusia', 15),
24(9, 4, 'prabowo', 'subianto', '1985-01-02', 'inggris', 0),
25(10, 5, 'donald', 'trump', '1999-02-04', 'amerika serikat', 19)
26
27
28DROP TABLE IF EXISTS `no_punggung`;
29
30CREATE TABLE `no_punggung` (
31	`id_pemain` int(11) NOT NULL,
32    `nomor_punggung` int(11) NOT NULL,
33    PRIMARY KEY (`id_pemain`),
34    CONSTRAINT `fk_pemain` FOREIGN KEY (`id_pemain`) REFERENCES `pemain` (`id_pemain`) ON DELETE NO ACTION ON UPDATE NO ACTION
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37INSERT INTO `pemain` VALUES (1, 3),
38(2, 21),
39(3, 1),
40(4, 20),
41(5, 9),
42(6, 10),
43(7, 20),
44(8, 15),
45(9, 0),
46(10, 19)
47
48
49
50