# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Erstellungszeit: 07. September 2004 um 14:50
# Server Version: 3.23.57
# PHP-Version: 4.3.8
# 
# Datenbank: `datasink`
# 

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `item`
#

CREATE TABLE `item` (
  `cid` varchar(32) NOT NULL default '',
  `owner` varchar(255) NOT NULL default '',
  `jid` varchar(255) NOT NULL default '',
  `name` varchar(255) default NULL,
  `start` datetime NOT NULL default '0000-00-00 00:00:00',
  `end` datetime default NULL,
  PRIMARY KEY  (`cid`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `message`
#

CREATE TABLE `message` (
  `item_cid` varchar(32) NOT NULL default '',
  `dir` enum('to','from') NOT NULL default 'to',
  `body` blob NOT NULL,
  `cDate` timestamp(14) NOT NULL
) TYPE=MyISAM;