-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `stipasac_inventaris`
--

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

--
-- Table structure for table `aauth_groups`
--

CREATE TABLE `aauth_groups` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `definition` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `aauth_groups`
--

INSERT INTO `aauth_groups` (`id`, `name`, `definition`) VALUES
(1, 'Admin', 'Superadmin Group'),
(2, 'Public', 'Public Group'),
(3, 'Default', 'Default Access Group'),
(4, 'Member', 'Member Access Group'),
(5, 'Unit', 'Unit yang bisa melakukan peminjaman saja'),
(6, 'Keuangan', 'Yang mengakses pengadaan barang saja untuk melihat pengeluaran biaya');

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

--
-- Table structure for table `aauth_group_to_group`
--

CREATE TABLE `aauth_group_to_group` (
  `group_id` int(11) UNSIGNED NOT NULL,
  `subgroup_id` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `aauth_login_attempts`
--

CREATE TABLE `aauth_login_attempts` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(39) DEFAULT NULL,
  `timestamp` datetime DEFAULT NULL,
  `login_attempts` tinyint(2) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `aauth_login_attempts`
--

INSERT INTO `aauth_login_attempts` (`id`, `ip_address`, `timestamp`, `login_attempts`) VALUES
(3, '180.251.65.156', '2019-03-23 15:09:28', 1),
(4, '192.168.1.102', '2019-05-17 09:52:58', 6),
(5, '182.1.205.77', '2019-07-17 17:22:04', 2),
(6, '182.1.205.77', '2019-07-17 17:30:08', 1),
(7, '115.178.254.115', '2019-10-07 20:18:55', 1),
(9, '36.65.127.121', '2019-11-03 00:44:45', 1),
(10, '36.65.91.112', '2019-11-10 14:37:31', 1),
(12, '36.71.232.156', '2019-12-09 12:07:20', 1),
(13, '105.110.57.83', '2020-02-01 06:37:06', 1),
(14, '114.142.169.21', '2020-02-04 14:44:40', 2),
(15, '31.14.73.62', '2020-02-11 17:17:19', 1),
(18, '202.77.106.254', '2020-04-22 15:23:32', 1),
(19, '223.255.229.3', '2020-11-23 14:50:32', 1),
(20, '114.5.111.236', '2021-02-18 20:47:30', 1),
(22, '180.253.165.86', '2021-02-28 16:41:29', 2),
(23, '114.4.219.215', '2021-08-10 18:17:39', 1),
(24, '36.85.133.7', '2022-01-25 12:55:34', 1),
(25, '114.5.110.217', '2022-03-14 08:43:56', 2),
(34, '114.4.222.245', '2022-10-21 23:49:43', 8),
(35, '114.4.222.245', '2022-10-22 09:26:11', 4),
(36, '114.4.222.245', '2022-10-22 09:32:05', 1),
(37, '2001:448a:6020:d182:40bc:eae7:4477:4b90', '2022-10-22 10:08:59', 3),
(45, '2001:448a:6020:336d:9562:bd06:55eb:84a5', '2023-01-26 12:21:04', 1),
(83, '180.247.85.184', '2023-05-06 16:59:25', 1),
(84, '173.245.211.25', '2023-05-18 21:03:47', 1),
(85, '180.249.186.163', '2023-06-11 06:41:50', 2),
(86, '103.86.49.187', '2023-06-20 15:08:21', 1),
(88, '125.160.55.244', '2023-07-04 11:58:00', 1),
(96, '180.254.143.63', '2023-07-04 22:13:56', 4),
(104, '182.3.43.8', '2023-09-26 10:35:56', 2),
(105, '202.124.43.177', '2023-09-26 17:50:40', 1),
(108, '36.90.157.211', '2023-10-30 13:24:47', 1),
(114, '124.158.184.226', '2023-12-11 14:22:32', 1),
(119, '2404:c0:8010::436:285b', '2024-01-07 19:23:05', 1),
(122, '92.38.148.61', '2024-01-11 01:54:38', 1),
(127, '36.68.55.142', '2024-02-01 15:09:00', 1),
(130, '103.124.138.254', '2024-02-10 16:44:45', 1),
(131, '125.164.98.197', '2024-02-12 11:56:04', 17),
(136, '202.80.217.32', '2024-03-04 16:22:50', 2),
(138, '158.140.165.12', '2024-03-21 08:44:37', 5),
(140, '182.2.140.200', '2024-04-05 23:49:26', 3),
(143, '103.141.47.32', '2024-05-21 16:59:51', 1),
(146, '120.188.72.49', '2024-08-19 05:00:47', 1),
(149, '203.80.166.169', '2024-09-06 18:32:09', 2),
(151, '185.213.83.109', '2024-09-22 23:21:30', 3),
(153, '103.185.46.38', '2024-09-23 07:03:40', 19),
(155, '128.14.197.221', '2024-09-23 07:11:25', 14),
(157, '112.215.238.154', '2024-10-26 11:11:03', 1),
(160, '125.166.19.238', '2024-12-25 00:20:19', 1),
(161, '103.140.55.222', '2025-01-15 07:19:12', 18),
(164, '103.84.193.44', '2025-01-15 07:23:11', 9),
(165, '2602:ffe4:c0d:4141:5df::1', '2025-01-18 15:29:12', 1),
(167, '103.136.161.238', '2025-01-21 11:04:44', 2),
(169, '59.153.128.134', '2025-01-21 21:53:06', 12),
(170, '59.153.128.134', '2025-01-21 22:34:44', 4),
(173, '103.149.71.10', '2025-03-03 09:00:57', 1),
(175, '113.192.27.2', '2025-03-07 02:10:01', 4),
(177, '103.80.98.63', '2025-04-09 00:27:02', 1),
(180, '103.80.98.63', '2025-05-06 00:44:31', 1),
(181, '116.212.130.44', '2025-05-11 01:16:20', 10),
(183, '38.54.95.129', '2025-05-13 14:40:54', 1),
(184, '38.54.95.129', '2025-05-19 11:13:23', 1),
(185, '38.54.95.129', '2025-05-19 23:59:52', 1),
(186, '38.54.95.129', '2025-05-23 09:25:12', 1),
(187, '38.54.95.129', '2025-05-24 08:26:39', 1),
(188, '103.80.98.63', '2025-05-26 14:48:53', 5),
(189, '140.213.33.195', '2025-06-01 09:52:50', 2),
(192, '202.124.41.216', '2025-06-29 21:09:40', 1),
(193, '157.66.170.26', '2025-06-30 23:32:48', 3),
(194, '114.122.101.240', '2025-07-05 13:06:07', 1),
(196, '185.213.83.228', '2025-07-06 19:46:23', 6),
(197, '182.253.126.12', '2025-07-10 08:44:37', 1),
(198, '121.101.131.98', '2025-07-18 10:03:39', 1),
(199, '103.80.98.63', '2025-07-23 01:59:56', 1),
(200, '103.14.229.105', '2025-08-19 15:37:05', 1),
(201, '103.174.237.120', '2025-09-24 18:01:58', 1),
(204, '203.189.130.52', '2025-09-25 12:57:33', 2),
(208, '125.167.200.250', '2025-10-16 18:55:33', 1);

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

--
-- Table structure for table `aauth_perms`
--

CREATE TABLE `aauth_perms` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `definition` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `aauth_perms`
--

INSERT INTO `aauth_perms` (`id`, `name`, `definition`) VALUES
(1, 'menu_dashboard', NULL),
(2, 'menu_crud_builder', NULL),
(3, 'menu_api_builder', NULL),
(4, 'menu_page_builder', NULL),
(5, 'menu_form_builder', NULL),
(6, 'menu_menu', NULL),
(7, 'menu_auth', NULL),
(8, 'menu_user', NULL),
(9, 'menu_group', NULL),
(10, 'menu_access', NULL),
(11, 'menu_permission', NULL),
(12, 'menu_api_documentation', NULL),
(13, 'menu_web_documentation', NULL),
(14, 'menu_settings', NULL),
(15, 'user_list', NULL),
(16, 'user_update_status', NULL),
(17, 'user_export', NULL),
(18, 'user_add', NULL),
(19, 'user_update', NULL),
(20, 'user_update_profile', NULL),
(21, 'user_update_password', NULL),
(22, 'user_profile', NULL),
(23, 'user_view', NULL),
(24, 'user_delete', NULL),
(25, 'blog_list', NULL),
(26, 'blog_export', NULL),
(27, 'blog_add', NULL),
(28, 'blog_update', NULL),
(29, 'blog_view', NULL),
(30, 'blog_delete', NULL),
(31, 'form_list', NULL),
(32, 'form_export', NULL),
(33, 'form_add', NULL),
(34, 'form_update', NULL),
(35, 'form_view', NULL),
(36, 'form_manage', NULL),
(37, 'form_delete', NULL),
(38, 'crud_list', NULL),
(39, 'crud_export', NULL),
(40, 'crud_add', NULL),
(41, 'crud_update', NULL),
(42, 'crud_view', NULL),
(43, 'crud_delete', NULL),
(44, 'rest_list', NULL),
(45, 'rest_export', NULL),
(46, 'rest_add', NULL),
(47, 'rest_update', NULL),
(48, 'rest_view', NULL),
(49, 'rest_delete', NULL),
(50, 'group_list', NULL),
(51, 'group_export', NULL),
(52, 'group_add', NULL),
(53, 'group_update', NULL),
(54, 'group_view', NULL),
(55, 'group_delete', NULL),
(56, 'permission_list', NULL),
(57, 'permission_export', NULL),
(58, 'permission_add', NULL),
(59, 'permission_update', NULL),
(60, 'permission_view', NULL),
(61, 'permission_delete', NULL),
(62, 'access_list', NULL),
(63, 'access_add', NULL),
(64, 'access_update', NULL),
(65, 'menu_list', NULL),
(66, 'menu_add', NULL),
(67, 'menu_update', NULL),
(68, 'menu_delete', NULL),
(69, 'menu_save_ordering', NULL),
(70, 'menu_type_add', NULL),
(71, 'page_list', NULL),
(72, 'page_export', NULL),
(73, 'page_add', NULL),
(74, 'page_update', NULL),
(75, 'page_view', NULL),
(76, 'page_delete', NULL),
(77, 'setting', NULL),
(78, 'setting_update', NULL),
(79, 'menu_builder', ''),
(80, 'menu_akun', ''),
(81, 'menu_other', ''),
(82, 'menu_kofigurasi', ''),
(88, 'jabatan_add', ''),
(89, 'jabatan_update', ''),
(90, 'jabatan_view', ''),
(91, 'jabatan_delete', ''),
(92, 'jabatan_list', ''),
(113, 'menu_master_data', ''),
(114, 'menu_karyawan', ''),
(115, 'menu_agama', ''),
(116, 'menu_barang', ''),
(117, 'menu_jabatan', ''),
(118, 'menu_ruangan', ''),
(124, 'blog_category_add', ''),
(125, 'blog_category_update', ''),
(126, 'blog_category_view', ''),
(127, 'blog_category_delete', ''),
(128, 'blog_category_list', ''),
(129, 'menu_blog', ''),
(130, 'menu_creat_blog', ''),
(131, 'menu_category', ''),
(132, 'form_pengajuan_pinjam_barang_add', ''),
(133, 'form_pengajuan_pinjam_barang_update', ''),
(134, 'form_pengajuan_pinjam_barang_view', ''),
(135, 'form_pengajuan_pinjam_barang_delete', ''),
(136, 'menu_home', ''),
(137, 'menu_pengajuan', ''),
(138, 'menu_input_pengajuan', ''),
(139, 'menu_view', ''),
(150, 'menu_pengembalian', ''),
(151, 'menu_input_barang_kembali', ''),
(152, 'menu_data_peminjam', ''),
(189, 'retur_add', ''),
(190, 'retur_update', ''),
(191, 'retur_view', ''),
(192, 'retur_delete', ''),
(193, 'retur_list', ''),
(194, 'menu_return', ''),
(195, 'menu_input_return', ''),
(196, 'karyawan_add', ''),
(197, 'karyawan_update', ''),
(198, 'karyawan_view', ''),
(199, 'karyawan_delete', ''),
(200, 'karyawan_list', ''),
(206, 'menu_peminjaman', ''),
(207, 'menu_input_peminjaman', ''),
(208, 'menu_crud', ''),
(209, 'departemen_add', ''),
(210, 'departemen_update', ''),
(211, 'departemen_view', ''),
(212, 'departemen_delete', ''),
(213, 'departemen_list', ''),
(214, 'menu_departemen', ''),
(215, 'supplier_add', ''),
(216, 'supplier_update', ''),
(217, 'supplier_view', ''),
(218, 'supplier_delete', ''),
(219, 'supplier_list', ''),
(220, 'lokasi_add', ''),
(221, 'lokasi_update', ''),
(222, 'lokasi_view', ''),
(223, 'lokasi_delete', ''),
(224, 'lokasi_list', ''),
(225, 'menu_supplier', ''),
(226, 'menu_lokasi', ''),
(227, 'jenis_pengadaan_add', ''),
(228, 'jenis_pengadaan_update', ''),
(229, 'jenis_pengadaan_view', ''),
(230, 'jenis_pengadaan_delete', ''),
(231, 'jenis_pengadaan_list', ''),
(232, 'menu_jenis_pengadaan', ''),
(233, 'menu_kategori', ''),
(234, 'kategori_add', ''),
(235, 'kategori_update', ''),
(236, 'kategori_view', ''),
(237, 'kategori_delete', ''),
(238, 'kategori_list', ''),
(239, 'menu_pengadaan', ''),
(240, 'menu_input_pengadaan', ''),
(246, 'menu_data_barang', ''),
(247, 'penempatan_add', ''),
(248, 'penempatan_update', ''),
(249, 'penempatan_view', ''),
(250, 'penempatan_delete', ''),
(251, 'penempatan_list', ''),
(252, 'menu_penempatan', ''),
(253, 'menu_input_penempatan', ''),
(254, 'barang_add', ''),
(255, 'barang_update', ''),
(256, 'barang_view', ''),
(257, 'barang_delete', ''),
(258, 'barang_list', ''),
(259, 'pengajuan_add', ''),
(260, 'pengajuan_update', ''),
(261, 'pengajuan_view', ''),
(262, 'pengajuan_delete', ''),
(263, 'pengajuan_list', ''),
(264, 'pengembalian_add', ''),
(265, 'pengembalian_update', ''),
(266, 'pengembalian_view', ''),
(267, 'pengembalian_delete', ''),
(268, 'pengembalian_list', ''),
(274, 'menu_mutasi', ''),
(275, 'menu_input_mutasi', ''),
(276, 'pengadaan_add', ''),
(277, 'pengadaan_update', ''),
(278, 'pengadaan_view', ''),
(279, 'pengadaan_delete', ''),
(280, 'pengadaan_list', ''),
(286, 'mutasi_add', ''),
(287, 'mutasi_update', ''),
(288, 'mutasi_view', ''),
(289, 'mutasi_delete', ''),
(290, 'mutasi_list', '');

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

--
-- Table structure for table `aauth_perm_to_group`
--

CREATE TABLE `aauth_perm_to_group` (
  `perm_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `aauth_perm_to_group`
--

INSERT INTO `aauth_perm_to_group` (`perm_id`, `group_id`) VALUES
(116, 0),
(117, 0),
(1, 6),
(139, 6),
(239, 6),
(278, 6),
(280, 6),
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(65, 1),
(66, 1),
(67, 1),
(68, 1),
(69, 1),
(70, 1),
(79, 1),
(80, 1),
(81, 1),
(82, 1),
(113, 1),
(114, 1),
(115, 1),
(116, 1),
(117, 1),
(118, 1),
(129, 1),
(130, 1),
(131, 1),
(136, 1),
(137, 1),
(138, 1),
(139, 1),
(150, 1),
(151, 1),
(152, 1),
(194, 1),
(195, 1),
(206, 1),
(207, 1),
(208, 1),
(214, 1),
(225, 1),
(226, 1),
(232, 1),
(233, 1),
(239, 1),
(240, 1),
(246, 1),
(252, 1),
(253, 1),
(274, 1),
(275, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(124, 1),
(125, 1),
(126, 1),
(127, 1),
(128, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(132, 1),
(133, 1),
(134, 1),
(135, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1),
(61, 1),
(62, 1),
(63, 1),
(64, 1),
(71, 1),
(72, 1),
(73, 1),
(74, 1),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(88, 1),
(89, 1),
(90, 1),
(91, 1),
(92, 1),
(189, 1),
(190, 1),
(191, 1),
(192, 1),
(193, 1),
(196, 1),
(197, 1),
(198, 1),
(199, 1),
(200, 1),
(209, 1),
(210, 1),
(211, 1),
(212, 1),
(213, 1),
(215, 1),
(216, 1),
(217, 1),
(218, 1),
(219, 1),
(220, 1),
(221, 1),
(222, 1),
(223, 1),
(224, 1),
(227, 1),
(228, 1),
(229, 1),
(230, 1),
(231, 1),
(234, 1),
(235, 1),
(236, 1),
(237, 1),
(238, 1),
(247, 1),
(248, 1),
(249, 1),
(250, 1),
(251, 1),
(254, 1),
(255, 1),
(256, 1),
(257, 1),
(258, 1),
(259, 1),
(260, 1),
(261, 1),
(262, 1),
(263, 1),
(264, 1),
(265, 1),
(266, 1),
(267, 1),
(268, 1),
(276, 1),
(277, 1),
(278, 1),
(279, 1),
(280, 1),
(286, 1),
(287, 1),
(288, 1),
(289, 1),
(290, 1),
(1, 5),
(118, 5),
(129, 5),
(139, 5),
(150, 5),
(151, 5),
(194, 5),
(195, 5),
(206, 5),
(226, 5),
(233, 5),
(239, 5),
(246, 5),
(252, 5),
(274, 5),
(20, 5),
(21, 5),
(22, 5),
(25, 5),
(29, 5),
(126, 5),
(31, 5),
(35, 5),
(38, 5),
(42, 5),
(44, 5),
(48, 5),
(71, 5),
(75, 5),
(90, 5),
(92, 5),
(191, 5),
(193, 5),
(198, 5),
(200, 5),
(211, 5),
(213, 5),
(217, 5),
(219, 5),
(222, 5),
(224, 5),
(229, 5),
(231, 5),
(236, 5),
(238, 5),
(249, 5),
(251, 5),
(256, 5),
(258, 5),
(261, 5),
(263, 5),
(266, 5),
(268, 5),
(278, 5),
(280, 5),
(288, 5),
(290, 5);

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

--
-- Table structure for table `aauth_perm_to_user`
--

CREATE TABLE `aauth_perm_to_user` (
  `perm_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `aauth_pms`
--

CREATE TABLE `aauth_pms` (
  `id` int(11) UNSIGNED NOT NULL,
  `sender_id` int(11) UNSIGNED NOT NULL,
  `receiver_id` int(11) UNSIGNED NOT NULL,
  `title` varchar(225) NOT NULL,
  `message` text DEFAULT NULL,
  `date_sent` datetime DEFAULT NULL,
  `date_read` datetime DEFAULT NULL,
  `pm_deleted_sender` int(1) DEFAULT NULL,
  `pm_deleted_receiver` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `aauth_user`
--

CREATE TABLE `aauth_user` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `definition` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `aauth_user_to_group`
--

CREATE TABLE `aauth_user_to_group` (
  `user_id` int(11) UNSIGNED NOT NULL,
  `group_id` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `aauth_user_to_group`
--

INSERT INTO `aauth_user_to_group` (`user_id`, `group_id`) VALUES
(1, 1),
(1, 3),
(2, 3),
(2, 4),
(2, 5),
(3, 3),
(3, 4),
(3, 6),
(4, 3),
(4, 4),
(5, 3),
(5, 4),
(6, 3),
(6, 4),
(7, 3),
(7, 4),
(8, 3),
(8, 4),
(9, 3),
(9, 4),
(10, 3),
(10, 4),
(11, 3),
(11, 4),
(12, 3),
(12, 4),
(13, 3),
(13, 4),
(14, 3),
(14, 4),
(15, 3),
(15, 4),
(16, 3),
(16, 4),
(17, 1),
(17, 3),
(18, 1),
(18, 2),
(18, 3),
(18, 4),
(18, 5),
(18, 6),
(19, 3),
(19, 4),
(20, 3),
(20, 4),
(21, 3),
(21, 4),
(22, 3),
(22, 4),
(23, 3),
(23, 4),
(24, 3),
(24, 4),
(25, 3),
(25, 4),
(26, 3),
(26, 4),
(27, 3),
(27, 4),
(28, 3),
(28, 4),
(29, 3),
(29, 4),
(30, 3),
(30, 4),
(31, 3),
(31, 4),
(32, 3),
(32, 4),
(33, 3),
(33, 4),
(34, 3),
(34, 4),
(35, 3),
(35, 4),
(36, 3),
(36, 4),
(37, 3),
(37, 4),
(38, 3),
(38, 4),
(39, 3),
(39, 4),
(40, 3),
(40, 4),
(41, 3),
(41, 4),
(42, 3),
(42, 4),
(43, 3),
(43, 4),
(44, 3),
(44, 4);

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

--
-- Table structure for table `aauth_user_variables`
--

CREATE TABLE `aauth_user_variables` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `data_key` varchar(100) NOT NULL,
  `value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `agama`
--

CREATE TABLE `agama` (
  `id_agama` int(11) NOT NULL,
  `agama` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `agama`
--

INSERT INTO `agama` (`id_agama`, `agama`) VALUES
(1, 'Islam'),
(2, 'Kristen'),
(3, 'Hindu'),
(4, 'Budha'),
(5, 'Katholik'),
(6, 'Protestan');

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

--
-- Table structure for table `barang`
--

CREATE TABLE `barang` (
  `id_barang` int(11) NOT NULL,
  `nama_barang` varchar(50) NOT NULL,
  `merek` varchar(100) NOT NULL,
  `kategori` varchar(100) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `satuan` varchar(50) NOT NULL,
  `gambar` varchar(100) NOT NULL,
  `keterangan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `barang`
--

INSERT INTO `barang` (`id_barang`, `nama_barang`, `merek`, `kategori`, `jumlah`, `satuan`, `gambar`, `keterangan`) VALUES
(17, 'Komputer Dell Optiplex 3011 AIO', 'Dell', 'KOMPUTER', -2, '2', '20190323093435-2019-03-23barang093203.jpg', 'Bantuan Propinsi Kalimantan Tengah Tahun 2014<br />\r\n1. No.&nbsp;<br />\r\n2.&nbsp;'),
(18, 'Kamera DSLR Nikon D90', 'Nikon', 'Foto Grafi', -1, '1', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"1066\">\r\n	<tbody>\r\n		<tr height=\"20\">\r\n			<td height=\"20\" width=\"105\">12/KOM/2011</td>\r\n			<td width=\"344\">TUSTEL NIKON D 90</td>\r\n			<td width=\"191\">NIKON</td>\r\n			<td width=\"181\">2279235</td>\r\n			<td width=\"137\">BAIK&nbsp;</td>\r\n			<td width=\"108\">2010</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n'),
(19, 'Printer Color LaserJet Pro MFP M177fw', 'HP', 'PRINTER', -2, '2', '20190323094726-2019-03-23barang094701.jpg', 'Bantuan dari Propinsi Kalimantan Tengah Tahun 2014'),
(21, 'UPS APC SMC1500I', 'APC', 'UPS', -1, '1', '20190325121945-2019-03-25barang121942.jpg', 'Bantuan Sarpras&nbsp; Bimas Katolik Kemenag RI Tahun 2018'),
(22, 'AC LG 2PK', 'LG', 'AC', -1, '1', '20190325120619-2019-03-25barang120608.jpg', 'AC LG 2 PK bantuan Sarpras 2017'),
(23, 'Kursi Putar Tiger', 'Tiger', 'MEBEL', -2, '2', '20190325121404-2019-03-25barang121048.jpg', '20/MEJ/2011 BOP 2010'),
(24, 'Jam Dinding Mirado', 'Mirado', 'JAM', -1, '1', '20190325122406-2019-03-25barang122237.jpg', '23/KOM/2011 Pengadaan Lembaga 2003'),
(25, 'LCD SONY VPL-DX211', 'SONY', 'PROYEKTOR', -5, '6', '20190325123120-2019-03-25barang123112.jpg', 'Bantuan Sarpras Bimas Katolik Tahun 2017'),
(27, 'PC Lenovo E72', 'Lenovo', 'KOMPUTER', -20, '20', '20190326100526-2019-03-26barang100515.jpg', 'Bantuan Dari Pemda Kalimantan Tengah Tahun 2015 SK No. 188.44/442/2015'),
(28, 'UPS ICA CT1082B 2000VA', 'ICA', 'UPS', -10, '10', '20190326101135-2019-03-26barang101045.jpg', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015'),
(29, 'Projektor Infocus 124 3200VA', 'Infocus', 'PROYEKTOR', -1, '1', '20190328083612-2019-03-28barang083607.jpg', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015'),
(30, 'Layar Proyektor dan Motor', 'China', 'PROYEKTOR', -1, '1', '20190328101437-2019-03-28barang101432.jpg', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015'),
(32, 'Modem D-Link DIR 605L Cloud Router', 'D-Link', 'Jaringan', -1, '1', '20190328083038-2019-03-28barang083026.jpg', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015'),
(33, 'Dongle Wifi Proyektor', 'China', 'PROYEKTOR', -1, '1', '', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015'),
(34, 'Instalasi Komputer Lab', 'China', 'KOMPUTER', -1, '1', '', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015'),
(35, 'PC HP Pavilion S5-1420 D-20 Inc', 'HP', 'KOMPUTER', -1, '1', '', 'Bantuan Kota Palangkaraya Tahun 2013 Berita Acara&nbsp; Serah Terima Barang No. 02.1a/DP-CV/BASTB/PKY/IV/ 013 Tanggal 11/3/2013'),
(36, 'Epson Stylus Office T1100', 'Epson', 'PRINTER', -1, '1', '', 'Dinas Pendidikan Propinsi Kalteng Tahun 2013 Nomor Kontrak 027/26/PNSP/I/2013 Tanggal 29 Januari 2013'),
(38, 'Lemari Kaca Alumunium', 'King Alumunium', 'MEBEL', -5, '5', '20190327110927-2019-03-27barang110737.jpg', 'Bantuan BOP Bimas Katolik Tahun 2009'),
(39, 'Lemari Besi', 'Alba', 'MEBEL', -2, '2', '20190328083930-2019-03-28barang083902.jpg', 'Bantuan BOP 2011&nbsp;'),
(40, 'Lemari Arsip besi', 'Brother, Lion, Royal', 'MEBEL', -3, '3', '20190328084405-2019-03-28barang084340.jpg', 'Merk Royal Rusak'),
(41, 'Printer Epson TX220', 'Epson', 'PRINTER', -1, '1', '20190328084726-2019-03-28barang084653.jpg', 'Rusak untuk Printernya Digunakan hanya Scanernya'),
(42, 'Printer HP Laser Jet P1102', 'HP', 'PRINTER', -1, '1', '20190328085713-2019-03-28barang085636.jpg', 'Bantuan BOP 2010 (Kondisi Rusak Tonernya)'),
(43, 'HP Laser Jet P1005', 'HP', 'PRINTER', -1, '1', '20190328090401-2019-03-28barang090324.jpg', 'BOP 2011'),
(45, 'Netbook Toshiba NB200', 'Toshiba', 'KOMPUTER', -1, '1', '20190328092153-2019-03-28barang092147.jpg', 'BOP 2011'),
(46, 'AC LG Smart Inverter', 'LG', 'AC', -1, '1', '20190328101833-2019-03-28barang101743.jpg', 'LG Smart Inverter Tahun 2018 (menjelang Akreditasi)'),
(47, 'TV LCD LG 42', 'LG', 'TV', -1, '1', '20190328102201-2019-03-28barang102153.jpg', 'BOP 2011'),
(48, 'LCD Infokus R. Dosen', 'Infokus', 'PROYEKTOR', -1, '1', '20190328102539-2019-03-28barang102525.jpg', 'Tahun 2017'),
(49, 'Laptop Toshiba', 'Toshiba', 'KOMPUTER', -3, '3', '20190927084903-2019-09-27barang084658.jpg', '<br />\r\n1. No. 212/KOM/2014 (Hijau)<br />\r\n&nbsp;'),
(50, 'Scaner', 'Plustek SmartOffice PS30D', 'KOMPUTER', -1, '1', '20211215083204-2021-12-15barang083024.jpg', 'Scaner&nbsp;Plustek SmartOffice PS30D Bantuan Sarpras Bimas Katolik Kemnag RI Tahun Anggaran 2021<br />\r\nNo. 229/COM/2021'),
(51, 'Web Cam', 'Logitec Brio', 'KOMPUTER', -1, '1', '20211215083405-2021-12-15barang083241.jpg', 'Web Cam Logitec Brio Bantuan Sarpras Bimas Katolik Kemenag RI Tahun ANggaran 2021<br />\r\nNo. 230/Com/2021'),
(52, 'CCTV', 'HIKVISION', 'CCTV DAN KAMERA', -1, '1', '20211215084041-2021-12-15barang083802.jpg', '<p data-testid=\"lblSnapshotProductName\"><small>NVR KIT HIKVISION 4ch 2MP 1080P+POE+HARDDISK 500GB Bantuan Sarpras Bimas Katolik Tahun Anggaran 2021 (4&nbsp;Camera)</small><br />\r\nNo. 231/COM/2021</p>\r\n'),
(53, 'Router', 'TPLINK', 'Jaringan', -1, '1', '20211215084652-2021-12-15barang084343.jpg', '<p data-testid=\"lblSnapshotProductName\">TP-LINK TL-WR840N 300MBps Wireless Router TPLINK Bantuan Sarpras Bimas Katolik Kemenag RI TA. 2021</p>\r\n\r\n<p>No. 232/COM/2021<br />\r\n<strong>RUSAK TERSAMBAR PETI</strong>R</p>\r\n'),
(54, 'Akses Point Outdoor', 'Access Point Outdoor TP-LINK', 'Jaringan', -1, '1', '20211215085306-2021-12-15barang085125.png', '<p data-testid=\"lblSnapshotProductName\">Access Point Outdoor TP-LINK 2.4GHz 300Mbps CPE220 / CPE 220 / CPE-220<br />\r\nNo.233/COM/2021</p>\r\n'),
(55, 'Penguat Signal', 'TP-LINK TL-WA855RE', 'Jaringan', -6, '6', '20211215085653-2021-12-15barang085506.jpg', '<p data-testid=\"lblSnapshotProductName\">TP-LINK TL-WA855RE Penguat Signal/855re / WiFi Range Extender WA855RE<br />\r\nNo.234/com/2021</p>\r\n'),
(56, 'Kulkas Panasonic', 'Panasonic', 'PANTRY', -1, '1', '20211216085109-2021-12-16barang085016.jpg', 'Kulkas Panasonic dana Sarpras Bimas Katolik Kemeneg Tahun 2021<br />\r\n235/COM/2021'),
(57, 'Komputer Lenovo Ideacenter AIO330-20AST', 'Lenovo Ideacenter AIO330-20AST', 'KOMPUTER', -1, '1', '20220104091938-2022-01-04barang091651.jpeg', 'Lenovo Ideacenter AIO330-20AST Bantuan Sarpras Bimas Katolik Kemenag RI TA. 2021<br />\r\n236/com/2021'),
(58, 'Kabel Sambungan USB3', 'Indo Bestlink', 'KOMPUTER', -1, '1', '20220523082331-2022-05-23barang082238.jpg', 'Pembelian Mei 2022 Rp. 27.500'),
(59, 'Konverter HDMI to VGA', 'China (Tidak bermerk)', 'KOMPUTER', -2, '4', '20220523082525-2022-05-23barang082426.jpg', 'Pembelian Mei 2022 4 buah dengan harga @Rp.33.500,-'),
(60, 'Printer Epson L1800', 'Epson', 'KOMPUTER', -1, '1', '20221020204127-2022-10-20barang204057.jpg', 'Epson L1800 Pembelian Berasal dari Dana Lembaga STIPAS'),
(61, 'Server DELL PowerEdge R730', 'DELL', 'KOMPUTER', -1, '1', '20221020205052-2022-10-20barang205035.jpg', 'Bantuan Sarpras 2018 dari Bimas Katolik Kemenag'),
(62, 'Laptop HP Pavillion G4', 'HP', 'KOMPUTER', -2, '2', '20221020205957-2022-10-20barang205928.jpg', ''),
(63, 'Printer Brother', 'Brother MFC-J3520', 'PRINTER', -2, '3', '20230208102234-2023-02-08barang102230.jpg', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015'),
(64, 'Charge Aki', 'Voltuter', 'KOMPUTER', -1, '1', '20230420095129-2023-04-20barang095032.jpg', 'Dibeli STIPAS Bulan April 2023 237/Com/2023 Rp.356.200'),
(65, 'Genset Perkins 50 KW', 'Genset Perkins 50 KW', 'Listrik', -1, '1', '', 'Genset Sarpras berasal dari Bimas Katolik Kementerian Agama RI'),
(66, 'Kursi Aula', 'Matrix', 'MEBEL', -380, '380', '', 'Bantuan dari Sarpras Bimas Katolik Kemenag'),
(67, 'Sound System', 'B', 'SOUND SYSTEM', -2, '2', '', 'Bantuan Sarpras / BOP Bimas Katolik'),
(68, 'Meja Panjang Aula', 'Kayu', 'MEBEL', -2, '2', '', ''),
(69, 'Microphone Meja (aula)', 'no', 'SOUND SYSTEM', -2, '2', '', ''),
(70, 'Tiang Microphone (Stand Microphone)', 'No', 'SOUND SYSTEM', -1, '1', '', ''),
(71, 'Tiang Microphone Meja', 'No', 'SOUND SYSTEM', -2, '2', '', ''),
(72, 'Kursi Kuliah', 'Chitos/Tiger', 'MEBEL', -100, '100', '', ''),
(73, 'Meja Kayu R.Kuliah', 'Kayu', 'MEBEL', -4, '4', '', ''),
(74, 'White Board', 'White Board', 'MEBEL', -4, '4', '', ''),
(75, 'Papan Mading', 'Papan Mading', 'MEBEL', -2, '2', '', ''),
(76, 'Papan Pengumuman', 'Papan Pengumuman', 'MEBEL', -1, '1', '', ''),
(77, 'Kursi Panjang Bandara', 'Kursi Panjang Bandara', 'MEBEL', -8, '8', '', ''),
(78, 'Mesin Foto Copy Canon IR', 'Canon IR', 'KOMPUTER', -1, '1', '', ''),
(79, 'Meja Kayu Ruang Rapat', 'Kayu', 'MEBEL', -15, '15', '', 'Bantuan Sarpras 2023 Bimas Katolik'),
(80, 'Kursi Ruang Rapat', 'Matrik', 'MEBEL', -15, '15', '', ''),
(81, 'Lemari Kaca Ruang Rapat', 'Lemari Kaca', 'MEBEL', -1, '1', '', ''),
(82, 'Sound System Polytron Paspro', 'Sound System Polytron', 'SOUND SYSTEM', -1, '1', '20230726100902-2023-07-26barang100857.jpg', 'Sarpras 2023 BImas Katolik'),
(83, 'Keyboard Yamaha PSR-910', 'Keyboard Yamaha PSR-910', 'SOUND SYSTEM', -1, '1', '', ''),
(84, 'Keyboard Yamaha E273', 'Keyboard Yamaha E273', 'SOUND SYSTEM', -1, '1', '', ''),
(85, 'Gitar Akuistik Yamaha', 'Gitar Akuistik Yamaha', 'SOUND SYSTEM', -15, '15', '', ''),
(86, 'Alat Musik Tradisional Dayak 1 set', 'Alat Musik Tradisional Dayak 1 set', 'SOUND SYSTEM', -1, '1', '', ''),
(87, 'Alat Band Modern 1 set', 'Alat Band Modern 1 set', 'SOUND SYSTEM', -1, '1', '', ''),
(88, 'SSD Samsung 870EVO', 'Samsung', 'KOMPUTER', -4, '4', '20230726095711-2023-07-26barang095704.jpg', 'Pengadaan dari Sarpras Bimas Katolik Kemenag RI Tahun 2023'),
(89, 'Printer Canon PIXMA E410', 'Canon', 'PRINTER', -1, '2', '20231013122347-2023-10-13barang122321.png', 'Bantuan Sarpras Bimas Katolik Tahun 2023'),
(90, 'HDMI to VGA', 'Bafo', 'KOMPUTER', 0, '2', '20240118111401-2024-01-18barang111251.jpg', 'Sarana Bimas Katolik Tahun 2023&nbsp;'),
(91, 'Mini HDMI to VGA', 'NYK', 'KOMPUTER', 0, '3', '20240118111612-2024-01-18barang111549.jpg', 'Sarana Bimas Katolik 2023'),
(92, 'usb Tipe C to VGA', 'MAXTECH', 'KOMPUTER', 0, '3', '20240118111847-2024-01-18barang111828.jpg', 'Bantuan Sarana Bimas 2023'),
(93, 'SSD Ekternal', 'Lexar', 'KOMPUTER', -1, '1', '20240118112004-2024-01-18barang111946.jpg', 'Sarana Bantuan Bimas Katolik 2023'),
(94, 'Kabel VGA 10 meter', 'NYK', 'KOMPUTER', 0, '4', '20240118112233-2024-01-18barang112131.jpg', 'Bantuan Sarana Bimas Katolik 2023 panjang 10 meter'),
(95, 'Printer Epson L121', 'Epson', 'KOMPUTER', -1, '2', '20240118112418-2024-01-18barang112357.jpg', 'Bantuan Sarana Bimas Katolik 2023'),
(96, 'PC AIO ACER 22-1700 C13', 'Acer', 'KOMPUTER', -4, '4', '20240207084655-2024-02-07barang084515.jpeg', 'Bantuan BIMASKAT Sarana 2023 @Rp. 9.500.000'),
(97, 'Wireles Presenter', 'UGREEN', 'KOMPUTER', -2, '4', '20240426121953-2024-04-26barang121932.jpg', 'Sarpras Bimas Katolik 2023');

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `image` text NOT NULL,
  `category` varchar(200) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `title`, `content`, `image`, `category`, `created_at`) VALUES
(1, 'Blog Pertama Saya', 'Ini adalah blog pertama saya', '20180718202127-2018-07-18blog202114.jpg', 'Technology', '2018-07-18 13:00:00');

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

--
-- Table structure for table `blog_category`
--

CREATE TABLE `blog_category` (
  `category_id` int(11) UNSIGNED NOT NULL,
  `category_name` varchar(200) NOT NULL,
  `category_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `blog_category`
--

INSERT INTO `blog_category` (`category_id`, `category_name`, `category_desc`) VALUES
(1, 'Technology', '');

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

--
-- Table structure for table `captcha`
--

CREATE TABLE `captcha` (
  `captcha_id` int(11) UNSIGNED NOT NULL,
  `captcha_time` int(10) DEFAULT NULL,
  `ip_address` varchar(45) NOT NULL,
  `word` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `captcha`
--

INSERT INTO `captcha` (`captcha_id`, `captcha_time`, `ip_address`, `word`) VALUES
(1031, 1760919690, '192.36.109.70', '8T6W');

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

--
-- Table structure for table `cc_options`
--

CREATE TABLE `cc_options` (
  `id` int(11) UNSIGNED NOT NULL,
  `option_name` varchar(200) NOT NULL,
  `option_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cc_options`
--

INSERT INTO `cc_options` (`id`, `option_name`, `option_value`) VALUES
(1, 'active_theme', 'cicool'),
(2, 'favicon', 'default.png'),
(3, 'site_name', 'Inventaris Barang STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(4, 'email', 'admin@stipas.ac.id'),
(5, 'author', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(6, 'site_description', 'Merupakan aplikasi untuk mendata inventaris secara on line'),
(7, 'keywords', 'inventaris stipas'),
(8, 'landing_page_id', '1');

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

--
-- Table structure for table `cc_session`
--

CREATE TABLE `cc_session` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) NOT NULL,
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `crud`
--

CREATE TABLE `crud` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `table_name` varchar(200) NOT NULL,
  `primary_key` varchar(200) NOT NULL,
  `page_read` varchar(20) DEFAULT NULL,
  `page_create` varchar(20) DEFAULT NULL,
  `page_update` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `crud`
--

INSERT INTO `crud` (`id`, `title`, `subject`, `table_name`, `primary_key`, `page_read`, `page_create`, `page_update`) VALUES
(2, 'Jabatan', 'Jabatan', 'jabatan', 'id_jabatan', 'yes', 'yes', 'yes'),
(8, 'Blog', 'Blog', 'blog', 'id', 'yes', 'yes', 'yes'),
(9, 'Blog Category', 'Blog Category', 'blog_category', 'category_id', 'yes', 'yes', 'yes'),
(19, 'Return', 'Return', 'retur', 'id_return', 'yes', 'yes', 'yes'),
(20, 'Data Peminjam', 'Data Peminjam', 'karyawan', 'id_karyawan', 'yes', 'yes', 'yes'),
(22, 'Departemen', 'Departemen', 'departemen', 'id_dep', 'yes', 'yes', 'yes'),
(23, 'Supplier', 'Supplier', 'supplier', 'id_sup', 'yes', 'yes', 'yes'),
(24, 'Lokasi', 'Lokasi', 'lokasi', 'id_lok', 'yes', 'yes', 'yes'),
(25, 'Jenis Pengadaan', 'Jenis Pengadaan', 'jenis_pengadaan', 'id_jenis_pendagaan', 'yes', 'yes', 'yes'),
(26, 'Kategori', 'Kategori', 'kategori', 'id_kategori', 'yes', 'yes', 'yes'),
(28, 'Penempatan', 'Penempatan', 'penempatan', 'id_penempatan', 'yes', 'yes', 'yes'),
(29, 'Barang', 'Barang', 'barang', 'id_barang', 'yes', 'yes', 'yes'),
(30, 'Peminjaman', 'Peminjaman', 'pengajuan', 'id_pengajuan', 'yes', 'yes', 'yes'),
(31, 'Pengembalian', 'Pengembalian', 'pengembalian', 'id_kembali', 'yes', 'yes', 'yes'),
(33, 'Pengadaan', 'Pengadaan', 'pengadaan', 'id_pengadaan', 'yes', 'yes', 'yes'),
(35, 'Mutasi', 'Mutasi', 'mutasi', 'id_mutasi', 'yes', 'yes', 'yes');

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

--
-- Table structure for table `crud_custom_option`
--

CREATE TABLE `crud_custom_option` (
  `id` int(11) UNSIGNED NOT NULL,
  `crud_field_id` int(11) NOT NULL,
  `crud_id` int(11) NOT NULL,
  `option_value` text NOT NULL,
  `option_label` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `crud_custom_option`
--

INSERT INTO `crud_custom_option` (`id`, `crud_field_id`, `crud_id`, `option_value`, `option_label`) VALUES
(11, 175, 4, 'Laki-laki', 'Laki-laki'),
(12, 175, 4, 'Perempuan', 'Perempuan');

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

--
-- Table structure for table `crud_field`
--

CREATE TABLE `crud_field` (
  `id` int(11) UNSIGNED NOT NULL,
  `crud_id` int(11) NOT NULL,
  `field_name` varchar(200) NOT NULL,
  `input_type` varchar(200) NOT NULL,
  `show_column` varchar(10) DEFAULT NULL,
  `show_add_form` varchar(10) DEFAULT NULL,
  `show_update_form` varchar(10) DEFAULT NULL,
  `show_detail_page` varchar(10) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `relation_table` varchar(200) DEFAULT NULL,
  `relation_value` varchar(200) DEFAULT NULL,
  `relation_label` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `crud_field`
--

INSERT INTO `crud_field` (`id`, `crud_id`, `field_name`, `input_type`, `show_column`, `show_add_form`, `show_update_form`, `show_detail_page`, `sort`, `relation_table`, `relation_value`, `relation_label`) VALUES
(1, 1, 'id_agama', 'number', '', '', '', 'yes', 1, '', '', ''),
(2, 1, 'agama', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(3, 2, 'id_jabatan', 'number', '', '', '', 'yes', 1, '', '', ''),
(4, 2, 'jabatan', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(15, 5, 'id_barang', 'number', '', '', '', 'yes', 1, '', '', ''),
(16, 5, 'nama_barang', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(17, 5, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(27, 6, 'id_pengajuan', 'number', '', '', '', 'yes', 1, '', '', ''),
(28, 6, 'nama_pemohon', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'karyawan', 'nama_lengkap', 'nama_lengkap'),
(29, 6, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'barang', 'nama_barang', 'nama_barang'),
(30, 6, 'jumlah_barang', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(31, 6, 'keperluan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 5, '', '', ''),
(32, 6, 'ruangan', 'select', 'yes', 'yes', 'yes', 'yes', 6, 'ruangan', 'ruangan', 'ruangan'),
(33, 6, 'tanggal_pinjam', 'date', '', 'yes', 'yes', 'yes', 7, '', '', ''),
(34, 6, 'tanggal_kembali', 'date', 'yes', 'yes', 'yes', 'yes', 8, '', '', ''),
(35, 6, 'tanggal_input', 'timestamp', 'yes', 'yes', 'yes', 'yes', 9, '', '', ''),
(36, 7, 'id_barang', 'number', '', '', '', 'yes', 1, '', '', ''),
(37, 7, 'nama_barang', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(38, 7, 'stok', 'number', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(39, 7, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(40, 3, 'id_ruangan', 'number', '', '', '', 'yes', 1, '', '', ''),
(41, 3, 'ruangan', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(42, 3, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(63, 9, 'category_id', 'number', '', '', '', 'yes', 1, '', '', ''),
(64, 9, 'category_name', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(65, 9, 'category_desc', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(66, 8, 'id', 'number', '', '', '', 'yes', 1, '', '', ''),
(67, 8, 'title', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(68, 8, 'content', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(69, 8, 'image', 'file', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(70, 8, 'category', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'blog_category', 'category_name', 'category_name'),
(71, 8, 'created_at', 'datetime', 'yes', '', '', 'yes', 6, '', '', ''),
(72, 10, 'id_barang', 'number', '', '', '', 'yes', 1, '', '', ''),
(73, 10, 'nama_barang', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(74, 10, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(75, 10, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(111, 12, 'id_pengajuan', 'number', '', '', '', 'yes', 1, '', '', ''),
(112, 12, 'nik', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'karyawan', 'nik', 'nik'),
(113, 12, 'nama_pemohon', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'karyawan', 'nama_lengkap', 'nama_lengkap'),
(114, 12, 'no_telp', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(115, 12, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'barang', 'nama_barang', 'nama_barang'),
(116, 12, 'jumlah_barang', 'number', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(117, 12, 'ruangan', 'select', 'yes', 'yes', 'yes', 'yes', 7, 'ruangan', 'ruangan', 'ruangan'),
(118, 12, 'keperluan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 8, '', '', ''),
(119, 12, 'tgl_pinjam', 'timestamp', 'yes', 'yes', 'yes', 'yes', 9, '', '', ''),
(120, 12, 'tanggal_kembali', 'date', 'yes', 'yes', 'yes', 'yes', 10, '', '', ''),
(121, 13, 'id_pengajuan', 'number', '', '', '', 'yes', 1, '', '', ''),
(122, 13, 'nik', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'karyawan', 'nik', 'nik'),
(123, 13, 'nama_pemohon', 'input', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(124, 13, 'no_telp', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(125, 13, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'barang', 'nama_barang', 'nama_barang'),
(126, 13, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(127, 13, 'ruangan', 'select', 'yes', 'yes', 'yes', 'yes', 7, 'ruangan', 'ruangan', 'ruangan'),
(128, 13, 'keperluan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 8, '', '', ''),
(129, 13, 'tgl_pinjam', 'timestamp', 'yes', 'yes', 'yes', 'yes', 9, '', '', ''),
(130, 13, 'tanggal_kembali', 'date', 'yes', 'yes', 'yes', 'yes', 10, '', '', ''),
(131, 14, 'id_pengajuan', 'number', '', '', '', 'yes', 1, '', '', ''),
(132, 14, 'nik', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'karyawan', 'nik', 'nik'),
(133, 14, 'nama_lengkap', 'input', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(134, 14, 'no_telp', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(135, 14, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'barang', 'nama_barang', 'nama_barang'),
(136, 14, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(137, 14, 'ruangan', 'select', 'yes', 'yes', 'yes', 'yes', 7, 'ruangan', 'ruangan', 'ruangan'),
(138, 14, 'keperluan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 8, '', '', ''),
(139, 14, 'tgl_pinjam', 'timestamp', 'yes', 'yes', 'yes', 'yes', 9, '', '', ''),
(140, 14, 'tanggal_kembali', 'date', 'yes', 'yes', 'yes', 'yes', 10, '', '', ''),
(148, 15, 'id_pengajuan', 'number', '', '', '', 'yes', 1, '', '', ''),
(149, 15, 'nama_lengkap', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'karyawan', 'nama_lengkap', 'nama_lengkap'),
(150, 15, 'no_telp', 'number', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(151, 15, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'barang', 'nama_barang', 'nama_barang'),
(152, 15, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 5, '', '', ''),
(153, 15, 'ruangan', 'select', 'yes', 'yes', 'yes', 'yes', 6, 'ruangan', 'ruangan', 'ruangan'),
(154, 15, 'keperluan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(155, 15, 'tgl_pinjam', 'timestamp', 'yes', 'yes', 'yes', 'yes', 8, '', '', ''),
(156, 15, 'tanggal_kembali', 'date', 'yes', 'yes', 'yes', 'yes', 9, '', '', ''),
(157, 11, 'id_kembali', 'number', '', '', '', 'yes', 1, '', '', ''),
(158, 11, 'tanggal_entry', 'timestamp', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(159, 11, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'pengajuan', 'nama_barang', 'nama_barang'),
(160, 11, 'nama_peminjam', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'pengajuan', 'nama_lengkap', 'nama_lengkap'),
(161, 11, 'jumlah', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'pengajuan', 'jumlah', 'jumlah'),
(162, 11, 'tanggal_kembali', 'date', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(163, 11, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(164, 16, 'id_barang', 'number', '', '', '', 'yes', 1, '', '', ''),
(165, 16, 'nama_barang', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(166, 16, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(167, 16, 'gambar', 'file', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(168, 16, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 5, '', '', ''),
(169, 4, 'id_karyawan', 'number', '', '', '', 'yes', 1, '', '', ''),
(170, 4, 'nama_lengkap', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(171, 4, 'nik', 'input', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(172, 4, 'jabatan', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'jabatan', 'jabatan', 'jabatan'),
(173, 4, 'alamat', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 5, '', '', ''),
(174, 4, 'agama', 'input', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(175, 4, 'jenis_kelamin', 'custom_option', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(180, 17, 'id_karyawan', 'number', '', '', '', 'yes', 1, '', '', ''),
(181, 17, 'nama_lengkap', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(182, 17, 'nik', 'input', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(183, 17, 'jabatan', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'jabatan', 'jabatan', 'jabatan'),
(184, 18, 'id_barang', 'number', '', '', '', 'yes', 1, '', '', ''),
(185, 18, 'nama_barang', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(186, 18, 'tipe_barang', 'input', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(187, 18, 'serial_number', 'input', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(188, 18, 'nomor_barang', 'input', 'yes', 'yes', 'yes', 'yes', 5, '', '', ''),
(189, 18, 'tahun', 'year', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(190, 18, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(191, 18, 'gambar', 'file', 'yes', 'yes', 'yes', 'yes', 8, '', '', ''),
(192, 18, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 9, '', '', ''),
(200, 20, 'id_karyawan', 'number', '', '', '', 'yes', 1, '', '', ''),
(201, 20, 'nama_lengkap', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(202, 20, 'telp', 'number', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(203, 20, 'nik', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(204, 20, 'jabatan', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'jabatan', 'jabatan', 'jabatan'),
(205, 21, 'id_pengajuan', 'number', '', '', '', 'yes', 1, '', '', ''),
(206, 21, 'nama_lengkap', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'karyawan', 'nama_lengkap', 'nama_lengkap'),
(207, 21, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'barang', 'nama_barang', 'nama_barang'),
(208, 21, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(209, 21, 'ruangan', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'ruangan', 'ruangan', 'ruangan'),
(210, 21, 'keperluan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(211, 21, 'tgl_pinjam', 'timestamp', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(212, 22, 'id_dep', 'number', '', '', '', 'yes', 1, '', '', ''),
(213, 22, 'nama_departemen', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(214, 22, 'keterangan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(215, 23, 'id_sup', 'number', '', '', '', 'yes', 1, '', '', ''),
(216, 23, 'nama_supplier', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(217, 23, 'alamat_lengkap', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(218, 23, 'no_telp', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(219, 24, 'id_lok', 'number', '', '', '', 'yes', 1, '', '', ''),
(220, 24, 'nama_lokasi', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(221, 24, 'departemen', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'departemen', 'nama_departemen', 'nama_departemen'),
(222, 25, 'id_jenis_pendagaan', 'number', '', '', '', 'yes', 1, '', '', ''),
(223, 25, 'jenis_pengadaan', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(224, 25, 'keterangan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(225, 26, 'id_kategori', 'number', '', '', '', 'yes', 1, '', '', ''),
(226, 26, 'katerogi', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(227, 26, 'keterangan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(237, 27, 'id_pengadaan', 'number', '', '', '', 'yes', 1, '', '', ''),
(238, 27, 'tanggal_pengadaan', 'date', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(239, 27, 'supplier', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'supplier', 'nama_supplier', 'nama_supplier'),
(240, 27, 'jenis_pengadaan', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'jenis_pengadaan', 'jenis_pengadaan', 'jenis_pengadaan'),
(241, 27, 'keterangan', 'editor_wysiwyg', '', 'yes', 'yes', 'yes', 5, '', '', ''),
(242, 27, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 6, 'barang', 'nama_barang', 'nama_barang'),
(243, 27, 'deskripsi_barang', 'editor_wysiwyg', '', 'yes', 'yes', 'yes', 7, '', '', ''),
(244, 27, 'harga', 'number', 'yes', 'yes', 'yes', 'yes', 8, '', '', ''),
(245, 27, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 9, '', '', ''),
(261, 29, 'id_barang', 'number', '', '', '', 'yes', 1, '', '', ''),
(262, 29, 'nama_barang', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(263, 29, 'merek', 'input', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(264, 29, 'kategori', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'kategori', 'katerogi', 'katerogi'),
(265, 29, 'jumlah', 'number', 'yes', '', '', 'yes', 5, '', '', ''),
(266, 29, 'satuan', 'input', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(267, 29, 'gambar', 'file', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(268, 29, 'keterangan', 'editor_wysiwyg', '', 'yes', 'yes', 'yes', 8, '', '', ''),
(276, 19, 'id_return', 'number', '', '', '', 'yes', 1, '', '', ''),
(277, 19, 'nomor_surat', 'input', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(278, 19, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'barang', 'nama_barang', 'nama_barang'),
(279, 19, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(280, 19, 'penerima_barang', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'departemen', 'nama_departemen', 'nama_departemen'),
(281, 19, 'berkas', 'file', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(282, 19, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(290, 31, 'id_kembali', 'number', '', '', '', 'yes', 1, '', '', ''),
(291, 31, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'barang', 'nama_barang', 'nama_barang'),
(292, 31, 'tanggal_entry', 'timestamp', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(293, 31, 'departemen_peminjam', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'departemen', 'nama_departemen', 'nama_departemen'),
(294, 31, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 5, '', '', ''),
(295, 31, 'tanggal_kembali', 'date', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(296, 31, 'deskripsi', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(297, 30, 'id_pengajuan', 'number', '', '', '', 'yes', 1, '', '', ''),
(298, 30, 'departemen', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'departemen', 'nama_departemen', 'nama_departemen'),
(299, 30, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'barang', 'nama_barang', 'nama_barang'),
(300, 30, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(301, 30, 'lokasi', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'lokasi', 'nama_lokasi', 'nama_lokasi'),
(302, 30, 'keperluan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 6, '', '', ''),
(303, 30, 'tgl_pinjam', 'timestamp', 'yes', 'yes', 'yes', 'yes', 7, '', '', ''),
(304, 32, 'id_mutasi', 'number', '', '', '', 'yes', 1, '', '', ''),
(305, 32, 'tanggal_mutasi', 'date', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(306, 32, 'keterangan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(307, 32, 'departemen', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'departemen', 'nama_departemen', 'nama_departemen'),
(308, 32, 'lokasi', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'lokasi', 'nama_lokasi', 'nama_lokasi'),
(309, 32, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 6, 'barang', 'nama_barang', 'nama_barang'),
(350, 33, 'id_pengadaan', 'number', '', '', '', 'yes', 1, '', '', ''),
(351, 33, 'tanggal_pengadaan', 'date', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(352, 33, 'supplier', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'supplier', 'nama_supplier', 'nama_supplier'),
(353, 33, 'jenis_pengadaan', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'jenis_pengadaan', 'jenis_pengadaan', 'jenis_pengadaan'),
(354, 33, 'keterangan', 'editor_wysiwyg', '', 'yes', 'yes', 'yes', 5, '', '', ''),
(355, 33, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 6, 'barang', 'nama_barang', 'nama_barang'),
(356, 33, 'deskripsi_barang', 'editor_wysiwyg', '', 'yes', 'yes', 'yes', 7, '', '', ''),
(357, 33, 'harga', 'number', 'yes', 'yes', 'yes', 'yes', 8, '', '', ''),
(358, 33, 'total', 'number', 'yes', '', '', 'yes', 9, '', '', ''),
(359, 33, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 10, '', '', ''),
(374, 34, 'id_mutasi', 'number', '', '', '', 'yes', 1, '', '', ''),
(375, 34, 'cari_id_penempatan', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'penempatan', 'lokasi', 'id_penempatan'),
(376, 34, 'tanggal_mutasi', 'date', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(377, 34, 'keterangan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(378, 34, 'departemen', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'departemen', 'nama_departemen', 'nama_departemen'),
(379, 34, 'lokasi', 'select', 'yes', 'yes', 'yes', 'yes', 6, 'lokasi', 'nama_lokasi', 'nama_lokasi'),
(380, 34, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 7, 'barang', 'nama_barang', 'nama_barang'),
(381, 35, 'id_mutasi', 'number', '', '', '', 'yes', 1, '', '', ''),
(382, 35, 'id_penempatan', 'select', 'yes', 'yes', 'yes', 'yes', 2, 'penempatan', 'lokasi', 'id_penempatan'),
(383, 35, 'tanggal_mutasi', 'date', 'yes', 'yes', 'yes', 'yes', 3, '', '', ''),
(384, 35, 'keterangan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 4, '', '', ''),
(385, 35, 'departemen', 'select', 'yes', 'yes', 'yes', 'yes', 5, 'departemen', 'nama_departemen', 'nama_departemen'),
(386, 35, 'lokasi', 'select', 'yes', 'yes', 'yes', 'yes', 6, 'lokasi', 'nama_lokasi', 'nama_lokasi'),
(387, 35, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 7, 'barang', 'nama_barang', 'nama_barang'),
(388, 28, 'id_penempatan', 'number', 'yes', '', '', 'yes', 1, '', '', ''),
(389, 28, 'tanggal_penempatan', 'date', 'yes', 'yes', 'yes', 'yes', 2, '', '', ''),
(390, 28, 'departemen', 'select', 'yes', 'yes', 'yes', 'yes', 3, 'departemen', 'nama_departemen', 'nama_departemen'),
(391, 28, 'lokasi', 'select', 'yes', 'yes', 'yes', 'yes', 4, 'lokasi', 'nama_lokasi', 'nama_lokasi'),
(392, 28, 'keterangan', 'editor_wysiwyg', 'yes', 'yes', 'yes', 'yes', 5, '', '', ''),
(393, 28, 'nama_barang', 'select', 'yes', 'yes', 'yes', 'yes', 6, 'barang', 'nama_barang', 'nama_barang'),
(394, 28, 'jumlah', 'number', 'yes', 'yes', 'yes', 'yes', 7, '', '', '');

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

--
-- Table structure for table `crud_field_validation`
--

CREATE TABLE `crud_field_validation` (
  `id` int(11) UNSIGNED NOT NULL,
  `crud_field_id` int(11) NOT NULL,
  `crud_id` int(11) NOT NULL,
  `validation_name` varchar(200) NOT NULL,
  `validation_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `crud_field_validation`
--

INSERT INTO `crud_field_validation` (`id`, `crud_field_id`, `crud_id`, `validation_name`, `validation_value`) VALUES
(1, 2, 1, 'required', ''),
(2, 2, 1, 'max_length', '10'),
(3, 4, 2, 'required', ''),
(4, 4, 2, 'max_length', '50'),
(19, 16, 5, 'required', ''),
(20, 16, 5, 'max_length', '50'),
(21, 17, 5, 'required', ''),
(34, 28, 6, 'required', ''),
(35, 28, 6, 'max_length', '50'),
(36, 29, 6, 'required', ''),
(37, 29, 6, 'max_length', '50'),
(38, 30, 6, 'required', ''),
(39, 30, 6, 'max_length', '11'),
(40, 31, 6, 'required', ''),
(41, 32, 6, 'required', ''),
(42, 32, 6, 'max_length', '50'),
(43, 33, 6, 'required', ''),
(44, 34, 6, 'required', ''),
(45, 37, 7, 'required', ''),
(46, 37, 7, 'max_length', '50'),
(47, 38, 7, 'required', ''),
(48, 38, 7, 'max_length', '11'),
(49, 39, 7, 'required', ''),
(50, 41, 3, 'required', ''),
(51, 41, 3, 'max_length', '50'),
(80, 64, 9, 'required', ''),
(81, 64, 9, 'max_length', '200'),
(82, 67, 8, 'required', ''),
(83, 67, 8, 'max_length', '200'),
(84, 68, 8, 'required', ''),
(85, 69, 8, 'allowed_extension', 'jpg,jpeg,png'),
(86, 69, 8, 'max_size', '2000'),
(87, 70, 8, 'required', ''),
(88, 70, 8, 'max_length', '200'),
(89, 71, 8, 'required', ''),
(90, 73, 10, 'required', ''),
(91, 74, 10, 'required', ''),
(92, 74, 10, 'valid_number', ''),
(128, 112, 12, 'required', ''),
(129, 113, 12, 'required', ''),
(130, 114, 12, 'required', ''),
(131, 114, 12, 'valid_number', ''),
(132, 115, 12, 'required', ''),
(133, 116, 12, 'required', ''),
(134, 116, 12, 'valid_number', ''),
(135, 117, 12, 'required', ''),
(136, 118, 12, 'required', ''),
(137, 119, 12, 'required', ''),
(138, 122, 13, 'required', ''),
(139, 123, 13, 'required', ''),
(140, 124, 13, 'required', ''),
(141, 124, 13, 'valid_number', ''),
(142, 125, 13, 'required', ''),
(143, 126, 13, 'required', ''),
(144, 126, 13, 'valid_number', ''),
(145, 127, 13, 'required', ''),
(146, 129, 13, 'required', ''),
(147, 130, 13, 'required', ''),
(148, 132, 14, 'required', ''),
(149, 133, 14, 'required', ''),
(150, 134, 14, 'required', ''),
(151, 134, 14, 'valid_number', ''),
(152, 135, 14, 'required', ''),
(153, 136, 14, 'required', ''),
(154, 136, 14, 'valid_number', ''),
(155, 137, 14, 'required', ''),
(156, 139, 14, 'required', ''),
(157, 140, 14, 'required', ''),
(163, 149, 15, 'required', ''),
(164, 150, 15, 'required', ''),
(165, 150, 15, 'valid_number', ''),
(166, 151, 15, 'required', ''),
(167, 152, 15, 'required', ''),
(168, 152, 15, 'valid_number', ''),
(169, 153, 15, 'required', ''),
(170, 155, 15, 'required', ''),
(171, 156, 15, 'required', ''),
(172, 159, 11, 'required', ''),
(173, 160, 11, 'required', ''),
(174, 161, 11, 'required', ''),
(175, 162, 11, 'required', ''),
(176, 165, 16, 'required', ''),
(177, 166, 16, 'required', ''),
(178, 166, 16, 'valid_number', ''),
(179, 167, 16, 'allowed_extension', 'jpg,jpeg,png'),
(180, 170, 4, 'required', ''),
(181, 170, 4, 'max_length', '50'),
(182, 171, 4, 'required', ''),
(183, 171, 4, 'max_length', '50'),
(184, 172, 4, 'required', ''),
(185, 172, 4, 'max_length', '50'),
(186, 173, 4, 'required', ''),
(187, 174, 4, 'max_length', '15'),
(188, 175, 4, 'required', ''),
(193, 181, 17, 'required', ''),
(194, 181, 17, 'max_length', '50'),
(195, 182, 17, 'required', ''),
(196, 183, 17, 'required', ''),
(197, 185, 18, 'required', ''),
(198, 186, 18, 'required', ''),
(199, 187, 18, 'required', ''),
(200, 188, 18, 'required', ''),
(201, 189, 18, 'required', ''),
(202, 190, 18, 'required', ''),
(203, 191, 18, 'required', ''),
(204, 192, 18, 'required', ''),
(210, 201, 20, 'required', ''),
(211, 202, 20, 'required', ''),
(212, 203, 20, 'required', ''),
(213, 204, 20, 'required', ''),
(214, 206, 21, 'required', ''),
(215, 207, 21, 'required', ''),
(216, 208, 21, 'required', ''),
(217, 209, 21, 'required', ''),
(218, 210, 21, 'required', ''),
(219, 211, 21, 'required', ''),
(220, 213, 22, 'required', ''),
(221, 216, 23, 'required', ''),
(222, 220, 24, 'required', ''),
(223, 221, 24, 'required', ''),
(224, 223, 25, 'required', ''),
(225, 226, 26, 'required', ''),
(231, 238, 27, 'required', ''),
(232, 239, 27, 'required', ''),
(233, 242, 27, 'required', ''),
(234, 244, 27, 'required', ''),
(235, 245, 27, 'required', ''),
(245, 262, 29, 'required', ''),
(246, 263, 29, 'required', ''),
(247, 264, 29, 'required', ''),
(248, 267, 29, 'allowed_extension', 'jpg,png,JPG,PNG,JPEG,jpeg'),
(254, 277, 19, 'required', ''),
(255, 278, 19, 'required', ''),
(256, 279, 19, 'required', ''),
(257, 280, 19, 'required', ''),
(264, 291, 31, 'required', ''),
(265, 292, 31, 'required', ''),
(266, 293, 31, 'required', ''),
(267, 294, 31, 'required', ''),
(268, 295, 31, 'required', ''),
(269, 298, 30, 'required', ''),
(270, 299, 30, 'required', ''),
(271, 300, 30, 'required', ''),
(272, 301, 30, 'required', ''),
(273, 302, 30, 'required', ''),
(274, 305, 32, 'required', ''),
(275, 307, 32, 'required', ''),
(276, 308, 32, 'required', ''),
(277, 309, 32, 'required', ''),
(305, 351, 33, 'required', ''),
(306, 352, 33, 'required', ''),
(307, 353, 33, 'required', ''),
(308, 355, 33, 'required', ''),
(309, 357, 33, 'required', ''),
(310, 359, 33, 'required', ''),
(321, 375, 34, 'required', ''),
(322, 376, 34, 'required', ''),
(323, 378, 34, 'required', ''),
(324, 379, 34, 'required', ''),
(325, 380, 34, 'required', ''),
(326, 382, 35, 'required', ''),
(327, 383, 35, 'required', ''),
(328, 385, 35, 'required', ''),
(329, 386, 35, 'required', ''),
(330, 387, 35, 'required', ''),
(331, 389, 28, 'required', ''),
(332, 390, 28, 'required', ''),
(333, 391, 28, 'required', ''),
(334, 393, 28, 'required', ''),
(335, 394, 28, 'required', '');

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

--
-- Table structure for table `crud_input_type`
--

CREATE TABLE `crud_input_type` (
  `id` int(11) UNSIGNED NOT NULL,
  `type` varchar(200) NOT NULL,
  `relation` varchar(20) NOT NULL,
  `custom_value` int(11) NOT NULL,
  `validation_group` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;



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

--
-- Table structure for table `crud_input_validation`
--

CREATE TABLE `crud_input_validation` (
  `id` int(11) UNSIGNED NOT NULL,
  `validation` varchar(200) NOT NULL,
  `input_able` varchar(20) NOT NULL,
  `group_input` text NOT NULL,
  `input_placeholder` text NOT NULL,
  `call_back` varchar(10) NOT NULL,
  `input_validation` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `crud_input_validation`
--

INSERT INTO `crud_input_validation` (`id`, `validation`, `input_able`, `group_input`, `input_placeholder`, `call_back`, `input_validation`) VALUES
(1, 'required', 'no', 'input, file, number, text, datetime, select, password, email, editor, date, yes_no, time, year, select_multiple, options, checkboxes, true_false, address_map, custom_option, custom_checkbox, custom_select_multiple, custom_select, file_multiple', '', '', ''),
(2, 'max_length', 'yes', 'input, number, text, select, password, email, editor, yes_no, time, year, select_multiple, options, checkboxes, address_map', '', '', 'numeric'),
(3, 'min_length', 'yes', 'input, number, text, select, password, email, editor, time, year, select_multiple, address_map', '', '', 'numeric'),
(4, 'valid_email', 'no', 'input, email', '', '', ''),
(5, 'valid_emails', 'no', 'input, email', '', '', ''),
(6, 'regex', 'yes', 'input, number, text, datetime, select, password, email, editor, date, yes_no, time, year, select_multiple, options, checkboxes', '', 'yes', 'callback_valid_regex'),
(7, 'decimal', 'no', 'input, number, text, select', '', '', ''),
(8, 'allowed_extension', 'yes', 'file, file_multiple', 'ex : jpg,png,..', '', 'callback_valid_extension_list'),
(9, 'max_width', 'yes', 'file, file_multiple', '', '', 'numeric'),
(10, 'max_height', 'yes', 'file, file_multiple', '', '', 'numeric'),
(11, 'max_size', 'yes', 'file, file_multiple', '... kb', '', 'numeric'),
(12, 'max_item', 'yes', 'file_multiple', '', '', 'numeric'),
(13, 'valid_url', 'no', 'input, text', '', '', ''),
(14, 'alpha', 'no', 'input, text, select, password, editor, yes_no', '', '', ''),
(15, 'alpha_numeric', 'no', 'input, number, text, select, password, editor', '', '', ''),
(16, 'alpha_numeric_spaces', 'no', 'input, number, text,select, password, editor', '', '', ''),
(17, 'valid_number', 'no', 'input, number, text, password, editor, true_false', '', 'yes', ''),
(18, 'valid_datetime', 'no', 'input, datetime, text', '', 'yes', ''),
(19, 'valid_date', 'no', 'input, datetime, date, text', '', 'yes', ''),
(20, 'valid_max_selected_option', 'yes', 'select_multiple, custom_select_multiple, custom_checkbox, checkboxes', '', 'yes', 'numeric'),
(21, 'valid_min_selected_option', 'yes', 'select_multiple, custom_select_multiple, custom_checkbox, checkboxes', '', 'yes', 'numeric'),
(22, 'valid_alpha_numeric_spaces_underscores', 'no', 'input, text,select, password, editor', '', 'yes', ''),
(23, 'matches', 'yes', 'input, number, text, password, email', 'any field', 'no', 'callback_valid_alpha_numeric_spaces_underscores'),
(24, 'valid_json', 'no', 'input, text, editor', '', 'yes', ' '),
(25, 'valid_url', 'no', 'input, text, editor', '', 'no', ' '),
(26, 'exact_length', 'yes', 'input, text, number', '0 - 99999*', 'no', 'numeric'),
(27, 'alpha_dash', 'no', 'input, text', '', 'no', ''),
(28, 'integer', 'no', 'input, text, number', '', 'no', ''),
(29, 'differs', 'yes', 'input, text, number, email, password, editor, options, select', 'any field', 'no', 'callback_valid_alpha_numeric_spaces_underscores'),
(30, 'is_natural', 'no', 'input, text, number', '', 'no', ''),
(31, 'is_natural_no_zero', 'no', 'input, text, number', '', 'no', ''),
(32, 'less_than', 'yes', 'input, text, number', '', 'no', 'numeric'),
(33, 'less_than_equal_to', 'yes', 'input, text, number', '', 'no', 'numeric'),
(34, 'greater_than', 'yes', 'input, text, number', '', 'no', 'numeric'),
(35, 'greater_than_equal_to', 'yes', 'input, text, number', '', 'no', 'numeric'),
(36, 'in_list', 'yes', 'input, text, number, select, options', '', 'no', 'callback_valid_multiple_value'),
(37, 'valid_ip', 'no', 'input, text', '', 'no', '');

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

--
-- Table structure for table `departemen`
--

CREATE TABLE `departemen` (
  `id_dep` int(11) NOT NULL,
  `nama_departemen` varchar(100) NOT NULL,
  `keterangan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `departemen`
--

INSERT INTO `departemen` (`id_dep`, `nama_departemen`, `keterangan`) VALUES
(5, 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Inventaris STIPAS'),
(6, 'SMAK St. Aloysius Palangka Raya', '');

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

--
-- Table structure for table `form`
--

CREATE TABLE `form` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `table_name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `form`
--

INSERT INTO `form` (`id`, `title`, `subject`, `table_name`) VALUES
(1, 'Pengajuan Pinjam Barang', 'Pengajuan Pinjam Barang', 'form_pengajuan_pinjam_barang');

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

--
-- Table structure for table `form_custom_attribute`
--

CREATE TABLE `form_custom_attribute` (
  `id` int(11) UNSIGNED NOT NULL,
  `form_field_id` int(11) NOT NULL,
  `form_id` int(11) NOT NULL,
  `attribute_value` text NOT NULL,
  `attribute_label` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `form_custom_option`
--

CREATE TABLE `form_custom_option` (
  `id` int(11) UNSIGNED NOT NULL,
  `form_field_id` int(11) NOT NULL,
  `form_id` int(11) NOT NULL,
  `option_value` text NOT NULL,
  `option_label` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `form_field`
--

CREATE TABLE `form_field` (
  `id` int(11) UNSIGNED NOT NULL,
  `form_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL,
  `field_name` varchar(200) NOT NULL,
  `input_type` varchar(200) NOT NULL,
  `field_label` varchar(200) DEFAULT NULL,
  `placeholder` text DEFAULT NULL,
  `auto_generate_help_block` varchar(10) DEFAULT NULL,
  `help_block` text DEFAULT NULL,
  `relation_table` varchar(200) DEFAULT NULL,
  `relation_value` varchar(200) DEFAULT NULL,
  `relation_label` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `form_field`
--

INSERT INTO `form_field` (`id`, `form_id`, `sort`, `field_name`, `input_type`, `field_label`, `placeholder`, `auto_generate_help_block`, `help_block`, `relation_table`, `relation_value`, `relation_label`) VALUES
(58, 1, 1, 'nik_nidn_nim', 'select', 'NIK/NIDN/NIM', '', 'yes', '', 'karyawan', 'nik', 'nik'),
(59, 1, 2, 'nama_peminjam', 'select', 'Nama Peminjam', '', 'yes', '', 'karyawan', 'nama_lengkap', 'nama_lengkap'),
(60, 1, 3, 'no_telp_hp', 'input', 'No Telp / Hp', '', 'yes', '', '', '', ''),
(61, 1, 4, 'nama_barang', 'select', 'Nama Barang', '', 'yes', '', 'barang', 'nama_barang', 'nama_barang'),
(62, 1, 5, 'dipakai_di', 'select', 'Dipakai di', '', 'yes', '', 'ruangan', 'ruangan', 'ruangan'),
(63, 1, 6, 'digunakan_untuk', 'editor_wysiwyg', 'Digunakan Untuk', '', 'yes', '', '', '', ''),
(64, 1, 7, 'jumlah', 'input', 'Jumlah', '', 'yes', '', '', '', ''),
(65, 1, 8, 'tanggal_pinjam', 'timestamp', 'Tanggal Pinjam', '', 'yes', '', '', '', ''),
(66, 1, 9, 'tanggal_kembali', 'date', 'Tanggal Kembali', '', 'yes', '', '', '', '');

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

--
-- Table structure for table `form_field_validation`
--

CREATE TABLE `form_field_validation` (
  `id` int(11) UNSIGNED NOT NULL,
  `form_field_id` int(11) NOT NULL,
  `form_id` int(11) NOT NULL,
  `validation_name` varchar(200) NOT NULL,
  `validation_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `form_field_validation`
--

INSERT INTO `form_field_validation` (`id`, `form_field_id`, `form_id`, `validation_name`, `validation_value`) VALUES
(50, 58, 1, 'required', ''),
(51, 59, 1, 'required', ''),
(52, 60, 1, 'required', ''),
(53, 61, 1, 'required', ''),
(54, 62, 1, 'required', ''),
(55, 63, 1, 'required', ''),
(56, 64, 1, 'required', ''),
(57, 66, 1, 'required', '');

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

--
-- Table structure for table `form_pengajuan_pinjam_barang`
--

CREATE TABLE `form_pengajuan_pinjam_barang` (
  `id` int(11) UNSIGNED NOT NULL,
  `nik_nidn_nim` varchar(225) NOT NULL,
  `nama_peminjam` varchar(225) NOT NULL,
  `no_telp_hp` varchar(225) NOT NULL,
  `nama_barang` varchar(225) NOT NULL,
  `dipakai_di` varchar(225) NOT NULL,
  `digunakan_untuk` text NOT NULL,
  `jumlah` varchar(225) NOT NULL,
  `tanggal_pinjam` text DEFAULT NULL,
  `tanggal_kembali` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `form_pengajuan_pinjam_barang`
--

INSERT INTO `form_pengajuan_pinjam_barang` (`id`, `nik_nidn_nim`, `nama_peminjam`, `no_telp_hp`, `nama_barang`, `dipakai_di`, `digunakan_untuk`, `jumlah`, `tanggal_pinjam`, `tanggal_kembali`) VALUES
(1, '3521354314354', 'Tio Panji Mahardika, S. Kom', '567567567', 'Mouse', 'IT', 'fyhfghfg', '5', '2018-07-23 10:05:27', '2018-07-24');

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

--
-- Table structure for table `jabatan`
--

CREATE TABLE `jabatan` (
  `id_jabatan` int(11) NOT NULL,
  `jabatan` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `jabatan`
--

INSERT INTO `jabatan` (`id_jabatan`, `jabatan`) VALUES
(1, 'Ketua Stikes'),
(2, 'Puket I'),
(3, 'Puket II'),
(4, 'Puket III'),
(5, 'Kaprodi S1 Ilmu Keperawatan'),
(6, 'Kaprodi DIII Keperawatan'),
(7, 'Kaprodi DIII Kebidanan'),
(8, 'Kaprodi DIV Bidan Pendidik'),
(9, 'Kaprodi Ners'),
(10, 'Kabag IT'),
(11, 'Kabag BAAK'),
(12, 'Kabag LPM'),
(13, 'Kabag LPPM'),
(14, 'Kabag Sarpras'),
(15, 'Kabag BAK'),
(16, 'Kabag BAUP'),
(17, 'Karyawan'),
(18, 'Supir'),
(19, 'Dosen'),
(20, 'Satpam'),
(21, 'Kebun'),
(22, 'Mahasiswa S1 Ilmu Keperawatan'),
(23, 'Mahasiswa DIV Bidan Pendidik'),
(24, 'Mahasiswa Profesi Ners'),
(25, 'Mahasiswa DIII Keperawatan'),
(26, 'Mahasiswa DIII Kebidanan');

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

--
-- Table structure for table `jenis_pengadaan`
--

CREATE TABLE `jenis_pengadaan` (
  `id_jenis_pendagaan` int(11) NOT NULL,
  `jenis_pengadaan` varchar(100) NOT NULL,
  `keterangan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `jenis_pengadaan`
--

INSERT INTO `jenis_pengadaan` (`id_jenis_pendagaan`, `jenis_pengadaan`, `keterangan`) VALUES
(6, 'Bantuan Bimas Katolik Kemenag RI', 'Bantuan Bimas Katolik Kemenag RI berupa sarana dan prasarana'),
(7, 'Pembelian dari Lembaga STIPAS', 'Inventaris Pembelian dari Lembaga STIPAS'),
(8, 'Bantuan Dari Pemerintah Daerah', 'Bantuan Dari Pemerintah Daerah baik Kota maupun Propinsi');

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

--
-- Table structure for table `karyawan`
--

CREATE TABLE `karyawan` (
  `id_karyawan` int(11) NOT NULL,
  `nama_lengkap` varchar(50) NOT NULL,
  `telp` varchar(13) NOT NULL,
  `nik` varchar(50) NOT NULL,
  `jabatan` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `karyawan`
--

INSERT INTO `karyawan` (`id_karyawan`, `nama_lengkap`, `telp`, `nik`, `jabatan`) VALUES
(6, 'Murjana', '0855665566', '123456789', 'Karyawan'),
(7, 'Putu Agus', '025354851215', '543233445435345', 'Karyawan'),
(9, 'Sapoy Corp', '082330726906', '1234346354324', 'Puket I');

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

--
-- Table structure for table `kategori`
--

CREATE TABLE `kategori` (
  `id_kategori` int(11) NOT NULL,
  `katerogi` varchar(100) NOT NULL,
  `keterangan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kategori`
--

INSERT INTO `kategori` (`id_kategori`, `katerogi`, `keterangan`) VALUES
(1, 'KOMPUTER', ''),
(2, 'MEBEL', ''),
(3, 'ATK', ''),
(4, 'AC', ''),
(6, 'SOUND SYSTEM', ''),
(7, 'PRINTER', ''),
(8, 'PROYEKTOR', ''),
(9, 'JAM', ''),
(10, 'HIASAN', ''),
(11, 'PANTRY', ''),
(12, 'UPS', ''),
(13, 'Foto Grafi', ''),
(14, 'Jaringan', ''),
(15, 'TV', ''),
(16, 'CCTV DAN KAMERA', ''),
(17, 'Listrik', '');

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

--
-- Table structure for table `lokasi`
--

CREATE TABLE `lokasi` (
  `id_lok` int(11) NOT NULL,
  `nama_lokasi` varchar(100) NOT NULL,
  `departemen` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `lokasi`
--

INSERT INTO `lokasi` (`id_lok`, `nama_lokasi`, `departemen`) VALUES
(4, 'Ruang Ketua', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(5, 'Ruang Waket I', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(6, 'Ruang Waket II', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(7, 'Ruang Waket III', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(8, 'Ruang Ketua Program Studi Pendidikan Dan Pengajaran Agama Katolik', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(9, 'Ruang Sekretariat', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(10, 'Ruang Administrasi Pendidikan', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(11, 'Ruang Bendahara dan Keuangan', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(12, 'Ruang Dosen', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(13, 'Ruang Makan', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(14, 'Ruang Dapur', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(15, 'Ruang Kuliah I', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(16, 'Ruang Kuliah II', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(17, 'Ruang Kuliah III', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(18, 'Ruang Kuliah IV', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(19, 'Ruang Musik', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(20, 'Ruang Komputer / Lab Komputer', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(21, 'Ruang Perpustakaan', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(22, 'Ruang Rm Frans', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(23, 'Luar Gedung STIPAS', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(24, 'Lantai 1', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(25, 'Lantai 2', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(26, 'Lantai 3', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(27, 'Gudang', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(28, 'SMAK st. Aloysius', 'SMAK St. Aloysius Palangka Raya'),
(29, 'Kapel', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(30, 'Ruang Rapat', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(31, 'LPPM', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya'),
(32, 'LPM', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya');

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int(11) UNSIGNED NOT NULL,
  `label` varchar(200) DEFAULT NULL,
  `type` varchar(200) DEFAULT NULL,
  `icon_color` varchar(200) DEFAULT NULL,
  `link` varchar(200) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `parent` int(11) NOT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `menu_type_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`id`, `label`, `type`, `icon_color`, `link`, `sort`, `parent`, `icon`, `menu_type_id`) VALUES
(1, 'MAIN NAVIGATION', 'label', '', 'administrator/dashboard', 1, 0, '', 1),
(2, 'Dashboard', 'menu', '', 'administrator/dashboard', 2, 0, 'fa-dashboard', 1),
(8, 'Akun', 'menu', 'default', '#', 28, 0, 'fa-shield', 1),
(9, 'User', 'menu', '', 'administrator/user', 29, 8, '', 1),
(10, 'Groups', 'menu', '', 'administrator/group', 30, 8, '', 1),
(11, 'Access', 'menu', '', 'administrator/access', 31, 8, '', 1),
(14, 'Kofigurasi', 'menu', 'default', '#', 32, 0, 'fa-cogs', 1),
(15, 'Settings', 'menu', 'text-red', 'administrator/setting', 33, 14, 'fa-circle-o', 1),
(18, 'Home', 'menu', 'default', '/', 1, 0, '', 2),
(21, 'Dashboard', 'menu', '', 'administrator/dashboard', 4, 0, '', 2),
(23, 'Master Data', 'menu', 'default', '#', 3, 0, 'fa-database', 1),
(32, 'Peminjaman', 'menu', 'default', '#', 19, 0, 'fa-edit', 1),
(33, 'Input Peminjaman', 'menu', 'default', 'administrator/pengajuan/add', 20, 32, '', 1),
(34, 'View', 'menu', 'default', 'administrator/pengajuan', 21, 32, '', 1),
(35, 'Pengembalian', 'menu', 'default', '#', 22, 0, 'fa-mail-reply', 1),
(36, 'Input Barang Kembali', 'menu', 'default', 'administrator/pengembalian/add', 23, 35, '', 1),
(37, 'View', 'menu', 'default', 'administrator/pengembalian', 24, 35, '', 1),
(41, 'Return', 'menu', 'default', 'administrator/retur', 25, 0, 'fa-car', 1),
(42, 'Input Return', 'menu', 'default', 'administrator/retur/add', 26, 41, '', 1),
(43, 'View', 'menu', 'default', 'administrator/retur', 27, 41, '', 1),
(47, 'Departemen', 'menu', 'default', 'administrator/departemen', 4, 23, '', 1),
(48, 'Supplier', 'menu', 'default', 'administrator/supplier', 5, 23, '', 1),
(49, 'Lokasi', 'menu', 'default', 'administrator/lokasi', 6, 23, '', 1),
(50, 'Jenis Pengadaan', 'menu', 'default', 'administrator/jenis_pengadaan', 7, 23, '', 1),
(51, 'Kategori', 'menu', 'default', 'administrator/kategori', 8, 23, '', 1),
(52, 'Pengadaan', 'menu', 'default', '#', 10, 0, 'fa-money', 1),
(53, 'View', 'menu', 'default', 'administrator/pengadaan', 12, 52, '', 1),
(54, 'Input Pengadaan', 'menu', 'default', 'administrator/pengadaan/add', 11, 52, '', 1),
(55, 'Data Barang', 'menu', 'default', 'administrator/barang', 9, 0, 'fa-briefcase', 1),
(56, 'Penempatan', 'menu', 'default', '#', 13, 0, 'fa-map-marker', 1),
(57, 'Input Penempatan', 'menu', 'default', 'administrator/penempatan/add', 14, 56, '', 1),
(58, 'View', 'menu', 'default', 'administrator/penempatan', 15, 56, '', 1),
(59, 'Mutasi', 'menu', 'default', '#', 16, 0, 'fa-cut', 1),
(60, 'Input Mutasi', 'menu', 'default', 'administrator/mutasi/add', 17, 59, '', 1),
(61, 'View', 'menu', 'default', 'administrator/mutasi', 18, 59, '', 1);

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

--
-- Table structure for table `menu_icon`
--

CREATE TABLE `menu_icon` (
  `class_name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `menu_icon`
--

INSERT INTO `menu_icon` (`class_name`) VALUES
('fa-500px'),
('fa-adjust'),
('fa-adn'),
('fa-align'),
('fa-align'),
('fa-align'),
('fa-align'),
('fa-amazon'),
('fa-ambulance'),
('fa-american'),
('fa-anchor'),
('fa-android'),
('fa-angellist'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-apple'),
('fa-archive'),
('fa-area'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrows'),
('fa-arrows'),
('fa-arrows'),
('fa-arrows'),
('fa-asl'),
('fa-assistive'),
('fa-asterisk'),
('fa-at'),
('fa-audio'),
('fa-automobile'),
('fa-backward'),
('fa-balance'),
('fa-ban'),
('fa-bank'),
('fa-bar'),
('fa-bar'),
('fa-barcode'),
('fa-bars'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-bed'),
('fa-beer'),
('fa-behance'),
('fa-behance'),
('fa-bell'),
('fa-bell'),
('fa-bell'),
('fa-bell'),
('fa-bicycle'),
('fa-binoculars'),
('fa-birthday'),
('fa-bitbucket'),
('fa-bitbucket'),
('fa-bitcoin'),
('fa-black'),
('fa-blind'),
('fa-bluetooth'),
('fa-bluetooth'),
('fa-bold'),
('fa-bolt'),
('fa-bomb'),
('fa-book'),
('fa-bookmark'),
('fa-bookmark'),
('fa-braille'),
('fa-briefcase'),
('fa-btc'),
('fa-bug'),
('fa-building'),
('fa-building'),
('fa-bullhorn'),
('fa-bullseye'),
('fa-bus'),
('fa-buysellads'),
('fa-cab'),
('fa-calculator'),
('fa-calendar'),
('fa-calendar'),
('fa-calendar'),
('fa-calendar'),
('fa-calendar'),
('fa-calendar'),
('fa-camera'),
('fa-camera'),
('fa-car'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-cart'),
('fa-cart'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-certificate'),
('fa-chain'),
('fa-chain'),
('fa-check'),
('fa-check'),
('fa-check'),
('fa-check'),
('fa-check'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-child'),
('fa-chrome'),
('fa-circle'),
('fa-circle'),
('fa-circle'),
('fa-circle'),
('fa-clipboard'),
('fa-clock'),
('fa-clone'),
('fa-close'),
('fa-cloud'),
('fa-cloud'),
('fa-cloud'),
('fa-cny'),
('fa-code'),
('fa-code'),
('fa-codepen'),
('fa-codiepie'),
('fa-coffee'),
('fa-cog'),
('fa-cogs'),
('fa-columns'),
('fa-comment'),
('fa-comment'),
('fa-commenting'),
('fa-commenting'),
('fa-comments'),
('fa-comments'),
('fa-compass'),
('fa-compress'),
('fa-connectdevelop'),
('fa-contao'),
('fa-copy'),
('fa-copyright'),
('fa-creative'),
('fa-credit'),
('fa-credit'),
('fa-crop'),
('fa-crosshairs'),
('fa-css3'),
('fa-cube'),
('fa-cubes'),
('fa-cut'),
('fa-cutlery'),
('fa-dashboard'),
('fa-dashcube'),
('fa-database'),
('fa-deaf'),
('fa-deafness'),
('fa-dedent'),
('fa-delicious'),
('fa-desktop'),
('fa-deviantart'),
('fa-diamond'),
('fa-digg'),
('fa-dollar'),
('fa-dot'),
('fa-download'),
('fa-dribbble'),
('fa-dropbox'),
('fa-drupal'),
('fa-edge'),
('fa-edit'),
('fa-eject'),
('fa-ellipsis'),
('fa-ellipsis'),
('fa-empire'),
('fa-envelope'),
('fa-envelope'),
('fa-envelope'),
('fa-envira'),
('fa-eraser'),
('fa-eur'),
('fa-euro'),
('fa-exchange'),
('fa-exclamation'),
('fa-exclamation'),
('fa-exclamation'),
('fa-expand'),
('fa-expeditedssl'),
('fa-external'),
('fa-external'),
('fa-eye'),
('fa-eye'),
('fa-eyedropper'),
('fa-fa'),
('fa-facebook'),
('fa-facebook'),
('fa-facebook'),
('fa-facebook'),
('fa-fast'),
('fa-fast'),
('fa-fax'),
('fa-feed'),
('fa-female'),
('fa-fighter'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-files'),
('fa-film'),
('fa-filter'),
('fa-fire'),
('fa-fire'),
('fa-firefox'),
('fa-first'),
('fa-flag'),
('fa-flag'),
('fa-flag'),
('fa-flash'),
('fa-flask'),
('fa-flickr'),
('fa-floppy'),
('fa-folder'),
('fa-folder'),
('fa-folder'),
('fa-folder'),
('fa-font'),
('fa-font'),
('fa-fonticons'),
('fa-fort'),
('fa-forumbee'),
('fa-forward'),
('fa-foursquare'),
('fa-frown'),
('fa-futbol'),
('fa-gamepad'),
('fa-gavel'),
('fa-gbp'),
('fa-ge'),
('fa-gear'),
('fa-gears'),
('fa-genderless'),
('fa-get'),
('fa-gg'),
('fa-gg'),
('fa-gift'),
('fa-git'),
('fa-git'),
('fa-github'),
('fa-github'),
('fa-github'),
('fa-gitlab'),
('fa-gittip'),
('fa-glass'),
('fa-glide'),
('fa-glide'),
('fa-globe'),
('fa-google'),
('fa-google'),
('fa-google'),
('fa-google'),
('fa-google'),
('fa-google'),
('fa-graduation'),
('fa-gratipay'),
('fa-group'),
('fa-h'),
('fa-hacker'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hard'),
('fa-hashtag'),
('fa-hdd'),
('fa-header'),
('fa-headphones'),
('fa-heart'),
('fa-heart'),
('fa-heartbeat'),
('fa-history'),
('fa-home'),
('fa-hospital'),
('fa-hotel'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-houzz'),
('fa-html5'),
('fa-i'),
('fa-ils'),
('fa-image'),
('fa-inbox'),
('fa-indent'),
('fa-industry'),
('fa-info'),
('fa-info'),
('fa-inr'),
('fa-instagram'),
('fa-institution'),
('fa-internet'),
('fa-intersex'),
('fa-ioxhost'),
('fa-italic'),
('fa-joomla'),
('fa-jpy'),
('fa-jsfiddle'),
('fa-key'),
('fa-keyboard'),
('fa-krw'),
('fa-language'),
('fa-laptop'),
('fa-lastfm'),
('fa-lastfm'),
('fa-leaf'),
('fa-leanpub'),
('fa-legal'),
('fa-lemon'),
('fa-level'),
('fa-level'),
('fa-life'),
('fa-life'),
('fa-life'),
('fa-life'),
('fa-lightbulb'),
('fa-line'),
('fa-link'),
('fa-linkedin'),
('fa-linkedin'),
('fa-linux'),
('fa-list'),
('fa-list'),
('fa-list'),
('fa-list'),
('fa-location'),
('fa-lock'),
('fa-long'),
('fa-long'),
('fa-long'),
('fa-long'),
('fa-low'),
('fa-magic'),
('fa-magnet'),
('fa-mail'),
('fa-mail'),
('fa-mail'),
('fa-male'),
('fa-map'),
('fa-map'),
('fa-map'),
('fa-map'),
('fa-map'),
('fa-mars'),
('fa-mars'),
('fa-mars'),
('fa-mars'),
('fa-mars'),
('fa-maxcdn'),
('fa-meanpath'),
('fa-medium'),
('fa-medkit'),
('fa-meh'),
('fa-mercury'),
('fa-microphone'),
('fa-microphone'),
('fa-minus'),
('fa-minus'),
('fa-minus'),
('fa-minus'),
('fa-mixcloud'),
('fa-mobile'),
('fa-mobile'),
('fa-modx'),
('fa-money'),
('fa-moon'),
('fa-mortar'),
('fa-motorcycle'),
('fa-mouse'),
('fa-music'),
('fa-navicon'),
('fa-neuter'),
('fa-newspaper'),
('fa-object'),
('fa-object'),
('fa-odnoklassniki'),
('fa-odnoklassniki'),
('fa-opencart'),
('fa-openid'),
('fa-opera'),
('fa-optin'),
('fa-outdent'),
('fa-pagelines'),
('fa-paint'),
('fa-paper'),
('fa-paper'),
('fa-paperclip'),
('fa-paragraph'),
('fa-paste'),
('fa-pause'),
('fa-pause'),
('fa-pause'),
('fa-paw'),
('fa-paypal'),
('fa-pencil'),
('fa-pencil'),
('fa-pencil'),
('fa-percent'),
('fa-phone'),
('fa-phone'),
('fa-photo'),
('fa-picture'),
('fa-pie'),
('fa-pied'),
('fa-pied'),
('fa-pied'),
('fa-pinterest'),
('fa-pinterest'),
('fa-pinterest'),
('fa-plane'),
('fa-play'),
('fa-play'),
('fa-play'),
('fa-plug'),
('fa-plus'),
('fa-plus'),
('fa-plus'),
('fa-plus'),
('fa-power'),
('fa-print'),
('fa-product'),
('fa-puzzle'),
('fa-qq'),
('fa-qrcode'),
('fa-question'),
('fa-question'),
('fa-question'),
('fa-quote'),
('fa-quote'),
('fa-ra'),
('fa-random'),
('fa-rebel'),
('fa-recycle'),
('fa-reddit'),
('fa-reddit'),
('fa-reddit'),
('fa-refresh'),
('fa-registered'),
('fa-remove'),
('fa-renren'),
('fa-reorder'),
('fa-repeat'),
('fa-reply'),
('fa-reply'),
('fa-resistance'),
('fa-retweet'),
('fa-rmb'),
('fa-road'),
('fa-rocket'),
('fa-rotate'),
('fa-rotate'),
('fa-rouble'),
('fa-rss'),
('fa-rss'),
('fa-rub'),
('fa-ruble'),
('fa-rupee'),
('fa-safari'),
('fa-save'),
('fa-scissors'),
('fa-scribd'),
('fa-search'),
('fa-search'),
('fa-search'),
('fa-sellsy'),
('fa-send'),
('fa-send'),
('fa-server'),
('fa-share'),
('fa-share'),
('fa-share'),
('fa-share'),
('fa-share'),
('fa-shekel'),
('fa-sheqel'),
('fa-shield'),
('fa-ship'),
('fa-shirtsinbulk'),
('fa-shopping'),
('fa-shopping'),
('fa-shopping'),
('fa-sign'),
('fa-sign'),
('fa-sign'),
('fa-signal'),
('fa-signing'),
('fa-simplybuilt'),
('fa-sitemap'),
('fa-skyatlas'),
('fa-skype'),
('fa-slack'),
('fa-sliders'),
('fa-slideshare'),
('fa-smile'),
('fa-snapchat'),
('fa-snapchat'),
('fa-snapchat'),
('fa-soccer'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-soundcloud'),
('fa-space'),
('fa-spinner'),
('fa-spoon'),
('fa-spotify'),
('fa-square'),
('fa-square'),
('fa-stack'),
('fa-stack'),
('fa-star'),
('fa-star'),
('fa-star'),
('fa-star'),
('fa-star'),
('fa-star'),
('fa-steam'),
('fa-steam'),
('fa-step'),
('fa-step'),
('fa-stethoscope'),
('fa-sticky'),
('fa-sticky'),
('fa-stop'),
('fa-stop'),
('fa-stop'),
('fa-street'),
('fa-strikethrough'),
('fa-stumbleupon'),
('fa-stumbleupon'),
('fa-subscript'),
('fa-subway'),
('fa-suitcase'),
('fa-sun'),
('fa-superscript'),
('fa-support'),
('fa-table'),
('fa-tablet'),
('fa-tachometer'),
('fa-tag'),
('fa-tags'),
('fa-tasks'),
('fa-taxi'),
('fa-television'),
('fa-tencent'),
('fa-terminal'),
('fa-text'),
('fa-text'),
('fa-th'),
('fa-th'),
('fa-th'),
('fa-themeisle'),
('fa-thumb'),
('fa-thumbs'),
('fa-thumbs'),
('fa-thumbs'),
('fa-thumbs'),
('fa-ticket'),
('fa-times'),
('fa-times'),
('fa-times'),
('fa-tint'),
('fa-toggle'),
('fa-toggle'),
('fa-toggle'),
('fa-toggle'),
('fa-toggle'),
('fa-toggle'),
('fa-trademark'),
('fa-train'),
('fa-transgender'),
('fa-transgender'),
('fa-trash'),
('fa-trash'),
('fa-tree'),
('fa-trello'),
('fa-tripadvisor'),
('fa-trophy'),
('fa-truck'),
('fa-try'),
('fa-tty'),
('fa-tumblr'),
('fa-tumblr'),
('fa-turkish'),
('fa-tv'),
('fa-twitch'),
('fa-twitter'),
('fa-twitter'),
('fa-umbrella'),
('fa-underline'),
('fa-undo'),
('fa-universal'),
('fa-university'),
('fa-unlink'),
('fa-unlock'),
('fa-unlock'),
('fa-unsorted'),
('fa-upload'),
('fa-usb'),
('fa-usd'),
('fa-user'),
('fa-user'),
('fa-user'),
('fa-user'),
('fa-user'),
('fa-users'),
('fa-venus'),
('fa-venus'),
('fa-venus'),
('fa-viacoin'),
('fa-viadeo'),
('fa-viadeo'),
('fa-video'),
('fa-vimeo'),
('fa-vimeo'),
('fa-vine'),
('fa-vk'),
('fa-volume'),
('fa-volume'),
('fa-volume'),
('fa-volume'),
('fa-warning'),
('fa-wechat'),
('fa-weibo'),
('fa-weixin'),
('fa-whatsapp'),
('fa-wheelchair'),
('fa-wheelchair'),
('fa-wifi'),
('fa-wikipedia'),
('fa-windows'),
('fa-won'),
('fa-wordpress'),
('fa-wpbeginner'),
('fa-wpforms'),
('fa-wrench'),
('fa-xing'),
('fa-xing'),
('fa-y'),
('fa-y'),
('fa-yahoo'),
('fa-yc'),
('fa-yc'),
('fa-yelp'),
('fa-yen'),
('fa-yoast'),
('fa-youtube'),
('fa-youtube'),
('fa-youtube'),
('fa-500px'),
('fa-adjust'),
('fa-adn'),
('fa-align'),
('fa-align'),
('fa-align'),
('fa-align'),
('fa-amazon'),
('fa-ambulance'),
('fa-american'),
('fa-anchor'),
('fa-android'),
('fa-angellist'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-angle'),
('fa-apple'),
('fa-archive'),
('fa-area'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrow'),
('fa-arrows'),
('fa-arrows'),
('fa-arrows'),
('fa-arrows'),
('fa-asl'),
('fa-assistive'),
('fa-asterisk'),
('fa-at'),
('fa-audio'),
('fa-automobile'),
('fa-backward'),
('fa-balance'),
('fa-ban'),
('fa-bank'),
('fa-bar'),
('fa-bar'),
('fa-barcode'),
('fa-bars'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-battery'),
('fa-bed'),
('fa-beer'),
('fa-behance'),
('fa-behance'),
('fa-bell'),
('fa-bell'),
('fa-bell'),
('fa-bell'),
('fa-bicycle'),
('fa-binoculars'),
('fa-birthday'),
('fa-bitbucket'),
('fa-bitbucket'),
('fa-bitcoin'),
('fa-black'),
('fa-blind'),
('fa-bluetooth'),
('fa-bluetooth'),
('fa-bold'),
('fa-bolt'),
('fa-bomb'),
('fa-book'),
('fa-bookmark'),
('fa-bookmark'),
('fa-braille'),
('fa-briefcase'),
('fa-btc'),
('fa-bug'),
('fa-building'),
('fa-building'),
('fa-bullhorn'),
('fa-bullseye'),
('fa-bus'),
('fa-buysellads'),
('fa-cab'),
('fa-calculator'),
('fa-calendar'),
('fa-calendar'),
('fa-calendar'),
('fa-calendar'),
('fa-calendar'),
('fa-calendar'),
('fa-camera'),
('fa-camera'),
('fa-car'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-caret'),
('fa-cart'),
('fa-cart'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-cc'),
('fa-certificate'),
('fa-chain'),
('fa-chain'),
('fa-check'),
('fa-check'),
('fa-check'),
('fa-check'),
('fa-check'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-chevron'),
('fa-child'),
('fa-chrome'),
('fa-circle'),
('fa-circle'),
('fa-circle'),
('fa-circle'),
('fa-clipboard'),
('fa-clock'),
('fa-clone'),
('fa-close'),
('fa-cloud'),
('fa-cloud'),
('fa-cloud'),
('fa-cny'),
('fa-code'),
('fa-code'),
('fa-codepen'),
('fa-codiepie'),
('fa-coffee'),
('fa-cog'),
('fa-cogs'),
('fa-columns'),
('fa-comment'),
('fa-comment'),
('fa-commenting'),
('fa-commenting'),
('fa-comments'),
('fa-comments'),
('fa-compass'),
('fa-compress'),
('fa-connectdevelop'),
('fa-contao'),
('fa-copy'),
('fa-copyright'),
('fa-creative'),
('fa-credit'),
('fa-credit'),
('fa-crop'),
('fa-crosshairs'),
('fa-css3'),
('fa-cube'),
('fa-cubes'),
('fa-cut'),
('fa-cutlery'),
('fa-dashboard'),
('fa-dashcube'),
('fa-database'),
('fa-deaf'),
('fa-deafness'),
('fa-dedent'),
('fa-delicious'),
('fa-desktop'),
('fa-deviantart'),
('fa-diamond'),
('fa-digg'),
('fa-dollar'),
('fa-dot'),
('fa-download'),
('fa-dribbble'),
('fa-dropbox'),
('fa-drupal'),
('fa-edge'),
('fa-edit'),
('fa-eject'),
('fa-ellipsis'),
('fa-ellipsis'),
('fa-empire'),
('fa-envelope'),
('fa-envelope'),
('fa-envelope'),
('fa-envira'),
('fa-eraser'),
('fa-eur'),
('fa-euro'),
('fa-exchange'),
('fa-exclamation'),
('fa-exclamation'),
('fa-exclamation'),
('fa-expand'),
('fa-expeditedssl'),
('fa-external'),
('fa-external'),
('fa-eye'),
('fa-eye'),
('fa-eyedropper'),
('fa-fa'),
('fa-facebook'),
('fa-facebook'),
('fa-facebook'),
('fa-facebook'),
('fa-fast'),
('fa-fast'),
('fa-fax'),
('fa-feed'),
('fa-female'),
('fa-fighter'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-file'),
('fa-files'),
('fa-film'),
('fa-filter'),
('fa-fire'),
('fa-fire'),
('fa-firefox'),
('fa-first'),
('fa-flag'),
('fa-flag'),
('fa-flag'),
('fa-flash'),
('fa-flask'),
('fa-flickr'),
('fa-floppy'),
('fa-folder'),
('fa-folder'),
('fa-folder'),
('fa-folder'),
('fa-font'),
('fa-font'),
('fa-fonticons'),
('fa-fort'),
('fa-forumbee'),
('fa-forward'),
('fa-foursquare'),
('fa-frown'),
('fa-futbol'),
('fa-gamepad'),
('fa-gavel'),
('fa-gbp'),
('fa-ge'),
('fa-gear'),
('fa-gears'),
('fa-genderless'),
('fa-get'),
('fa-gg'),
('fa-gg'),
('fa-gift'),
('fa-git'),
('fa-git'),
('fa-github'),
('fa-github'),
('fa-github'),
('fa-gitlab'),
('fa-gittip'),
('fa-glass'),
('fa-glide'),
('fa-glide'),
('fa-globe'),
('fa-google'),
('fa-google'),
('fa-google'),
('fa-google'),
('fa-google'),
('fa-google'),
('fa-graduation'),
('fa-gratipay'),
('fa-group'),
('fa-h'),
('fa-hacker'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hand'),
('fa-hard'),
('fa-hashtag'),
('fa-hdd'),
('fa-header'),
('fa-headphones'),
('fa-heart'),
('fa-heart'),
('fa-heartbeat'),
('fa-history'),
('fa-home'),
('fa-hospital'),
('fa-hotel'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-hourglass'),
('fa-houzz'),
('fa-html5'),
('fa-i'),
('fa-ils'),
('fa-image'),
('fa-inbox'),
('fa-indent'),
('fa-industry'),
('fa-info'),
('fa-info'),
('fa-inr'),
('fa-instagram'),
('fa-institution'),
('fa-internet'),
('fa-intersex'),
('fa-ioxhost'),
('fa-italic'),
('fa-joomla'),
('fa-jpy'),
('fa-jsfiddle'),
('fa-key'),
('fa-keyboard'),
('fa-krw'),
('fa-language'),
('fa-laptop'),
('fa-lastfm'),
('fa-lastfm'),
('fa-leaf'),
('fa-leanpub'),
('fa-legal'),
('fa-lemon'),
('fa-level'),
('fa-level'),
('fa-life'),
('fa-life'),
('fa-life'),
('fa-life'),
('fa-lightbulb'),
('fa-line'),
('fa-link'),
('fa-linkedin'),
('fa-linkedin'),
('fa-linux'),
('fa-list'),
('fa-list'),
('fa-list'),
('fa-list'),
('fa-location'),
('fa-lock'),
('fa-long'),
('fa-long'),
('fa-long'),
('fa-long'),
('fa-low'),
('fa-magic'),
('fa-magnet'),
('fa-mail'),
('fa-mail'),
('fa-mail'),
('fa-male'),
('fa-map'),
('fa-map'),
('fa-map'),
('fa-map'),
('fa-map'),
('fa-mars'),
('fa-mars'),
('fa-mars'),
('fa-mars'),
('fa-mars'),
('fa-maxcdn'),
('fa-meanpath'),
('fa-medium'),
('fa-medkit'),
('fa-meh'),
('fa-mercury'),
('fa-microphone'),
('fa-microphone'),
('fa-minus'),
('fa-minus'),
('fa-minus'),
('fa-minus'),
('fa-mixcloud'),
('fa-mobile'),
('fa-mobile'),
('fa-modx'),
('fa-money'),
('fa-moon'),
('fa-mortar'),
('fa-motorcycle'),
('fa-mouse'),
('fa-music'),
('fa-navicon'),
('fa-neuter'),
('fa-newspaper'),
('fa-object'),
('fa-object'),
('fa-odnoklassniki'),
('fa-odnoklassniki'),
('fa-opencart'),
('fa-openid'),
('fa-opera'),
('fa-optin'),
('fa-outdent'),
('fa-pagelines'),
('fa-paint'),
('fa-paper'),
('fa-paper'),
('fa-paperclip'),
('fa-paragraph'),
('fa-paste'),
('fa-pause'),
('fa-pause'),
('fa-pause'),
('fa-paw'),
('fa-paypal'),
('fa-pencil'),
('fa-pencil'),
('fa-pencil'),
('fa-percent'),
('fa-phone'),
('fa-phone'),
('fa-photo'),
('fa-picture'),
('fa-pie'),
('fa-pied'),
('fa-pied'),
('fa-pied'),
('fa-pinterest'),
('fa-pinterest'),
('fa-pinterest'),
('fa-plane'),
('fa-play'),
('fa-play'),
('fa-play'),
('fa-plug'),
('fa-plus'),
('fa-plus'),
('fa-plus'),
('fa-plus'),
('fa-power'),
('fa-print'),
('fa-product'),
('fa-puzzle'),
('fa-qq'),
('fa-qrcode'),
('fa-question'),
('fa-question'),
('fa-question'),
('fa-quote'),
('fa-quote'),
('fa-ra'),
('fa-random'),
('fa-rebel'),
('fa-recycle'),
('fa-reddit'),
('fa-reddit'),
('fa-reddit'),
('fa-refresh'),
('fa-registered'),
('fa-remove'),
('fa-renren'),
('fa-reorder'),
('fa-repeat'),
('fa-reply'),
('fa-reply'),
('fa-resistance'),
('fa-retweet'),
('fa-rmb'),
('fa-road'),
('fa-rocket'),
('fa-rotate'),
('fa-rotate'),
('fa-rouble'),
('fa-rss'),
('fa-rss'),
('fa-rub'),
('fa-ruble'),
('fa-rupee'),
('fa-safari'),
('fa-save'),
('fa-scissors'),
('fa-scribd'),
('fa-search'),
('fa-search'),
('fa-search'),
('fa-sellsy'),
('fa-send'),
('fa-send'),
('fa-server'),
('fa-share'),
('fa-share'),
('fa-share'),
('fa-share'),
('fa-share'),
('fa-shekel'),
('fa-sheqel'),
('fa-shield'),
('fa-ship'),
('fa-shirtsinbulk'),
('fa-shopping'),
('fa-shopping'),
('fa-shopping'),
('fa-sign'),
('fa-sign'),
('fa-sign'),
('fa-signal'),
('fa-signing'),
('fa-simplybuilt'),
('fa-sitemap'),
('fa-skyatlas'),
('fa-skype'),
('fa-slack'),
('fa-sliders'),
('fa-slideshare'),
('fa-smile'),
('fa-snapchat'),
('fa-snapchat'),
('fa-snapchat'),
('fa-soccer'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-sort'),
('fa-soundcloud'),
('fa-space'),
('fa-spinner'),
('fa-spoon'),
('fa-spotify'),
('fa-square'),
('fa-square'),
('fa-stack'),
('fa-stack'),
('fa-star'),
('fa-star'),
('fa-star'),
('fa-star'),
('fa-star'),
('fa-star'),
('fa-steam'),
('fa-steam'),
('fa-step'),
('fa-step'),
('fa-stethoscope'),
('fa-sticky'),
('fa-sticky'),
('fa-stop'),
('fa-stop'),
('fa-stop'),
('fa-street'),
('fa-strikethrough'),
('fa-stumbleupon'),
('fa-stumbleupon'),
('fa-subscript'),
('fa-subway'),
('fa-suitcase'),
('fa-sun'),
('fa-superscript'),
('fa-support'),
('fa-table'),
('fa-tablet'),
('fa-tachometer'),
('fa-tag'),
('fa-tags'),
('fa-tasks'),
('fa-taxi'),
('fa-television'),
('fa-tencent'),
('fa-terminal'),
('fa-text'),
('fa-text'),
('fa-th'),
('fa-th'),
('fa-th'),
('fa-themeisle'),
('fa-thumb'),
('fa-thumbs'),
('fa-thumbs'),
('fa-thumbs'),
('fa-thumbs'),
('fa-ticket'),
('fa-times'),
('fa-times'),
('fa-times'),
('fa-tint'),
('fa-toggle'),
('fa-toggle'),
('fa-toggle'),
('fa-toggle'),
('fa-toggle'),
('fa-toggle'),
('fa-trademark'),
('fa-train'),
('fa-transgender'),
('fa-transgender'),
('fa-trash'),
('fa-trash'),
('fa-tree'),
('fa-trello'),
('fa-tripadvisor'),
('fa-trophy'),
('fa-truck'),
('fa-try'),
('fa-tty'),
('fa-tumblr'),
('fa-tumblr'),
('fa-turkish'),
('fa-tv'),
('fa-twitch'),
('fa-twitter'),
('fa-twitter'),
('fa-umbrella'),
('fa-underline'),
('fa-undo'),
('fa-universal'),
('fa-university'),
('fa-unlink'),
('fa-unlock'),
('fa-unlock'),
('fa-unsorted'),
('fa-upload'),
('fa-usb'),
('fa-usd'),
('fa-user'),
('fa-user'),
('fa-user'),
('fa-user'),
('fa-user'),
('fa-users'),
('fa-venus'),
('fa-venus'),
('fa-venus'),
('fa-viacoin'),
('fa-viadeo'),
('fa-viadeo'),
('fa-video'),
('fa-vimeo'),
('fa-vimeo'),
('fa-vine'),
('fa-vk'),
('fa-volume'),
('fa-volume'),
('fa-volume'),
('fa-volume'),
('fa-warning'),
('fa-wechat'),
('fa-weibo'),
('fa-weixin'),
('fa-whatsapp'),
('fa-wheelchair'),
('fa-wheelchair'),
('fa-wifi'),
('fa-wikipedia'),
('fa-windows'),
('fa-won'),
('fa-wordpress'),
('fa-wpbeginner'),
('fa-wpforms'),
('fa-wrench'),
('fa-xing'),
('fa-xing'),
('fa-y'),
('fa-y'),
('fa-yahoo'),
('fa-yc'),
('fa-yc'),
('fa-yelp'),
('fa-yen'),
('fa-yoast'),
('fa-youtube'),
('fa-youtube'),
('fa-youtube'),
('fa-balance-scale'),
('fa-battery-0'),
('fa-battery-1'),
('fa-battery-2'),
('fa-battery-3'),
('fa-battery-4'),
('fa-battery-empty'),
('fa-battery-full'),
('fa-battery-half'),
('fa-battery-quarter'),
('fa-battery-three'),
('fa-black-tie'),
('fa-calendar-check'),
('fa-calendar-minus'),
('fa-calendar-plus'),
('fa-calendar-times'),
('fa-cc-diners'),
('fa-cc-jcb'),
('fa-commenting-o'),
('fa-creative-commons'),
('fa-get-pocket'),
('fa-gg-circle'),
('fa-hand-grab'),
('fa-hand-lizard'),
('fa-hand-paper'),
('fa-hand-peace'),
('fa-hand-pointer'),
('fa-hand-rock'),
('fa-hand-scissors'),
('fa-hand-spock'),
('fa-hand-stop'),
('fa-hourglass-1'),
('fa-hourglass-2'),
('fa-hourglass-3'),
('fa-hourglass-end'),
('fa-hourglass-half'),
('fa-hourglass-o'),
('fa-hourglass-start'),
('fa-i-cursor'),
('fa-internet-explorer'),
('fa-map-o'),
('fa-map-pin'),
('fa-map-signs'),
('fa-mouse-pointer'),
('fa-object-group'),
('fa-object-ungroup'),
('fa-odnoklassniki-square'),
('fa-optin-monster'),
('fa-sticky-note'),
('fa-sticky-note'),
('fa-wikipedia-w'),
('fa-y-combinator'),
('fa-area-chart'),
('fa-arrows-h'),
('fa-arrows-v'),
('fa-balance-scale'),
('fa-bar-chart'),
('fa-bar-chart'),
('fa-battery-0'),
('fa-battery-1'),
('fa-battery-2'),
('fa-battery-3'),
('fa-battery-4'),
('fa-battery-empty'),
('fa-battery-full'),
('fa-battery-half'),
('fa-battery-quarter'),
('fa-battery-three'),
('fa-bell-o'),
('fa-bell-slash'),
('fa-bell-slash'),
('fa-birthday-cake'),
('fa-bookmark-o'),
('fa-building-o'),
('fa-calendar-check'),
('fa-calendar-minus'),
('fa-calendar-o'),
('fa-calendar-plus'),
('fa-calendar-times'),
('fa-camera-retro'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-square'),
('fa-cart-arrow'),
('fa-cart-plus'),
('fa-check-circle'),
('fa-check-circle'),
('fa-check-square'),
('fa-check-square'),
('fa-circle-o'),
('fa-circle-o'),
('fa-circle-thin'),
('fa-clock-o'),
('fa-cloud-download'),
('fa-cloud-upload'),
('fa-code-fork'),
('fa-comment-o'),
('fa-commenting-o'),
('fa-comments-o'),
('fa-creative-commons'),
('fa-credit-card'),
('fa-dot-circle'),
('fa-ellipsis-h'),
('fa-ellipsis-v'),
('fa-envelope-o'),
('fa-envelope-square'),
('fa-exclamation-circle'),
('fa-exclamation-triangle'),
('fa-external-link'),
('fa-external-link'),
('fa-eye-slash'),
('fa-fighter-jet'),
('fa-file-archive'),
('fa-file-audio'),
('fa-file-code'),
('fa-file-excel'),
('fa-file-image'),
('fa-file-movie'),
('fa-file-pdf'),
('fa-file-photo'),
('fa-file-picture'),
('fa-file-powerpoint'),
('fa-file-sound'),
('fa-file-video'),
('fa-file-word'),
('fa-file-zip'),
('fa-fire-extinguisher'),
('fa-flag-checkered'),
('fa-flag-o'),
('fa-folder-o'),
('fa-folder-open'),
('fa-folder-open'),
('fa-frown-o'),
('fa-futbol-o'),
('fa-graduation-cap'),
('fa-hand-grab'),
('fa-hand-lizard'),
('fa-hand-paper'),
('fa-hand-peace'),
('fa-hand-pointer'),
('fa-hand-rock'),
('fa-hand-scissors'),
('fa-hand-spock'),
('fa-hand-stop'),
('fa-hdd-o'),
('fa-heart-o'),
('fa-hourglass-1'),
('fa-hourglass-2'),
('fa-hourglass-3'),
('fa-hourglass-end'),
('fa-hourglass-half'),
('fa-hourglass-o'),
('fa-hourglass-start'),
('fa-i-cursor'),
('fa-info-circle'),
('fa-keyboard-o'),
('fa-lemon-o'),
('fa-level-down'),
('fa-level-up'),
('fa-life-bouy'),
('fa-life-buoy'),
('fa-life-ring'),
('fa-life-saver'),
('fa-lightbulb-o'),
('fa-line-chart'),
('fa-location-arrow'),
('fa-mail-forward'),
('fa-mail-reply'),
('fa-mail-reply'),
('fa-map-marker'),
('fa-map-o'),
('fa-map-pin'),
('fa-map-signs'),
('fa-meh-o'),
('fa-microphone-slash'),
('fa-minus-circle'),
('fa-minus-square'),
('fa-minus-square'),
('fa-mobile-phone'),
('fa-moon-o'),
('fa-mortar-board'),
('fa-mouse-pointer'),
('fa-newspaper-o'),
('fa-object-group'),
('fa-object-ungroup'),
('fa-paint-brush'),
('fa-paper-plane'),
('fa-paper-plane'),
('fa-pencil-square'),
('fa-pencil-square'),
('fa-phone-square'),
('fa-picture-o'),
('fa-pie-chart'),
('fa-plus-circle'),
('fa-plus-square'),
('fa-plus-square'),
('fa-power-off'),
('fa-puzzle-piece'),
('fa-question-circle'),
('fa-quote-left'),
('fa-quote-right'),
('fa-reply-all'),
('fa-rss-square'),
('fa-search-minus'),
('fa-search-plus'),
('fa-send-o'),
('fa-share-alt'),
('fa-share-alt'),
('fa-share-square'),
('fa-share-square'),
('fa-shopping-cart'),
('fa-sign-in'),
('fa-sign-out'),
('fa-smile-o'),
('fa-soccer-ball'),
('fa-sort-alpha'),
('fa-sort-alpha'),
('fa-sort-amount'),
('fa-sort-amount'),
('fa-sort-asc'),
('fa-sort-desc'),
('fa-sort-down'),
('fa-sort-numeric'),
('fa-sort-numeric'),
('fa-sort-up'),
('fa-space-shuttle'),
('fa-square-o'),
('fa-star-half'),
('fa-star-half'),
('fa-star-half'),
('fa-star-half'),
('fa-star-o'),
('fa-sticky-note'),
('fa-sticky-note'),
('fa-street-view'),
('fa-sun-o'),
('fa-thumb-tack'),
('fa-thumbs-down'),
('fa-thumbs-o'),
('fa-thumbs-o'),
('fa-thumbs-up'),
('fa-times-circle'),
('fa-times-circle'),
('fa-toggle-down'),
('fa-toggle-left'),
('fa-toggle-off'),
('fa-toggle-on'),
('fa-toggle-right'),
('fa-toggle-up'),
('fa-trash-o'),
('fa-unlock-alt'),
('fa-user-plus'),
('fa-user-secret'),
('fa-user-times'),
('fa-video-camera'),
('fa-volume-down'),
('fa-volume-off'),
('fa-volume-up'),
('fa-hand-grab'),
('fa-hand-lizard'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-paper'),
('fa-hand-peace'),
('fa-hand-pointer'),
('fa-hand-rock'),
('fa-hand-scissors'),
('fa-hand-spock'),
('fa-hand-stop'),
('fa-thumbs-down'),
('fa-thumbs-o'),
('fa-thumbs-o'),
('fa-thumbs-up'),
('fa-fighter-jet'),
('fa-space-shuttle'),
('fa-mars-double'),
('fa-mars-stroke'),
('fa-mars-stroke'),
('fa-mars-stroke'),
('fa-transgender-alt'),
('fa-venus-double'),
('fa-venus-mars'),
('fa-file-archive'),
('fa-file-audio'),
('fa-file-code'),
('fa-file-excel'),
('fa-file-image'),
('fa-file-movie'),
('fa-file-o'),
('fa-file-pdf'),
('fa-file-photo'),
('fa-file-picture'),
('fa-file-powerpoint'),
('fa-file-sound'),
('fa-file-text'),
('fa-file-text'),
('fa-file-video'),
('fa-file-word'),
('fa-file-zip'),
('fa-circle-o'),
('fa-check-square'),
('fa-check-square'),
('fa-circle-o'),
('fa-dot-circle'),
('fa-minus-square'),
('fa-minus-square'),
('fa-plus-square'),
('fa-plus-square'),
('fa-square-o'),
('fa-cc-amex'),
('fa-cc-diners'),
('fa-cc-discover'),
('fa-cc-jcb'),
('fa-cc-mastercard'),
('fa-cc-paypal'),
('fa-cc-stripe'),
('fa-cc-visa'),
('fa-credit-card'),
('fa-google-wallet'),
('fa-area-chart'),
('fa-bar-chart'),
('fa-bar-chart'),
('fa-line-chart'),
('fa-pie-chart'),
('fa-gg-circle'),
('fa-turkish-lira'),
('fa-align-center'),
('fa-align-justify'),
('fa-align-left'),
('fa-align-right'),
('fa-chain-broken'),
('fa-file-o'),
('fa-file-text'),
('fa-file-text'),
('fa-files-o'),
('fa-floppy-o'),
('fa-list-alt'),
('fa-list-ol'),
('fa-list-ul'),
('fa-rotate-left'),
('fa-rotate-right'),
('fa-text-height'),
('fa-text-width'),
('fa-th-large'),
('fa-th-list'),
('fa-angle-double'),
('fa-angle-double'),
('fa-angle-double'),
('fa-angle-double'),
('fa-angle-down'),
('fa-angle-left'),
('fa-angle-right'),
('fa-angle-up'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-down'),
('fa-arrow-left'),
('fa-arrow-right'),
('fa-arrow-up'),
('fa-arrows-alt'),
('fa-arrows-h'),
('fa-arrows-v'),
('fa-caret-down'),
('fa-caret-left'),
('fa-caret-right'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-up'),
('fa-chevron-circle'),
('fa-chevron-circle'),
('fa-chevron-circle'),
('fa-chevron-circle'),
('fa-chevron-down'),
('fa-chevron-left'),
('fa-chevron-right'),
('fa-chevron-up'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-o'),
('fa-long-arrow'),
('fa-long-arrow'),
('fa-long-arrow'),
('fa-long-arrow'),
('fa-toggle-down'),
('fa-toggle-left'),
('fa-toggle-right'),
('fa-toggle-up'),
('fa-arrows-alt'),
('fa-fast-backward'),
('fa-fast-forward'),
('fa-play-circle'),
('fa-play-circle'),
('fa-step-backward'),
('fa-step-forward'),
('fa-youtube-play'),
('fa-behance-square'),
('fa-bitbucket-square'),
('fa-black-tie'),
('fa-cc-amex'),
('fa-cc-diners'),
('fa-cc-discover'),
('fa-cc-jcb'),
('fa-cc-mastercard'),
('fa-cc-paypal'),
('fa-cc-stripe'),
('fa-cc-visa'),
('fa-facebook-f'),
('fa-facebook-official'),
('fa-facebook-square'),
('fa-get-pocket'),
('fa-gg-circle'),
('fa-git-square'),
('fa-github-alt'),
('fa-github-square'),
('fa-google-plus'),
('fa-google-plus'),
('fa-google-wallet'),
('fa-hacker-news'),
('fa-internet-explorer'),
('fa-lastfm-square'),
('fa-linkedin-square'),
('fa-odnoklassniki-square'),
('fa-optin-monster'),
('fa-pied-piper'),
('fa-pied-piper'),
('fa-pinterest-p'),
('fa-pinterest-square'),
('fa-reddit-square'),
('fa-share-alt'),
('fa-share-alt'),
('fa-stack-exchange'),
('fa-stack-overflow'),
('fa-steam-square'),
('fa-stumbleupon-circle'),
('fa-tencent-weibo'),
('fa-tumblr-square'),
('fa-twitter-square'),
('fa-vimeo-square'),
('fa-wikipedia-w'),
('fa-xing-square'),
('fa-y-combinator'),
('fa-y-combinator'),
('fa-yc-square'),
('fa-youtube-play'),
('fa-youtube-square'),
('fa-h-square'),
('fa-heart-o'),
('fa-hospital-o'),
('fa-plus-square'),
('fa-user-md'),
('fa-balance-scale'),
('fa-battery-0'),
('fa-battery-1'),
('fa-battery-2'),
('fa-battery-3'),
('fa-battery-4'),
('fa-battery-empty'),
('fa-battery-full'),
('fa-battery-half'),
('fa-battery-quarter'),
('fa-battery-three'),
('fa-black-tie'),
('fa-calendar-check'),
('fa-calendar-minus'),
('fa-calendar-plus'),
('fa-calendar-times'),
('fa-cc-diners'),
('fa-cc-jcb'),
('fa-commenting-o'),
('fa-creative-commons'),
('fa-get-pocket'),
('fa-gg-circle'),
('fa-hand-grab'),
('fa-hand-lizard'),
('fa-hand-paper'),
('fa-hand-peace'),
('fa-hand-pointer'),
('fa-hand-rock'),
('fa-hand-scissors'),
('fa-hand-spock'),
('fa-hand-stop'),
('fa-hourglass-1'),
('fa-hourglass-2'),
('fa-hourglass-3'),
('fa-hourglass-end'),
('fa-hourglass-half'),
('fa-hourglass-o'),
('fa-hourglass-start'),
('fa-i-cursor'),
('fa-internet-explorer'),
('fa-map-o'),
('fa-map-pin'),
('fa-map-signs'),
('fa-mouse-pointer'),
('fa-object-group'),
('fa-object-ungroup'),
('fa-odnoklassniki-square'),
('fa-optin-monster'),
('fa-sticky-note'),
('fa-sticky-note'),
('fa-wikipedia-w'),
('fa-y-combinator'),
('fa-area-chart'),
('fa-arrows-h'),
('fa-arrows-v'),
('fa-balance-scale'),
('fa-bar-chart'),
('fa-bar-chart'),
('fa-battery-0'),
('fa-battery-1'),
('fa-battery-2'),
('fa-battery-3'),
('fa-battery-4'),
('fa-battery-empty'),
('fa-battery-full'),
('fa-battery-half'),
('fa-battery-quarter'),
('fa-battery-three'),
('fa-bell-o'),
('fa-bell-slash'),
('fa-bell-slash'),
('fa-birthday-cake'),
('fa-bookmark-o'),
('fa-building-o'),
('fa-calendar-check'),
('fa-calendar-minus'),
('fa-calendar-o'),
('fa-calendar-plus'),
('fa-calendar-times'),
('fa-camera-retro'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-square'),
('fa-cart-arrow'),
('fa-cart-plus'),
('fa-check-circle'),
('fa-check-circle'),
('fa-check-square'),
('fa-check-square'),
('fa-circle-o'),
('fa-circle-o'),
('fa-circle-thin'),
('fa-clock-o'),
('fa-cloud-download'),
('fa-cloud-upload'),
('fa-code-fork'),
('fa-comment-o'),
('fa-commenting-o'),
('fa-comments-o'),
('fa-creative-commons'),
('fa-credit-card'),
('fa-dot-circle'),
('fa-ellipsis-h'),
('fa-ellipsis-v'),
('fa-envelope-o'),
('fa-envelope-square'),
('fa-exclamation-circle'),
('fa-exclamation-triangle'),
('fa-external-link'),
('fa-external-link'),
('fa-eye-slash'),
('fa-fighter-jet'),
('fa-file-archive'),
('fa-file-audio'),
('fa-file-code'),
('fa-file-excel'),
('fa-file-image'),
('fa-file-movie'),
('fa-file-pdf'),
('fa-file-photo'),
('fa-file-picture'),
('fa-file-powerpoint'),
('fa-file-sound'),
('fa-file-video'),
('fa-file-word'),
('fa-file-zip'),
('fa-fire-extinguisher'),
('fa-flag-checkered'),
('fa-flag-o'),
('fa-folder-o'),
('fa-folder-open'),
('fa-folder-open'),
('fa-frown-o'),
('fa-futbol-o'),
('fa-graduation-cap'),
('fa-hand-grab'),
('fa-hand-lizard'),
('fa-hand-paper'),
('fa-hand-peace'),
('fa-hand-pointer'),
('fa-hand-rock'),
('fa-hand-scissors'),
('fa-hand-spock'),
('fa-hand-stop'),
('fa-hdd-o'),
('fa-heart-o'),
('fa-hourglass-1'),
('fa-hourglass-2'),
('fa-hourglass-3'),
('fa-hourglass-end'),
('fa-hourglass-half'),
('fa-hourglass-o'),
('fa-hourglass-start'),
('fa-i-cursor'),
('fa-info-circle'),
('fa-keyboard-o'),
('fa-lemon-o'),
('fa-level-down'),
('fa-level-up'),
('fa-life-bouy'),
('fa-life-buoy'),
('fa-life-ring'),
('fa-life-saver'),
('fa-lightbulb-o'),
('fa-line-chart'),
('fa-location-arrow'),
('fa-mail-forward'),
('fa-mail-reply'),
('fa-mail-reply'),
('fa-map-marker'),
('fa-map-o'),
('fa-map-pin'),
('fa-map-signs'),
('fa-meh-o'),
('fa-microphone-slash'),
('fa-minus-circle'),
('fa-minus-square'),
('fa-minus-square'),
('fa-mobile-phone'),
('fa-moon-o'),
('fa-mortar-board'),
('fa-mouse-pointer'),
('fa-newspaper-o'),
('fa-object-group'),
('fa-object-ungroup'),
('fa-paint-brush'),
('fa-paper-plane'),
('fa-paper-plane'),
('fa-pencil-square'),
('fa-pencil-square'),
('fa-phone-square'),
('fa-picture-o'),
('fa-pie-chart'),
('fa-plus-circle'),
('fa-plus-square'),
('fa-plus-square'),
('fa-power-off'),
('fa-puzzle-piece'),
('fa-question-circle'),
('fa-quote-left'),
('fa-quote-right'),
('fa-reply-all'),
('fa-rss-square'),
('fa-search-minus'),
('fa-search-plus'),
('fa-send-o'),
('fa-share-alt'),
('fa-share-alt'),
('fa-share-square'),
('fa-share-square'),
('fa-shopping-cart'),
('fa-sign-in'),
('fa-sign-out'),
('fa-smile-o'),
('fa-soccer-ball'),
('fa-sort-alpha'),
('fa-sort-alpha'),
('fa-sort-amount'),
('fa-sort-amount'),
('fa-sort-asc'),
('fa-sort-desc'),
('fa-sort-down'),
('fa-sort-numeric'),
('fa-sort-numeric'),
('fa-sort-up'),
('fa-space-shuttle'),
('fa-square-o'),
('fa-star-half'),
('fa-star-half'),
('fa-star-half'),
('fa-star-half'),
('fa-star-o'),
('fa-sticky-note'),
('fa-sticky-note'),
('fa-street-view'),
('fa-sun-o'),
('fa-thumb-tack'),
('fa-thumbs-down'),
('fa-thumbs-o'),
('fa-thumbs-o'),
('fa-thumbs-up'),
('fa-times-circle'),
('fa-times-circle'),
('fa-toggle-down'),
('fa-toggle-left'),
('fa-toggle-off'),
('fa-toggle-on'),
('fa-toggle-right'),
('fa-toggle-up'),
('fa-trash-o'),
('fa-unlock-alt'),
('fa-user-plus'),
('fa-user-secret'),
('fa-user-times'),
('fa-video-camera'),
('fa-volume-down'),
('fa-volume-off'),
('fa-volume-up'),
('fa-hand-grab'),
('fa-hand-lizard'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-paper'),
('fa-hand-peace'),
('fa-hand-pointer'),
('fa-hand-rock'),
('fa-hand-scissors'),
('fa-hand-spock'),
('fa-hand-stop'),
('fa-thumbs-down'),
('fa-thumbs-o'),
('fa-thumbs-o'),
('fa-thumbs-up'),
('fa-fighter-jet'),
('fa-space-shuttle'),
('fa-mars-double'),
('fa-mars-stroke'),
('fa-mars-stroke'),
('fa-mars-stroke'),
('fa-transgender-alt'),
('fa-venus-double'),
('fa-venus-mars'),
('fa-file-archive'),
('fa-file-audio'),
('fa-file-code'),
('fa-file-excel'),
('fa-file-image'),
('fa-file-movie'),
('fa-file-o'),
('fa-file-pdf'),
('fa-file-photo'),
('fa-file-picture'),
('fa-file-powerpoint'),
('fa-file-sound'),
('fa-file-text'),
('fa-file-text'),
('fa-file-video'),
('fa-file-word'),
('fa-file-zip'),
('fa-circle-o'),
('fa-check-square'),
('fa-check-square'),
('fa-circle-o'),
('fa-dot-circle'),
('fa-minus-square'),
('fa-minus-square'),
('fa-plus-square'),
('fa-plus-square'),
('fa-square-o'),
('fa-cc-amex'),
('fa-cc-diners'),
('fa-cc-discover'),
('fa-cc-jcb'),
('fa-cc-mastercard'),
('fa-cc-paypal'),
('fa-cc-stripe'),
('fa-cc-visa'),
('fa-credit-card'),
('fa-google-wallet'),
('fa-area-chart'),
('fa-bar-chart'),
('fa-bar-chart'),
('fa-line-chart'),
('fa-pie-chart'),
('fa-gg-circle'),
('fa-turkish-lira'),
('fa-align-center'),
('fa-align-justify'),
('fa-align-left'),
('fa-align-right'),
('fa-chain-broken'),
('fa-file-o'),
('fa-file-text'),
('fa-file-text'),
('fa-files-o'),
('fa-floppy-o'),
('fa-list-alt'),
('fa-list-ol'),
('fa-list-ul'),
('fa-rotate-left'),
('fa-rotate-right'),
('fa-text-height'),
('fa-text-width'),
('fa-th-large'),
('fa-th-list'),
('fa-angle-double'),
('fa-angle-double'),
('fa-angle-double'),
('fa-angle-double'),
('fa-angle-down'),
('fa-angle-left'),
('fa-angle-right'),
('fa-angle-up'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-circle'),
('fa-arrow-down'),
('fa-arrow-left'),
('fa-arrow-right'),
('fa-arrow-up'),
('fa-arrows-alt'),
('fa-arrows-h'),
('fa-arrows-v'),
('fa-caret-down'),
('fa-caret-left'),
('fa-caret-right'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-square'),
('fa-caret-up'),
('fa-chevron-circle'),
('fa-chevron-circle'),
('fa-chevron-circle'),
('fa-chevron-circle'),
('fa-chevron-down'),
('fa-chevron-left'),
('fa-chevron-right'),
('fa-chevron-up'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-o'),
('fa-hand-o'),
('fa-long-arrow'),
('fa-long-arrow'),
('fa-long-arrow'),
('fa-long-arrow'),
('fa-toggle-down'),
('fa-toggle-left'),
('fa-toggle-right'),
('fa-toggle-up'),
('fa-arrows-alt'),
('fa-fast-backward'),
('fa-fast-forward'),
('fa-play-circle'),
('fa-play-circle'),
('fa-step-backward'),
('fa-step-forward'),
('fa-youtube-play'),
('fa-behance-square'),
('fa-bitbucket-square'),
('fa-black-tie'),
('fa-cc-amex'),
('fa-cc-diners'),
('fa-cc-discover'),
('fa-cc-jcb'),
('fa-cc-mastercard'),
('fa-cc-paypal'),
('fa-cc-stripe'),
('fa-cc-visa'),
('fa-facebook-f'),
('fa-facebook-official'),
('fa-facebook-square'),
('fa-get-pocket'),
('fa-gg-circle'),
('fa-git-square'),
('fa-github-alt'),
('fa-github-square'),
('fa-google-plus'),
('fa-google-plus'),
('fa-google-wallet'),
('fa-hacker-news'),
('fa-internet-explorer'),
('fa-lastfm-square'),
('fa-linkedin-square'),
('fa-odnoklassniki-square'),
('fa-optin-monster'),
('fa-pied-piper'),
('fa-pied-piper'),
('fa-pinterest-p'),
('fa-pinterest-square'),
('fa-reddit-square'),
('fa-share-alt'),
('fa-share-alt'),
('fa-stack-exchange'),
('fa-stack-overflow'),
('fa-steam-square'),
('fa-stumbleupon-circle'),
('fa-tencent-weibo'),
('fa-tumblr-square'),
('fa-twitter-square'),
('fa-vimeo-square'),
('fa-wikipedia-w'),
('fa-xing-square'),
('fa-y-combinator'),
('fa-y-combinator'),
('fa-yc-square'),
('fa-youtube-play'),
('fa-youtube-square'),
('fa-h-square'),
('fa-heart-o'),
('fa-hospital-o'),
('fa-plus-square'),
('fa-user-md');

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

--
-- Table structure for table `menu_type`
--

CREATE TABLE `menu_type` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `definition` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `menu_type`
--

INSERT INTO `menu_type` (`id`, `name`, `definition`) VALUES
(1, 'side menu', NULL),
(2, 'top menu', NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `version` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`version`) VALUES
(1);

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

--
-- Table structure for table `mutasi`
--

CREATE TABLE `mutasi` (
  `id_mutasi` int(11) NOT NULL,
  `id_penempatan` varchar(100) NOT NULL,
  `tanggal_mutasi` date NOT NULL,
  `keterangan` text NOT NULL,
  `departemen` varchar(100) NOT NULL,
  `lokasi` varchar(100) NOT NULL,
  `nama_barang` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mutasi`
--

INSERT INTO `mutasi` (`id_mutasi`, `id_penempatan`, `tanggal_mutasi`, `keterangan`, `departemen`, `lokasi`, `nama_barang`) VALUES
(1, 'Ruang Ketua', '2023-02-08', 'Rusak Masuk Gudang', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Gudang', 'Printer Color LaserJet Pro MFP M177fw'),
(2, 'Ruang Sekretariat', '2023-02-08', 'Rusak Masuk Gudang', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Gudang', 'Printer Color LaserJet Pro MFP M177fw'),
(3, 'Ruang Administrasi Pendidikan', '2023-02-08', 'Rusak masuk gudang', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Gudang', 'Printer Epson TX220'),
(4, 'Ruang Rm Frans', '2023-02-08', 'Router Rusak taruh di gudang', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Gudang', 'Router'),
(5, 'Ruang Sekretariat', '2016-02-26', 'Barang Rusak sejak Tahun 2016', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Gudang', 'UPS Stabilize Smart 750 VA'),
(6, 'Ruang Komputer / Lab Komputer', '2022-02-20', 'Ruang Keuangan', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Bendahara dan Keuangan', 'PC Lenovo E72'),
(7, 'Ruang Komputer / Lab Komputer', '2019-02-18', 'Di Pinjam Pakai Di SMAK St. Aloysius Palangka Raya', 'SMAK St. Aloysius Palangka Raya', 'SMAK st. Aloysius', 'PC Lenovo E72');

--
-- Triggers `mutasi`
--
DELIMITER $$
CREATE TRIGGER `keterangan_mutasi` AFTER INSERT ON `mutasi` FOR EACH ROW BEGIN
	UPDATE penempatan SET keterangan = keterangan = NEW.keterangan
	WHERE id_penempatan = NEW.id_penempatan;
END
$$
DELIMITER ;

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

--
-- Table structure for table `page`
--

CREATE TABLE `page` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `type` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `fresh_content` text NOT NULL,
  `keyword` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `link` varchar(200) DEFAULT NULL,
  `template` varchar(200) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`id`, `title`, `type`, `content`, `fresh_content`, `keyword`, `description`, `link`, `template`, `created_at`) VALUES
(1, 'home', 'frontend', '<cc-element cc-id=\"style\">\n    <link data-src=\"stylesheet-bootstrap\" href=\"http://localhost:80/pinjam/cc-content/page-element/portofolio\\/package/vendor/bootstrap/css/bootstrap.min.css\" rel=\"stylesheet\">\n    <link data-src=\"stylesheet-freelancer\" href=\"http://localhost:80/pinjam/cc-content/page-element/portofolio\\/package/css/freelancer.min.css\" rel=\"stylesheet\">\n    <link data-src=\"stylesheet-font-awesome\" href=\"http://localhost:80/pinjam/cc-content/page-element/portofolio\\/package/vendor/font-awesome/css/font-awesome.min.css\" rel=\"stylesheet\" type=\"text/css\">\n    <link data-src=\"stylesheet-bootstrap\" href=\"https://fonts.googleapis.com/css?family=Montserrat:400,700\" rel=\"stylesheet\" type=\"text/css\">\n    <link data-src=\"stylesheet-bootstrap\" href=\"https://fonts.googleapis.com/css?family=Lato:400,700,400italic,700italic\" rel=\"stylesheet\" type=\"text/css\">\n</cc-element>\n\n<cc-element cc-id=\"content\">\n    <header class=\"free-header\" style=\"\">\n        </header></cc-element>', '\n                                    \n                                    \n                                    \n                                    \n                                    \n                                    \n                                    \n                                                                                                                                                      <li class=\"block-item ui-draggable ui-draggable-handle block-item-loaded\" data-src=\"portofolio\\/header.php\" data-block-name=\"portofolio\\\" style=\"width: 200px; right: auto; height: 107px; bottom: auto; display: list-item;\">\n				                <div class=\"nav-content-wrapper noselect ui-sortable\">\n				                  <i class=\"fa fa-gear\"></i>\n				                  <div class=\"tool-nav delete ui-sortable\">\n				                    <i class=\"fa fa-trash\"></i> <span class=\"info-nav\">Delete</span>\n				                  </div>\n				                  <div class=\"tool-nav source ui-sortable\">\n				                    <i class=\"fa fa-code\"></i> <span class=\"info-nav\">Source</span>\n				                  </div>\n				                  <div class=\"tool-nav copy ui-sortable\">\n				                    <i class=\"fa fa-copy\"></i> <span class=\"info-nav\">Copy</span>\n				                  </div>\n				                  <div class=\"tool-nav handle ui-sortable ui-sortable-handle\">\n				                    <i class=\"fa fa-arrows\"></i> <span class=\"info-nav\">Move</span>\n				                  </div>\n				                </div>\n				              \n				              <div class=\"block-content editable ui-sortable\"><cc-element cc-id=\"style\">\n    <link data-src=\"stylesheet-bootstrap\" href=\"http://localhost:80/pinjam/cc-content/page-element/portofolio\\/package/vendor/bootstrap/css/bootstrap.min.css\" rel=\"stylesheet\">\n    <link data-src=\"stylesheet-freelancer\" href=\"http://localhost:80/pinjam/cc-content/page-element/portofolio\\/package/css/freelancer.min.css\" rel=\"stylesheet\">\n    <link data-src=\"stylesheet-font-awesome\" href=\"http://localhost:80/pinjam/cc-content/page-element/portofolio\\/package/vendor/font-awesome/css/font-awesome.min.css\" rel=\"stylesheet\" type=\"text/css\">\n    <link data-src=\"stylesheet-bootstrap\" href=\"https://fonts.googleapis.com/css?family=Montserrat:400,700\" rel=\"stylesheet\" type=\"text/css\">\n    <link data-src=\"stylesheet-bootstrap\" href=\"https://fonts.googleapis.com/css?family=Lato:400,700,400italic,700italic\" rel=\"stylesheet\" type=\"text/css\">\n</cc-element>\n\n<cc-element cc-id=\"content\">\n    <header class=\"free-header\" style=\"\">\n        </header></cc-element></div></li>                                                                                                                                                 ', '', '', 'home', 'default', '2019-01-05 01:08:34');

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

--
-- Table structure for table `page_block_element`
--

CREATE TABLE `page_block_element` (
  `id` int(11) UNSIGNED NOT NULL,
  `group_name` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `image_preview` varchar(200) NOT NULL,
  `block_name` varchar(200) NOT NULL,
  `content_type` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `penempatan`
--

CREATE TABLE `penempatan` (
  `id_penempatan` int(11) NOT NULL,
  `tanggal_penempatan` date NOT NULL,
  `departemen` varchar(100) NOT NULL,
  `lokasi` varchar(100) NOT NULL,
  `keterangan` text NOT NULL,
  `nama_barang` varchar(100) NOT NULL,
  `jumlah` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `penempatan`
--

INSERT INTO `penempatan` (`id_penempatan`, `tanggal_penempatan`, `departemen`, `lokasi`, `keterangan`, `nama_barang`, `jumlah`) VALUES
(14, '2014-07-10', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'No.&nbsp;', 'Komputer Dell Optiplex 3011 AIO', 1),
(15, '2014-06-18', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Ketua', 'Nomor :', 'Komputer Dell Optiplex 3011 AIO', 1),
(16, '2010-11-10', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Bantuan BOP 2010 Bimas Katolik', 'Kamera DSLR Nikon D90', 1),
(17, '2014-12-12', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Ketua', 'Bantuan Pemda Kalteng Tahun 2014<br />\r\nKondisi Rusak', 'Printer Color LaserJet Pro MFP M177fw', 1),
(18, '2014-12-12', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Bantuan Pemda Kalteng Tahun 2014<br />\r\n<br />\r\nKondisi Rusak', 'Printer Color LaserJet Pro MFP M177fw', 1),
(20, '2018-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Bantuan Sarpras 2018 Bimas Katolik', 'UPS APC SMC1500I', 1),
(21, '2017-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Ketua', 'Bantuan Sarpras dari Bimas Katolik Tahun 2017', 'AC LG 2PK', 1),
(22, '2010-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', '20/MEJ/2011', 'Kursi Putar Tiger', 2),
(23, '2003-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', '23/KOM/2011', 'Jam Dinding Mirado', 1),
(24, '2010-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah I', 'Sarpras Bimas 2017', 'LCD SONY VPL-DX211', 1),
(25, '2017-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah II', 'Sarpras Bimas Katolik 2017', 'LCD SONY VPL-DX211', 1),
(26, '2017-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah III', 'Sarpras Bimas Katolik Tahun 2017', 'LCD SONY VPL-DX211', 1),
(27, '2017-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah IV', 'Sarpras Bimas Katolik 2017', 'LCD SONY VPL-DX211', 1),
(32, '2015-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', 'Bantuan Pemda Kalimantan Tengah Tahun 2015', 'PC Lenovo E72', 18),
(33, '2015-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015', 'UPS ICA CT1082B 2000VA', 10),
(34, '2015-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015', 'Projektor Infocus 124 3200VA', 1),
(35, '2015-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Dosen', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015', 'Layar Proyektor dan Motor', 1),
(37, '2015-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015', 'Modem D-Link DIR 605L Cloud Router', 1),
(38, '2015-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015', 'Dongle Wifi Proyektor', 1),
(39, '2015-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015', 'Instalasi Komputer Lab', 1),
(40, '2013-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Perpustakaan', 'Bantuan Kota Palangkaraya Tahun 2013 Berita Acara&nbsp; Serah Terima Barang No. 02.1a/DP-CV/BASTB/PKY/IV/ 013 Tanggal 11/3/2013', 'PC HP Pavilion S5-1420 D-20 Inc', 1),
(41, '2013-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Perpustakaan', 'Dinas Pendidikan Propinsi Kalteng Tahun 2013 Nomor Kontrak 027/26/PNSP/I/2013 Tanggal 29 Januari 2013&nbsp; Kondisi Rusak', 'Epson Stylus Office T1100', 1),
(43, '2009-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Bantuan BOP Bimas Katolik Tahun 2009 ( Untuk Arsip Dokumen )', 'Lemari Kaca Alumunium', 1),
(44, '2009-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Bantuan BOP Bimas Katolik Tahun 2009 (Peralatan / perlengkapan Baju Wisuda)', 'Lemari Kaca Alumunium', 2),
(45, '2009-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Administrasi Pendidikan', 'Bantuan BOP Bimas Katolik Tahun 2009 (Arsip Dokumen)', 'Lemari Kaca Alumunium', 1),
(46, '2009-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Dosen', 'Bantuan BOP Bimas Katolik Tahun 2009 (Arsip Dokumen)', 'Lemari Kaca Alumunium', 1),
(47, '2011-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Administrasi Pendidikan', 'BOP 2011 (simpan dokumen)', 'Lemari Besi', 1),
(48, '2011-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'BOP 2011', 'Lemari Besi', 1),
(49, '2011-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Administrasi Pendidikan', 'Merek Royal Rusak', 'Lemari Arsip besi', 3),
(50, '2011-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Administrasi Pendidikan', 'Rusak Printernya yang digunakan hanya scanernya', 'Printer Epson TX220', 1),
(51, '2010-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Rusak Tonernya', 'Printer HP Laser Jet P1102', 1),
(52, '2011-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Administrasi Pendidikan', 'BOP 2011', 'HP Laser Jet P1005', 1),
(53, '2011-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Bendahara dan Keuangan', 'BOP 2011', 'Netbook Toshiba NB200', 1),
(54, '2018-01-11', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Dosen', 'Persiapan Reakreditasi 2018', 'AC LG Smart Inverter', 1),
(56, '2017-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Dosen', 'Tahun 2017', 'LCD Infokus R. Dosen', 1),
(58, '2011-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Dosen', 'BOP 2011', 'TV LCD LG 42', 1),
(60, '2014-09-20', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Ketua', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"697\">\r\n	<tbody>\r\n		<tr height=\"17\">\r\n			<td height=\"17\" width=\"105\">213/COM/2014</td>\r\n			<td width=\"344\">LAPTOP TOSHIBA SATELLITE M840-4D106381C</td>\r\n			<td width=\"248\">TOSHIBA (MERAH) M840 1034XP</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', 'Laptop Toshiba', 1),
(61, '2019-12-09', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Ketua Program Studi Pendidikan Dan Pengajaran Agama Katolik', 'Nomor Inventaris : 214/KOM/2014<br />\r\nSilvester Adinuhgra, S.S. M.Hum.<br />\r\n<img alt=\"\" src=\"https://drive.google.com/file/d/1BUsx2jJN7c2ErrkcYDQWhHb_3RNibzxj/view\" style=\"width: 100px; height: 50px;\" />', 'Laptop Toshiba', 1),
(62, '2021-10-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', '1 unit CCTV (DVR berada di Ruang Komputer 4 camera cctv terletak 2 didepan gedung, 1 di lorong lantai 1 dan 1 di belakang gedung)', 'CCTV', 1),
(63, '2021-10-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Web Cam di simpan di lemari Penyimpanan di Sekretariat', 'Web Cam', 1),
(64, '2021-11-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Rm Frans', 'Sebagai penguatan signal dari Asrama Putra STIPAS<br />\r\nRusak Tersambar Petir', 'Router', 1),
(65, '2021-12-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Luar Gedung STIPAS', 'Ditempatkan di Luar Gedung Lantai 2 Pada Pagar Luar', 'Akses Point Outdoor', 1),
(66, '2021-10-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Ditempatkan di atas dinding Ruang Sekretariat', 'Penguat Signal', 1),
(67, '2021-10-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', 'Diletakkan di Ruang Komputer 2 buat mengambil dari wifi asrama stipas dan dari wifi STIPAS', 'Penguat Signal', 2),
(68, '2021-10-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah IV', 'Ditempatkan di Ruang Kuliah IV Lantai 2', 'Penguat Signal', 1),
(69, '2021-10-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 2', 'Lantai 2 Dekat Tangga', 'Penguat Signal', 1),
(70, '2021-12-14', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', '', 'Kulkas Panasonic', 1),
(71, '2021-12-14', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', '', 'Scaner', 1),
(72, '2022-01-04', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Perpustakaan', 'Lengkap Set (Keyboard , Mouse dan Adaptor) Rusak Monitornya', 'Komputer Lenovo Ideacenter AIO330-20AST', 1),
(73, '2022-05-23', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Rm Frans', 'Digunakan untuk penyambung power Kipas Laptop Pribadi', 'Kabel Sambungan USB3', 1),
(74, '2022-05-23', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Rm Frans', 'Digunakan Untuk penyambung/converter Laptop pribadi ke LCD HDMI No. 4', 'Konverter HDMI to VGA', 1),
(75, '2022-05-23', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Perpustakaan', 'HDMI Convert No. 3', 'Konverter HDMI to VGA', 1),
(76, '2014-02-04', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Dibeli dengan Dana STIPAS Tahasak Danum Pambelum Tahun 2014', 'Printer Epson L1800', 1),
(77, '2018-12-22', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', 'Bantuan Sarpras Bimas Katolik Tahun 2018', 'Server DELL PowerEdge R730', 1),
(78, '2013-03-13', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Bantuan Pemda Kalteng', 'Laptop HP Pavillion G4', 1),
(79, '2013-03-13', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Administrasi Pendidikan', 'Di ruang Berta Rina', 'Laptop HP Pavillion G4', 1),
(80, '2023-02-06', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 1', '', 'LCD SONY VPL-DX211', 1),
(81, '2022-05-08', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Rm Frans', 'Penguat Signal&nbsp;TP-LINK TL-WA855RE', 'Penguat Signal', 1),
(84, '2022-08-08', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Ketua', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015', 'Printer Brother', 1),
(85, '2023-02-08', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 1', 'Bantuan Pemda Propinsi Kalteng Tahun 2015 SK No. 188.44/442/2015', 'Printer Brother', 1),
(86, '2012-04-12', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Di Ruang Bapak Yustinus Dwi Andriyanto', 'Charge Aki', 1),
(87, '2018-10-18', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Luar Gedung STIPAS', '', 'Genset Perkins 50 KW', 1),
(88, '2018-10-18', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 3', 'Di St. Aloysius Hall Lantai 3', 'Kursi Aula', 300),
(89, '2018-08-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Kapel', '', 'Kursi Aula', 80),
(90, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 3', '', 'Sound System', 2),
(91, '2018-08-15', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 3', '', 'Meja Panjang Aula', 2),
(92, '2018-08-09', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 3', '', 'Microphone Meja (aula)', 2),
(93, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 3', '', 'Tiang Microphone (Stand Microphone)', 1),
(94, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 3', '', 'Tiang Microphone Meja', 2),
(95, '2018-08-04', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah I', '', 'Kursi Kuliah', 25),
(96, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah II', '', 'Kursi Kuliah', 25),
(97, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah III', '', 'Kursi Kuliah', 25),
(98, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah IV', '', 'Kursi Kuliah', 25),
(99, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah I', '', 'Meja Kayu R.Kuliah', 1),
(100, '2018-08-03', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah II', '', 'Meja Kayu R.Kuliah', 1),
(101, '2018-08-04', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah III', '', 'Meja Kayu R.Kuliah', 1),
(102, '2018-08-04', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah IV', '', 'Meja Kayu R.Kuliah', 1),
(103, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah I', '', 'White Board', 1),
(104, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah II', '', 'White Board', 1),
(105, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah III', '', 'White Board', 1),
(106, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Kuliah IV', '', 'White Board', 1),
(107, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 1', '', 'Papan Mading', 1),
(108, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 2', '', 'Papan Mading', 1),
(109, '2023-07-14', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 1', '', 'Papan Pengumuman', 1),
(110, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 1', '', 'Kursi Panjang Bandara', 4),
(111, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 2', '', 'Kursi Panjang Bandara', 4),
(112, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 1', '', 'Mesin Foto Copy Canon IR', 1),
(113, '2023-05-18', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Rapat', '', 'Meja Kayu Ruang Rapat', 15),
(114, '2022-05-20', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Rapat', '', 'Kursi Ruang Rapat', 15),
(115, '2023-05-10', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Rapat', '', 'Lemari Kaca Ruang Rapat', 1),
(116, '2023-05-05', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Lantai 1', '', 'Sound System Polytron', 1),
(117, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Musik', '', 'Keyboard Yamaha PSR-910', 1),
(118, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Musik', '', 'Keyboard Yamaha E273', 1),
(119, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Musik', '', 'Gitar Akuistik Yamaha', 15),
(120, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Musik', '', 'Alat Musik Tradisional Dayak 1 set', 1),
(121, '2018-08-16', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Musik', '', 'Alat Band Modern 1 set', 1),
(122, '2023-07-05', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Komputer / Lab Komputer', 'Digunakan untuk Pengganti HDD pada server STIPAS 2 buah', 'SSD Samsung 870EVO', 2),
(123, '2023-07-26', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Bendahara dan Keuangan', 'Pengganti HDD pada Nettbook HP-mini bendahara', 'SSD Samsung 870EVO', 1),
(124, '2023-09-01', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Waket I', 'SSD 512 GB pengganti HDD Laptop Toshiba', 'SSD Samsung 870EVO', 1),
(125, '2023-10-13', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'LPPM', 'Diambil bu Dr. Erly Lumban Gaol, S.Ag., M.Th.', 'Printer Canon PIXMA E410', 1),
(126, '2024-01-18', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'LPM', 'Printer Epson L121 Bantuan Bimas Katolik Tahun 2023', 'Printer Epson L121', 1),
(127, '2024-01-24', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Waket II', 'Diserahkan lengkap satu set', 'PC AIO ACER 22-1700 C13', 1),
(128, '2024-01-30', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Waket I', 'Diberikan lengkap satu set', 'PC AIO ACER 22-1700 C13', 1),
(129, '2024-01-30', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Ketua Program Studi Pendidikan Dan Pengajaran Agama Katolik', 'Diberikan lengkap satu set', 'PC AIO ACER 22-1700 C13', 1),
(130, '2024-02-02', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'LPPM', 'Diberikan lengkap satu set', 'PC AIO ACER 22-1700 C13', 1),
(131, '2024-04-23', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Perpustakaan', 'Di Pinjam Yustinus Dwi A', 'Wireles Presenter', 1),
(132, '2024-01-25', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Sekretariat', 'Di Komputer Sekretariat', 'SSD Ekternal', 1),
(133, '2025-03-10', 'STIPAS Tahasak Danum Pambelum Keuskupan Palangkaraya', 'Ruang Waket I', 'Wireles Presenter (ibu Paulina Maria EW)', 'Wireles Presenter', 1);

--
-- Triggers `penempatan`
--
DELIMITER $$
CREATE TRIGGER `penempatan_barang` AFTER INSERT ON `penempatan` FOR EACH ROW BEGIN
	UPDATE barang SET jumlah=jumlah-NEW.jumlah
    WHERE nama_barang=NEW.nama_barang;
END
$$
DELIMITER ;

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

--
-- Table structure for table `pengadaan`
--

CREATE TABLE `pengadaan` (
  `id_pengadaan` int(11) NOT NULL,
  `tanggal_pengadaan` date NOT NULL,
  `supplier` varchar(100) NOT NULL,
  `jenis_pengadaan` varchar(100) NOT NULL,
  `keterangan` text NOT NULL,
  `nama_barang` varchar(100) NOT NULL,
  `deskripsi_barang` text NOT NULL,
  `harga` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `jumlah` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Triggers `pengadaan`
--
DELIMITER $$
CREATE TRIGGER `pengadaan_barang` AFTER INSERT ON `pengadaan` FOR EACH ROW BEGIN
	UPDATE barang SET jumlah = jumlah+NEW.jumlah
    WHERE nama_barang = NEW.nama_barang;
END
$$
DELIMITER ;

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

--
-- Table structure for table `pengajuan`
--

CREATE TABLE `pengajuan` (
  `id_pengajuan` int(11) NOT NULL,
  `departemen` varchar(100) NOT NULL,
  `nama_barang` varchar(50) NOT NULL,
  `jumlah` varchar(11) NOT NULL,
  `lokasi` varchar(50) NOT NULL,
  `keperluan` text NOT NULL,
  `tgl_pinjam` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Triggers `pengajuan`
--
DELIMITER $$
CREATE TRIGGER `pengajuan_pinjam` AFTER INSERT ON `pengajuan` FOR EACH ROW BEGIN
	UPDATE barang SET jumlah=jumlah-NEW.jumlah
    WHERE nama_barang=NEW.nama_barang;
END
$$
DELIMITER ;

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

--
-- Table structure for table `pengembalian`
--

CREATE TABLE `pengembalian` (
  `id_kembali` int(11) NOT NULL,
  `nama_barang` varchar(100) NOT NULL,
  `tanggal_entry` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `departemen_peminjam` varchar(100) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `tanggal_kembali` date NOT NULL,
  `deskripsi` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Triggers `pengembalian`
--
DELIMITER $$
CREATE TRIGGER `pengembalian_barang` AFTER INSERT ON `pengembalian` FOR EACH ROW BEGIN
	UPDATE barang SET jumlah = jumlah+NEW.jumlah
    WHERE nama_barang = NEW.nama_barang;
END
$$
DELIMITER ;

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

--
-- Table structure for table `rest`
--

CREATE TABLE `rest` (
  `id` int(11) UNSIGNED NOT NULL,
  `subject` varchar(200) NOT NULL,
  `table_name` varchar(200) NOT NULL,
  `primary_key` varchar(200) NOT NULL,
  `x_api_key` varchar(20) DEFAULT NULL,
  `x_token` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `rest_field`
--

CREATE TABLE `rest_field` (
  `id` int(11) UNSIGNED NOT NULL,
  `rest_id` int(11) NOT NULL,
  `field_name` varchar(200) NOT NULL,
  `input_type` varchar(200) NOT NULL,
  `show_column` varchar(10) DEFAULT NULL,
  `show_add_api` varchar(10) DEFAULT NULL,
  `show_update_api` varchar(10) DEFAULT NULL,
  `show_detail_api` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `rest_field_validation`
--

CREATE TABLE `rest_field_validation` (
  `id` int(11) UNSIGNED NOT NULL,
  `rest_field_id` int(11) NOT NULL,
  `rest_id` int(11) NOT NULL,
  `validation_name` varchar(200) NOT NULL,
  `validation_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `rest_input_type`
--

CREATE TABLE `rest_input_type` (
  `id` int(11) UNSIGNED NOT NULL,
  `type` varchar(200) NOT NULL,
  `relation` varchar(20) NOT NULL,
  `validation_group` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `rest_input_type`
--

INSERT INTO `rest_input_type` (`id`, `type`, `relation`, `validation_group`) VALUES
(1, 'input', '0', 'input'),
(2, 'timestamp', '0', 'timestamp'),
(3, 'file', '0', 'file');

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

--
-- Table structure for table `retur`
--

CREATE TABLE `retur` (
  `id_return` int(11) NOT NULL,
  `nomor_surat` varchar(50) NOT NULL,
  `nama_barang` varchar(50) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `penerima_barang` varchar(50) NOT NULL,
  `berkas` varchar(50) NOT NULL,
  `deskripsi` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Triggers `retur`
--
DELIMITER $$
CREATE TRIGGER `retur barang` AFTER INSERT ON `retur` FOR EACH ROW BEGIN
	UPDATE barang SET jumlah = jumlah+NEW.jumlah
    WHERE nama_barang = NEW.nama_barang;
END
$$
DELIMITER ;

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

--
-- Table structure for table `ruangan`
--

CREATE TABLE `ruangan` (
  `id_ruangan` int(11) NOT NULL,
  `ruangan` varchar(50) NOT NULL,
  `deskripsi` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ruangan`
--

INSERT INTO `ruangan` (`id_ruangan`, `ruangan`, `deskripsi`) VALUES
(9, 'Perlengkapan', '');

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

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `id_sup` int(11) NOT NULL,
  `nama_supplier` varchar(100) NOT NULL,
  `alamat_lengkap` text NOT NULL,
  `no_telp` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aauth_groups`
--
ALTER TABLE `aauth_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `aauth_group_to_group`
--
ALTER TABLE `aauth_group_to_group`
  ADD PRIMARY KEY (`group_id`,`subgroup_id`);

--
-- Indexes for table `aauth_login_attempts`
--
ALTER TABLE `aauth_login_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `aauth_perms`
--
ALTER TABLE `aauth_perms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `aauth_perm_to_user`
--
ALTER TABLE `aauth_perm_to_user`
  ADD PRIMARY KEY (`user_id`,`perm_id`);

--
-- Indexes for table `aauth_pms`
--
ALTER TABLE `aauth_pms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `aauth_user`
--
ALTER TABLE `aauth_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `aauth_user_to_group`
--
ALTER TABLE `aauth_user_to_group`
  ADD PRIMARY KEY (`user_id`,`group_id`);

--
-- Indexes for table `aauth_user_variables`
--
ALTER TABLE `aauth_user_variables`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `agama`
--
ALTER TABLE `agama`
  ADD PRIMARY KEY (`id_agama`);

--
-- Indexes for table `barang`
--
ALTER TABLE `barang`
  ADD PRIMARY KEY (`id_barang`);

--
-- Indexes for table `blog`
--
ALTER TABLE `blog`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_category`
--
ALTER TABLE `blog_category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `captcha`
--
ALTER TABLE `captcha`
  ADD PRIMARY KEY (`captcha_id`);

--
-- Indexes for table `cc_options`
--
ALTER TABLE `cc_options`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crud`
--
ALTER TABLE `crud`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crud_custom_option`
--
ALTER TABLE `crud_custom_option`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crud_field`
--
ALTER TABLE `crud_field`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crud_field_validation`
--
ALTER TABLE `crud_field_validation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crud_input_type`
--
ALTER TABLE `crud_input_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crud_input_validation`
--
ALTER TABLE `crud_input_validation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `departemen`
--
ALTER TABLE `departemen`
  ADD PRIMARY KEY (`id_dep`);

--
-- Indexes for table `form`
--
ALTER TABLE `form`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `form_custom_attribute`
--
ALTER TABLE `form_custom_attribute`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `form_custom_option`
--
ALTER TABLE `form_custom_option`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `form_field`
--
ALTER TABLE `form_field`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `form_field_validation`
--
ALTER TABLE `form_field_validation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `form_pengajuan_pinjam_barang`
--
ALTER TABLE `form_pengajuan_pinjam_barang`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jabatan`
--
ALTER TABLE `jabatan`
  ADD PRIMARY KEY (`id_jabatan`);

--
-- Indexes for table `jenis_pengadaan`
--
ALTER TABLE `jenis_pengadaan`
  ADD PRIMARY KEY (`id_jenis_pendagaan`);

--
-- Indexes for table `karyawan`
--
ALTER TABLE `karyawan`
  ADD PRIMARY KEY (`id_karyawan`);

--
-- Indexes for table `kategori`
--
ALTER TABLE `kategori`
  ADD PRIMARY KEY (`id_kategori`);

--
-- Indexes for table `lokasi`
--
ALTER TABLE `lokasi`
  ADD PRIMARY KEY (`id_lok`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu_type`
--
ALTER TABLE `menu_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mutasi`
--
ALTER TABLE `mutasi`
  ADD PRIMARY KEY (`id_mutasi`);

--
-- Indexes for table `page`
--
ALTER TABLE `page`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `page_block_element`
--
ALTER TABLE `page_block_element`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `penempatan`
--
ALTER TABLE `penempatan`
  ADD PRIMARY KEY (`id_penempatan`);

--
-- Indexes for table `pengadaan`
--
ALTER TABLE `pengadaan`
  ADD PRIMARY KEY (`id_pengadaan`);

--
-- Indexes for table `pengajuan`
--
ALTER TABLE `pengajuan`
  ADD PRIMARY KEY (`id_pengajuan`);

--
-- Indexes for table `pengembalian`
--
ALTER TABLE `pengembalian`
  ADD PRIMARY KEY (`id_kembali`);

--
-- Indexes for table `rest`
--
ALTER TABLE `rest`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rest_field`
--
ALTER TABLE `rest_field`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rest_field_validation`
--
ALTER TABLE `rest_field_validation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rest_input_type`
--
ALTER TABLE `rest_input_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `retur`
--
ALTER TABLE `retur`
  ADD PRIMARY KEY (`id_return`);

--
-- Indexes for table `ruangan`
--
ALTER TABLE `ruangan`
  ADD PRIMARY KEY (`id_ruangan`);

--
-- Indexes for table `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`id_sup`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `aauth_groups`
--
ALTER TABLE `aauth_groups`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `aauth_login_attempts`
--
ALTER TABLE `aauth_login_attempts`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=210;

--
-- AUTO_INCREMENT for table `aauth_perms`
--
ALTER TABLE `aauth_perms`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=291;

--
-- AUTO_INCREMENT for table `aauth_pms`
--
ALTER TABLE `aauth_pms`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `aauth_user`
--
ALTER TABLE `aauth_user`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `aauth_user_variables`
--
ALTER TABLE `aauth_user_variables`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `agama`
--
ALTER TABLE `agama`
  MODIFY `id_agama` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `barang`
--
ALTER TABLE `barang`
  MODIFY `id_barang` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;

--
-- AUTO_INCREMENT for table `blog`
--
ALTER TABLE `blog`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blog_category`
--
ALTER TABLE `blog_category`
  MODIFY `category_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `captcha`
--
ALTER TABLE `captcha`
  MODIFY `captcha_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1032;

--
-- AUTO_INCREMENT for table `cc_options`
--
ALTER TABLE `cc_options`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `crud`
--
ALTER TABLE `crud`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `crud_custom_option`
--
ALTER TABLE `crud_custom_option`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `crud_field`
--
ALTER TABLE `crud_field`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=395;

--
-- AUTO_INCREMENT for table `crud_field_validation`
--
ALTER TABLE `crud_field_validation`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=336;

--
-- AUTO_INCREMENT for table `crud_input_type`
--
ALTER TABLE `crud_input_type`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `crud_input_validation`
--
ALTER TABLE `crud_input_validation`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `departemen`
--
ALTER TABLE `departemen`
  MODIFY `id_dep` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `form`
--
ALTER TABLE `form`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `form_custom_attribute`
--
ALTER TABLE `form_custom_attribute`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_custom_option`
--
ALTER TABLE `form_custom_option`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_field`
--
ALTER TABLE `form_field`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT for table `form_field_validation`
--
ALTER TABLE `form_field_validation`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `form_pengajuan_pinjam_barang`
--
ALTER TABLE `form_pengajuan_pinjam_barang`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `jabatan`
--
ALTER TABLE `jabatan`
  MODIFY `id_jabatan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `jenis_pengadaan`
--
ALTER TABLE `jenis_pengadaan`
  MODIFY `id_jenis_pendagaan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `karyawan`
--
ALTER TABLE `karyawan`
  MODIFY `id_karyawan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `kategori`
--
ALTER TABLE `kategori`
  MODIFY `id_kategori` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `lokasi`
--
ALTER TABLE `lokasi`
  MODIFY `id_lok` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `menu_type`
--
ALTER TABLE `menu_type`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mutasi`
--
ALTER TABLE `mutasi`
  MODIFY `id_mutasi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `page`
--
ALTER TABLE `page`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `page_block_element`
--
ALTER TABLE `page_block_element`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `penempatan`
--
ALTER TABLE `penempatan`
  MODIFY `id_penempatan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=134;

--
-- AUTO_INCREMENT for table `pengadaan`
--
ALTER TABLE `pengadaan`
  MODIFY `id_pengadaan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `pengajuan`
--
ALTER TABLE `pengajuan`
  MODIFY `id_pengajuan` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pengembalian`
--
ALTER TABLE `pengembalian`
  MODIFY `id_kembali` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rest`
--
ALTER TABLE `rest`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rest_field`
--
ALTER TABLE `rest_field`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rest_field_validation`
--
ALTER TABLE `rest_field_validation`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rest_input_type`
--
ALTER TABLE `rest_input_type`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `retur`
--
ALTER TABLE `retur`
  MODIFY `id_return` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ruangan`
--
ALTER TABLE `ruangan`
  MODIFY `id_ruangan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `id_sup` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

