CREATE TABLE `cms_navigation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `caption` varchar(30) NOT NULL DEFAULT '',
  `url` varchar(30) NOT NULL DEFAULT '',
  `parent_id` int(30) NOT NULL DEFAULT '-1',
  `order_id` int(30) NOT NULL DEFAULT '0',
  `visibility` int(11) NOT NULL DEFAULT '1',
  `filename` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `cms_navigation` (`id`, `caption`, `url`, `parent_id`, `order_id`, `visibility`, `filename`)
VALUES
	(1,'{username}','/me',-1,1,1,'me'),
	(2,'Community','/community',-1,2,1,'community'),
	(3,'Shop','/vip',-1,3,0,'vip'),
	(4,'{username}','/me',1,1,1,'me'),
	(5,'My Page','/home/{username}',1,2,1,'home/{username}'),
	(6,'Settings','/settingspassword',1,3,1,'settingspassword'),
	(7,'Log Out','/logout',1,5,0,'logout'),
	(8,'Login Attempts','/sessionlog',1,4,1,'sessionlog'),
	(9,'Community','/community',2,1,1,'community'),
	(10,'Articles','/news',2,2,1,'news'),
	(11,'Leaderboards','/stats',2,3,1,'leaderboards'),
	(12,'Online Users','/online',2,4,1,'online'),
	(13,'Staff','/staff',2,4,1,'staff');