equal
deleted
inserted
replaced
38 |
38 |
39 DROP TABLE IF EXISTS `eht_message`; |
39 DROP TABLE IF EXISTS `eht_message`; |
40 /*!50001 DROP VIEW IF EXISTS `eht_message`*/; |
40 /*!50001 DROP VIEW IF EXISTS `eht_message`*/; |
41 /*!50001 CREATE TABLE `eht_message` ( |
41 /*!50001 CREATE TABLE `eht_message` ( |
42 `message_id` bigint(20), |
42 `message_id` bigint(20), |
|
43 `timestamp` timestamp, |
43 `mandant` int(11), |
44 `mandant` int(11), |
44 `typ` int(11), |
45 `typ` int(11), |
45 `vorgang` int(11), |
46 `vorgang` int(11), |
46 `content` longtext |
47 `content` longtext |
47 ) */; |
48 ) */; |
104 |
105 |
105 /*!50001 DROP TABLE IF EXISTS `eht_message`*/; |
106 /*!50001 DROP TABLE IF EXISTS `eht_message`*/; |
106 /*!50001 DROP VIEW IF EXISTS `eht_message`*/; |
107 /*!50001 DROP VIEW IF EXISTS `eht_message`*/; |
107 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
108 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
108 /*!50013 DEFINER=`mail`@`%` SQL SECURITY DEFINER */ |
109 /*!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 /*!50001 VIEW `eht_message` AS select `eht`.`message_id` AS `message_id`,`message`.`timestamp` AS `timestamp`,`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 |
111 -- |
112 -- |
112 -- Final view structure for view `header` |
113 -- Final view structure for view `header` |
113 -- |
114 -- |
114 |
115 |
125 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
126 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
126 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
127 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
127 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
128 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
128 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
129 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
129 |
130 |
130 -- Dump completed on 2008-08-20 14:45:22 |
131 -- Dump completed on 2008-08-22 15:33:33 |