/*
SQLyog Community Edition- MySQL GUI v6.03
Host - 4.1.22-standard-log : Database - joebeeso_showtracker
*********************************************************************
Server version : 4.1.22-standard-log
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `joebeeso_showtracker`;

USE `joebeeso_showtracker`;

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

/*Table structure for table `stEvents` */

DROP TABLE IF EXISTS `stEvents`;

CREATE TABLE `stEvents` (
  `eventid` int(11) NOT NULL auto_increment,
  `artistid` int(11) default NULL,
  `date` text,
  `venue` text,
  `purchase` text,
  `zipcode` varchar(10) default NULL,
  PRIMARY KEY  (`eventid`)
) ENGINE=MyISAM AUTO_INCREMENT=23959 DEFAULT CHARSET=latin1;

/*Table structure for table `stRatings` */

DROP TABLE IF EXISTS `stRatings`;

CREATE TABLE `stRatings` (
  `userid` int(6) default NULL,
  `artistid` int(11) default NULL,
  `rating` int(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `stSimilar` */

DROP TABLE IF EXISTS `stSimilar`;

CREATE TABLE `stSimilar` (
  `artistid` int(6) default NULL,
  `linkartistid` int(6) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `stZipData` */

DROP TABLE IF EXISTS `stZipData`;

CREATE TABLE `stZipData` (
  `zip` int(5) default NULL,
  `lat` varchar(10) default NULL,
  `lon` varchar(10) default NULL,
  `city` varchar(30) default NULL,
  `state` char(2) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;