From 946c230e6f8e04c7dd8f92ca3190a51ac220f0ca Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Sat, 11 Jun 2011 18:09:20 +0200 Subject: directory renames and cleanup --- db/Messages.sql | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 db/Messages.sql (limited to 'db/Messages.sql') diff --git a/db/Messages.sql b/db/Messages.sql new file mode 100644 index 00000000..cc2c3b63 --- /dev/null +++ b/db/Messages.sql @@ -0,0 +1,28 @@ +-- phpMyAdmin SQL Dump +-- version 2.9.1.1-Debian-4 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Erstellungszeit: 09. Oktober 2007 um 22:04 +-- Server Version: 5.0.32 +-- PHP-Version: 5.2.0-8+etch7 +-- +-- Datenbank: `Himmel` +-- + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `Messages` +-- + +DROP TABLE IF EXISTS `Messages`; +CREATE TABLE IF NOT EXISTS `Messages` ( + `Datum` datetime NOT NULL default '0000-00-00 00:00:00', + `SUID` int(11) NOT NULL default '0', + `RUID` int(11) NOT NULL default '0', + `isRead` char(1) NOT NULL default 'N', + `Text` text NOT NULL, + PRIMARY KEY (`Datum`,`SUID`,`RUID`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Fuers interen Communikationssystem'; + -- cgit v1.2.3-70-g09d2