-- phpMyAdmin SQL Dump
-- version 2.10.3deb1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 28, 2007 at 12:38 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.3-1ubuntu6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `bandnet3_dev`
-- 

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

-- 
-- Table structure for table `bn_site_artists`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `status` tinyint(1) unsigned NOT NULL default '1',
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `joinkey` char(40) NOT NULL,
  `jointime` int(10) unsigned NOT NULL,
  `lastactive` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_artists`
-- 


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

-- 
-- Table structure for table `bn_site_artists_description`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists_description` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `artistID` mediumint(8) unsigned NOT NULL,
  `userID` mediumint(8) unsigned NOT NULL,
  `status` tinyint(1) unsigned NOT NULL default '1',
  `active` tinyint(1) NOT NULL COMMENT 'if set this description is always used',
  `posttime` int(10) unsigned NOT NULL,
  `content` text NOT NULL,
  `prevID` int(10) unsigned NOT NULL,
  `hash` char(40) NOT NULL COMMENT 'sha1 prevents duplicate descriptions',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `hash` (`hash`),
  KEY `artistID` (`artistID`),
  KEY `prevID` (`prevID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_artists_description`
-- 


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

-- 
-- Table structure for table `bn_site_artists_featured`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists_featured` (
  `artistID` mediumint(8) unsigned NOT NULL,
  `timefavourited` int(10) unsigned NOT NULL,
  `displaycount` smallint(5) unsigned NOT NULL,
  `reviewID` mediumint(8) unsigned NOT NULL,
  `imageID` mediumint(8) unsigned NOT NULL,
  UNIQUE KEY `artistID` (`artistID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_artists_featured`
-- 


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

-- 
-- Table structure for table `bn_site_artists_images`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists_images` (
  `artistID` int(10) unsigned NOT NULL,
  `fileID` int(10) unsigned NOT NULL,
  `def` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`artistID`,`fileID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_artists_images`
-- 


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

-- 
-- Table structure for table `bn_site_artists_members`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists_members` (
  `userID` int(10) unsigned NOT NULL,
  `artistID` int(10) unsigned NOT NULL,
  `status` tinyint(2) NOT NULL,
  `role` varchar(255) NOT NULL,
  PRIMARY KEY  (`userID`,`artistID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_artists_members`
-- 


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

-- 
-- Table structure for table `bn_site_artists_rating`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists_rating` (
  `artistID` int(10) unsigned NOT NULL,
  `userID` int(10) unsigned NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`artistID`,`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_artists_rating`
-- 


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

-- 
-- Table structure for table `bn_site_artists_reviews`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists_reviews` (
  `artistID` mediumint(8) unsigned NOT NULL,
  `userID` mediumint(8) unsigned NOT NULL,
  `reviewtime` int(10) unsigned NOT NULL,
  `body` text NOT NULL,
  KEY `artistID` (`artistID`,`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_artists_reviews`
-- 


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

-- 
-- Table structure for table `bn_site_artists_shoutbox`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists_shoutbox` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `artistID` int(10) unsigned NOT NULL,
  `userID` int(10) unsigned NOT NULL,
  `timestamp` int(10) unsigned NOT NULL,
  `text` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `artistID` (`artistID`),
  KEY `userID` (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_artists_shoutbox`
-- 


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

-- 
-- Table structure for table `bn_site_artists_tags`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_artists_tags` (
  `artistID` mediumint(8) unsigned NOT NULL,
  `tagID` mediumint(8) unsigned NOT NULL,
  `userID` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (`artistID`,`tagID`,`userID`),
  KEY `artistID` (`artistID`,`tagID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_artists_tags`
-- 


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

-- 
-- Table structure for table `bn_site_files`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_files` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `artistID` mediumint(8) unsigned NOT NULL,
  `userID` int(10) unsigned NOT NULL,
  `folderID` mediumint(8) unsigned NOT NULL,
  `addtime` int(10) unsigned NOT NULL,
  `fileType` tinyint(3) unsigned NOT NULL,
  `status` tinyint(1) unsigned NOT NULL,
  `title` varchar(50) NOT NULL,
  `storedName` varchar(255) NOT NULL,
  `sha1` char(32) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `artistID` (`artistID`,`folderID`),
  KEY `sha1` (`sha1`),
  KEY `folderID` (`folderID`),
  KEY `fileType` (`fileType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_files`
-- 


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

-- 
-- Table structure for table `bn_site_files_data`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_files_data` (
  `fileID` int(10) unsigned NOT NULL,
  `dataType` tinyint(3) unsigned NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY  (`fileID`,`dataType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_files_data`
-- 


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

-- 
-- Table structure for table `bn_site_folders`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_folders` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `artistID` int(10) unsigned NOT NULL,
  `userID` int(10) unsigned NOT NULL,
  `iconID` int(10) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL,
  `title` varchar(255) NOT NULL,
  `storedName` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `artistID` (`artistID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_folders`
-- 


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

-- 
-- Table structure for table `bn_site_log_messages`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_log_messages` (
  `messageName` varchar(50) collate utf8_unicode_ci NOT NULL,
  `messageID` smallint(5) unsigned NOT NULL auto_increment,
  `verbosity` tinyint(3) unsigned NOT NULL,
  `defaultText` varchar(255) collate utf8_unicode_ci NOT NULL COMMENT 'use if message not translated',
  `icon` varchar(15) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`messageName`),
  KEY `messageID` (`messageID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=124 ;

-- 
-- Dumping data for table `bn_site_log_messages`
-- 

INSERT INTO `bn_site_log_messages` (`messageName`, `messageID`, `verbosity`, `defaultText`, `icon`) VALUES 
('LOG_USER_REGISTERED', 100, 5, '%logusername% joined %sitename%! Hooray!', ''),
('LOG_USER_FAVOURITE_ADD', 105, 5, '%logusername% added <a href="%loggeturlartist%">%loggetartistname%</a> to their favourite artists', 'heart.png'),
('LOG_USER_FAVOURITE_REMOVE', 106, 5, '%logusername% removed <a href="%loggeturlartist%">%loggetartistname%</a> from their favourites', ''),
('LOG_USER_SUBMITTED_DESCRIPTION', 121, 3, '%logusername% submitted a description for the artist <a href="%loggeturlartist%">%loggetartistname%</a>', ''),
('LOG_USER_SUBMITTED_DESCRIPTION_ACCEPTED', 122, 4, '%logusername% accepted %loggetusername%''s description for <a href="%loggeturlartist%">%loggetartistname%</a>', ''),
('LOG_USER_SUBMITTED_DESCRIPTION_ACCEPTED_BY', 123, 4, '%logusername%''s description for <a href="%loggeturlartist%">%loggetartistname%</a> was accepted by %loggetusername%', '');

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

-- 
-- Table structure for table `bn_site_log_system`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_log_system` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `logType` smallint(5) unsigned NOT NULL,
  `logTime` int(10) unsigned NOT NULL,
  `logText` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_log_system`
-- 


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

-- 
-- Table structure for table `bn_site_places`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_places` (
  `node` int(10) unsigned NOT NULL,
  `type` varchar(10) NOT NULL default '',
  `name` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `lat` double NOT NULL default '0',
  `lon` double NOT NULL default '0',
  PRIMARY KEY  (`lat`,`lon`),
  KEY `node` (`node`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_places`
-- 


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

-- 
-- Table structure for table `bn_site_tags`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_tags` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `tag` varchar(50) NOT NULL,
  `type` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `tag` (`tag`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_tags`
-- 


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

-- 
-- Table structure for table `bn_site_users`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(100) NOT NULL,
  `password` char(40) NOT NULL,
  `loginkey` char(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `jointime` int(10) unsigned NOT NULL,
  `lastvisit` int(10) unsigned NOT NULL,
  `lastactive` int(10) unsigned NOT NULL,
  `status` smallint(1) NOT NULL,
  `location` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `username` (`username`,`password`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_users`
-- 


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

-- 
-- Table structure for table `bn_site_users_confirm`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_users_confirm` (
  `userID` mediumint(8) unsigned NOT NULL,
  `confirmhash` char(40) NOT NULL,
  `regtime` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_users_confirm`
-- 


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

-- 
-- Table structure for table `bn_site_users_favourites`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_users_favourites` (
  `userID` mediumint(8) unsigned NOT NULL,
  `artistID` mediumint(8) unsigned NOT NULL,
  `addtime` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`userID`,`artistID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `bn_site_users_favourites`
-- 


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

-- 
-- Table structure for table `bn_site_users_log`
-- 

CREATE TABLE IF NOT EXISTS `bn_site_users_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userID` mediumint(8) unsigned NOT NULL,
  `logType` smallint(5) unsigned NOT NULL,
  `logTime` int(10) unsigned NOT NULL,
  `logValues` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `userID` (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `bn_site_users_log`
-- 

