12 /*!40103 SET TIME_ZONE='+00:00' */; |
12 /*!40103 SET TIME_ZONE='+00:00' */; |
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
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 |
|
18 -- |
|
19 -- Temporary table structure for view `header` |
|
20 -- |
|
21 |
|
22 DROP TABLE IF EXISTS `header`; |
|
23 /*!50001 DROP VIEW IF EXISTS `header`*/; |
|
24 /*!50001 CREATE TABLE `header` ( |
|
25 `message_id` int(11), |
|
26 `name` char(255), |
|
27 `idx` int(11), |
|
28 `content` text |
|
29 ) */; |
17 |
30 |
18 -- |
31 -- |
19 -- Table structure for table `header_field` |
32 -- Table structure for table `header_field` |
20 -- |
33 -- |
21 |
34 |
51 KEY `header_field_id` (`header_field_id`), |
64 KEY `header_field_id` (`header_field_id`), |
52 KEY `message_id` (`message_id`), |
65 KEY `message_id` (`message_id`), |
53 CONSTRAINT `message_header_ibfk_1` FOREIGN KEY (`header_field_id`) REFERENCES `header_field` (`id`) ON DELETE CASCADE, |
66 CONSTRAINT `message_header_ibfk_1` FOREIGN KEY (`header_field_id`) REFERENCES `header_field` (`id`) ON DELETE CASCADE, |
54 CONSTRAINT `message_header_ibfk_2` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE |
67 CONSTRAINT `message_header_ibfk_2` FOREIGN KEY (`message_id`) REFERENCES `message` (`id`) ON DELETE CASCADE |
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
68 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
69 |
|
70 -- |
|
71 -- Final view structure for view `header` |
|
72 -- |
|
73 |
|
74 /*!50001 DROP TABLE IF EXISTS `header`*/; |
|
75 /*!50001 DROP VIEW IF EXISTS `header`*/; |
|
76 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
|
77 /*!50013 DEFINER=`mail`@`%` SQL SECURITY DEFINER */ |
|
78 /*!50001 VIEW `header` AS select `message_header`.`message_id` AS `message_id`,`header_field`.`name` AS `name`,`message_header`.`idx` AS `idx`,`message_header`.`content` AS `content` from (`message_header` join `header_field` on((`header_field`.`id` = `message_header`.`header_field_id`))) order by `message_header`.`message_id`,`header_field`.`name`,`message_header`.`idx` */; |
56 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
79 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
57 |
80 |
58 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
81 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
59 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
82 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
60 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
83 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
61 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
84 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
62 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
85 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
63 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
86 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
64 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
87 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
65 |
88 |
66 -- Dump completed on 2008-07-20 20:54:13 |
89 -- Dump completed on 2008-07-20 21:24:42 |