112 lines
3.6 KiB
SQL
112 lines
3.6 KiB
SQL
-- 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);
|
|
|