24 `message_id` bigint(20) default NULL, |
24 `message_id` bigint(20) default NULL, |
25 `mandant` int(11) default NULL, |
25 `mandant` int(11) default NULL, |
26 `typ` int(11) default NULL, |
26 `typ` int(11) default NULL, |
27 `vorgang` int(11) default NULL, |
27 `vorgang` int(11) default NULL, |
28 KEY `message_id` (`message_id`), |
28 KEY `message_id` (`message_id`), |
|
29 KEY `vorgang` (`vorgang`), |
|
30 KEY `typ` (`typ`), |
|
31 KEY `mandant` (`mandant`), |
29 CONSTRAINT `eht_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE |
32 CONSTRAINT `eht_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE |
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
33 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
34 |
|
35 -- |
|
36 -- Temporary table structure for view `eht_message` |
|
37 -- |
|
38 |
|
39 DROP TABLE IF EXISTS `eht_message`; |
|
40 /*!50001 DROP VIEW IF EXISTS `eht_message`*/; |
|
41 /*!50001 CREATE TABLE `eht_message` ( |
|
42 `message_id` bigint(20), |
|
43 `mandant` int(11), |
|
44 `typ` int(11), |
|
45 `vorgang` int(11), |
|
46 `content` longtext |
|
47 ) */; |
31 |
48 |
32 -- |
49 -- |
33 -- Temporary table structure for view `header` |
50 -- Temporary table structure for view `header` |
34 -- |
51 -- |
35 |
52 |
80 CONSTRAINT `message_header_ibfk_1` FOREIGN KEY (`header_field_id`) REFERENCES `header_field` (`id`) ON DELETE CASCADE, |
97 CONSTRAINT `message_header_ibfk_1` FOREIGN KEY (`header_field_id`) REFERENCES `header_field` (`id`) ON DELETE CASCADE, |
81 CONSTRAINT `message_header_ibfk_2` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE |
98 CONSTRAINT `message_header_ibfk_2` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE |
82 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
99 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
83 |
100 |
84 -- |
101 -- |
|
102 -- Final view structure for view `eht_message` |
|
103 -- |
|
104 |
|
105 /*!50001 DROP TABLE IF EXISTS `eht_message`*/; |
|
106 /*!50001 DROP VIEW IF EXISTS `eht_message`*/; |
|
107 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
|
108 /*!50013 DEFINER=`mail`@`%` SQL SECURITY DEFINER */ |
|
109 /*!50001 VIEW `eht_message` AS select `eht`.`message_id` AS `message_id`,`eht`.`mandant` AS `mandant`,`eht`.`typ` AS `typ`,`eht`.`vorgang` AS `vorgang`,`message`.`content` AS `content` from (`eht` left join `message` on((`eht`.`message_id` = `message`.`id`))) */; |
|
110 |
|
111 -- |
85 -- Final view structure for view `header` |
112 -- Final view structure for view `header` |
86 -- |
113 -- |
87 |
114 |
88 /*!50001 DROP TABLE IF EXISTS `header`*/; |
115 /*!50001 DROP TABLE IF EXISTS `header`*/; |
89 /*!50001 DROP VIEW IF EXISTS `header`*/; |
116 /*!50001 DROP VIEW IF EXISTS `header`*/; |
98 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
125 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
99 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
126 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
100 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
127 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
101 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
128 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
102 |
129 |
103 -- Dump completed on 2008-08-20 14:18:22 |
130 -- Dump completed on 2008-08-20 14:41:50 |