-- 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 %loggetartistname% to their favourite artists', 'heart.png'),
('LOG_USER_FAVOURITE_REMOVE', 106, 5, '%logusername% removed %loggetartistname% from their favourites', ''),
('LOG_USER_SUBMITTED_DESCRIPTION', 121, 3, '%logusername% submitted a description for the artist %loggetartistname%', ''),
('LOG_USER_SUBMITTED_DESCRIPTION_ACCEPTED', 122, 4, '%logusername% accepted %loggetusername%''s description for %loggetartistname%', ''),
('LOG_USER_SUBMITTED_DESCRIPTION_ACCEPTED_BY', 123, 4, '%logusername%''s description for %loggetartistname% 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`
--