CREATE DATABASE  IF NOT EXISTS `airscribe` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `airscribe`;
-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: localhost    Database: airscribe
-- ------------------------------------------------------
-- Server version	5.5.27

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

DROP TABLE IF EXISTS `genres`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `genres` (
  `idgenres` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `genre` varchar(30) DEFAULT NULL,
  `genrecode` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`idgenres`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `copy`
--

DROP TABLE IF EXISTS `copy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `copy` (
  `idcopy` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` varchar(13) DEFAULT NULL,
  `catch` varchar(25) DEFAULT NULL,
  `headline` varchar(55) DEFAULT NULL,
  `detail` varchar(55) DEFAULT NULL,
  `bodyair` longtext,
  `tx` varchar(3) DEFAULT NULL,
  `genre` varchar(20) DEFAULT NULL,
  `category` varchar(15) DEFAULT NULL,
  `author` varchar(25) DEFAULT NULL,
  `audiofilename` varchar(45) DEFAULT NULL,
  `audiotitle` varchar(45) DEFAULT NULL,
  `audiodur` varchar(5) DEFAULT NULL,
  `imagefilename` varchar(255) DEFAULT NULL,
  `webfile` varchar(1) DEFAULT NULL,
  `bodyweb` longtext,
  `xmltimeid` varchar(20) DEFAULT NULL,
  `revisionid` varchar(3) DEFAULT NULL,
  `filetime` varchar(8) DEFAULT NULL,
  `current` varchar(1) DEFAULT NULL,
  `audiooutcue` varchar(30) DEFAULT NULL,
  `tags` varchar(250) DEFAULT ' ',
  `audiopath` varchar(250) DEFAULT '',
  PRIMARY KEY (`idcopy`)
) ENGINE=MyISAM AUTO_INCREMENT=325145 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `workstations`
--

DROP TABLE IF EXISTS `workstations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workstations` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `NAME` varchar(40) NOT NULL,
  `SITE` varchar(40) DEFAULT '',
  `USER` varchar(40) DEFAULT '',
  `LOGBULL` tinyint(1) NOT NULL DEFAULT '0',
  `EDITORFONT` varchar(30) DEFAULT '',
  `PRINTSTYLE` varchar(5) DEFAULT '',
  `WORDCOUNT` varchar(5) DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `idusers` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `firstname` varchar(30) DEFAULT '',
  `lastname` varchar(30) DEFAULT '',
  `password` blob NOT NULL,
  `permissions` longtext,
  `prefs` longtext,
  PRIMARY KEY (`idusers`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `stations`
--

DROP TABLE IF EXISTS `stations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stations` (
  `idstations` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `code` varchar(3) NOT NULL,
  `type` varchar(3) NOT NULL,
  `keep` varchar(5) DEFAULT '0',
  `feedtype` varchar(6) DEFAULT '',
  `method` varchar(6) DEFAULT '',
  `authuser` varchar(40) DEFAULT '',
  `authpass` varchar(40) DEFAULT '',
  `url` varchar(255) DEFAULT '',
  `folder` varchar(25) DEFAULT '',
  `port` varchar(5) DEFAULT '',
  `audio` varchar(3) DEFAULT '',
  `checki` varchar(3) DEFAULT NULL,
  `twitterid` varchar(25) DEFAULT '',
  `twitterpassword` varchar(20) DEFAULT '',
  `twitterurl` varchar(50) DEFAULT '',
  `bullend` varchar(250) DEFAULT '--END OF BULLETIN--',
  PRIMARY KEY (`idstations`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pp`
--

DROP TABLE IF EXISTS `pp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pp` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `STATION` varchar(3) NOT NULL,
  `RENDER` varchar(15) NOT NULL,
  `FTPS` varchar(50) DEFAULT '',
  `FTPU` varchar(50) DEFAULT '',
  `FTPP` varchar(50) DEFAULT '',
  `FTPD` varchar(50) DEFAULT '',
  `FTPPORT` int(10) unsigned DEFAULT '21',
  `FTPPASV` int(10) unsigned DEFAULT '0',
  `SMTP` varchar(50) DEFAULT '',
  `EMAIL` varchar(50) DEFAULT '',
  `NAME` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `broadcast`
--

DROP TABLE IF EXISTS `broadcast`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `broadcast` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `DATE` datetime NOT NULL,
  `LIST` longtext NOT NULL,
  `TX` varchar(3) NOT NULL,
  `TAGS` longtext NOT NULL,
  `TEXT` longtext NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1454 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `images`
--

DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images` (
  `idimages` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `content` longblob NOT NULL,
  PRIMARY KEY (`idimages`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `audio`
--

DROP TABLE IF EXISTS `audio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audio` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `CODE` varchar(3) NOT NULL,
  `URL` varchar(255) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bulletin`
--

DROP TABLE IF EXISTS `bulletin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bulletin` (
  `idbulletin` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `NAME` varchar(20) NOT NULL,
  `LIST` longtext,
  `STATION` varchar(50) NOT NULL,
  `FORCEUPDATE` varchar(1) DEFAULT NULL,
  `UPDATENOTE` varchar(50) DEFAULT NULL,
  `UPDATED` datetime NOT NULL,
  PRIMARY KEY (`idbulletin`)
) ENGINE=MyISAM AUTO_INCREMENT=8025 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `idcategories` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(15) NOT NULL,
  PRIMARY KEY (`idcategories`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2013-09-05 23:44:38
