Beiträge von manu

-- phpMyAdmin SQL Dump
-- version 3.1.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 25. Juli 2010 um 17:05
-- Server Version: 5.1.32
-- PHP-Version: 5.2.9-1




SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";




--
-- Datenbank: `mam`
--




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `admins`
--




CREATE TABLE IF NOT EXISTS `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid` varchar(32) NOT NULL,
  `group` varchar(50) NOT NULL,
  `protected` tinyint(1) NOT NULL,
  `names` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `guid` (`guid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `config`
--




CREATE TABLE IF NOT EXISTS `config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `groups`
--




CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `group` (`group`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `groups_commands`
--




CREATE TABLE IF NOT EXISTS `groups_commands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group` int(11) NOT NULL,
  `command` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `maps`
--




CREATE TABLE IF NOT EXISTS `maps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(50) NOT NULL,
  `longname` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `reasons`
--




CREATE TABLE IF NOT EXISTS `reasons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `reason` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;