-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 24 Nov 2020 pada 02.49
-- Versi server: 10.4.11-MariaDB
-- Versi PHP: 7.4.6

START TRANSACTION;



--
-- Database: `sw_school_v2`
--

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

--
-- Struktur dari tabel `agenda`
--

CREATE TABLE `agenda` (
  `agenda_id` int(11) NOT NULL,
  `author` int(5) NOT NULL,
  `title` varchar(200) NOT NULL,
  `seotitle` varchar(200) NOT NULL,
  `images` varchar(200) NOT NULL,
  `agenda_date` varchar(20) NOT NULL,
  `agenda_time` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `content` text NOT NULL,
  `time` time NOT NULL,
  `date` date NOT NULL,
  `stats` int(5) NOT NULL,
  `active` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `agenda`
--

INSERT INTO `agenda` (`agenda_id`, `author`, `title`, `seotitle`, `images`, `agenda_date`, `agenda_time`, `address`, `content`, `time`, `date`, `stats`, `active`) VALUES
(1, 1, 'Kegiatan Lomba Sekolah SMKN 1 Bukit Kemuning', 'kegiatan-lomba-sekolah-smkn-1-bukit-kemuning', '/product/school-v2/sw-content/agenda/image/2.jpg', '26-11-2020', '9:00:00', 'Aula Sekolah Bandar Lampung', '<p>Kegiatan Lomba Sekolah</p>', '09:04:03', '2020-11-20', 21, '1');

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

--
-- Struktur dari tabel `banner`
--

CREATE TABLE `banner` (
  `banner_id` int(8) NOT NULL,
  `banner_name` varchar(30) NOT NULL,
  `banner_photo` varchar(200) NOT NULL,
  `banner_url` varchar(100) NOT NULL,
  `target_link` varchar(10) NOT NULL,
  `banner_width` varchar(10) NOT NULL,
  `banner_height` varchar(10) NOT NULL,
  `position` int(2) NOT NULL,
  `group_id` int(5) NOT NULL,
  `active` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Struktur dari tabel `banner_group`
--

CREATE TABLE `banner_group` (
  `banner_group_id` int(5) NOT NULL,
  `banner_group_name` varchar(20) NOT NULL,
  `banner_width` varchar(10) NOT NULL,
  `banner_height` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `banner_group`
--

INSERT INTO `banner_group` (`banner_group_id`, `banner_group_name`, `banner_width`, `banner_height`) VALUES
(1, 'Sidebar Blog', '385', '278');

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

--
-- Struktur dari tabel `category`
--

CREATE TABLE `category` (
  `category_id` int(5) NOT NULL,
  `parent_id` int(8) NOT NULL,
  `title` varchar(40) NOT NULL,
  `seotitle` varchar(45) NOT NULL,
  `type` varchar(10) NOT NULL,
  `parent_type` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `category`
--

INSERT INTO `category` (`category_id`, `parent_id`, `title`, `seotitle`, `type`, `parent_type`) VALUES
(7, 0, 'Kegiatan Siswa', 'kegiatan-siswa', '3', 0),
(12, 0, 'Karir', 'karir', '2', 0),
(14, 0, 'Pengumuman', 'pengumuman', '2', 0),
(15, 0, 'Informasi', 'informasi', '2', 0),
(16, 0, 'Welcome', 'welcome', '5', 0),
(17, 0, 'Abouts', 'abouts', '5', 0),
(18, 0, 'Guru', 'guru', '6', 0),
(19, 0, 'Pegawai', 'pegawai', '6', 0);

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

--
-- Struktur dari tabel `colortheme`
--

CREATE TABLE `colortheme` (
  `id` int(3) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `colortheme`
--

INSERT INTO `colortheme` (`id`, `name`) VALUES
(1, 'night'),
(2, 'amethyst'),
(3, 'modern'),
(4, 'autumn'),
(5, 'flatie'),
(6, 'spring'),
(7, 'fancy'),
(8, 'fire'),
(9, 'theme');

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

--
-- Struktur dari tabel `galery`
--

CREATE TABLE `galery` (
  `galery_id` int(11) NOT NULL,
  `galery_name` varchar(80) NOT NULL,
  `category` varchar(30) NOT NULL,
  `galery_photo` varchar(200) NOT NULL,
  `galery_time` time NOT NULL,
  `galery_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `galery`
--

INSERT INTO `galery` (`galery_id`, `galery_name`, `category`, `galery_photo`, `galery_time`, `galery_date`) VALUES
(19, 'Gallery 1', '7', '05d0e7b29d64e56dc46ac86ef0afb3d7.jpg', '00:34:42', '2020-11-22'),
(20, 'Gallery 2', '7', 'a3fa8017c83dfded6c10de14f548bbfc.jpg', '00:34:53', '2020-11-22'),
(21, 'Gallery 3', '7', 'e7e75f835299fe5f7ed1dac89b4f2c77.jpg', '00:35:05', '2020-11-22'),
(22, 'S-widodo.com Jasa Web Lampung', '7', 'f969af86845a476186c0e347a22fee82.jpg', '00:37:06', '2020-11-22');

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

--
-- Struktur dari tabel `language`
--

CREATE TABLE `language` (
  `id` int(3) NOT NULL,
  `langname` varchar(100) NOT NULL,
  `langcode` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `language`
--

INSERT INTO `language` (`id`, `langname`, `langcode`) VALUES
(1, 'English USA', 'en-US'),
(2, 'Bahasa Indonesia', 'id-ID');

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

--
-- Struktur dari tabel `menu`
--

CREATE TABLE `menu` (
  `id` tinyint(3) UNSIGNED NOT NULL,
  `parent_id` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `class` varchar(255) NOT NULL DEFAULT '',
  `position` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `group_id` tinyint(3) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `menu`
--

INSERT INTO `menu` (`id`, `parent_id`, `title`, `url`, `class`, `position`, `group_id`) VALUES
(1, 0, 'Beranda', './', '', 0, 1),
(2, 0, 'Profil', '#', 'dropdown', 1, 1),
(4, 0, 'Agenda', './agenda', '', 14, 1),
(57, 2, 'Profil Sekolah', 'http://localhost/product/school-v2/pages/2-profil-sekolah.html', '', 2, 1),
(56, 2, 'Makna Lambang', '#', '', 3, 1),
(82, 84, 'Guru', 'http://localhost/product/school-v2/team/guru.html', '', 12, 1),
(66, 0, 'Publikasi', '#', 'dropdown', 7, 1),
(36, 0, 'Kontak', 'contact.html', '', 16, 1),
(67, 0, 'Gallery', './gallery.html', '', 15, 1),
(68, 66, 'Semua Informasi', './blog', '', 8, 1),
(69, 66, 'Pengumuman', '#', '', 9, 1),
(70, 66, 'Pendaftaran Siswa', '#', '', 10, 1),
(83, 84, 'Pegawai', 'http://localhost/product/school-v2/team/pegawai.html', '', 13, 1),
(84, 0, 'Data', '#', 'dropdown', 11, 1),
(72, 0, 'Profil Sekolah', '#', '', 0, 2),
(73, 0, 'Blog', 'http://localhost:8080/sman1-waylima/blog', '', 1, 2),
(74, 0, 'Agenda', '#', '', 2, 2),
(75, 0, 'Gallery', '#', '', 3, 2),
(76, 0, 'Kontak', '#', '', 4, 2),
(79, 2, 'Fasilitas', '#', '', 4, 1),
(80, 2, 'Kepala Sekolah', '#', '', 5, 1),
(81, 2, 'Struktur Organisasi', '#', '', 6, 1);

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

--
-- Struktur dari tabel `menu_group`
--

CREATE TABLE `menu_group` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `menu_group`
--

INSERT INTO `menu_group` (`id`, `title`) VALUES
(1, 'Menu Manager'),
(2, 'Link Footer'),
(3, 'Link Sidebar');

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

--
-- Struktur dari tabel `message`
--

CREATE TABLE `message` (
  `msg_id` int(11) NOT NULL,
  `msg_name` varchar(50) NOT NULL,
  `msg_subject` varchar(80) NOT NULL,
  `msg_mail` varchar(50) NOT NULL,
  `msg_content` text NOT NULL,
  `msg_time` datetime NOT NULL,
  `msg_type` int(1) NOT NULL,
  `msg_tab` int(1) NOT NULL,
  `msg_status` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Struktur dari tabel `module`
--

CREATE TABLE `module` (
  `module_id` int(3) NOT NULL,
  `parent_id` int(3) NOT NULL,
  `position` int(3) NOT NULL,
  `icon` varchar(50) NOT NULL,
  `modulename` varchar(50) NOT NULL,
  `link` varchar(50) DEFAULT NULL,
  `displayname` varchar(50) NOT NULL,
  `active` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `module`
--

INSERT INTO `module` (`module_id`, `parent_id`, `position`, `icon`, `modulename`, `link`, `displayname`, `active`) VALUES
(1, 0, 19, 'fa fa-cogs', 'label_setting', 'NULL', 'Settings', 'Y'),
(2, 1, 23, 'gi gi-more_items', 'Module Management', '?mod=module', 'Module Management', 'Y'),
(3, 1, 22, 'gi gi-wrench', 'setting', '?mod=setting', 'General Settings', 'Y'),
(6, 1, 21, 'fa fa-sitemap', 'menumanager', '?mod=menumanager&group_id=1', 'Menu Manager', 'Y'),
(7, 0, 0, 'fa fa-book', 'postlabel', 'NULL', 'Post', 'Y'),
(8, 7, 2, 'fa fa-list-alt', 'post', '?mod=post', 'All Posts', 'Y'),
(9, 7, 1, 'fa fa-plus', 'addnew', '?mod=post&op=add', 'Add New', 'Y'),
(10, 7, 3, 'fa fa-bookmark', 'category', '?mod=category', 'Categories', 'Y'),
(11, 7, 4, 'gi gi-tag', 'tag', '?mod=tag', 'Tags', 'Y'),
(13, 0, 8, 'fa fa-file-o', 'page', 'NULL', 'Pages', 'Y'),
(15, 0, 25, 'gi gi-group', 'alluser', '?mod=user', 'Users', 'Y'),
(24, 0, 18, 'fa fa-envelope', 'allmessage', '?mod=message', 'Message', 'Y'),
(26, 1, 20, 'fa fa-picture-o', 'slider', '?mod=slider', 'Slider', 'Y'),
(31, 0, 17, 'fa fa-picture-o', 'banner', '?mod=banner', 'Banner', 'Y'),
(32, 0, 12, 'fa fa-camera-retro', 'Gallery', 'NULL', 'Gallery', 'Y'),
(33, 32, 13, 'fa fa-camera-retro', 'All Gallery', '?mod=galery', 'All Gallery Foto', 'Y'),
(34, 32, 14, 'fa fa-tags', 'Category Gallery', '?mod=galery&op=category', 'Category Album', 'Y'),
(35, 0, 5, 'fa fa-calendar', 'Agenda', 'NULL', 'Agenda', 'Y'),
(36, 35, 7, 'fa fa-list-alt', 'All Agenda', '?mod=agenda', 'All Agenda', 'Y'),
(37, 35, 6, 'fa fa-plus', 'Add Agenda', '?mod=agenda&op=add', 'Add New', 'Y'),
(40, 13, 9, 'fa fa-plus', 'Add Pages', '?mod=page&op=add', 'Add New', 'Y'),
(41, 13, 10, 'fa fa-list-alt', 'Pages', '?mod=page', 'Pages', 'Y'),
(42, 13, 11, 'fa fa-bookmark', 'Category Pages', '?mod=page&op=category', 'Category', 'Y'),
(43, 0, 16, 'fa fa-users', 'Team', '?mod=team', 'Team', 'Y'),
(44, 0, 15, 'fa fa-rocket', 'Powered', '?mod=powered', 'Kerja Sama', 'Y'),
(45, 1, 24, 'gi gi-more_windows', 'Theme', '?mod=theme', 'Theme', 'Y');

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

--
-- Struktur dari tabel `page`
--

CREATE TABLE `page` (
  `page_id` int(11) NOT NULL,
  `author` int(5) NOT NULL,
  `title` varchar(200) NOT NULL,
  `seotitle` varchar(200) NOT NULL,
  `category` varchar(20) NOT NULL,
  `images` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `content` text NOT NULL,
  `time` time NOT NULL,
  `date` date NOT NULL,
  `hits` int(5) NOT NULL,
  `active` varchar(1) NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `page`
--

INSERT INTO `page` (`page_id`, `author`, `title`, `seotitle`, `category`, `images`, `description`, `content`, `time`, `date`, `hits`, `active`) VALUES
(1, 1, 'Sambutan Kepala Sekolah', 'sambutan-kepala-sekolah', 'welcome', '/product/school-v2/sw-content/pages/image/p1.jpg', 'Yoharnes, S.Si. M.Si / Kepapa Sekolah', '<p>SMAN 1 Way Lima Pesawaran Pesawaran merupakan sekolah bagi para calon pemimpin masa depan.</p>\r\n<p>Staf dan para pendidik kami berkomitmen untuk memberdayakan siswa kami untuk mencapai potensi maksimalnya. Didukung dengan fasilitas, kami yakin SMAN 1 Way Lima Pesawaran adalah tempat yang tepat untuk mempersiapkan generasi muda untuk masa depan.</p>', '14:29:55', '2020-10-19', 1, 'Y'),
(2, 1, 'Profil Sekolah', 'profil-sekolah', 'abouts', '/denis/sw-content/pages/image/photo-1460518451285-97b6aa326961.jpg', 'Profil Sekolah', '<h3>Sejarah SMA Negeri 1 Waylima</h3>\r\n<p><strong>SMA Negeri 1 Waylima</strong> merupakan salah satu SMA Negeri di Kabupaten Pesawaran yang di dirikan tahun 2006 dan beralamat di Jl.Raya Desa Batu Raja Kec. Way Lima Kab. Pesawaran Lampung dengan jarak tempuh 45 Km dari Pusat Kota Bandar Lampung. SMA Negeri 1 Waylima menempati tanah seluas: 21363 m2 yang merupakan tanah dari hibah masyarakat Waylima. SMA Negeri 1 Waylima didirikan atas prakarsa dan inisiatif serta hibah dari masyarakat Waylima yang menginginkan adanya sekolah SMA Negeri daerah Waylima.</p>\r\n<p>&nbsp;</p>\r\n<h3>Visi, Misi, Dan Tujuan Sekolah</h3>\r\n<p>A. VISI SEKOLAH <br />MEWUJUDKAN SUMBER DAYA MANUSIA YANG BERIMAN, BEKARAKTER, TERDIDIK, BERBUDAYA, DAN BERWAWASAN LINGKUNGAN.</p>\r\n<p>B. MISI SEKOLAH</p>\r\n<ol>\r\n<li>Menyelenggarakan kegiatan pembelajaran yang efektif, inovatif dan kreatif berwawasan lingkungan</li>\r\n<li>Membangun karakter siswa dan warga sekolah melalui penerapan ajaran agama, dan budaya bangsa</li>\r\n<li>Membangun minat dan bakat siswa melalui kegiatan intrakurikuler, kokurikuler, dan ekstrakurikuler;</li>\r\n<li>&nbsp;Menciptakan lingkungan sekolah yang nyaman, bersih, indah, rindang, dan tertata rapih.</li>\r\n<li>Meningkatkan sarana dan prasarana sekolah untuk menunjang kegiatan pembelajaran dan ekstrakurikuler;</li>\r\n<li>Meningkatkan kemampuan pengelola sekolah melalui kegiatan pelatihan.</li>\r\n<li>Menerapkan manajemen partisipatif dengan melibatkan seluruh warga sekolah dan Komite Sekolah</li>\r\n<li>Meningkatkan hubungan yang harmonis antara warga sekolah dengan masyarakat</li>\r\n</ol>\r\n<p>&nbsp;</p>\r\n<h3><strong>C. TUJUAN SMA NEGERI 1 WAYLIMA</strong></h3>\r\n<ol>\r\n<li>Terciptanya kegiatan pembelajaran yang berorientasi pada live skil dan berbasis lingkungan</li>\r\n<li>Setiap warga sekolah memiliki karakter, taat dengan ajaran agama, memiliki akhlak dan budi pekerti yang luhur; dan disiplin yang tinggi dan berbudaya</li>\r\n<li>Terbinanya siswa yang berbakat dibidang sains, olahraga, seni, Pramuka, Paskibra, PMR, KIR, dan Rohis.</li>\r\n<li>Memiliki lingkungan sekolah yang nyaman, bersih, rapih, indah, rindang, dan tertata rapih.</li>\r\n<li>Terpenuhinya sarana dan prasarana sekolah yang memadai untuk menunjang kegiatan pembelajaran dan kegiatan ekstrakurikuler.</li>\r\n<li>Terciptannya pengelola sekolah (guru dan staf TU) yang professional melalui training, work shop, MGMP dalam rangka pelaksanaan kurikulum 2013</li>\r\n<li>Memiliki manajemen pengelolaan sekolah yang partisipatif dengan melibatkan seluruh warga sekolah dan Komite Sekolah</li>\r\n<li>Terjalinnya hubungan kerja sama yang harmonis antara warga sekolah dengan stake holder</li>\r\n</ol>\r\n<p>&nbsp;</p>\r\n<h3>Denah Lokasi SMA NEGERI 1 WAY LIMA</h3>\r\n<p><img src=\"/sman1-waylima/sw-content/pages/image/Denah_SMAN_1_Way_Lima.jpg\" alt=\"\" /></p>', '11:51:25', '2020-04-02', 36, 'Y'),
(3, 1, 'Makna Lambang', 'makna-lambang', 'abouts', '/sman1-waylima/sw-content/pages/image/LOGO_SMAN_1_WAYLIMA.jpg', 'Makna Lambang', '<h3><img style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"/sman1-waylima/sw-content/pages/image/LOGO_SMAN_1_WAYLIMA.jpg\" alt=\"\" /></h3>\r\n<p>&nbsp;</p>\r\n<h3>MAKNA LAMBANG</h3>\r\n<p>BINTANG : MELAMBANGKAN ILMU ITU CAHAYA<br />BUKU : MELAMBANGKAN SUMBER ILMU<br />PENA : MELAMBANGKAN ILMU ITU HARUS DIKEJAR DAN DITERAPKAN<br />TANGGA : MELAMBANGKAN MENUJU PRESTASI<br />WARNA HIJAU : MELAMBANGKAN PEDULI TERHADAP LINGKUNGAN<br />WARNA KUNING : MELAMBANGKAN PERDAMAIAN DAN KECERIAAN<br />SIGER : MELAMBANGKAN KITA HARUS MENJUNJUNG TINGGI DAN <br />MENGHARGAI BUDAYA BANGSA DAN NEGARA KITA <br /><br />TULISAN &ldquo;BERIMAN, TERDIDIK, BERBUDAYA, DAN BERWAWASAN LINGKUNGAN MENUNJUKKAN VISI SMA NEGERI 1 WAYLIMA&rdquo; YAITU TERWUJUDNYA SUMBER DAYA MANUSIA YANG BERIMAN, TERDIDIK, BERBUDAYA, DAN BERWAWASAN LINGKUNGAN&rdquo;</p>', '14:38:27', '2020-10-19', 7, 'Y'),
(4, 1, 'Tenaga Pendidik', 'tenaga-pendidik', 'abouts', '/sman1-waylima/sw-content/pages/image/LOGO_SMAN_1_WAYLIMA.jpg', 'Tenaga Pendidik', '<table class=\"swdatatable table table-bordered table-hover table-striped\">\r\n<thead>\r\n<tr>\r\n<td width=\"64\">No</td>\r\n<td colspan=\"2\" width=\"766\">Identitas</td>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Yoharnes, S.Si. M.Si.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19750822 200604 1 005</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S2 Biologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Biologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">IV/a</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Kemiling, Bandar Lampung</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Sumariyati, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19701221 199903 2 001</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Sejarah</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Sejarah</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">IV/b</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Wiyono, Kec. Gedong Tataan, Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Suparto, S.Pd., MM.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19730705 199802 1 002</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S2 Manajemen</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Geografi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">IV/b</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Sukadadi, Kec. Gedong Tataan, Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"9\" width=\"64\">4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Maysuri Amalia, SE.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19730501 200604 2 012</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Ekonomi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Ekonomi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">IV/a</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Pampangan, Kecamatan Waylima, Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">&nbsp;</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Elda Refanelly, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19721022 200604 2 010</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Biologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Biologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">IV/a</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Blora No. 40 Segalamider Bandar Lampung</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Maya Sari, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19760512 200604 2 014</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Ekonomi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Ekonomi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">IV/a</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Cut Nyak Dien Gg.Ratu Adil No. 26 Durian Payung</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Drs. Badawi Mahmud</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19671219 200701 1 006</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Kimia</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Kimia</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">IV/a</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl.Kelapa Sawit VIII No. 114 Prumnas Wayhalim Bandar Lampung</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Abdul Kholib, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19681015 200701 1 005</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Bahasa Indonesia</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Bahasa Indonesia</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">IV/a</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Purnawirawan Lingkungan 1 RT 12 Gg Swadaya Kec. Langkapura</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Lismawati, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19700927 200701 2 011</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 PKn</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">PKn</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/d</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Abdu Mutolib No.22 Tanjung Karang Barat Bandar Lampung</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">10.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Jumono, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19690503 200801 1 007</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Bahasa Indonesia</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Bahasa Indonesia</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/d</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Kebagusan, Kec. Gedong Tataan, Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">11.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Heni Purwoningsih, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19790817 200801 2 012</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Bahasa Indonesia</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Bahasa Indonesia</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/d</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Kota Dalam, Kec. Waylima, Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">12.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Rahmat Suryanto, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19790412 200902 1 006</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Biologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Biologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/c</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Imam Bonjol Gg. Sentosa Kurungan Nyawa, Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">13.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Syahrial Fayumi, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19810418 200902 1 005</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Penjaskes</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Penjasorkes</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/c</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Delima Blok 10 No. 18 Lk 1 Beringin Raya Kemiling Bandarlampung</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">14.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Anita Septilia, S.Si.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19810918 200902 2 004</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Matematika</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Matematika</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/d</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Gotong Royong RT 05 LK. V Ke. Pringsewu Barat, Kabupaten Pringsewu</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">15.&nbsp; &nbsp;</td>\r\n<td width=\"300\">\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td width=\"300\">Nama</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n<td width=\"466\">Reby Mayurintha, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19850731 200902 2 006</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S2 Teknologi Pendidikan</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Teknologi Pendidikan</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/c</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl.Raden Gunawan Perum Bumi Citra Lestari Blok B No. 1</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">16.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Rosiana Fadhila, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19761221 201001 2 004</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S2 Manajemen</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Manajemen</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/d</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Laks. Martadinata No. 12 Teluk Betung Bandar Lampung</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">17.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Herawati, S.Sos.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19790514 201001 2 008</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Sosiologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Sosiologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/d</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl, Raya Wiyono Desa Sukatinggi, Kec. Gedong Tataan, Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">18.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Vina Safitri, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19890614 201101 2 010</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Penjaskes</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Penjasorkes</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/c</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Desa Pampangan, Gedongtataan, Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">19.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Tabligh Farida, S.Sos.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">19800202 201101 2 004</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Sosiologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Sosiologi</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">PNS</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">III/c</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl Agung 1 No. 122 RT 1/RW- Perumnas Way Halim Kedaton</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">20.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Rinda Widyastuti,S.Pd</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Bahasa Inggris</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Bahasa Inggris</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">Honorer</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Raya Tambah Sari RT 002 RW 007 Pringsewu</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">21.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Novriansyah, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 BK</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">BK</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">Honorer</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Jl. Tritura Nabang Sari Kedondong</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">22.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Nurma Yunita</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 Matematika</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">Matematika</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">Honorer</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Banjar Negri Kec. Waylima Kab. Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">23.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Olpi Likasari, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1 BK</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">BK</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">Honorer</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Tebajawa Kedondong Pesawaran</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"8\" width=\"64\">24.&nbsp; &nbsp;</td>\r\n<td width=\"300\">Nama</td>\r\n<td width=\"466\">Septri Yuanda, S.Pd.</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">NIP</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pendidikan</td>\r\n<td width=\"466\">S1</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Jurusan</td>\r\n<td width=\"466\">PAI</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Agama</td>\r\n<td width=\"466\">Islam</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Status</td>\r\n<td width=\"466\">Honorer</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Pangkat/Gol</td>\r\n<td width=\"466\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td width=\"300\">Alamat</td>\r\n<td width=\"466\">Baturaja, Kecamatan Waylima Pesawaran</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p>&nbsp;</p>', '14:58:58', '2020-10-19', 26, 'Y'),
(5, 1, 'Fasilitas', 'fasilitas', 'abouts', '/sman1-waylima/sw-content/pages/image/LOGO_SMAN_1_WAYLIMA.jpg', 'Fasilitas SMAN 1 Way Lima', '<p>Fasilitas SMAN 1 Way Lima</p>', '15:42:45', '2020-10-22', 4, 'Y');

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

--
-- Struktur dari tabel `post`
--

CREATE TABLE `post` (
  `post_id` int(11) NOT NULL,
  `post_title` varchar(220) NOT NULL,
  `seotitle` varchar(225) NOT NULL,
  `author` int(8) NOT NULL,
  `post_description` text NOT NULL,
  `post_content` text NOT NULL,
  `images` varchar(225) NOT NULL DEFAULT 'noimage.jpg',
  `post_category` varchar(50) NOT NULL,
  `post_tags` varchar(150) NOT NULL,
  `post_time` time NOT NULL,
  `post_date` date NOT NULL,
  `post_hits` int(5) NOT NULL,
  `post_status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `post`
--

INSERT INTO `post` (`post_id`, `post_title`, `seotitle`, `author`, `post_description`, `post_content`, `images`, `post_category`, `post_tags`, `post_time`, `post_date`, `post_hits`, `post_status`) VALUES
(2, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.', 'lorem-ipsum-dolor-sit-amet-consectetur-adipisicing-elit', 1, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Alias blanditiis eveniet molestias pariatur quibusdam sed ducimus eius obcaecati adipisci et doloribus perferendis, veritatis, rerum libero, ratione ipsam expedita doloremque! Quidem.</p>\r\n<p>Lorem ipsum dolor sit amet,&nbsp;<a href=\"http://localhost/front-end/sekolah/blog-detail.html#\">Link Beranda</a>&nbsp;consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<ul>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n</ul>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Alias blanditiis eveniet molestias pariatur quibusdam sed ducimus eius obcaecati adipisci et doloribus perferendis, veritatis, rerum libero, ratione ipsam expedita doloremque! Quidem.</p>', '/product/school-v2/sw-content/blog/image/4.jpg', 'informasi', 'Informasi', '21:19:00', '2020-11-19', 1, 1),
(3, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit_2', 'lorem-ipsum-dolor-sit-amet-consectetur-adipisicing-elit_2', 1, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit_2', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Alias blanditiis eveniet molestias pariatur quibusdam sed ducimus eius obcaecati adipisci et doloribus perferendis, veritatis, rerum libero, ratione ipsam expedita doloremque! Quidem.</p>\r\n<p>Lorem ipsum dolor sit amet,&nbsp;<a href=\"http://localhost/front-end/sekolah/blog-detail.html#\">Link Beranda</a>&nbsp;consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<ul>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n</ul>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Alias blanditiis eveniet molestias pariatur quibusdam sed ducimus eius obcaecati adipisci et doloribus perferendis, veritatis, rerum libero, ratione ipsam expedita doloremque! Quidem.</p>', '/product/school-v2/sw-content/blog/image/3.jpg', 'informasi', 'Informasi', '21:21:00', '2020-11-19', 2, 1),
(4, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit 3', 'lorem-ipsum-dolor-sit-amet-consectetur-adipisicing-elit-3', 1, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit 3', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Alias blanditiis eveniet molestias pariatur quibusdam sed ducimus eius obcaecati adipisci et doloribus perferendis, veritatis, rerum libero, ratione ipsam expedita doloremque! Quidem.</p>\r\n<p>Lorem ipsum dolor sit amet,&nbsp;<a href=\"http://localhost/front-end/sekolah/blog-detail.html#\">Link Beranda</a>&nbsp;consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<ul>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n</ul>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Alias blanditiis eveniet molestias pariatur quibusdam sed ducimus eius obcaecati adipisci et doloribus perferendis, veritatis, rerum libero, ratione ipsam expedita doloremque! Quidem.</p>\r\n<ol>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n</ol>\r\n<blockquote>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Neque sint omnis natus dolores eveniet, harum autem possimus doloremque, quod enim architecto corporis, consequatur veritatis ducimus suscipit! Ab, asperiores dolor impedit.</p>\r\n</blockquote>', '/product/school-v2/sw-content/blog/image/2.jpg', 'informasi', 'Informasi', '21:22:15', '2020-11-19', 1, 1),
(5, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit 4', 'lorem-ipsum-dolor-sit-amet-consectetur-adipisicing-elit-4', 1, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit 4', '<p><img src=\"/product/school-v2/sw-content/blog/image/1.jpg\" alt=\"\" /></p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Alias blanditiis eveniet molestias pariatur quibusdam sed ducimus eius obcaecati adipisci et doloribus perferendis, veritatis, rerum libero, ratione ipsam expedita doloremque! Quidem.</p>\r\n<p>Lorem ipsum dolor sit amet,&nbsp;<a href=\"http://localhost/front-end/sekolah/blog-detail.html#\">Link Beranda</a>&nbsp;consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<ul>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n</ul>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Alias blanditiis eveniet molestias pariatur quibusdam sed ducimus eius obcaecati adipisci et doloribus perferendis, veritatis, rerum libero, ratione ipsam expedita doloremque! Quidem.</p>\r\n<ol>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n</ol>\r\n<blockquote>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Neque sint omnis natus dolores eveniet, harum autem possimus doloremque, quod enim architecto corporis, consequatur veritatis ducimus suscipit! Ab, asperiores dolor impedit.</p>\r\n</blockquote>', '/product/school-v2/sw-content/blog/image/1.jpg', 'informasi', 'Informasi', '21:22:45', '2020-11-19', 11, 1),
(6, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit 5', 'lorem-ipsum-dolor-sit-amet-consectetur-adipisicing-elit-5', 1, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.', '<p>Lorem ipsum dolor sit amet,&nbsp;<a href=\"http://localhost/front-end/sekolah/blog-detail.html#\">Link Beranda</a>&nbsp;consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<ul>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n</ul>', '/product/school-v2/sw-content/blog/image/3.jpg', 'informasi', 'Informasi', '21:33:00', '2020-11-19', 19, 1),
(7, 'Excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.', 'excepturi-omnis-eligendi-iure-dolores-a-in-aspernatur-placeat-quos-nostrum-eveniet-doloribus-aut-nisi-consequuntur-fuga-ullam', 1, 'excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.', '<p>Lorem ipsum dolor sit amet,&nbsp;<a href=\"http://localhost/front-end/sekolah/blog-detail.html#\">Link Beranda</a>&nbsp;consectetur adipisicing elit. Cupiditate mollitia praesentium aliquid cumque beatae doloribus nam aut a, quam ratione voluptate accusamus totam reprehenderit repellat quas aliquam est eos soluta? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quos neque aperiam nobis, et odio incidunt labore, placeat ad inventore recusandae molestias debitis voluptatem similique corporis voluptatibus omnis optio iure consectetur! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Non totam necessitatibus itaque, excepturi omnis eligendi iure dolores a in aspernatur placeat quos nostrum eveniet, doloribus aut nisi consequuntur fuga ullam.</p>\r\n<ul>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n<li>Lorem ipsum dolor sit amet</li>\r\n</ul>', '/product/school-v2/sw-content/blog/image/2.jpg', 'informasi', 'Informasi', '21:35:00', '2020-11-19', 18, 1);

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

--
-- Struktur dari tabel `powered`
--

CREATE TABLE `powered` (
  `id` int(12) NOT NULL,
  `name` varchar(50) NOT NULL,
  `photo` varchar(50) NOT NULL,
  `online` varchar(40) NOT NULL,
  `date` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `powered`
--

INSERT INTO `powered` (`id`, `name`, `photo`, `online`, `date`) VALUES
(24, '#', 'brand-06.png', '#', '2020-11-20'),
(25, '#', 'brand-05.png', '#', '2020-11-20'),
(26, '#', 'brand-04.png', '#', '2020-11-20'),
(27, '#', 'brand-03.png', '#', '2020-11-20');

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

--
-- Struktur dari tabel `site`
--

CREATE TABLE `site` (
  `site_id` int(1) NOT NULL,
  `site_url` varchar(100) NOT NULL,
  `sub_url` varchar(100) NOT NULL,
  `site_name` varchar(150) NOT NULL,
  `site_owner` varchar(30) NOT NULL,
  `site_phone` varchar(16) NOT NULL,
  `site_phone_2` varchar(16) NOT NULL,
  `site_office_address` varchar(200) NOT NULL,
  `site_description` text NOT NULL,
  `site_keyword` text NOT NULL,
  `site_logo` varchar(150) NOT NULL,
  `site_favicon` varchar(30) NOT NULL DEFAULT 'favicon.png',
  `maintenance_mode` varchar(2) NOT NULL,
  `social_facebook` varchar(100) NOT NULL,
  `social_twitter` varchar(100) NOT NULL,
  `social_google` varchar(100) NOT NULL,
  `social_instagram` varchar(30) NOT NULL,
  `social_line` varchar(20) NOT NULL,
  `social_bbm` varchar(20) NOT NULL,
  `social_rss` varchar(100) NOT NULL,
  `site_email` varchar(35) NOT NULL,
  `google_map` text NOT NULL,
  `live_cat` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `site`
--

INSERT INTO `site` (`site_id`, `site_url`, `sub_url`, `site_name`, `site_owner`, `site_phone`, `site_phone_2`, `site_office_address`, `site_description`, `site_keyword`, `site_logo`, `site_favicon`, `maintenance_mode`, `social_facebook`, `social_twitter`, `social_google`, `social_instagram`, `social_line`, `social_bbm`, `social_rss`, `site_email`, `google_map`, `live_cat`) VALUES
(1, 'http://localhost/product/school-v2', 'http://localhost/product/school-v2', 'SMKN 1 Bukit Kemuning', 'SMAN 1 Way Lima Pesawaran', '0896-666-5781', '-', 'Jl. Zainal Abidin Labuhan Ratu Gg. Harapan 1 No. 32 Bandar Lampung', 'Website ini adalah Web Custom CMS Sekolah yang dapat di kembangkan kembali atau langsung di hosting ke penyedia hosting, Bisa digunakan disekolah', 'Website Sekolah, CMS Website Sekolah', 'sw-sw-logoweb.png', 'favicon.png', 'N', 'https://web.facebook.com/SMAN1WAYLIMA', '#', '#', 'sman1waylima', '#', '#', '#', 'swidodo.com@gmail.com', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d15888.007380230496!2d105.0162255!3d-5.4166866!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0:0x841cf5778f8b4749!2sSMA Negeri 1 Way Lima!5e0!3m2!1sid!2sid!4v1602954245406!5m2!1sid!2sid\" width=\"100%\" height=\"380px\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', '<!-- Live Chat kosong -->');

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

--
-- Struktur dari tabel `slider`
--

CREATE TABLE `slider` (
  `id` int(5) NOT NULL,
  `photo` varchar(80) NOT NULL,
  `slider_url` varchar(200) NOT NULL,
  `position` int(5) NOT NULL,
  `active` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `slider`
--

INSERT INTO `slider` (`id`, `photo`, `slider_url`, `position`, `active`) VALUES
(1, 'slider-4575d15550def67719bf8293c5b91237.jpg', '#', 1, 'Y'),
(3, 'slider-e3f4255922ab8282d841bb160b66539c.jpg', '#', 2, 'Y');

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

--
-- Struktur dari tabel `statistic`
--

CREATE TABLE `statistic` (
  `ip` varchar(20) NOT NULL DEFAULT '',
  `tanggal` date NOT NULL,
  `hits` int(10) NOT NULL DEFAULT 1,
  `online` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `statistic`
--

INSERT INTO `statistic` (`ip`, `tanggal`, `hits`, `online`) VALUES
('', '2020-10-23', 1, '1'),
('::1', '2020-10-23', 116, '1603461979'),
('::1', '2020-10-25', 7, '1603561187'),
('::1', '2020-10-29', 1, '1603988439'),
('::1', '2020-11-14', 1, '1605319261'),
('::1', '2020-11-15', 3, '1605457083'),
('::1', '2020-11-17', 1, '1605626906'),
('::1', '2020-11-19', 125, '1605801481'),
('127.0.0.1', '2020-11-19', 1, '1605798720'),
('::1', '2020-11-20', 178, '1605887198'),
('127.0.0.1', '2020-11-21', 1, '1605922779'),
('::1', '2020-11-21', 234, '1605977862'),
('::1', '2020-11-22', 9, '1605980239'),
('::1', '2020-11-24', 7, '1606182366');

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

--
-- Struktur dari tabel `tags`
--

CREATE TABLE `tags` (
  `id` int(11) NOT NULL,
  `title` varchar(60) NOT NULL,
  `seotitle` varchar(60) NOT NULL,
  `type` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `tags`
--

INSERT INTO `tags` (`id`, `title`, `seotitle`, `type`) VALUES
(11, 'Karir', 'karir', '2'),
(13, 'Tips', 'tips', '2'),
(16, 'Admin', 'admin', '1'),
(17, 'Sosial Media', 'sosial-media', '3'),
(18, 'Modern', 'modern', '3'),
(20, 'Informasi', 'informasi', '2');

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

--
-- Struktur dari tabel `team`
--

CREATE TABLE `team` (
  `team_id` int(8) NOT NULL,
  `position` int(5) NOT NULL,
  `team_name` varchar(40) NOT NULL,
  `team_work` varchar(30) NOT NULL,
  `team_avatar` varchar(70) NOT NULL,
  `team_facebook` varchar(70) NOT NULL,
  `team_twitter` varchar(70) NOT NULL,
  `team_instagram` varchar(70) NOT NULL,
  `category` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `team`
--

INSERT INTO `team` (`team_id`, `position`, `team_name`, `team_work`, `team_avatar`, `team_facebook`, `team_twitter`, `team_instagram`, `category`) VALUES
(7, 1, 'Intan', 'Kepala Sekolah', 'tim-f3ccdd27d2000e3f9255a7e3e2c48800.jpg', '#', '#', '#', 'guru'),
(9, 2, 'Sari', 'Guru Matematika', 'tim-156005c5baf40ff51a327f1c34f2975b.jpg', '#', '#', '#', 'guru'),
(10, 3, 'Widodo', 'IT Support', 'tim-799bad5a3b514f096e69bbc4a7896cd9.jpg', '#', '#', 'swidodocom', 'pegawai'),
(11, 4, 'Rizky', 'Guru Fisika', 'tim-799bad5a3b514f096e69bbc4a7896cd9.jpg', '#', '#', '#', 'guru'),
(12, 5, 'Intan Sari', 'Guru Bahasa Indo', 'tim-f3ccdd27d2000e3f9255a7e3e2c48800.jpg', '#', '#', '#', 'guru');

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

--
-- Struktur dari tabel `theme`
--

CREATE TABLE `theme` (
  `theme_id` int(3) NOT NULL,
  `name` varchar(100) NOT NULL,
  `author` varchar(100) NOT NULL,
  `folder` varchar(100) NOT NULL,
  `active` enum('Y','N') DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `theme`
--

INSERT INTO `theme` (`theme_id`, `name`, `author`, `folder`, `active`) VALUES
(1, 'Thema Sekolah v.2', 's-widodo.com', 'sw-theme', 'Y');

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

--
-- Struktur dari tabel `user_level`
--

CREATE TABLE `user_level` (
  `level_id` int(3) NOT NULL,
  `level` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `active` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user_level`
--

INSERT INTO `user_level` (`level_id`, `level`, `active`) VALUES
(1, 'admin', 'Y'),
(2, 'user', 'Y'),
(3, 'member', 'Y');

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

--
-- Struktur dari tabel `user_profile`
--

CREATE TABLE `user_profile` (
  `id` int(5) NOT NULL,
  `user_id` int(3) NOT NULL,
  `about` text NOT NULL,
  `job` varchar(100) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `birthday` varchar(20) NOT NULL,
  `facebook` varchar(50) NOT NULL,
  `twitter` varchar(50) NOT NULL,
  `cover` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user_profile`
--

INSERT INTO `user_profile` (`id`, `user_id`, `about`, `job`, `phone`, `gender`, `birthday`, `facebook`, `twitter`, `cover`) VALUES
(1, 1, 'Pengelola Website', 'Admin Website', '089666665781', 'male', '09/08/1991', '#', '#', '');

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

--
-- Struktur dari tabel `user_role`
--

CREATE TABLE `user_role` (
  `role_id` int(3) NOT NULL,
  `level_id` int(3) NOT NULL,
  `module_id` int(3) NOT NULL,
  `read_access` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N',
  `write_access` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N',
  `modify_access` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N',
  `delete_access` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user_role`
--

INSERT INTO `user_role` (`role_id`, `level_id`, `module_id`, `read_access`, `write_access`, `modify_access`, `delete_access`) VALUES
(1, 1, 1, 'Y', 'Y', 'Y', 'Y'),
(2, 2, 1, 'N', 'Y', 'Y', 'Y'),
(3, 3, 1, 'N', 'Y', 'Y', 'Y'),
(4, 1, 2, 'Y', 'Y', 'Y', 'Y'),
(5, 2, 2, 'Y', 'Y', 'Y', 'Y'),
(6, 3, 2, 'Y', 'Y', 'Y', 'Y'),
(7, 1, 3, 'Y', 'Y', 'Y', 'Y'),
(8, 2, 3, 'Y', 'Y', 'Y', 'Y'),
(9, 3, 3, 'Y', 'Y', 'Y', 'Y'),
(16, 1, 6, 'Y', 'Y', 'Y', 'Y'),
(17, 2, 6, 'Y', 'Y', 'Y', 'Y'),
(18, 3, 6, 'Y', 'Y', 'Y', 'Y'),
(19, 1, 7, 'Y', 'Y', 'Y', 'Y'),
(20, 2, 7, 'Y', 'Y', 'Y', 'Y'),
(21, 3, 7, 'N', 'Y', 'Y', 'Y'),
(22, 1, 8, 'Y', 'Y', 'Y', 'Y'),
(23, 2, 8, 'N', 'Y', 'Y', 'Y'),
(24, 3, 8, 'N', 'Y', 'Y', 'Y'),
(25, 1, 9, 'Y', 'Y', 'Y', 'Y'),
(26, 2, 9, 'Y', 'Y', 'Y', 'Y'),
(27, 3, 9, 'Y', 'Y', 'Y', 'Y'),
(28, 1, 10, 'Y', 'Y', 'Y', 'Y'),
(29, 2, 10, 'Y', 'Y', 'Y', 'Y'),
(30, 3, 10, 'Y', 'Y', 'Y', 'Y'),
(31, 1, 11, 'Y', 'Y', 'Y', 'Y'),
(32, 2, 11, 'Y', 'Y', 'Y', 'Y'),
(33, 3, 11, 'Y', 'Y', 'Y', 'Y'),
(37, 1, 13, 'Y', 'Y', 'Y', 'Y'),
(38, 2, 13, 'N', 'Y', 'Y', 'Y'),
(39, 3, 13, 'N', 'Y', 'Y', 'Y'),
(43, 1, 15, 'Y', 'Y', 'Y', 'Y'),
(44, 2, 15, 'Y', 'Y', 'Y', 'Y'),
(45, 3, 15, 'Y', 'Y', 'Y', 'Y'),
(55, 1, 0, 'Y', 'Y', 'Y', 'Y'),
(56, 2, 0, 'N', 'N', 'N', 'N'),
(59, 2, 58, 'N', 'N', 'N', 'N'),
(62, 2, 61, 'N', 'N', 'N', 'N'),
(64, 1, 24, 'Y', 'Y', 'Y', 'Y'),
(65, 2, 64, 'N', 'N', 'N', 'N'),
(68, 2, 67, 'N', 'N', 'N', 'N'),
(70, 1, 26, 'Y', 'Y', 'Y', 'Y'),
(71, 2, 70, 'N', 'N', 'N', 'N'),
(74, 2, 73, 'N', 'N', 'N', 'N'),
(77, 2, 76, 'N', 'N', 'N', 'N'),
(78, 3, 77, 'N', 'N', 'N', 'N'),
(79, 1, 11, 'Y', 'Y', 'Y', 'Y'),
(80, 1, 10, 'Y', 'N', 'N', 'N'),
(82, 2, 81, 'N', 'N', 'N', 'N'),
(83, 3, 82, 'N', 'N', 'N', 'N'),
(85, 2, 84, 'N', 'N', 'N', 'N'),
(86, 3, 85, 'N', 'N', 'N', 'N'),
(88, 2, 87, 'N', 'N', 'N', 'N'),
(89, 3, 88, 'N', 'N', 'N', 'N'),
(91, 2, 90, 'N', 'N', 'N', 'N'),
(92, 3, 91, 'N', 'N', 'N', 'N'),
(93, 1, 24, 'Y', 'Y', 'Y', 'Y'),
(94, 2, 93, 'N', 'N', 'N', 'N'),
(95, 3, 94, 'N', 'N', 'N', 'N'),
(97, 2, 96, 'N', 'N', 'N', 'N'),
(98, 3, 97, 'N', 'N', 'N', 'N'),
(99, 1, 26, 'Y', 'Y', 'Y', 'Y'),
(100, 2, 99, 'N', 'N', 'N', 'N'),
(101, 3, 100, 'N', 'N', 'N', 'N'),
(102, 1, 31, 'Y', 'Y', 'Y', 'Y'),
(103, 2, 102, 'N', 'N', 'N', 'N'),
(104, 3, 103, 'N', 'N', 'N', 'N'),
(106, 2, 105, 'N', 'N', 'N', 'N'),
(107, 3, 106, 'N', 'N', 'N', 'N'),
(109, 2, 108, 'N', 'N', 'N', 'N'),
(110, 3, 109, 'N', 'N', 'N', 'N'),
(112, 2, 111, 'N', 'N', 'N', 'N'),
(113, 3, 112, 'N', 'N', 'N', 'N'),
(115, 2, 114, 'N', 'N', 'N', 'N'),
(116, 3, 115, 'N', 'N', 'N', 'N'),
(118, 2, 117, 'N', 'N', 'N', 'N'),
(119, 3, 118, 'N', 'N', 'N', 'N'),
(121, 2, 120, 'N', 'N', 'N', 'N'),
(122, 3, 121, 'N', 'N', 'N', 'N'),
(124, 2, 123, 'N', 'N', 'N', 'N'),
(125, 3, 124, 'N', 'N', 'N', 'N'),
(126, 1, 32, 'Y', 'Y', 'Y', 'Y'),
(127, 2, 126, 'N', 'N', 'N', 'N'),
(128, 3, 127, 'N', 'N', 'N', 'N'),
(129, 1, 33, 'Y', 'Y', 'Y', 'Y'),
(130, 2, 129, 'N', 'N', 'N', 'N'),
(131, 3, 130, 'N', 'N', 'N', 'N'),
(132, 1, 34, 'Y', 'Y', 'Y', 'Y'),
(133, 2, 132, 'N', 'N', 'N', 'N'),
(134, 3, 133, 'N', 'N', 'N', 'N'),
(135, 1, 35, 'Y', 'Y', 'Y', 'Y'),
(136, 2, 135, 'N', 'N', 'N', 'N'),
(137, 3, 136, 'N', 'N', 'N', 'N'),
(138, 1, 36, 'Y', 'Y', 'Y', 'Y'),
(139, 2, 138, 'N', 'N', 'N', 'N'),
(140, 3, 139, 'N', 'N', 'N', 'N'),
(141, 1, 37, 'Y', 'Y', 'Y', 'Y'),
(142, 2, 141, 'N', 'N', 'N', 'N'),
(143, 3, 142, 'N', 'N', 'N', 'N'),
(145, 2, 144, 'N', 'N', 'N', 'N'),
(146, 3, 145, 'N', 'N', 'N', 'N'),
(148, 2, 147, 'N', 'N', 'N', 'N'),
(149, 3, 148, 'N', 'N', 'N', 'N'),
(150, 1, 40, 'Y', 'Y', 'Y', 'Y'),
(151, 2, 150, 'N', 'N', 'N', 'N'),
(152, 3, 151, 'N', 'N', 'N', 'N'),
(153, 1, 41, 'Y', 'Y', 'Y', 'Y'),
(154, 2, 153, 'N', 'N', 'N', 'N'),
(155, 3, 154, 'N', 'N', 'N', 'N'),
(156, 1, 42, 'Y', 'Y', 'Y', 'Y'),
(157, 2, 156, 'N', 'N', 'N', 'N'),
(158, 3, 157, 'N', 'N', 'N', 'N'),
(159, 1, 43, 'Y', 'Y', 'Y', 'Y'),
(160, 2, 159, 'N', 'N', 'N', 'N'),
(161, 3, 160, 'N', 'N', 'N', 'N'),
(162, 1, 44, 'Y', 'Y', 'Y', 'Y'),
(163, 2, 162, 'N', 'N', 'N', 'N'),
(164, 3, 163, 'N', 'N', 'N', 'N'),
(165, 1, 45, 'Y', 'Y', 'Y', 'Y'),
(166, 2, 165, 'N', 'N', 'N', 'N'),
(167, 3, 166, 'N', 'N', 'N', 'N');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `agenda`
--
ALTER TABLE `agenda`
  ADD PRIMARY KEY (`agenda_id`);

--
-- Indeks untuk tabel `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`banner_id`);

--
-- Indeks untuk tabel `banner_group`
--
ALTER TABLE `banner_group`
  ADD PRIMARY KEY (`banner_group_id`);

--
-- Indeks untuk tabel `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indeks untuk tabel `colortheme`
--
ALTER TABLE `colortheme`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `galery`
--
ALTER TABLE `galery`
  ADD PRIMARY KEY (`galery_id`),
  ADD UNIQUE KEY `galery_id` (`galery_id`);

--
-- Indeks untuk tabel `language`
--
ALTER TABLE `language`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `menu_group`
--
ALTER TABLE `menu_group`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `message`
--
ALTER TABLE `message`
  ADD PRIMARY KEY (`msg_id`);

--
-- Indeks untuk tabel `module`
--
ALTER TABLE `module`
  ADD PRIMARY KEY (`module_id`);

--
-- Indeks untuk tabel `page`
--
ALTER TABLE `page`
  ADD PRIMARY KEY (`page_id`);

--
-- Indeks untuk tabel `post`
--
ALTER TABLE `post`
  ADD PRIMARY KEY (`post_id`);

--
-- Indeks untuk tabel `powered`
--
ALTER TABLE `powered`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `site`
--
ALTER TABLE `site`
  ADD PRIMARY KEY (`site_id`);

--
-- Indeks untuk tabel `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `team`
--
ALTER TABLE `team`
  ADD PRIMARY KEY (`team_id`);

--
-- Indeks untuk tabel `theme`
--
ALTER TABLE `theme`
  ADD PRIMARY KEY (`theme_id`);

--
-- Indeks untuk tabel `user_level`
--
ALTER TABLE `user_level`
  ADD PRIMARY KEY (`level_id`);

--
-- Indeks untuk tabel `user_profile`
--
ALTER TABLE `user_profile`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `user_role`
--
ALTER TABLE `user_role`
  ADD PRIMARY KEY (`role_id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `agenda`
--
ALTER TABLE `agenda`
  MODIFY `agenda_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `banner`
--
ALTER TABLE `banner`
  MODIFY `banner_id` int(8) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `banner_group`
--
ALTER TABLE `banner_group`
  MODIFY `banner_group_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `category`
--
ALTER TABLE `category`
  MODIFY `category_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT untuk tabel `colortheme`
--
ALTER TABLE `colortheme`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `galery`
--
ALTER TABLE `galery`
  MODIFY `galery_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT untuk tabel `language`
--
ALTER TABLE `language`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT untuk tabel `menu`
--
ALTER TABLE `menu`
  MODIFY `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT untuk tabel `menu_group`
--
ALTER TABLE `menu_group`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `message`
--
ALTER TABLE `message`
  MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT untuk tabel `module`
--
ALTER TABLE `module`
  MODIFY `module_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT untuk tabel `page`
--
ALTER TABLE `page`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `post`
--
ALTER TABLE `post`
  MODIFY `post_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `powered`
--
ALTER TABLE `powered`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT untuk tabel `site`
--
ALTER TABLE `site`
  MODIFY `site_id` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `tags`
--
ALTER TABLE `tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT untuk tabel `team`
--
ALTER TABLE `team`
  MODIFY `team_id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT untuk tabel `theme`
--
ALTER TABLE `theme`
  MODIFY `theme_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `user_level`
--
ALTER TABLE `user_level`
  MODIFY `level_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `user_profile`
--
ALTER TABLE `user_profile`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `user_role`
--
ALTER TABLE `user_role`
  MODIFY `role_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=168;
COMMIT;

