summaryrefslogtreecommitdiffstats
path: root/config/SQL/nav.sql
blob: 0b3b8101f6b02b1c84398ba88a71bec559af81cb (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
-- 
-- Tabellenstruktur für Tabelle `nav`
-- 

CREATE TABLE `nav` (
  `id` bigint(20) NOT NULL auto_increment,
  `parent` bigint(20) NOT NULL default '0',
  `gid` bigint(20) NOT NULL default '0',
  `text` tinytext NOT NULL,
  `link` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=27 ;

-- 
-- Daten für Tabelle `nav`
-- 

INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (2, 1, 0, 'Startseite', ':Home:Startseite');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (3, 1, 0, 'Mail', '@info@gamezock.de');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (4, 7, 0, 'Login', '-login');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (16, 26, 0, 'Logout', ':Logout');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (1, 17, 0, 'Home', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (7, 17, 0, 'Login', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (24, 18, 0, 'Administration', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (26, 18, 0, 'Mitglieder', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (10, 17, 0, 'Test', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (11, 10, 0, 'Lorem Ipsum', ':Test:LoremIpsum');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (12, 24, 0, 'Seiten', ':Pages');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (15, 24, 0, 'Module', ':Modules');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (14, 24, 0, 'Benutzer', ':Users');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (17, 0, 0, 'default', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (18, 0, -1, 'default', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (19, 18, 0, 'Home', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (25, 18, 0, 'Test', '');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (21, 19, 0, 'Startseite', ':Home:Startseite');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (22, 19, 0, 'Mail', '@info@gamezock.de');
INSERT INTO `nav` (`id`, `parent`, `gid`, `text`, `link`) VALUES (23, 25, 0, 'Lorem Ipsum', ':Test:LoremIpsum');