-- MySQL dump 10.10
--
-- Host: localhost    Database: cachelistener
-- ------------------------------------------------------
-- Server version	5.0.15-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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `directories`
--

DROP TABLE IF EXISTS `directories`;
CREATE TABLE `directories` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(200) NOT NULL default '',
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `SK_directories_1` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `directories`
--
-- ORDER BY:  ID


/*!40000 ALTER TABLE `directories` DISABLE KEYS */;
LOCK TABLES `directories` WRITE;
INSERT INTO `directories` VALUES (1,'C:\\Program Files\\ACE cache','2005-10-28 17:27:06');
UNLOCK TABLES;
/*!40000 ALTER TABLE `directories` ENABLE KEYS */;

--
-- Table structure for table `directories_files`
--

DROP TABLE IF EXISTS `directories_files`;
CREATE TABLE `directories_files` (
  `DirectoryID` int(10) unsigned NOT NULL,
  `FileID` int(10) unsigned NOT NULL,
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`DirectoryID`,`FileID`),
  KEY `SK_directories_files_1` (`DirectoryID`),
  KEY `SK_directories_files_2` (`FileID`),
  CONSTRAINT `FK_directories_files_1` FOREIGN KEY (`DirectoryID`) REFERENCES `directories` (`ID`),
  CONSTRAINT `FK_directories_files_2` FOREIGN KEY (`FileID`) REFERENCES `files` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `directories_files`
--
-- ORDER BY:  DirectoryID,FileID


/*!40000 ALTER TABLE `directories_files` DISABLE KEYS */;
LOCK TABLES `directories_files` WRITE;
INSERT INTO `directories_files` VALUES (1,1,'2005-10-28 17:27:07');
INSERT INTO `directories_files` VALUES (1,3,'2005-10-28 17:27:07');
UNLOCK TABLES;
/*!40000 ALTER TABLE `directories_files` ENABLE KEYS */;

--
-- Table structure for table `files`
--

DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(200) NOT NULL default '',
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `SK_files_1` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `files`
--
-- ORDER BY:  ID


/*!40000 ALTER TABLE `files` DISABLE KEYS */;
LOCK TABLES `files` WRITE;
INSERT INTO `files` VALUES (1,'common.settings.config','2005-10-28 17:27:07');
INSERT INTO `files` VALUES (2,'Test file.txt','2005-10-28 17:27:07');
INSERT INTO `files` VALUES (3,'Nothing particular.txt','2005-10-28 17:27:07');
UNLOCK TABLES;
/*!40000 ALTER TABLE `files` ENABLE KEYS */;

--
-- Table structure for table `servers`
--

DROP TABLE IF EXISTS `servers`;
CREATE TABLE `servers` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(50) NOT NULL default '',
  `IPAddress` varchar(30) NOT NULL default '',
  `PortNumber` int(10) unsigned NOT NULL default '0',
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `SK_servers_1` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servers`
--
-- ORDER BY:  ID


/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
LOCK TABLES `servers` WRITE;
INSERT INTO `servers` VALUES (1,'My laptop UK01WWKS192','172.22.51.148',25000,'2005-10-28 17:27:07');
INSERT INTO `servers` VALUES (2,'uk01drbd001 - UK development','172.22.7.107',25000,'2005-10-28 17:27:07');
INSERT INTO `servers` VALUES (3,'tla01416 - Southbury','172.20.80.131',25000,'2005-10-28 17:27:07');
INSERT INTO `servers` VALUES (4,'usbdyapp304 - Wilmington','10.21.144.50',25000,'2005-10-28 17:27:07');
INSERT INTO `servers` VALUES (5,'lamexap01 - Mexico','172.25.60.23',25000,'2005-10-28 17:27:07');
INSERT INTO `servers` VALUES (6,'ussbyapp337 - Southbury','10.16.161.43',25000,'2005-10-28 17:27:07');
INSERT INTO `servers` VALUES (7,'usvanapp301 - Richmond, Glen Allen','10.18.178.26',25000,'2005-10-28 17:27:07');
INSERT INTO `servers` VALUES (8,'uslibappv12 - US email and queue broker','172.20.25.218',25000,'2005-10-28 17:27:07');
INSERT INTO `servers` VALUES (9,'uslibintv27 - Unknown location','172.20.25.215',25000,'2005-10-28 17:27:07');
UNLOCK TABLES;
/*!40000 ALTER TABLE `servers` ENABLE KEYS */;

--
-- Table structure for table `servers_directories`
--

DROP TABLE IF EXISTS `servers_directories`;
CREATE TABLE `servers_directories` (
  `ServerID` int(10) unsigned NOT NULL,
  `DirectoryID` int(10) unsigned NOT NULL,
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ServerID`,`DirectoryID`),
  KEY `SK_servers_directories_1` (`ServerID`),
  KEY `SK_servers_directories_2` (`DirectoryID`),
  CONSTRAINT `FK_servers_directories_1` FOREIGN KEY (`ServerID`) REFERENCES `servers` (`ID`),
  CONSTRAINT `FK_servers_directories_2` FOREIGN KEY (`DirectoryID`) REFERENCES `directories` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servers_directories`
--
-- ORDER BY:  ServerID,DirectoryID


/*!40000 ALTER TABLE `servers_directories` DISABLE KEYS */;
LOCK TABLES `servers_directories` WRITE;
INSERT INTO `servers_directories` VALUES (1,1,'2005-10-28 17:27:08');
INSERT INTO `servers_directories` VALUES (2,1,'2005-10-28 17:27:08');
UNLOCK TABLES;
/*!40000 ALTER TABLE `servers_directories` ENABLE KEYS */;

--
-- Dumping routines for database 'cachelistener'
--
DELIMITER ;;
/*!50003 DROP PROCEDURE IF EXISTS `AddFile` */;;
/*!50003 SET SESSION SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER"*/;;
/*!50003 CREATE PROCEDURE `AddFile`(in filename varchar(100))
BEGIN

    -- One day I will grow up to be a procedure.

END */;;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
/*!50003 DROP PROCEDURE IF EXISTS `DeleteFileById` */;;
/*!50003 SET SESSION SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER"*/;;
/*!50003 CREATE PROCEDURE `DeleteFileById`(in fileid integer)
proc : BEGIN

    -- 2005/10/29 PHS. Original coding.



    -- Delete a record using the unique file id parameter.



    delete from files where id = fileid;

END proc */;;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
DELIMITER ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;