From fa39bfd963d7d05335d968b0efdfd9bb9a40f132 Mon Sep 17 00:00:00 2001 From: neoraider Date: Mon, 4 Dec 2006 00:29:05 +0000 Subject: Datenbank-Update vergessen... --- config/neon.sql | 64 +++++++++++++++++++++++++++++++++++++++++---------------- 1 file changed, 46 insertions(+), 18 deletions(-) diff --git a/config/neon.sql b/config/neon.sql index f4f8596..5de9591 100644 --- a/config/neon.sql +++ b/config/neon.sql @@ -3,7 +3,7 @@ -- http://www.phpmyadmin.net -- -- Host: localhost --- Erstellungszeit: 02. Dezember 2006 um 14:57 +-- Erstellungszeit: 04. Dezember 2006 um 01:27 -- Server Version: 5.0.27 -- PHP-Version: 5.2.0-7 -- @@ -83,28 +83,56 @@ INSERT INTO `modules` (`id`, `name`, `enabled`) VALUES (3, 'BBCode', 1); 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=17 ; +) TYPE=MyISAM AUTO_INCREMENT=27 ; -- -- Daten für Tabelle `nav` -- -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (2, 1, 'Startseite', ':Home:Startseite'); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (3, 1, 'Mail', '@info@gamezock.de'); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (4, 7, 'Login', '!Login'); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (16, 9, 'Logout', ':Logout'); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (1, 0, 'Home', ''); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (7, 0, 'Login', ''); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (8, 0, 'Administration', ''); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (9, 0, 'Mitglieder', ''); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (10, 0, 'Test', ''); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (11, 10, 'Lorem Ipsum', ':Test:LoremIpsum'); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (12, 8, 'Seiten', ':Pages'); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (15, 8, 'Module', ':Modules'); -INSERT INTO `nav` (`id`, `parent`, `text`, `link`) VALUES (14, 8, 'Benutzer', ':Users'); +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'); + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `nav_inserts` +-- + +CREATE TABLE `nav_inserts` ( + `id` bigint(20) NOT NULL auto_increment, + `name` varchar(255) NOT NULL, + `code` longtext NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +) TYPE=MyISAM AUTO_INCREMENT=2 ; + +-- +-- Daten für Tabelle `nav_inserts` +-- + +INSERT INTO `nav_inserts` (`id`, `name`, `code`) VALUES (1, 'login', 'GetNeonLink(''Login'');\r\n echo ''" method="post">'';\r\n?>\r\n
\r\n User:
\r\n
\r\n Passwort:
\r\n
\r\n \r\n \r\n
\r\n\r\n'); -- -------------------------------------------------------- @@ -175,6 +203,6 @@ CREATE TABLE `users` ( -- Daten für Tabelle `users` -- -INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (1, '', 0, 'NeoRaider', 'gamezock', '2006-10-15 03:12:57'); -INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (3, '', 0, 'sicarius', 'armleuchter', '2006-03-05 23:46:46'); -INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (4, '', 0, 'morti', 'return', '2006-03-05 22:02:27'); +INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (1, '', -1, 'NeoRaider', 'gamezock', '2006-12-04 01:18:26'); +INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (3, '', -1, 'sicarius', 'armleuchter', '2006-12-02 22:46:58'); +INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (4, '', -1, 'morti', 'return', '2006-12-02 22:46:58'); -- cgit v1.2.3