summaryrefslogtreecommitdiff
path: root/DB
diff options
context:
space:
mode:
authorcookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>2007-10-09 22:05:16 +0000
committercookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>2007-10-09 22:05:16 +0000
commit17873f57b518849ff2aea4328abb8768abd1fdc5 (patch)
treec8bef1b034213cc124b91641dc5695443048ac74 /DB
parentabc55d6bf4820fb9926bc558616ea50b6fa66f49 (diff)
DB/Messages.sql vergessen
git-svn-id: svn://svn.cccv.de/engel-system@239 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'DB')
-rw-r--r--DB/Messages.sql28
1 files changed, 28 insertions, 0 deletions
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';
+