--- 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