-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdbtugasbesar.sql
122 lines (103 loc) · 7.26 KB
/
dbtugasbesar.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
CREATE DATABASE IF NOT EXISTS `dbtugasbesar` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `dbtugasbesar`;
CREATE TABLE `anime` (
`id_anime` int(11) NOT NULL,
`judul_anime` varchar(100) NOT NULL,
`jumlah_episode` int(11) NOT NULL,
`rating_anime` double NOT NULL,
`gambar_anime` varchar(225) NOT NULL,
`sinopsis_anime` varchar(225) NOT NULL,
`durasi_anime` int(20) NOT NULL,
`status` varchar(15) NOT NULL,
`genre_anime` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `anime` (`id_anime`, `judul_anime`, `jumlah_episode`, `rating_anime`, `gambar_anime`, `sinopsis_anime`, `durasi_anime`, `status`, `genre_anime`) VALUES
(1, 'Kimi No Na Wa', 1, 9.12, 'Kimi No Na Wa.jpg', 'Menceritakan seorang gadis bernama Mitsuha Miyamizu yang tinggal di pedesaan dengan kehidupan rutinitas sebagai seorang pelajar, ia bisa menenun dan juga membuat sake untuk dipersembahkan kepada dewa.', 106, 'Completed', 'Romance, Supernatural, School, Drama'),
(2, 'Kaguya-sama: Love Is War', 12, 8.42, 'Kaguya-sama wa Kokurasetai Tensai-tachi no Renai Zunousen.jpg', 'Sang ketua OSIS Miyuki Shirogane dan wakil ketua OSIS Kaguya Shinomiya yang terlihat sempurna dimata para siswa, namun mereka berdua memiliki harga diri yang tinggi. Sehingga mereka sangat sulit untuk menyatakan perasaan', 24, 'completed', 'Comedy, Psychological, Romance, School, Seinen'),
(3, 'Charlotte', 13, 7.91, 'Charlotte.jpg', 'Dunia dimana beberapa perempuan dan laki-laki memiliki kemampuan khusus, mereka mendapatkan kekuatan dari suatu kejadian yang pernah terjadi.', 24, 'Completed', 'Drama, School, Super Power');
CREATE TABLE `streaming` (
`id_streaming` int(11) NOT NULL,
`id_anime` int(11) NOT NULL,
`episode_streaming` int(11) NOT NULL,
`url_streaming` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `streaming` (`id_streaming`, `id_anime`, `episode_streaming`, `url_streaming`) VALUES
(1, 1, 1, 'https://drive.google.com/file/d/0ByWK-tMARRCGYWdiSnRpNHR5YWs/preview'),
(2, 2, 2, 'https://drive.google.com/file/d/1P9zLK-V3G_o3t1shcvub9FQ_7y6D7MJn/view?usp=sharing'),
(3, 2, 3, 'https://drive.google.com/file/d/1X4zpubk3uwR5TVOvnAaJb5mNNXTUbPKO/view?usp=sharing'),
(4, 2, 4, 'https://drive.google.com/file/d/1FGNVzTx9uyQiNjlQPodPbEtX6FBG9My1/view?usp=sharing'),
(5, 2, 5, 'https://drive.google.com/file/d/1bWKDtJTaO_Ofb1mODSMD_rY1bjx24Xyc/view?usp=sharing'),
(6, 2, 6, 'https://drive.google.com/file/d/1llvYKYeNYnJmNrgzl9Ds3XJ9HXK8upSG/view?usp=sharing'),
(7, 2, 7, 'https://drive.google.com/file/d/1b1uX-mX3QsCthjhM4WwPM7nRImgy9By0/view?usp=sharing'),
(8, 2, 8, 'https://drive.google.com/file/d/1y3WlSOaVsiUIe6LWKakW9ITU_SB_ZuVy/view?usp=sharing'),
(9, 2, 9, 'https://drive.google.com/file/d/1FJpQXgBuHV8iGrOxfcZ8IKxaTE0qlL41/view?usp=sharing'),
(10, 2, 10, 'https://drive.google.com/file/d/1AZcNkaFkjkb3HCn5uK5ihhVTvRDP6P3I/view?usp=sharing'),
(11, 3, 1, 'https://drive.google.com/file/d/112WLixC0qVMwHflteeWZrv04_oht8FUb/view?usp=sharing'),
(12, 3, 2, 'https://drive.google.com/file/d/1x-T8lAV1yRig9zp4f6fOZjEGgniKITkC/view?usp=sharing'),
(13, 3, 3, 'https://drive.google.com/file/d/1-YyTx1jXA5S2j7srisjhbEdp8f5Nwy8A/view?usp=sharing'),
(14, 3, 4, 'https://drive.google.com/file/d/1_t_adPD2tO9bmnREbOhHQQG7qfL17rVv/view?usp=sharing'),
(15, 3, 5, 'https://drive.google.com/file/d/1TcQBJuGTY0V56ajcX91iJxQAU9nvE-69/view?usp=sharing'),
(16, 3, 6, 'https://drive.google.com/file/d/1zx5KOQUo5vWhqg6DmNpE97W6xquWMfzg/view?usp=sharing'),
(17, 3, 7, 'https://drive.google.com/file/d/17zMdmOr8N0ynpkY1ucn1U-8RvHt1EmD4/view?usp=sharing'),
(18, 3, 8, 'https://drive.google.com/file/d/1ChsN8KAUNhNGAL95PZCl_gSWuIp1yxGs/view?usp=sharing'),
(19, 3, 9, 'https://drive.google.com/file/d/1-vRpreCNXFCkRabCPOuXw6EniMtysdoa/view?usp=sharing'),
(20, 3, 10, 'https://drive.google.com/file/d/1H6fnibrO36iHO8UYCFivCYFttk50BLNQ/view?usp=sharing'),
(21, 3, 11, 'https://drive.google.com/file/d/15UuXwqpe9p7zXKgwJSkaCqC1zDsk9HuD/view?usp=sharing'),
(22, 3, 12, 'https://drive.google.com/file/d/1Rq9VrLmybwkMEgKyY9-Z4LZuGRXZH_vn/view?usp=sharing'),
(23, 3, 13, 'https://drive.google.com/file/d/13QZnOLaPr2dH3GLPfj5G6RX_46id_hwm/view?usp=sharing'),
(24, 2, 11, 'https://drive.google.com/file/d/1DhLudoJ63X1ae0VIkzBxAUvtYVX7SZqZ/view?usp=sharing'),
(25, 2, 12, 'https://drive.google.com/file/d/1JFswj2bVFtV2teY37ex8cGnDE19u6lhz/preview'),
(0, 2, 1, 'https://drive.google.com/open?id=13wHwlscfTp64drisAgwzdy78uAXpqR4a'),
(11, 3, 1, 'https://drive.google.com/file/d/112WLixC0qVMwHflteeWZrv04_oht8FUb/view?usp=sharing'),
(12, 3, 2, 'https://drive.google.com/file/d/1x-T8lAV1yRig9zp4f6fOZjEGgniKITkC/view?usp=sharing'),
(13, 3, 3, 'https://drive.google.com/file/d/1-YyTx1jXA5S2j7srisjhbEdp8f5Nwy8A/view?usp=sharing'),
(14, 3, 4, 'https://drive.google.com/file/d/1_t_adPD2tO9bmnREbOhHQQG7qfL17rVv/view?usp=sharing'),
(15, 3, 5, 'https://drive.google.com/file/d/1TcQBJuGTY0V56ajcX91iJxQAU9nvE-69/view?usp=sharing'),
(16, 3, 6, 'https://drive.google.com/file/d/1zx5KOQUo5vWhqg6DmNpE97W6xquWMfzg/view?usp=sharing'),
(17, 3, 7, 'https://drive.google.com/file/d/17zMdmOr8N0ynpkY1ucn1U-8RvHt1EmD4/view?usp=sharing'),
(18, 3, 8, 'https://drive.google.com/file/d/1ChsN8KAUNhNGAL95PZCl_gSWuIp1yxGs/view?usp=sharing'),
(19, 3, 9, 'https://drive.google.com/file/d/1-vRpreCNXFCkRabCPOuXw6EniMtysdoa/view?usp=sharing'),
(20, 3, 10, 'https://drive.google.com/file/d/1H6fnibrO36iHO8UYCFivCYFttk50BLNQ/view?usp=sharing'),
(21, 3, 11, 'https://drive.google.com/file/d/15UuXwqpe9p7zXKgwJSkaCqC1zDsk9HuD/view?usp=sharing'),
(22, 3, 12, 'https://drive.google.com/file/d/1Rq9VrLmybwkMEgKyY9-Z4LZuGRXZH_vn/view?usp=sharing'),
(23, 3, 13, 'https://drive.google.com/file/d/13QZnOLaPr2dH3GLPfj5G6RX_46id_hwm/view?usp=sharing');
CREATE TABLE `user` (
`id_user` int(11) NOT NULL,
`nama_user` varchar(255) NOT NULL,
`username_user` varchar(255) NOT NULL,
`password_user` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `user` (`id_user`, `nama_user`, `username_user`, `password_user`) VALUES
(6, 'admin', 'admin', 'admin'),
(11, 'Dedi cahya', 'gonior', 'bebaslah123'),
(12, 'Luchter', 'omaewa', '111111'),
(13, 'Fitriani', 'fitri', 'fitri'),
(14, 'asda', 'sndkjanskj', '123'),
(15, 'nani', 'nani', 'sayangnani');
ALTER TABLE `anime`
ADD PRIMARY KEY (`id_anime`);
ALTER TABLE `streaming`
ADD KEY `id_streaming` (`id_streaming`),
ADD KEY `id_anime` (`id_anime`) USING BTREE;
ALTER TABLE `user`
ADD PRIMARY KEY (`id_user`);
ALTER TABLE `anime`
MODIFY `id_anime` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
ALTER TABLE `streaming`
MODIFY `id_streaming` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
ALTER TABLE `user`
MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
ALTER TABLE `streaming`
ADD CONSTRAINT `streaming_ibfk_1` FOREIGN KEY (`id_anime`) REFERENCES `anime` (`id_anime`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;
/*!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 */;