Ticket #4639: weathersourcesettings.sql

-- MySQL dump 10.11
--
-- Host: localhost    Database: mythconverg
-- ------------------------------------------------------
-- Server version       5.0.54-log

/*!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 `weathersourcesettings`
--

DROP TABLE IF EXISTS `weathersourcesettings`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `weathersourcesettings` (
  `sourceid` int(10) unsigned NOT NULL auto_increment,
  `source_name` varchar(64) NOT NULL,
  `update_timeout` int(10) unsigned NOT NULL default '600',
  `retrieve_timeout` int(10) unsigned NOT NULL default '60',
  `hostname` varchar(255) default NULL,
  `path` varchar(255) default NULL,
  `author` varchar(128) default NULL,
  `version` varchar(32) default NULL,
  `email` varchar(255) default NULL,
  `types` mediumtext,
  PRIMARY KEY  (`sourceid`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `weathersourcesettings`
--

LOCK TABLES `weathersourcesettings` WRITE;
/*!40000 ALTER TABLE `weathersourcesettings` DISABLE KEYS */;
INSERT INTO `weathersourcesettings` VALUES (1,'Animated-Map-Download',600,30,'saruman','/usr/share/mythtv/mythweather/scripts/animaps.pl','Lucien Dunning','0.1','ldunning@gmail.com','amdesc,updatetime,animatedimage'),(6,'Map-Download',600,30,'saruman','/usr/share/mythtv/mythweather/scripts/maps.pl','Lucien Dunning','0.1','ldunning@gmail.com','smdesc,updatetime,map'),(7,'NDFD-6_day',900,30,'saruman','/usr/share/mythtv/mythweather/scripts/ndfd.pl','Lucien Dunning','0.1','ldunning@gmail.com','3dlocation,6dlocation,updatetime,high-0,high-1,high-2,high-3,high-4,high-5,low-0,low-1,low-2,low-3,low-4,low-5,icon-0,icon-1,icon-2,icon-3,icon-4,icon-5,date-0,date-1,date-2,date-3,date-4,date-5'),(10,'NWS-XML',900,30,'saruman','/usr/share/mythtv/mythweather/scripts/nwsxml.pl','Lucien Dunning','0.2','ldunning@gmail.com','cclocation,station_id,latitude,longitude,observation_time,observation_time_rfc822,weather,temperature_string,temp,relative_humidity,wind_string,wind_dir,wind_degrees,wind_speed,wind_gust,pressure_string,pressure,dewpoint_string,dewpoint,heat_index_string,heat_index,windchill_string,windchill,visibility,weather_icon,appt,wind_spdgst'),(11,'Animated-Map-Download',600,30,'gandalf','/usr/share/mythtv/mythweather/scripts/animaps.pl','Lucien Dunning','0.1','ldunning@gmail.com','amdesc,updatetime,animatedimage'),(16,'Map-Download',600,30,'gandalf','/usr/share/mythtv/mythweather/scripts/maps.pl','Lucien Dunning','0.1','ldunning@gmail.com','smdesc,updatetime,map'),(17,'NDFD-6_day',900,30,'gandalf','/usr/share/mythtv/mythweather/scripts/ndfd.pl','Lucien Dunning','0.1','ldunning@gmail.com','3dlocation,6dlocation,updatetime,high-0,high-1,high-2,high-3,high-4,high-5,low-0,low-1,low-2,low-3,low-4,low-5,icon-0,icon-1,icon-2,icon-3,icon-4,icon-5,date-0,date-1,date-2,date-3,date-4,date-5'),(18,'NDFD-18_Hour',900,30,'gandalf','/usr/share/mythtv/mythweather/scripts/ndfd18.pl','Lucien Dunning','0.1','ldunning@gmail.com','18hrlocation,updatetime,temp-0,temp-1,temp-2,temp-3,temp-4,temp-5,18icon-0,18icon-1,18icon-2,18icon-3,18icon-4,18icon-5,pop-0,pop-1,pop-2,pop-3,pop-4,pop-5,time-0,time-1,time-2,time-3,time-4,time-5'),(19,'NWS-Alerts',600,30,'gandalf','/usr/share/mythtv/mythweather/scripts/nws-alert.pl','Lucien Dunning','0.1','ldunning@gmail.com','swlocation,updatetime,alerts'),(20,'NWS-XML',900,30,'gandalf','/usr/share/mythtv/mythweather/scripts/nwsxml.pl','Lucien Dunning','0.2','ldunning@gmail.com','cclocation,station_id,latitude,longitude,observation_time,observation_time_rfc822,weather,temperature_string,temp,relative_humidity,wind_string,wind_dir,wind_degrees,wind_speed,wind_gust,pressure_string,pressure,dewpoint_string,dewpoint,heat_index_string,heat_index,windchill_string,windchill,visibility,weather_icon,appt,wind_spdgst');
/*!40000 ALTER TABLE `weathersourcesettings` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 */;

-- Dump completed on 2008-02-14  4:21:43