· 9 years ago · Nov 13, 2016, 06:34 AM
1CREATE TABLE IF NOT EXISTS `nav` (
2 `id` tinyint(3) NOT NULL AUTO_INCREMENT,
3 `name` varchar(100) NOT NULL,
4 `url` varchar(100) NOT NULL,
5 `title` varchar(100) NOT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
8
9--
10-- Dumping data for table `nav`
11--
12
13INSERT INTO `nav` (`id`, `name`, `url`, `title`) VALUES
14(1, 'Community', 'index.php?page=1', 'Home'),
15(2, 'News', 'index.php?page=2', 'News'),
16(3, 'Portfolio', 'index.php?page=3', 'Portfolio'),
17(4, 'Services', 'index.php?page=4', 'Services'),
18(5, 'Products', 'index.php?page=5', 'Products'),
19(6, 'About Us', 'index.php?page=6', 'About Us'),
20(7, 'Contact Us', 'index.php?page=7', 'Contact Us');
21
22/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
23/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
24/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;