· 7 years ago · Dec 26, 2018, 08:08 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.9
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 26, 2018 at 08:04 AM
7-- Server version: 5.6.37
8-- PHP Version: 7.1.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `fb_ruang`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `pemesanan`
21--
22
23CREATE TABLE IF NOT EXISTS `pemesanan` (
24 `id` int(11) NOT NULL,
25 `nama_pemesan` varchar(100) NOT NULL,
26 `user_id` int(11) NOT NULL DEFAULT '4',
27 `ruang_id` int(11) NOT NULL,
28 `jadwal_id` int(11) NOT NULL,
29 `nama_ruangan` varchar(100) NOT NULL,
30 `prodi_dosen` varchar(50) NOT NULL,
31 `jam_mulai` varchar(20) NOT NULL,
32 `sks` varchar(5) NOT NULL,
33 `tanggal` date DEFAULT NULL,
34 `status` enum('yes','no','other','waiting') NOT NULL DEFAULT 'waiting',
35 `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
36) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
37
38--
39-- Dumping data for table `pemesanan`
40--
41
42INSERT INTO `pemesanan` (`id`, `nama_pemesan`, `user_id`, `ruang_id`, `jadwal_id`, `nama_ruangan`, `prodi_dosen`, `jam_mulai`, `sks`, `tanggal`, `status`, `updated`) VALUES
43(56, 'andi', 4, 6, 1, '', 'pte-yusran', '', '2', '2018-12-17', 'yes', '2018-12-25 13:48:17'),
44(57, 'ade', 4, 8, 9, '', 'PTI-Ghufran', '', '2', '2018-12-17', 'yes', '2018-12-25 13:48:31'),
45(59, 'akbar', 4, 11, 1, '', 'pte-bustomi', '', '3', '2018-12-17', 'no', '2018-12-25 13:48:31'),
46(60, 'ipad', 4, 12, 11, '', 'pte-mira', '', '3', '2018-12-17', 'no', '2018-12-25 13:48:31'),
47(61, 'muhajir', 4, 10, 10, '', 'pte-mira', '', '2', '2018-12-17', 'no', '2018-12-25 13:48:31'),
48(62, 'andi', 4, 10, 12, '', 'pti-andika', '', '2', '2018-12-17', 'no', '2018-12-25 13:48:31'),
49(63, 'dian', 4, 3, 1, '', 'pte-yusran', '', '2', '2018-12-17', 'yes', '2018-12-25 13:48:31'),
50(64, 'ipad', 4, 8, 8, '', 'pte-bustomi', '', '1', '2018-12-17', 'no', '2018-12-25 13:48:31'),
51(65, 'akbar', 4, 2, 1, '', 'pti-andika', '', '3', '2018-12-21', 'yes', '2018-12-25 13:48:31'),
52(66, 'muhajir', 4, 5, 1, '', 'pte-bustomi', '', '1', '2018-12-24', 'no', '2018-12-25 13:48:31'),
53(67, 'Khairul', 4, 5, 3, '', 'PTI - Syubhan', '', '3', '2018-12-24', 'yes', '2018-12-25 13:48:31'),
54(68, 'Haji', 4, 7, 1, '', 'PTI - Bustomi', '', '2', '2018-12-24', 'waiting', '2018-12-25 13:48:31'),
55(69, 'Nanda', 4, 12, 4, '', 'PTI - Basrul', '', '3', '2018-12-24', 'yes', '2018-12-25 13:48:31'),
56(70, 'Fauzi', 4, 11, 1, '', 'PTI - Ghufran', '', '2', '2018-12-24', 'yes', '2018-12-25 13:48:31'),
57(71, 'Akbar', 4, 2, 5, '', 'PBL - Sri', '', '3', '2018-12-24', 'yes', '2018-12-25 13:48:31');
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table `user`
63--
64
65CREATE TABLE IF NOT EXISTS `user` (
66 `id` int(11) NOT NULL,
67 `nip_nim` varchar(20) NOT NULL,
68 `nama` varchar(100) NOT NULL,
69 `password` varchar(50) NOT NULL,
70 `status` varchar(20) NOT NULL
71) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
72
73--
74-- Dumping data for table `user`
75--
76
77INSERT INTO `user` (`id`, `nip_nim`, `nama`, `password`, `status`) VALUES
78(1, '1408107010060', 'putra arifah', '3fc0a7acf087f549ac2b266baf94b8b1', 'mahasiswa'),
79(2, '123456789012345', 'OP', '25d55ad283aa400af464c76d713c07ad', 'admin'),
80(3, '141414', 'ade', '827ccb0eea8a706c4c34a16891f84e7b', 'admin'),
81(4, '121212', 'akbar', '827ccb0eea8a706c4c34a16891f84e7b', 'dosen');
82
83--
84-- Indexes for dumped tables
85--
86
87--
88-- Indexes for table `pemesanan`
89--
90ALTER TABLE `pemesanan`
91 ADD PRIMARY KEY (`id`),
92 ADD KEY `ruang_id` (`ruang_id`),
93 ADD KEY `jadwal_id` (`jadwal_id`),
94 ADD KEY `user_id` (`user_id`);
95
96--
97-- Indexes for table `user`
98--
99ALTER TABLE `user`
100 ADD PRIMARY KEY (`id`);
101
102--
103-- AUTO_INCREMENT for dumped tables
104--
105
106--
107-- AUTO_INCREMENT for table `pemesanan`
108--
109ALTER TABLE `pemesanan`
110 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=72;
111--
112-- AUTO_INCREMENT for table `user`
113--
114ALTER TABLE `user`
115 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
116--
117-- Constraints for dumped tables
118--
119
120--
121-- Constraints for table `pemesanan`
122--
123ALTER TABLE `pemesanan`
124
125 ADD CONSTRAINT `pemesanan_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;