gistfile1.sql

-- --------------------------------------------------------
-- Host:                         localhost
-- Server version:               5.1.41 - Source distribution
-- Server OS:                    Win32
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2012-03-16 11:16:55
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping database structure for dfk_audiorip
CREATE DATABASE IF NOT EXISTS `dfk_audiorip` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `dfk_audiorip`;


-- Dumping structure for table dfk_audiorip.tracks
CREATE TABLE IF NOT EXISTS `tracks` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userID` int(10) NOT NULL,
  `videoID` varchar(255) NOT NULL,
  `mediaURL` varchar(255) NOT NULL,
  `mediaPath` varchar(255) NOT NULL,
  `audioPath` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;