db.mysql
changeset 2 1f7a59625863
parent 0 68aafeeb1559
child 12 c22d35b6dda7
equal deleted inserted replaced
1:2638ae657240 2:1f7a59625863
    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