1 -- MySQL dump 10.11 |
1 -- MySQL dump 10.11 |
2 -- |
2 -- |
3 -- Host: schnuffi Database: mail |
3 -- Host: schnuffi Database: mail |
4 -- ------------------------------------------------------ |
4 -- ------------------------------------------------------ |
5 -- Server version 5.0.32-Debian_7etch6-log |
5 -- Server version 5.0.32-Debian_7etch6 |
6 |
6 |
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
10 /*!40101 SET NAMES utf8 */; |
10 /*!40101 SET NAMES utf8 */; |
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
17 |
17 |
18 -- |
18 -- |
|
19 -- Table structure for table `eht` |
|
20 -- |
|
21 |
|
22 DROP TABLE IF EXISTS `eht`; |
|
23 CREATE TABLE `eht` ( |
|
24 `message_id` bigint(20) default NULL, |
|
25 `mandant` int(11) default NULL, |
|
26 `typ` int(11) default NULL, |
|
27 `vorgang` int(11) default NULL, |
|
28 KEY `message_id` (`message_id`), |
|
29 CONSTRAINT `eht_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE |
|
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
31 |
|
32 -- |
19 -- Temporary table structure for view `header` |
33 -- Temporary table structure for view `header` |
20 -- |
34 -- |
21 |
35 |
22 DROP TABLE IF EXISTS `header`; |
36 DROP TABLE IF EXISTS `header`; |
23 /*!50001 DROP VIEW IF EXISTS `header`*/; |
37 /*!50001 DROP VIEW IF EXISTS `header`*/; |
24 /*!50001 CREATE TABLE `header` ( |
38 /*!50001 CREATE TABLE `header` ( |
25 `message_id` int(11), |
39 `message_id` bigint(20), |
26 `name` char(255), |
40 `name` char(255), |
27 `idx` int(11), |
41 `idx` int(11), |
28 `content` text |
42 `content` text |
29 ) */; |
43 ) */; |
30 |
44 |
43 -- Table structure for table `message` |
57 -- Table structure for table `message` |
44 -- |
58 -- |
45 |
59 |
46 DROP TABLE IF EXISTS `message`; |
60 DROP TABLE IF EXISTS `message`; |
47 CREATE TABLE `message` ( |
61 CREATE TABLE `message` ( |
48 `id` int(11) NOT NULL auto_increment, |
62 `id` bigint(20) NOT NULL auto_increment, |
49 `content` longtext, |
63 `content` longtext, |
50 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
64 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
51 KEY `id` (`id`) |
65 KEY `id` (`id`) |
52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
66 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
53 |
67 |
55 -- Table structure for table `message_header` |
69 -- Table structure for table `message_header` |
56 -- |
70 -- |
57 |
71 |
58 DROP TABLE IF EXISTS `message_header`; |
72 DROP TABLE IF EXISTS `message_header`; |
59 CREATE TABLE `message_header` ( |
73 CREATE TABLE `message_header` ( |
60 `message_id` int(11) NOT NULL, |
74 `message_id` bigint(20) NOT NULL, |
61 `header_field_id` int(11) NOT NULL, |
75 `header_field_id` int(11) NOT NULL, |
62 `idx` int(11) default NULL, |
76 `idx` int(11) default NULL, |
63 `content` text, |
77 `content` text, |
64 KEY `header_field_id` (`header_field_id`), |
78 KEY `header_field_id` (`header_field_id`), |
65 KEY `message_id` (`message_id`), |
79 KEY `message_id` (`message_id`), |
84 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
98 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
85 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
99 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
86 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
100 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
87 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
101 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
88 |
102 |
89 -- Dump completed on 2008-07-20 21:24:42 |
103 -- Dump completed on 2008-08-20 14:18:22 |