db.mysql
brancheht
changeset 18 806166bd5332
parent 15 2812b7e2b26f
--- 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