-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 06. Juli 2006 um 17:09
-- Server Version: 5.0.18
-- PHP-Version: 5.1.1
-- 
-- Datenbank: `zuckermaeusken`
-- 

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

-- 
-- Tabellenstruktur für Tabelle `persons`
-- 

CREATE TABLE `persons` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lastname` varchar(50) collate latin1_general_ci default NULL,
  `firstname` varchar(50) collate latin1_general_ci default NULL,
  `nickname` varchar(50) collate latin1_general_ci default NULL,
  `edited` datetime NOT NULL,
  `editor` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

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

-- 
-- Tabellenstruktur für Tabelle `quote_categories`
-- 

CREATE TABLE `quote_categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) collate latin1_general_ci NOT NULL,
  `iconsrc` varchar(250) collate latin1_general_ci NOT NULL,
  `edited` datetime NOT NULL,
  `editor` int(10) unsigned NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Tabellenstruktur für Tabelle `quotes`
-- 

CREATE TABLE `quotes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat` int(10) unsigned default NULL,
  `quote` varchar(250) collate latin1_general_ci NOT NULL,
  `author` int(10) unsigned NOT NULL,
  `edited` datetime NOT NULL,
  `editor` int(10) unsigned NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Tabellenstruktur für Tabelle `users`
-- 

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `person_id` int(10) unsigned NOT NULL,
  `email` varchar(100) collate latin1_general_ci NOT NULL,
  `password` varchar(40) collate latin1_general_ci NOT NULL,
  `oldpassword` varchar(40) collate latin1_general_ci default NULL,
  `edited` datetime NOT NULL,
  `editor` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `person_id` (`person_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

categoryid
top
name