-- phpMyAdmin SQL Dump -- version 2.7.0-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 04. Januar 2007 um 18:52 -- Server Version: 5.0.18 -- PHP-Version: 5.1.1 -- -- Datenbank: `db_2erlei` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `fl_basecontent` -- DROP TABLE IF EXISTS `fl_basecontent`; CREATE TABLE `fl_basecontent` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', `ip` varchar(15) NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', `action` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Daten für Tabelle `fl_basecontent` -- INSERT INTO `fl_basecontent` VALUES (1, 'matthias', '127.0.0.1', '2007-01-04 18:01:34', 'matthias hat sich eingeloggt'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `fl_basecontent_options` -- DROP TABLE IF EXISTS `fl_basecontent_options`; CREATE TABLE `fl_basecontent_options` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `optionname` varchar(50) default NULL, `value` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0; -- -- Daten für Tabelle `fl_basecontent_options` -- INSERT INTO `fl_basecontent_options` VALUES (1, 'SEITENTITEL', 'Kundenlogin'); INSERT INTO `fl_basecontent_options` VALUES (2, 'DEFAULTSECTION', 'pages'); INSERT INTO `fl_basecontent_options` VALUES (3, 'ADMINHELP', 'sichtbar'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `fl_user` -- DROP TABLE IF EXISTS `fl_user`; CREATE TABLE `fl_user` ( `id` tinyint(4) NOT NULL auto_increment, `status` tinyint(3) unsigned NOT NULL default '0', `name` varchar(20) default NULL, `password` varchar(255) default NULL, `email` varchar(255) default NULL, `level` tinyint(3) unsigned NOT NULL default '255', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten für Tabelle `fl_user` -- INSERT INTO `fl_user` VALUES (1, 0, 'matthias', '598d4c200461b81522a3328565c25f7c', 'matthias@2erlei.de', 0); INSERT INTO `fl_user` VALUES (2, 0, 'bastian', 'b9d519a644a0590327bc0e3ef6505539', 'bastian@2erlei.de', 1); INSERT INTO `fl_user` VALUES (3, 0, 'norman', 'b9d519a644a0590327bc0e3ef6505539', 'norman@2erlei.de', 2); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `fl_user_access` -- DROP TABLE IF EXISTS `fl_user_access`; CREATE TABLE `fl_user_access` ( `id` int(10) unsigned NOT NULL auto_increment, `controller` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `level` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0; -- -- Daten für Tabelle `fl_user_access` -- INSERT INTO `fl_user_access` VALUES (1, 'basecontent', 'show', 2); INSERT INTO `fl_user_access` VALUES (2, 'basecontent', 'trashcan', 1); INSERT INTO `fl_user_access` VALUES (3, 'basecontent', 'logout', 255); INSERT INTO `fl_user_access` VALUES (4, 'basecontent', 'options', 1); INSERT INTO `fl_user_access` VALUES (5, 'basecontent', 'protocol', 1); INSERT INTO `fl_user_access` VALUES (6, 'basecontent', 'support', 1); INSERT INTO `fl_user_access` VALUES (7, 'user', 'add', 2); INSERT INTO `fl_user_access` VALUES (8, 'user', 'edit', 2); INSERT INTO `fl_user_access` VALUES (9, 'user', 'del', 1); INSERT INTO `fl_user_access` VALUES (10, 'user', 'admin', 2);