· 9 years ago · Dec 06, 2016, 07:08 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.3
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 06, 2016 at 08:05
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `kursus`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `menu`
27--
28
29CREATE TABLE IF NOT EXISTS `menu` (
30 `id` int(11) NOT NULL,
31 `nama` varchar(250) NOT NULL,
32 `link` varchar(500) NOT NULL,
33 `level` int(11) NOT NULL DEFAULT '1',
34 `sub` int(11) NOT NULL DEFAULT '0',
35 `jenis` varchar(200) NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38--
39-- Indexes for dumped tables
40--
41
42--
43-- Indexes for table `menu`
44--
45ALTER TABLE `menu`
46 ADD PRIMARY KEY (`id`);
47
48--
49-- AUTO_INCREMENT for dumped tables
50--
51
52--
53-- AUTO_INCREMENT for table `menu`
54--
55ALTER TABLE `menu`
56 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
57/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
58/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
59/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;