-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 02:40 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- Database: `bmcforu_transfer`
--

-- --------------------------------------------------------

--
-- Table structure for table `radio`
--

CREATE TABLE IF NOT EXISTS `radio` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `r_iscat` varchar(5) NOT NULL DEFAULT 'no',
  `r_name` varchar(255) NOT NULL DEFAULT '',
  `r_location` varchar(255) NOT NULL DEFAULT '',
  `r_forcat` int(15) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=44 ;

--
-- Dumping data for table `radio`
--

INSERT INTO `radio` (`rid`, `r_iscat`, `r_name`, `r_location`, `r_forcat`) VALUES
(1, 'yes', 'Alternative Rock', '', 0),
(12, 'no', 'KNAC', 'http://release.theplatform.com/content.select?pid=_Vx9pkxpFxxCRGWMQ2FKCqW70iuLi6Mn&UserName=knaclive', 1),
(9, 'no', 'A.I.R. Radio', 'http://130.49.24.169:1015/listen.pls', 1),
(7, 'no', 'Idobi', 'http://www.idobi.com/radio/iradio.rm', 1),
(8, 'no', 'American Radio Network', 'http://www.myamericanradio.net/audio/heavymetalhigh/preload.asx', 1),
(13, 'yes', 'Country', '', 0),
(14, 'yes', 'Rap/Hip Hop/R&B', '', 0),
(15, 'no', 'Kiss 100 (London)', 'http://www.emapdigitalradio.com/emapdigitalradio/metafiles/kiss.asx', 14),
(16, 'yes', 'Oldies', '', 0),
(17, 'yes', 'Rock', '', 0),
(18, 'yes', 'Talk', '', 0),
(19, 'yes', 'Jazz', '', 0),
(20, 'yes', 'Classical', '', 0),
(21, 'yes', 'Religious', '', 0),
(22, 'yes', 'TV Stations', '', 0),
(23, 'no', 'Bloomberg TV', 'http://www.bloomberg.com/streams/video/LiveBTV56.asx', 22),
(24, 'yes', 'Adult Contemporary', '', 0),
(25, 'no', 'KBIG 104.3 (Los Angeles) -"Upbeat Mix 80s 90s & Today"', 'http://ccdig.liquidviewer.com/kbig', 24),
(26, 'no', 'CNN', 'http://www.cnn.com/audio/radio/liveaudio.asx', 18),
(27, 'yes', 'Heavy Metal', '', 0),
(28, 'no', 'HoTMetaL', 'http://www.hotmetalradio.com/audio/music.asx', 27),
(29, 'no', 'WBTS 99.5 (Athens, GA) - "95.5 the Beat"', 'mms://66.250.188.18/WBTS_FM', 24),
(30, 'no', 'WKLS 96.1 (Atlanta, GA) - "96 Rock the Rock Station"', 'http://ccdig.liquidviewer.com/wkls', 17),
(31, 'no', 'WNNX 99.7 (Atlanta, GA) - "New Rock 99X"', 'http://www.streamaudio.com/stations/asx/wnnx_fm.asx', 1),
(32, 'no', 'WBZT 96.7 (Mauldin, SC) - "The Buzzard"', 'mms://66.250.188.16/wbzt_fm', 17),
(33, 'no', 'KLOU 103.3 (St. Louis, MO) - "Oldies 103.3 Clue"', 'http://ccri.eonstreams.com/ccri_mo_stlouis_klou_fm.asf', 16),
(34, 'no', 'KONO 860 (San Antonio, TX) - "Co-No 101 Goodtime Oldies"', 'http://66.250.188.14/KONO_FM', 16),
(35, 'no', 'WAHT 1560 (Clemson, SC) - "Carolina Gold - Bringing the Beach Upstate"', 'http://stream.netro.ca/waht', 16),
(36, 'no', 'WOLL 105.5 (Melbourne, FL)', 'http://ccri.eonstreams.com/ccri_fl_westpalmbeach_woll_fm.asf', 16),
(37, 'no', 'WIVK 107.7 (Knoxville, TN) - "Knoxville''s Country Station"', 'mms://mmslb.eonstreams.com/citadelwivk.asf', 13),
(38, 'no', 'WWSR 105.7 (Rockwood, TN)', 'http://live.str3am.com:2630/listen.pls', 13),
(39, 'no', 'WGRD 97.9 (Grand Rapids, MI) - "New Rock 97.9"', 'http://www.streamaudio.com/stations/asx/WGRD_FM.asx', 17),
(40, 'no', 'WRIF 101.1 (Detroit, MI) - "101 Riff Rocks"', 'http://tuner1.dc1.sonixtream.com/playlists/wrif/wrifwrif.asx', 17),
(41, 'no', 'WPLA 93.3 (Callahan, FL) - "Power Planet Radio 93.3"', 'http://ccdig.liquidviewer.com/wpla', 1),
(42, 'no', 'WMXQ 102.9 (Jacksonville, FL)', 'mms://66.250.188.18/WMXQ_FM', 43),
(43, 'yes', '80''s', '', 0);