diff -r cfaaf0096975 -r 806166bd5332 db.mysql --- a/db.mysql Wed Aug 20 14:53:03 2008 +0000 +++ b/db.mysql Fri Aug 22 15:54:00 2008 +0000 @@ -40,6 +40,7 @@ /*!50001 DROP VIEW IF EXISTS `eht_message`*/; /*!50001 CREATE TABLE `eht_message` ( `message_id` bigint(20), + `timestamp` timestamp, `mandant` int(11), `typ` int(11), `vorgang` int(11), @@ -106,7 +107,7 @@ /*!50001 DROP VIEW IF EXISTS `eht_message`*/; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`mail`@`%` SQL SECURITY DEFINER */ -/*!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`))) */; +/*!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`))) */; -- -- Final view structure for view `header` @@ -127,4 +128,4 @@ /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2008-08-20 14:45:22 +-- Dump completed on 2008-08-22 15:33:33