db.mysql
brancheht
changeset 12 c22d35b6dda7
parent 2 1f7a59625863
child 14 2865079a223c
--- a/db.mysql	Mon Jul 21 12:54:11 2008 +0000
+++ b/db.mysql	Wed Aug 20 14:23:02 2008 +0000
@@ -2,7 +2,7 @@
 --
 -- Host: schnuffi    Database: mail
 -- ------------------------------------------------------
--- Server version	5.0.32-Debian_7etch6-log
+-- Server version	5.0.32-Debian_7etch6
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -16,13 +16,27 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
 --
+-- Table structure for table `eht`
+--
+
+DROP TABLE IF EXISTS `eht`;
+CREATE TABLE `eht` (
+  `message_id` bigint(20) default NULL,
+  `mandant` int(11) default NULL,
+  `typ` int(11) default NULL,
+  `vorgang` int(11) default NULL,
+  KEY `message_id` (`message_id`),
+  CONSTRAINT `eht_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
 -- Temporary table structure for view `header`
 --
 
 DROP TABLE IF EXISTS `header`;
 /*!50001 DROP VIEW IF EXISTS `header`*/;
 /*!50001 CREATE TABLE `header` (
-  `message_id` int(11),
+  `message_id` bigint(20),
   `name` char(255),
   `idx` int(11),
   `content` text
@@ -45,7 +59,7 @@
 
 DROP TABLE IF EXISTS `message`;
 CREATE TABLE `message` (
-  `id` int(11) NOT NULL auto_increment,
+  `id` bigint(20) NOT NULL auto_increment,
   `content` longtext,
   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   KEY `id` (`id`)
@@ -57,7 +71,7 @@
 
 DROP TABLE IF EXISTS `message_header`;
 CREATE TABLE `message_header` (
-  `message_id` int(11) NOT NULL,
+  `message_id` bigint(20) NOT NULL,
   `header_field_id` int(11) NOT NULL,
   `idx` int(11) default NULL,
   `content` text,
@@ -86,4 +100,4 @@
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2008-07-20 21:24:42
+-- Dump completed on 2008-08-20 14:18:22