From 93e1133ee88b03e7cae7318cb19761e698e57b86 Mon Sep 17 00:00:00 2001 From: neoraider Date: Sun, 10 Dec 2006 18:00:04 +0000 Subject: SQL-Daten tabellenweise aufgeteilt; config-Daten jetzt mit urlencode kodiert. --- config/SQL/nav.sql | 37 +++++++++++++++++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 config/SQL/nav.sql (limited to 'config/SQL/nav.sql') diff --git a/config/SQL/nav.sql b/config/SQL/nav.sql new file mode 100644 index 0000000..0b3b810 --- /dev/null +++ b/config/SQL/nav.sql @@ -0,0 +1,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'); -- cgit v1.2.3