· 6 years ago · Sep 22, 2019, 05:50 PM
1- phpMyAdmin SQL Dump
2- version 4.2.7.1
3- http://www.phpmyadmin.net
4-
5- Host: 127.0.0.1
6- Generation Time: May 06, 2015 at 4:32 AM
7- Server version: 5.6.20
8- PHP Version: 5.5.15
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: `ppked`
21-
22
23- ------------------------------------------------ --------
24
25-
26- Table structure for `agenda` tables
27-
28
29CREATE TABLE IF NOT EXISTS `agenda` (
30`id_agenda` int (11) NOT NULL,
31 varchar `title_agenda` (100) NOT NULL,
32 `tgl_agenda` varchar (10) NOT NULL,
33 `tgl_agenda2` varchar (10) NOT NULL
34) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 15;
35
36-
37- Dumping data for the `agenda` table
38-
39
40INSERT INTO `agenda` (` id_agenda`, `title_agenda`,` tgl_agenda`, `tgl_agenda2`) VALUES
41(7, 'Registration of PKD ToT Participants', '01 -05-2015 ', '14 -05-2015'),
42(8, 'Implementation of Regional Expenditure Module PKT ToT', '24 -05-2015 ', '02 -06-2015'),
43(10, 'Implementation of Regional Property Module PKT ToT', '03 -06-2015 ', '13 -06-2015'),
44(11, 'Implementation of Regional Planning and Budgeting PKT ToT Module', '02 -08-2015 ', '12 -08-2015'),
45(12, 'Implementation of Regional Revenue Module PKT ToT', '19 -08-2015 ',' '),
46(13, 'Implementation of PKD ToT Module in Regional Financial Treasury Administration', '30 -08-2015 ', '09 -09-2015'),
47(14, 'Implementation of Regional Financial Accounting Module PKT ToT', '09 -09-2015 ', '20 -09-2015');
48
49- ------------------------------------------------ --------
50
51-
52- Table structure for `reason` table
53-
54
55CREATE TABLE IF NOT EXISTS `reasons` (
56`id_ reason` int (11) NOT NULL,
57 `reason` text NOT NULL,
58 `id_biodata` int (11) NOT NULL,
59 `registration_int` int (11) NOT NULL
60) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
61
62- ------------------------------------------------ --------
63
64-
65- Table structure for `album` table
66-
67
68CREATE TABLE IF NOT EXISTS `album` (
69`id_album` int (11) NOT NULL,
70 varchar_name_album (100) NOT NULL
71) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 2;
72
73-
74- Dumping data for the `album` table
75-
76
77INSERT INTO `album` (` id_album`, `album_name`) VALUES
78(1, 'PKD ToT Batch I - 2015');
79
80- ------------------------------------------------ --------
81
82-
83- Table structure for `alumni` tables
84-
85
86CREATE TABLE IF NOT EXISTS `alumni` (
87`id_alumni` int (11) NOT NULL,
88 `nip` varchar (25) NOT NULL,
89 `alumni_name` varchar (100) NOT NULL,
90 `tmp_lah` varchar (100) NOT NULL,
91 `date_birth` varchar (10) NOT NULL,
92 varchar address (255) NOT NULL,
93 varchar email (100) NOT NULL,
94 `telephone` varchar (15) NOT NULL,
95 `mobile` varchar (15) NOT NULL,
96 varchar (100) NOT NOT NULL,
97 varchar position (100) NOT NULL,
98 `foto` text NOT NULL,
99 varchar username (100) NOT NULL,
100 varchar password (50) NOT NULL
101) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
102
103- ------------------------------------------------ --------
104
105-
106- Table structure for `news` table
107-
108
109CREATE TABLE IF NOT EXISTS `news` (
110`id_berita` int (11) NOT NULL,
111 varchar `title_terms` (255) NOT NULL,
112 `fill_story` text NOT NULL,
113 `tgl_berita` varchar (10) NOT NULL,
114 `pic_berita` text NOT NULL,
115 `writer` varchar (25) NOT NULL
116) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 2;
117
118-
119- Dumping data for `news` tables
120-
121
122INSERT INTO `news` (` news_id`, `news_idit`,` news_fill`, 'news_id`,' news_idit`, 'author') VALUES
123(1, 'Registration of Regional Financial Management ToT', '<p> PPKED FEB Unhas in collaboration with the Directorate General of Fiscal Balance (DJPK) of the Ministry of Finance of the Republic of Indonesia will conduct a Regional Financial Management Training of Trainers which includes: </p> \ r \ n < ol> \ r \ n <li> Regional Planning and Budgeting; </li> \ r \ n <li> Regional Revenue; </li> \ r \ n <li> Regional Expenditures; </li> \ r \ n <li> Regional Property Management; </li> \ r \ n <li> Administration of Regional Financial Treasury; </li> \ r \ n <li> Regional Financial Accounting. </li> \ r \ n </ ol > \ r \ n <p> & nbsp; Which may be followed by local government officials and university lecturers. </p> \ r \ n <p> Registration time is until May 14, 2015. </p> \ r \ n <p > Registration can be done online on the site <a href="?page=Registration"> PPKED FEB Unhas </a> or send & nbsp; <a href="upload/1430879315- PKT ToT Participant Registration Form.docx"> registration form </a> that has been filled in via email to ppkedfebunhas@gmail.com. </p> \ r \ n <p> <img src = "images / upload / 1430809731-dalam --green_001.png" alt = "" width = "100%" /> < / p> ', '05 -05-2015', 'images / news / 1430809553-front-green_001.png', 'Administrator');images / upload / 1430809731-dalam - hijau_001.png "alt =" "width =" 100% "/> </p> ', '05 -05-2015', 'images / news / 1430809553-front-green_001.png ',' Administrator ');images / upload / 1430809731-dalam - hijau_001.png "alt =" "width =" 100% "/> </p> ', '05 -05-2015', 'images / news / 1430809553-front-green_001.png ',' Administrator ');
124
125- ------------------------------------------------ --------
126
127-
128- Table structure for `biodata` table
129-
130
131CREATE TABLE IF NOT EXISTS `biodata` (
132`id_biodata` int (11) NOT NULL,
133 `foto` text NOT NULL,
134 `name` varchar (100) NOT NULL,
135 `nip` varchar (25) NOT NULL,
136 `tmp_lah` varchar (50) NOT NULL,
137 `date_birth` varchar (10) NOT NULL,
138 `religion` varchar (20) NOT NULL,
139 `jk` varchar (10) NOT NULL,
140 varchar address (255) NOT NULL,
141 `tlp_kan` office varchar (15) NOT NULL,
142 `tlp_rumah` varchar (15) NOT NULL,
143 `mobile` varchar (15) NOT NULL,
144 varchar fax (15) NOT NULL,
145 varchar email (100) NOT NULL,
146 varchar status (15) NOT NULL,
147 varchar group (15) NOT NULL,
148 `npwp` varchar (25) NOT NULL,
149 varchar position (200) NOT NULL,
150 varchar agency (200) NOT NULL,
151 `address_instantsi` varchar (255) NOT NULL,
152 varchar level (25) NOT NULL,
153 `province` varchar (50) NOT NULL,
154 `education` varchar (2) NOT NULL,
155 `majors` varchar (100) NOT NULL,
156 `pass` varchar (4) NOT NULL,
157 varchar username (50) NOT NULL,
158 varchar password (50) NOT NULL
159) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
160
161- ------------------------------------------------ --------
162
163-
164- Table structure for `support` tables
165-
166
167CREATE TABLE IF NOT EXISTS `support` (
168`id_man` int (11) NOT NULL,
169 `name` varchar (150) NOT NULL,
170 `nip` varchar (25) NOT NULL,
171 varchar position (200) NOT NULL,
172 `letter` text NOT NULL,
173 `id_biodata` int (11) NOT NULL,
174 `registration_int` int (11) NOT NULL
175) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
176
177- ------------------------------------------------ --------
178
179-
180- Table structure for `photo` table
181-
182
183CREATE TABLE IF NOT EXISTS `photo` (
184`id_photo` int (11) NOT NULL,
185 `id_album` int (11) NOT NULL,
186 `foto` text NOT NULL
187) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 5;
188
189-
190- Dumping data for the `photo` table
191-
192
193INSERT INTO `photo` (` photo_name`, `id_album`,` photo`) VALUES
194(1, 1, 'images / gallery / 1430812394-photos 1.JPG'),
195(2, 1, 'images / gallery / 1430812403-photos 2.JPG'),
196(3, 1, 'images / gallery / 1430812413-photos 3.JPG'),
197(4, 1, 'images / gallery / 1430812423-photos 4.JPG');
198
199- ------------------------------------------------ --------
200
201-
202- Table structure for `picture` table
203-
204
205CREATE TABLE IF NOT EXISTS `picture` (
206`id_image` int (11) NOT NULL,
207 `link_gambar` text NOT NULL
208) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 2;
209
210-
211- Dumping data for the `picture` table
212-
213
214INSERT INTO `images` (` picture_id`, `image_link`) VALUES
215(1, 'images / upload / 1430809731-in - green_001.png');
216
217- ------------------------------------------------ --------
218
219-
220- Table structure for `page` table
221-
222
223CREATE TABLE IF NOT EXISTS `page` (
224`id_page` int (11) NOT NULL,
225 `link_page` text NOT NULL,
226 `title_page` varchar (255) NOT NULL,
227 `fill_page` text NOT NULL
228) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 10;
229
230-
231- Dumping data for `page` table
232-
233
234INSERT INTO `page` (` page_name`, `link_page`,` title_page`, `page_fill`) VALUES
235With the increasing allocation of APBD funds to the regions as a consequence of the implementation of decentralization or regional autonomy, it has become a driving force for the central government and regional governments to continue to improve their ability to manage their finances more professionally and oriented towards good governance. & Nbsp; In this connection, policy reforms in the field of state financial management that require more effective, efficient, transparent and accountable financial management. </p> \ r \ n <p style = "text-align: justify;"> Management reform finance includes aspects of budget formulation, budget execution, administration, accountability and reporting.
236(2, 'About-Us-Vision-Mission', 'VISION & MISSION', '<h4> <strong> Vision </strong> </h4> \ r \ n <p> Becoming the 3rd (Three) Best Education Centers , Research and Floating of Regional Finance and Economy in Indonesia in 2016. </p> \ r \ n <h4> <strong> Mission </strong> </h4> \ r \ n <p> Organizing Activities: </ p > \ r \ n <ol> \ r \ n <li> Education and Training in the field of Regional Financial Management </li> \ r \ n <li> Assessment relating to Regional Financial Management </li> \ r \ n <li > Vocations for developing the quality of Regional Financial Management </li> \ r \ n </ol> '),
237(3, 'About-Us-Structure-Organization', 'ORGANIZATIONAL STRUCTURE', '<p> Organizational Structure of the Center for Regional Financial and Economic Floating. </p>'),
238Alimuddin, & nbsp; Dr.., SE., MM., Ak. </li> \ r \ n <li> Anas Iswanto Anwar, SE., MA. </li> \ r \ n <li> Andi Kusmawati, Dr ., SE., M.Sc., Ak. </li> \ r \ n <li> Arifuddin, Dr., SE., M.Sc., Ak. </li> \ r \ n <li> Asri Usman, Dr. SE., M.Sc., Ak., CA. </li> \ r \ n <li> Bakhtiar Mustari, SE., M.Sc. </li> \ r \ n <li> Darwis Said, & nbsp; Dr., SE., MSA., Ak. </li> \ r \ n <li> Gagaring Pagalung, & nbsp; Prof. Dr., MS., Ak. </li> \ r \ n <li> Grace T. Pontoh, Dr., SE., M.Sc., Ak. </li> \ r \ n <li> Harryanto, Drs., M.Com. PhD. </li> \ r \ n <li> Indraswati Tri Abdireviane, Dr., SE., MA. </li> \ r \ n <li> Jusni, Dr., SE., M.Sc. </ li> \ r \ n <li> Kartini, Dr., SE., M.Sc., Ak. </li> \ r \ n <li> Madris, & nbsp; Dr., SE., DPS., M. Si. </li> \ r \ n <li> Mediaty, Dr., SE., MS., Ak. </li> \ r \ n <li> Muhammad Ali, & nbsp; Prof. Dr., SE., MS. </li> \ r \ n <li> Muhammad Djibril Tajibu, Dr., Ir., SE., M.Sc. </li> \ r \ n <li> Mursalim, Dr. ., SE., M.Sc. </li> \ r \ n <li> Nursini, Dr., SE., M.Sc. </li> \ r \ n <li> Paulus Uppun, Dr., SE ., MA. </li> \ r \ n <li> Grace, & nbsp; Prof. Dr., SE., MA. </li> \ r \ n <li> Ratna Ayu Damayanti, Dr., SE., M.Soc.Sc., Ak. </li> \ r \ n <li> Sabir , Dr., SE., M.Sc. </li> \ r \ n <li> Sanusi Fattah, Dr., SE., M.Sc. </li> \ r \ n <li> Siti Haerani, Prof. . Dr., SE., M.Sc. </li> \ r \ n <li> Sri Undai Nurbayani, Dr., SE., M.Sc. </li> \ r \ n <li> Sultan Suhab, Dr. ., SE., M.Sc. </li> \ r \ n <li> Syamsuddin, Dr., SE., M.Sc., Ak., CA. </li> \ r \ n <li> Syarifuddin , Dr., SE., M.Soc.Sc., Ak. </li> \ r \ n <li>
239(5, 'Service-Training', 'TRAINING', '<ol> \ r \ n <li> <strong> <strong> Regular Training <br /> </strong> </strong> \ r \ n <ul > \ r \ n <li> Regional Planning and Budgeting </li> \ r \ n <li> Local Revenue </li> \ r \ n <li> Regional Expenditure </li> \ r \ n <li> Goods Regional Ownership </li> \ r \ n <li> Regional Administration and Treasury </li> \ r \ n <li> Financial Accounting SKPD and Pemda <br /> <strong> <br /> </strong> </ li> \ r \ n </ul> \ r \ n </li> \ r \ n <li> <strong> <strong> Training of Trainers <br /> </strong> </strong> \ r \ n <ul> \ r \ n <li> Regional Planning and Budgeting </li> \ r \ n <li> Local Revenue </li> \ r \ n <li> Regional Expenditure </li> \ r \ n <li >Regional Property </li> \ r \ n <li> Administration and Regional Treasury </li> \ r \ n <li> SKPD and Local Government Financial Accounting <strong> <br /> <br /> </strong> < / li> \ r \ n </ul> \ r \ n </li> \ r \ n <li style = "text-align: justify;"> <strong> Inhouse Training </strong> </li> \ r \ n </ol> \ r \ n <p> & nbsp; </p> '),
240(6, 'Research-Research', 'RESEARCH', '<ol> \ r \ n <li> <strong> Regional Economy </strong> </li> \ r \ n <li> <strong> Regional Potential < / strong> </li> \ r \ n <li> <strong> Fiscal Decentralization </strong> </li> \ r \ n <li> <strong> Regional Financial Management </strong> </li> \ r \ n <li> <strong> Feasibility Study </strong> </li> \ r \ n </ol> '),
241(7, 'Services-Assistance', 'GUIDE', '<p style = "text-align: justify;"> The contents are the accompanying page of the Center for Regional Financial and Economic Floating. </p> \ r \ n <ol> \ r \ n <li style = "text-align: justify;"> <strong> Drafting the Draft Rules </strong> </li> \ r \ n <li style = "text-align: justify;"> <strong> Compilation Local Government Financial Reports </strong> </li> \ r \ n <li style = "text-align: justify;"> <strong> Preparation of KDH Accountability Reports </strong> </li> \ r \ n <li style = "text-align: justify;"> <strong> Compilation of the Regional Financial Information System </strong> </li> \ r \ n </ol> '),
242(8, 'Overseas Cooperation', 'OVERSEAS', '<ol> \ r \ n <li style = "text-align: justify;"> <strong> AIPD - Australia <br /> </ strong > </li> \ r \ n <li style = "text-align: justify;"> <strong> GIZ - German <br /> </strong> </li> \ r \ n <li style = "text -align: justify; "> <strong> Inwent - Germany </strong> </li> \ r \ n </ol> '),
243(9, 'Domestic Cooperation', 'IN STATE', '<ol> \ r \ n <li style = "text-align: justify;"> <strong> RI MINISTRY OF PEOPLE <br /> </strong> </li> \ r \ n <li style = "text-align: justify;"> <strong> Provincial, Regency and City Local Governments <br /> </strong> </li> \ r \ n </ol> ');
244
245- ------------------------------------------------ --------
246
247-
248- Table structure for `comments` table
249-
250
251CREATE TABLE IF NOT EXISTS `comments` (
252`id_comment` int (11) NOT NULL,
253 `name` varchar (50) NOT NULL,
254 varchar email (200) NOT NULL,
255 varchar website (255) NOT NULL,
256 `comment` text NOT NULL,
257 `id_berita` int (11) NOT NULL,
258 varchar status (6) NOT NULL,
259 `tgl_comentar` varchar (10) NOT NULL
260) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
261
262- ------------------------------------------------ --------
263
264-
265- Table structure for `contact` table
266-
267
268CREATE TABLE IF NOT EXISTS `contact` (
269`id_contact` int (11) NOT NULL,
270 `contact_name` varchar (100) NOT NULL,
271 varchar address (150) NOT NULL,
272 `telephone` varchar (20) NOT NULL,
273 `mobile` varchar (50) NOT NULL
274) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 3;
275
276-
277- Dumping data for `contact` table
278-
279
280INSERT INTO `contact` (` contact_id`, `contact_name`,` address`, `telephone`,` mobile`) VALUES
281(2, '3rd Floor of the Faculty of Economics UNHAS', 'Tamalanrea Campus, Jl. Perintis Kemerdekaan KM 10, Makassar', '0411-587218 / 587583', '082187315132 (Nadia) / 085397273312 (Risma)');
282
283- ------------------------------------------------ --------
284
285-
286- Table structure for `course` tables
287-
288
289CREATE TABLE IF NOT EXISTS `course` (
290`id_kursus` int (11) NOT NULL,
291 varchar `` s_name_course (150) NOT NULL,
292 `year` varchar (4) NOT NULL,
293 `organizer` varchar (100) NOT NULL,
294 `duration` varchar (255) NOT NULL,
295 `id_biodata` int (11) NOT NULL
296) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 2;
297
298-
299- Dumping data for `course` tables
300-
301
302INSERT INTO `course` (` course_name`, `course_name`,` year`, `organizer`,` duration`, `id_biodata`) VALUES
303(1, 'Level IV Leadership Training', '2007', 'Palopo City Training Agency', '17 Days', 1);
304
305- ------------------------------------------------ --------
306
307-
308- Table structure for table `ourse_alumni`
309-
310
311CREATE TABLE IF NOT EXISTS `Course_alumni` (
312`id_kursus` int (11) NOT NULL,
313 `year` varchar (4) NOT NULL,
314 varchar name_name (255) NOT NULL,
315 `id_alumni` int (11) NOT NULL
316) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
317
318- ------------------------------------------------ --------
319
320-
321- Table structure for `links` table
322-
323
324CREATE TABLE IF NOT EXISTS `links` (
325`id_link` int (11) NOT NULL,
326 `link__name` varchar (100) NOT NULL,
327 `link` text NOT NULL
328) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 4;
329
330-
331- Dumping data for the `links` table
332-
333
334INSERT INTO `links` (` id_link`, `link_name`,` link`) VALUES
335(1, 'Hasanuddin University', 'http://unhas.ac.id/'),
336(2, 'Faculty of Economics Unhas', 'http://www.unhas.ac.id/fekon/'),
337(3, 'Directorate of Fiscal Balance Jendaral', 'http://www.djpk.kemenkeu.go.id/');
338
339- ------------------------------------------------ --------
340
341-
342- Table structure for `menu` tables
343-
344
345CREATE TABLE IF NOT EXISTS `menu` (
346`id_menu` int (11) NOT NULL,
347 `name_menu` varchar (20) NOT NULL,
348 `child` varchar (4) NOT NULL,
349 `link_menu` text NOT NULL,
350 `type` varchar (7) NOT NULL
351) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 11;
352
353-
354- Dumping data for the `menu` table
355-
356
357INSERT INTO `menu` (` id_menu`, `menu_name`,` child`, `link_menu`,` type`) VALUES
358(1, 'HOME', 'No', 'Home', 'Static'),
359(2, 'ABOUT US', 'Yes', 'About-Us', 'Dynamic'),
360(3, 'SERVICE', 'Yes', 'Service', 'Dynamic'),
361(4, 'COOPERATION', 'Yes', 'Cooperation', 'Dynamic'),
362(5, 'AGENDA & NEWS', 'No', 'News-Agenda', 'Static'),
363(6, 'PHOTO', 'No', 'Photo', 'Static'),
364(7, 'DOWNLOAD', 'No', 'Download', 'Dynamic'),
365(8, 'REGISTRATION', 'No', 'Registration', 'Static'),
366(9, 'ALUMNI', 'No', 'Alumni', 'Static'),
367(10, 'CONTACT US', 'No', 'Contact-Us', 'Static');
368
369- ------------------------------------------------ --------
370
371-
372- Table structure for `module` table
373-
374
375CREATE TABLE IF NOT EXISTS `module` (
376`id_modul` int (11) NOT NULL,
377 `vodar_name_name` (255) NOT NULL
378) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 7;
379
380-
381- Dumping data for `modules` table
382-
383
384INSERT INTO `module` (` module_id`, `module_name`) VALUES
385(1, 'Regional Planning and Budgeting'),
386(2, 'Local Revenue'),
387(3, 'Regional Shopping'),
388(4, 'Regional Property'),
389(5, 'Administration of Regional Treasury'),
390(6, 'SKPD and Local Government Financial Accounting');
391
392- ------------------------------------------------ --------
393
394-
395- Table structure for `online` tables
396-
397
398CREATE TABLE IF NOT EXISTS `online` (
399`id_online` int (11) NOT NULL,
400 `media_online` varchar (20) NOT NULL,
401 `link_online` text NOT NULL,
402 `logo_online` text NOT NULL
403) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 5;
404
405-
406- Dumping data for `online` tables
407-
408
409INSERT INTO `online` (` id_online`, `media_online`,` link_online`, `logo_online`) VALUES
410(1, 'Email', 'ppkedfebunhas@gmail.com', ''),
411(2, 'Facebook', 'https://www.facebook.com/', 'images / fb.png'),
412(3, 'Twitter', 'https://www.twitter.com/', 'images / twitter.png'),
413(4, 'Youtube', 'https://www.youtube.com/', 'images / youtube.png');
414
415- ------------------------------------------------ --------
416
417-
418- Table structure for `registries` tables
419-
420
421CREATE TABLE IF NOT EXISTS `registrant` (
422`register_id` int (11) NOT NULL,
423 `id_biodata` int (11) NOT NULL,
424 `registration_int` int (11) NOT NULL
425) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
426
427- ------------------------------------------------ --------
428
429-
430- Table structure for `registration` table
431-
432
433CREATE TABLE IF NOT EXISTS `registration` (
434`registration_int` int (11) NOT NULL,
435 `year` varchar (4) NOT NULL,
436 varchar force (3) NOT NULL,
437 `start_date` varchar (10) NOT NULL,
438 `completion_varch` (10) NOT NULL,
439 varchar status (5) NOT NULL
440) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 2;
441
442-
443- Dumping data for the `registration` table
444-
445
446INSERT INTO `registration` (` registration_id`, `year`,` force`, `start_date`,` date_ completion`, `status`) VALUES
447(1, '2015', 'II', '01 -05-2015 ', '14 -05-2015', 'Open');
448
449- ------------------------------------------------ --------
450
451-
452- Table structure for `experience 'tables
453-
454
455CREATE TABLE IF NOT EXISTS `experience` (
456`experience_int` int (11) NOT NULL,
457 `teach` varchar (100) NOT NULL,
458 `year` varchar (4) NOT NULL,
459 `description` text NOT NULL,
460 `id_biodata` int (11) NOT NULL
461) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
462
463- ------------------------------------------------ --------
464
465-
466- Table structure for `priority` tables
467-
468
469CREATE TABLE IF NOT EXISTS `priority` (
470`id_prioritas` int (11) NOT NULL,
471 `id_modul` int (11) NOT NULL,
472 `priority` int (2) NOT NULL,
473 `id_biodata` int (11) NOT NULL,
474 `registration_int` int (11) NOT NULL
475) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
476
477- ------------------------------------------------ --------
478
479-
480- Table structure for `history` table
481-
482
483CREATE TABLE IF NOT EXISTS `history` (
484`id_domain` int (11) NOT NULL,
485 varchar position (150) NOT NULL,
486 `year` varchar (4) NOT NULL,
487 `description` text NOT NULL,
488 `id_biodata` int (11) NOT NULL
489) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 1;
490
491- ------------------------------------------------ --------
492
493-
494- Table structure for `submenu` tables
495-
496
497CREATE TABLE IF NOT EXISTS `submenu` (
498`id_submenu` int (11) NOT NULL,
499 `name_menu` varchar (20) NOT NULL,
500 `sub_name_name` varchar (25) NOT NULL,
501 `link_submenu` text NOT NULL,
502 varchar link (255) NOT NULL
503) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 10;
504
505-
506- Dumping data for the `submenu` table
507-
508
509INSERT INTO `submenu` (` id_submenu`, `nama_menu`,` submenu_name`, `link_submenu`,` link`) VALUES
510(1, 'ABOUT US', 'HISTORY', 'About-Us-History', 'History'),
511(2, 'ABOUT US', 'VISION & MISSION', 'About-Us-Vision-Mission', 'Vision-Mission'),
512(3, 'ABOUT US', 'ORGANIZATIONAL STRUCTURE', 'About-Us-Organizational-Structure', 'Organizational-Structure'),
513(4, 'ABOUT US', 'SDM', 'About-Us-SDM', 'SDM'),
514(5, 'SERVICE', 'TRAINING', 'Service-Training', 'Training'),
515(6, 'SERVICE', 'RESEARCH', 'Research-Service', 'Research'),
516(7, 'SERVICE', 'GUIDE', 'Services-Assistance', 'Assistance'),
517(8, 'COOPERATION', 'OVERSEAS', 'Overseas Cooperation', 'Overseas Cooperation'),
518(9, 'COOPERATION', 'IN STATE', 'Domestic Co-operation', 'Domestic Co-operation');
519
520- ------------------------------------------------ --------
521
522-
523- Table structure for `upload` table
524-
525
526CREATE TABLE IF NOT EXISTS `upload` (
527`id_upload` int (11) NOT NULL,
528 varchar filename (255) NOT NULL,
529 `link_file` text NOT NULL,
530 `directory` text NOT NULL
531) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 3;
532
533-
534- Dumping data for the `upload` table
535-
536
537INSERT INTO `upload` (` id_upload`, `filename`,` link_file`, `directory`) VALUES
538(1, 'PKD.docx Participant Registration Form', '', 'upload / 1430879315-PKD.docx Participant Registration Form'),
539(2, 'PKD.docx Participant Registration Form', 'Download', 'upload / 1430879393-PKD.docx Participant Registration Form');
540
541- ------------------------------------------------ --------
542
543-
544- Table structure for `users` table
545-
546
547CREATE TABLE IF NOT EXISTS `users` (
548`id_user` int (11) NOT NULL,
549 `username_user` varchar (25) NOT NULL,
550 `username` varchar (20) NOT NULL,
551 varchar password (50) NOT NULL,
552 varchar level (10) NOT NULL
553) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 5;
554
555-
556- Dumping data for the `users` table
557-
558
559INSERT INTO `users` (` id_user`, `username_user`,` username`, `password`,` level`) VALUES
560(1, 'Administrator', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Admin'),
561(4, 'Zhamry Jr.', 'soe', '0ed1c6558eb04ee47cdbac4f383ea17d', 'Editor');
562
563- ------------------------------------------------ --------
564
565-
566- Table structure for `visitor` table
567-
568
569CREATE TABLE IF NOT EXISTS `visitor` (
570`id_visitor` int (11) NOT NULL,
571 `date_visit` date is NOT NULL,
572 `ip_address` text NOT NULL,
573 `time` int (11) NOT NULL
574) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 34;
575
576-
577- Dumping data for `visitor` table
578-
579
580INSERT INTO `visitor` (` id_visitor`, `tgl_visit`,` ip_address`, `time`) VALUES
581(1, '2015-03-29', ':: 1', 1427634219),
582(2, '2015-03-31', ':: 1', 1427817553),
583(3, '2015-04-01', ':: 1', 1427897763),
584(4, '2015-04-02', ':: 1', 1427980024),
585(5, '2015-04-03', ':: 1', 1428005434),
586(6, '2015-04-04', ':: 1', 1428117560),
587(7, '2015-04-05', ':: 1', 1428249547),
588(8, '2015-04-06', ':: 1', 1428308151),
589(9, '2015-04-07', ':: 1', 1428422327),
590(10, '2015-04-08', ':: 1', 1428497695),
591(11, '2015-04-09', ':: 1', 1428582818),
592(12, '2015-04-10', ':: 1', 1428677784),
593(13, '2015-04-11', ':: 1', 1428733414),
594(14, '2015-04-13', ':: 1', 1428928026),
595(15, '2015-04-14', ':: 1', 1429022517),
596(16, '2015-04-15', ':: 1', 1429113512),
597(17, '2015-04-16', ':: 1', 1429160229),
598(18, '2015-04-17', ':: 1', 1429273341),
599(19, '2015-04-18', ':: 1', 1429372040),
600(20, '2015-04-21', ':: 1', 1429598784),
601(21, '2015-04-22', ':: 1', 1429715742),
602(22, '2015-04-23', ':: 1', 1429798067),
603(23, '2015-04-24', ':: 1', 1429863589),
604(24, '2015-04-25', ':: 1', 1429967624),
605(25, '2015-04-26', ':: 1', 1430052677),
606(26, '2015-04-26', '192.168.43.1', 1430037367),
607(27, '2015-04-27', ':: 1', 1430142457),
608(28, '2015-04-27', '192.168.43.1', 1430141607),
609(29, '2015-04-28', ':: 1', 1430205248),
610(30, '2015-04-29', ':: 1', 1430292184),
611(31, '2015-05-04', ':: 1', 1430736074),
612(32, '2015-05-05', ':: 1', 1430812525),
613(33, '2015-05-06', ':: 1', 1430878918);
614
615-
616- Indexes for dumped tables
617-
618
619-
620- Indexes for the `agenda` table
621-
622ALTER TABLE `agenda`
623 ADD PRIMARY KEY (`id_agenda`);
624
625-
626- Indexes for table `reasons`
627-
628ALTER TABLE `reasons`
629 ADD PRIMARY KEY (`reasoning`);
630
631-
632- Indexes for the `album` table
633-
634ALTER TABLE `album`
635 ADD PRIMARY KEY (`id_album`);
636
637-
638- Indexes for the `alumni` table
639-
640ALTER TABLE `alumni`
641 ADD PRIMARY KEY (`id_alumni`);
642
643-
644- Indexes for the `news` table
645-
646ALTER TABLE `news`
647 ADD PRIMARY KEY (`news_id`);
648
649-
650- Indexes for table `biodata`
651-
652ALTER TABLE `biodata`
653 ADD PRIMARY KEY (`id_biodata`);
654
655-
656- Indexes for table `support`
657-
658ALTER TABLE `support`
659 ADD PRIMARY KEY (`leader_id`);
660
661-
662- Indexes for the `photo` table
663-
664ALTER TABLE `photo`
665 ADD PRIMARY KEY (`photo_id`);
666
667-
668- Indexes for the `picture` table
669-
670ALTER TABLE `image`
671 ADD PRIMARY KEY (`image_id`);
672
673-
674- Indexes for the `page` table
675-
676ALTER TABLE `page`
677 ADD PRIMARY KEY (`id_page`);
678
679-
680- Indexes for the `comments` table
681-
682ALTER TABLE `comments`
683 ADD PRIMARY KEY (`comment_id`);
684
685-
686- Indexes for the `contact` table
687-
688ALTER TABLE `contact`
689 ADD PRIMARY KEY (`contact_id`);
690
691-
692- Indexes for `course` table
693-
694ALTER TABLE `course`
695 ADD PRIMARY KEY (`id_course ');
696
697-
698- Indexes for table `ourse_alumni`
699-
700ALTER TABLE `Course_alumni`
701 ADD PRIMARY KEY (`id_course ');
702
703-
704- Indexes for the `links` table
705-
706ALTER TABLE `links`
707 ADD PRIMARY KEY (`id_link`);
708
709-
710- Indexes for table `menu`
711-
712ALTER TABLE `menu`
713 ADD PRIMARY KEY (`id_menu`);
714
715-
716- Indexes for table `modules`
717-
718ALTER TABLE `module`
719 ADD PRIMARY KEY (`module_id`);
720
721-
722- Indexes for table `online`
723-
724ALTER TABLE is online
725 ADD PRIMARY KEY (`id_online`);
726
727-
728- Indexes for the `registries` table
729-
730ALTER TABLE `registrant`
731 ADD PRIMARY KEY (`register_id`);
732
733-
734- Indexes for the `registration` table
735-
736ALTER TABLE `registration`
737 ADD PRIMARY KEY (`registration_id`);
738
739-
740- Indexes for the `experience` table
741-
742ALTER TABLE `experience`
743 ADD PRIMARY KEY (`experience_id`);
744
745-
746- Indexes for table `priority`
747-
748ALTER TABLE `priority`
749 ADD PRIMARY KEY (`priority_id`);
750
751-
752- Indexes for the `history` table
753-
754ALTER TABLE `history`
755 ADD PRIMARY KEY (`history_id`);
756
757-
758- Indexes for table `submenu`
759-
760ALTER TABLE `submenu`
761 ADD PRIMARY KEY (`id_submenu`);
762
763-
764- Indexes for the `upload` table
765-
766ALTER TABLE `upload`
767 ADD PRIMARY KEY (`id_upload`);
768
769-
770- Indexes for the `users` table
771-
772ALTER TABLE `users`
773 ADD PRIMARY KEY (`id_user`), ADD UNIQUE KEY` username` (`username`);
774
775-
776- Indexes for the `visitor` table
777-
778ALTER TABLE `visitor`
779 ADD PRIMARY KEY (`id_visitor`);
780
781-
782- AUTO_INCREMENT for dumped tables
783-
784
785-
786- AUTO_INCREMENT for `agenda` table
787-
788ALTER TABLE `agenda`
789MODIFY `id_agenda` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 15;
790-
791- AUTO_INCREMENT for `reason` table
792-
793ALTER TABLE `reasons`
794MODIFY `id_alasan` int (11) NOT NULL AUTO_INCREMENT;
795-
796- AUTO_INCREMENT for `album` table
797-
798ALTER TABLE `album`
799MODIFY `id_album` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 2;
800-
801- AUTO_INCREMENT for `alumni` table
802-
803ALTER TABLE `alumni`
804MODIFY `id_alumni` int (11) NOT NULL AUTO_INCREMENT;
805-
806- AUTO_INCREMENT for `news` table
807-
808ALTER TABLE `news`
809MODIFY `id_berita` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 2;
810-
811- AUTO_INCREMENT for `biodata` table
812-
813ALTER TABLE `biodata`
814MODIFY `id_biodata` int (11) NOT NULL AUTO_INCREMENT;
815-
816- AUTO_INCREMENT for `support` table
817-
818ALTER TABLE `support`
819MODIFY `id_man` int (11) NOT NULL AUTO_INCREMENT;
820-
821- AUTO_INCREMENT for `photo` table
822-
823ALTER TABLE `photo`
824MODIFY `id_foto` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 5;
825-
826- AUTO_INCREMENT for `pictures` table
827-
828ALTER TABLE `image`
829MODIFY `id_gambar` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 2;
830-
831- AUTO_INCREMENT for `pages` table
832-
833ALTER TABLE `page`
834MODIFY `id_page` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 10;
835-
836- AUTO_INCREMENT for the `comments` table
837-
838ALTER TABLE `comments`
839MODIFY `id_comentar` int (11) NOT NULL AUTO_INCREMENT;
840-
841- AUTO_INCREMENT for `contact` table
842-
843ALTER TABLE `contact`
844MODIFY `id_contact` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 3;
845-
846- AUTO_INCREMENT for `courses` table
847-
848ALTER TABLE `course`
849MODIFY `id_kursus` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 2;
850-
851- AUTO_INCREMENT for `ourse_alumni` table
852-
853ALTER TABLE `Course_alumni`
854MODIFY `id_kursus` int (11) NOT NULL AUTO_INCREMENT;
855-
856- AUTO_INCREMENT for `links` table
857-
858ALTER TABLE `links`
859MODIFY `id_link` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 4;
860-
861- AUTO_INCREMENT for `menu` table
862-
863ALTER TABLE `menu`
864MODIFY `id_menu` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 11;
865-
866- AUTO_INCREMENT for `modules` table
867-
868ALTER TABLE `module`
869MODIFY `id_modul` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 7;
870-
871- AUTO_INCREMENT for `online` table
872-
873ALTER TABLE is online
874MODIFY `id_online` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 5;
875-
876- AUTO_INCREMENT for `registrants' table
877-
878ALTER TABLE `registrant`
879MODIFY `register_eng` int (11) NOT NULL AUTO_INCREMENT;
880-
881- AUTO_INCREMENT for `registration` table
882-
883ALTER TABLE `registration`
884MODIFY `registration_int` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 2;
885-
886- AUTO_INCREMENT for `experience` table
887-
888ALTER TABLE `experience`
889MODIFY `id_experience` int (11) NOT NULL AUTO_INCREMENT;
890-
891- AUTO_INCREMENT for `priority` table
892-
893ALTER TABLE `priority`
894MODIFY `id_prioritas` int (11) NOT NULL AUTO_INCREMENT;
895-
896- AUTO_INCREMENT for `history` table
897-
898ALTER TABLE `history`
899MODIFY `id_riistory` int (11) NOT NULL AUTO_INCREMENT;
900-
901- AUTO_INCREMENT for `submenu` table
902-
903ALTER TABLE `submenu`
904MODIFY `id_submenu` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 10;
905-
906- AUTO_INCREMENT for `upload` table
907-
908ALTER TABLE `upload`
909MODIFY `id_upload` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 3;
910-
911- AUTO_INCREMENT for `users` table
912-
913ALTER TABLE `users`
914MODIFY `id_user` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 5;
915-
916- AUTO_INCREMENT for `visitor` table
917-
918ALTER TABLE `visitor`
919MODIFY `id_visitor` int (11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 34;
920/ *! 40101 SET CHARACTER_SET_CLIENT = @ OLD_CHARACTER_SET_CLIENT * /;
921/ *! 40101 SET CHARACTER_SET_RESULTS = @ OLD_CHARACTER_SET_RESULTS * /;
922/ *! 40101 SET COLLATION_CONNECTION = @ OLD_COLLATION_CONNECTION * /;