-- 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 `sortmemb`
--

CREATE TABLE IF NOT EXISTS `sortmemb` (
  `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=5 ;

--
-- Dumping data for table `sortmemb`
--

INSERT INTO `sortmemb` (`sortid`, `name`, `code`) VALUES
(2, 'Date (newest first)', 'ORDER BY maxdate DESC'),
(3, 'Views (high to low)', 'ORDER BY tviews DESC'),
(1, 'Most Active', 'ORDER BY maxlast DESC'),
(4, 'Alphabetical Order', 'ORDER BY user ASC');