diff options
| author | neoraider <devnull@localhost> | 2006-12-10 19:00:04 +0100 |
|---|---|---|
| committer | neoraider <devnull@localhost> | 2006-12-10 19:00:04 +0100 |
| commit | 93e1133ee88b03e7cae7318cb19761e698e57b86 (patch) | |
| tree | 825b0ca10c5b32f3ad03430ec8b427f99d3dc855 /config/SQL/nav.sql | |
| parent | 7be63518bdb86fb747dda20918ef6eab3d30e40c (diff) | |
| download | neon-93e1133ee88b03e7cae7318cb19761e698e57b86.tar neon-93e1133ee88b03e7cae7318cb19761e698e57b86.zip | |
SQL-Daten tabellenweise aufgeteilt;
config-Daten jetzt mit urlencode kodiert.
Diffstat (limited to 'config/SQL/nav.sql')
| -rw-r--r-- | config/SQL/nav.sql | 37 |
1 files changed, 37 insertions, 0 deletions
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'); |