-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 02:44 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `bmcforu_transfer`
--

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

--
-- Table structure for table `sort`
--

CREATE TABLE IF NOT EXISTS `sort` (
  `sortid` int(15) NOT NULL AUTO_INCREMENT,
  `name` varchar(35) NOT NULL DEFAULT '',
  `code` varchar(75) NOT NULL DEFAULT '',
  PRIMARY KEY (`sortid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `sort`
--

INSERT INTO `sort` (`sortid`, `name`, `code`) VALUES
(2, 'Latest', 'ORDER BY disporder,date DESC'),
(3, 'Most Views', 'ORDER BY disporder,views DESC'),
(1, 'Most Active', 'ORDER BY disporder,lastpost DESC'),
(4, 'Most Popular', 'ORDER BY disporder,rating DESC, views DESC'),
(6, 'Random', 'ORDER BY disporder,RAND()'),
(5, 'Least Popular', 'ORDER BY disporder,rating,views'),
(7, 'Image Name', 'ORDER BY disporder,bigimage'),
(8, 'Title', 'ORDER BY disporder,title');