7F8dnH11

1-- phpMyAdmin SQL Dump
2-- version 4.8.0
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: May 23, 2019 at 05:17 PM
7-- Server version: 10.1.31-MariaDB
8-- PHP Version: 7.2.4
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `tugas_soa`
23--
24CREATE DATABASE IF NOT EXISTS `tugas_soa` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `tugas_soa`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `d_like_video`
31--
32
33DROP TABLE IF EXISTS `d_like_video`;
34CREATE TABLE `d_like_video` (
35  `id_video` int(11) NOT NULL,
36  `id_user` varchar(32) NOT NULL,
37  `date_like` date NOT NULL,
38  `time_like` time NOT NULL,
39  `like_or_dislike` varchar(1) NOT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `d_subscribe`
46--
47
48DROP TABLE IF EXISTS `d_subscribe`;
49CREATE TABLE `d_subscribe` (
50  `id_user_subscriber` varchar(32) NOT NULL,
51  `id_user2_subscribed` varchar(32) NOT NULL
52) ENGINE=InnoDB DEFAULT CHARSET=latin1;
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `user`
58--
59
60DROP TABLE IF EXISTS `user`;
61CREATE TABLE `user` (
62  `password` varchar(255) NOT NULL,
63  `id_user` varchar(32) NOT NULL,
64  `nama_user` varchar(50) NOT NULL,
65  `email` varchar(50) NOT NULL,
66  `tanggal_lahir` date NOT NULL,
67  `date_created` date NOT NULL,
68  `profile_foto_url` varchar(75) NOT NULL,
69  `status` varchar(1) NOT NULL,
70  `description_channel` varchar(144) NOT NULL,
71  `subscriber_count` int(11) NOT NULL,
72  `api_key` varchar(255) NOT NULL
73) ENGINE=InnoDB DEFAULT CHARSET=latin1;
74
75-- --------------------------------------------------------
76
77--
78-- Table structure for table `video`
79--
80
81DROP TABLE IF EXISTS `video`;
82CREATE TABLE `video` (
83  `id_video` int(11) NOT NULL,
84  `judul_video` varchar(50) NOT NULL,
85  `description` varchar(144) NOT NULL,
86  `date_publish` date NOT NULL,
87  `time_publish` time NOT NULL,
88  `like_count` int(11) NOT NULL,
89  `dislike_count` int(11) NOT NULL,
90  `viewers_count` int(11) NOT NULL,
91  `comment_count` int(11) NOT NULL,
92  `video_path` varchar(75) NOT NULL,
93  `id_user` varchar(32) NOT NULL
94) ENGINE=InnoDB DEFAULT CHARSET=latin1;
95
96--
97-- Indexes for dumped tables
98--
99
100--
101-- Indexes for table `d_like_video`
102--
103ALTER TABLE `d_like_video`
104  ADD PRIMARY KEY (`id_video`,`id_user`),
105  ADD KEY `id_user` (`id_user`);
106
107--
108-- Indexes for table `d_subscribe`
109--
110ALTER TABLE `d_subscribe`
111  ADD PRIMARY KEY (`id_user_subscriber`,`id_user2_subscribed`),
112  ADD KEY `FK_USER_SUBSCRIBED` (`id_user2_subscribed`);
113
114--
115-- Indexes for table `user`
116--
117ALTER TABLE `user`
118  ADD PRIMARY KEY (`id_user`);
119
120--
121-- Indexes for table `video`
122--
123ALTER TABLE `video`
124  ADD PRIMARY KEY (`id_video`),
125  ADD KEY `FK_USER_VIDEO` (`id_user`);
126
127--
128-- AUTO_INCREMENT for dumped tables
129--
130
131--
132-- AUTO_INCREMENT for table `video`
133--
134ALTER TABLE `video`
135  MODIFY `id_video` int(11) NOT NULL AUTO_INCREMENT;
136COMMIT;
137
138/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
139/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
140/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;