· 11 years ago · Mar 15, 2015, 07:36 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.4
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Mar 15, 2015 at 08:34 AM
7-- Server version: 5.5.32
8-- PHP Version: 5.4.16
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `dbacademy`
21--
22CREATE DATABASE IF NOT EXISTS `dbacademy` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `dbacademy`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `majors`
29--
30
31CREATE TABLE IF NOT EXISTS `majors` (
32 `id` int(11) NOT NULL AUTO_INCREMENT,
33 `name` varchar(100) NOT NULL,
34 `created` datetime NOT NULL,
35 `modfied` datetime NOT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
38
39--
40-- Dumping data for table `majors`
41--
42
43INSERT INTO `majors` (`id`, `name`, `created`, `modfied`) VALUES
44(3, 'Sistem Informasi', '2015-03-14 06:09:00', '2015-03-14 06:09:00'),
45(4, 'Teknik Informatika', '2015-03-14 06:09:00', '2015-03-14 06:09:00');
46
47-- --------------------------------------------------------
48
49--
50-- Table structure for table `students`
51--
52
53CREATE TABLE IF NOT EXISTS `students` (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `nama` varchar(100) NOT NULL,
56 `tanggal_lahir` date NOT NULL,
57 `jk` enum('L','P') NOT NULL,
58 `alamat` text NOT NULL,
59 `agama` varchar(20) NOT NULL,
60 `phone` varchar(20) NOT NULL,
61 `email` varchar(255) NOT NULL,
62 `picture` varchar(255) NOT NULL,
63 `angkatan` int(11) NOT NULL,
64 `major_id` int(11) NOT NULL,
65 `created` datetime NOT NULL,
66 `modified` datetime NOT NULL,
67 `status` enum('unregister','aktif','alumni','cuti') NOT NULL,
68 PRIMARY KEY (`id`)
69) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1503002 ;
70
71--
72-- Dumping data for table `students`
73--
74
75INSERT INTO `students` (`id`, `nama`, `tanggal_lahir`, `jk`, `alamat`, `agama`, `phone`, `email`, `picture`, `angkatan`, `major_id`, `created`, `modified`, `status`) VALUES
76(1503001, 'Cunai', '2015-03-14', 'L', 'bojongge', 'Islam', '08239823992', 'yanuar@gmail.com', '-YanzGetes.JPG', 2015, 3, '2015-03-14 20:27:47', '2015-03-14 20:39:39', 'unregister');
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `studies`
82--
83
84CREATE TABLE IF NOT EXISTS `studies` (
85 `id` varchar(15) NOT NULL,
86 `nama_matkul` varchar(100) NOT NULL,
87 `semester` int(11) NOT NULL,
88 `jumlah_sks` int(11) NOT NULL,
89 `created` datetime NOT NULL,
90 `modified` datetime NOT NULL,
91 `status` enum('enabled','disabled') NOT NULL,
92 PRIMARY KEY (`id`)
93) ENGINE=InnoDB DEFAULT CHARSET=latin1;
94
95--
96-- Dumping data for table `studies`
97--
98
99INSERT INTO `studies` (`id`, `nama_matkul`, `semester`, `jumlah_sks`, `created`, `modified`, `status`) VALUES
100('MK00001', 'Corporate Portal', 5, 3, '2015-03-15 01:08:39', '2015-03-15 13:59:40', 'enabled'),
101('MK00002', 'Computing Economic', 5, 3, '2015-03-15 10:03:16', '2015-03-15 14:00:48', 'enabled');
102
103-- --------------------------------------------------------
104
105--
106-- Table structure for table `studies_preconditions`
107--
108
109CREATE TABLE IF NOT EXISTS `studies_preconditions` (
110 `precondition_id` varchar(15) NOT NULL,
111 `study_id` varchar(15) NOT NULL
112) ENGINE=InnoDB DEFAULT CHARSET=latin1;
113
114--
115-- Dumping data for table `studies_preconditions`
116--
117
118INSERT INTO `studies_preconditions` (`precondition_id`, `study_id`) VALUES
119('MK00001', 'MK00002');
120
121-- --------------------------------------------------------
122
123--
124-- Table structure for table `teachers`
125--
126
127CREATE TABLE IF NOT EXISTS `teachers` (
128 `id` varchar(15) NOT NULL,
129 `nama` varchar(100) NOT NULL,
130 `tanggal_lahir` date NOT NULL,
131 `jk` enum('L','P') NOT NULL,
132 `alamat` text NOT NULL,
133 `agama` varchar(20) NOT NULL,
134 `phone` varchar(20) NOT NULL,
135 `email` varchar(255) NOT NULL,
136 `picture` varchar(255) NOT NULL,
137 `created` datetime NOT NULL,
138 `modified` datetime NOT NULL,
139 `status` enum('tetap','tidak tetap','aktif','non aktif') NOT NULL,
140 PRIMARY KEY (`id`)
141) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142
143--
144-- Dumping data for table `teachers`
145--
146
147INSERT INTO `teachers` (`id`, `nama`, `tanggal_lahir`, `jk`, `alamat`, `agama`, `phone`, `email`, `picture`, `created`, `modified`, `status`) VALUES
148('DS00001', 'Jancuk', '2015-03-15', 'L', 'Bojonggede', 'Islam', '082984982', 'dosen@gmail.com', '168957_191307260894342_6362842_n.jpg', '2015-03-15 00:31:16', '2015-03-15 00:31:16', 'tetap');
149
150-- --------------------------------------------------------
151
152--
153-- Table structure for table `teachers_studies`
154--
155
156CREATE TABLE IF NOT EXISTS `teachers_studies` (
157 `teacher_id` varchar(15) NOT NULL,
158 `study_id` varchar(15) NOT NULL
159) ENGINE=InnoDB DEFAULT CHARSET=latin1;
160
161-- --------------------------------------------------------
162
163--
164-- Table structure for table `users`
165--
166
167CREATE TABLE IF NOT EXISTS `users` (
168 `id` int(11) NOT NULL AUTO_INCREMENT,
169 `username` varchar(16) NOT NULL,
170 `password` varchar(255) NOT NULL,
171 `display_name` varchar(64) DEFAULT NULL,
172 `email` varchar(64) NOT NULL,
173 `phone` varchar(20) NOT NULL,
174 `bio` varchar(160) DEFAULT NULL,
175 `gender` enum('M','F') NOT NULL DEFAULT 'M',
176 `birthdate` date DEFAULT NULL,
177 `address` varchar(160) DEFAULT NULL,
178 `city` varchar(64) DEFAULT NULL,
179 `postal_code` int(11) DEFAULT '0',
180 `url_facebook` varchar(64) DEFAULT NULL,
181 `url_twitter` varchar(64) DEFAULT NULL,
182 `url_youtube` varchar(64) DEFAULT NULL,
183 `url_linkedin` varchar(64) DEFAULT NULL,
184 `url_pinterest` varchar(64) DEFAULT NULL,
185 `url_instagram` varchar(64) DEFAULT NULL,
186 `picture_dir` varchar(255) NOT NULL DEFAULT 'default',
187 `picture` varchar(255) NOT NULL DEFAULT 'default.jpg',
188 `activation_key` varchar(255) DEFAULT NULL,
189 `role` enum('administrator','contributor','user') NOT NULL DEFAULT 'user',
190 `created` datetime DEFAULT NULL,
191 `modified` datetime DEFAULT NULL,
192 `status` tinyint(4) NOT NULL DEFAULT '0',
193 PRIMARY KEY (`id`),
194 UNIQUE KEY `username` (`username`)
195) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
196
197--
198-- Dumping data for table `users`
199--
200
201INSERT INTO `users` (`id`, `username`, `password`, `display_name`, `email`, `phone`, `bio`, `gender`, `birthdate`, `address`, `city`, `postal_code`, `url_facebook`, `url_twitter`, `url_youtube`, `url_linkedin`, `url_pinterest`, `url_instagram`, `picture_dir`, `picture`, `activation_key`, `role`, `created`, `modified`, `status`) VALUES
202(1, 'administrator', 'ed4511c5fec2a42435e6746f30fc53a3c64df43c', 'Yanuar Nurcahyo', 'yanuar.nurcahyo6661@gmail.com', '', '', 'M', NULL, '', '', 16320, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'default.jpg', NULL, 'administrator', '2014-07-16 00:00:00', '2014-07-23 20:38:43', 0),
203(2, 'fina', 'ed4511c5fec2a42435e6746f30fc53a3c64df43c', 'Fina Alis', 'fina@gmail.com', '', '', 'F', '2014-07-23', '', 'Bogor', 14320, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1613765_1426376610935434_1576759072_n.jpg', '53cfe091-1bd4-4cf3-83c7-1768c16639e9', 'user', '2014-07-23 23:19:29', '2014-07-23 23:19:29', 0),
204(3, 'agus', 'ed4511c5fec2a42435e6746f30fc53a3c64df43c', 'Agus Hadiyatna', 'agus@gmail.com', '', '', 'M', '1985-08-22', 'Jl. Cibinong', 'Bogor', 16430, NULL, NULL, NULL, NULL, NULL, NULL, '3', 'ias.jpg', '53df95ac-99d0-48f6-854b-1a3cc16639e9', 'contributor', '2014-08-04 21:16:13', '2014-08-04 21:19:56', 0),
205(4, 'admin', '4bdccffffb56b487a1f122e94d41540c4e55a619', 'Administrator', 'admin@admin.com', '08561982498249', '', 'M', '0000-00-00', 'asd', 'k;', 211222, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'Untitled.jpg', '54dee496-25ac-45af-a3dd-0820246c5b52', 'administrator', '2015-02-14 07:00:54', '2015-03-11 19:36:51', 0);
206
207/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
208/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
209/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;