Part of Slepp's Projects — Pastebin — TURL — Imagebin — Filebin
Feedback -- English French German Japanese
Create Upload Newest Tools Donate
Sign In | Create Account

Paste Actions

Download Raw
Embed
pBox URL
Post to Twitter
Remove Paste

Paste Details

Raw format, 4 years 6 months old, and 460 hits.

Anonymous
Monday, July 16th, 2007 at 7:45:51pm MDT 

  1. /*
  2. SQLyog Community Edition- MySQL GUI v6.03
  3. Host - 4.1.22-standard-log : Database - joebeeso_showtracker
  4. *********************************************************************
  5. Server version : 4.1.22-standard-log
  6. */
  7.  
  8.  
  9. /*!40101 SET NAMES utf8 */;
  10.  
  11. /*!40101 SET SQL_MODE=''*/;
  12.  
  13. create database if not exists `joebeeso_showtracker`;
  14.  
  15. USE `joebeeso_showtracker`;
  16.  
  17. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  18. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  19.  
  20. /*Table structure for table `stEvents` */
  21.  
  22. DROP TABLE IF EXISTS `stEvents`;
  23.  
  24. CREATE TABLE `stEvents` (
  25.   `eventid` int(11) NOT NULL auto_increment,
  26.   `artistid` int(11) default NULL,
  27.   `date` text,
  28.   `venue` text,
  29.   `purchase` text,
  30.   `zipcode` varchar(10) default NULL,
  31.   PRIMARY KEY  (`eventid`)
  32. ) ENGINE=MyISAM AUTO_INCREMENT=23959 DEFAULT CHARSET=latin1;
  33.  
  34. /*Table structure for table `stRatings` */
  35.  
  36. DROP TABLE IF EXISTS `stRatings`;
  37.  
  38. CREATE TABLE `stRatings` (
  39.   `userid` int(6) default NULL,
  40.   `artistid` int(11) default NULL,
  41.   `rating` int(1) default NULL
  42. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  43.  
  44. /*Table structure for table `stSimilar` */
  45.  
  46. DROP TABLE IF EXISTS `stSimilar`;
  47.  
  48. CREATE TABLE `stSimilar` (
  49.   `artistid` int(6) default NULL,
  50.   `linkartistid` int(6) default NULL
  51. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  52.  
  53. /*Table structure for table `stZipData` */
  54.  
  55. DROP TABLE IF EXISTS `stZipData`;
  56.  
  57. CREATE TABLE `stZipData` (
  58.   `zip` int(5) default NULL,
  59.   `lat` varchar(10) default NULL,
  60.   `lon` varchar(10) default NULL,
  61.   `city` varchar(30) default NULL,
  62.   `state` char(2) default NULL
  63. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  64.  
  65. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  66. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

advertising

Update the Post

Either update this post and resubmit it with changes, or make a new post.

You may also comment on this post.

update paste below
details of the post (optional)

Note: Only the paste content is required, though the following information can be useful to others.

Save name / title?

(space separated, optional)



Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.

worth-right