[2566560] | 1 | -- MySQL dump 10.10 |
---|
| 2 | -- |
---|
| 3 | -- Host: localhost Database: zephyr_log |
---|
| 4 | -- ------------------------------------------------------ |
---|
| 5 | -- Server version 5.0.26-log |
---|
| 6 | |
---|
| 7 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
---|
| 8 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
---|
| 9 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
---|
| 10 | /*!40101 SET NAMES utf8 */; |
---|
| 11 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
---|
| 12 | /*!40103 SET TIME_ZONE='+00:00' */; |
---|
| 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 */; |
---|
| 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 */; |
---|
| 17 | |
---|
| 18 | -- |
---|
| 19 | -- Table structure for table `messages` |
---|
| 20 | -- |
---|
| 21 | |
---|
| 22 | DROP TABLE IF EXISTS `messages`; |
---|
| 23 | CREATE TABLE `messages` ( |
---|
| 24 | `id` int(11) NOT NULL auto_increment, |
---|
| 25 | `sender` varchar(100) NOT NULL default '', |
---|
| 26 | `class` varchar(100) NOT NULL default '', |
---|
| 27 | `instance` varchar(100) NOT NULL default '', |
---|
| 28 | `opcode` varchar(100) default NULL, |
---|
| 29 | `sent` timestamp NOT NULL default CURRENT_TIMESTAMP, |
---|
| 30 | `received` timestamp NULL default NULL, |
---|
| 31 | `host` varchar(200) NOT NULL default '', |
---|
| 32 | `zsig` text NOT NULL, |
---|
| 33 | `body` text, |
---|
| 34 | PRIMARY KEY (`id`), |
---|
| 35 | KEY `index_class` (`class`), |
---|
| 36 | KEY `index_instance` (`instance`), |
---|
| 37 | KEY `index_class_instance` (`class`,`instance`), |
---|
| 38 | KEY `index_class_instance_sender` (`class`,`instance`,`sender`), |
---|
| 39 | KEY `index_class_sender` (`class`,`sender`), |
---|
| 40 | KEY `index_sender` (`sender`), |
---|
| 41 | KEY `index_host` (`host`), |
---|
| 42 | KEY `index_sent` (`sent`), |
---|
| 43 | FULLTEXT KEY `index_body` (`body`) |
---|
| 44 | ) ENGINE=MyISAM AUTO_INCREMENT=1517065 DEFAULT CHARSET=utf8; |
---|
| 45 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
---|
| 46 | |
---|
| 47 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
---|
| 48 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
---|
| 49 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
---|
| 50 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
---|
| 51 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
---|
| 52 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
---|
| 53 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
---|
| 54 | |
---|
| 55 | -- Dump completed on 2007-02-06 21:39:09 |
---|