All pastes #232239 Raw Edit

Unnamed

public text v1 · immutable
·published 2006-11-01 07:47 UTC
rendered paste body
-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 01, 2006 at 02:46 AM
-- Server version: 5.0.24
-- PHP Version: 4.4.2
-- 
-- Database: `mmotheat_main`
-- 

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

-- 
-- Table structure for table `file`
-- 

CREATE TABLE `file` (
  `file_id` int(11) NOT NULL auto_increment,
  `source` varchar(255) default NULL,
  `cat_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `section_id` int(11) NOT NULL default '0',
  `postauthor` varchar(255) NOT NULL default '',
  `file_name` varchar(255) NOT NULL default '',
  `file_description` text NOT NULL,
  `file_summary` varchar(255) default NULL,
  `file_image` blob,
  `file_length` int(11) default '0',
  `file_version` varchar(28) default NULL,
  `file_filesize` int(11) default '0',
  `file_language` varchar(28) default NULL,
  `downloads` int(11) NOT NULL default '0',
  `downloads_today` int(11) NOT NULL default '0',
  `downloads_daily` int(11) NOT NULL default '0',
  `downloads_rank` int(11) NOT NULL default '0',
  `comments` int(11) NOT NULL default '0',
  `comments_today` int(11) NOT NULL default '0',
  `props` int(11) NOT NULL default '0',
  `props_today` int(11) NOT NULL default '0',
  `props_rank` int(11) NOT NULL default '0',
  `rating_0` int(11) NOT NULL,
  `rating_1` int(11) NOT NULL,
  `rating_0_today` int(11) NOT NULL,
  `rating_1_today` int(11) NOT NULL,
  `visible` tinyint(1) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  PRIMARY KEY  (`file_id`),
  UNIQUE KEY `source` (`source`),
  KEY `postauthor_id` (`user_id`),
  KEY `tag_id` (`cat_id`),
  KEY `section_id` (`section_id`),
  FULLTEXT KEY `movie_name` (`file_name`),
  FULLTEXT KEY `movie_description` (`file_description`)
) ENGINE=MyISAM AUTO_INCREMENT=38168 DEFAULT CHARSET=latin1 AUTO_INCREMENT=38168 ;

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

-- 
-- Table structure for table `file_cats`
-- 

CREATE TABLE `file_cats` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(255) NOT NULL default '',
  `cat_alias` varchar(255) NOT NULL default '',
  `format` varchar(255) NOT NULL,
  `files` int(11) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  `template_id` int(11) NOT NULL default '0',
  `post_date` int(11) NOT NULL,
  PRIMARY KEY  (`cat_id`),
  UNIQUE KEY `cat_alias` (`cat_alias`),
  KEY `template_id` (`template_id`),
  FULLTEXT KEY `cat_name` (`cat_name`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

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

-- 
-- Table structure for table `file_cats_sections`
-- 

CREATE TABLE `file_cats_sections` (
  `cat_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `post_date` int(11) NOT NULL,
  `can_upload` tinyint(1) NOT NULL,
  `files` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY  (`cat_id`,`section_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `file_comments`
-- 

CREATE TABLE `file_comments` (
  `comment_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `file_id` int(11) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  `comment` text NOT NULL,
  `visible` tinyint(1) NOT NULL default '0',
  `rating_0` int(11) NOT NULL,
  `rating_1` int(11) NOT NULL,
  PRIMARY KEY  (`comment_id`),
  KEY `user_id` (`user_id`),
  KEY `movie_id` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=194 ;

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

-- 
-- Table structure for table `file_comments_votes`
-- 

CREATE TABLE `file_comments_votes` (
  `user_id` int(11) NOT NULL default '0',
  `comment_id` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `file_downloads`
-- 

CREATE TABLE `file_downloads` (
  `download_id` int(11) NOT NULL auto_increment,
  `file_id` int(11) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  `ipaddress` varchar(15) NOT NULL default '',
  `user_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`download_id`),
  KEY `movie_id` (`file_id`),
  KEY `dateline` (`dateline`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=152173 ;

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

-- 
-- Table structure for table `file_featured`
-- 

CREATE TABLE `file_featured` (
  `featured_id` int(11) NOT NULL auto_increment,
  `file_id` int(11) NOT NULL default '0',
  `tag_id` int(11) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  PRIMARY KEY  (`featured_id`),
  KEY `movie_id` (`file_id`),
  KEY `tag_id` (`tag_id`),
  KEY `tag_id_2` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `file_friends`
-- 

CREATE TABLE `file_friends` (
  `user_id` int(11) NOT NULL default '0',
  `friend_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`friend_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `file_links`
-- 

CREATE TABLE `file_links` (
  `link_id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `link_name` varchar(255) NOT NULL default '',
  `link_url` varchar(255) NOT NULL default '',
  `link_order` tinyint(4) NOT NULL default '0',
  `link_title` varchar(255) NOT NULL default '',
  `link_status` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`link_id`),
  KEY `cat_id` (`cat_id`),
  KEY `link_status` (`link_status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

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

-- 
-- Table structure for table `file_mirrors`
-- 

CREATE TABLE `file_mirrors` (
  `mirror_id` int(11) NOT NULL auto_increment,
  `file_id` int(11) NOT NULL default '0',
  `mirror_url` varchar(255) NOT NULL default '',
  `user_id` int(11) NOT NULL default '0',
  `rating_0` int(11) NOT NULL,
  `rating_1` int(11) NOT NULL,
  PRIMARY KEY  (`mirror_id`),
  KEY `movie_id` (`file_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=38890 ;

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

-- 
-- Table structure for table `file_mirrors_votes`
-- 

CREATE TABLE `file_mirrors_votes` (
  `user_id` int(11) NOT NULL default '0',
  `mirror_id` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`mirror_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `file_posts`
-- 

CREATE TABLE `file_posts` (
  `post_id` int(11) NOT NULL auto_increment,
  `thread_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `username` varchar(255) NOT NULL default '',
  `dateline` int(11) NOT NULL default '0',
  `post_text` text NOT NULL,
  PRIMARY KEY  (`post_id`),
  KEY `thread_id` (`thread_id`),
  KEY `user_id` (`user_id`),
  FULLTEXT KEY `post_text` (`post_text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `file_props`
-- 

CREATE TABLE `file_props` (
  `prop_id` int(11) NOT NULL auto_increment,
  `file_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  PRIMARY KEY  (`prop_id`),
  UNIQUE KEY `adsfasdf` (`file_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=558 ;

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

-- 
-- Table structure for table `file_ratings`
-- 

CREATE TABLE `file_ratings` (
  `file_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `is_good` tinyint(1) NOT NULL,
  `dateline` int(11) NOT NULL default '0',
  PRIMARY KEY  (`file_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `file_referers`
-- 

CREATE TABLE `file_referers` (
  `ref_id` int(11) NOT NULL auto_increment,
  `file_id` int(11) NOT NULL,
  `ip_address` varchar(15) NOT NULL,
  `remote_url` varchar(255) NOT NULL,
  `dateline` int(11) NOT NULL,
  PRIMARY KEY  (`ref_id`),
  KEY `file_id` (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `file_sections`
-- 

CREATE TABLE `file_sections` (
  `section_id` int(11) NOT NULL auto_increment,
  `section_name` varchar(255) NOT NULL default '',
  `section_alias` varchar(255) NOT NULL default '',
  `section_description` text NOT NULL,
  `section_icon` blob NOT NULL,
  `section_status` tinyint(1) NOT NULL default '0',
  `format` varchar(255) NOT NULL,
  `needs_approval` tinyint(1) NOT NULL default '0',
  `type_id` int(11) NOT NULL default '0',
  `template_id` int(11) NOT NULL default '0',
  `can_upload` tinyint(1) NOT NULL default '0',
  `files` int(11) NOT NULL default '0',
  PRIMARY KEY  (`section_id`),
  UNIQUE KEY `section_alias` (`section_alias`),
  KEY `type_id` (`type_id`),
  KEY `template_id` (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

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

-- 
-- Table structure for table `file_tagged`
-- 

CREATE TABLE `file_tagged` (
  `tag_id` int(11) NOT NULL auto_increment,
  `file_id` int(11) NOT NULL default '0',
  `tag_name` varchar(255) NOT NULL default '',
  `tag_sname` varchar(255) NOT NULL default '',
  `user_id` int(11) NOT NULL default '0',
  `dateline` int(11) NOT NULL default '0',
  PRIMARY KEY  (`tag_id`),
  UNIQUE KEY `movie_id` (`file_id`,`tag_sname`),
  KEY `user_id` (`user_id`),
  FULLTEXT KEY `tag_sname` (`tag_sname`),
  FULLTEXT KEY `tag_name` (`tag_name`)
) ENGINE=MyISAM AUTO_INCREMENT=4819 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4819 ;

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

-- 
-- Table structure for table `file_tags`
-- 

CREATE TABLE `file_tags` (
  `tag_id` int(11) NOT NULL auto_increment,
  `tag_name` varchar(255) NOT NULL default '',
  `tag_sname` varchar(255) NOT NULL default '',
  `cat_id` int(11) NOT NULL default '0',
  `section_id` int(11) NOT NULL default '0',
  `files` int(11) NOT NULL default '0',
  PRIMARY KEY  (`tag_id`),
  KEY `cat_id` (`cat_id`),
  KEY `section_id` (`section_id`),
  FULLTEXT KEY `tag_name` (`tag_name`),
  FULLTEXT KEY `tag_sname` (`tag_sname`)
) ENGINE=MyISAM AUTO_INCREMENT=1312 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1312 ;

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

-- 
-- Table structure for table `file_templates`
-- 

CREATE TABLE `file_templates` (
  `template_id` int(11) NOT NULL auto_increment,
  `template_name` varchar(255) NOT NULL,
  `theme_id` int(11) NOT NULL,
  `can_delete` tinyint(1) NOT NULL,
  `template_data` text NOT NULL,
  `template_parse` text NOT NULL,
  `last_update` int(11) NOT NULL,
  PRIMARY KEY  (`template_id`),
  UNIQUE KEY `template_name` (`template_name`),
  KEY `theme_id` (`theme_id`),
  KEY `can_delete` (`can_delete`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

-- 
-- Table structure for table `file_themes`
-- 

CREATE TABLE `file_themes` (
  `theme_id` int(11) NOT NULL auto_increment,
  `theme_name` varchar(255) NOT NULL default '',
  `can_delete` tinyint(1) NOT NULL default '1',
  `theme_author` varchar(255) NOT NULL default '',
  `theme_email` varchar(255) NOT NULL default '',
  `theme_url` varchar(255) NOT NULL default '',
  `theme_version` varchar(255) NOT NULL default '',
  `parent_theme_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`theme_id`),
  KEY `parent_theme_id` (`parent_theme_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `file_threads`
-- 

CREATE TABLE `file_threads` (
  `thread_id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `username` varchar(255) NOT NULL default '',
  `thread_desc` varchar(255) NOT NULL default '',
  `thread_title` varchar(255) NOT NULL default '',
  `dateline` int(11) NOT NULL default '0',
  `visible` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`thread_id`),
  KEY `cat_id` (`cat_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `file_users`
-- 

CREATE TABLE `file_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `username` varchar(24) NOT NULL default '',
  `key` varchar(30) default NULL,
  `lostkey` varchar(30) default NULL,
  `password` varchar(32) NOT NULL default '',
  `u_salt` char(3) NOT NULL default '',
  `access` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `url` varchar(255) default NULL,
  `xp` int(11) NOT NULL default '0',
  `level` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `avatar` blob NOT NULL,
  `signature` varchar(128) default NULL,
  `fname` varchar(255) default NULL,
  `lname` varchar(255) default NULL,
  `handle` varchar(255) NOT NULL default '',
  `name_label` tinyint(4) NOT NULL default '1',
  `name_color` int(11) NOT NULL default '0',
  `name_bgcolor` int(11) NOT NULL default '0',
  `date_registered` int(11) NOT NULL default '0',
  `date_seen` int(11) NOT NULL default '0',
  `tags` int(11) NOT NULL default '0',
  `comments` int(11) NOT NULL default '0',
  `files` int(11) NOT NULL default '0',
  `props` int(11) NOT NULL default '0',
  `ratings` int(11) NOT NULL,
  `mirrors` int(11) NOT NULL default '0',
  `images` int(11) NOT NULL default '0',
  `posts` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=2668 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2668 ;