-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 05 Sep 2023 pada 16.41
-- Versi server: 10.8.4-MariaDB-1:10.8.4+maria~ubu2004
-- Versi PHP: 8.1.22

START TRANSACTION;



--
-- Database: `db_jurnalojs`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `access_keys`
--

CREATE TABLE `access_keys` (
  `access_key_id` bigint(20) NOT NULL,
  `context` varchar(40) NOT NULL,
  `key_hash` varchar(40) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `assoc_id` bigint(20) DEFAULT NULL,
  `expiry_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `announcements`
--

CREATE TABLE `announcements` (
  `announcement_id` bigint(20) NOT NULL,
  `assoc_type` smallint(6) DEFAULT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `type_id` bigint(20) DEFAULT NULL,
  `date_expire` date DEFAULT NULL,
  `date_posted` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `announcement_settings`
--

CREATE TABLE `announcement_settings` (
  `announcement_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `announcement_types`
--

CREATE TABLE `announcement_types` (
  `type_id` bigint(20) NOT NULL,
  `assoc_type` smallint(6) NOT NULL,
  `assoc_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `announcement_type_settings`
--

CREATE TABLE `announcement_type_settings` (
  `type_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `authors`
--

CREATE TABLE `authors` (
  `author_id` bigint(20) NOT NULL,
  `email` varchar(90) NOT NULL,
  `include_in_browse` smallint(6) NOT NULL DEFAULT 1,
  `publication_id` bigint(20) NOT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00,
  `user_group_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `authors`
--

INSERT INTO `authors` (`author_id`, `email`, `include_in_browse`, `publication_id`, `seq`, `user_group_id`) VALUES
(2, 'niken@gmail.com', 1, 1, 1.00, 14),
(3, 'andisupriadijr@gmail.com', 1, 2, 0.00, 14),
(5, 'rina.sari@lecture.unjani.ac.id', 1, 4, 0.00, 14),
(6, 'dyah.titi@lecture.unjani.ac.id', 1, 5, 0.00, 14),
(7, 'rachmat.taufiq@lecture.unjani.ac.id', 1, 6, 0.00, 14),
(8, 'linda.ernawati@lecture.unjani.ac.id', 1, 6, 1.00, 14),
(9, 'miamilikmianti@gmail.com', 1, 6, 2.00, 14),
(10, 'afinifreud@gmail.com', 1, 6, 3.00, 14),
(11, 'afini.freudwi@lecture.unjani.ac.id', 1, 7, 0.00, 14),
(12, 'lenny.utama@dsn.ubharajaya.ac.id', 1, 8, 0.00, 14),
(13, 'nurwahyuni.nasir@dsn.ubharajaya.ac.id', 1, 9, 0.00, 14);

-- --------------------------------------------------------

--
-- Struktur dari tabel `author_settings`
--

CREATE TABLE `author_settings` (
  `author_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `author_settings`
--

INSERT INTO `author_settings` (`author_id`, `locale`, `setting_name`, `setting_value`) VALUES
(2, '', 'country', 'ID'),
(2, '', 'orcid', ''),
(2, '', 'url', ''),
(2, 'en_US', 'affiliation', 'Unjani'),
(2, 'en_US', 'biography', ''),
(2, 'en_US', 'familyName', 'Cahyorinartri'),
(2, 'en_US', 'givenName', 'Niken'),
(2, 'en_US', 'preferredPublicName', ''),
(3, '', 'country', 'ID'),
(3, '', 'orcid', ''),
(3, '', 'url', ''),
(3, 'en_US', 'affiliation', 'Unjani'),
(3, 'en_US', 'biography', ''),
(3, 'en_US', 'familyName', 'Supriadi'),
(3, 'en_US', 'givenName', 'Andi'),
(5, '', 'country', 'ID'),
(5, 'en_US', 'affiliation', 'Universitas Jenderal Achmad Yani'),
(5, 'en_US', 'familyName', 'Sari'),
(5, 'en_US', 'givenName', 'Rina'),
(6, '', 'country', 'ID'),
(6, 'en_US', 'affiliation', 'Universitas Jenderal Achmad Yani'),
(6, 'en_US', 'familyName', ''),
(6, 'en_US', 'givenName', 'Dyah Titi S'),
(7, '', 'country', 'ID'),
(7, 'en_US', 'affiliation', 'Fakultas Psikologi Universitas Jenderal Achmad Yani'),
(7, 'en_US', 'familyName', 'Taufiq'),
(7, 'en_US', 'givenName', 'Rachmat'),
(8, '', 'country', 'ID'),
(8, '', 'orcid', ''),
(8, '', 'url', ''),
(8, 'en_US', 'affiliation', ''),
(8, 'en_US', 'biography', ''),
(8, 'en_US', 'familyName', 'Ernawati'),
(8, 'en_US', 'givenName', 'Linda'),
(8, 'en_US', 'preferredPublicName', ''),
(9, '', 'country', 'ID'),
(9, '', 'orcid', ''),
(9, '', 'url', ''),
(9, 'en_US', 'affiliation', ''),
(9, 'en_US', 'biography', ''),
(9, 'en_US', 'familyName', 'Milikmianti'),
(9, 'en_US', 'givenName', 'Mia'),
(9, 'en_US', 'preferredPublicName', ''),
(10, '', 'country', 'ID'),
(10, '', 'orcid', ''),
(10, '', 'url', ''),
(10, 'en_US', 'affiliation', ''),
(10, 'en_US', 'biography', ''),
(10, 'en_US', 'familyName', 'Freudwi Asri'),
(10, 'en_US', 'givenName', 'Afini'),
(10, 'en_US', 'preferredPublicName', ''),
(11, '', 'country', 'ID'),
(11, 'en_US', 'affiliation', 'Universitas Jenderal Achmad Yani'),
(11, 'en_US', 'familyName', 'Asri'),
(11, 'en_US', 'givenName', 'Afini'),
(12, '', 'country', 'ID'),
(12, 'en_US', 'affiliation', 'Universitas Bhayangkara Jakarta Raya'),
(12, 'en_US', 'familyName', 'Afriyenti'),
(12, 'en_US', 'givenName', 'Lenny Utama'),
(13, '', 'country', 'ID'),
(13, 'en_US', 'affiliation', 'Universitas bhayangkara jakarta raya'),
(13, 'en_US', 'familyName', 'Nasir'),
(13, 'en_US', 'givenName', 'Nurwahyuni');

-- --------------------------------------------------------

--
-- Struktur dari tabel `auth_sources`
--

CREATE TABLE `auth_sources` (
  `auth_id` bigint(20) NOT NULL,
  `title` varchar(60) NOT NULL,
  `plugin` varchar(32) NOT NULL,
  `auth_default` smallint(6) NOT NULL DEFAULT 0,
  `settings` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `categories`
--

CREATE TABLE `categories` (
  `category_id` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `parent_id` bigint(20) NOT NULL,
  `seq` bigint(20) DEFAULT NULL,
  `path` varchar(255) NOT NULL,
  `image` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `category_settings`
--

CREATE TABLE `category_settings` (
  `category_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `citations`
--

CREATE TABLE `citations` (
  `citation_id` bigint(20) NOT NULL,
  `publication_id` bigint(20) NOT NULL DEFAULT 0,
  `raw_citation` text NOT NULL,
  `seq` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `citation_settings`
--

CREATE TABLE `citation_settings` (
  `citation_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `completed_payments`
--

CREATE TABLE `completed_payments` (
  `completed_payment_id` bigint(20) NOT NULL,
  `timestamp` datetime NOT NULL,
  `payment_type` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `assoc_id` bigint(20) DEFAULT NULL,
  `amount` double(8,2) NOT NULL,
  `currency_code_alpha` varchar(3) DEFAULT NULL,
  `payment_method_plugin_name` varchar(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `controlled_vocabs`
--

CREATE TABLE `controlled_vocabs` (
  `controlled_vocab_id` bigint(20) NOT NULL,
  `symbolic` varchar(64) NOT NULL,
  `assoc_type` bigint(20) NOT NULL DEFAULT 0,
  `assoc_id` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `controlled_vocabs`
--

INSERT INTO `controlled_vocabs` (`controlled_vocab_id`, `symbolic`, `assoc_type`, `assoc_id`) VALUES
(6, 'interest', 0, 0),
(5, 'submissionAgency', 1048588, 1),
(11, 'submissionAgency', 1048588, 2),
(16, 'submissionAgency', 1048588, 3),
(21, 'submissionAgency', 1048588, 4),
(26, 'submissionAgency', 1048588, 5),
(31, 'submissionAgency', 1048588, 6),
(36, 'submissionAgency', 1048588, 7),
(41, 'submissionAgency', 1048588, 8),
(46, 'submissionAgency', 1048588, 9),
(3, 'submissionDiscipline', 1048588, 1),
(9, 'submissionDiscipline', 1048588, 2),
(14, 'submissionDiscipline', 1048588, 3),
(19, 'submissionDiscipline', 1048588, 4),
(24, 'submissionDiscipline', 1048588, 5),
(29, 'submissionDiscipline', 1048588, 6),
(34, 'submissionDiscipline', 1048588, 7),
(39, 'submissionDiscipline', 1048588, 8),
(44, 'submissionDiscipline', 1048588, 9),
(1, 'submissionKeyword', 1048588, 1),
(7, 'submissionKeyword', 1048588, 2),
(12, 'submissionKeyword', 1048588, 3),
(17, 'submissionKeyword', 1048588, 4),
(22, 'submissionKeyword', 1048588, 5),
(27, 'submissionKeyword', 1048588, 6),
(32, 'submissionKeyword', 1048588, 7),
(37, 'submissionKeyword', 1048588, 8),
(42, 'submissionKeyword', 1048588, 9),
(4, 'submissionLanguage', 1048588, 1),
(10, 'submissionLanguage', 1048588, 2),
(15, 'submissionLanguage', 1048588, 3),
(20, 'submissionLanguage', 1048588, 4),
(25, 'submissionLanguage', 1048588, 5),
(30, 'submissionLanguage', 1048588, 6),
(35, 'submissionLanguage', 1048588, 7),
(40, 'submissionLanguage', 1048588, 8),
(45, 'submissionLanguage', 1048588, 9),
(2, 'submissionSubject', 1048588, 1),
(8, 'submissionSubject', 1048588, 2),
(13, 'submissionSubject', 1048588, 3),
(18, 'submissionSubject', 1048588, 4),
(23, 'submissionSubject', 1048588, 5),
(28, 'submissionSubject', 1048588, 6),
(33, 'submissionSubject', 1048588, 7),
(38, 'submissionSubject', 1048588, 8),
(43, 'submissionSubject', 1048588, 9);

-- --------------------------------------------------------

--
-- Struktur dari tabel `controlled_vocab_entries`
--

CREATE TABLE `controlled_vocab_entries` (
  `controlled_vocab_entry_id` bigint(20) NOT NULL,
  `controlled_vocab_id` bigint(20) NOT NULL,
  `seq` double(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `controlled_vocab_entries`
--

INSERT INTO `controlled_vocab_entries` (`controlled_vocab_entry_id`, `controlled_vocab_id`, `seq`) VALUES
(10, 1, 1.00),
(11, 1, 2.00),
(7, 6, 0.00),
(12, 6, 0.00),
(13, 6, 0.00),
(14, 6, 0.00),
(15, 6, 0.00),
(22, 6, 0.00),
(16, 22, 1.00),
(17, 27, 1.00),
(18, 27, 2.00),
(19, 32, 1.00),
(20, 32, 2.00),
(21, 32, 3.00);

-- --------------------------------------------------------

--
-- Struktur dari tabel `controlled_vocab_entry_settings`
--

CREATE TABLE `controlled_vocab_entry_settings` (
  `controlled_vocab_entry_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `controlled_vocab_entry_settings`
--

INSERT INTO `controlled_vocab_entry_settings` (`controlled_vocab_entry_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(7, '', 'interest', 'dsfsdfdsf', 'string'),
(10, 'en_US', 'submissionKeyword', 'Penyesuaian Diri', 'string'),
(11, 'en_US', 'submissionKeyword', 'Bintara', 'string'),
(12, '', 'interest', 'Psychometric', 'string'),
(13, '', 'interest', 'measurement psychology', 'string'),
(14, '', 'interest', 'and carrer development', 'string'),
(15, '', 'interest', '', 'string'),
(16, 'en_US', 'submissionKeyword', 'Kematian Orangtua; Keputusasaan; Putus Asa, Upaya Bunuh Diri', 'string'),
(17, 'en_US', 'submissionKeyword', 'self concept', 'string'),
(18, 'en_US', 'submissionKeyword', 'gay', 'string'),
(19, 'en_US', 'submissionKeyword', 'flow academic', 'string'),
(20, 'en_US', 'submissionKeyword', 'mahasiswa', 'string'),
(21, 'en_US', 'submissionKeyword', 'academic burnout', 'string'),
(22, '', 'interest', 'Psikologi', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `custom_issue_orders`
--

CREATE TABLE `custom_issue_orders` (
  `issue_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `custom_section_orders`
--

CREATE TABLE `custom_section_orders` (
  `issue_id` bigint(20) NOT NULL,
  `section_id` bigint(20) NOT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `data_object_tombstones`
--

CREATE TABLE `data_object_tombstones` (
  `tombstone_id` bigint(20) NOT NULL,
  `data_object_id` bigint(20) NOT NULL,
  `date_deleted` datetime NOT NULL,
  `set_spec` varchar(255) NOT NULL,
  `set_name` varchar(255) NOT NULL,
  `oai_identifier` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `data_object_tombstones`
--

INSERT INTO `data_object_tombstones` (`tombstone_id`, `data_object_id`, `date_deleted`, `set_spec`, `set_name`, `oai_identifier`) VALUES
(1, 2, '2023-07-11 13:02:07', 'ip:ART', 'Articles', 'oai:ojs2.localhost:8000:article/2'),
(2, 1, '2023-08-23 14:24:59', 'ip:ART', 'Articles', 'oai:ojs2.localhost:8000:article/1');

-- --------------------------------------------------------

--
-- Struktur dari tabel `data_object_tombstone_oai_set_objects`
--

CREATE TABLE `data_object_tombstone_oai_set_objects` (
  `object_id` bigint(20) NOT NULL,
  `tombstone_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `data_object_tombstone_oai_set_objects`
--

INSERT INTO `data_object_tombstone_oai_set_objects` (`object_id`, `tombstone_id`, `assoc_type`, `assoc_id`) VALUES
(1, 1, 256, 1),
(2, 1, 530, 1),
(3, 2, 256, 1),
(4, 2, 530, 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `data_object_tombstone_settings`
--

CREATE TABLE `data_object_tombstone_settings` (
  `tombstone_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `edit_decisions`
--

CREATE TABLE `edit_decisions` (
  `edit_decision_id` bigint(20) NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `review_round_id` bigint(20) NOT NULL,
  `stage_id` bigint(20) DEFAULT NULL,
  `round` smallint(6) NOT NULL,
  `editor_id` bigint(20) NOT NULL,
  `decision` smallint(6) NOT NULL,
  `date_decided` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `edit_decisions`
--

INSERT INTO `edit_decisions` (`edit_decision_id`, `submission_id`, `review_round_id`, `stage_id`, `round`, `editor_id`, `decision`, `date_decided`) VALUES
(1, 1, 0, 1, 0, 2, 1, '2023-03-18 15:25:33'),
(2, 1, 0, 4, 0, 2, 7, '2023-03-18 15:27:03'),
(3, 2, 0, 1, 0, 1, 1, '2023-03-25 14:21:52'),
(4, 2, 0, 4, 0, 1, 7, '2023-03-25 14:23:10'),
(5, 4, 0, 1, 0, 1, 8, '2023-08-28 14:50:12'),
(6, 5, 0, 1, 0, 1, 8, '2023-08-28 16:23:20'),
(7, 7, 0, 1, 0, 1, 8, '2023-09-05 00:59:59'),
(8, 6, 0, 1, 0, 1, 8, '2023-09-05 01:01:48'),
(9, 5, 2, 3, 1, 1, 2, '2023-09-05 03:17:08'),
(10, 4, 1, 3, 1, 1, 2, '2023-09-05 05:14:04'),
(11, 4, 1, 3, 1, 1, 2, '2023-09-05 05:14:19'),
(12, 4, 1, 3, 1, 1, 2, '2023-09-05 05:14:59');

-- --------------------------------------------------------

--
-- Struktur dari tabel `email_log`
--

CREATE TABLE `email_log` (
  `log_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `sender_id` bigint(20) NOT NULL,
  `date_sent` datetime NOT NULL,
  `event_type` bigint(20) DEFAULT NULL,
  `from_address` varchar(255) DEFAULT NULL,
  `recipients` text DEFAULT NULL,
  `cc_recipients` text DEFAULT NULL,
  `bcc_recipients` text DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;



-- --------------------------------------------------------

--
-- Struktur dari tabel `email_log_users`
--

CREATE TABLE `email_log_users` (
  `email_log_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `email_log_users`
--

INSERT INTO `email_log_users` (`email_log_id`, `user_id`) VALUES
(1, 2),
(2, 2),
(3, 2),
(4, 2),
(5, 12),
(6, 12),
(7, 8),
(8, 6),
(9, 6),
(10, 6),
(11, 13),
(12, 14);

-- --------------------------------------------------------

--
-- Struktur dari tabel `email_templates`
--

CREATE TABLE `email_templates` (
  `email_id` bigint(20) NOT NULL,
  `email_key` varchar(64) NOT NULL COMMENT 'Unique identifier for this email.',
  `context_id` bigint(20) NOT NULL,
  `enabled` smallint(6) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `email_templates_default`
--

CREATE TABLE `email_templates_default` (
  `email_id` bigint(20) NOT NULL,
  `email_key` varchar(64) NOT NULL COMMENT 'Unique identifier for this email.',
  `can_disable` smallint(6) NOT NULL DEFAULT 0,
  `can_edit` smallint(6) NOT NULL DEFAULT 0,
  `from_role_id` bigint(20) DEFAULT NULL,
  `to_role_id` bigint(20) DEFAULT NULL,
  `stage_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `email_templates_default`
--

INSERT INTO `email_templates_default` (`email_id`, `email_key`, `can_disable`, `can_edit`, `from_role_id`, `to_role_id`, `stage_id`) VALUES
(1, 'NOTIFICATION', 0, 1, NULL, NULL, NULL),
(2, 'NOTIFICATION_CENTER_DEFAULT', 0, 1, NULL, NULL, NULL),
(3, 'PASSWORD_RESET_CONFIRM', 0, 1, NULL, NULL, NULL),
(4, 'USER_REGISTER', 0, 1, NULL, NULL, NULL),
(5, 'USER_VALIDATE', 0, 1, NULL, NULL, NULL),
(6, 'REVIEWER_REGISTER', 0, 1, NULL, NULL, NULL),
(7, 'PUBLISH_NOTIFY', 0, 1, NULL, NULL, NULL),
(8, 'LOCKSS_EXISTING_ARCHIVE', 0, 1, NULL, NULL, NULL),
(9, 'LOCKSS_NEW_ARCHIVE', 0, 1, NULL, NULL, NULL),
(10, 'SUBMISSION_ACK', 1, 1, NULL, 65536, 1),
(11, 'SUBMISSION_ACK_NOT_USER', 1, 1, NULL, 65536, 1),
(12, 'EDITOR_ASSIGN', 1, 1, 16, 16, 1),
(13, 'REVIEW_CANCEL', 1, 1, 16, 4096, 3),
(14, 'REVIEW_REINSTATE', 1, 1, 16, 4096, 3),
(15, 'REVIEW_REQUEST', 1, 1, 16, 4096, 3),
(16, 'REVIEW_REQUEST_SUBSEQUENT', 1, 1, 16, 4096, 3),
(17, 'REVIEW_REQUEST_ONECLICK', 1, 1, 16, 4096, 3),
(18, 'REVIEW_REQUEST_ONECLICK_SUBSEQUENT', 1, 1, 16, 4096, 3),
(19, 'REVIEW_REQUEST_ATTACHED', 0, 1, 16, 4096, 3),
(20, 'REVIEW_REQUEST_ATTACHED_SUBSEQUENT', 0, 1, 16, 4096, 3),
(21, 'REVIEW_REQUEST_REMIND_AUTO', 0, 1, NULL, 4096, 3),
(22, 'REVIEW_REQUEST_REMIND_AUTO_ONECLICK', 0, 1, NULL, 4096, 3),
(23, 'REVIEW_CONFIRM', 1, 1, 4096, 16, 3),
(24, 'REVIEW_DECLINE', 1, 1, 4096, 16, 3),
(25, 'REVIEW_ACK', 1, 1, 16, 4096, 3),
(26, 'REVIEW_REMIND', 0, 1, 16, 4096, 3),
(27, 'REVIEW_REMIND_AUTO', 0, 1, NULL, 4096, 3),
(28, 'REVIEW_REMIND_ONECLICK', 0, 1, 16, 4096, 3),
(29, 'REVIEW_REMIND_AUTO_ONECLICK', 0, 1, NULL, 4096, 3),
(30, 'EDITOR_DECISION_ACCEPT', 0, 1, 16, 65536, 3),
(31, 'EDITOR_DECISION_SEND_TO_EXTERNAL', 0, 1, 16, 65536, 3),
(32, 'EDITOR_DECISION_SEND_TO_PRODUCTION', 0, 1, 16, 65536, 5),
(33, 'EDITOR_DECISION_REVISIONS', 0, 1, 16, 65536, 3),
(34, 'EDITOR_DECISION_RESUBMIT', 0, 1, 16, 65536, 3),
(35, 'EDITOR_DECISION_DECLINE', 0, 1, 16, 65536, 3),
(36, 'EDITOR_DECISION_INITIAL_DECLINE', 0, 1, 16, 65536, 1),
(37, 'EDITOR_RECOMMENDATION', 0, 1, 16, 16, 3),
(38, 'COPYEDIT_REQUEST', 1, 1, 16, 4097, 4),
(39, 'LAYOUT_REQUEST', 1, 1, 16, 4097, 5),
(40, 'LAYOUT_COMPLETE', 1, 1, 4097, 16, 5),
(41, 'EMAIL_LINK', 0, 1, 1048576, NULL, NULL),
(42, 'SUBSCRIPTION_NOTIFY', 0, 1, NULL, 1048576, NULL),
(43, 'OPEN_ACCESS_NOTIFY', 0, 1, NULL, 1048576, NULL),
(44, 'SUBSCRIPTION_BEFORE_EXPIRY', 0, 1, NULL, 1048576, NULL),
(45, 'SUBSCRIPTION_AFTER_EXPIRY', 0, 1, NULL, 1048576, NULL),
(46, 'SUBSCRIPTION_AFTER_EXPIRY_LAST', 0, 1, NULL, 1048576, NULL),
(47, 'SUBSCRIPTION_PURCHASE_INDL', 0, 1, NULL, 2097152, NULL),
(48, 'SUBSCRIPTION_PURCHASE_INSTL', 0, 1, NULL, 2097152, NULL),
(49, 'SUBSCRIPTION_RENEW_INDL', 0, 1, NULL, 2097152, NULL),
(50, 'SUBSCRIPTION_RENEW_INSTL', 0, 1, NULL, 2097152, NULL),
(51, 'CITATION_EDITOR_AUTHOR_QUERY', 0, 1, NULL, NULL, 4),
(52, 'REVISED_VERSION_NOTIFY', 0, 1, NULL, 16, 3),
(53, 'STATISTICS_REPORT_NOTIFICATION', 1, 1, 16, 17, NULL),
(54, 'ANNOUNCEMENT', 0, 1, 16, 1048576, NULL),
(55, 'ORCID_COLLECT_AUTHOR_ID', 0, 1, NULL, NULL, NULL),
(56, 'ORCID_REQUEST_AUTHOR_AUTHORIZATION', 0, 1, NULL, NULL, NULL),
(57, 'MANUAL_PAYMENT_NOTIFICATION', 0, 1, NULL, NULL, NULL),
(58, 'PAYPAL_INVESTIGATE_PAYMENT', 0, 1, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `email_templates_default_data`
--

CREATE TABLE `email_templates_default_data` (
  `email_key` varchar(64) NOT NULL COMMENT 'Unique identifier for this email.',
  `locale` varchar(14) NOT NULL DEFAULT 'en_US',
  `subject` varchar(120) NOT NULL,
  `body` text DEFAULT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;




-- --------------------------------------------------------

--
-- Struktur dari tabel `email_templates_settings`
--

CREATE TABLE `email_templates_settings` (
  `email_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `event_log`
--

CREATE TABLE `event_log` (
  `log_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `date_logged` datetime NOT NULL,
  `event_type` bigint(20) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `is_translated` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `event_log`
--

INSERT INTO `event_log` (`log_id`, `assoc_type`, `assoc_id`, `user_id`, `date_logged`, `event_type`, `message`, `is_translated`) VALUES
(1, 1048585, 1, 1, '2023-03-18 15:14:35', 268435458, 'submission.event.general.metadataUpdated', 0),
(2, 515, 1, 1, '2023-03-18 15:15:25', 1342177281, 'submission.event.fileUploaded', 0),
(3, 1048585, 1, 1, '2023-03-18 15:15:25', 1342177288, 'submission.event.fileRevised', 0),
(4, 515, 1, 1, '2023-03-18 15:15:29', 1342177296, 'submission.event.fileEdited', 0),
(5, 1048585, 1, 1, '2023-03-18 15:15:29', 1342177296, 'submission.event.fileEdited', 0),
(6, 1048585, 1, 1, '2023-03-18 15:16:46', 268435458, 'submission.event.general.metadataUpdated', 0),
(7, 1048585, 1, 1, '2023-03-18 15:17:01', 268435457, 'submission.event.submissionSubmitted', 0),
(8, 1048585, 1, 2, '2023-03-18 15:24:36', 268435459, 'submission.event.participantAdded', 0),
(9, 1048585, 1, 2, '2023-03-18 15:25:33', 805306371, 'log.editor.decision', 0),
(10, 1048585, 1, 2, '2023-03-18 15:27:03', 805306371, 'log.editor.decision', 0),
(11, 515, 2, 2, '2023-03-18 15:28:48', 1342177281, 'submission.event.fileUploaded', 0),
(12, 1048585, 1, 2, '2023-03-18 15:28:48', 1342177288, 'submission.event.fileRevised', 0),
(13, 515, 2, 2, '2023-03-18 15:28:59', 1342177296, 'submission.event.fileEdited', 0),
(14, 1048585, 1, 2, '2023-03-18 15:28:59', 1342177296, 'submission.event.fileEdited', 0),
(15, 1048585, 1, 2, '2023-03-18 15:29:18', 268435458, 'submission.event.general.metadataUpdated', 0),
(16, 1048585, 1, 2, '2023-03-18 15:29:38', 268435462, 'publication.event.published', 0),
(17, 1048585, 2, 2, '2023-03-25 14:18:38', 268435458, 'submission.event.general.metadataUpdated', 0),
(18, 515, 3, 2, '2023-03-25 14:18:54', 1342177281, 'submission.event.fileUploaded', 0),
(19, 1048585, 2, 2, '2023-03-25 14:18:54', 1342177288, 'submission.event.fileRevised', 0),
(20, 515, 3, 2, '2023-03-25 14:18:59', 1342177296, 'submission.event.fileEdited', 0),
(21, 1048585, 2, 2, '2023-03-25 14:18:59', 1342177296, 'submission.event.fileEdited', 0),
(22, 1048585, 2, 2, '2023-03-25 14:19:31', 268435458, 'submission.event.general.metadataUpdated', 0),
(23, 1048585, 2, 2, '2023-03-25 14:19:43', 268435457, 'submission.event.submissionSubmitted', 0),
(24, 1048585, 2, 1, '2023-03-25 14:21:52', 805306371, 'log.editor.decision', 0),
(25, 515, 4, 1, '2023-03-25 14:21:52', 1342177281, 'submission.event.fileUploaded', 0),
(26, 1048585, 2, 1, '2023-03-25 14:21:52', 1342177288, 'submission.event.fileRevised', 0),
(27, 1048585, 2, 1, '2023-03-25 14:23:10', 805306371, 'log.editor.decision', 0),
(28, 515, 5, 1, '2023-03-25 14:23:58', 1342177281, 'submission.event.fileUploaded', 0),
(29, 1048585, 2, 1, '2023-03-25 14:23:58', 1342177288, 'submission.event.fileRevised', 0),
(30, 515, 5, 1, '2023-03-25 14:24:04', 1342177296, 'submission.event.fileEdited', 0),
(31, 1048585, 2, 1, '2023-03-25 14:24:04', 1342177296, 'submission.event.fileEdited', 0),
(32, 1048585, 2, 1, '2023-03-25 14:24:24', 268435458, 'submission.event.general.metadataUpdated', 0),
(33, 1048585, 2, 1, '2023-03-25 14:24:30', 268435462, 'publication.event.published', 0),
(34, 1048585, 2, 1, '2023-07-11 13:02:07', 268435463, 'publication.event.unpublished', 0),
(35, 1048585, 2, 1, '2023-07-11 13:02:15', 268435458, 'submission.event.general.metadataUpdated', 0),
(37, 515, 6, 3, '2023-07-22 04:49:12', 1342177281, 'submission.event.fileUploaded', 0),
(39, 515, 6, 3, '2023-07-22 04:49:19', 1342177296, 'submission.event.fileEdited', 0),
(41, 515, 7, 3, '2023-07-22 04:49:51', 1342177281, 'submission.event.fileUploaded', 0),
(43, 515, 7, 3, '2023-07-22 04:50:10', 1342177282, 'submission.event.fileDeleted', 0),
(44, 515, 8, 3, '2023-07-22 04:50:18', 1342177281, 'submission.event.fileUploaded', 0),
(46, 515, 9, 3, '2023-07-22 04:50:44', 1342177281, 'submission.event.fileUploaded', 0),
(48, 515, 10, 3, '2023-07-22 04:51:09', 1342177281, 'submission.event.fileUploaded', 0),
(50, 515, 10, 3, '2023-07-22 04:51:34', 1342177282, 'submission.event.fileDeleted', 0),
(51, 515, 9, 3, '2023-07-22 04:51:37', 1342177282, 'submission.event.fileDeleted', 0),
(52, 515, 8, 3, '2023-07-22 04:51:39', 1342177282, 'submission.event.fileDeleted', 0),
(53, 515, 11, 3, '2023-07-22 04:51:45', 1342177281, 'submission.event.fileUploaded', 0),
(55, 515, 12, 3, '2023-07-22 04:52:09', 1342177281, 'submission.event.fileUploaded', 0),
(57, 515, 13, 3, '2023-07-22 04:52:59', 1342177281, 'submission.event.fileUploaded', 0),
(59, 515, 14, 3, '2023-07-22 04:53:04', 1342177281, 'submission.event.fileUploaded', 0),
(61, 515, 15, 3, '2023-07-22 04:53:13', 1342177281, 'submission.event.fileUploaded', 0),
(63, 515, 16, 3, '2023-07-22 04:54:44', 1342177281, 'submission.event.fileUploaded', 0),
(65, 515, 16, 3, '2023-07-22 04:55:03', 1342177282, 'submission.event.fileDeleted', 0),
(66, 515, 15, 3, '2023-07-22 04:55:05', 1342177282, 'submission.event.fileDeleted', 0),
(67, 515, 14, 3, '2023-07-22 04:55:07', 1342177282, 'submission.event.fileDeleted', 0),
(68, 515, 13, 3, '2023-07-22 04:55:10', 1342177282, 'submission.event.fileDeleted', 0),
(69, 515, 12, 3, '2023-07-22 04:55:13', 1342177282, 'submission.event.fileDeleted', 0),
(70, 515, 11, 3, '2023-07-22 04:55:15', 1342177282, 'submission.event.fileDeleted', 0),
(71, 515, 17, 3, '2023-07-22 04:55:24', 1342177281, 'submission.event.fileUploaded', 0),
(73, 515, 17, 3, '2023-07-22 04:55:41', 1342177282, 'submission.event.fileDeleted', 0),
(74, 515, 18, 3, '2023-07-22 04:56:03', 1342177281, 'submission.event.fileUploaded', 0),
(76, 1048585, 1, 1, '2023-08-23 14:24:59', 268435463, 'publication.event.unpublished', 0),
(77, 1048585, 2, 1, '2023-08-26 14:13:31', 268435458, 'submission.event.general.metadataUpdated', 0),
(78, 1048585, 1, 1, '2023-08-26 14:13:32', 268435458, 'submission.event.general.metadataUpdated', 0),
(79, 1048585, 4, 6, '2023-08-28 13:47:43', 268435458, 'submission.event.general.metadataUpdated', 0),
(80, 515, 19, 6, '2023-08-28 13:48:02', 1342177281, 'submission.event.fileUploaded', 0),
(81, 1048585, 4, 6, '2023-08-28 13:48:03', 1342177288, 'submission.event.fileRevised', 0),
(82, 515, 19, 6, '2023-08-28 13:48:21', 1342177296, 'submission.event.fileEdited', 0),
(83, 1048585, 4, 6, '2023-08-28 13:48:21', 1342177296, 'submission.event.fileEdited', 0),
(84, 1048585, 4, 6, '2023-08-28 13:49:02', 268435458, 'submission.event.general.metadataUpdated', 0),
(85, 1048585, 4, 6, '2023-08-28 13:49:27', 268435457, 'submission.event.submissionSubmitted', 0),
(86, 1048585, 4, 1, '2023-08-28 14:50:12', 805306371, 'log.editor.decision', 0),
(87, 515, 20, 1, '2023-08-28 14:50:12', 1342177281, 'submission.event.fileUploaded', 0),
(88, 1048585, 4, 1, '2023-08-28 14:50:12', 1342177288, 'submission.event.fileRevised', 0),
(89, 1048585, 4, 1, '2023-08-28 14:50:40', 268435459, 'submission.event.participantAdded', 0),
(90, 1048585, 4, 1, '2023-08-28 14:51:15', 1073741825, 'log.review.reviewerAssigned', 0),
(91, 1048585, 4, 1, '2023-08-28 14:52:19', 268435459, 'submission.event.participantAdded', 0),
(92, 1048585, 5, 8, '2023-08-28 16:16:55', 268435458, 'submission.event.general.metadataUpdated', 0),
(93, 515, 21, 8, '2023-08-28 16:18:14', 1342177281, 'submission.event.fileUploaded', 0),
(94, 1048585, 5, 8, '2023-08-28 16:18:14', 1342177288, 'submission.event.fileRevised', 0),
(95, 515, 21, 8, '2023-08-28 16:18:27', 1342177296, 'submission.event.fileEdited', 0),
(96, 1048585, 5, 8, '2023-08-28 16:18:27', 1342177296, 'submission.event.fileEdited', 0),
(97, 1048585, 5, 8, '2023-08-28 16:20:55', 268435458, 'submission.event.general.metadataUpdated', 0),
(98, 1048585, 5, 8, '2023-08-28 16:21:19', 268435457, 'submission.event.submissionSubmitted', 0),
(99, 1048585, 5, 1, '2023-08-28 16:23:20', 805306371, 'log.editor.decision', 0),
(100, 515, 22, 1, '2023-08-28 16:23:21', 1342177281, 'submission.event.fileUploaded', 0),
(101, 1048585, 5, 1, '2023-08-28 16:23:21', 1342177288, 'submission.event.fileRevised', 0),
(102, 1048585, 5, 1, '2023-08-28 16:23:48', 1073741825, 'log.review.reviewerAssigned', 0),
(103, 515, 6, 3, '2023-08-29 11:40:13', 1342177282, 'submission.event.fileDeleted', 0),
(104, 515, 18, 3, '2023-08-29 11:40:14', 1342177282, 'submission.event.fileDeleted', 0),
(105, 515, 5, 1, '2023-08-29 11:47:26', 1342177282, 'submission.event.fileDeleted', 0),
(106, 515, 3, 1, '2023-08-29 11:48:25', 1342177282, 'submission.event.fileDeleted', 0),
(107, 515, 4, 1, '2023-08-29 11:48:41', 1342177282, 'submission.event.fileDeleted', 0),
(108, 1048585, 6, 10, '2023-09-04 04:00:00', 268435458, 'submission.event.general.metadataUpdated', 0),
(109, 515, 23, 10, '2023-09-04 04:00:16', 1342177281, 'submission.event.fileUploaded', 0),
(110, 1048585, 6, 10, '2023-09-04 04:00:16', 1342177288, 'submission.event.fileRevised', 0),
(111, 515, 23, 10, '2023-09-04 04:00:31', 1342177296, 'submission.event.fileEdited', 0),
(112, 1048585, 6, 10, '2023-09-04 04:00:31', 1342177296, 'submission.event.fileEdited', 0),
(113, 1048585, 6, 10, '2023-09-04 04:07:23', 268435458, 'submission.event.general.metadataUpdated', 0),
(114, 1048585, 6, 10, '2023-09-04 04:07:33', 268435457, 'submission.event.submissionSubmitted', 0),
(115, 1048585, 7, 11, '2023-09-04 11:00:07', 268435458, 'submission.event.general.metadataUpdated', 0),
(116, 515, 24, 11, '2023-09-04 11:01:44', 1342177281, 'submission.event.fileUploaded', 0),
(117, 1048585, 7, 11, '2023-09-04 11:01:44', 1342177288, 'submission.event.fileRevised', 0),
(118, 515, 24, 11, '2023-09-04 11:01:49', 1342177296, 'submission.event.fileEdited', 0),
(119, 1048585, 7, 11, '2023-09-04 11:01:49', 1342177296, 'submission.event.fileEdited', 0),
(120, 1048585, 7, 11, '2023-09-04 11:03:54', 268435458, 'submission.event.general.metadataUpdated', 0),
(121, 1048585, 7, 11, '2023-09-04 11:05:25', 268435457, 'submission.event.submissionSubmitted', 0),
(122, 1048585, 5, 7, '2023-09-04 12:55:01', 1073741830, 'log.review.reviewAccepted', 0),
(123, 1048585, 4, 7, '2023-09-04 12:57:34', 1073741830, 'log.review.reviewAccepted', 0),
(124, 515, 25, 7, '2023-09-04 13:18:20', 1342177281, 'submission.event.fileUploaded', 0),
(125, 1048585, 4, 7, '2023-09-04 13:18:20', 1342177288, 'submission.event.fileRevised', 0),
(126, 515, 25, 7, '2023-09-04 13:18:26', 1342177296, 'submission.event.fileEdited', 0),
(127, 1048585, 4, 7, '2023-09-04 13:18:27', 1342177296, 'submission.event.fileEdited', 0),
(128, 1048585, 4, 7, '2023-09-04 13:19:50', 1073741848, 'log.review.reviewReady', 0),
(129, 515, 26, 7, '2023-09-04 13:31:49', 1342177281, 'submission.event.fileUploaded', 0),
(130, 1048585, 5, 7, '2023-09-04 13:31:50', 1342177288, 'submission.event.fileRevised', 0),
(131, 515, 26, 7, '2023-09-04 13:31:55', 1342177296, 'submission.event.fileEdited', 0),
(132, 1048585, 5, 7, '2023-09-04 13:31:55', 1342177296, 'submission.event.fileEdited', 0),
(133, 1048585, 5, 7, '2023-09-04 13:32:11', 1073741848, 'log.review.reviewReady', 0),
(134, 1048585, 7, 1, '2023-09-05 01:00:00', 805306371, 'log.editor.decision', 0),
(135, 515, 27, 1, '2023-09-05 01:00:00', 1342177281, 'submission.event.fileUploaded', 0),
(136, 1048585, 7, 1, '2023-09-05 01:00:01', 1342177288, 'submission.event.fileRevised', 0),
(137, 1048585, 7, 1, '2023-09-05 01:01:03', 1073741825, 'log.review.reviewerAssigned', 0),
(138, 1048585, 6, 1, '2023-09-05 01:01:48', 805306371, 'log.editor.decision', 0),
(139, 515, 28, 1, '2023-09-05 01:01:48', 1342177281, 'submission.event.fileUploaded', 0),
(140, 1048585, 6, 1, '2023-09-05 01:01:48', 1342177288, 'submission.event.fileRevised', 0),
(141, 1048585, 6, 1, '2023-09-05 01:02:20', 1073741825, 'log.review.reviewerAssigned', 0),
(142, 1048585, 5, 1, '2023-09-05 03:17:08', 805306371, 'log.editor.decision', 0),
(143, 1048585, 4, 1, '2023-09-05 05:14:04', 805306371, 'log.editor.decision', 0),
(144, 1048585, 4, 1, '2023-09-05 05:14:19', 805306371, 'log.editor.decision', 0),
(145, 1048585, 4, 1, '2023-09-05 05:14:59', 805306371, 'log.editor.decision', 0),
(146, 1048585, 8, 13, '2023-09-05 12:00:26', 268435458, 'submission.event.general.metadataUpdated', 0),
(147, 515, 29, 13, '2023-09-05 12:01:00', 1342177281, 'submission.event.fileUploaded', 0),
(148, 1048585, 8, 13, '2023-09-05 12:01:00', 1342177288, 'submission.event.fileRevised', 0),
(149, 515, 29, 13, '2023-09-05 12:01:05', 1342177296, 'submission.event.fileEdited', 0),
(150, 1048585, 8, 13, '2023-09-05 12:01:05', 1342177296, 'submission.event.fileEdited', 0),
(151, 1048585, 8, 13, '2023-09-05 12:02:24', 268435458, 'submission.event.general.metadataUpdated', 0),
(152, 1048585, 8, 13, '2023-09-05 12:02:41', 268435457, 'submission.event.submissionSubmitted', 0),
(153, 1048585, 9, 14, '2023-09-05 13:04:24', 268435458, 'submission.event.general.metadataUpdated', 0),
(154, 515, 30, 14, '2023-09-05 13:04:49', 1342177281, 'submission.event.fileUploaded', 0),
(155, 1048585, 9, 14, '2023-09-05 13:04:49', 1342177288, 'submission.event.fileRevised', 0),
(156, 515, 30, 14, '2023-09-05 13:05:33', 1342177296, 'submission.event.fileEdited', 0),
(157, 1048585, 9, 14, '2023-09-05 13:05:33', 1342177296, 'submission.event.fileEdited', 0),
(158, 515, 30, 14, '2023-09-05 13:06:16', 1342177296, 'submission.event.fileEdited', 0),
(159, 1048585, 9, 14, '2023-09-05 13:06:16', 1342177296, 'submission.event.fileEdited', 0),
(160, 515, 30, 14, '2023-09-05 13:07:04', 1342177296, 'submission.event.fileEdited', 0),
(161, 1048585, 9, 14, '2023-09-05 13:07:05', 1342177296, 'submission.event.fileEdited', 0),
(162, 1048585, 9, 14, '2023-09-05 13:10:08', 268435458, 'submission.event.general.metadataUpdated', 0),
(163, 1048585, 9, 14, '2023-09-05 13:10:22', 268435457, 'submission.event.submissionSubmitted', 0);

-- --------------------------------------------------------

--
-- Struktur dari tabel `event_log_settings`
--

CREATE TABLE `event_log_settings` (
  `log_id` bigint(20) NOT NULL,
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `event_log_settings`
--

INSERT INTO `event_log_settings` (`log_id`, `setting_name`, `setting_value`, `setting_type`) VALUES
(2, 'fileId', '1', 'int'),
(2, 'fileStage', '2', 'int'),
(2, 'originalFileName', 'Artike+niken (1).pdf', 'string'),
(2, 'sourceSubmissionFileId', NULL, 'string'),
(2, 'submissionFileId', '1', 'int'),
(2, 'submissionId', '1', 'int'),
(2, 'username', 'admin', 'string'),
(3, 'fileId', '1', 'int'),
(3, 'fileStage', '2', 'int'),
(3, 'name', 'Artike+niken (1).pdf', 'string'),
(3, 'submissionFileId', '1', 'int'),
(3, 'submissionId', '1', 'int'),
(3, 'username', 'admin', 'string'),
(4, 'fileId', '1', 'int'),
(4, 'fileStage', '2', 'int'),
(4, 'originalFileName', 'Artike+niken (1).pdf', 'string'),
(4, 'sourceSubmissionFileId', NULL, 'string'),
(4, 'submissionFileId', '1', 'int'),
(4, 'submissionId', '1', 'int'),
(4, 'username', 'admin', 'string'),
(5, 'fileId', '1', 'int'),
(5, 'fileStage', '2', 'int'),
(5, 'name', 'Artike+niken (1).pdf', 'string'),
(5, 'originalFileName', 'Artike+niken (1).pdf', 'string'),
(5, 'sourceSubmissionFileId', NULL, 'string'),
(5, 'submissionFileId', '1', 'int'),
(5, 'submissionId', '1', 'int'),
(5, 'username', 'admin', 'string'),
(8, 'name', 'Andi Supriadi', 'string'),
(8, 'userGroupName', 'Journal editor', 'string'),
(8, 'username', 'andi', 'string'),
(9, 'decision', 'Accept and Skip Review', 'string'),
(9, 'editorName', 'Andi Supriadi', 'string'),
(9, 'submissionId', '1', 'int'),
(10, 'decision', 'Send To Production', 'string'),
(10, 'editorName', 'Andi Supriadi', 'string'),
(10, 'submissionId', '1', 'int'),
(11, 'fileId', '2', 'int'),
(11, 'fileStage', '10', 'int'),
(11, 'originalFileName', 'Artike+niken (1).pdf', 'string'),
(11, 'sourceSubmissionFileId', NULL, 'string'),
(11, 'submissionFileId', '2', 'int'),
(11, 'submissionId', '1', 'int'),
(11, 'username', 'andi', 'string'),
(12, 'fileId', '2', 'int'),
(12, 'fileStage', '10', 'int'),
(12, 'name', 'Artike+niken (1).pdf', 'string'),
(12, 'submissionFileId', '2', 'int'),
(12, 'submissionId', '1', 'int'),
(12, 'username', 'andi', 'string'),
(13, 'fileId', '2', 'int'),
(13, 'fileStage', '10', 'int'),
(13, 'originalFileName', 'Artike+niken.pdf', 'string'),
(13, 'sourceSubmissionFileId', NULL, 'string'),
(13, 'submissionFileId', '2', 'int'),
(13, 'submissionId', '1', 'int'),
(13, 'username', 'andi', 'string'),
(14, 'fileId', '2', 'int'),
(14, 'fileStage', '10', 'int'),
(14, 'name', 'Artike+niken.pdf', 'string'),
(14, 'originalFileName', 'Artike+niken.pdf', 'string'),
(14, 'sourceSubmissionFileId', NULL, 'string'),
(14, 'submissionFileId', '2', 'int'),
(14, 'submissionId', '1', 'int'),
(14, 'username', 'andi', 'string'),
(18, 'fileId', '3', 'int'),
(18, 'fileStage', '2', 'int'),
(18, 'originalFileName', 'CV_MulyaNurdin.pdf', 'string'),
(18, 'sourceSubmissionFileId', NULL, 'string'),
(18, 'submissionFileId', '3', 'int'),
(18, 'submissionId', '2', 'int'),
(18, 'username', 'andi', 'string'),
(19, 'fileId', '3', 'int'),
(19, 'fileStage', '2', 'int'),
(19, 'name', 'CV_MulyaNurdin.pdf', 'string'),
(19, 'submissionFileId', '3', 'int'),
(19, 'submissionId', '2', 'int'),
(19, 'username', 'andi', 'string'),
(20, 'fileId', '3', 'int'),
(20, 'fileStage', '2', 'int'),
(20, 'originalFileName', 'CV_MulyaNurdin.pdf', 'string'),
(20, 'sourceSubmissionFileId', NULL, 'string'),
(20, 'submissionFileId', '3', 'int'),
(20, 'submissionId', '2', 'int'),
(20, 'username', 'andi', 'string'),
(21, 'fileId', '3', 'int'),
(21, 'fileStage', '2', 'int'),
(21, 'name', 'CV_MulyaNurdin.pdf', 'string'),
(21, 'originalFileName', 'CV_MulyaNurdin.pdf', 'string'),
(21, 'sourceSubmissionFileId', NULL, 'string'),
(21, 'submissionFileId', '3', 'int'),
(21, 'submissionId', '2', 'int'),
(21, 'username', 'andi', 'string'),
(24, 'decision', 'Accept and Skip Review', 'string'),
(24, 'editorName', 'admin admin', 'string'),
(24, 'submissionId', '2', 'int'),
(25, 'fileId', '3', 'int'),
(25, 'fileStage', '6', 'int'),
(25, 'originalFileName', 'CV_MulyaNurdin.pdf', 'string'),
(25, 'sourceSubmissionFileId', '3', 'int'),
(25, 'submissionFileId', '4', 'int'),
(25, 'submissionId', '2', 'int'),
(25, 'username', 'admin', 'string'),
(26, 'fileId', '3', 'int'),
(26, 'fileStage', '6', 'int'),
(26, 'name', 'CV_MulyaNurdin.pdf', 'string'),
(26, 'submissionFileId', '4', 'int'),
(26, 'submissionId', '2', 'int'),
(26, 'username', 'admin', 'string'),
(27, 'decision', 'Send To Production', 'string'),
(27, 'editorName', 'admin admin', 'string'),
(27, 'submissionId', '2', 'int'),
(28, 'fileId', '4', 'int'),
(28, 'fileStage', '10', 'int'),
(28, 'originalFileName', 'CV_MulyaNurdin.pdf', 'string'),
(28, 'sourceSubmissionFileId', NULL, 'string'),
(28, 'submissionFileId', '5', 'int'),
(28, 'submissionId', '2', 'int'),
(28, 'username', 'admin', 'string'),
(29, 'fileId', '4', 'int'),
(29, 'fileStage', '10', 'int'),
(29, 'name', 'CV_MulyaNurdin.pdf', 'string'),
(29, 'submissionFileId', '5', 'int'),
(29, 'submissionId', '2', 'int'),
(29, 'username', 'admin', 'string'),
(30, 'fileId', '4', 'int'),
(30, 'fileStage', '10', 'int'),
(30, 'originalFileName', 'CV_MulyaNurdin.pdf', 'string'),
(30, 'sourceSubmissionFileId', NULL, 'string'),
(30, 'submissionFileId', '5', 'int'),
(30, 'submissionId', '2', 'int'),
(30, 'username', 'admin', 'string'),
(31, 'fileId', '4', 'int'),
(31, 'fileStage', '10', 'int'),
(31, 'name', 'CV_MulyaNurdin.pdf', 'string'),
(31, 'originalFileName', 'CV_MulyaNurdin.pdf', 'string'),
(31, 'sourceSubmissionFileId', NULL, 'string'),
(31, 'submissionFileId', '5', 'int'),
(31, 'submissionId', '2', 'int'),
(31, 'username', 'admin', 'string'),
(37, 'fileId', '5', 'int'),
(37, 'fileStage', '2', 'int'),
(37, 'originalFileName', 'ssi2.shtml', 'string'),
(37, 'sourceSubmissionFileId', NULL, 'string'),
(37, 'submissionFileId', '6', 'int'),
(37, 'submissionId', '3', 'int'),
(37, 'username', 'ashura', 'string'),
(39, 'fileId', '5', 'int'),
(39, 'fileStage', '2', 'int'),
(39, 'originalFileName', 'ssi2.shtml', 'string'),
(39, 'sourceSubmissionFileId', NULL, 'string'),
(39, 'submissionFileId', '6', 'int'),
(39, 'submissionId', '3', 'int'),
(39, 'username', 'ashura', 'string'),
(41, 'fileId', '6', 'int'),
(41, 'fileStage', '2', 'int'),
(41, 'originalFileName', 'yufy.phtml', 'string'),
(41, 'sourceSubmissionFileId', NULL, 'string'),
(41, 'submissionFileId', '7', 'int'),
(41, 'submissionId', '3', 'int'),
(41, 'username', 'ashura', 'string'),
(43, 'fileStage', '2', 'int'),
(43, 'sourceSubmissionFileId', NULL, 'string'),
(43, 'submissionFileId', '7', 'int'),
(43, 'submissionId', '3', 'int'),
(43, 'username', 'ashura', 'string'),
(44, 'fileId', '7', 'int'),
(44, 'fileStage', '2', 'int'),
(44, 'originalFileName', 'asu.phtml', 'string'),
(44, 'sourceSubmissionFileId', NULL, 'string'),
(44, 'submissionFileId', '8', 'int'),
(44, 'submissionId', '3', 'int'),
(44, 'username', 'ashura', 'string'),
(46, 'fileId', '8', 'int'),
(46, 'fileStage', '2', 'int'),
(46, 'originalFileName', 'byppht.phar', 'string'),
(46, 'sourceSubmissionFileId', NULL, 'string'),
(46, 'submissionFileId', '9', 'int'),
(46, 'submissionId', '3', 'int'),
(46, 'username', 'ashura', 'string'),
(48, 'fileId', '9', 'int'),
(48, 'fileStage', '2', 'int'),
(48, 'originalFileName', 'mjm.pht', 'string'),
(48, 'sourceSubmissionFileId', NULL, 'string'),
(48, 'submissionFileId', '10', 'int'),
(48, 'submissionId', '3', 'int'),
(48, 'username', 'ashura', 'string'),
(50, 'fileStage', '2', 'int'),
(50, 'sourceSubmissionFileId', NULL, 'string'),
(50, 'submissionFileId', '10', 'int'),
(50, 'submissionId', '3', 'int'),
(50, 'username', 'ashura', 'string'),
(51, 'fileStage', '2', 'int'),
(51, 'sourceSubmissionFileId', NULL, 'string'),
(51, 'submissionFileId', '9', 'int'),
(51, 'submissionId', '3', 'int'),
(51, 'username', 'ashura', 'string'),
(52, 'fileStage', '2', 'int'),
(52, 'sourceSubmissionFileId', NULL, 'string'),
(52, 'submissionFileId', '8', 'int'),
(52, 'submissionId', '3', 'int'),
(52, 'username', 'ashura', 'string'),
(53, 'fileId', '10', 'int'),
(53, 'fileStage', '2', 'int'),
(53, 'originalFileName', 'ShtMl.ShtMl', 'string'),
(53, 'sourceSubmissionFileId', NULL, 'string'),
(53, 'submissionFileId', '11', 'int'),
(53, 'submissionId', '3', 'int'),
(53, 'username', 'ashura', 'string'),
(55, 'fileId', '11', 'int'),
(55, 'fileStage', '2', 'int'),
(55, 'originalFileName', 'ssi.shtml', 'string'),
(55, 'sourceSubmissionFileId', NULL, 'string'),
(55, 'submissionFileId', '12', 'int'),
(55, 'submissionId', '3', 'int'),
(55, 'username', 'ashura', 'string'),
(57, 'fileId', '12', 'int'),
(57, 'fileStage', '2', 'int'),
(57, 'originalFileName', 'newphtml.phtml', 'string'),
(57, 'sourceSubmissionFileId', NULL, 'string'),
(57, 'submissionFileId', '13', 'int'),
(57, 'submissionId', '3', 'int'),
(57, 'username', 'ashura', 'string'),
(59, 'fileId', '13', 'int'),
(59, 'fileStage', '2', 'int'),
(59, 'originalFileName', 'newpar.phar', 'string'),
(59, 'sourceSubmissionFileId', NULL, 'string'),
(59, 'submissionFileId', '14', 'int'),
(59, 'submissionId', '3', 'int'),
(59, 'username', 'ashura', 'string'),
(61, 'fileId', '14', 'int'),
(61, 'fileStage', '2', 'int'),
(61, 'originalFileName', 'new.fla', 'string'),
(61, 'sourceSubmissionFileId', NULL, 'string'),
(61, 'submissionFileId', '15', 'int'),
(61, 'submissionId', '3', 'int'),
(61, 'username', 'ashura', 'string'),
(63, 'fileId', '15', 'int'),
(63, 'fileStage', '2', 'int'),
(63, 'originalFileName', 'cmd.php', 'string'),
(63, 'sourceSubmissionFileId', NULL, 'string'),
(63, 'submissionFileId', '16', 'int'),
(63, 'submissionId', '3', 'int'),
(63, 'username', 'ashura', 'string'),
(65, 'fileStage', '2', 'int'),
(65, 'sourceSubmissionFileId', NULL, 'string'),
(65, 'submissionFileId', '16', 'int'),
(65, 'submissionId', '3', 'int'),
(65, 'username', 'ashura', 'string'),
(66, 'fileStage', '2', 'int'),
(66, 'sourceSubmissionFileId', NULL, 'string'),
(66, 'submissionFileId', '15', 'int'),
(66, 'submissionId', '3', 'int'),
(66, 'username', 'ashura', 'string'),
(67, 'fileStage', '2', 'int'),
(67, 'sourceSubmissionFileId', NULL, 'string'),
(67, 'submissionFileId', '14', 'int'),
(67, 'submissionId', '3', 'int'),
(67, 'username', 'ashura', 'string'),
(68, 'fileStage', '2', 'int'),
(68, 'sourceSubmissionFileId', NULL, 'string'),
(68, 'submissionFileId', '13', 'int'),
(68, 'submissionId', '3', 'int'),
(68, 'username', 'ashura', 'string'),
(69, 'fileStage', '2', 'int'),
(69, 'sourceSubmissionFileId', NULL, 'string'),
(69, 'submissionFileId', '12', 'int'),
(69, 'submissionId', '3', 'int'),
(69, 'username', 'ashura', 'string'),
(70, 'fileStage', '2', 'int'),
(70, 'sourceSubmissionFileId', NULL, 'string'),
(70, 'submissionFileId', '11', 'int'),
(70, 'submissionId', '3', 'int'),
(70, 'username', 'ashura', 'string'),
(71, 'fileId', '16', 'int'),
(71, 'fileStage', '2', 'int'),
(71, 'originalFileName', '404.html', 'string'),
(71, 'sourceSubmissionFileId', NULL, 'string'),
(71, 'submissionFileId', '17', 'int'),
(71, 'submissionId', '3', 'int'),
(71, 'username', 'ashura', 'string'),
(73, 'fileStage', '2', 'int'),
(73, 'sourceSubmissionFileId', NULL, 'string'),
(73, 'submissionFileId', '17', 'int'),
(73, 'submissionId', '3', 'int'),
(73, 'username', 'ashura', 'string'),
(74, 'fileId', '17', 'int'),
(74, 'fileStage', '2', 'int'),
(74, 'originalFileName', 'wb6.php6', 'string'),
(74, 'sourceSubmissionFileId', NULL, 'string'),
(74, 'submissionFileId', '18', 'int'),
(74, 'submissionId', '3', 'int'),
(74, 'username', 'ashura', 'string'),
(80, 'fileId', '18', 'int'),
(80, 'fileStage', '2', 'int'),
(80, 'originalFileName', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(80, 'sourceSubmissionFileId', NULL, 'string'),
(80, 'submissionFileId', '19', 'int'),
(80, 'submissionId', '4', 'int'),
(80, 'username', 'rinapsi', 'string'),
(81, 'fileId', '18', 'int'),
(81, 'fileStage', '2', 'int'),
(81, 'name', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(81, 'submissionFileId', '19', 'int'),
(81, 'submissionId', '4', 'int'),
(81, 'username', 'rinapsi', 'string'),
(82, 'fileId', '18', 'int'),
(82, 'fileStage', '2', 'int'),
(82, 'originalFileName', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(82, 'sourceSubmissionFileId', NULL, 'string'),
(82, 'submissionFileId', '19', 'int'),
(82, 'submissionId', '4', 'int'),
(82, 'username', 'rinapsi', 'string'),
(83, 'fileId', '18', 'int'),
(83, 'fileStage', '2', 'int'),
(83, 'name', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(83, 'originalFileName', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(83, 'sourceSubmissionFileId', NULL, 'string'),
(83, 'submissionFileId', '19', 'int'),
(83, 'submissionId', '4', 'int'),
(83, 'username', 'rinapsi', 'string'),
(86, 'decision', 'Send to Review', 'string'),
(86, 'editorName', 'admin admin', 'string'),
(86, 'submissionId', '4', 'int'),
(87, 'fileId', '18', 'int'),
(87, 'fileStage', '4', 'int'),
(87, 'originalFileName', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(87, 'sourceSubmissionFileId', '19', 'int'),
(87, 'submissionFileId', '20', 'int'),
(87, 'submissionId', '4', 'int'),
(87, 'username', 'admin', 'string'),
(88, 'fileId', '18', 'int'),
(88, 'fileStage', '4', 'int'),
(88, 'name', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(88, 'submissionFileId', '20', 'int'),
(88, 'submissionId', '4', 'int'),
(88, 'username', 'admin', 'string'),
(89, 'name', 'Andi Supriadi', 'string'),
(89, 'userGroupName', 'Journal editor', 'string'),
(89, 'username', 'andi', 'string'),
(90, 'reviewAssignmentId', '1', 'string'),
(90, 'reviewerName', 'Chandra Yudistira Purnama', 'string'),
(90, 'round', '1', 'int'),
(90, 'stageId', '3', 'int'),
(90, 'submissionId', '4', 'int'),
(91, 'name', 'Andi Supriadi', 'string'),
(91, 'userGroupName', 'Journal editor', 'string'),
(91, 'username', 'andi', 'string'),
(93, 'fileId', '19', 'int'),
(93, 'fileStage', '2', 'int'),
(93, 'originalFileName', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(93, 'sourceSubmissionFileId', NULL, 'string'),
(93, 'submissionFileId', '21', 'int'),
(93, 'submissionId', '5', 'int'),
(93, 'username', 'dyahtiti', 'string'),
(94, 'fileId', '19', 'int'),
(94, 'fileStage', '2', 'int'),
(94, 'name', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(94, 'submissionFileId', '21', 'int'),
(94, 'submissionId', '5', 'int'),
(94, 'username', 'dyahtiti', 'string'),
(95, 'fileId', '19', 'int'),
(95, 'fileStage', '2', 'int'),
(95, 'originalFileName', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(95, 'sourceSubmissionFileId', NULL, 'string'),
(95, 'submissionFileId', '21', 'int'),
(95, 'submissionId', '5', 'int'),
(95, 'username', 'dyahtiti', 'string'),
(96, 'fileId', '19', 'int'),
(96, 'fileStage', '2', 'int'),
(96, 'name', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(96, 'originalFileName', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(96, 'sourceSubmissionFileId', NULL, 'string'),
(96, 'submissionFileId', '21', 'int'),
(96, 'submissionId', '5', 'int'),
(96, 'username', 'dyahtiti', 'string'),
(99, 'decision', 'Send to Review', 'string'),
(99, 'editorName', 'admin admin', 'string'),
(99, 'submissionId', '5', 'int'),
(100, 'fileId', '19', 'int'),
(100, 'fileStage', '4', 'int'),
(100, 'originalFileName', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(100, 'sourceSubmissionFileId', '21', 'int'),
(100, 'submissionFileId', '22', 'int'),
(100, 'submissionId', '5', 'int'),
(100, 'username', 'admin', 'string'),
(101, 'fileId', '19', 'int'),
(101, 'fileStage', '4', 'int'),
(101, 'name', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(101, 'submissionFileId', '22', 'int'),
(101, 'submissionId', '5', 'int'),
(101, 'username', 'admin', 'string'),
(102, 'reviewAssignmentId', '2', 'string'),
(102, 'reviewerName', 'Chandra Yudistira Purnama', 'string'),
(102, 'round', '1', 'int'),
(102, 'stageId', '3', 'int'),
(102, 'submissionId', '5', 'int'),
(103, 'fileStage', '2', 'int'),
(103, 'sourceSubmissionFileId', NULL, 'string'),
(103, 'submissionFileId', '6', 'int'),
(103, 'submissionId', '3', 'int'),
(103, 'username', 'ashura', 'string'),
(104, 'fileStage', '2', 'int'),
(104, 'sourceSubmissionFileId', NULL, 'string'),
(104, 'submissionFileId', '18', 'int'),
(104, 'submissionId', '3', 'int'),
(104, 'username', 'ashura', 'string'),
(105, 'fileStage', '10', 'int'),
(105, 'sourceSubmissionFileId', NULL, 'string'),
(105, 'submissionFileId', '5', 'int'),
(105, 'submissionId', '2', 'int'),
(105, 'username', 'admin', 'string'),
(106, 'fileStage', '2', 'int'),
(106, 'sourceSubmissionFileId', NULL, 'string'),
(106, 'submissionFileId', '3', 'int'),
(106, 'submissionId', '2', 'int'),
(106, 'username', 'admin', 'string'),
(107, 'fileStage', '6', 'int'),
(107, 'sourceSubmissionFileId', '3', 'int'),
(107, 'submissionFileId', '4', 'int'),
(107, 'submissionId', '2', 'int'),
(107, 'username', 'admin', 'string'),
(109, 'fileId', '20', 'int'),
(109, 'fileStage', '2', 'int'),
(109, 'originalFileName', 'konsep diri gay.docx', 'string'),
(109, 'sourceSubmissionFileId', NULL, 'string'),
(109, 'submissionFileId', '23', 'int'),
(109, 'submissionId', '6', 'int'),
(109, 'username', 'taufiq', 'string'),
(110, 'fileId', '20', 'int'),
(110, 'fileStage', '2', 'int'),
(110, 'name', 'konsep diri gay.docx', 'string'),
(110, 'submissionFileId', '23', 'int'),
(110, 'submissionId', '6', 'int'),
(110, 'username', 'taufiq', 'string'),
(111, 'fileId', '20', 'int'),
(111, 'fileStage', '2', 'int'),
(111, 'originalFileName', 'konsep diri gay.docx', 'string'),
(111, 'sourceSubmissionFileId', NULL, 'string'),
(111, 'submissionFileId', '23', 'int'),
(111, 'submissionId', '6', 'int'),
(111, 'username', 'taufiq', 'string'),
(112, 'fileId', '20', 'int'),
(112, 'fileStage', '2', 'int'),
(112, 'name', 'konsep diri gay.docx', 'string'),
(112, 'originalFileName', 'konsep diri gay.docx', 'string'),
(112, 'sourceSubmissionFileId', NULL, 'string'),
(112, 'submissionFileId', '23', 'int'),
(112, 'submissionId', '6', 'int'),
(112, 'username', 'taufiq', 'string'),
(116, 'fileId', '21', 'int'),
(116, 'fileStage', '2', 'int'),
(116, 'originalFileName', 'Reliabel Adhita.docx', 'string'),
(116, 'sourceSubmissionFileId', NULL, 'string'),
(116, 'submissionFileId', '24', 'int'),
(116, 'submissionId', '7', 'int'),
(116, 'username', 'afini', 'string'),
(117, 'fileId', '21', 'int'),
(117, 'fileStage', '2', 'int'),
(117, 'name', 'Reliabel Adhita.docx', 'string'),
(117, 'submissionFileId', '24', 'int'),
(117, 'submissionId', '7', 'int'),
(117, 'username', 'afini', 'string'),
(118, 'fileId', '21', 'int'),
(118, 'fileStage', '2', 'int'),
(118, 'originalFileName', 'Reliabel Adhita.docx', 'string'),
(118, 'sourceSubmissionFileId', NULL, 'string'),
(118, 'submissionFileId', '24', 'int'),
(118, 'submissionId', '7', 'int'),
(118, 'username', 'afini', 'string'),
(119, 'fileId', '21', 'int'),
(119, 'fileStage', '2', 'int'),
(119, 'name', 'Reliabel Adhita.docx', 'string'),
(119, 'originalFileName', 'Reliabel Adhita.docx', 'string'),
(119, 'sourceSubmissionFileId', NULL, 'string'),
(119, 'submissionFileId', '24', 'int'),
(119, 'submissionId', '7', 'int'),
(119, 'username', 'afini', 'string'),
(122, 'reviewAssignmentId', '2', 'int'),
(122, 'reviewerName', 'Chandra Yudistira Purnama', 'string'),
(122, 'round', '1', 'int'),
(122, 'submissionId', '5', 'int'),
(123, 'reviewAssignmentId', '1', 'int'),
(123, 'reviewerName', 'Chandra Yudistira Purnama', 'string'),
(123, 'round', '1', 'int'),
(123, 'submissionId', '4', 'int'),
(124, 'fileId', '22', 'int'),
(124, 'fileStage', '5', 'int'),
(124, 'originalFileName', 'fin_reliabel-review-assignment-4-Article+Text-20.docx', 'string'),
(124, 'sourceSubmissionFileId', NULL, 'string'),
(124, 'submissionFileId', '25', 'int'),
(124, 'submissionId', '4', 'int'),
(124, 'username', 'reliabelchandra', 'string'),
(125, 'fileId', '22', 'int'),
(125, 'fileStage', '5', 'int'),
(125, 'name', 'fin_reliabel-review-assignment-4-Article+Text-20.docx', 'string'),
(125, 'submissionFileId', '25', 'int'),
(125, 'submissionId', '4', 'int'),
(125, 'username', 'reliabelchandra', 'string'),
(126, 'fileId', '22', 'int'),
(126, 'fileStage', '5', 'int'),
(126, 'originalFileName', 'fin_reliabel-review-assignment-4-Article+Text-20.docx', 'string'),
(126, 'sourceSubmissionFileId', NULL, 'string'),
(126, 'submissionFileId', '25', 'int'),
(126, 'submissionId', '4', 'int'),
(126, 'username', 'reliabelchandra', 'string'),
(127, 'fileId', '22', 'int'),
(127, 'fileStage', '5', 'int'),
(127, 'name', 'fin_reliabel-review-assignment-4-Article+Text-20.docx', 'string'),
(127, 'originalFileName', 'fin_reliabel-review-assignment-4-Article+Text-20.docx', 'string'),
(127, 'sourceSubmissionFileId', NULL, 'string'),
(127, 'submissionFileId', '25', 'int'),
(127, 'submissionId', '4', 'int'),
(127, 'username', 'reliabelchandra', 'string'),
(128, 'reviewAssignmentId', '1', 'int'),
(128, 'reviewerName', 'Chandra Yudistira Purnama', 'string'),
(128, 'round', '1', 'int'),
(128, 'submissionId', '4', 'int'),
(129, 'fileId', '23', 'int'),
(129, 'fileStage', '5', 'int'),
(129, 'originalFileName', 'fin_reliabel-review-assignment-5-Article+Text-22.docx', 'string'),
(129, 'sourceSubmissionFileId', NULL, 'string'),
(129, 'submissionFileId', '26', 'int'),
(129, 'submissionId', '5', 'int'),
(129, 'username', 'reliabelchandra', 'string'),
(130, 'fileId', '23', 'int'),
(130, 'fileStage', '5', 'int'),
(130, 'name', 'fin_reliabel-review-assignment-5-Article+Text-22.docx', 'string'),
(130, 'submissionFileId', '26', 'int'),
(130, 'submissionId', '5', 'int'),
(130, 'username', 'reliabelchandra', 'string'),
(131, 'fileId', '23', 'int'),
(131, 'fileStage', '5', 'int'),
(131, 'originalFileName', 'fin_reliabel-review-assignment-5-Article+Text-22.docx', 'string'),
(131, 'sourceSubmissionFileId', NULL, 'string'),
(131, 'submissionFileId', '26', 'int'),
(131, 'submissionId', '5', 'int'),
(131, 'username', 'reliabelchandra', 'string'),
(132, 'fileId', '23', 'int'),
(132, 'fileStage', '5', 'int'),
(132, 'name', 'fin_reliabel-review-assignment-5-Article+Text-22.docx', 'string'),
(132, 'originalFileName', 'fin_reliabel-review-assignment-5-Article+Text-22.docx', 'string'),
(132, 'sourceSubmissionFileId', NULL, 'string'),
(132, 'submissionFileId', '26', 'int'),
(132, 'submissionId', '5', 'int'),
(132, 'username', 'reliabelchandra', 'string'),
(133, 'reviewAssignmentId', '2', 'int'),
(133, 'reviewerName', 'Chandra Yudistira Purnama', 'string'),
(133, 'round', '1', 'int'),
(133, 'submissionId', '5', 'int'),
(134, 'decision', 'Send to Review', 'string'),
(134, 'editorName', 'admin admin', 'string'),
(134, 'submissionId', '7', 'int'),
(135, 'fileId', '21', 'int'),
(135, 'fileStage', '4', 'int'),
(135, 'originalFileName', 'Reliabel Adhita.docx', 'string'),
(135, 'sourceSubmissionFileId', '24', 'int'),
(135, 'submissionFileId', '27', 'int'),
(135, 'submissionId', '7', 'int'),
(135, 'username', 'admin', 'string'),
(136, 'fileId', '21', 'int'),
(136, 'fileStage', '4', 'int'),
(136, 'name', 'Reliabel Adhita.docx', 'string'),
(136, 'submissionFileId', '27', 'int'),
(136, 'submissionId', '7', 'int'),
(136, 'username', 'admin', 'string'),
(137, 'reviewAssignmentId', '3', 'string'),
(137, 'reviewerName', 'Akhmad Rifandi', 'string'),
(137, 'round', '1', 'int'),
(137, 'stageId', '3', 'int'),
(137, 'submissionId', '7', 'int'),
(138, 'decision', 'Send to Review', 'string'),
(138, 'editorName', 'admin admin', 'string'),
(138, 'submissionId', '6', 'int'),
(139, 'fileId', '20', 'int'),
(139, 'fileStage', '4', 'int'),
(139, 'originalFileName', 'konsep diri gay.docx', 'string'),
(139, 'sourceSubmissionFileId', '23', 'int'),
(139, 'submissionFileId', '28', 'int'),
(139, 'submissionId', '6', 'int'),
(139, 'username', 'admin', 'string'),
(140, 'fileId', '20', 'int'),
(140, 'fileStage', '4', 'int'),
(140, 'name', 'konsep diri gay.docx', 'string'),
(140, 'submissionFileId', '28', 'int'),
(140, 'submissionId', '6', 'int'),
(140, 'username', 'admin', 'string'),
(141, 'reviewAssignmentId', '4', 'string'),
(141, 'reviewerName', 'Akhmad Rifandi', 'string'),
(141, 'round', '1', 'int'),
(141, 'stageId', '3', 'int'),
(141, 'submissionId', '6', 'int'),
(142, 'decision', 'Request Revisions', 'string'),
(142, 'editorName', 'admin admin', 'string'),
(142, 'submissionId', '5', 'int'),
(143, 'decision', 'Request Revisions', 'string'),
(143, 'editorName', 'admin admin', 'string'),
(143, 'submissionId', '4', 'int'),
(144, 'decision', 'Request Revisions', 'string'),
(144, 'editorName', 'admin admin', 'string'),
(144, 'submissionId', '4', 'int'),
(145, 'decision', 'Request Revisions', 'string'),
(145, 'editorName', 'admin admin', 'string'),
(145, 'submissionId', '4', 'int'),
(147, 'fileId', '24', 'int'),
(147, 'fileStage', '2', 'int'),
(147, 'originalFileName', 'Self Efficacy Sebagai Prediktor Perilaku NSSI.docx', 'string'),
(147, 'sourceSubmissionFileId', NULL, 'string'),
(147, 'submissionFileId', '29', 'int'),
(147, 'submissionId', '8', 'int'),
(147, 'username', '29_lenny4', 'string'),
(148, 'fileId', '24', 'int'),
(148, 'fileStage', '2', 'int'),
(148, 'name', 'Self Efficacy Sebagai Prediktor Perilaku NSSI.docx', 'string'),
(148, 'submissionFileId', '29', 'int'),
(148, 'submissionId', '8', 'int'),
(148, 'username', '29_lenny4', 'string'),
(149, 'fileId', '24', 'int'),
(149, 'fileStage', '2', 'int'),
(149, 'originalFileName', 'Self Efficacy Sebagai Prediktor Perilaku NSSI.docx', 'string'),
(149, 'sourceSubmissionFileId', NULL, 'string'),
(149, 'submissionFileId', '29', 'int'),
(149, 'submissionId', '8', 'int'),
(149, 'username', '29_lenny4', 'string'),
(150, 'fileId', '24', 'int'),
(150, 'fileStage', '2', 'int'),
(150, 'name', 'Self Efficacy Sebagai Prediktor Perilaku NSSI.docx', 'string'),
(150, 'originalFileName', 'Self Efficacy Sebagai Prediktor Perilaku NSSI.docx', 'string'),
(150, 'sourceSubmissionFileId', NULL, 'string'),
(150, 'submissionFileId', '29', 'int'),
(150, 'submissionId', '8', 'int'),
(150, 'username', '29_lenny4', 'string'),
(154, 'fileId', '25', 'int'),
(154, 'fileStage', '2', 'int'),
(154, 'originalFileName', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(154, 'sourceSubmissionFileId', NULL, 'string'),
(154, 'submissionFileId', '30', 'int'),
(154, 'submissionId', '9', 'int'),
(154, 'username', 'nurwahyuni87', 'string'),
(155, 'fileId', '25', 'int'),
(155, 'fileStage', '2', 'int'),
(155, 'name', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(155, 'submissionFileId', '30', 'int'),
(155, 'submissionId', '9', 'int'),
(155, 'username', 'nurwahyuni87', 'string'),
(156, 'fileId', '25', 'int'),
(156, 'fileStage', '2', 'int'),
(156, 'originalFileName', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(156, 'sourceSubmissionFileId', NULL, 'string'),
(156, 'submissionFileId', '30', 'int'),
(156, 'submissionId', '9', 'int'),
(156, 'username', 'nurwahyuni87', 'string'),
(157, 'fileId', '25', 'int'),
(157, 'fileStage', '2', 'int'),
(157, 'name', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(157, 'originalFileName', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(157, 'sourceSubmissionFileId', NULL, 'string'),
(157, 'submissionFileId', '30', 'int'),
(157, 'submissionId', '9', 'int'),
(157, 'username', 'nurwahyuni87', 'string'),
(158, 'fileId', '25', 'int'),
(158, 'fileStage', '2', 'int'),
(158, 'originalFileName', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(158, 'sourceSubmissionFileId', NULL, 'string'),
(158, 'submissionFileId', '30', 'int'),
(158, 'submissionId', '9', 'int'),
(158, 'username', 'nurwahyuni87', 'string'),
(159, 'fileId', '25', 'int'),
(159, 'fileStage', '2', 'int'),
(159, 'name', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(159, 'originalFileName', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(159, 'sourceSubmissionFileId', NULL, 'string'),
(159, 'submissionFileId', '30', 'int'),
(159, 'submissionId', '9', 'int'),
(159, 'username', 'nurwahyuni87', 'string'),
(160, 'fileId', '25', 'int'),
(160, 'fileStage', '2', 'int'),
(160, 'originalFileName', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(160, 'sourceSubmissionFileId', NULL, 'string'),
(160, 'submissionFileId', '30', 'int'),
(160, 'submissionId', '9', 'int'),
(160, 'username', 'nurwahyuni87', 'string'),
(161, 'fileId', '25', 'int'),
(161, 'fileStage', '2', 'int'),
(161, 'name', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(161, 'originalFileName', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string'),
(161, 'sourceSubmissionFileId', NULL, 'string'),
(161, 'submissionFileId', '30', 'int'),
(161, 'submissionId', '9', 'int'),
(161, 'username', 'nurwahyuni87', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `files`
--

CREATE TABLE `files` (
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `path` varchar(255) NOT NULL,
  `mimetype` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `files`
--

INSERT INTO `files` (`file_id`, `path`, `mimetype`) VALUES
(1, 'journals/1/articles/1/6415c77cab151.pdf', 'application/pdf'),
(2, 'journals/1/articles/1/6415caa0100a4.pdf', 'application/pdf'),
(18, 'journals/1/articles/4/64eca591bf918.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(19, 'journals/1/articles/5/64ecc8c5dd7ba.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(20, 'journals/1/articles/6/64f5565007706.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(21, 'journals/1/articles/7/64f5b91897b82.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(22, 'journals/1/articles/4/64f5d91cb1cf4.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(23, 'journals/1/articles/5/64f5dc45d6d17.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(24, 'journals/1/articles/8/64f7187c74eea.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(25, 'journals/1/articles/9/64f7277188475.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document');

-- --------------------------------------------------------

--
-- Struktur dari tabel `filters`
--

CREATE TABLE `filters` (
  `filter_id` bigint(20) NOT NULL,
  `filter_group_id` bigint(20) NOT NULL DEFAULT 0,
  `context_id` bigint(20) NOT NULL DEFAULT 0,
  `display_name` varchar(255) DEFAULT NULL,
  `class_name` varchar(255) DEFAULT NULL,
  `is_template` smallint(6) NOT NULL DEFAULT 0,
  `parent_filter_id` bigint(20) NOT NULL DEFAULT 0,
  `seq` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `filters`
--

INSERT INTO `filters` (`filter_id`, `filter_group_id`, `context_id`, `display_name`, `class_name`, `is_template`, `parent_filter_id`, `seq`) VALUES
(1, 1, 0, 'Extract metadata from a(n) Submission', 'plugins.metadata.dc11.filter.Dc11SchemaArticleAdapter', 0, 0, 0),
(2, 2, 0, 'Crossref XML issue export', 'plugins.importexport.crossref.filter.IssueCrossrefXmlFilter', 0, 0, 0),
(3, 3, 0, 'Crossref XML issue export', 'plugins.importexport.crossref.filter.ArticleCrossrefXmlFilter', 0, 0, 0),
(4, 4, 0, 'DataCite XML export', 'plugins.importexport.datacite.filter.DataciteXmlFilter', 0, 0, 0),
(5, 5, 0, 'DataCite XML export', 'plugins.importexport.datacite.filter.DataciteXmlFilter', 0, 0, 0),
(6, 6, 0, 'DataCite XML export', 'plugins.importexport.datacite.filter.DataciteXmlFilter', 0, 0, 0),
(7, 7, 0, 'DOAJ XML export', 'plugins.importexport.doaj.filter.DOAJXmlFilter', 0, 0, 0),
(8, 8, 0, 'DOAJ JSON export', 'plugins.importexport.doaj.filter.DOAJJsonFilter', 0, 0, 0),
(9, 9, 0, 'Native XML submission export', 'plugins.importexport.native.filter.ArticleNativeXmlFilter', 0, 0, 0),
(10, 10, 0, 'Native XML submission import', 'plugins.importexport.native.filter.NativeXmlArticleFilter', 0, 0, 0),
(11, 11, 0, 'Native XML issue export', 'plugins.importexport.native.filter.IssueNativeXmlFilter', 0, 0, 0),
(12, 12, 0, 'Native XML issue import', 'plugins.importexport.native.filter.NativeXmlIssueFilter', 0, 0, 0),
(13, 13, 0, 'Native XML issue galley export', 'plugins.importexport.native.filter.IssueGalleyNativeXmlFilter', 0, 0, 0),
(14, 14, 0, 'Native XML issue galley import', 'plugins.importexport.native.filter.NativeXmlIssueGalleyFilter', 0, 0, 0),
(15, 15, 0, 'Native XML author export', 'plugins.importexport.native.filter.AuthorNativeXmlFilter', 0, 0, 0),
(16, 16, 0, 'Native XML author import', 'plugins.importexport.native.filter.NativeXmlAuthorFilter', 0, 0, 0),
(17, 18, 0, 'Native XML submission file import', 'plugins.importexport.native.filter.NativeXmlArticleFileFilter', 0, 0, 0),
(18, 17, 0, 'Native XML submission file export', 'lib.pkp.plugins.importexport.native.filter.SubmissionFileNativeXmlFilter', 0, 0, 0),
(19, 19, 0, 'Native XML representation export', 'plugins.importexport.native.filter.ArticleGalleyNativeXmlFilter', 0, 0, 0),
(20, 20, 0, 'Native XML representation import', 'plugins.importexport.native.filter.NativeXmlArticleGalleyFilter', 0, 0, 0),
(21, 21, 0, 'Native XML Publication export', 'plugins.importexport.native.filter.PublicationNativeXmlFilter', 0, 0, 0),
(22, 22, 0, 'Native XML publication import', 'plugins.importexport.native.filter.NativeXmlPublicationFilter', 0, 0, 0),
(23, 23, 0, 'ArticlePubMedXmlFilter', 'plugins.importexport.pubmed.filter.ArticlePubMedXmlFilter', 0, 0, 0),
(24, 24, 0, 'User XML user export', 'lib.pkp.plugins.importexport.users.filter.PKPUserUserXmlFilter', 0, 0, 0),
(25, 25, 0, 'User XML user import', 'lib.pkp.plugins.importexport.users.filter.UserXmlPKPUserFilter', 0, 0, 0),
(26, 26, 0, 'Native XML user group export', 'lib.pkp.plugins.importexport.users.filter.UserGroupNativeXmlFilter', 0, 0, 0),
(27, 27, 0, 'Native XML user group import', 'lib.pkp.plugins.importexport.users.filter.NativeXmlUserGroupFilter', 0, 0, 0);

-- --------------------------------------------------------

--
-- Struktur dari tabel `filter_groups`
--

CREATE TABLE `filter_groups` (
  `filter_group_id` bigint(20) NOT NULL,
  `symbolic` varchar(255) DEFAULT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `input_type` varchar(255) DEFAULT NULL,
  `output_type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `filter_groups`
--

INSERT INTO `filter_groups` (`filter_group_id`, `symbolic`, `display_name`, `description`, `input_type`, `output_type`) VALUES
(1, 'article=>dc11', 'plugins.metadata.dc11.articleAdapter.displayName', 'plugins.metadata.dc11.articleAdapter.description', 'class::classes.submission.Submission', 'metadata::plugins.metadata.dc11.schema.Dc11Schema(ARTICLE)'),
(2, 'issue=>crossref-xml', 'plugins.importexport.crossref.displayName', 'plugins.importexport.crossref.description', 'class::classes.issue.Issue[]', 'xml::schema(https://www.crossref.org/schemas/crossref4.3.6.xsd)'),
(3, 'article=>crossref-xml', 'plugins.importexport.crossref.displayName', 'plugins.importexport.crossref.description', 'class::classes.submission.Submission[]', 'xml::schema(https://www.crossref.org/schemas/crossref4.3.6.xsd)'),
(4, 'issue=>datacite-xml', 'plugins.importexport.datacite.displayName', 'plugins.importexport.datacite.description', 'class::classes.issue.Issue', 'xml::schema(http://schema.datacite.org/meta/kernel-4/metadata.xsd)'),
(5, 'article=>datacite-xml', 'plugins.importexport.datacite.displayName', 'plugins.importexport.datacite.description', 'class::classes.submission.Submission', 'xml::schema(http://schema.datacite.org/meta/kernel-4/metadata.xsd)'),
(6, 'galley=>datacite-xml', 'plugins.importexport.datacite.displayName', 'plugins.importexport.datacite.description', 'class::classes.article.ArticleGalley', 'xml::schema(http://schema.datacite.org/meta/kernel-4/metadata.xsd)'),
(7, 'article=>doaj-xml', 'plugins.importexport.doaj.displayName', 'plugins.importexport.doaj.description', 'class::classes.submission.Submission[]', 'xml::schema(plugins/importexport/doaj/doajArticles.xsd)'),
(8, 'article=>doaj-json', 'plugins.importexport.doaj.displayName', 'plugins.importexport.doaj.description', 'class::classes.submission.Submission', 'primitive::string'),
(9, 'article=>native-xml', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'class::classes.submission.Submission[]', 'xml::schema(plugins/importexport/native/native.xsd)'),
(10, 'native-xml=>article', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'xml::schema(plugins/importexport/native/native.xsd)', 'class::classes.submission.Submission[]'),
(11, 'issue=>native-xml', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'class::classes.issue.Issue[]', 'xml::schema(plugins/importexport/native/native.xsd)'),
(12, 'native-xml=>issue', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'xml::schema(plugins/importexport/native/native.xsd)', 'class::classes.issue.Issue[]'),
(13, 'issuegalley=>native-xml', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'class::classes.issue.IssueGalley[]', 'xml::schema(plugins/importexport/native/native.xsd)'),
(14, 'native-xml=>issuegalley', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'xml::schema(plugins/importexport/native/native.xsd)', 'class::classes.issue.IssueGalley[]'),
(15, 'author=>native-xml', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'class::classes.article.Author[]', 'xml::schema(plugins/importexport/native/native.xsd)'),
(16, 'native-xml=>author', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'xml::schema(plugins/importexport/native/native.xsd)', 'class::classes.article.Author[]'),
(17, 'SubmissionFile=>native-xml', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'class::lib.pkp.classes.submission.SubmissionFile', 'xml::schema(plugins/importexport/native/native.xsd)'),
(18, 'native-xml=>SubmissionFile', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'xml::schema(plugins/importexport/native/native.xsd)', 'class::lib.pkp.classes.submission.SubmissionFile'),
(19, 'article-galley=>native-xml', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'class::classes.article.ArticleGalley', 'xml::schema(plugins/importexport/native/native.xsd)'),
(20, 'native-xml=>ArticleGalley', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'xml::schema(plugins/importexport/native/native.xsd)', 'class::classes.article.ArticleGalley[]'),
(21, 'publication=>native-xml', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'class::classes.publication.Publication', 'xml::schema(plugins/importexport/native/native.xsd)'),
(22, 'native-xml=>Publication', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'xml::schema(plugins/importexport/native/native.xsd)', 'class::classes.publication.Publication'),
(23, 'article=>pubmed-xml', 'plugins.importexport.pubmed.displayName', 'plugins.importexport.pubmed.description', 'class::classes.submission.Submission[]', 'xml::dtd'),
(24, 'user=>user-xml', 'plugins.importexport.users.displayName', 'plugins.importexport.users.description', 'class::lib.pkp.classes.user.User[]', 'xml::schema(lib/pkp/plugins/importexport/users/pkp-users.xsd)'),
(25, 'user-xml=>user', 'plugins.importexport.users.displayName', 'plugins.importexport.users.description', 'xml::schema(lib/pkp/plugins/importexport/users/pkp-users.xsd)', 'class::classes.users.User[]'),
(26, 'usergroup=>user-xml', 'plugins.importexport.users.displayName', 'plugins.importexport.users.description', 'class::lib.pkp.classes.security.UserGroup[]', 'xml::schema(lib/pkp/plugins/importexport/users/pkp-users.xsd)'),
(27, 'user-xml=>usergroup', 'plugins.importexport.native.displayName', 'plugins.importexport.native.description', 'xml::schema(lib/pkp/plugins/importexport/users/pkp-users.xsd)', 'class::lib.pkp.classes.security.UserGroup[]');

-- --------------------------------------------------------

--
-- Struktur dari tabel `filter_settings`
--

CREATE TABLE `filter_settings` (
  `filter_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `genres`
--

CREATE TABLE `genres` (
  `genre_id` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `seq` bigint(20) NOT NULL,
  `enabled` smallint(6) NOT NULL DEFAULT 1,
  `category` bigint(20) NOT NULL DEFAULT 1,
  `dependent` smallint(6) NOT NULL DEFAULT 0,
  `supplementary` smallint(6) NOT NULL DEFAULT 0,
  `entry_key` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `genres`
--

INSERT INTO `genres` (`genre_id`, `context_id`, `seq`, `enabled`, `category`, `dependent`, `supplementary`, `entry_key`) VALUES
(1, 1, 0, 1, 1, 0, 0, 'SUBMISSION'),
(2, 1, 1, 1, 3, 0, 1, 'RESEARCHINSTRUMENT'),
(3, 1, 2, 1, 3, 0, 1, 'RESEARCHMATERIALS'),
(4, 1, 3, 1, 3, 0, 1, 'RESEARCHRESULTS'),
(5, 1, 4, 1, 3, 0, 1, 'TRANSCRIPTS'),
(6, 1, 5, 1, 3, 0, 1, 'DATAANALYSIS'),
(7, 1, 6, 1, 3, 0, 1, 'DATASET'),
(8, 1, 7, 1, 3, 0, 1, 'SOURCETEXTS'),
(9, 1, 8, 1, 1, 1, 1, 'MULTIMEDIA'),
(10, 1, 9, 1, 2, 1, 0, 'IMAGE'),
(11, 1, 10, 1, 1, 1, 0, 'STYLE'),
(12, 1, 11, 1, 3, 0, 1, 'OTHER');

-- --------------------------------------------------------

--
-- Struktur dari tabel `genre_settings`
--

CREATE TABLE `genre_settings` (
  `genre_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `genre_settings`
--

INSERT INTO `genre_settings` (`genre_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(1, 'en_US', 'name', 'Article Text', 'string'),
(1, 'id_ID', 'name', 'File Utama Naskah', 'string'),
(2, 'en_US', 'name', 'Research Instrument', 'string'),
(2, 'id_ID', 'name', 'Instrumen Penelitian', 'string'),
(3, 'en_US', 'name', 'Research Materials', 'string'),
(3, 'id_ID', 'name', 'Bahan Penelitian', 'string'),
(4, 'en_US', 'name', 'Research Results', 'string'),
(4, 'id_ID', 'name', 'Hasil Penelitian', 'string'),
(5, 'en_US', 'name', 'Transcripts', 'string'),
(5, 'id_ID', 'name', 'Transkrip', 'string'),
(6, 'en_US', 'name', 'Data Analysis', 'string'),
(6, 'id_ID', 'name', 'Analisis Data', 'string'),
(7, 'en_US', 'name', 'Data Set', 'string'),
(7, 'id_ID', 'name', 'Data Set', 'string'),
(8, 'en_US', 'name', 'Source Texts', 'string'),
(8, 'id_ID', 'name', 'Teks Sumber', 'string'),
(9, 'en_US', 'name', 'Multimedia', 'string'),
(9, 'id_ID', 'name', 'Multimedia', 'string'),
(10, 'en_US', 'name', 'Image', 'string'),
(10, 'id_ID', 'name', 'Gambar', 'string'),
(11, 'en_US', 'name', 'HTML Stylesheet', 'string'),
(11, 'id_ID', 'name', 'HTML StyleSheet', 'string'),
(12, 'en_US', 'name', 'Other', 'string'),
(12, 'id_ID', 'name', 'Lainnya', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `institutional_subscriptions`
--

CREATE TABLE `institutional_subscriptions` (
  `institutional_subscription_id` bigint(20) NOT NULL,
  `subscription_id` bigint(20) NOT NULL,
  `institution_name` varchar(255) NOT NULL,
  `mailing_address` varchar(255) DEFAULT NULL,
  `domain` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `institutional_subscription_ip`
--

CREATE TABLE `institutional_subscription_ip` (
  `institutional_subscription_ip_id` bigint(20) NOT NULL,
  `subscription_id` bigint(20) NOT NULL,
  `ip_string` varchar(40) NOT NULL,
  `ip_start` bigint(20) NOT NULL,
  `ip_end` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `issues`
--

CREATE TABLE `issues` (
  `issue_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `volume` smallint(6) DEFAULT NULL,
  `number` varchar(40) DEFAULT NULL,
  `year` smallint(6) DEFAULT NULL,
  `published` smallint(6) NOT NULL DEFAULT 0,
  `current` smallint(6) NOT NULL DEFAULT 0,
  `date_published` datetime DEFAULT NULL,
  `date_notified` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `access_status` smallint(6) NOT NULL DEFAULT 1,
  `open_access_date` datetime DEFAULT NULL,
  `show_volume` smallint(6) NOT NULL DEFAULT 0,
  `show_number` smallint(6) NOT NULL DEFAULT 0,
  `show_year` smallint(6) NOT NULL DEFAULT 0,
  `show_title` smallint(6) NOT NULL DEFAULT 0,
  `style_file_name` varchar(90) DEFAULT NULL,
  `original_style_file_name` varchar(255) DEFAULT NULL,
  `url_path` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `issue_files`
--

CREATE TABLE `issue_files` (
  `file_id` bigint(20) NOT NULL,
  `issue_id` bigint(20) NOT NULL,
  `file_name` varchar(90) NOT NULL,
  `file_type` varchar(255) NOT NULL,
  `file_size` bigint(20) NOT NULL,
  `content_type` bigint(20) NOT NULL,
  `original_file_name` varchar(127) DEFAULT NULL,
  `date_uploaded` datetime NOT NULL,
  `date_modified` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `issue_galleys`
--

CREATE TABLE `issue_galleys` (
  `galley_id` bigint(20) NOT NULL,
  `locale` varchar(14) DEFAULT NULL,
  `issue_id` bigint(20) NOT NULL,
  `file_id` bigint(20) NOT NULL,
  `label` varchar(32) DEFAULT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00,
  `url_path` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `issue_galley_settings`
--

CREATE TABLE `issue_galley_settings` (
  `galley_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `issue_settings`
--

CREATE TABLE `issue_settings` (
  `issue_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `item_views`
--

CREATE TABLE `item_views` (
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `date_last_viewed` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `item_views`
--

INSERT INTO `item_views` (`assoc_type`, `assoc_id`, `user_id`, `date_last_viewed`) VALUES
(516, 2, 1, '2023-09-05 03:12:09'),
(516, 1, 1, '2023-09-05 05:13:37');

-- --------------------------------------------------------

--
-- Struktur dari tabel `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `journals`
--

CREATE TABLE `journals` (
  `journal_id` bigint(20) NOT NULL,
  `path` varchar(32) NOT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00 COMMENT 'Used to order lists of journals',
  `primary_locale` varchar(14) NOT NULL,
  `enabled` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Controls whether or not the journal is considered "live" and will appear on the website. (Note that disabled journals may still be accessible, but only if the user knows the URL.)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `journals`
--

INSERT INTO `journals` (`journal_id`, `path`, `seq`, `primary_locale`, `enabled`) VALUES
(1, 'ip', 1.00, 'en_US', 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `journal_settings`
--

CREATE TABLE `journal_settings` (
  `journal_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext DEFAULT NULL,
  `setting_type` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `journal_settings`
--

INSERT INTO `journal_settings` (`journal_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(1, '', 'contactEmail', 'reliabel.fpsi.unjani@gmail.com', NULL),
(1, '', 'contactName', 'Reliabel : Jurnal Ilmiah Psikologi', NULL),
(1, '', 'contactPhone', '022-6636153', NULL),
(1, '', 'copyrightYearBasis', 'issue', NULL),
(1, '', 'defaultReviewMode', '2', NULL),
(1, '', 'disableSubmissions', '0', NULL),
(1, '', 'emailSignature', '<p><br>________________________________________________________________________<br><a href=\"http://localhost:8000/index.php/ip\">Jurnal Ilmu Psikologi : Reliabel</a></p>', NULL),
(1, '', 'enableAnnouncements', '1', NULL),
(1, '', 'enableOai', '1', NULL),
(1, '', 'itemsPerPage', '25', NULL),
(1, '', 'keywords', 'request', NULL),
(1, '', 'mailingAddress', 'Jl. Terusan Jend. Sudirman, Cibeber, Kec. Cimahi Sel., Kota Cimahi, Jawa Barat 40531', NULL),
(1, '', 'membershipFee', '0', NULL),
(1, '', 'numAnnouncementsHomepage', '1', NULL),
(1, '', 'numPageLinks', '10', NULL),
(1, '', 'numWeeksPerResponse', '4', NULL),
(1, '', 'numWeeksPerReview', '4', NULL),
(1, '', 'publicationFee', '0', NULL),
(1, '', 'publisherInstitution', 'Fakultas Psikologi ', NULL),
(1, '', 'purchaseArticleFee', '0', NULL),
(1, '', 'sidebar', '[\"sidebar\"]', NULL),
(1, '', 'styleSheet', '{\"name\":\"styleSheet.css\",\"uploadName\":\"styleSheet.css\",\"dateUploaded\":\"2023-03-18 04:33:44\"}', NULL),
(1, '', 'supportedFormLocales', '[\"en_US\"]', NULL),
(1, '', 'supportedLocales', '[\"id_ID\",\"en_US\"]', NULL),
(1, '', 'supportedSubmissionLocales', '[\"en_US\"]', NULL),
(1, '', 'supportEmail', 'afini.freudwiasri@lecture.unjani.ac.id', NULL),
(1, '', 'supportName', 'Afini Freudwi Asri', NULL),
(1, '', 'supportPhone', '0857-2399-6565', NULL),
(1, '', 'themePluginPath', 'defaultManuscript', NULL),
(1, 'en_US', 'abbreviation', 'Jurnal Psikologi', NULL),
(1, 'en_US', 'about', '<p><strong>Reliabel: Jurnal Ilmiah Psikologi</strong></p>\n<p> </p>\n<table class=\"data\" width=\"496\" bgcolor=\"#f0f0f0\">\n<tbody>\n<tr valign=\"top\">\n<td width=\"20%\">Journal title</td>\n<td width=\"80%\">Jurnal Ilmiah Psikologi</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Initials</td>\n<td width=\"80%\">Reliabel</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Frequency</td>\n<td width=\"80%\">2 issues per year (February, and August)</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Print ISSN</td>\n<td width=\"80%\"> </td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Online ISSN</td>\n<td width=\"80%\"> </td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Editor-in-chief</td>\n<td width=\"80%\">Linda Ernawati</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Man/Han. Editor</td>\n<td width=\"80%\">Afini Freudwi Asri</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Publisher</td>\n<td width=\"80%\">Fakultas Psikologi Universitas Jenderal Ahmad Yani</td>\n</tr>\n</tbody>\n</table>\n<p><strong>Reliabel Jurnal Ilmiah Psikologi</strong> is journal blind peer-review dedicated for research publication. We welcome articles from any psychology-related subjects that could fall under these sub-themes: Educational Psychology, Clinical Psychology, Industrial/Organizational Psychology, Developmental Psychology, Social Psychology, Military Psychology, Experimental Psychology, Psychometrics, Cognition and Neuroscience, Health Psychology. </p>\n<p><strong><span style=\"font-size: 0.875rem;\">Reliabel </span>Jurnal Ilmiah Psikologi</strong>  publishes articles that contribute theoretical studies (e.g. systematic reviews, new thoughts on research methodology and design, criticism and discussion of theoretical models, meta-theoretical) as well as contributions to the results of empirical and applied research (e.g. empirical reports, meta-analyses) both qualitative and quantitative research. </p>\n<p>All submitted manuscripts must be original, previously unpublished or must NOT be under consideration for publication elsewhere.</p>\n<p> </p>', NULL),
(1, 'en_US', 'acronym', 'Reliabel', NULL),
(1, 'en_US', 'additionalHomeContent', '<p><strong>Reliabel: Jurnal Ilmiah Psikologi</strong></p>\n<p> </p>\n<table class=\"data\" width=\"496\" bgcolor=\"#f0f0f0\">\n<tbody>\n<tr valign=\"top\">\n<td width=\"20%\">Journal title</td>\n<td width=\"80%\">Jurnal Ilmiah Psikologi</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Initials</td>\n<td width=\"80%\">Reliabel</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Frequency</td>\n<td width=\"80%\">2 issues per year (February, and August)</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Print ISSN</td>\n<td width=\"80%\"> </td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Online ISSN</td>\n<td width=\"80%\"> </td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Editor-in-chief</td>\n<td width=\"80%\">Linda Ernawati</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Man/Han. Editor</td>\n<td width=\"80%\">Afini Freudwi Asri</td>\n</tr>\n<tr valign=\"top\">\n<td width=\"20%\">Publisher</td>\n<td width=\"80%\">Fakultas Psikologi Universitas Jenderal Ahmad Yani</td>\n</tr>\n</tbody>\n</table>\n<p>We welcome articles from any psychology-related subjects that could fall under these sub-themes: Educational Psychology, Clinical Psychology, Industrial/Organizational Psychology, Developmental Psychology, Social Psychology, Military Psychology, Experimental Psychology, Psychometrics, Cognition and Neuroscience, Health Psychology.</p>\n<p><strong><span style=\"font-size: 0.875rem;\">Reliabel </span>Jurnal Ilmiah Psikologi </strong> publishes articles that contribute theoretical studies (e.g. systematic reviews, new thoughts on research methodology and design, criticism and discussion of theoretical models, meta-theoretical) as well as contributions to the results of empirical and applied research (e.g. empirical reports, meta-analyses) both qualitative and quantitative research. </p>\n<p>ll submitted manuscripts must be original, previously unpublished or must NOT be under consideration for publication elsewhere.</p>\n<p> </p>', NULL),
(1, 'en_US', 'clockssLicense', 'This journal utilizes the CLOCKSS system to create a distributed archiving system among participating libraries and permits those libraries to create permanent archives of the journal for purposes of preservation and restoration. <a href=\"http://clockss.org/\">More...</a>', NULL),
(1, 'en_US', 'contactAffiliation', 'Universitas Jenderal Achmad Yani', NULL),
(1, 'en_US', 'description', '<p>Reliabel Jurnal Ilmiah Psikologi si journal blind peer-review dedicated for research publication. We welcome articles from any psychology-related subjects that could fall under these sub-themes: Educational Psychology, Clinical Psychology, Industrial/Organizational Psychology, Developmental Psychology, Social Psychology, Military Psychology, Experimental Psychology, Psychometrics, Cognition and Neuroscience, Health Psychology. </p>\n<p><span style=\"font-size: 0.875rem;\">Reliabel </span>Jurnal Ilmiah Psikologi  publishes articles that contribute theoretical studies (e.g. systematic reviews, new thoughts on research methodology and design, criticism and discussion of theoretical models, meta-theoretical) as well as contributions to the results of empirical and applied research (e.g. empirical reports, meta-analyses) both qualitative and quantitative research. </p>\n<p>All submitted manuscripts must be original, previously unpublished or must NOT be under consideration for publication elsewhere.</p>', NULL),
(1, 'en_US', 'editorialTeam', '<p><strong>Editor in Chief</strong></p>\n<p>Linda Ernawati, Universitas Jenderal Achmad Yani</p>\n<p><strong>Man. Editor</strong></p>\n<p>Afini Freudwi Asri, Universitas Jenderal Achmad Yani</p>\n<p><strong>Editorial Board</strong></p>\n<ul>\n<li>Vera Angliani Juwita, Universitas Jenderal Achmad Yani</li>\n<li>Amir Nuyman S, Universitas Jenderal Achmad Yani</li>\n<li>Zora Arfina Sukabdi, Universitas Indonesia</li>\n<li>Risydah Fadilah, Universitas Medan Area</li>\n</ul>\n<p><strong>Reviewer</strong></p>\n<ul>\n<li>Ifran Fahmi, Universitas Islam Negeri Sunan Gunung Djati</li>\n<li>Chandra Yudistira, Universitas Jenderal Achmad Yani</li>\n<li>Akhmad Rifandi, Universitas Muhammadiyah Banjarmasin</li>\n</ul>\n<p><strong>Administration</strong></p>\n<p>Resi Isnawati, Universitas Jenderal Achmad Yani</p>\n<p><strong>IT Support</strong></p>\n<p>Yayan Haryanto, Universitas Jenderal Achmad Yani</p>', NULL),
(1, 'en_US', 'favicon', '{\"name\":\"fav png.png\",\"uploadName\":\"favicon_en_US.png\",\"width\":797,\"height\":768,\"dateUploaded\":\"2023-03-18 13:56:50\",\"altText\":\"\"}', NULL),
(1, 'en_US', 'journalThumbnail', '{\"name\":\"WhatsApp Image 2023-08-26 at 20.04.04.jpeg\",\"uploadName\":\"journalThumbnail_en_US.jpg\",\"width\":1131,\"height\":1600,\"dateUploaded\":\"2023-09-05 00:40:32\",\"altText\":\"\"}', NULL),
(1, 'en_US', 'lockssLicense', 'This journal utilizes the LOCKSS system to create a distributed archiving system among participating libraries and permits those libraries to create permanent archives of the journal for purposes of preservation and restoration. <a href=\"http://www.lockss.org/\">More...</a>', NULL),
(1, 'en_US', 'name', 'Reliabel: Jurnal Ilmiah Psikologi', NULL),
(1, 'en_US', 'openAccessPolicy', 'This journal provides immediate open access to its content on the principle that making research freely available to the public supports a greater global exchange of knowledge.', NULL),
(1, 'en_US', 'pageFooter', '<p>Jl. Terusan Jend. Sudirman, Cibeber, Kec. Cimahi Sel., Kota Cimahi, Jawa Barat 40531</p>', NULL),
(1, 'en_US', 'pageHeaderLogoImage', '{\"name\":\"banner psikolog 3.jpg\",\"uploadName\":\"pageHeaderLogoImage_en_US.jpg\",\"width\":6000,\"height\":908,\"dateUploaded\":\"2023-07-11 11:28:23\",\"altText\":\"\"}', NULL),
(1, 'en_US', 'privacyStatement', '<p>The names and email addresses entered in this journal site will be used exclusively for the stated purposes of this journal and will not be made available for any other purpose or to any other party.</p>', NULL),
(1, 'en_US', 'submissionChecklist', '[{\"order\":1,\"content\":\"The submission has not been previously published, nor is it before another journal for consideration (or an explanation has been provided in Comments to the Editor).\"},{\"order\":2,\"content\":\"The submission file is in OpenOffice, Microsoft Word, or RTF document file format.\"},{\"order\":3,\"content\":\"Where available, URLs for the references have been provided.\"},{\"order\":4,\"content\":\"The text is single-spaced; uses a 12-point font; employs italics, rather than underlining (except with URL addresses); and all illustrations, figures, and tables are placed within the text at the appropriate points, rather than at the end.\"},{\"order\":5,\"content\":\"The text adheres to the stylistic and bibliographic requirements outlined in the Author Guidelines.\"}]', NULL),
(1, 'id_ID', 'abbreviation', NULL, NULL),
(1, 'id_ID', 'acronym', NULL, NULL),
(1, 'id_ID', 'authorInformation', 'Tertarik menerbitkan jurnal? Kami merekomendasikan Anda mereview halaman <a href=\"http://localhost:8000/index.php/ip/about\">Tentang Kami </a>untuk kebijakan bagian jurnal serta <a href=\"http://localhost:8000/index.php/ip/about/submissions#authorGuidelines\">Petunjuk Penulis </a>. Penulis perlu <a href=\"http://localhost:8000/index.php/ip/user/register\">Mendaftar </a>dengan jurnal sebelum menyerahkan atau jika sudah terdaftar <a href=\"http://localhost:8000/index.php/index/login\">login</a>dan mulai proses lima langkah.', NULL),
(1, 'id_ID', 'clockssLicense', 'Journal ini memakai sistem CLOCKSS untum membuat sistem pengarsipan terdistribusi di antara pustaka yang turut berpartisipasi dan mengizinkan pustaka tersebut membuat arsip jurnal secara permanen untuk tujuan pemeliharaan dan pemulihan. <a href=\"http://clockss.org/\">More...</a>', NULL),
(1, 'id_ID', 'librarianInformation', 'Kami mendorong pustakawan riset untuk mendaftar jurnal diantara pemegang jurnal eletronik perpustakaan. Begitu juga, ini mungkin berharga bahwa sistem penerbitan sumber terbuka jurnal cocok untuk perpustakaan untuk menjadi tuan rumah untuk anggota fakultas untuk menggunakan jurnal saat mereka terlibat dalam proses editing. (Lihat <a href=\"http://pkp.sfu.ca/ojs\">Open Journal Systems</a>).', NULL),
(1, 'id_ID', 'lockssLicense', 'OJS sistem LOCKSS berfungsi sebagai sistem pengarsipan terdistribusi antar-perpustakaan yang menggunakan sistem ini dengan tujuan membuat arsip permanen (untuk preservasi dan restorasi). <a href=\"http://www.lockss.org/\">Lanjut...</a>', NULL),
(1, 'id_ID', 'name', NULL, NULL),
(1, 'id_ID', 'openAccessPolicy', 'Jurnal ini menyediakan akses terbuka yang pada prinsipnya membuat riset tersedia secara gratis untuk publik dan akan mensupport pertukaran pengetahuan global terbesar.', NULL),
(1, 'id_ID', 'privacyStatement', '<p>Nama dan alamat email yang dimasukkan di website ini hanya akan digunakan untuk tujuan yang sudah disebutkan, tidak akan disalahgunakan untuk tujuan lain atau untuk disebarluaskan ke pihak lain.</p>', NULL),
(1, 'id_ID', 'readerInformation', 'Kami mendorong pembaca untuk mendaftarkan diri di layanan notifikasi penerbitan untuk jurnal ini. Gunakan tautan <a href=\"http://localhost:8000/index.php/ip/user/register\">Daftar</a>di bagian atas beranda jurnal. Dengan mendaftar, pembaca akan memperoleh email berisi Daftar Isi tiap ada terbitan jurnal baru. Daftar ini juga membuat jurnal dapat mengetahui tingkat dukungan atau jumlah pembaca. Lihat jurnal <a href=\"http://localhost:8000/index.php/ip/about/submissions#privacyStatement\">Pernyataan Privasi</a>, yang meyakinkan pembaca bahwa nama dan alamat email yang didaftarkan tidak akan digunakan untuk tujuan lain.', NULL),
(1, 'id_ID', 'submissionChecklist', '[{\"order\":1,\"content\":\"Naskah belum pernah diterbitkan sebelumnya, dan tidak sedang dalam pertimbangan untuk diterbitkan di jurnal lain (atau sudah dijelaskan dalam Komentar kepada Editor).\"},{\"order\":2,\"content\":\"File naskah dalam format dokumen OpenOffice, Microsoft Word, atau RTF.\"},{\"order\":3,\"content\":\"Referensi yang dapat diakses online telah dituliskan URL-nya.\"},{\"order\":4,\"content\":\"Naskah diketik dengan teks 1 spasi; font 12; menggunakan huruf miring, bukan huruf bergaris bawah (kecuali alamat URL); dan semua ilustrasi, gambar, dan tabel diletakkan dalam teks pada tempat yang diharapkan, bukan dikelompokkan tersendiri di akhir naskah.\"},{\"order\":5,\"content\":\"Naskah mengikuti aturan gaya selingkung dan bibliografi yang disyaratkan dalam Panduan Penulis.\"}]', NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `library_files`
--

CREATE TABLE `library_files` (
  `file_id` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `original_file_name` varchar(255) NOT NULL,
  `file_type` varchar(255) NOT NULL,
  `file_size` bigint(20) NOT NULL,
  `type` smallint(6) NOT NULL,
  `date_uploaded` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `public_access` smallint(6) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `library_file_settings`
--

CREATE TABLE `library_file_settings` (
  `file_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object|date)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `metadata_descriptions`
--

CREATE TABLE `metadata_descriptions` (
  `metadata_description_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL DEFAULT 0,
  `assoc_id` bigint(20) NOT NULL DEFAULT 0,
  `schema_namespace` varchar(255) NOT NULL,
  `schema_name` varchar(255) NOT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `seq` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `metadata_description_settings`
--

CREATE TABLE `metadata_description_settings` (
  `metadata_description_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `metrics`
--

CREATE TABLE `metrics` (
  `load_id` varchar(255) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `pkp_section_id` bigint(20) DEFAULT NULL,
  `assoc_object_type` bigint(20) DEFAULT NULL,
  `assoc_object_id` bigint(20) DEFAULT NULL,
  `submission_id` bigint(20) DEFAULT NULL,
  `representation_id` bigint(20) DEFAULT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `day` varchar(8) DEFAULT NULL,
  `month` varchar(6) DEFAULT NULL,
  `file_type` smallint(6) DEFAULT NULL,
  `country_id` varchar(2) DEFAULT NULL,
  `region` varchar(2) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `metric_type` varchar(255) NOT NULL,
  `metric` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `metrics`
--

INSERT INTO `metrics` (`load_id`, `context_id`, `pkp_section_id`, `assoc_object_type`, `assoc_object_id`, `submission_id`, `representation_id`, `assoc_type`, `assoc_id`, `day`, `month`, `file_type`, `country_id`, `region`, `city`, `metric_type`, `metric`) VALUES
('usage_events_20230711.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230711', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 33),
('usage_events_20230711.log', 1, NULL, NULL, NULL, NULL, NULL, 259, 1, '20230711', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 3),
('usage_events_20230712.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230712', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 11),
('usage_events_20230713.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230713', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 5),
('usage_events_20230714.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230714', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 12),
('usage_events_20230715.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230715', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 10),
('usage_events_20230716.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230716', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 6),
('usage_events_20230717.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230717', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 9),
('usage_events_20230717.log', 1, NULL, NULL, NULL, NULL, NULL, 259, 1, '20230717', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230718.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230718', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 11),
('usage_events_20230719.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230719', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 6),
('usage_events_20230720.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230720', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 2),
('usage_events_20230721.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230721', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 14),
('usage_events_20230722.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230722', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 5),
('usage_events_20230724.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230724', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230723.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230723', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 10),
('usage_events_20230725.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230725', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 13),
('usage_events_20230726.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230726', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 11),
('usage_events_20230726.log', 1, NULL, NULL, NULL, NULL, NULL, 259, 1, '20230726', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230727.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230727', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 2),
('usage_events_20230728.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230728', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 11),
('usage_events_20230729.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230729', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 2),
('usage_events_20230730.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230730', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 3),
('usage_events_20230731.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230731', '202307', NULL, NULL, NULL, NULL, 'ojs::counter', 8),
('usage_events_20230801.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230801', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 14),
('usage_events_20230801.log', 1, NULL, NULL, NULL, NULL, NULL, 259, 1, '20230801', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230802.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230802', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 5),
('usage_events_20230802.log', 1, NULL, NULL, NULL, NULL, NULL, 259, 1, '20230802', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230803.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230803', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 3),
('usage_events_20230804.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230804', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230806.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230806', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 9),
('usage_events_20230807.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230807', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 6),
('usage_events_20230808.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230808', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 9),
('usage_events_20230809.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230809', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 2),
('usage_events_20230810.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230810', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 2),
('usage_events_20230811.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230811', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230812.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230812', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230813.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230813', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 3),
('usage_events_20230815.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230815', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 2),
('usage_events_20230817.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230817', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 7),
('usage_events_20230820.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230820', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 8),
('usage_events_20230822.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230822', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 5),
('usage_events_20230823.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230823', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 6),
('usage_events_20230823.log', 1, NULL, NULL, NULL, NULL, NULL, 259, 1, '20230823', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 1),
('usage_events_20230824.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230824', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 4),
('usage_events_20230825.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230825', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 15),
('usage_events_20230826.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230826', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 37),
('usage_events_20230827.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230827', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 22),
('usage_events_20230828.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230828', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 22),
('usage_events_20230829.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230829', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 21),
('usage_events_20230830.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230830', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 18),
('usage_events_20230831.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230831', '202308', NULL, NULL, NULL, NULL, 'ojs::counter', 2),
('usage_events_20230901.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230901', '202309', NULL, NULL, NULL, NULL, 'ojs::counter', 5),
('usage_events_20230902.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230902', '202309', NULL, NULL, NULL, NULL, 'ojs::counter', 34),
('usage_events_20230903.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230903', '202309', NULL, NULL, NULL, NULL, 'ojs::counter', 8),
('usage_events_20230904.log', 1, NULL, NULL, NULL, NULL, NULL, 256, 1, '20230904', '202309', NULL, NULL, NULL, NULL, 'ojs::counter', 36);

-- --------------------------------------------------------

--
-- Struktur dari tabel `navigation_menus`
--

CREATE TABLE `navigation_menus` (
  `navigation_menu_id` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `area_name` varchar(255) DEFAULT '',
  `title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `navigation_menus`
--

INSERT INTO `navigation_menus` (`navigation_menu_id`, `context_id`, `area_name`, `title`) VALUES
(1, 0, 'user', 'User Navigation Menu'),
(2, 1, 'user', 'User Navigation Menu'),
(3, 1, 'primary', 'Primary Navigation Menu');

-- --------------------------------------------------------

--
-- Struktur dari tabel `navigation_menu_items`
--

CREATE TABLE `navigation_menu_items` (
  `navigation_menu_item_id` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `path` varchar(255) DEFAULT '',
  `type` varchar(255) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `navigation_menu_items`
--

INSERT INTO `navigation_menu_items` (`navigation_menu_item_id`, `context_id`, `path`, `type`) VALUES
(1, 0, NULL, 'NMI_TYPE_USER_REGISTER'),
(2, 0, NULL, 'NMI_TYPE_USER_LOGIN'),
(3, 0, NULL, 'NMI_TYPE_USER_DASHBOARD'),
(4, 0, NULL, 'NMI_TYPE_USER_DASHBOARD'),
(5, 0, NULL, 'NMI_TYPE_USER_PROFILE'),
(6, 0, NULL, 'NMI_TYPE_ADMINISTRATION'),
(7, 0, NULL, 'NMI_TYPE_USER_LOGOUT'),
(8, 1, NULL, 'NMI_TYPE_USER_REGISTER'),
(9, 1, NULL, 'NMI_TYPE_USER_LOGIN'),
(10, 1, NULL, 'NMI_TYPE_USER_DASHBOARD'),
(11, 1, '', 'NMI_TYPE_USER_DASHBOARD'),
(12, 1, '', 'NMI_TYPE_USER_PROFILE'),
(13, 1, NULL, 'NMI_TYPE_ADMINISTRATION'),
(14, 1, NULL, 'NMI_TYPE_USER_LOGOUT'),
(15, 1, NULL, 'NMI_TYPE_CURRENT'),
(16, 1, NULL, 'NMI_TYPE_ARCHIVES'),
(17, 1, NULL, 'NMI_TYPE_ANNOUNCEMENTS'),
(18, 1, '', 'NMI_TYPE_ABOUT'),
(19, 1, NULL, 'NMI_TYPE_ABOUT'),
(20, 1, NULL, 'NMI_TYPE_SUBMISSIONS'),
(21, 1, '', 'NMI_TYPE_EDITORIAL_TEAM'),
(22, 1, NULL, 'NMI_TYPE_PRIVACY'),
(23, 1, NULL, 'NMI_TYPE_CONTACT'),
(24, 1, NULL, 'NMI_TYPE_SEARCH'),
(25, 1, '', 'NMI_TYPE_REMOTE_URL');

-- --------------------------------------------------------

--
-- Struktur dari tabel `navigation_menu_item_assignments`
--

CREATE TABLE `navigation_menu_item_assignments` (
  `navigation_menu_item_assignment_id` bigint(20) NOT NULL,
  `navigation_menu_id` bigint(20) NOT NULL,
  `navigation_menu_item_id` bigint(20) NOT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `seq` bigint(20) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `navigation_menu_item_assignments`
--

INSERT INTO `navigation_menu_item_assignments` (`navigation_menu_item_assignment_id`, `navigation_menu_id`, `navigation_menu_item_id`, `parent_id`, `seq`) VALUES
(1, 1, 1, 0, 0),
(2, 1, 2, 0, 1),
(3, 1, 3, 0, 2),
(4, 1, 4, 3, 0),
(5, 1, 5, 3, 1),
(6, 1, 6, 3, 2),
(7, 1, 7, 3, 3),
(8, 2, 8, 0, 0),
(9, 2, 9, 0, 1),
(10, 2, 10, 0, 2),
(11, 2, 11, 10, 0),
(12, 2, 12, 10, 1),
(13, 2, 13, 10, 2),
(14, 2, 14, 10, 3),
(37, 3, 25, 0, 0),
(38, 3, 18, 0, 1),
(39, 3, 21, 0, 2),
(40, 3, 15, 0, 3),
(41, 3, 16, 0, 4),
(42, 3, 17, 0, 5),
(43, 3, 23, 0, 6);

-- --------------------------------------------------------

--
-- Struktur dari tabel `navigation_menu_item_assignment_settings`
--

CREATE TABLE `navigation_menu_item_assignment_settings` (
  `navigation_menu_item_assignment_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `navigation_menu_item_assignment_settings`
--

INSERT INTO `navigation_menu_item_assignment_settings` (`navigation_menu_item_assignment_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(37, 'en_US', 'title', 'Home', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `navigation_menu_item_settings`
--

CREATE TABLE `navigation_menu_item_settings` (
  `navigation_menu_item_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` longtext DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `navigation_menu_item_settings`
--

INSERT INTO `navigation_menu_item_settings` (`navigation_menu_item_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(1, '', 'titleLocaleKey', 'navigation.register', 'string'),
(2, '', 'titleLocaleKey', 'navigation.login', 'string'),
(3, '', 'titleLocaleKey', '{$loggedInUsername}', 'string'),
(4, '', 'titleLocaleKey', 'navigation.dashboard', 'string'),
(5, '', 'titleLocaleKey', 'common.viewProfile', 'string'),
(6, '', 'titleLocaleKey', 'navigation.admin', 'string'),
(7, '', 'titleLocaleKey', 'user.logOut', 'string'),
(8, '', 'titleLocaleKey', 'navigation.register', 'string'),
(9, '', 'titleLocaleKey', 'navigation.login', 'string'),
(10, '', 'titleLocaleKey', '{$loggedInUsername}', 'string'),
(11, '', 'titleLocaleKey', 'navigation.dashboard', 'string'),
(11, 'en_US', 'content', '', 'string'),
(11, 'en_US', 'remoteUrl', '', 'string'),
(12, '', 'titleLocaleKey', 'common.viewProfile', 'string'),
(12, 'en_US', 'content', '', 'string'),
(12, 'en_US', 'remoteUrl', '', 'string'),
(13, '', 'titleLocaleKey', 'navigation.admin', 'string'),
(14, '', 'titleLocaleKey', 'user.logOut', 'string'),
(15, '', 'titleLocaleKey', 'navigation.current', 'string'),
(16, '', 'titleLocaleKey', 'navigation.archives', 'string'),
(17, '', 'titleLocaleKey', 'manager.announcements', 'string'),
(18, '', 'titleLocaleKey', 'navigation.about', 'string'),
(18, 'en_US', 'content', '', 'string'),
(18, 'en_US', 'remoteUrl', '', 'string'),
(19, '', 'titleLocaleKey', 'about.aboutContext', 'string'),
(20, '', 'titleLocaleKey', 'about.submissions', 'string'),
(21, '', 'titleLocaleKey', 'about.editorialTeam', 'string'),
(21, 'en_US', 'content', '', 'string'),
(21, 'en_US', 'remoteUrl', '', 'string'),
(22, '', 'titleLocaleKey', 'manager.setup.privacyStatement', 'string'),
(23, '', 'titleLocaleKey', 'about.contact', 'string'),
(24, '', 'titleLocaleKey', 'common.search', 'string'),
(25, 'en_US', 'content', '', 'string'),
(25, 'en_US', 'remoteUrl', 'http://reliabel.fpsi.unjani.ac.id/index.php/ip', 'string'),
(25, 'en_US', 'title', 'Home', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `notes`
--

CREATE TABLE `notes` (
  `note_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `contents` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `notes`
--

INSERT INTO `notes` (`note_id`, `assoc_type`, `assoc_id`, `user_id`, `date_created`, `date_modified`, `title`, `contents`) VALUES
(3, 1048586, 3, 13, '2023-09-05 12:00:26', '2023-09-05 12:00:26', 'Comments for the Editor', '<p>Dear Editor,</p>\r\n<p>Ijin mengirimkan artikel jurnal. Terimakasih</p>');

-- --------------------------------------------------------

--
-- Struktur dari tabel `notifications`
--

CREATE TABLE `notifications` (
  `notification_id` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `level` bigint(20) NOT NULL,
  `type` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_read` datetime DEFAULT NULL,
  `assoc_type` bigint(20) DEFAULT NULL,
  `assoc_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `notifications`
--

INSERT INTO `notifications` (`notification_id`, `context_id`, `user_id`, `level`, `type`, `date_created`, `date_read`, `assoc_type`, `assoc_id`) VALUES
(18, 1, 0, 2, 16777243, '2023-03-18 15:17:01', NULL, 1048585, 1),
(19, 1, 0, 2, 16777245, '2023-03-18 15:17:01', NULL, 1048585, 1),
(29, 1, 2, 2, 16777217, '2023-03-25 14:19:39', NULL, 1048585, 2),
(30, 1, 0, 2, 16777243, '2023-03-25 14:19:43', NULL, 1048585, 2),
(31, 1, 0, 2, 16777245, '2023-03-25 14:19:43', NULL, 1048585, 2),
(35, 1, 2, 2, 16777235, '2023-03-25 14:23:14', NULL, 1048585, 2),
(38, 1, 2, 3, 16777258, '2023-07-11 06:55:33', NULL, 0, 0),
(41, 1, 2, 3, 16777258, '2023-08-01 02:28:31', NULL, 0, 0),
(48, 1, 2, 2, 16777217, '2023-08-28 13:49:06', NULL, 1048585, 4),
(50, 1, 0, 2, 16777243, '2023-08-28 13:49:26', NULL, 1048585, 4),
(51, 1, 0, 2, 16777245, '2023-08-28 13:49:26', NULL, 1048585, 4),
(54, 1, 0, 2, 16777236, '2023-08-28 14:50:12', '2023-08-28 14:50:15', 523, 1),
(62, 1, 2, 2, 16777217, '2023-08-28 16:20:58', NULL, 1048585, 5),
(64, 1, 0, 2, 16777243, '2023-08-28 16:21:19', NULL, 1048585, 5),
(65, 1, 0, 2, 16777245, '2023-08-28 16:21:19', NULL, 1048585, 5),
(67, 1, 0, 2, 16777236, '2023-08-28 16:23:21', '2023-08-28 16:23:23', 523, 2),
(75, 1, 2, 2, 16777254, '2023-08-29 11:47:26', NULL, 1048585, 2),
(85, 1, 9, 3, 16777258, '2023-09-01 00:00:46', NULL, 0, 0),
(89, 1, 9, 2, 16777217, '2023-09-04 04:07:28', NULL, 1048585, 6),
(90, 1, 0, 2, 16777243, '2023-09-04 04:07:32', NULL, 1048585, 6),
(91, 1, 0, 2, 16777245, '2023-09-04 04:07:33', NULL, 1048585, 6),
(94, 1, 9, 2, 16777217, '2023-09-04 11:05:21', NULL, 1048585, 7),
(95, 1, 0, 2, 16777243, '2023-09-04 11:05:25', NULL, 1048585, 7),
(96, 1, 0, 2, 16777245, '2023-09-04 11:05:25', NULL, 1048585, 7),
(100, 1, 2, 2, 16777219, '2023-09-04 13:19:46', NULL, 517, 1),
(101, 1, 2, 2, 16777219, '2023-09-04 13:32:07', NULL, 517, 2),
(106, 1, 0, 2, 16777236, '2023-09-05 01:00:00', '2023-09-05 01:00:01', 523, 3),
(107, 1, 11, 2, 16777231, '2023-09-05 01:00:01', NULL, 1048585, 7),
(108, 1, 12, 3, 16777227, '2023-09-05 01:01:03', NULL, 517, 3),
(110, 1, 0, 2, 16777236, '2023-09-05 01:01:48', '2023-09-05 01:01:49', 523, 4),
(111, 1, 10, 2, 16777231, '2023-09-05 01:01:48', NULL, 1048585, 6),
(112, 1, 12, 3, 16777227, '2023-09-05 01:02:20', NULL, 517, 4),
(114, 1, 8, 3, 16777232, '2023-09-05 03:17:13', '2023-09-05 03:18:39', 1048585, 5),
(117, 1, 6, 3, 16777232, '2023-09-05 05:15:04', NULL, 1048585, 4),
(118, 1, 9, 2, 16777217, '2023-09-05 12:02:31', NULL, 1048585, 8),
(119, 1, 0, 2, 16777243, '2023-09-05 12:02:37', NULL, 1048585, 8),
(120, 1, 0, 2, 16777245, '2023-09-05 12:02:37', NULL, 1048585, 8),
(122, 1, 9, 2, 16777217, '2023-09-05 13:10:15', NULL, 1048585, 9),
(123, 1, 0, 2, 16777243, '2023-09-05 13:10:19', NULL, 1048585, 9),
(124, 1, 0, 2, 16777245, '2023-09-05 13:10:19', NULL, 1048585, 9);

-- --------------------------------------------------------

--
-- Struktur dari tabel `notification_mail_list`
--

CREATE TABLE `notification_mail_list` (
  `notification_mail_list_id` bigint(20) NOT NULL,
  `email` varchar(90) NOT NULL,
  `confirmed` smallint(6) NOT NULL DEFAULT 0,
  `token` varchar(40) NOT NULL,
  `context` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `notification_settings`
--

CREATE TABLE `notification_settings` (
  `notification_id` bigint(20) NOT NULL,
  `locale` varchar(14) DEFAULT NULL,
  `setting_name` varchar(64) NOT NULL,
  `setting_value` text NOT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `notification_settings`
--

INSERT INTO `notification_settings` (`notification_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(38, '', 'contents', 'This is a kind reminder for you to check your journal\'s health through the editorial report.', 'string'),
(41, '', 'contents', 'This is a kind reminder for you to check your journal\'s health through the editorial report.', 'string'),
(85, '', 'contents', 'This is a kind reminder for you to check your journal\'s health through the editorial report.', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `notification_subscription_settings`
--

CREATE TABLE `notification_subscription_settings` (
  `setting_id` bigint(20) NOT NULL,
  `setting_name` varchar(64) NOT NULL,
  `setting_value` text NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `context` bigint(20) NOT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `oai_resumption_tokens`
--

CREATE TABLE `oai_resumption_tokens` (
  `token` varchar(32) NOT NULL,
  `expire` bigint(20) NOT NULL,
  `record_offset` int(11) NOT NULL,
  `params` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `plugin_settings`
--

CREATE TABLE `plugin_settings` (
  `plugin_name` varchar(80) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `setting_name` varchar(80) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `plugin_settings`
--

INSERT INTO `plugin_settings` (`plugin_name`, `context_id`, `setting_name`, `setting_value`, `setting_type`) VALUES
('acronplugin', 0, 'crontab', '[{\"className\":\"plugins.generic.usageStats.UsageStatsLoader\",\"frequency\":{\"hour\":24},\"args\":[\"autoStage\"]},{\"className\":\"plugins.generic.usageStats.UsageStatsLoader\",\"frequency\":{\"hour\":24},\"args\":[\"autoStage\"]},{\"className\":\"plugins.importexport.crossref.CrossrefInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"plugins.importexport.datacite.DataciteInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"plugins.importexport.doaj.DOAJInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"plugins.generic.usageStats.UsageStatsLoader\",\"frequency\":{\"hour\":24},\"args\":[\"autoStage\"]},{\"className\":\"plugins.importexport.crossref.CrossrefInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"plugins.importexport.datacite.DataciteInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"plugins.importexport.doaj.DOAJInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"plugins.generic.usageStats.UsageStatsLoader\",\"frequency\":{\"hour\":24},\"args\":[\"autoStage\"]},{\"className\":\"plugins.importexport.crossref.CrossrefInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"plugins.importexport.datacite.DataciteInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"plugins.importexport.doaj.DOAJInfoSender\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"lib.pkp.classes.task.ReviewReminder\",\"frequency\":{\"hour\":24},\"args\":[]},{\"className\":\"lib.pkp.classes.task.StatisticsReport\",\"frequency\":{\"day\":\"1\"},\"args\":[]},{\"className\":\"classes.tasks.SubscriptionExpiryReminder\",\"frequency\":{\"day\":\"1\"},\"args\":[]}]', 'object'),
('acronplugin', 0, 'enabled', '1', 'bool'),
('announcementsblockplugin', 1, 'enabled', '1', 'bool'),
('citationstylelanguageplugin', 1, 'enabled', '1', 'bool'),
('customblockmanagerplugin', 1, 'blocks', '[\"sidebar\"]', 'object'),
('customblockmanagerplugin', 1, 'enabled', '1', 'bool'),
('defaultmanuscriptchildthemeplugin', 1, 'accentColour', '#7E45E3', 'string'),
('defaultmanuscriptchildthemeplugin', 1, 'enabled', '1', 'bool'),
('defaultthemeplugin', 0, 'enabled', '1', 'bool'),
('defaultthemeplugin', 1, 'baseColour', '#9320BA', 'string'),
('defaultthemeplugin', 1, 'enabled', '1', 'bool'),
('defaultthemeplugin', 1, 'showDescriptionInJournalIndex', 'false', 'string'),
('developedbyblockplugin', 0, 'enabled', '0', 'bool'),
('developedbyblockplugin', 0, 'seq', '0', 'int'),
('developedbyblockplugin', 1, 'enabled', '0', 'bool'),
('developedbyblockplugin', 1, 'seq', '0', 'int'),
('dublincoremetaplugin', 1, 'enabled', '1', 'bool'),
('googlescholarplugin', 1, 'enabled', '1', 'bool'),
('htmlarticlegalleyplugin', 1, 'enabled', '1', 'bool'),
('informationblockplugin', 1, 'enabled', '1', 'bool'),
('informationblockplugin', 1, 'seq', '7', 'int'),
('languagetoggleblockplugin', 0, 'enabled', '1', 'bool'),
('languagetoggleblockplugin', 0, 'seq', '4', 'int'),
('languagetoggleblockplugin', 1, 'enabled', '1', 'bool'),
('languagetoggleblockplugin', 1, 'seq', '4', 'int'),
('lensgalleyplugin', 1, 'enabled', '1', 'bool'),
('makesubmissionblockplugin', 1, 'enabled', '1', 'bool'),
('pdfjsviewerplugin', 1, 'enabled', '1', 'bool'),
('resolverplugin', 1, 'enabled', '1', 'bool'),
('sidebar', 1, 'blockContent', '{\"en_US\":\"<div class=\\\"vertical-menu\\\">\\r\\n<h2 class=\\\"title\\\">MAIN MENU<\\/h2>\\r\\n<div class=\\\"content\\\">\\r\\n<ul>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/reliabel.fpsi.unjani.ac.id\\/index.php\\/ip\\/submissions\\\">SUBMISSIONS<\\/a><\\/li>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/about\\/submissions#authorGuidelines\\\">AUTHOR GUIDELINES <\\/a><\\/li>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/focusandscope\\\"> FOCUS AND SCOPE <\\/a><\\/li>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/about\\/editorialTeam\\\"> EDITORIAL TEAM<\\/a><\\/li>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/reviewers\\\"> REVIEWER <\\/a><\\/li>\\r\\n<\\/ul>\\r\\n<\\/div>\\r\\n<p>&nbsp;<\\/p>\\r\\n<h2 class=\\\"title\\\">ISSN Barcode<\\/h2>\\r\\n<div class=\\\"content\\\">\\r\\n<p>ISSN Online:&nbsp;<br>ISSN Print:&nbsp;<\\/p>\\r\\n<\\/div>\\r\\n<p>&nbsp;<\\/p>\\r\\n<h2 class=\\\"title\\\">Template<\\/h2>\\r\\n<div class=\\\"content\\\">\\r\\n<p><img src=\\\"http:\\/\\/localhost:8000\\/public\\/site\\/images\\/admin\\/journal-template.png\\\" alt=\\\"\\\" width=\\\"150\\\" height=\\\"91\\\"><\\/p>\\r\\n<\\/div>\\r\\n<p>&nbsp;<\\/p>\\r\\n<h2 class=\\\"title\\\">User<\\/h2>\\r\\n<div class=\\\"content\\\"><form action=\\\"https:\\/\\/localhost:8000\\/index.php\\/ip\\/login\\/signIn\\\" method=\\\"post\\\">\\r\\n<table>\\r\\n<tbody>\\r\\n<tr>\\r\\n<td><label for=\\\"sidebar-username\\\">Username<\\/label><\\/td>\\r\\n<td><input id=\\\"sidebar-username\\\" class=\\\"textField\\\" maxlength=\\\"32\\\" name=\\\"username\\\" size=\\\"12\\\" type=\\\"text\\\" value=\\\"\\\"><\\/td>\\r\\n<\\/tr>\\r\\n<tr>\\r\\n<td><label for=\\\"sidebar-password\\\">Password<\\/label><\\/td>\\r\\n<td><input id=\\\"sidebar-password\\\" class=\\\"textField\\\" name=\\\"password\\\" size=\\\"12\\\" type=\\\"password\\\" value=\\\"\\\"><\\/td>\\r\\n<\\/tr>\\r\\n<tr>\\r\\n<td colspan=\\\"2\\\"><input id=\\\"remember\\\" name=\\\"remember\\\" type=\\\"checkbox\\\" value=\\\"1\\\"> <label for=\\\"remember\\\">Remember me<\\/label><\\/td>\\r\\n<\\/tr>\\r\\n<tr>\\r\\n<td colspan=\\\"2\\\"><input class=\\\"button\\\" type=\\\"submit\\\" value=\\\"Login\\\"><\\/td>\\r\\n<\\/tr>\\r\\n<\\/tbody>\\r\\n<\\/table>\\r\\n<\\/form><\\/div>\\r\\n<p>&nbsp;<\\/p>\\r\\n<h2 class=\\\"title\\\">Tools<\\/h2>\\r\\n<div class=\\\"content\\\">\\r\\n<p><img src=\\\"http:\\/\\/localhost:8000\\/public\\/site\\/images\\/admin\\/mendeley.png\\\" alt=\\\"\\\" width=\\\"159\\\" height=\\\"55\\\"><\\/p>\\r\\n<p><img src=\\\"http:\\/\\/localhost:8000\\/public\\/site\\/images\\/admin\\/grammarly.png\\\" alt=\\\"\\\" width=\\\"159\\\" height=\\\"55\\\"><\\/p>\\r\\n<\\/div>\\r\\n<p>&nbsp;<\\/p>\\r\\n<h2 class=\\\"title\\\">Notification<\\/h2>\\r\\n<div class=\\\"content\\\">\\r\\n<ul>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/notification\\\">View<\\/a><\\/li>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/notification\\/subscribeMailList\\\">Subscribe<\\/a><\\/li>\\r\\n<\\/ul>\\r\\n<\\/div>\\r\\n<p>&nbsp;<\\/p>\\r\\n<h2 class=\\\"title\\\">Information<\\/h2>\\r\\n<div class=\\\"content\\\">\\r\\n<ul>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/information\\/readers\\\"> For Reader<\\/a><\\/li>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/information\\/authors\\\"> For Author <\\/a><\\/li>\\r\\n<li class=\\\"show\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/information\\/librarians\\\"> For Librarians <\\/a><\\/li>\\r\\n<\\/ul>\\r\\n<\\/div>\\r\\n<p>&nbsp;<\\/p>\\r\\n<h2 class=\\\"title\\\">Language<\\/h2>\\r\\n<div class=\\\"content\\\">\\r\\n<ul>\\r\\n<li class=\\\"locale_en_US current show\\\" lang=\\\"en-US\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/user\\/setLocale\\/id_ID?source=%2Findex.php%2Fip\\\"> Bahasa Indonesia <\\/a><\\/li>\\r\\n<li class=\\\"locale_id_ID show\\\" lang=\\\"id-ID\\\"><a href=\\\"http:\\/\\/localhost:8000\\/index.php\\/ip\\/user\\/setLocale\\/en_US?source=%2Findex.php%2Fip\\\"> English <\\/a><\\/li>\\r\\n<\\/ul>\\r\\n<\\/div>\\r\\n<\\/div>\\r\\n<p>&nbsp;<\\/p>\\r\\n<p><a href=\\\"https:\\/\\/info.flagcounter.com\\/1XBx\\\"><img src=\\\"https:\\/\\/s01.flagcounter.com\\/count2\\/1XBx\\/bg_FFFFFF\\/txt_000000\\/border_3F1E92\\/columns_2\\/maxflags_10\\/viewers_0\\/labels_0\\/pageviews_0\\/flags_0\\/percent_0\\/\\\" alt=\\\"Flag Counter\\\" border=\\\"0\\\"><\\/a><\\/p>\"}', 'object'),
('sidebar', 1, 'blockTitle', '{\"en_US\":\"sidebar\"}', 'object'),
('sidebar', 1, 'enabled', '1', 'bool'),
('sidebar', 1, 'showName', NULL, 'string'),
('staticpagesplugin', 1, 'enabled', '1', 'bool'),
('subscriptionblockplugin', 1, 'enabled', '1', 'bool'),
('subscriptionblockplugin', 1, 'seq', '2', 'int'),
('tinymceplugin', 0, 'enabled', '1', 'bool'),
('tinymceplugin', 1, 'enabled', '1', 'bool'),
('usageeventplugin', 0, 'enabled', '1', 'bool'),
('usageeventplugin', 0, 'uniqueSiteId', '6414c422cf053', 'string'),
('usagestatsplugin', 0, 'accessLogFileParseRegex', '/^(?P<ip>\\S+) \\S+ \\S+ \\[(?P<date>.*?)\\] \"\\S+ (?P<url>\\S+).*?\" (?P<returnCode>\\S+) \\S+ \".*?\" \"(?P<userAgent>.*?)\"/', 'string'),
('usagestatsplugin', 0, 'chartType', 'bar', 'string'),
('usagestatsplugin', 0, 'createLogFiles', '1', 'bool'),
('usagestatsplugin', 0, 'datasetMaxCount', '4', 'string'),
('usagestatsplugin', 0, 'enabled', '1', 'bool'),
('usagestatsplugin', 0, 'optionalColumns', '[\"city\",\"region\"]', 'object'),
('webfeedplugin', 1, 'displayItems', '1', 'bool'),
('webfeedplugin', 1, 'displayPage', 'homepage', 'string'),
('webfeedplugin', 1, 'enabled', '1', 'bool');

-- --------------------------------------------------------

--
-- Struktur dari tabel `publications`
--

CREATE TABLE `publications` (
  `publication_id` bigint(20) NOT NULL,
  `access_status` bigint(20) DEFAULT 0,
  `date_published` date DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `locale` varchar(14) DEFAULT NULL,
  `primary_contact_id` bigint(20) DEFAULT NULL,
  `section_id` bigint(20) DEFAULT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00,
  `submission_id` bigint(20) NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT 1,
  `url_path` varchar(64) DEFAULT NULL,
  `version` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `publications`
--

INSERT INTO `publications` (`publication_id`, `access_status`, `date_published`, `last_modified`, `locale`, `primary_contact_id`, `section_id`, `seq`, `submission_id`, `status`, `url_path`, `version`) VALUES
(1, 0, '2023-03-18', '2023-08-26 14:13:31', NULL, 1, 1, 0.00, 1, 1, NULL, 1),
(2, 0, '2023-03-25', '2023-08-26 14:13:31', NULL, 3, 1, 0.00, 2, 1, NULL, 1),
(4, 0, NULL, '2023-08-28 13:49:02', NULL, 5, 1, 0.00, 4, 1, NULL, 1),
(5, 0, NULL, '2023-08-28 16:20:54', NULL, 6, 1, 0.00, 5, 1, NULL, 1),
(6, 0, NULL, '2023-09-04 04:07:23', NULL, 7, 1, 0.00, 6, 1, NULL, 1),
(7, 0, NULL, '2023-09-04 11:03:53', NULL, 11, 1, 0.00, 7, 1, NULL, 1),
(8, 0, NULL, '2023-09-05 12:02:23', NULL, 12, 1, 0.00, 8, 1, NULL, 1),
(9, 0, NULL, '2023-09-05 13:10:08', NULL, 13, 1, 0.00, 9, 1, NULL, 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `publication_categories`
--

CREATE TABLE `publication_categories` (
  `publication_id` bigint(20) NOT NULL,
  `category_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `publication_galleys`
--

CREATE TABLE `publication_galleys` (
  `galley_id` bigint(20) NOT NULL,
  `locale` varchar(14) DEFAULT NULL,
  `publication_id` bigint(20) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `submission_file_id` bigint(20) UNSIGNED DEFAULT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00,
  `remote_url` varchar(2047) DEFAULT NULL,
  `is_approved` smallint(6) NOT NULL DEFAULT 0,
  `url_path` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `publication_galleys`
--

INSERT INTO `publication_galleys` (`galley_id`, `locale`, `publication_id`, `label`, `submission_file_id`, `seq`, `remote_url`, `is_approved`, `url_path`) VALUES
(1, 'en_US', 1, 'PDF', 2, 0.00, '', 0, '');

-- --------------------------------------------------------

--
-- Struktur dari tabel `publication_galley_settings`
--

CREATE TABLE `publication_galley_settings` (
  `galley_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `publication_settings`
--

CREATE TABLE `publication_settings` (
  `publication_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `publication_settings`
--

INSERT INTO `publication_settings` (`publication_id`, `locale`, `setting_name`, `setting_value`) VALUES
(1, '', 'categoryIds', '[]'),
(1, '', 'copyrightYear', '2023'),
(1, '', 'issueId', '0'),
(1, 'en_US', 'abstract', '<p><em>Pusdik Armed adalah Badan Pelaksana dari Pussen Armed yang secara organik dan administratif berada di bawah Pussen Armed Kodiklat TNI AD dan merupakan pelaksana utama Pussen Armed Kodiklat TNI AD di dalam menyelenggarakan pendidikan kecabangan Artileri Medan.</em>&nbsp;<em>Dalam melaksanakan tugas-tugas tersebut tentunya motivasi kerja sangat berperan penting dalam meningkatkan semangat kerja prajurit Artileri Medan. motivasi kerja adalah suatu dorongan intrinsik dan ekstrinsik yang menyebabkan seseorang (individu) untuk bertindak atau berbuat mencapai tujuan, sehingga perubahan tingkah laku pada diri prajurit diharapkan terjadi.</em>&nbsp;<em>Rancangan penelitian ini adalah non-eksperimental dimana dan jenis penelitian ini&nbsp;</em><em>adalah penelitian korelasional.</em>&nbsp;<em>Pada kegiatan penelitian ini populasi yang terlibat yaitu Organik Golongan Bintara diPusdik X sebanyak 129 prajurit.</em>&nbsp;<em>Dalam penelitian ini, penelitiakan menggunakan pengolahan menggunakan uji korelasi Pearson Product Moment.</em>&nbsp;<em>Didapatkan hasil yaitu terdapat hubungan antara Penyesuaian Diri dengan Motivasi Kerja pada Organik Bintara Pusdik Armed (0.922**). Menurut Klasifikasi Nilai Koefisien Korelasi r Pearson, hal ini termasuk ke dalam kategorisasi korelasi yang sangat besar atau sangat kuat.</em></p>'),
(1, 'en_US', 'copyrightHolder', 'Reliabel: Jurnal Ilmiah Psikologi'),
(1, 'en_US', 'prefix', ''),
(1, 'en_US', 'subtitle', ''),
(1, 'en_US', 'title', 'PENYESUAIAN DIRI DENGAN MOTIVASI KERJA PADA ORGANIK GOLONGAN BINTARA PUSDIK X'),
(2, '', 'categoryIds', '[]'),
(2, '', 'copyrightYear', '2023'),
(2, '', 'issueId', '0'),
(2, 'en_US', 'abstract', '<div>\r\n<div>Lorem, ipsum dolor sit amet consectetur adipisicing elit. Molestias dicta harum, quos quidem ipsum magni impedit quaerat numquam non cumque. Libero quisquam ratione repellat aliquam fuga ducimus deleniti, voluptates ex illum, rerum asperiores impedit iure corporis consectetur modi eaque magnam nulla provident reprehenderit accusantium obcaecati. Quo voluptatum ex aliquid iusto.</div>\r\n</div>'),
(2, 'en_US', 'copyrightHolder', 'Reliabel: Jurnal Ilmiah Psikologi'),
(2, 'en_US', 'prefix', 'asa'),
(2, 'en_US', 'subtitle', 'asasa'),
(2, 'en_US', 'title', 'asas'),
(4, '', 'categoryIds', '[]'),
(4, 'en_US', 'abstract', '<p style=\"font-weight: 400;\">Tujuan dari penelitian ini adalah untuk mengetahui hubungan antara <em>pet attachment</em> dengan strategi regulasi emosi yakni <em>cognitive reappraisal</em> dan <em>expressive suppression</em>. Penelitian ini termasuk kedalam penelitian kuantitatif. Penelitian dilakukan pada 62 mahasiswa UNJANI yang memelihara kucing, berusia 18-25 tahun, yang terdiri dari 7 laki-laki dan 55 perempuan. Pengambilan sampel menggunakan teknik <em>accidental sampling. </em>Alat ukur yang digunakan untuk mengukur regulasi emosi adalah <em>ERQ (Emotion Regulation Questionnaire)</em> milik Gross, J.J., &amp; John, O. p. (2003). Kemudian untuk mengukur <em>pet attachment</em> menggunakan <em>LAPS</em> (<em>Lexington Attachments to Pets Scale)</em> alat ukur ini dirancang oleh Johnson, Garrity, &amp; Stallones (1992) Penelitian ini menggunakan uji korelasi <em>rank spearman</em>. Hasil dari penelitian, tidak terdapat hubungan yang signifikan antara <em>pet attachment</em>dengan <em>cognitive reappraisal</em> Hal ini diketahui dari skor <em>p-value</em> yang diperoleh sebesar 0.068 dengan nilai koefisien korelasi sebesar 0.233 yang berarti berada dalam kategori lemah positif. Begitupun <em>pet attachment </em>dan strategi <em>expressive suppression</em> diketahui tidak terdapat hubungan yang signifikan dikarenakan memiliki <em>p-value</em> sebesar 0.195, dengan nilai koefisien sebesar 0.167 atau dapat dikatakan berada dalam kategori lemah positif.</p>'),
(4, 'en_US', 'prefix', ''),
(4, 'en_US', 'subtitle', ''),
(4, 'en_US', 'title', 'Hubungan Pet Attachment dan Strategi Regulasi Emosi '),
(5, '', 'categoryIds', '[]'),
(5, 'en_US', 'abstract', '<table width=\"605\">\r\n<tbody>\r\n<tr>\r\n<td width=\"468\">\r\n<p><strong><em>Abstract.</em></strong> <em>Hopeless</em><em> can encourage ending life</em><em>, b</em><em>ecause feels empty an</em><em>d pessimistic about future</em><em> makes </em><em>decrease life </em><em>spirit and difficult to think clearly. Individuals who experience </em><em>parental death</em><em> may experience hopelessness.</em> <em>U</em><em>nderstanding hopelessness nee</em><em>ds</em><em> in order to know what is actually being experienced, </em><em>and why </em><em>a suicide attempt is made </em><em>so later </em><em>can provide right treatment. </em><em>A</em><em>im of this research is to provide an overview of the experiences of </em><em>hopeless</em><em> in individuals who are trying to end</em><em>ing life</em><em>. This is a descriptive phenomenological study using three participants by conducting in-depth interviews. From this research, it was found that the hopelessness was caused by deep sorrow due the loss of a significant figure that made dreams and hopes in life disappear, coupled with feelings of regret and uselessness, making suicide finally chosen. After multiple failed suicide attempts, positive coping, access to medication, and spirituality are reported as ways to end hopelessness.</em></p>\r\n<p><strong><em>Keywords: </em></strong><strong><em>Hopeless; Hopelessness; Parental death; Suicide Attempt</em></strong></p>\r\n<p><em>&nbsp;</em></p>\r\n<p><strong>Abstrak.</strong> Putus asa seringkali mendorong pemikiran mengakhiri hidup, ini karena hidup terasa hampa tanpa harapan dan pesimis terhadap masa depan, membuat kehilangan semangat hidup dan sulit berfikir jernih. Individu yang kehilangan sosok penting dalam hidupnya seperti kematian orang tua dapat jatuh dalam keputusasaan. Pemahaman mendalam mengenai pengalaman keputusasaan perlu dilakukan agar mengetahui apa yang sebenarnya dialami, dirasakan sehingga bunuh diri dilakukan agar kelak dapat memberikan penanganan yang tepat. Tujuan penelitian adalah memberikan gambaran pengalaman dan penghayatan putus asa pada individu yang berupaya mengakhiri hidup. Penelitian ini merupakan penelitian fenomenologis deskriptif menggunakan tiga partisipan dengan melakukan <em>depth interview</em><em>. </em>Dari penelitian ini ditemukan bahwa keputusasaan disebabkan oleh kesedihan mendalam akibat kehilangan sosok penting yang membuat impian dan harapan hidup sirna, ditambah dengan perasaan menyesal dan tidak berguna sehingga bunuh diri akhirnya dipilih. Setelah beberapa upaya bunuh diri yang gagal, <em>c</em><em>oping</em> positif, akses pengobatan, dan spiritualitas dilaporkan sebagai cara mengakhiri keputusasaan.</p>\r\n<p><strong><em>Kata kunc</em></strong><strong><em>i : Kematian Orangtua; Keputusasaan; Putus Asa, Upaya Bunuh Diri</em></strong></p>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>'),
(5, 'en_US', 'prefix', ''),
(5, 'en_US', 'subtitle', ''),
(5, 'en_US', 'title', 'Pengalaman Putus Asa pada Individu yang Berupaya Mengakhiri Hidup'),
(6, '', 'categoryIds', '[]'),
(6, 'en_US', 'abstract', '<p><em>This study highlights how the self-concept of gay individuals develops and how the surrounding environment influences this self-concept. The theory of self-concept utilized in this research is derived from William H. Fitts (1971). Employing a qualitative method with a descriptive approach, the study involved five respondents. Data were collected through interviews, following Fitts\' (1971) dimensions of self-concept, which generated 15 combinations of internal and external dimensions. The findings reveal variations in the self-concept of gay individuals: three out of five participants exhibited a negative self-concept, whereas the remaining two displayed a positive self-concept. The environment also plays a crucial role; an accepting environment supports a positive self-concept, while a rejecting environment contributes to a negative self-concept. The study suggests that society and parents should create a supportive environment for gay individuals, enabling them to feel accepted and subsequently reducing negative self-concepts</em></p>\r\n<p><em>Keywords: Self concept, gay</em></p>'),
(6, 'en_US', 'prefix', 'The'),
(6, 'en_US', 'subtitle', ''),
(6, 'en_US', 'title', 'Gay Self-Concept'),
(7, '', 'categoryIds', '[]'),
(7, 'en_US', 'abstract', '<p style=\"font-weight: 400;\">Penelitian ini bertujuan untuk mengetahui hubungan <em>Flow </em>Akademik dengan <em>Academic Burnout </em>pada mahasiswa Fakultas Psikologi Universitas Jenderal Achmad Yani selama masa pembelajaran daring. Penelitian ini menggunakan teori <em>flow </em>(Bakker, 2008) dan <em>academic burnout </em>(Schaufeli, et all., 2002). Pendekatan yang digunakan dalam penelitian ini adalah deduktif dengan metode penelitian kuantitatif dengan jenis penelitian korelasi. Penelitian ini melibatkan 247 responden yang merupakan mahasiswa Fakultas Psikologi Universitas Jenderal Achmad Yani. Proses pengambilan data, dilakukan dengan menyebarkan kuesioner alat ukur <em>The Study–Related Flow Inventory </em>(WOLF-S) dengan koefisien reliabilitas 0.866 dan <em>Maslach Burnout Inventory-Student Survei </em>(MBI-SS) dengan koefisien reliabilitas 0.859. Hasil yang didapatkan dengan uji korelasi <em>spearman rank </em>didapatkan hasil korelasi sebesar -0.377 dengan taraf signifikansi &lt;0.001 (p&lt;0.05). Artinya terdapat hubungan yang signifikan antara <em>flow</em> akademik dengan <em>academic burnout</em> pada mahasiswa Fakultas Psikologi Universitas Jenderal Achmad Yani selama masa pembelajaran daring. Saran bagi peneliti selanjutnya diharapkan dapat meneliti faktor lain yang berpengaruh terhadap terjadinya <em>flow</em> akademik, seperti kondisi lingkungan belajar dan perkuliahan.</p>'),
(7, 'en_US', 'prefix', ''),
(7, 'en_US', 'subtitle', ''),
(7, 'en_US', 'title', 'HUBUNGAN FLOW AKADEMIK DENGAN ACADEMIC BURNOUT PADA MAHASISWA DI FAKULTAS PSIKOLOGI UNIVERSITAS JENDERAL ACHMAD YANI'),
(8, '', 'categoryIds', '[]'),
(8, 'en_US', 'abstract', '<p>Tujuan dari penelitian ini adalah untuk mengetahui apakah terdapat hubungan antara Self Efficacy dengan Nonsuicidal Self Injury di Universitas X. Penelitian ini menggunakan metode penelitian kuantitatif korelasional. Subjek pada penelitian ini adalah seluruh mahasiswa aktif di Universitas X dengan menggunakan Purposive Sampling sebagai teknik pengambilan data. Sampel dalam penelitian ini berjumlah 122 mahasiswa dan penelitian ini menggunaka alat ukur berupa General Self Efficacy sedangkan untuk NSSI alat ukur pada penelitian ini dibuat berasarkan aspek-aspek NSSI dengan menggunakan skala likert. Analisis dalam penelitian ini menggunakan analisis korelasional Spearman’s rho dan diketahui terdapat hubungan negatif antara self efficacy dengan nonsuicidal self injury dengan nilai signifikan sebesar 0.000 (p &gt; 0.05) dengan nilai korelasi sebesar -0.363** yang berarti ada kemungkinan terdapat hubungan antara self efficacy dengan nonsuicidal self injury dalam penelitian ini. Hasil terebut menunjukkan bahwa, semakin tinggi self efficacy maka semakin rendah individu untuk melakukan NSSI hal tersebut juga berlaku sebaliknya yaitu, semakin tinggi NSSI maka semakin rendah self efficacy yang dimiliki individu.</p>\r\n<p><strong><em>Kata kunci</em></strong><em> : Dewasa Awal, Melukai Diri, Nonsuicidal Self Injury, Self Efficacy</em></p>'),
(8, 'en_US', 'prefix', ''),
(8, 'en_US', 'subtitle', ''),
(8, 'en_US', 'title', 'Self Efficacy Sebagai Prediktor Perilaku Non Suicidal Self Injury  Pada Mahasiswa'),
(9, '', 'categoryIds', '[]'),
(9, 'en_US', 'abstract', '<p>Abstrak&nbsp;</p>\r\n<p>Penelitian ini bertujuan untuk mengetahui kecemasan berbicara di depan umum pada mahasiswa skripsi fakultas Psikologi Universitas Bhayangkara Jakarta Raya, dimana rentang usia pada dewasa awal antara 18 hingga 25 tahun. Mahasiswa berada pada rentang usia tersebut, dimana dituntut untuk memiliki kemampuan berbicara di depan umum. Individu dapat dikatakan mengalami kecemasan ketika individu tersebut mengalami suatu kondisi adanya tekanan dalam diri akibat tuntutan yang berasal dari dalam diri maupun lingkungannya. Metode yang digunakan menggunakan metode kuantitatif dengan teknik pengumpulan data menggunakan kuesioner. Subjek penelitian adalah mahasiswa skripsi Fakultas Psikologi Universitas Bhayangkara Jakarta Raya yang berjumlah 50 orang mahasiswa. Hasil penelitian ini didapatkan dari gambaran kecemasan berbicara di depan umum pada mahasiswa skripsi Fakultas Psikologi Universitas Bhayangkara Jakarta Raya. Hasil uji normalitas menggunakan Kolmogorov Smirnov, didapatkan nilai signifikansi (p) sebesar 0,185 yang berarti data terdistribusi normal. Adapun hasil berdasarkan kategorisasi didapatkan yaitu subjek yang mempunyai kecemasan berbicara didepan umum sedang berjumlah 14 mahasiswa (28%) dan subjek yang mempunyai kecemasan berbicara didepan umum tinggi sebesar 36 mahasiswa (72%). Hasil ini menunjukkan bahwa sebagian besar subjek memiliki kecemasan berbicara didepan umum pada kategorisasi tinggi.</p>\r\n<p>Kata Kunci: kecemasan berbicara di depan umum, mahasiswa skripsi</p>'),
(9, 'en_US', 'prefix', ''),
(9, 'en_US', 'subtitle', ''),
(9, 'en_US', 'title', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI  UNIVERSITAS BHAYANGKARA JAKARTA RAYA');

-- --------------------------------------------------------

--
-- Struktur dari tabel `queries`
--

CREATE TABLE `queries` (
  `query_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `stage_id` smallint(6) NOT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00,
  `date_posted` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `closed` smallint(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `queries`
--

INSERT INTO `queries` (`query_id`, `assoc_type`, `assoc_id`, `stage_id`, `seq`, `date_posted`, `date_modified`, `closed`) VALUES
(3, 1048585, 8, 1, 1.00, NULL, NULL, 0);

-- --------------------------------------------------------

--
-- Struktur dari tabel `query_participants`
--

CREATE TABLE `query_participants` (
  `query_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `query_participants`
--

INSERT INTO `query_participants` (`query_id`, `user_id`) VALUES
(3, 13);

-- --------------------------------------------------------

--
-- Struktur dari tabel `queued_payments`
--

CREATE TABLE `queued_payments` (
  `queued_payment_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `expiry_date` date DEFAULT NULL,
  `payment_data` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_assignments`
--

CREATE TABLE `review_assignments` (
  `review_id` bigint(20) NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `reviewer_id` bigint(20) NOT NULL,
  `competing_interests` text DEFAULT NULL,
  `recommendation` smallint(6) DEFAULT NULL,
  `date_assigned` datetime DEFAULT NULL,
  `date_notified` datetime DEFAULT NULL,
  `date_confirmed` datetime DEFAULT NULL,
  `date_completed` datetime DEFAULT NULL,
  `date_acknowledged` datetime DEFAULT NULL,
  `date_due` datetime DEFAULT NULL,
  `date_response_due` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `reminder_was_automatic` smallint(6) NOT NULL DEFAULT 0,
  `declined` smallint(6) NOT NULL DEFAULT 0,
  `cancelled` smallint(6) NOT NULL DEFAULT 0,
  `reviewer_file_id` bigint(20) DEFAULT NULL,
  `date_rated` datetime DEFAULT NULL,
  `date_reminded` datetime DEFAULT NULL,
  `quality` smallint(6) DEFAULT NULL,
  `review_round_id` bigint(20) NOT NULL,
  `stage_id` smallint(6) NOT NULL,
  `review_method` smallint(6) NOT NULL DEFAULT 1,
  `round` smallint(6) NOT NULL DEFAULT 1,
  `step` smallint(6) NOT NULL DEFAULT 1,
  `review_form_id` bigint(20) DEFAULT NULL,
  `unconsidered` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `review_assignments`
--

INSERT INTO `review_assignments` (`review_id`, `submission_id`, `reviewer_id`, `competing_interests`, `recommendation`, `date_assigned`, `date_notified`, `date_confirmed`, `date_completed`, `date_acknowledged`, `date_due`, `date_response_due`, `last_modified`, `reminder_was_automatic`, `declined`, `cancelled`, `reviewer_file_id`, `date_rated`, `date_reminded`, `quality`, `review_round_id`, `stage_id`, `review_method`, `round`, `step`, `review_form_id`, `unconsidered`) VALUES
(1, 4, 7, NULL, 2, '2023-08-28 14:51:15', '2023-08-28 14:51:15', '2023-09-04 12:57:34', '2023-09-04 13:19:50', NULL, '2023-09-25 00:00:00', '2023-09-25 00:00:00', '2023-09-04 13:19:50', 0, 0, 0, NULL, NULL, NULL, NULL, 1, 3, 2, 1, 4, NULL, 0),
(2, 5, 7, NULL, 2, '2023-08-28 16:23:47', '2023-08-28 16:23:48', '2023-09-04 12:55:01', '2023-09-04 13:32:11', NULL, '2023-09-25 00:00:00', '2023-09-25 00:00:00', '2023-09-04 13:32:11', 0, 0, 0, NULL, NULL, NULL, NULL, 2, 3, 2, 1, 4, NULL, 0),
(3, 7, 12, NULL, NULL, '2023-09-05 01:01:03', '2023-09-05 01:01:03', NULL, NULL, NULL, '2023-09-10 00:00:00', '2023-09-07 00:00:00', '2023-09-05 01:01:03', 0, 0, 0, NULL, NULL, NULL, NULL, 3, 3, 2, 1, 1, NULL, 0),
(4, 6, 12, NULL, NULL, '2023-09-05 01:02:20', '2023-09-05 01:02:20', NULL, NULL, NULL, '2023-09-10 00:00:00', '2023-09-07 00:00:00', '2023-09-05 01:02:20', 0, 0, 0, NULL, NULL, NULL, NULL, 4, 3, 2, 1, 1, NULL, 0);

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_files`
--

CREATE TABLE `review_files` (
  `review_id` bigint(20) NOT NULL,
  `submission_file_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `review_files`
--

INSERT INTO `review_files` (`review_id`, `submission_file_id`) VALUES
(1, 20),
(2, 22),
(3, 27),
(4, 28);

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_forms`
--

CREATE TABLE `review_forms` (
  `review_form_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `seq` double(8,2) DEFAULT NULL,
  `is_active` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_form_elements`
--

CREATE TABLE `review_form_elements` (
  `review_form_element_id` bigint(20) NOT NULL,
  `review_form_id` bigint(20) NOT NULL,
  `seq` double(8,2) DEFAULT NULL,
  `element_type` bigint(20) DEFAULT NULL,
  `required` smallint(6) DEFAULT NULL,
  `included` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_form_element_settings`
--

CREATE TABLE `review_form_element_settings` (
  `review_form_element_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_form_responses`
--

CREATE TABLE `review_form_responses` (
  `review_form_element_id` bigint(20) NOT NULL,
  `review_id` bigint(20) NOT NULL,
  `response_type` varchar(6) DEFAULT NULL,
  `response_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_form_settings`
--

CREATE TABLE `review_form_settings` (
  `review_form_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_rounds`
--

CREATE TABLE `review_rounds` (
  `review_round_id` bigint(20) NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `stage_id` bigint(20) DEFAULT NULL,
  `round` smallint(6) NOT NULL,
  `review_revision` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `review_rounds`
--

INSERT INTO `review_rounds` (`review_round_id`, `submission_id`, `stage_id`, `round`, `review_revision`, `status`) VALUES
(1, 4, 3, 1, NULL, 1),
(2, 5, 3, 1, NULL, 1),
(3, 7, 3, 1, NULL, 7),
(4, 6, 3, 1, NULL, 7);

-- --------------------------------------------------------

--
-- Struktur dari tabel `review_round_files`
--

CREATE TABLE `review_round_files` (
  `submission_id` bigint(20) NOT NULL,
  `review_round_id` bigint(20) NOT NULL,
  `stage_id` smallint(6) NOT NULL,
  `submission_file_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `review_round_files`
--

INSERT INTO `review_round_files` (`submission_id`, `review_round_id`, `stage_id`, `submission_file_id`) VALUES
(4, 1, 3, 20),
(4, 1, 3, 25),
(5, 2, 3, 22),
(5, 2, 3, 26),
(6, 4, 3, 28),
(7, 3, 3, 27);

-- --------------------------------------------------------

--
-- Struktur dari tabel `scheduled_tasks`
--

CREATE TABLE `scheduled_tasks` (
  `class_name` varchar(255) NOT NULL,
  `last_run` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `scheduled_tasks`
--

INSERT INTO `scheduled_tasks` (`class_name`, `last_run`) VALUES
('classes.tasks.SubscriptionExpiryReminder', '2023-09-01 00:00:46'),
('lib.pkp.classes.task.ReviewReminder', '2023-09-05 09:52:31'),
('lib.pkp.classes.task.StatisticsReport', '2023-09-01 00:00:46'),
('plugins.generic.usageStats.UsageStatsLoader', '2023-09-05 09:52:29'),
('plugins.importexport.crossref.CrossrefInfoSender', '2023-09-05 09:52:30'),
('plugins.importexport.datacite.DataciteInfoSender', '2023-09-05 09:52:31'),
('plugins.importexport.doaj.DOAJInfoSender', '2023-09-05 09:52:31');

-- --------------------------------------------------------

--
-- Struktur dari tabel `sections`
--

CREATE TABLE `sections` (
  `section_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `review_form_id` bigint(20) DEFAULT NULL,
  `seq` double(8,2) NOT NULL DEFAULT 0.00,
  `editor_restricted` smallint(6) NOT NULL DEFAULT 0,
  `meta_indexed` smallint(6) NOT NULL DEFAULT 0,
  `meta_reviewed` smallint(6) NOT NULL DEFAULT 1,
  `abstracts_not_required` smallint(6) NOT NULL DEFAULT 0,
  `hide_title` smallint(6) NOT NULL DEFAULT 0,
  `hide_author` smallint(6) NOT NULL DEFAULT 0,
  `is_inactive` smallint(6) NOT NULL DEFAULT 0,
  `abstract_word_count` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `sections`
--

INSERT INTO `sections` (`section_id`, `journal_id`, `review_form_id`, `seq`, `editor_restricted`, `meta_indexed`, `meta_reviewed`, `abstracts_not_required`, `hide_title`, `hide_author`, `is_inactive`, `abstract_word_count`) VALUES
(1, 1, 0, 0.00, 0, 1, 1, 0, 0, 0, 0, NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `section_settings`
--

CREATE TABLE `section_settings` (
  `section_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `section_settings`
--

INSERT INTO `section_settings` (`section_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(1, 'en_US', 'abbrev', 'ART', 'string'),
(1, 'en_US', 'identifyType', '', 'string'),
(1, 'en_US', 'policy', '', 'string'),
(1, 'en_US', 'title', 'Articles', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `site_settings`
--

CREATE TABLE `site_settings` (
  `setting_name` varchar(255) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `site_settings`
--

INSERT INTO `site_settings` (`setting_name`, `locale`, `setting_value`) VALUES
('contactEmail', 'en_US', 'mulyanurdin10@gmail.com'),
('contactName', 'en_US', 'Open Journal Systems'),
('contactName', 'id_ID', 'Open Journal Systems'),
('themePluginPath', '', 'default');

-- --------------------------------------------------------

--
-- Struktur dari tabel `stage_assignments`
--

CREATE TABLE `stage_assignments` (
  `stage_assignment_id` bigint(20) NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `user_group_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `date_assigned` datetime NOT NULL,
  `recommend_only` smallint(6) NOT NULL DEFAULT 0,
  `can_change_metadata` smallint(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `stage_assignments`
--

INSERT INTO `stage_assignments` (`stage_assignment_id`, `submission_id`, `user_group_id`, `user_id`, `date_assigned`, `recommend_only`, `can_change_metadata`) VALUES
(1, 1, 2, 1, '2023-03-18 15:14:36', 0, 1),
(2, 1, 3, 2, '2023-03-18 15:24:36', 0, 1),
(3, 2, 14, 2, '2023-03-25 14:18:38', 0, 0),
(4, 2, 3, 2, '2023-03-25 14:19:39', 0, 1),
(6, 4, 14, 6, '2023-08-28 13:47:43', 0, 0),
(7, 4, 3, 2, '2023-08-28 14:52:19', 1, 1),
(8, 5, 14, 8, '2023-08-28 16:16:55', 0, 0),
(9, 5, 3, 2, '2023-08-28 16:20:58', 0, 1),
(10, 6, 14, 10, '2023-09-04 04:00:00', 0, 0),
(11, 6, 3, 9, '2023-09-04 04:07:28', 0, 1),
(12, 7, 14, 11, '2023-09-04 11:00:07', 0, 0),
(13, 7, 3, 9, '2023-09-04 11:05:21', 0, 1),
(14, 8, 14, 13, '2023-09-05 12:00:26', 0, 0),
(15, 8, 3, 9, '2023-09-05 12:02:31', 0, 1),
(16, 9, 14, 14, '2023-09-05 13:04:24', 0, 0),
(17, 9, 3, 9, '2023-09-05 13:10:15', 0, 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `static_pages`
--

CREATE TABLE `static_pages` (
  `static_page_id` bigint(20) NOT NULL,
  `path` varchar(255) NOT NULL,
  `context_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `static_pages`
--

INSERT INTO `static_pages` (`static_page_id`, `path`, `context_id`) VALUES
(1, 'focusandscope', 1),
(2, 'reviewers', 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `static_page_settings`
--

CREATE TABLE `static_page_settings` (
  `static_page_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` longtext DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `static_page_settings`
--

INSERT INTO `static_page_settings` (`static_page_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(1, 'en_US', 'content', '<p>We welcome articles from any psychology-related subjects that could fall under these sub-themes: Educational Psychology, Clinical Psychology, Industrial/Organizational Psychology, Developmental Psychology, Social Psychology, Military Psychology, Experimental Psychology, Psychometrics,&nbsp;Cognition and Neuroscience, Health Psychology.&nbsp;</p>\r\n<p>Jurnal Ilmiah Psikologi Reliabel publishes articles that contribute theoretical studies (e.g. systematic reviews, new thoughts on research methodology and design, criticism and discussion of theoretical models, meta-theoretical) as well as contributions to the results of empirical and applied research (e.g. empirical reports, meta-analyses) both qualitative and quantitative research.&nbsp;</p>\r\n<p>All submitted manuscripts must be original, previously unpublished or must NOT be under consideration for publication elsewhere.</p>', 'string'),
(1, 'en_US', 'title', 'Focus and Scope', 'string'),
(2, 'en_US', 'content', '<h4>Reviewer</h4>\r\n<p>Ifran Fahmi, Universitas Islam Negeri Sunan Gunung Djati</p>\r\n<p>Chandra Yudistira, Universitas Jenderal Achmad Yani</p>\r\n<p>Akhmad Rifandi, Universitas Muhammadiyah Banjarmasin</p>\r\n<p>&nbsp;</p>', 'string'),
(2, 'en_US', 'title', 'Reviewers', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `subeditor_submission_group`
--

CREATE TABLE `subeditor_submission_group` (
  `context_id` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `submissions`
--

CREATE TABLE `submissions` (
  `submission_id` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `current_publication_id` bigint(20) DEFAULT NULL,
  `date_last_activity` datetime DEFAULT NULL,
  `date_submitted` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `stage_id` bigint(20) NOT NULL DEFAULT 1,
  `locale` varchar(14) DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT 1,
  `submission_progress` smallint(6) NOT NULL DEFAULT 1,
  `work_type` smallint(6) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `submissions`
--

INSERT INTO `submissions` (`submission_id`, `context_id`, `current_publication_id`, `date_last_activity`, `date_submitted`, `last_modified`, `stage_id`, `locale`, `status`, `submission_progress`, `work_type`) VALUES
(1, 1, 1, '2023-08-26 14:13:32', '2023-03-18 15:16:57', '2023-03-18 15:16:57', 5, 'en_US', 1, 0, 0),
(2, 1, 2, '2023-08-26 14:13:31', '2023-03-25 14:19:39', '2023-03-25 14:19:39', 5, 'en_US', 1, 0, 0),
(4, 1, 4, '2023-09-05 05:15:00', '2023-08-28 13:49:06', '2023-08-28 13:49:06', 3, 'en_US', 1, 0, 0),
(5, 1, 5, '2023-09-05 03:17:08', '2023-08-28 16:20:58', '2023-08-28 16:20:58', 3, 'en_US', 1, 0, 0),
(6, 1, 6, '2023-09-05 01:02:20', '2023-09-04 04:07:28', '2023-09-04 04:07:28', 3, 'en_US', 1, 0, 0),
(7, 1, 7, '2023-09-05 01:01:03', '2023-09-04 11:05:21', '2023-09-04 11:05:21', 3, 'en_US', 1, 0, 0),
(8, 1, 8, '2023-09-05 12:02:41', '2023-09-05 12:02:31', '2023-09-05 12:02:31', 1, 'en_US', 1, 0, 0),
(9, 1, 9, '2023-09-05 13:10:22', '2023-09-05 13:10:15', '2023-09-05 13:10:15', 1, 'en_US', 1, 0, 0);

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_comments`
--

CREATE TABLE `submission_comments` (
  `comment_id` bigint(20) NOT NULL,
  `comment_type` bigint(20) DEFAULT NULL,
  `role_id` bigint(20) NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `author_id` bigint(20) NOT NULL,
  `comment_title` text NOT NULL,
  `comments` text DEFAULT NULL,
  `date_posted` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `viewable` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `submission_comments`
--

INSERT INTO `submission_comments` (`comment_id`, `comment_type`, `role_id`, `submission_id`, `assoc_id`, `author_id`, `comment_title`, `comments`, `date_posted`, `date_modified`, `viewable`) VALUES
(1, 1, 4096, 4, 1, 7, '', '<p>Mohon mempertimbangkan komentar dan saran yang telah diberikan.</p>\r\n<p>Semoga sukses selalu.</p>', '2023-09-04 13:19:46', NULL, 1),
(2, 1, 4096, 5, 2, 7, '', '<p>Mohon pertimbangkan komentar dan saran yang diberikan.</p>\r\n<p>Semoga sukses selalu.</p>\r\n<p>&nbsp;</p>\r\n<p>Terima kasih.</p>', '2023-09-04 13:32:07', NULL, 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_files`
--

CREATE TABLE `submission_files` (
  `submission_file_id` bigint(20) UNSIGNED NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `file_id` bigint(20) UNSIGNED NOT NULL,
  `source_submission_file_id` bigint(20) DEFAULT NULL,
  `genre_id` bigint(20) DEFAULT NULL,
  `file_stage` bigint(20) NOT NULL,
  `direct_sales_price` varchar(255) DEFAULT NULL,
  `sales_type` varchar(255) DEFAULT NULL,
  `viewable` smallint(6) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `uploader_user_id` bigint(20) DEFAULT NULL,
  `assoc_type` bigint(20) DEFAULT NULL,
  `assoc_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `submission_files`
--

INSERT INTO `submission_files` (`submission_file_id`, `submission_id`, `file_id`, `source_submission_file_id`, `genre_id`, `file_stage`, `direct_sales_price`, `sales_type`, `viewable`, `created_at`, `updated_at`, `uploader_user_id`, `assoc_type`, `assoc_id`) VALUES
(1, 1, 1, NULL, 1, 2, NULL, NULL, NULL, '2023-03-18 15:15:25', '2023-03-18 15:15:28', 1, NULL, NULL),
(2, 1, 2, NULL, 1, 10, NULL, NULL, NULL, '2023-03-18 15:28:48', '2023-03-18 15:28:59', 2, 521, 1),
(19, 4, 18, NULL, 1, 2, NULL, NULL, NULL, '2023-08-28 13:48:02', '2023-08-28 13:48:21', 6, NULL, NULL),
(20, 4, 18, 19, 1, 4, NULL, NULL, NULL, '2023-08-28 14:50:12', '2023-08-28 14:50:12', 6, NULL, NULL),
(21, 5, 19, NULL, 1, 2, NULL, NULL, NULL, '2023-08-28 16:18:14', '2023-08-28 16:18:27', 8, NULL, NULL),
(22, 5, 19, 21, 1, 4, NULL, NULL, NULL, '2023-08-28 16:23:21', '2023-08-28 16:23:21', 8, NULL, NULL),
(23, 6, 20, NULL, 1, 2, NULL, NULL, NULL, '2023-09-04 04:00:16', '2023-09-04 04:00:30', 10, NULL, NULL),
(24, 7, 21, NULL, 1, 2, NULL, NULL, NULL, '2023-09-04 11:01:44', '2023-09-04 11:01:49', 11, NULL, NULL),
(25, 4, 22, NULL, 0, 5, NULL, NULL, 1, '2023-09-04 13:18:20', '2023-09-04 13:18:26', 7, 517, 1),
(26, 5, 23, NULL, 0, 5, NULL, NULL, 1, '2023-09-04 13:31:49', '2023-09-04 13:31:55', 7, 517, 2),
(27, 7, 21, 24, 1, 4, NULL, NULL, NULL, '2023-09-05 01:00:00', '2023-09-05 01:00:00', 11, NULL, NULL),
(28, 6, 20, 23, 1, 4, NULL, NULL, NULL, '2023-09-05 01:01:48', '2023-09-05 01:01:48', 10, NULL, NULL),
(29, 8, 24, NULL, 1, 2, NULL, NULL, NULL, '2023-09-05 12:01:00', '2023-09-05 12:01:05', 13, NULL, NULL),
(30, 9, 25, NULL, 4, 2, NULL, NULL, NULL, '2023-09-05 13:04:49', '2023-09-05 13:07:04', 14, NULL, NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_file_revisions`
--

CREATE TABLE `submission_file_revisions` (
  `revision_id` bigint(20) UNSIGNED NOT NULL,
  `submission_file_id` bigint(20) UNSIGNED NOT NULL,
  `file_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `submission_file_revisions`
--

INSERT INTO `submission_file_revisions` (`revision_id`, `submission_file_id`, `file_id`) VALUES
(1, 1, 1),
(2, 2, 2),
(19, 19, 18),
(20, 20, 18),
(21, 21, 19),
(22, 22, 19),
(23, 23, 20),
(24, 24, 21),
(25, 25, 22),
(26, 26, 23),
(27, 27, 21),
(28, 28, 20),
(29, 29, 24),
(30, 30, 25);

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_file_settings`
--

CREATE TABLE `submission_file_settings` (
  `submission_file_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL DEFAULT 'string' COMMENT '(bool|int|float|string|object|date)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `submission_file_settings`
--

INSERT INTO `submission_file_settings` (`submission_file_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(1, 'en_US', 'name', 'Artike+niken (1).pdf', 'string'),
(2, 'en_US', 'name', 'Artike+niken.pdf', 'string'),
(19, 'en_US', 'name', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(20, 'en_US', 'name', 'Jurnal Reliabel 2023_Pet Atcchment & regulasi emosi_rina & vanessa.docx', 'string'),
(21, 'en_US', 'name', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(22, 'en_US', 'name', 'Dyah_Jurnal Reliabel_Maret 2023.docx', 'string'),
(23, 'en_US', 'name', 'konsep diri gay.docx', 'string'),
(24, 'en_US', 'name', 'Reliabel Adhita.docx', 'string'),
(25, 'en_US', 'name', 'fin_reliabel-review-assignment-4-Article+Text-20.docx', 'string'),
(26, 'en_US', 'name', 'fin_reliabel-review-assignment-5-Article+Text-22.docx', 'string'),
(27, 'en_US', 'name', 'Reliabel Adhita.docx', 'string'),
(28, 'en_US', 'name', 'konsep diri gay.docx', 'string'),
(29, 'en_US', 'name', 'Self Efficacy Sebagai Prediktor Perilaku NSSI.docx', 'string'),
(30, 'en_US', 'name', 'KECEMASAN BERBICARA DI DEPAN UMUM PADA MAHASISWA SKRIPSI FAKULTAS PSIKOLOGI UBJ.docx', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_search_keyword_list`
--

CREATE TABLE `submission_search_keyword_list` (
  `keyword_id` bigint(20) NOT NULL,
  `keyword_text` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `submission_search_keyword_list`
--

INSERT INTO `submission_search_keyword_list` (`keyword_id`, `keyword_text`) VALUES
(145, 'accusantium'),
(15, 'adalah'),
(113, 'adipisicing'),
(23, 'administratif'),
(129, 'aliquam'),
(149, 'aliquid'),
(111, 'amet'),
(101, 'andi'),
(91, 'antara'),
(14, 'armed'),
(34, 'artileri'),
(103, 'asa'),
(104, 'asas'),
(105, 'asasa'),
(136, 'asperiores'),
(56, 'atau'),
(16, 'badan'),
(25, 'bawah'),
(24, 'berada'),
(57, 'berbuat'),
(42, 'berperan'),
(55, 'bertindak'),
(99, 'besar'),
(12, 'bintara'),
(2, 'cahyorinartri'),
(112, 'consectetur'),
(138, 'corporis'),
(124, 'cumque'),
(30, 'dalam'),
(22, 'dan'),
(18, 'dari'),
(132, 'deleniti'),
(6, 'dengan'),
(116, 'dicta'),
(87, 'didapatkan'),
(64, 'diharapkan'),
(70, 'dimana'),
(77, 'dipusdik'),
(5, 'diri'),
(106, 'div'),
(109, 'dolor'),
(48, 'dorongan'),
(131, 'ducimus'),
(140, 'eaque'),
(50, 'ekstrinsik'),
(114, 'elit'),
(130, 'fuga'),
(11, 'golongan'),
(96, 'hal'),
(117, 'harum'),
(88, 'hasil'),
(90, 'hubungan'),
(134, 'illum'),
(121, 'impedit'),
(53, 'individu'),
(68, 'ini'),
(49, 'intrinsik'),
(108, 'ipsum'),
(137, 'iure'),
(150, 'iusto'),
(71, 'jenis'),
(98, 'kategorisasi'),
(33, 'kecabangan'),
(73, 'kegiatan'),
(8, 'kerja'),
(93, 'klasifikasi'),
(26, 'kodiklat'),
(95, 'koefisien'),
(83, 'korelasi'),
(72, 'korelasional'),
(100, 'kuat'),
(63, 'laku'),
(125, 'libero'),
(107, 'lorem'),
(141, 'magnam'),
(120, 'magni'),
(35, 'medan'),
(37, 'melaksanakan'),
(58, 'mencapai'),
(80, 'menggunakan'),
(44, 'meningkatkan'),
(92, 'menurut'),
(51, 'menyebabkan'),
(31, 'menyelenggarakan'),
(28, 'merupakan'),
(139, 'modi'),
(115, 'molestias'),
(86, 'moment'),
(7, 'motivasi'),
(36, 'nbsp'),
(1, 'niken'),
(94, 'nilai'),
(69, 'non-eksperimental'),
(142, 'nulla'),
(123, 'numquam'),
(146, 'obcaecati'),
(10, 'organik'),
(9, 'pada'),
(84, 'pearson'),
(17, 'pelaksana'),
(32, 'pendidikan'),
(79, 'penelitiakan'),
(67, 'penelitian'),
(81, 'pengolahan'),
(43, 'penting'),
(4, 'penyesuaian'),
(61, 'perubahan'),
(74, 'populasi'),
(46, 'prajurit'),
(85, 'product'),
(143, 'provident'),
(13, 'pusdik'),
(19, 'pussen'),
(122, 'quaerat'),
(119, 'quidem'),
(126, 'quisquam'),
(147, 'quo'),
(118, 'quos'),
(66, 'rancangan'),
(127, 'ratione'),
(128, 'repellat'),
(144, 'reprehenderit'),
(135, 'rerum'),
(41, 'sangat'),
(78, 'sebanyak'),
(21, 'secara'),
(60, 'sehingga'),
(45, 'semangat'),
(52, 'seseorang'),
(110, 'sit'),
(47, 'suatu'),
(102, 'supriadi'),
(40, 'tentunya'),
(89, 'terdapat'),
(65, 'terjadi'),
(75, 'terlibat'),
(97, 'termasuk'),
(39, 'tersebut'),
(62, 'tingkah'),
(27, 'tni'),
(38, 'tugas-tugas'),
(59, 'tujuan'),
(82, 'uji'),
(3, 'unjani'),
(54, 'untuk'),
(29, 'utama'),
(133, 'voluptates'),
(148, 'voluptatum'),
(76, 'yaitu'),
(20, 'yang');

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_search_objects`
--

CREATE TABLE `submission_search_objects` (
  `object_id` bigint(20) NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `type` int(11) NOT NULL COMMENT 'Type of item. E.g., abstract, fulltext, etc.',
  `assoc_id` bigint(20) DEFAULT NULL COMMENT 'Optional ID of an associated record (e.g., a file_id)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_search_object_keywords`
--

CREATE TABLE `submission_search_object_keywords` (
  `object_id` bigint(20) NOT NULL,
  `keyword_id` bigint(20) NOT NULL,
  `pos` int(11) NOT NULL COMMENT 'Word position of the keyword in the object.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_settings`
--

CREATE TABLE `submission_settings` (
  `submission_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `submission_tombstones`
--

CREATE TABLE `submission_tombstones` (
  `tombstone_id` bigint(20) NOT NULL,
  `submission_id` bigint(20) NOT NULL,
  `date_deleted` datetime NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `section_id` bigint(20) NOT NULL,
  `set_spec` varchar(255) NOT NULL,
  `set_name` varchar(255) NOT NULL,
  `oai_identifier` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `subscriptions`
--

CREATE TABLE `subscriptions` (
  `subscription_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `type_id` bigint(20) NOT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT 1,
  `membership` varchar(40) DEFAULT NULL,
  `reference_number` varchar(40) DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `subscription_types`
--

CREATE TABLE `subscription_types` (
  `type_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `cost` double(8,2) NOT NULL,
  `currency_code_alpha` varchar(3) NOT NULL,
  `duration` smallint(6) DEFAULT NULL,
  `format` smallint(6) NOT NULL,
  `institutional` smallint(6) NOT NULL DEFAULT 0,
  `membership` smallint(6) NOT NULL DEFAULT 0,
  `disable_public_display` smallint(6) NOT NULL,
  `seq` double(8,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `subscription_type_settings`
--

CREATE TABLE `subscription_type_settings` (
  `type_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `temporary_files`
--

CREATE TABLE `temporary_files` (
  `file_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `file_name` varchar(90) NOT NULL,
  `file_type` varchar(255) DEFAULT NULL,
  `file_size` bigint(20) NOT NULL,
  `original_file_name` varchar(127) DEFAULT NULL,
  `date_uploaded` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `usage_stats_temporary_records`
--

CREATE TABLE `usage_stats_temporary_records` (
  `assoc_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `day` bigint(20) NOT NULL,
  `entry_time` bigint(20) NOT NULL,
  `metric` bigint(20) NOT NULL DEFAULT 1,
  `country_id` varchar(2) DEFAULT NULL,
  `region` varchar(2) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `load_id` varchar(255) NOT NULL,
  `file_type` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Struktur dari tabel `user_groups`
--

CREATE TABLE `user_groups` (
  `user_group_id` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  `is_default` smallint(6) NOT NULL DEFAULT 0,
  `show_title` smallint(6) NOT NULL DEFAULT 1,
  `permit_self_registration` smallint(6) NOT NULL DEFAULT 0,
  `permit_metadata_edit` smallint(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `user_groups`
--

INSERT INTO `user_groups` (`user_group_id`, `context_id`, `role_id`, `is_default`, `show_title`, `permit_self_registration`, `permit_metadata_edit`) VALUES
(1, 0, 1, 1, 0, 0, 0),
(2, 1, 16, 1, 0, 0, 1),
(3, 1, 16, 1, 0, 0, 1),
(4, 1, 16, 1, 0, 0, 1),
(5, 1, 17, 1, 0, 0, 1),
(6, 1, 17, 1, 0, 0, 0),
(7, 1, 4097, 1, 0, 0, 0),
(8, 1, 4097, 1, 0, 0, 0),
(9, 1, 4097, 1, 0, 0, 0),
(10, 1, 4097, 1, 0, 0, 0),
(11, 1, 4097, 1, 0, 0, 0),
(12, 1, 4097, 1, 0, 0, 0),
(13, 1, 4097, 1, 0, 0, 0),
(14, 1, 65536, 1, 0, 1, 0),
(15, 1, 65536, 1, 0, 0, 0),
(16, 1, 4096, 1, 0, 1, 0),
(17, 1, 1048576, 1, 0, 1, 0),
(18, 1, 2097152, 1, 0, 0, 0);

-- --------------------------------------------------------

--
-- Struktur dari tabel `user_group_settings`
--

CREATE TABLE `user_group_settings` (
  `user_group_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `user_group_settings`
--

INSERT INTO `user_group_settings` (`user_group_id`, `locale`, `setting_name`, `setting_value`, `setting_type`) VALUES
(1, 'en_US', 'name', 'Site Admin', 'string'),
(1, 'id_ID', 'name', '##default.groups.name.siteAdmin##', 'string'),
(2, '', 'abbrevLocaleKey', 'default.groups.abbrev.manager', 'string'),
(2, '', 'nameLocaleKey', 'default.groups.name.manager', 'string'),
(2, 'en_US', 'abbrev', 'JM', 'string'),
(2, 'en_US', 'name', 'Journal manager', 'string'),
(2, 'id_ID', 'abbrev', 'JM', 'string'),
(2, 'id_ID', 'name', 'Manajer Jurnal', 'string'),
(3, '', 'abbrevLocaleKey', 'default.groups.abbrev.editor', 'string'),
(3, '', 'nameLocaleKey', 'default.groups.name.editor', 'string'),
(3, 'en_US', 'abbrev', 'JE', 'string'),
(3, 'en_US', 'name', 'Journal editor', 'string'),
(3, 'id_ID', 'abbrev', 'JE', 'string'),
(3, 'id_ID', 'name', 'Editor Jurnal', 'string'),
(4, '', 'abbrevLocaleKey', 'default.groups.abbrev.productionEditor', 'string'),
(4, '', 'nameLocaleKey', 'default.groups.name.productionEditor', 'string'),
(4, 'en_US', 'abbrev', 'ProdE', 'string'),
(4, 'en_US', 'name', 'Production editor', 'string'),
(4, 'id_ID', 'abbrev', 'ProdE', 'string'),
(4, 'id_ID', 'name', 'Editor produksi', 'string'),
(5, '', 'abbrevLocaleKey', 'default.groups.abbrev.sectionEditor', 'string'),
(5, '', 'nameLocaleKey', 'default.groups.name.sectionEditor', 'string'),
(5, 'en_US', 'abbrev', 'SecE', 'string'),
(5, 'en_US', 'name', 'Section editor', 'string'),
(5, 'id_ID', 'abbrev', 'EdBag', 'string'),
(5, 'id_ID', 'name', 'Editor Bagian', 'string'),
(6, '', 'abbrevLocaleKey', 'default.groups.abbrev.guestEditor', 'string'),
(6, '', 'nameLocaleKey', 'default.groups.name.guestEditor', 'string'),
(6, 'en_US', 'abbrev', 'GE', 'string'),
(6, 'en_US', 'name', 'Guest editor', 'string'),
(6, 'id_ID', 'abbrev', 'GE', 'string'),
(6, 'id_ID', 'name', 'Editor Tamu', 'string'),
(7, '', 'abbrevLocaleKey', 'default.groups.abbrev.copyeditor', 'string'),
(7, '', 'nameLocaleKey', 'default.groups.name.copyeditor', 'string'),
(7, 'en_US', 'abbrev', 'CE', 'string'),
(7, 'en_US', 'name', 'Copyeditor', 'string'),
(7, 'id_ID', 'abbrev', 'CE', 'string'),
(7, 'id_ID', 'name', 'Copyeditor', 'string'),
(8, '', 'abbrevLocaleKey', 'default.groups.abbrev.designer', 'string'),
(8, '', 'nameLocaleKey', 'default.groups.name.designer', 'string'),
(8, 'en_US', 'abbrev', 'Design', 'string'),
(8, 'en_US', 'name', 'Designer', 'string'),
(8, 'id_ID', 'abbrev', 'Desain', 'string'),
(8, 'id_ID', 'name', 'Desainer', 'string'),
(9, '', 'abbrevLocaleKey', 'default.groups.abbrev.funding', 'string'),
(9, '', 'nameLocaleKey', 'default.groups.name.funding', 'string'),
(9, 'en_US', 'abbrev', 'FC', 'string'),
(9, 'en_US', 'name', 'Funding coordinator', 'string'),
(9, 'id_ID', 'abbrev', 'FC', 'string'),
(9, 'id_ID', 'name', 'Koordinator pendanaan', 'string'),
(10, '', 'abbrevLocaleKey', 'default.groups.abbrev.indexer', 'string'),
(10, '', 'nameLocaleKey', 'default.groups.name.indexer', 'string'),
(10, 'en_US', 'abbrev', 'IND', 'string'),
(10, 'en_US', 'name', 'Indexer', 'string'),
(10, 'id_ID', 'abbrev', 'IND', 'string'),
(10, 'id_ID', 'name', 'Pengindeks', 'string'),
(11, '', 'abbrevLocaleKey', 'default.groups.abbrev.layoutEditor', 'string'),
(11, '', 'nameLocaleKey', 'default.groups.name.layoutEditor', 'string'),
(11, 'en_US', 'abbrev', 'LE', 'string'),
(11, 'en_US', 'name', 'Layout Editor', 'string'),
(11, 'id_ID', 'abbrev', 'LE', 'string'),
(11, 'id_ID', 'name', 'Editor Tata Letak', 'string'),
(12, '', 'abbrevLocaleKey', 'default.groups.abbrev.marketing', 'string'),
(12, '', 'nameLocaleKey', 'default.groups.name.marketing', 'string'),
(12, 'en_US', 'abbrev', 'MS', 'string'),
(12, 'en_US', 'name', 'Marketing and sales coordinator', 'string'),
(12, 'id_ID', 'abbrev', 'MS', 'string'),
(12, 'id_ID', 'name', 'Koordinator penjualan dan pemasaran', 'string'),
(13, '', 'abbrevLocaleKey', 'default.groups.abbrev.proofreader', 'string'),
(13, '', 'nameLocaleKey', 'default.groups.name.proofreader', 'string'),
(13, 'en_US', 'abbrev', 'PR', 'string'),
(13, 'en_US', 'name', 'Proofreader', 'string'),
(13, 'id_ID', 'abbrev', 'PR', 'string'),
(13, 'id_ID', 'name', 'Proofreader', 'string'),
(14, '', 'abbrevLocaleKey', 'default.groups.abbrev.author', 'string'),
(14, '', 'nameLocaleKey', 'default.groups.name.author', 'string'),
(14, 'en_US', 'abbrev', 'AU', 'string'),
(14, 'en_US', 'name', 'Author', 'string'),
(14, 'id_ID', 'abbrev', 'AU', 'string'),
(14, 'id_ID', 'name', 'Penulis', 'string'),
(15, '', 'abbrevLocaleKey', 'default.groups.abbrev.translator', 'string'),
(15, '', 'nameLocaleKey', 'default.groups.name.translator', 'string'),
(15, 'en_US', 'abbrev', 'Trans', 'string'),
(15, 'en_US', 'name', 'Translator', 'string'),
(15, 'id_ID', 'abbrev', 'Trans', 'string'),
(15, 'id_ID', 'name', 'Penerjemah', 'string'),
(16, '', 'abbrevLocaleKey', 'default.groups.abbrev.externalReviewer', 'string'),
(16, '', 'nameLocaleKey', 'default.groups.name.externalReviewer', 'string'),
(16, 'en_US', 'abbrev', 'R', 'string'),
(16, 'en_US', 'name', 'Reviewer', 'string'),
(16, 'id_ID', 'abbrev', 'R', 'string'),
(16, 'id_ID', 'name', 'Mitra Bestari', 'string'),
(17, '', 'abbrevLocaleKey', 'default.groups.abbrev.reader', 'string'),
(17, '', 'nameLocaleKey', 'default.groups.name.reader', 'string'),
(17, 'en_US', 'abbrev', 'Read', 'string'),
(17, 'en_US', 'name', 'Reader', 'string'),
(17, 'id_ID', 'abbrev', 'Baca', 'string'),
(17, 'id_ID', 'name', 'Pembaca', 'string'),
(18, '', 'abbrevLocaleKey', 'default.groups.abbrev.subscriptionManager', 'string'),
(18, '', 'nameLocaleKey', 'default.groups.name.subscriptionManager', 'string'),
(18, 'en_US', 'abbrev', 'SubM', 'string'),
(18, 'en_US', 'name', 'Subscription Manager', 'string'),
(18, 'id_ID', 'abbrev', 'MReg', 'string'),
(18, 'id_ID', 'name', 'Manajer Langganan', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `user_group_stage`
--

CREATE TABLE `user_group_stage` (
  `context_id` bigint(20) NOT NULL,
  `user_group_id` bigint(20) NOT NULL,
  `stage_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `user_group_stage`
--

INSERT INTO `user_group_stage` (`context_id`, `user_group_id`, `stage_id`) VALUES
(1, 3, 1),
(1, 3, 3),
(1, 3, 4),
(1, 3, 5),
(1, 4, 4),
(1, 4, 5),
(1, 5, 1),
(1, 5, 3),
(1, 5, 4),
(1, 5, 5),
(1, 6, 1),
(1, 6, 3),
(1, 6, 4),
(1, 6, 5),
(1, 7, 4),
(1, 8, 5),
(1, 9, 1),
(1, 9, 3),
(1, 10, 5),
(1, 11, 5),
(1, 12, 4),
(1, 13, 5),
(1, 14, 1),
(1, 14, 3),
(1, 14, 4),
(1, 14, 5),
(1, 15, 1),
(1, 15, 3),
(1, 15, 4),
(1, 15, 5),
(1, 16, 3);

-- --------------------------------------------------------

--
-- Struktur dari tabel `user_interests`
--

CREATE TABLE `user_interests` (
  `user_id` bigint(20) NOT NULL,
  `controlled_vocab_entry_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `user_interests`
--

INSERT INTO `user_interests` (`user_id`, `controlled_vocab_entry_id`) VALUES
(3, 7),
(7, 12),
(7, 13),
(7, 14),
(12, 22);

-- --------------------------------------------------------

--
-- Struktur dari tabel `user_settings`
--

CREATE TABLE `user_settings` (
  `user_id` bigint(20) NOT NULL,
  `locale` varchar(14) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `assoc_type` bigint(20) NOT NULL DEFAULT 0,
  `assoc_id` bigint(20) NOT NULL DEFAULT 0,
  `setting_value` text DEFAULT NULL,
  `setting_type` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `user_settings`
--

INSERT INTO `user_settings` (`user_id`, `locale`, `setting_name`, `assoc_type`, `assoc_id`, `setting_value`, `setting_type`) VALUES
(1, '', 'orcid', 0, 0, '', 'string'),
(1, 'en_US', 'affiliation', 0, 0, '', 'string'),
(1, 'en_US', 'biography', 0, 0, '', 'string'),
(1, 'en_US', 'familyName', 0, 0, 'admin', 'string'),
(1, 'en_US', 'givenName', 0, 0, 'admin', 'string'),
(1, 'en_US', 'preferredPublicName', 0, 0, '', 'string'),
(1, 'en_US', 'signature', 0, 0, '', 'string'),
(2, '', 'orcid', 0, 0, '', 'string'),
(2, 'en_US', 'affiliation', 0, 0, 'Unjani', 'string'),
(2, 'en_US', 'biography', 0, 0, '', 'string'),
(2, 'en_US', 'familyName', 0, 0, 'Supriadi', 'string'),
(2, 'en_US', 'givenName', 0, 0, 'Andi', 'string'),
(2, 'en_US', 'preferredPublicName', 0, 0, '', 'string'),
(2, 'en_US', 'signature', 0, 0, '', 'string'),
(3, 'en_US', 'affiliation', 0, 0, 'asdsadsdadasd', 'string'),
(3, 'en_US', 'familyName', 0, 0, 'sdadsdad', 'string'),
(3, 'en_US', 'givenName', 0, 0, 'swdasasdasd', 'string'),
(4, 'en_US', 'affiliation', 0, 0, 'Universitas Jenderal Achmad Yani', 'string'),
(4, 'en_US', 'familyName', 0, 0, 'ERNAWATI', 'string'),
(4, 'en_US', 'givenName', 0, 0, 'LINDA', 'string'),
(5, 'en_US', 'affiliation', 0, 0, 'Universitas Jenderal Achmad Yani', 'string'),
(5, 'en_US', 'familyName', 0, 0, 'ERNAWATI', 'string'),
(5, 'en_US', 'givenName', 0, 0, 'LINDA', 'string'),
(6, 'en_US', 'affiliation', 0, 0, 'Universitas Jenderal Achmad Yani', 'string'),
(6, 'en_US', 'familyName', 0, 0, 'Sari', 'string'),
(6, 'en_US', 'givenName', 0, 0, 'Rina', 'string'),
(7, '', 'orcid', 0, 0, '', 'string'),
(7, 'en_US', 'affiliation', 0, 0, 'Universitas Jenderal Achmad Yani Cimahi', 'string'),
(7, 'en_US', 'biography', 0, 0, '', 'string'),
(7, 'en_US', 'familyName', 0, 0, 'Purnama', 'string'),
(7, 'en_US', 'givenName', 0, 0, 'Chandra Yudistira', 'string'),
(7, 'en_US', 'preferredPublicName', 0, 0, '', 'string'),
(7, 'en_US', 'signature', 0, 0, '', 'string'),
(8, 'en_US', 'affiliation', 0, 0, 'Universitas Jenderal Achmad Yani', 'string'),
(8, 'en_US', 'familyName', 0, 0, '', 'string'),
(8, 'en_US', 'givenName', 0, 0, 'Dyah Titi S', 'string'),
(9, '', 'orcid', 0, 0, '', 'string'),
(9, 'en_US', 'affiliation', 0, 0, '', 'string'),
(9, 'en_US', 'biography', 0, 0, '', 'string'),
(9, 'en_US', 'familyName', 0, 0, 'Supriadi', 'string'),
(9, 'en_US', 'givenName', 0, 0, 'Andi', 'string'),
(9, 'en_US', 'preferredPublicName', 0, 0, '', 'string'),
(9, 'en_US', 'signature', 0, 0, '', 'string'),
(10, 'en_US', 'affiliation', 0, 0, 'Fakultas Psikologi Universitas Jenderal Achmad Yani', 'string'),
(10, 'en_US', 'familyName', 0, 0, 'Taufiq', 'string'),
(10, 'en_US', 'givenName', 0, 0, 'Rachmat', 'string'),
(11, 'en_US', 'affiliation', 0, 0, 'Universitas Jenderal Achmad Yani', 'string'),
(11, 'en_US', 'familyName', 0, 0, 'Asri', 'string'),
(11, 'en_US', 'givenName', 0, 0, 'Afini', 'string'),
(12, '', 'orcid', 0, 0, '', 'string'),
(12, 'en_US', 'affiliation', 0, 0, 'Universitas Muhammadiyah Banjarmasin', 'string'),
(12, 'en_US', 'biography', 0, 0, '', 'string'),
(12, 'en_US', 'familyName', 0, 0, '', 'string'),
(12, 'en_US', 'givenName', 0, 0, 'Akhmad Rifandi', 'string'),
(12, 'en_US', 'preferredPublicName', 0, 0, '', 'string'),
(12, 'en_US', 'signature', 0, 0, '', 'string'),
(13, 'en_US', 'affiliation', 0, 0, 'Universitas Bhayangkara Jakarta Raya', 'string'),
(13, 'en_US', 'familyName', 0, 0, 'Afriyenti', 'string'),
(13, 'en_US', 'givenName', 0, 0, 'Lenny Utama', 'string'),
(14, 'en_US', 'affiliation', 0, 0, 'Universitas bhayangkara jakarta raya', 'string'),
(14, 'en_US', 'familyName', 0, 0, 'Nasir', 'string'),
(14, 'en_US', 'givenName', 0, 0, 'Nurwahyuni', 'string');

-- --------------------------------------------------------

--
-- Struktur dari tabel `user_user_groups`
--

CREATE TABLE `user_user_groups` (
  `user_group_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `user_user_groups`
--

INSERT INTO `user_user_groups` (`user_group_id`, `user_id`) VALUES
(1, 1),
(2, 1),
(2, 9),
(3, 9),
(14, 6),
(14, 7),
(14, 8),
(14, 10),
(14, 11),
(14, 13),
(14, 14),
(16, 4),
(16, 5),
(16, 6),
(16, 7),
(16, 8),
(16, 12),
(16, 13),
(16, 14),
(17, 10),
(17, 11);

-- --------------------------------------------------------

--
-- Struktur dari tabel `versions`
--

CREATE TABLE `versions` (
  `major` int(11) NOT NULL DEFAULT 0 COMMENT 'Major component of version number, e.g. the 2 in OJS 2.3.8-0',
  `minor` int(11) NOT NULL DEFAULT 0 COMMENT 'Minor component of version number, e.g. the 3 in OJS 2.3.8-0',
  `revision` int(11) NOT NULL DEFAULT 0 COMMENT 'Revision component of version number, e.g. the 8 in OJS 2.3.8-0',
  `build` int(11) NOT NULL DEFAULT 0 COMMENT 'Build component of version number, e.g. the 0 in OJS 2.3.8-0',
  `date_installed` datetime NOT NULL,
  `current` smallint(6) NOT NULL DEFAULT 0 COMMENT '1 iff the version entry being described is currently active. This permits the table to store past installation history for forensic purposes.',
  `product_type` varchar(30) DEFAULT NULL COMMENT 'Describes the type of product this row describes, e.g. "plugins.generic" (for a generic plugin) or "core" for the application itelf',
  `product` varchar(30) DEFAULT NULL COMMENT 'Uniquely identifies the product this version row describes, e.g. "ojs2" for OJS 2.x, "languageToggle" for the language toggle block plugin, etc.',
  `product_class_name` varchar(80) DEFAULT NULL COMMENT 'Specifies the class name associated with this product, for plugins, or the empty string where not applicable.',
  `lazy_load` smallint(6) NOT NULL DEFAULT 0 COMMENT '1 iff the row describes a lazy-load plugin; 0 otherwise',
  `sitewide` smallint(6) NOT NULL DEFAULT 0 COMMENT '1 iff the row describes a site-wide plugin; 0 otherwise'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data untuk tabel `versions`
--

INSERT INTO `versions` (`major`, `minor`, `revision`, `build`, `date_installed`, `current`, `product_type`, `product`, `product_class_name`, `lazy_load`, `sitewide`) VALUES
(1, 0, 0, 0, '2023-03-17 20:25:50', 1, 'plugins.metadata', 'dc11', '', 0, 0),
(1, 0, 1, 0, '2023-03-17 20:25:50', 1, 'plugins.blocks', 'browse', 'BrowseBlockPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:50', 1, 'plugins.blocks', 'developedBy', 'DevelopedByBlockPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:50', 1, 'plugins.blocks', 'information', 'InformationBlockPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:50', 1, 'plugins.blocks', 'languageToggle', 'LanguageToggleBlockPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:50', 1, 'plugins.blocks', 'makeSubmission', 'MakeSubmissionBlockPlugin', 1, 0),
(1, 1, 0, 0, '2023-03-17 20:25:50', 1, 'plugins.blocks', 'subscription', 'SubscriptionBlockPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.gateways', 'resolver', '', 0, 0),
(1, 2, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'acron', 'AcronPlugin', 1, 1),
(1, 1, 3, 4, '2023-03-17 20:25:51', 1, 'plugins.generic', 'orcidProfile', 'OrcidProfilePlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'usageStats', 'UsageStatsPlugin', 0, 1),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'usageEvent', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'tinymce', 'TinyMCEPlugin', 1, 0),
(1, 2, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'staticPages', 'StaticPagesPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'recommendBySimilarity', 'RecommendBySimilarityPlugin', 1, 1),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'recommendByAuthor', 'RecommendByAuthorPlugin', 1, 1),
(1, 0, 1, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'pdfJsViewer', 'PdfJsViewerPlugin', 1, 0),
(1, 0, 1, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'lensGalley', 'LensGalleyPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'announcementFeed', 'AnnouncementFeedPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'htmlArticleGalley', 'HtmlArticleGalleyPlugin', 1, 0),
(1, 1, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'googleScholar', 'GoogleScholarPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'googleAnalytics', 'GoogleAnalyticsPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'dublinCoreMeta', 'DublinCoreMetaPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'driver', 'DRIVERPlugin', 1, 0),
(1, 2, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'customBlockManager', 'CustomBlockManagerPlugin', 1, 0),
(0, 1, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'citationStyleLanguage', 'CitationStyleLanguagePlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.generic', 'webFeed', 'WebFeedPlugin', 1, 0),
(2, 1, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.importexport', 'crossref', '', 0, 0),
(2, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.importexport', 'datacite', '', 0, 0),
(1, 1, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.importexport', 'doaj', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.importexport', 'native', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.importexport', 'pubmed', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.importexport', 'users', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.oaiMetadataFormats', 'dc', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.oaiMetadataFormats', 'marc', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.oaiMetadataFormats', 'marcxml', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.oaiMetadataFormats', 'rfc1807', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.paymethod', 'manual', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.paymethod', 'paypal', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.pubIds', 'doi', 'DOIPubIdPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.pubIds', 'urn', 'URNPubIdPlugin', 1, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.reports', 'articles', '', 0, 0),
(1, 1, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.reports', 'counterReport', '', 0, 0),
(2, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.reports', 'reviewReport', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.reports', 'subscriptions', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.reports', 'views', '', 0, 0),
(1, 0, 0, 0, '2023-03-17 20:25:51', 1, 'plugins.themes', 'default', 'DefaultThemePlugin', 1, 0),
(3, 3, 0, 14, '2023-03-17 20:25:38', 1, 'core', 'ojs2', '', 0, 1),
(1, 0, 3, 1, '2023-03-17 20:45:44', 1, 'plugins.themes', 'defaultManuscript', 'DefaultManuscriptChildThemePlugin', 1, 0),
(3, 2, 0, 1, '2023-03-17 20:49:17', 1, 'plugins.blocks', 'announcementsBlock', 'AnnouncementsBlockPlugin', 1, 0);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `access_keys`
--
ALTER TABLE `access_keys`
  ADD PRIMARY KEY (`access_key_id`),
  ADD KEY `access_keys_hash` (`key_hash`,`user_id`,`context`);

--
-- Indeks untuk tabel `announcements`
--
ALTER TABLE `announcements`
  ADD PRIMARY KEY (`announcement_id`),
  ADD KEY `announcements_assoc` (`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `announcement_settings`
--
ALTER TABLE `announcement_settings`
  ADD UNIQUE KEY `announcement_settings_pkey` (`announcement_id`,`locale`,`setting_name`),
  ADD KEY `announcement_settings_announcement_id` (`announcement_id`);

--
-- Indeks untuk tabel `announcement_types`
--
ALTER TABLE `announcement_types`
  ADD PRIMARY KEY (`type_id`),
  ADD KEY `announcement_types_assoc` (`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `announcement_type_settings`
--
ALTER TABLE `announcement_type_settings`
  ADD UNIQUE KEY `announcement_type_settings_pkey` (`type_id`,`locale`,`setting_name`),
  ADD KEY `announcement_type_settings_type_id` (`type_id`);

--
-- Indeks untuk tabel `authors`
--
ALTER TABLE `authors`
  ADD PRIMARY KEY (`author_id`),
  ADD KEY `authors_publication_id` (`publication_id`);

--
-- Indeks untuk tabel `author_settings`
--
ALTER TABLE `author_settings`
  ADD UNIQUE KEY `author_settings_pkey` (`author_id`,`locale`,`setting_name`),
  ADD KEY `author_settings_author_id` (`author_id`);

--
-- Indeks untuk tabel `auth_sources`
--
ALTER TABLE `auth_sources`
  ADD PRIMARY KEY (`auth_id`);

--
-- Indeks untuk tabel `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`),
  ADD UNIQUE KEY `category_path` (`context_id`,`path`),
  ADD KEY `category_context_id` (`context_id`,`parent_id`);

--
-- Indeks untuk tabel `category_settings`
--
ALTER TABLE `category_settings`
  ADD UNIQUE KEY `category_settings_pkey` (`category_id`,`locale`,`setting_name`);

--
-- Indeks untuk tabel `citations`
--
ALTER TABLE `citations`
  ADD PRIMARY KEY (`citation_id`),
  ADD UNIQUE KEY `citations_publication_seq` (`publication_id`,`seq`),
  ADD KEY `citations_publication` (`publication_id`);

--
-- Indeks untuk tabel `citation_settings`
--
ALTER TABLE `citation_settings`
  ADD UNIQUE KEY `citation_settings_pkey` (`citation_id`,`locale`,`setting_name`),
  ADD KEY `citation_settings_citation_id` (`citation_id`);

--
-- Indeks untuk tabel `completed_payments`
--
ALTER TABLE `completed_payments`
  ADD PRIMARY KEY (`completed_payment_id`);

--
-- Indeks untuk tabel `controlled_vocabs`
--
ALTER TABLE `controlled_vocabs`
  ADD PRIMARY KEY (`controlled_vocab_id`),
  ADD UNIQUE KEY `controlled_vocab_symbolic` (`symbolic`,`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `controlled_vocab_entries`
--
ALTER TABLE `controlled_vocab_entries`
  ADD PRIMARY KEY (`controlled_vocab_entry_id`),
  ADD KEY `controlled_vocab_entries_cv_id` (`controlled_vocab_id`,`seq`);

--
-- Indeks untuk tabel `controlled_vocab_entry_settings`
--
ALTER TABLE `controlled_vocab_entry_settings`
  ADD UNIQUE KEY `c_v_e_s_pkey` (`controlled_vocab_entry_id`,`locale`,`setting_name`),
  ADD KEY `c_v_e_s_entry_id` (`controlled_vocab_entry_id`);

--
-- Indeks untuk tabel `custom_issue_orders`
--
ALTER TABLE `custom_issue_orders`
  ADD UNIQUE KEY `custom_issue_orders_pkey` (`issue_id`);

--
-- Indeks untuk tabel `custom_section_orders`
--
ALTER TABLE `custom_section_orders`
  ADD UNIQUE KEY `custom_section_orders_pkey` (`issue_id`,`section_id`);

--
-- Indeks untuk tabel `data_object_tombstones`
--
ALTER TABLE `data_object_tombstones`
  ADD PRIMARY KEY (`tombstone_id`),
  ADD KEY `data_object_tombstones_data_object_id` (`data_object_id`);

--
-- Indeks untuk tabel `data_object_tombstone_oai_set_objects`
--
ALTER TABLE `data_object_tombstone_oai_set_objects`
  ADD PRIMARY KEY (`object_id`),
  ADD KEY `data_object_tombstone_oai_set_objects_tombstone_id` (`tombstone_id`);

--
-- Indeks untuk tabel `data_object_tombstone_settings`
--
ALTER TABLE `data_object_tombstone_settings`
  ADD UNIQUE KEY `data_object_tombstone_settings_pkey` (`tombstone_id`,`locale`,`setting_name`),
  ADD KEY `data_object_tombstone_settings_tombstone_id` (`tombstone_id`);

--
-- Indeks untuk tabel `edit_decisions`
--
ALTER TABLE `edit_decisions`
  ADD PRIMARY KEY (`edit_decision_id`),
  ADD KEY `edit_decisions_submission_id` (`submission_id`),
  ADD KEY `edit_decisions_editor_id` (`editor_id`);

--
-- Indeks untuk tabel `email_log`
--
ALTER TABLE `email_log`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `email_log_assoc` (`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `email_log_users`
--
ALTER TABLE `email_log_users`
  ADD UNIQUE KEY `email_log_user_id` (`email_log_id`,`user_id`);

--
-- Indeks untuk tabel `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`email_id`),
  ADD UNIQUE KEY `email_templates_email_key` (`email_key`,`context_id`);

--
-- Indeks untuk tabel `email_templates_default`
--
ALTER TABLE `email_templates_default`
  ADD PRIMARY KEY (`email_id`),
  ADD KEY `email_templates_default_email_key` (`email_key`);

--
-- Indeks untuk tabel `email_templates_default_data`
--
ALTER TABLE `email_templates_default_data`
  ADD UNIQUE KEY `email_templates_default_data_pkey` (`email_key`,`locale`);

--
-- Indeks untuk tabel `email_templates_settings`
--
ALTER TABLE `email_templates_settings`
  ADD UNIQUE KEY `email_settings_pkey` (`email_id`,`locale`,`setting_name`),
  ADD KEY `email_settings_email_id` (`email_id`);

--
-- Indeks untuk tabel `event_log`
--
ALTER TABLE `event_log`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `event_log_assoc` (`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `event_log_settings`
--
ALTER TABLE `event_log_settings`
  ADD UNIQUE KEY `event_log_settings_pkey` (`log_id`,`setting_name`),
  ADD KEY `event_log_settings_log_id` (`log_id`),
  ADD KEY `event_log_settings_name_value` (`setting_name`(50),`setting_value`(150));

--
-- Indeks untuk tabel `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`file_id`);

--
-- Indeks untuk tabel `filters`
--
ALTER TABLE `filters`
  ADD PRIMARY KEY (`filter_id`);

--
-- Indeks untuk tabel `filter_groups`
--
ALTER TABLE `filter_groups`
  ADD PRIMARY KEY (`filter_group_id`),
  ADD UNIQUE KEY `filter_groups_symbolic` (`symbolic`);

--
-- Indeks untuk tabel `filter_settings`
--
ALTER TABLE `filter_settings`
  ADD UNIQUE KEY `filter_settings_pkey` (`filter_id`,`locale`,`setting_name`),
  ADD KEY `filter_settings_id` (`filter_id`);

--
-- Indeks untuk tabel `genres`
--
ALTER TABLE `genres`
  ADD PRIMARY KEY (`genre_id`);

--
-- Indeks untuk tabel `genre_settings`
--
ALTER TABLE `genre_settings`
  ADD UNIQUE KEY `genre_settings_pkey` (`genre_id`,`locale`,`setting_name`),
  ADD KEY `genre_settings_genre_id` (`genre_id`);

--
-- Indeks untuk tabel `institutional_subscriptions`
--
ALTER TABLE `institutional_subscriptions`
  ADD PRIMARY KEY (`institutional_subscription_id`),
  ADD KEY `institutional_subscriptions_subscription_id` (`subscription_id`),
  ADD KEY `institutional_subscriptions_domain` (`domain`);

--
-- Indeks untuk tabel `institutional_subscription_ip`
--
ALTER TABLE `institutional_subscription_ip`
  ADD PRIMARY KEY (`institutional_subscription_ip_id`),
  ADD KEY `institutional_subscription_ip_subscription_id` (`subscription_id`),
  ADD KEY `institutional_subscription_ip_start` (`ip_start`),
  ADD KEY `institutional_subscription_ip_end` (`ip_end`);

--
-- Indeks untuk tabel `issues`
--
ALTER TABLE `issues`
  ADD PRIMARY KEY (`issue_id`),
  ADD KEY `issues_journal_id` (`journal_id`),
  ADD KEY `issues_url_path` (`url_path`);

--
-- Indeks untuk tabel `issue_files`
--
ALTER TABLE `issue_files`
  ADD PRIMARY KEY (`file_id`),
  ADD KEY `issue_files_issue_id` (`issue_id`);

--
-- Indeks untuk tabel `issue_galleys`
--
ALTER TABLE `issue_galleys`
  ADD PRIMARY KEY (`galley_id`),
  ADD KEY `issue_galleys_issue_id` (`issue_id`),
  ADD KEY `issue_galleys_url_path` (`url_path`);

--
-- Indeks untuk tabel `issue_galley_settings`
--
ALTER TABLE `issue_galley_settings`
  ADD UNIQUE KEY `issue_galley_settings_pkey` (`galley_id`,`locale`,`setting_name`),
  ADD KEY `issue_galley_settings_galley_id` (`galley_id`);

--
-- Indeks untuk tabel `issue_settings`
--
ALTER TABLE `issue_settings`
  ADD UNIQUE KEY `issue_settings_pkey` (`issue_id`,`locale`,`setting_name`),
  ADD KEY `issue_settings_issue_id` (`issue_id`),
  ADD KEY `issue_settings_name_value` (`setting_name`(50),`setting_value`(150));

--
-- Indeks untuk tabel `item_views`
--
ALTER TABLE `item_views`
  ADD UNIQUE KEY `item_views_pkey` (`assoc_type`,`assoc_id`,`user_id`);

--
-- Indeks untuk tabel `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`);

--
-- Indeks untuk tabel `journals`
--
ALTER TABLE `journals`
  ADD PRIMARY KEY (`journal_id`),
  ADD UNIQUE KEY `journals_path` (`path`);

--
-- Indeks untuk tabel `journal_settings`
--
ALTER TABLE `journal_settings`
  ADD UNIQUE KEY `journal_settings_pkey` (`journal_id`,`locale`,`setting_name`),
  ADD KEY `journal_settings_journal_id` (`journal_id`);

--
-- Indeks untuk tabel `library_files`
--
ALTER TABLE `library_files`
  ADD PRIMARY KEY (`file_id`),
  ADD KEY `library_files_context_id` (`context_id`),
  ADD KEY `library_files_submission_id` (`submission_id`);

--
-- Indeks untuk tabel `library_file_settings`
--
ALTER TABLE `library_file_settings`
  ADD UNIQUE KEY `library_file_settings_pkey` (`file_id`,`locale`,`setting_name`),
  ADD KEY `library_file_settings_id` (`file_id`);

--
-- Indeks untuk tabel `metadata_descriptions`
--
ALTER TABLE `metadata_descriptions`
  ADD PRIMARY KEY (`metadata_description_id`),
  ADD KEY `metadata_descriptions_assoc` (`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `metadata_description_settings`
--
ALTER TABLE `metadata_description_settings`
  ADD UNIQUE KEY `metadata_descripton_settings_pkey` (`metadata_description_id`,`locale`,`setting_name`),
  ADD KEY `metadata_description_settings_id` (`metadata_description_id`);

--
-- Indeks untuk tabel `metrics`
--
ALTER TABLE `metrics`
  ADD KEY `metrics_load_id` (`load_id`),
  ADD KEY `metrics_metric_type_context_id` (`metric_type`,`context_id`),
  ADD KEY `metrics_metric_type_submission_id_assoc_type` (`metric_type`,`submission_id`,`assoc_type`),
  ADD KEY `metrics_metric_type_submission_id_assoc` (`metric_type`,`context_id`,`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `navigation_menus`
--
ALTER TABLE `navigation_menus`
  ADD PRIMARY KEY (`navigation_menu_id`);

--
-- Indeks untuk tabel `navigation_menu_items`
--
ALTER TABLE `navigation_menu_items`
  ADD PRIMARY KEY (`navigation_menu_item_id`);

--
-- Indeks untuk tabel `navigation_menu_item_assignments`
--
ALTER TABLE `navigation_menu_item_assignments`
  ADD PRIMARY KEY (`navigation_menu_item_assignment_id`);

--
-- Indeks untuk tabel `navigation_menu_item_assignment_settings`
--
ALTER TABLE `navigation_menu_item_assignment_settings`
  ADD UNIQUE KEY `navigation_menu_item_assignment_settings_pkey` (`navigation_menu_item_assignment_id`,`locale`,`setting_name`),
  ADD KEY `assignment_settings_navigation_menu_item_assignment_id` (`navigation_menu_item_assignment_id`);

--
-- Indeks untuk tabel `navigation_menu_item_settings`
--
ALTER TABLE `navigation_menu_item_settings`
  ADD UNIQUE KEY `navigation_menu_item_settings_pkey` (`navigation_menu_item_id`,`locale`,`setting_name`),
  ADD KEY `navigation_menu_item_settings_navigation_menu_id` (`navigation_menu_item_id`);

--
-- Indeks untuk tabel `notes`
--
ALTER TABLE `notes`
  ADD PRIMARY KEY (`note_id`),
  ADD KEY `notes_assoc` (`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`notification_id`),
  ADD KEY `notifications_context_id_user_id` (`context_id`,`user_id`,`level`),
  ADD KEY `notifications_context_id` (`context_id`,`level`),
  ADD KEY `notifications_assoc` (`assoc_type`,`assoc_id`),
  ADD KEY `notifications_user_id_level` (`user_id`,`level`);

--
-- Indeks untuk tabel `notification_mail_list`
--
ALTER TABLE `notification_mail_list`
  ADD PRIMARY KEY (`notification_mail_list_id`),
  ADD UNIQUE KEY `notification_mail_list_email_context` (`email`,`context`);

--
-- Indeks untuk tabel `notification_settings`
--
ALTER TABLE `notification_settings`
  ADD UNIQUE KEY `notification_settings_pkey` (`notification_id`,`locale`,`setting_name`);

--
-- Indeks untuk tabel `notification_subscription_settings`
--
ALTER TABLE `notification_subscription_settings`
  ADD PRIMARY KEY (`setting_id`);

--
-- Indeks untuk tabel `oai_resumption_tokens`
--
ALTER TABLE `oai_resumption_tokens`
  ADD UNIQUE KEY `oai_resumption_tokens_pkey` (`token`);

--
-- Indeks untuk tabel `plugin_settings`
--
ALTER TABLE `plugin_settings`
  ADD UNIQUE KEY `plugin_settings_pkey` (`plugin_name`,`context_id`,`setting_name`),
  ADD KEY `plugin_settings_plugin_name` (`plugin_name`);

--
-- Indeks untuk tabel `publications`
--
ALTER TABLE `publications`
  ADD PRIMARY KEY (`publication_id`),
  ADD KEY `publications_submission_id` (`submission_id`),
  ADD KEY `publications_section_id` (`section_id`),
  ADD KEY `publications_url_path` (`url_path`);

--
-- Indeks untuk tabel `publication_categories`
--
ALTER TABLE `publication_categories`
  ADD UNIQUE KEY `publication_categories_id` (`publication_id`,`category_id`);

--
-- Indeks untuk tabel `publication_galleys`
--
ALTER TABLE `publication_galleys`
  ADD PRIMARY KEY (`galley_id`),
  ADD KEY `publication_galleys_publication_id` (`publication_id`),
  ADD KEY `publication_galleys_url_path` (`url_path`),
  ADD KEY `publication_galleys_submission_file_id_foreign` (`submission_file_id`);

--
-- Indeks untuk tabel `publication_galley_settings`
--
ALTER TABLE `publication_galley_settings`
  ADD UNIQUE KEY `publication_galley_settings_pkey` (`galley_id`,`locale`,`setting_name`),
  ADD KEY `publication_galley_settings_galley_id` (`galley_id`),
  ADD KEY `publication_galley_settings_name_value` (`setting_name`(50),`setting_value`(150));

--
-- Indeks untuk tabel `publication_settings`
--
ALTER TABLE `publication_settings`
  ADD UNIQUE KEY `publication_settings_pkey` (`publication_id`,`locale`,`setting_name`),
  ADD KEY `publication_settings_publication_id` (`publication_id`),
  ADD KEY `publication_settings_name_value` (`setting_name`(50),`setting_value`(150));

--
-- Indeks untuk tabel `queries`
--
ALTER TABLE `queries`
  ADD PRIMARY KEY (`query_id`),
  ADD KEY `queries_assoc_id` (`assoc_type`,`assoc_id`);

--
-- Indeks untuk tabel `query_participants`
--
ALTER TABLE `query_participants`
  ADD UNIQUE KEY `query_participants_pkey` (`query_id`,`user_id`);

--
-- Indeks untuk tabel `queued_payments`
--
ALTER TABLE `queued_payments`
  ADD PRIMARY KEY (`queued_payment_id`);

--
-- Indeks untuk tabel `review_assignments`
--
ALTER TABLE `review_assignments`
  ADD PRIMARY KEY (`review_id`),
  ADD KEY `review_assignments_submission_id` (`submission_id`),
  ADD KEY `review_assignments_reviewer_id` (`reviewer_id`),
  ADD KEY `review_assignments_form_id` (`review_form_id`),
  ADD KEY `review_assignments_reviewer_review` (`reviewer_id`,`review_id`);

--
-- Indeks untuk tabel `review_files`
--
ALTER TABLE `review_files`
  ADD UNIQUE KEY `review_files_pkey` (`review_id`,`submission_file_id`),
  ADD KEY `review_files_review_id` (`review_id`),
  ADD KEY `review_files_submission_file_id_foreign` (`submission_file_id`);

--
-- Indeks untuk tabel `review_forms`
--
ALTER TABLE `review_forms`
  ADD PRIMARY KEY (`review_form_id`);

--
-- Indeks untuk tabel `review_form_elements`
--
ALTER TABLE `review_form_elements`
  ADD PRIMARY KEY (`review_form_element_id`),
  ADD KEY `review_form_elements_review_form_id` (`review_form_id`);

--
-- Indeks untuk tabel `review_form_element_settings`
--
ALTER TABLE `review_form_element_settings`
  ADD UNIQUE KEY `review_form_element_settings_pkey` (`review_form_element_id`,`locale`,`setting_name`),
  ADD KEY `review_form_element_settings_review_form_element_id` (`review_form_element_id`);

--
-- Indeks untuk tabel `review_form_responses`
--
ALTER TABLE `review_form_responses`
  ADD KEY `review_form_responses_pkey` (`review_form_element_id`,`review_id`);

--
-- Indeks untuk tabel `review_form_settings`
--
ALTER TABLE `review_form_settings`
  ADD UNIQUE KEY `review_form_settings_pkey` (`review_form_id`,`locale`,`setting_name`),
  ADD KEY `review_form_settings_review_form_id` (`review_form_id`);

--
-- Indeks untuk tabel `review_rounds`
--
ALTER TABLE `review_rounds`
  ADD PRIMARY KEY (`review_round_id`),
  ADD UNIQUE KEY `review_rounds_submission_id_stage_id_round_pkey` (`submission_id`,`stage_id`,`round`),
  ADD KEY `review_rounds_submission_id` (`submission_id`);

--
-- Indeks untuk tabel `review_round_files`
--
ALTER TABLE `review_round_files`
  ADD UNIQUE KEY `review_round_files_pkey` (`submission_id`,`review_round_id`,`submission_file_id`),
  ADD KEY `review_round_files_submission_id` (`submission_id`),
  ADD KEY `review_round_files_submission_file_id_foreign` (`submission_file_id`);

--
-- Indeks untuk tabel `scheduled_tasks`
--
ALTER TABLE `scheduled_tasks`
  ADD UNIQUE KEY `scheduled_tasks_pkey` (`class_name`);

--
-- Indeks untuk tabel `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`section_id`),
  ADD KEY `sections_journal_id` (`journal_id`);

--
-- Indeks untuk tabel `section_settings`
--
ALTER TABLE `section_settings`
  ADD UNIQUE KEY `section_settings_pkey` (`section_id`,`locale`,`setting_name`),
  ADD KEY `section_settings_section_id` (`section_id`);

--
-- Indeks untuk tabel `site_settings`
--
ALTER TABLE `site_settings`
  ADD UNIQUE KEY `site_settings_pkey` (`setting_name`,`locale`);

--
-- Indeks untuk tabel `stage_assignments`
--
ALTER TABLE `stage_assignments`
  ADD PRIMARY KEY (`stage_assignment_id`),
  ADD UNIQUE KEY `stage_assignment` (`submission_id`,`user_group_id`,`user_id`),
  ADD KEY `stage_assignments_submission_id` (`submission_id`),
  ADD KEY `stage_assignments_user_group_id` (`user_group_id`),
  ADD KEY `stage_assignments_user_id` (`user_id`);

--
-- Indeks untuk tabel `static_pages`
--
ALTER TABLE `static_pages`
  ADD PRIMARY KEY (`static_page_id`);

--
-- Indeks untuk tabel `static_page_settings`
--
ALTER TABLE `static_page_settings`
  ADD UNIQUE KEY `static_page_settings_pkey` (`static_page_id`,`locale`,`setting_name`),
  ADD KEY `static_page_settings_static_page_id` (`static_page_id`);

--
-- Indeks untuk tabel `subeditor_submission_group`
--
ALTER TABLE `subeditor_submission_group`
  ADD UNIQUE KEY `section_editors_pkey` (`context_id`,`assoc_id`,`assoc_type`,`user_id`),
  ADD KEY `section_editors_context_id` (`context_id`),
  ADD KEY `subeditor_submission_group_assoc_id` (`assoc_id`,`assoc_type`),
  ADD KEY `subeditor_submission_group_user_id` (`user_id`);

--
-- Indeks untuk tabel `submissions`
--
ALTER TABLE `submissions`
  ADD PRIMARY KEY (`submission_id`),
  ADD KEY `submissions_context_id` (`context_id`),
  ADD KEY `submissions_publication_id` (`current_publication_id`);

--
-- Indeks untuk tabel `submission_comments`
--
ALTER TABLE `submission_comments`
  ADD PRIMARY KEY (`comment_id`),
  ADD KEY `submission_comments_submission_id` (`submission_id`);

--
-- Indeks untuk tabel `submission_files`
--
ALTER TABLE `submission_files`
  ADD PRIMARY KEY (`submission_file_id`),
  ADD KEY `submission_files_submission_id` (`submission_id`),
  ADD KEY `submission_files_stage_assoc` (`file_stage`,`assoc_type`,`assoc_id`),
  ADD KEY `submission_files_file_id_foreign` (`file_id`);

--
-- Indeks untuk tabel `submission_file_revisions`
--
ALTER TABLE `submission_file_revisions`
  ADD PRIMARY KEY (`revision_id`),
  ADD KEY `submission_file_revisions_submission_file_id_foreign` (`submission_file_id`),
  ADD KEY `submission_file_revisions_file_id_foreign` (`file_id`);

--
-- Indeks untuk tabel `submission_file_settings`
--
ALTER TABLE `submission_file_settings`
  ADD UNIQUE KEY `submission_file_settings_pkey` (`submission_file_id`,`locale`,`setting_name`),
  ADD KEY `submission_file_settings_id` (`submission_file_id`);

--
-- Indeks untuk tabel `submission_search_keyword_list`
--
ALTER TABLE `submission_search_keyword_list`
  ADD PRIMARY KEY (`keyword_id`),
  ADD UNIQUE KEY `submission_search_keyword_text` (`keyword_text`);

--
-- Indeks untuk tabel `submission_search_objects`
--
ALTER TABLE `submission_search_objects`
  ADD PRIMARY KEY (`object_id`),
  ADD KEY `submission_search_object_submission` (`submission_id`);

--
-- Indeks untuk tabel `submission_search_object_keywords`
--
ALTER TABLE `submission_search_object_keywords`
  ADD UNIQUE KEY `submission_search_object_keywords_pkey` (`object_id`,`pos`),
  ADD KEY `submission_search_object_keywords_keyword_id` (`keyword_id`);

--
-- Indeks untuk tabel `submission_settings`
--
ALTER TABLE `submission_settings`
  ADD UNIQUE KEY `submission_settings_pkey` (`submission_id`,`locale`,`setting_name`),
  ADD KEY `submission_settings_submission_id` (`submission_id`);

--
-- Indeks untuk tabel `submission_tombstones`
--
ALTER TABLE `submission_tombstones`
  ADD PRIMARY KEY (`tombstone_id`),
  ADD KEY `submission_tombstones_journal_id` (`journal_id`),
  ADD KEY `submission_tombstones_submission_id` (`submission_id`);

--
-- Indeks untuk tabel `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`subscription_id`);

--
-- Indeks untuk tabel `subscription_types`
--
ALTER TABLE `subscription_types`
  ADD PRIMARY KEY (`type_id`);

--
-- Indeks untuk tabel `subscription_type_settings`
--
ALTER TABLE `subscription_type_settings`
  ADD UNIQUE KEY `subscription_type_settings_pkey` (`type_id`,`locale`,`setting_name`),
  ADD KEY `subscription_type_settings_type_id` (`type_id`);

--
-- Indeks untuk tabel `temporary_files`
--
ALTER TABLE `temporary_files`
  ADD PRIMARY KEY (`file_id`),
  ADD KEY `temporary_files_user_id` (`user_id`);

--
-- Indeks untuk tabel `user_groups`
--
ALTER TABLE `user_groups`
  ADD PRIMARY KEY (`user_group_id`),
  ADD KEY `user_groups_user_group_id` (`user_group_id`),
  ADD KEY `user_groups_context_id` (`context_id`),
  ADD KEY `user_groups_role_id` (`role_id`);

--
-- Indeks untuk tabel `user_group_settings`
--
ALTER TABLE `user_group_settings`
  ADD UNIQUE KEY `user_group_settings_pkey` (`user_group_id`,`locale`,`setting_name`);

--
-- Indeks untuk tabel `user_group_stage`
--
ALTER TABLE `user_group_stage`
  ADD UNIQUE KEY `user_group_stage_pkey` (`context_id`,`user_group_id`,`stage_id`),
  ADD KEY `user_group_stage_context_id` (`context_id`),
  ADD KEY `user_group_stage_user_group_id` (`user_group_id`),
  ADD KEY `user_group_stage_stage_id` (`stage_id`);

--
-- Indeks untuk tabel `user_interests`
--
ALTER TABLE `user_interests`
  ADD UNIQUE KEY `u_e_pkey` (`user_id`,`controlled_vocab_entry_id`);

--
-- Indeks untuk tabel `user_settings`
--
ALTER TABLE `user_settings`
  ADD UNIQUE KEY `user_settings_pkey` (`user_id`,`locale`,`setting_name`,`assoc_type`,`assoc_id`),
  ADD KEY `user_settings_user_id` (`user_id`),
  ADD KEY `user_settings_locale_setting_name_index` (`setting_name`,`locale`);

--
-- Indeks untuk tabel `user_user_groups`
--
ALTER TABLE `user_user_groups`
  ADD UNIQUE KEY `user_user_groups_pkey` (`user_group_id`,`user_id`),
  ADD KEY `user_user_groups_user_group_id` (`user_group_id`),
  ADD KEY `user_user_groups_user_id` (`user_id`);

--
-- Indeks untuk tabel `versions`
--
ALTER TABLE `versions`
  ADD UNIQUE KEY `versions_pkey` (`product_type`,`product`,`major`,`minor`,`revision`,`build`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `access_keys`
--
ALTER TABLE `access_keys`
  MODIFY `access_key_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `announcements`
--
ALTER TABLE `announcements`
  MODIFY `announcement_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `announcement_types`
--
ALTER TABLE `announcement_types`
  MODIFY `type_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `authors`
--
ALTER TABLE `authors`
  MODIFY `author_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `auth_sources`
--
ALTER TABLE `auth_sources`
  MODIFY `auth_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `citations`
--
ALTER TABLE `citations`
  MODIFY `citation_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `completed_payments`
--
ALTER TABLE `completed_payments`
  MODIFY `completed_payment_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `controlled_vocabs`
--
ALTER TABLE `controlled_vocabs`
  MODIFY `controlled_vocab_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT untuk tabel `controlled_vocab_entries`
--
ALTER TABLE `controlled_vocab_entries`
  MODIFY `controlled_vocab_entry_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT untuk tabel `data_object_tombstones`
--
ALTER TABLE `data_object_tombstones`
  MODIFY `tombstone_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `data_object_tombstone_oai_set_objects`
--
ALTER TABLE `data_object_tombstone_oai_set_objects`
  MODIFY `object_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `edit_decisions`
--
ALTER TABLE `edit_decisions`
  MODIFY `edit_decision_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT untuk tabel `email_log`
--
ALTER TABLE `email_log`
  MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT untuk tabel `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `email_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `email_templates_default`
--
ALTER TABLE `email_templates_default`
  MODIFY `email_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- AUTO_INCREMENT untuk tabel `event_log`
--
ALTER TABLE `event_log`
  MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=164;

--
-- AUTO_INCREMENT untuk tabel `files`
--
ALTER TABLE `files`
  MODIFY `file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT untuk tabel `filters`
--
ALTER TABLE `filters`
  MODIFY `filter_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT untuk tabel `filter_groups`
--
ALTER TABLE `filter_groups`
  MODIFY `filter_group_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT untuk tabel `genres`
--
ALTER TABLE `genres`
  MODIFY `genre_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT untuk tabel `institutional_subscriptions`
--
ALTER TABLE `institutional_subscriptions`
  MODIFY `institutional_subscription_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `institutional_subscription_ip`
--
ALTER TABLE `institutional_subscription_ip`
  MODIFY `institutional_subscription_ip_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `issues`
--
ALTER TABLE `issues`
  MODIFY `issue_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `issue_files`
--
ALTER TABLE `issue_files`
  MODIFY `file_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `issue_galleys`
--
ALTER TABLE `issue_galleys`
  MODIFY `galley_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `journals`
--
ALTER TABLE `journals`
  MODIFY `journal_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `library_files`
--
ALTER TABLE `library_files`
  MODIFY `file_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `metadata_descriptions`
--
ALTER TABLE `metadata_descriptions`
  MODIFY `metadata_description_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `navigation_menus`
--
ALTER TABLE `navigation_menus`
  MODIFY `navigation_menu_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `navigation_menu_items`
--
ALTER TABLE `navigation_menu_items`
  MODIFY `navigation_menu_item_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT untuk tabel `navigation_menu_item_assignments`
--
ALTER TABLE `navigation_menu_item_assignments`
  MODIFY `navigation_menu_item_assignment_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT untuk tabel `notes`
--
ALTER TABLE `notes`
  MODIFY `note_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `notifications`
--
ALTER TABLE `notifications`
  MODIFY `notification_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;

--
-- AUTO_INCREMENT untuk tabel `notification_mail_list`
--
ALTER TABLE `notification_mail_list`
  MODIFY `notification_mail_list_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `notification_subscription_settings`
--
ALTER TABLE `notification_subscription_settings`
  MODIFY `setting_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `publications`
--
ALTER TABLE `publications`
  MODIFY `publication_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `publication_galleys`
--
ALTER TABLE `publication_galleys`
  MODIFY `galley_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `queries`
--
ALTER TABLE `queries`
  MODIFY `query_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `queued_payments`
--
ALTER TABLE `queued_payments`
  MODIFY `queued_payment_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `review_assignments`
--
ALTER TABLE `review_assignments`
  MODIFY `review_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `review_forms`
--
ALTER TABLE `review_forms`
  MODIFY `review_form_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `review_form_elements`
--
ALTER TABLE `review_form_elements`
  MODIFY `review_form_element_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `review_rounds`
--
ALTER TABLE `review_rounds`
  MODIFY `review_round_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `sections`
--
ALTER TABLE `sections`
  MODIFY `section_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `stage_assignments`
--
ALTER TABLE `stage_assignments`
  MODIFY `stage_assignment_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT untuk tabel `static_pages`
--
ALTER TABLE `static_pages`
  MODIFY `static_page_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `submissions`
--
ALTER TABLE `submissions`
  MODIFY `submission_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `submission_comments`
--
ALTER TABLE `submission_comments`
  MODIFY `comment_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `submission_files`
--
ALTER TABLE `submission_files`
  MODIFY `submission_file_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT untuk tabel `submission_file_revisions`
--
ALTER TABLE `submission_file_revisions`
  MODIFY `revision_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT untuk tabel `submission_search_keyword_list`
--
ALTER TABLE `submission_search_keyword_list`
  MODIFY `keyword_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT untuk tabel `submission_search_objects`
--
ALTER TABLE `submission_search_objects`
  MODIFY `object_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT untuk tabel `submission_tombstones`
--
ALTER TABLE `submission_tombstones`
  MODIFY `tombstone_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `subscription_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `subscription_types`
--
ALTER TABLE `subscription_types`
  MODIFY `type_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `temporary_files`
--
ALTER TABLE `temporary_files`
  MODIFY `file_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT untuk tabel `user_groups`
--
ALTER TABLE `user_groups`
  MODIFY `user_group_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `publication_galleys`
--
ALTER TABLE `publication_galleys`
  ADD CONSTRAINT `publication_galleys_submission_file_id_foreign` FOREIGN KEY (`submission_file_id`) REFERENCES `submission_files` (`submission_file_id`);

--
-- Ketidakleluasaan untuk tabel `review_files`
--
ALTER TABLE `review_files`
  ADD CONSTRAINT `review_files_submission_file_id_foreign` FOREIGN KEY (`submission_file_id`) REFERENCES `submission_files` (`submission_file_id`);

--
-- Ketidakleluasaan untuk tabel `review_round_files`
--
ALTER TABLE `review_round_files`
  ADD CONSTRAINT `review_round_files_submission_file_id_foreign` FOREIGN KEY (`submission_file_id`) REFERENCES `submission_files` (`submission_file_id`);

--
-- Ketidakleluasaan untuk tabel `submission_files`
--
ALTER TABLE `submission_files`
  ADD CONSTRAINT `submission_files_file_id_foreign` FOREIGN KEY (`file_id`) REFERENCES `files` (`file_id`);

--
-- Ketidakleluasaan untuk tabel `submission_file_revisions`
--
ALTER TABLE `submission_file_revisions`
  ADD CONSTRAINT `submission_file_revisions_file_id_foreign` FOREIGN KEY (`file_id`) REFERENCES `files` (`file_id`),
  ADD CONSTRAINT `submission_file_revisions_submission_file_id_foreign` FOREIGN KEY (`submission_file_id`) REFERENCES `submission_files` (`submission_file_id`);
COMMIT;

