Ticket #4639: weathersourcesettings.new.sql

File weathersourcesettings.new.sql, 5.1 KB (added by eric.bosch@…, 13 years ago)

WeatherSourcesettings? after truncating and reconfiguring mythweather

Line 
1-- MySQL dump 10.11
2--
3-- Host: localhost    Database: mythconverg
4-- ------------------------------------------------------
5-- Server version       5.0.54-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 `weathersourcesettings`
20--
21
22DROP TABLE IF EXISTS `weathersourcesettings`;
23SET @saved_cs_client     = @@character_set_client;
24SET character_set_client = utf8;
25CREATE TABLE `weathersourcesettings` (
26  `sourceid` int(10) unsigned NOT NULL auto_increment,
27  `source_name` varchar(64) NOT NULL,
28  `update_timeout` int(10) unsigned NOT NULL default '600',
29  `retrieve_timeout` int(10) unsigned NOT NULL default '60',
30  `hostname` varchar(255) default NULL,
31  `path` varchar(255) default NULL,
32  `author` varchar(128) default NULL,
33  `version` varchar(32) default NULL,
34  `email` varchar(255) default NULL,
35  `types` mediumtext,
36  PRIMARY KEY  (`sourceid`)
37) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
38SET character_set_client = @saved_cs_client;
39
40--
41-- Dumping data for table `weathersourcesettings`
42--
43
44LOCK TABLES `weathersourcesettings` WRITE;
45/*!40000 ALTER TABLE `weathersourcesettings` DISABLE KEYS */;
46INSERT INTO `weathersourcesettings` VALUES (21,'ENVCAN',900,30,'saruman','/usr/share/mythtv/mythweather/scripts/ca_envcan/envcan.pl','Joe Ripley','0.4','vitaminjoe@gmail.com','cclocation,station_id,copyright,observation_time,observation_time_rfc822,weather,temp,relative_humidity,wind_dir,wind_degrees,wind_speed,wind_gust,pressure,dewpoint,heat_index,windchill,visibility,weather_icon,appt,wind_spdgst,3dlocation,6dlocation,date-0,icon-0,low-0,high-0,date-1,icon-1,low-1,high-1,date-2,icon-2,low-2,high-2,updatetime,date-3,icon-3,low-3,high-3,date-4,icon-4,low-4,high-4,date-5,icon-5,low-5,high-5'),(22,'ENVCAN-Animated-Map',600,30,'saruman','/usr/share/mythtv/mythweather/scripts/ca_envcan/envcan_animaps.pl','Joe Ripley','0.3','vitaminjoe@gmail.com','amdesc,updatetime,animatedimage'),(23,'BBC-Current-XML',7200,30,'saruman','/usr/share/mythtv/mythweather/scripts/uk_bbc/bbccurrentxml.pl','Stuart Morgan','0.1','stuart@tase.co.uk','cclocation,station_id,copyright,observation_time,weather,temp,relative_humidity,wind_dir,pressure,visibility,weather_icon,appt,wind_spdgst'),(24,'BBC-3day-XML',21600,30,'saruman','/usr/share/mythtv/mythweather/scripts/uk_bbc/bbcthreedayxml.pl','Stuart Morgan','0.1','stuart@tase.co.uk','3dlocation,station_id,copyright,weather_icon,date-0,icon-0,low-0,high-0,date-1,icon-1,low-1,high-1,date-2,icon-2,low-2,high-2,updatetime'),(25,'Animated-Map-Download',600,30,'saruman','/usr/share/mythtv/mythweather/scripts/us_nws/animaps.pl','Lucien Dunning','0.1','ldunning@gmail.com','amdesc,updatetime,animatedimage'),(26,'Map-Download',600,30,'saruman','/usr/share/mythtv/mythweather/scripts/us_nws/maps.pl','Lucien Dunning','0.1','ldunning@gmail.com','smdesc,updatetime,map'),(27,'NDFD-6_day',900,30,'saruman','/usr/share/mythtv/mythweather/scripts/us_nws/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'),(28,'NDFD-18_Hour',900,30,'saruman','/usr/share/mythtv/mythweather/scripts/us_nws/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'),(29,'NWS-Alerts',600,30,'saruman','/usr/share/mythtv/mythweather/scripts/us_nws/nws-alert.pl','Lucien Dunning','0.1','ldunning@gmail.com','swlocation,updatetime,alerts'),(30,'NWS-XML',900,30,'saruman','/usr/share/mythtv/mythweather/scripts/us_nws/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');
47/*!40000 ALTER TABLE `weathersourcesettings` ENABLE KEYS */;
48UNLOCK TABLES;
49/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
50
51/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
52/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
53/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
54/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
55/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
56/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
57/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
58
59-- Dump completed on 2008-02-14  4:40:18