-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.14-beta-community-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema testupdate
--

CREATE DATABASE IF NOT EXISTS testupdate;
USE testupdate;

--
-- Temporary table structure for view `tobeidentifiedmessages`
--
DROP TABLE IF EXISTS `tobeidentifiedmessages`;
DROP VIEW IF EXISTS `tobeidentifiedmessages`;
CREATE TABLE `tobeidentifiedmessages` (
  `MessageID` int(10),
  `Machine` varchar(16),
  `Time` varchar(14),
  `CPU` smallint(5),
  `Name` int(10),
  `SubSystem` varchar(24),
  `Severity` smallint(5),
  `Description` text,
  `OpComment` varchar(255),
  `ChangeSequence` int(10),
  `RecordId` int(10),
  `SourceFileID` int(10),
  `IDNo` varchar(6),
  `User` varchar(16),
  `FullMessageRec` text,
  `MyID` int(10),
  `RecDate` datetime,
  `RecStatus` smallint(5)
);

--
-- Definition of table `messages`
--

DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
  `MessageID` int(10) DEFAULT NULL,
  `Machine` varchar(16) DEFAULT NULL,
  `Time` varchar(14) DEFAULT NULL,
  `CPU` smallint(5) DEFAULT NULL,
  `Name` int(10) DEFAULT NULL,
  `SubSystem` varchar(24) DEFAULT NULL,
  `Severity` smallint(5) DEFAULT NULL,
  `Description` text,
  `OpComment` varchar(255) DEFAULT NULL,
  `ChangeSequence` int(10) DEFAULT NULL,
  `RecordId` int(10) NOT NULL AUTO_INCREMENT,
  `SourceFileID` int(10) DEFAULT NULL,
  `IDNo` varchar(6) DEFAULT NULL,
  `User` varchar(16) DEFAULT NULL,
  `FullMessageRec` text,
  `MyID` int(10) DEFAULT NULL,
  `RecDate` datetime DEFAULT NULL,
  `RecStatus` smallint(5) DEFAULT NULL,
  PRIMARY KEY (`RecordId`),
  KEY `MyID` (`MyID`),
  KEY `IDNo` (`IDNo`),
  KEY `MessageID` (`MessageID`),
  KEY `SourceFileID` (`SourceFileID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messages`
--

/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` (`MessageID`,`Machine`,`Time`,`CPU`,`Name`,`SubSystem`,`Severity`,`Description`,`OpComment`,`ChangeSequence`,`RecordId`,`SourceFileID`,`IDNo`,`User`,`FullMessageRec`,`MyID`,`RecDate`,`RecStatus`) VALUES 
 (1001,'machine-1',NULL,1,NULL,'myapplication',5,'The monkey has a nice place in our zoo, with a verry nice view on all preaple comming to visit him and his beatifull family. ',NULL,NULL,1,24,NULL,'Louis','The monkey has a nice place in our zoo, with a verry nice view on all preaple comming to visit him and his beatifull family. ',0,'2007-01-30 00:00:00',NULL),
 (1002,'machine-2',NULL,0,NULL,'myapplication',2,'The monkey has a nice place in our zoo, with a verry nice view on all preaple comming to visit him and his beatifull family. ',NULL,NULL,2,23,NULL,'Louis','The monkey has a nice place in our zoo, with a verry nice view on all preaple comming to visit him and his beatifull family. ',0,'2007-01-30 00:00:00',NULL),
 (1003,'machine-1',NULL,0,NULL,'myapplication',2,'The monkey has a nice place in our zoo, with a verry nice view on all preaple comming to visit him and his beatifull family. ',NULL,NULL,3,24,NULL,'Louis','The monkey has a nice place in our zoo, with a verry nice view on all preaple comming to visit him and his beatifull family. ',1,'2007-01-30 00:00:00',NULL);
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;


--
-- Definition of view `tobeidentifiedmessages`
--

DROP TABLE IF EXISTS `tobeidentifiedmessages`;
DROP VIEW IF EXISTS `tobeidentifiedmessages`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tobeidentifiedmessages` AS select `messages`.`MessageID` AS `MessageID`,`messages`.`Machine` AS `Machine`,`messages`.`Time` AS `Time`,`messages`.`CPU` AS `CPU`,`messages`.`Name` AS `Name`,`messages`.`SubSystem` AS `SubSystem`,`messages`.`Severity` AS `Severity`,`messages`.`Description` AS `Description`,`messages`.`OpComment` AS `OpComment`,`messages`.`ChangeSequence` AS `ChangeSequence`,`messages`.`RecordId` AS `RecordId`,`messages`.`SourceFileID` AS `SourceFileID`,`messages`.`IDNo` AS `IDNo`,`messages`.`User` AS `User`,`messages`.`FullMessageRec` AS `FullMessageRec`,`messages`.`MyID` AS `MyID`,`messages`.`RecDate` AS `RecDate`,`messages`.`RecStatus` AS `RecStatus` from `messages` where (`messages`.`MyID` = 0);



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;