-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 15, 2023 at 01:09 PM -- Server version: 10.4.11-MariaDB -- PHP Version: 7.2.31 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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 */; -- -- Database: `ujianonline` -- -- -------------------------------------------------------- -- -- Table structure for table `cbt_jawaban` -- CREATE TABLE `cbt_jawaban` ( `jawaban_id` bigint(20) UNSIGNED NOT NULL, `jawaban_soal_id` bigint(20) UNSIGNED NOT NULL, `jawaban_detail` text COLLATE utf8_unicode_ci NOT NULL, `jawaban_benar` tinyint(1) NOT NULL DEFAULT 0, `jawaban_aktif` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_jawaban` -- INSERT INTO `cbt_jawaban` (`jawaban_id`, `jawaban_soal_id`, `jawaban_detail`, `jawaban_benar`, `jawaban_aktif`) VALUES (186, 57, '

1 Syawal

\r\n', 1, 1), (187, 57, '

1 Agustus

', 0, 1), (188, 57, '

1 Januari

', 0, 1), (189, 57, '

1 Desember

', 0, 1), (190, 57, '

14 Februari

', 0, 1), (191, 56, '

Nazril Irham

', 1, 1), (192, 56, '

Joko Susilo

', 0, 1), (193, 56, '

Wahyu Saputra

\r\n', 0, 1), (194, 56, '

Aril Piterpen

', 0, 1), (195, 56, 'Joko Wow', 0, 1), (196, 55, '

Soekarno

', 1, 1), (197, 55, '

Soeharto

\r\n', 0, 1), (198, 55, '

Susilo Bambang Yudhoyono

\r\n', 0, 1), (199, 55, '

BJ. Habibie

\r\n', 0, 1), (200, 55, '

Joko Widodo

\r\n', 0, 1), (201, 54, '

Sun East Mall

', 1, 1), (202, 54, '

Matahari

', 0, 1), (203, 54, '

Bulan

', 0, 1), (204, 54, '

Tanah Abang

', 0, 1), (205, 54, '

Tanah Lempong

', 0, 1), (206, 53, '

Sekolah Menengah Kejuruan

', 1, 1), (207, 53, '

Sekolah Menengah Kejujuran

', 0, 1), (208, 53, '

Sekolah Maju Sendiri

', 0, 1), (209, 53, '

Sekolah Mak Ku

', 0, 1), (210, 53, '

Sekolah Memilih Kekasih

', 0, 1), (211, 64, 'Akhirnya aku menemukanmu', 1, 1), (212, 64, 'Akhir dirimu', 0, 1), (213, 64, 'Susahnya jadi dia', 0, 1), (214, 64, 'Jones', 0, 1), (215, 64, 'Josan - Jomblo Pas Pasan', 0, 1), (621, 161, '

Aksi bela Jomblo

\r\n', 1, 1), (622, 161, '

Aksi bela cewek

\r\n', 0, 1), (623, 161, '

14 Februari

\r\n', 0, 1), (624, 161, '

Hari Valentine

\r\n', 0, 1), (625, 161, '

Turun ke jalan

\r\n', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `cbt_konfigurasi` -- CREATE TABLE `cbt_konfigurasi` ( `konfigurasi_id` int(11) NOT NULL, `konfigurasi_kode` varchar(50) NOT NULL, `konfigurasi_isi` varchar(500) NOT NULL, `konfigurasi_keterangan` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cbt_konfigurasi` -- INSERT INTO `cbt_konfigurasi` (`konfigurasi_id`, `konfigurasi_kode`, `konfigurasi_isi`, `konfigurasi_keterangan`) VALUES (1, 'link_login_operator', 'ya', 'Menampilkan Link Login Operator'), (2, 'cbt_nama', 'Computer Based-Test', 'Nama Penyelenggara ZYACBT'), (3, 'cbt_keterangan', 'Ujian Online Berbasis Komputer', 'Keterangan Penyelenggara ZYACBT'), (4, 'cbt_mobile_lock_xambro', 'tidak', 'Melakukan Lock pada browser mobile agar menggunakan Xambro Saja'), (5, 'cbt_informasi', '

Silahkan pilih Tes yang diikuti dari daftar tes yang tersedia dibawah ini. Apabila tes tidak muncul, silahkan menghubungi Operator yang bertugas.

\r\n', 'Informasi yang diberika di Dashboard peserta tes\''); -- -------------------------------------------------------- -- -- Table structure for table `cbt_modul` -- CREATE TABLE `cbt_modul` ( `modul_id` bigint(20) UNSIGNED NOT NULL, `modul_nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `modul_aktif` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_modul` -- INSERT INTO `cbt_modul` (`modul_id`, `modul_nama`, `modul_aktif`) VALUES (9, 'Default', 1); -- -------------------------------------------------------- -- -- Table structure for table `cbt_sessions` -- CREATE TABLE `cbt_sessions` ( `id` varchar(128) NOT NULL, `ip_address` varchar(45) NOT NULL, `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0, `data` blob NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `cbt_sessions` -- INSERT INTO `cbt_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('1bl9rt0j69ub0lrcvptp9jv93rp8mlma', '::1', 1644459044, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343435393034333b), ('3p29jbime34jis7a5em13qm2epfq90na', '::1', 1599377882, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393337373634313b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('407kmuvok6a01i09j8rg7p5i1ivltps5', '::1', 1644459043, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343435393034333b), ('49vtfbptg1ruremgul4j1ivkej54ofvp', '127.0.0.1', 1604183402, 0x5f5f63695f6c6173745f726567656e65726174657c693a313630343138333337353b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('7e742n3jq70q4g577qpfdth4fdk4j02p', '127.0.0.1', 1604182994, 0x5f5f63695f6c6173745f726567656e65726174657c693a313630343138323939343b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('8pcnsa8ojtp08a04kaojglv011u1p9vp', '::1', 1599379422, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393337393134313b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('ace5hlacs61k06r3bhl6dgb2kvjmkset', '::1', 1599379011, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393337383732303b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('alu2de14sll20rb2druvb7e3anth2bqf', '::1', 1644457890, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343435373839303b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('b8ls2vctk6rsjiiuvpv1pq9apvmb5bos', '::1', 1599381132, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393338313031383b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b6362745f7465735f757365725f69647c733a353a226c75746669223b6362745f7465735f6e616d617c733a32323a224d7568616d6d6164204c75746669616c2048616b696d223b6362745f7465735f67726f75707c733a353a225849204d4d223b6362745f7465735f67726f75705f69647c733a313a2235223b), ('bbtk0oq94r7dnqkcitjidi135e2n7jet', '::1', 1599380892, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393338303633363b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b6362745f7465735f757365725f69647c733a343a226a6f6b6f223b6362745f7465735f6e616d617c733a31323a224a6f6b6f20537573616e746f223b6362745f7465735f67726f75707c733a353a225849204d4d223b6362745f7465735f67726f75705f69647c733a313a2235223b), ('bc9aejgjbhihf9rq8vm7t8j5anr7j7hc', '::1', 1599382972, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393338323937313b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b6362745f7465735f757365725f69647c733a353a226c75746669223b6362745f7465735f6e616d617c733a32323a224d7568616d6d6164204c75746669616c2048616b696d223b6362745f7465735f67726f75707c733a353a225849204d4d223b6362745f7465735f67726f75705f69647c733a313a2235223b), ('e38frtjsi5nefgjao7u40ptn8gshstnk', '::1', 1644977783, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343937373537323b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('f39scdhganmqqot28k62lbc3rmo1lsce', '::1', 1599386485, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393338363138373b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b6362745f7465735f757365725f69647c733a353a226c75746669223b6362745f7465735f6e616d617c733a32323a224d7568616d6d6164204c75746669616c2048616b696d223b6362745f7465735f67726f75707c733a353a225849204d4d223b6362745f7465735f67726f75705f69647c733a313a2235223b), ('fthkcg5hasehthcqlfjmeogf3eedm9ef', '127.0.0.1', 1599454747, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393435343734373b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('h7rpp3igk9lt3tu4vbi28jia5jkfv524', '::1', 1599454890, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393435343832303b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('ha55u3amhkachu4cfa34mvkgcj97vrdi', '::1', 1599381616, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393338313534363b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b6362745f7465735f757365725f69647c733a353a226c75746669223b6362745f7465735f6e616d617c733a32323a224d7568616d6d6164204c75746669616c2048616b696d223b6362745f7465735f67726f75707c733a353a225849204d4d223b6362745f7465735f67726f75705f69647c733a313a2235223b), ('htnpqjqcfqcl9g1psdribp1dpkicv416', '::1', 1641784345, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634313738343036393b), ('je0iglrep3d50g8gn21lonmv6nvnjsu1', '::1', 1644977572, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343937373537323b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('kkolosfo49t3vu9of56viv7u5r25rfks', '::1', 1599378656, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393337383431393b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('ks2b8bbrgkobgrkfij4pktj9keg6vj5e', '::1', 1644971525, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343937313532353b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('mt3ddutslgt5rtbqq22i9g8qigcjdpva', '::1', 1599386603, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393338363536303b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b6362745f7465735f757365725f69647c733a353a226c75746669223b6362745f7465735f6e616d617c733a32323a224d7568616d6d6164204c75746669616c2048616b696d223b6362745f7465735f67726f75707c733a353a225849204d4d223b6362745f7465735f67726f75705f69647c733a313a2235223b), ('p5q7f07bavkq326a2ddftl0ggc9c5g6q', '127.0.0.1', 1604183375, 0x5f5f63695f6c6173745f726567656e65726174657c693a313630343138333337353b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('ph4kvrn03c7gh4pishmsg9a0vhi1i8e5', '::1', 1599377617, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393337373333323b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('qg6n9mljb7oo6a9809pcl686s9mjm87m', '::1', 1599455121, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393435353131353b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('rhafjlpmrr6dbsi05f24tl39qv9250e9', '::1', 1599378268, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393337373935373b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('ro5m2p8h2ikbdm0fltah1tkegn1vj00p', '127.0.0.1', 1599455011, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539393435343734373b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('sfu4bpjieurrhjoln9he28hbhd2pviuj', '::1', 1644971826, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343937313832363b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b), ('vrqaeb3lbmh6otg8hibq5jrr93hbblln', '::1', 1644977270, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343937373237303b6362745f757365725f69647c733a353a2261646d696e223b6362745f6e616d617c733a31323a224163686d6164204c75746669223b6362745f6c6576656c7c733a353a2261646d696e223b6362745f6f707369317c733a303a22223b6362745f6f707369327c733a303a22223b); -- -------------------------------------------------------- -- -- Table structure for table `cbt_soal` -- CREATE TABLE `cbt_soal` ( `soal_id` bigint(20) UNSIGNED NOT NULL, `soal_topik_id` bigint(20) UNSIGNED NOT NULL, `soal_detail` text COLLATE utf8_unicode_ci NOT NULL, `soal_tipe` smallint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=Pilihan ganda, 2=essay, 3=jawaban singkat', `soal_kunci` text COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Kunci untuk soal jawaban singkat', `soal_difficulty` smallint(6) NOT NULL DEFAULT 1, `soal_aktif` tinyint(1) NOT NULL DEFAULT 0, `soal_audio` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `soal_audio_play` int(11) NOT NULL DEFAULT 0, `soal_timer` smallint(10) DEFAULT NULL, `soal_inline_answers` tinyint(1) NOT NULL DEFAULT 0, `soal_auto_next` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_soal` -- INSERT INTO `cbt_soal` (`soal_id`, `soal_topik_id`, `soal_detail`, `soal_tipe`, `soal_kunci`, `soal_difficulty`, `soal_aktif`, `soal_audio`, `soal_audio_play`, `soal_timer`, `soal_inline_answers`, `soal_auto_next`) VALUES (53, 7, 'Apakah kepanjangan dari SMK ?', 1, NULL, 1, 1, NULL, 1, NULL, 0, 0), (54, 7, '

Nama salah satu Mall yang ada di kota genteng adalah ...

', 1, NULL, 1, 1, NULL, 1, NULL, 0, 0), (55, 7, '

Siapakah nama tokoh berikut ?


', 1, NULL, 1, 1, NULL, 1, NULL, 0, 0), (56, 7, '

Siapakah vokalis band NOAH ?

', 1, NULL, 1, 1, NULL, 1, NULL, 0, 0), (57, 7, '

Tanggal berapakah hari raya Idul Fitri ?

\r\n', 1, NULL, 1, 1, NULL, 1, NULL, 0, 0), (61, 7, 'Jelaskan apa yang dimaksud dengan Jomblo ?', 2, NULL, 1, 1, NULL, 1, NULL, 0, 0), (62, 7, '

PT. Tiar Perkasa ingin melebarkan sayap usaha di bidang kuliner.

Dari pernyataan tersebut, sebutkan siapa kekasih mas Tiar ?

', 2, NULL, 1, 1, NULL, 1, NULL, 0, 0), (63, 7, '

Jelaskan kenapa Liverpool FC susah sekali untuk juara Premiere Leage !

\r\n', 2, NULL, 1, 1, NULL, 1, NULL, 0, 0), (64, 7, '

Apakah judul lagu berikut ini?

', 1, NULL, 1, 1, 'naff_-_akhirnya_ku_menemukanmu.mp3', 1, NULL, 0, 0), (161, 7, '

Jelaskan arti poster dibawah ini ?

\r\n\r\n

\r\n', 1, NULL, 1, 1, NULL, 0, NULL, 0, 0), (214, 7, '

Berapakah 5x10 ?

\r\n', 3, '50', 1, 1, NULL, 0, NULL, 0, 0), (215, 7, '

asdasd

\r\n', 1, '', 1, 1, NULL, 0, NULL, 0, 0), (216, 8, '

sdf

\r\n', 1, '', 1, 1, NULL, 0, NULL, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `cbt_tes` -- CREATE TABLE `cbt_tes` ( `tes_id` bigint(20) UNSIGNED NOT NULL, `tes_nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `tes_detail` text COLLATE utf8_unicode_ci NOT NULL, `tes_begin_time` datetime DEFAULT NULL, `tes_end_time` datetime DEFAULT NULL, `tes_duration_time` smallint(10) UNSIGNED NOT NULL DEFAULT 0, `tes_ip_range` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*.*.*.*', `tes_results_to_users` tinyint(1) NOT NULL DEFAULT 0, `tes_detail_to_users` tinyint(1) NOT NULL DEFAULT 0, `tes_score_right` decimal(10,2) DEFAULT 1.00, `tes_score_wrong` decimal(10,2) DEFAULT 0.00, `tes_score_unanswered` decimal(10,2) DEFAULT 0.00, `tes_max_score` decimal(10,2) NOT NULL DEFAULT 0.00, `tes_token` tinyint(1) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_tes` -- INSERT INTO `cbt_tes` (`tes_id`, `tes_nama`, `tes_detail`, `tes_begin_time`, `tes_end_time`, `tes_duration_time`, `tes_ip_range`, `tes_results_to_users`, `tes_detail_to_users`, `tes_score_right`, `tes_score_wrong`, `tes_score_unanswered`, `tes_max_score`, `tes_token`) VALUES (5, 'Tes Uji Coba', 'Tes Uji Coba', '2020-09-06 17:03:00', '2021-05-08 17:03:00', 30, '*.*.*.*', 1, 0, '1.00', '0.00', '0.00', '10.00', 0); -- -------------------------------------------------------- -- -- Table structure for table `cbt_tesgrup` -- CREATE TABLE `cbt_tesgrup` ( `tstgrp_tes_id` bigint(20) UNSIGNED NOT NULL, `tstgrp_grup_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_tesgrup` -- INSERT INTO `cbt_tesgrup` (`tstgrp_tes_id`, `tstgrp_grup_id`) VALUES (5, 5); -- -------------------------------------------------------- -- -- Table structure for table `cbt_tes_soal` -- CREATE TABLE `cbt_tes_soal` ( `tessoal_id` bigint(20) UNSIGNED NOT NULL, `tessoal_tesuser_id` bigint(20) UNSIGNED NOT NULL, `tessoal_user_ip` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL, `tessoal_soal_id` bigint(20) UNSIGNED NOT NULL, `tessoal_jawaban_text` text COLLATE utf8_unicode_ci DEFAULT NULL, `tessoal_nilai` decimal(10,2) DEFAULT NULL, `tessoal_creation_time` datetime DEFAULT NULL, `tessoal_display_time` datetime DEFAULT NULL, `tessoal_change_time` datetime DEFAULT NULL, `tessoal_reaction_time` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `tessoal_ragu` int(1) NOT NULL DEFAULT 0 COMMENT '1=ragu, 0=tidak ragu', `tessoal_order` smallint(6) NOT NULL DEFAULT 1, `tessoal_num_answers` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `tessoal_comment` text COLLATE utf8_unicode_ci DEFAULT NULL, `tessoal_audio_play` int(11) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cbt_tes_soal_jawaban` -- CREATE TABLE `cbt_tes_soal_jawaban` ( `soaljawaban_tessoal_id` bigint(20) UNSIGNED NOT NULL, `soaljawaban_jawaban_id` bigint(20) UNSIGNED NOT NULL, `soaljawaban_selected` smallint(6) NOT NULL DEFAULT -1, `soaljawaban_order` smallint(6) NOT NULL DEFAULT 1, `soaljawaban_position` bigint(20) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cbt_tes_token` -- CREATE TABLE `cbt_tes_token` ( `token_id` int(11) NOT NULL, `token_isi` varchar(20) NOT NULL, `token_user_id` int(11) NOT NULL, `token_ts` timestamp NOT NULL DEFAULT current_timestamp(), `token_aktif` int(11) NOT NULL DEFAULT 1 COMMENT 'Umur Token dalam menit, 1 = 1 hari penuh', `token_tes_id` bigint(20) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cbt_tes_token` -- INSERT INTO `cbt_tes_token` (`token_id`, `token_isi`, `token_user_id`, `token_ts`, `token_aktif`, `token_tes_id`) VALUES (12, '299403', 5, '2019-12-12 02:53:22', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `cbt_tes_topik_set` -- CREATE TABLE `cbt_tes_topik_set` ( `tset_id` bigint(20) UNSIGNED NOT NULL, `tset_tes_id` bigint(20) UNSIGNED NOT NULL, `tset_topik_id` bigint(20) UNSIGNED NOT NULL, `tset_tipe` smallint(6) NOT NULL DEFAULT 1, `tset_difficulty` smallint(6) NOT NULL DEFAULT 1, `tset_jumlah` smallint(6) NOT NULL DEFAULT 1, `tset_jawaban` smallint(6) NOT NULL DEFAULT 0, `tset_acak_jawaban` int(11) NOT NULL DEFAULT 1, `tset_acak_soal` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_tes_topik_set` -- INSERT INTO `cbt_tes_topik_set` (`tset_id`, `tset_tes_id`, `tset_topik_id`, `tset_tipe`, `tset_difficulty`, `tset_jumlah`, `tset_jawaban`, `tset_acak_jawaban`, `tset_acak_soal`) VALUES (5, 5, 7, 0, 1, 10, 5, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `cbt_tes_user` -- CREATE TABLE `cbt_tes_user` ( `tesuser_id` bigint(20) UNSIGNED NOT NULL, `tesuser_tes_id` bigint(20) UNSIGNED NOT NULL, `tesuser_user_id` bigint(20) UNSIGNED NOT NULL, `tesuser_status` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `tesuser_creation_time` datetime NOT NULL, `tesuser_comment` text COLLATE utf8_unicode_ci DEFAULT NULL, `tesuser_token` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cbt_topik` -- CREATE TABLE `cbt_topik` ( `topik_id` bigint(20) UNSIGNED NOT NULL, `topik_modul_id` bigint(20) UNSIGNED NOT NULL DEFAULT 1, `topik_nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `topik_detail` text COLLATE utf8_unicode_ci DEFAULT NULL, `topik_aktif` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_topik` -- INSERT INTO `cbt_topik` (`topik_id`, `topik_modul_id`, `topik_nama`, `topik_detail`, `topik_aktif`) VALUES (7, 9, 'Soal Uji Coba', 'Kumpulan Soal untuk Uji Coba ', 1), (8, 9, 'Testing', 'testing', 1); -- -------------------------------------------------------- -- -- Table structure for table `cbt_user` -- CREATE TABLE `cbt_user` ( `user_id` bigint(20) UNSIGNED NOT NULL, `user_grup_id` bigint(20) UNSIGNED NOT NULL, `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `user_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `user_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_regdate` timestamp NOT NULL DEFAULT current_timestamp(), `user_ip` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL, `user_firstname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_birthdate` date DEFAULT NULL, `user_birthplace` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_level` smallint(3) UNSIGNED NOT NULL DEFAULT 1, `user_detail` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_user` -- INSERT INTO `cbt_user` (`user_id`, `user_grup_id`, `user_name`, `user_password`, `user_email`, `user_regdate`, `user_ip`, `user_firstname`, `user_birthdate`, `user_birthplace`, `user_level`, `user_detail`) VALUES (1, 5, 'lutfi', 'lutfi', '', '2018-01-11 04:38:27', NULL, 'Muhammad Lutfial Hakim', NULL, NULL, 1, 'Ruang 1, Sesi 1'), (2, 5, 'joko', 'joko', '', '2018-08-11 03:49:25', NULL, 'Joko Susanto', NULL, NULL, 1, 'Ruang 1, Sesi 2'); -- -------------------------------------------------------- -- -- Table structure for table `cbt_user_grup` -- CREATE TABLE `cbt_user_grup` ( `grup_id` bigint(20) UNSIGNED NOT NULL, `grup_nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `cbt_user_grup` -- INSERT INTO `cbt_user_grup` (`grup_id`, `grup_nama`) VALUES (5, 'XI MM'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(255) NOT NULL, `nama` varchar(150) NOT NULL, `opsi1` varchar(75) NOT NULL, `opsi2` varchar(75) NOT NULL, `keterangan` varchar(150) NOT NULL, `level` varchar(50) NOT NULL, `ts` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `password`, `nama`, `opsi1`, `opsi2`, `keterangan`, `level`, `ts`) VALUES (1, 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 'Admin', '', '', '', 'admin', '2015-07-29 18:12:03'), (4, 'operator', 'fe96dd39756ac41b74283a9292652d366d73931f', 'Operator', '', '', 'Operator', 'operator-soal', '2018-03-30 12:58:55'), (5, 'joko', '97c358728f7f947c9a279ba9be88308395c7cc3a', 'Joko', '', '', 'Haloo', 'admin', '2019-12-12 02:53:12'); -- -------------------------------------------------------- -- -- Table structure for table `user_akses` -- CREATE TABLE `user_akses` ( `id` int(11) NOT NULL, `level` varchar(75) NOT NULL, `kode_menu` varchar(50) NOT NULL, `add` int(2) NOT NULL DEFAULT 1 COMMENT '0=false, 1=true', `edit` int(2) NOT NULL DEFAULT 1 COMMENT '0=false, 1=true' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user_akses` -- INSERT INTO `user_akses` (`id`, `level`, `kode_menu`, `add`, `edit`) VALUES (254, 'operator-soal', 'modul-daftar', 1, 1), (255, 'operator-soal', 'modul-filemanager', 1, 1), (256, 'operator-soal', 'modul-import', 1, 1), (257, 'operator-soal', 'modul-soal', 1, 1), (258, 'operator-soal', 'modul-topik', 1, 1), (259, 'operator-tes', 'tes-hasil-operator', 1, 1), (260, 'operator-tes', 'tes-token', 1, 1), (481, 'admin', 'laporan-analisis-butir-soal', 1, 1), (482, 'admin', 'peserta-kartu', 1, 1), (483, 'admin', 'peserta-group', 1, 1), (484, 'admin', 'peserta-daftar', 1, 1), (485, 'admin', 'modul-daftar', 1, 1), (486, 'admin', 'tes-daftar', 1, 1), (487, 'admin', 'tool-backup', 1, 1), (488, 'admin', 'tes-evaluasi', 1, 1), (489, 'admin', 'tool-exportimport-soal', 1, 1), (490, 'admin', 'modul-filemanager', 1, 1), (491, 'admin', 'tes-hasil', 1, 1), (492, 'admin', 'peserta-import', 1, 1), (493, 'admin', 'modul-import', 1, 1), (494, 'admin', 'modul-import-word', 1, 1), (496, 'admin', 'user_level', 1, 1), (497, 'admin', 'user_menu', 1, 1), (498, 'admin', 'user_atur', 1, 1), (499, 'admin', 'user-zyacbt', 1, 1), (500, 'admin', 'laporan-rekap', 1, 1), (501, 'admin', 'modul-soal', 1, 1), (502, 'admin', 'tes-tambah', 1, 1), (503, 'admin', 'tes-token', 1, 1), (504, 'admin', 'modul-topik', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `user_level` -- CREATE TABLE `user_level` ( `id` int(11) NOT NULL, `level` varchar(50) NOT NULL, `keterangan` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user_level` -- INSERT INTO `user_level` (`id`, `level`, `keterangan`) VALUES (1, 'admin', 'Administrator'), (7, 'operator-soal', 'Operator Soal'), (8, 'operator-tes', 'Operator Tes'); -- -------------------------------------------------------- -- -- Table structure for table `user_log` -- CREATE TABLE `user_log` ( `id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `log` varchar(250) NOT NULL, `ts` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `user_menu` -- CREATE TABLE `user_menu` ( `id` int(11) NOT NULL, `tipe` int(11) NOT NULL DEFAULT 1 COMMENT '0=parent, 1=child', `parent` varchar(50) DEFAULT NULL, `kode_menu` varchar(50) NOT NULL, `nama_menu` varchar(100) NOT NULL, `url` varchar(150) NOT NULL DEFAULT '#', `icon` varchar(75) NOT NULL DEFAULT 'fa fa-circle-o', `urutan` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user_menu` -- INSERT INTO `user_menu` (`id`, `tipe`, `parent`, `kode_menu`, `nama_menu`, `url`, `icon`, `urutan`) VALUES (1, 0, '', 'user', 'Pengaturan', '#', 'fa fa-user', 20), (3, 1, 'user', 'user_atur', 'Pengaturan User', 'manager/useratur', 'fa fa-circle-o', 5), (4, 1, 'user', 'user_level', 'Pengaturan Level', 'manager/userlevel', 'fa fa-circle-o', 6), (5, 1, 'user', 'user_menu', 'Pengaturan Menu', 'manager/usermenu', 'fa fa-circle-o', 7), (6, 0, '', 'modul', 'Data Modul', '#', 'fa fa-book', 2), (7, 1, 'modul', 'modul-daftar', 'Daftar Soal', 'manager/modul_daftar', 'fa fa-circle-o', 5), (8, 1, 'modul', 'modul-topik', 'Topik', 'manager/modul_topik', 'fa fa-circle-o', 2), (10, 0, '', 'peserta', 'Data Peserta', '#', 'fa fa-users', 3), (11, 1, 'peserta', 'peserta-daftar', 'Daftar Peserta', 'manager/peserta_daftar', 'fa fa-circle-o', 2), (12, 1, 'peserta', 'peserta-group', 'Daftar Group', 'manager/peserta_group', 'fa fa-circle-o', 1), (13, 1, 'peserta', 'peserta-import', 'Import Data Peserta', 'manager/peserta_import', 'fa fa-circle-o', 3), (14, 0, '', 'tes', 'Data Tes', '#', 'fa fa-tasks', 4), (15, 1, 'tes', 'tes-tambah', 'Tambah Tes', 'manager/tes_tambah', 'fa fa-circle-o', 1), (16, 1, 'tes', 'tes-daftar', 'Daftar Tes', 'manager/tes_daftar', 'fa fa-circle-o', 2), (17, 1, 'tes', 'tes-hasil', 'Hasil Tes', 'manager/tes_hasil', 'fa fa-circle-o', 6), (18, 1, 'modul', 'modul-soal', 'Soal', 'manager/modul_soal', 'fa fa-circle-o', 3), (19, 1, 'tes', 'tes-token', 'Token', 'manager/tes_token', 'fa fa-circle-o', 8), (22, 1, 'modul', 'modul-filemanager', 'File Manager', 'manager/modul_filemanager', 'fa fa-circle-o', 6), (24, 1, 'modul', 'modul-import', 'Import Soal Spreadsheet', 'manager/modul_import', 'fa fa-circle-o', 4), (25, 1, 'tes', 'tes-evaluasi', 'Evaluasi Tes', 'manager/tes_evaluasi', 'fa fa-circle-o', 5), (28, 1, 'tes', 'tes-hasil-operator', 'Hasil Tes Operator', 'manager/tes_hasil_operator', 'fa fa-circle-o', 10), (30, 0, '', 'tool', 'Tool', '#', 'fa fa-wrench', 6), (31, 1, 'tool', 'tool-backup', 'Database', 'manager/tool_backup', 'fa fa-database', 1), (32, 1, 'tes-laporan', 'laporan-rekap', 'Rekap Hasil Tes', 'manager/laporan_rekap_hasil', 'fa fa-circle-o', 7), (33, 1, 'tool', 'tool-exportimport-soal', 'Export / Import Soal', 'manager/tool_exportimport_soal', 'fa fa-circle-o', 2), (34, 1, 'user', 'user-zyacbt', 'Pengaturan UJIAN ONLINE', 'manager/pengaturan_zyacbt', 'fa fa-circle-o', 1), (37, 1, 'peserta', 'peserta-kartu', 'Cetak Kartu', 'manager/peserta_kartu', 'fa fa-circle-o', 5), (38, 0, '', 'tes-laporan', 'Laporan', '#', 'fa fa-print', 5), (41, 1, 'tes-laporan', 'laporan-analisis-butir-soal', 'Analisis Butir Soal', 'manager/laporan_analisis_butir_soal', 'fa fa-circle-o', 1), (42, 1, 'tes-laporan', 'laporan-analisis-soal', 'Analisis Soal', 'manager/laporan_analisis_soal', 'fa fa-circle-o', 2), (43, 1, 'modul', 'modul-import-word', 'Import Soal Word', 'manager/modul_import_word', 'fa fa-circle-o', 4); -- -- Indexes for dumped tables -- -- -- Indexes for table `cbt_jawaban` -- ALTER TABLE `cbt_jawaban` ADD PRIMARY KEY (`jawaban_id`), ADD KEY `p_answer_question_id` (`jawaban_soal_id`); -- -- Indexes for table `cbt_konfigurasi` -- ALTER TABLE `cbt_konfigurasi` ADD PRIMARY KEY (`konfigurasi_id`), ADD UNIQUE KEY `konfigurasi_kode` (`konfigurasi_kode`); -- -- Indexes for table `cbt_modul` -- ALTER TABLE `cbt_modul` ADD PRIMARY KEY (`modul_id`), ADD UNIQUE KEY `ak_module_name` (`modul_nama`); -- -- Indexes for table `cbt_sessions` -- ALTER TABLE `cbt_sessions` ADD PRIMARY KEY (`id`), ADD KEY `ci_sessions_timestamp` (`timestamp`); -- -- Indexes for table `cbt_soal` -- ALTER TABLE `cbt_soal` ADD PRIMARY KEY (`soal_id`), ADD KEY `p_question_subject_id` (`soal_topik_id`); -- -- Indexes for table `cbt_tes` -- ALTER TABLE `cbt_tes` ADD PRIMARY KEY (`tes_id`), ADD UNIQUE KEY `ak_test_name` (`tes_nama`); -- -- Indexes for table `cbt_tesgrup` -- ALTER TABLE `cbt_tesgrup` ADD PRIMARY KEY (`tstgrp_tes_id`,`tstgrp_grup_id`), ADD KEY `p_tstgrp_test_id` (`tstgrp_tes_id`), ADD KEY `p_tstgrp_group_id` (`tstgrp_grup_id`); -- -- Indexes for table `cbt_tes_soal` -- ALTER TABLE `cbt_tes_soal` ADD PRIMARY KEY (`tessoal_id`), ADD UNIQUE KEY `ak_testuser_question` (`tessoal_tesuser_id`,`tessoal_soal_id`), ADD KEY `p_testlog_question_id` (`tessoal_soal_id`), ADD KEY `p_testlog_testuser_id` (`tessoal_tesuser_id`); -- -- Indexes for table `cbt_tes_soal_jawaban` -- ALTER TABLE `cbt_tes_soal_jawaban` ADD PRIMARY KEY (`soaljawaban_tessoal_id`,`soaljawaban_jawaban_id`), ADD KEY `p_logansw_answer_id` (`soaljawaban_jawaban_id`), ADD KEY `p_logansw_testlog_id` (`soaljawaban_tessoal_id`); -- -- Indexes for table `cbt_tes_token` -- ALTER TABLE `cbt_tes_token` ADD PRIMARY KEY (`token_id`), ADD KEY `token_user_id` (`token_user_id`); -- -- Indexes for table `cbt_tes_topik_set` -- ALTER TABLE `cbt_tes_topik_set` ADD PRIMARY KEY (`tset_id`), ADD KEY `p_tsubset_test_id` (`tset_tes_id`), ADD KEY `tsubset_subject_id` (`tset_topik_id`); -- -- Indexes for table `cbt_tes_user` -- ALTER TABLE `cbt_tes_user` ADD PRIMARY KEY (`tesuser_id`), ADD UNIQUE KEY `ak_testuser` (`tesuser_tes_id`,`tesuser_user_id`,`tesuser_status`), ADD KEY `p_testuser_user_id` (`tesuser_user_id`), ADD KEY `p_testuser_test_id` (`tesuser_tes_id`); -- -- Indexes for table `cbt_topik` -- ALTER TABLE `cbt_topik` ADD PRIMARY KEY (`topik_id`), ADD UNIQUE KEY `ak_subject_name` (`topik_modul_id`,`topik_nama`); -- -- Indexes for table `cbt_user` -- ALTER TABLE `cbt_user` ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `ak_user_name` (`user_name`), ADD KEY `user_groups_id` (`user_grup_id`), ADD KEY `user_detail` (`user_detail`); -- -- Indexes for table `cbt_user_grup` -- ALTER TABLE `cbt_user_grup` ADD PRIMARY KEY (`grup_id`), ADD UNIQUE KEY `group_name` (`grup_nama`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD KEY `level` (`level`); -- -- Indexes for table `user_akses` -- ALTER TABLE `user_akses` ADD PRIMARY KEY (`id`), ADD KEY `akses_kode_menu` (`kode_menu`), ADD KEY `akses_level` (`level`); -- -- Indexes for table `user_level` -- ALTER TABLE `user_level` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `level` (`level`); -- -- Indexes for table `user_log` -- ALTER TABLE `user_log` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_menu` -- ALTER TABLE `user_menu` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `kode_menu` (`kode_menu`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `cbt_jawaban` -- ALTER TABLE `cbt_jawaban` MODIFY `jawaban_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=626; -- -- AUTO_INCREMENT for table `cbt_konfigurasi` -- ALTER TABLE `cbt_konfigurasi` MODIFY `konfigurasi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `cbt_modul` -- ALTER TABLE `cbt_modul` MODIFY `modul_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `cbt_soal` -- ALTER TABLE `cbt_soal` MODIFY `soal_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=217; -- -- AUTO_INCREMENT for table `cbt_tes` -- ALTER TABLE `cbt_tes` MODIFY `tes_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `cbt_tes_soal` -- ALTER TABLE `cbt_tes_soal` MODIFY `tessoal_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `cbt_tes_token` -- ALTER TABLE `cbt_tes_token` MODIFY `token_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `cbt_tes_topik_set` -- ALTER TABLE `cbt_tes_topik_set` MODIFY `tset_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `cbt_tes_user` -- ALTER TABLE `cbt_tes_user` MODIFY `tesuser_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `cbt_topik` -- ALTER TABLE `cbt_topik` MODIFY `topik_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `cbt_user` -- ALTER TABLE `cbt_user` MODIFY `user_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `cbt_user_grup` -- ALTER TABLE `cbt_user_grup` MODIFY `grup_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `user_akses` -- ALTER TABLE `user_akses` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=505; -- -- AUTO_INCREMENT for table `user_level` -- ALTER TABLE `user_level` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `user_log` -- ALTER TABLE `user_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user_menu` -- ALTER TABLE `user_menu` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; -- -- Constraints for dumped tables -- -- -- Constraints for table `cbt_jawaban` -- ALTER TABLE `cbt_jawaban` ADD CONSTRAINT `cbt_jawaban_ibfk_1` FOREIGN KEY (`jawaban_soal_id`) REFERENCES `cbt_soal` (`soal_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `cbt_soal` -- ALTER TABLE `cbt_soal` ADD CONSTRAINT `cbt_soal_ibfk_1` FOREIGN KEY (`soal_topik_id`) REFERENCES `cbt_topik` (`topik_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `cbt_tesgrup` -- ALTER TABLE `cbt_tesgrup` ADD CONSTRAINT `cbt_tesgrup_ibfk_1` FOREIGN KEY (`tstgrp_tes_id`) REFERENCES `cbt_tes` (`tes_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `cbt_tesgrup_ibfk_2` FOREIGN KEY (`tstgrp_grup_id`) REFERENCES `cbt_user_grup` (`grup_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `cbt_tes_soal` -- ALTER TABLE `cbt_tes_soal` ADD CONSTRAINT `cbt_tes_soal_ibfk_1` FOREIGN KEY (`tessoal_tesuser_id`) REFERENCES `cbt_tes_user` (`tesuser_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `cbt_tes_soal_ibfk_2` FOREIGN KEY (`tessoal_soal_id`) REFERENCES `cbt_soal` (`soal_id`) ON UPDATE NO ACTION; -- -- Constraints for table `cbt_tes_soal_jawaban` -- ALTER TABLE `cbt_tes_soal_jawaban` ADD CONSTRAINT `cbt_tes_soal_jawaban_ibfk_1` FOREIGN KEY (`soaljawaban_tessoal_id`) REFERENCES `cbt_tes_soal` (`tessoal_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `cbt_tes_soal_jawaban_ibfk_2` FOREIGN KEY (`soaljawaban_jawaban_id`) REFERENCES `cbt_jawaban` (`jawaban_id`) ON UPDATE NO ACTION; -- -- Constraints for table `cbt_tes_token` -- ALTER TABLE `cbt_tes_token` ADD CONSTRAINT `cbt_tes_token_ibfk_1` FOREIGN KEY (`token_user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `cbt_tes_topik_set` -- ALTER TABLE `cbt_tes_topik_set` ADD CONSTRAINT `cbt_tes_topik_set_ibfk_1` FOREIGN KEY (`tset_tes_id`) REFERENCES `cbt_tes` (`tes_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `cbt_tes_topik_set_ibfk_2` FOREIGN KEY (`tset_topik_id`) REFERENCES `cbt_topik` (`topik_id`) ON UPDATE NO ACTION; -- -- Constraints for table `cbt_tes_user` -- ALTER TABLE `cbt_tes_user` ADD CONSTRAINT `cbt_tes_user_ibfk_1` FOREIGN KEY (`tesuser_tes_id`) REFERENCES `cbt_tes` (`tes_id`) ON DELETE CASCADE, ADD CONSTRAINT `cbt_tes_user_ibfk_2` FOREIGN KEY (`tesuser_user_id`) REFERENCES `cbt_user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `cbt_topik` -- ALTER TABLE `cbt_topik` ADD CONSTRAINT `cbt_topik_ibfk_1` FOREIGN KEY (`topik_modul_id`) REFERENCES `cbt_modul` (`modul_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `cbt_user` -- ALTER TABLE `cbt_user` ADD CONSTRAINT `cbt_user_ibfk_1` FOREIGN KEY (`user_grup_id`) REFERENCES `cbt_user_grup` (`grup_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `user` -- ALTER TABLE `user` ADD CONSTRAINT `user_ibfk_1` FOREIGN KEY (`level`) REFERENCES `user_level` (`level`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `user_akses` -- ALTER TABLE `user_akses` ADD CONSTRAINT `user_akses_ibfk_2` FOREIGN KEY (`kode_menu`) REFERENCES `user_menu` (`kode_menu`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `user_akses_ibfk_3` FOREIGN KEY (`level`) REFERENCES `user_level` (`level`) 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 */;