Skip to content

Instantly share code, notes, and snippets.

@addingama
Created September 9, 2013 20:25
Show Gist options
  • Save addingama/6501006 to your computer and use it in GitHub Desktop.
Save addingama/6501006 to your computer and use it in GitHub Desktop.
sql dump for menu
DROP TABLE IF EXISTS `menu`;
CREATE TABLE IF NOT EXISTS `menu` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`submenu_of` int(10) DEFAULT '0',
`urutan` int(4) unsigned DEFAULT '0',
`idmenu` int(10) DEFAULT NULL,
`label` varchar(50) DEFAULT NULL,
`level` int(2) unsigned DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`main_menu` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='menyimpan struktur menu' AUTO_INCREMENT=79 ;
--
-- Dumping data for table `menu`
--
INSERT INTO `menu` (`id`, `submenu_of`, `urutan`, `idmenu`, `label`, `level`, `created_at`, `main_menu`) VALUES
(1, 0, 1, NULL, 'Tentang Jabar', 0, '2013-07-22 18:59:54', 1),
(2, 0, 2, NULL, 'Pemerintahan', 0, '2013-07-22 18:59:54', 1),
(5, 0, 4, NULL, 'Potensi Jabar', 0, '2013-07-22 18:59:54', 1),
(24, 0, 7, NULL, 'Kepala Daerah', 0, '2013-07-23 11:28:12', 0),
(33, 6, 1, NULL, 'sub menu', 2, '2013-09-10 02:46:10', 1),
(34, 6, 1, NULL, 'rtgerterter', 2, '2013-09-10 02:47:30', 1),
(40, 1, 2, NULL, 'Visi dan Misi Jawa Barat', 1, '2013-09-10 02:52:56', 1),
(44, 1, 1, NULL, 'Sekilas Jabar', 1, '2013-09-10 02:56:33', 1),
(45, 44, 1, NULL, 'Sejarah Jawa Barat', 2, '2013-09-10 02:57:37', 1),
(46, 44, 2, NULL, 'Sejarah Pimpinan Daerah', 2, '2013-09-10 02:57:51', 1),
(47, 44, 3, NULL, 'Peta Jawa Barat', 2, '2013-09-10 02:58:01', 1),
(48, 44, 4, NULL, 'Kependudukan', 2, '2013-09-10 02:58:10', 1),
(49, 44, 5, NULL, 'Kondisi Geografis', 2, '2013-09-10 02:58:23', 1),
(50, 1, 3, NULL, 'Jabar Dalam Angka', 1, '2013-09-10 02:59:04', 1),
(51, 2, 1, NULL, 'Pimpinan Daerah', 1, '2013-09-10 02:59:48', 1),
(52, 2, 2, NULL, 'Visi Misi Pemprov Jabar', 1, '2013-09-10 03:00:05', 1),
(53, 2, 3, NULL, 'Kelembagaan', 1, '2013-09-10 03:00:23', 1),
(54, 2, 4, NULL, 'BUMD', 1, '2013-09-10 03:00:32', 1),
(55, 2, 5, NULL, 'DPRD', 1, '2013-09-10 03:00:40', 1),
(56, 2, 6, NULL, 'Kabupaten/Kota', 1, '2013-09-10 03:00:52', 1),
(57, 2, 7, NULL, 'Program Kerja', 1, '2013-09-10 03:01:01', 1),
(58, 2, 8, NULL, 'Pelaporan & Pertanggungjawaban', 1, '2013-09-10 03:01:30', 1),
(59, 2, 9, NULL, 'Produk Hukum', 1, '2013-09-10 03:01:42', 1),
(60, 2, 10, NULL, 'Transparansi Pengelolaan Keuangan', 1, '2013-09-10 03:01:57', 1),
(61, 53, 1, NULL, 'OPD', 2, '2013-09-10 03:02:07', 1),
(62, 53, 2, NULL, 'Lembaga Lainnya', 2, '2013-09-10 03:02:24', 1),
(63, 57, 1, NULL, 'RPJMD', 2, '2013-09-10 03:02:36', 1),
(64, 57, 2, NULL, 'RKPD', 2, '2013-09-10 03:02:50', 1),
(65, 57, 3, NULL, 'APBD', 2, '2013-09-10 03:03:03', 1),
(66, 0, 3, NULL, 'Info Jabar', 0, '2013-09-10 03:03:23', 1),
(67, 66, 1, NULL, 'Berita', 1, '2013-09-10 03:03:35', 1),
(68, 67, 1, NULL, 'Berita Utama', 2, '2013-09-10 03:03:59', 1),
(69, 67, 2, NULL, 'Berita Umum', 2, '2013-09-10 03:04:11', 1),
(70, 67, 3, NULL, 'Berita OPD', 2, '2013-09-10 03:04:30', 1),
(71, 67, 4, NULL, 'Berita Daerah', 2, '2013-09-10 03:04:49', 1),
(72, 66, 2, NULL, 'Artikel', 1, '2013-09-10 03:05:22', 1),
(73, 66, 3, NULL, 'Galeri Foto', 1, '2013-09-10 03:05:48', 1),
(74, 66, 4, NULL, 'Galeri Batik', 1, '2013-09-10 03:06:01', 1),
(75, 66, 5, NULL, 'Galeri Video', 1, '2013-09-10 03:06:29', 1),
(76, 66, 6, NULL, 'Prestasi Jawa Barat', 1, '2013-09-10 03:07:00', 1),
(77, 66, 7, NULL, 'Anugrah Jawa Barat', 1, '2013-09-10 03:07:16', 1),
(78, 66, 8, NULL, 'Agenda', 1, '2013-09-10 03:07:31', 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment