-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 01:32 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 `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `catname` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) DEFAULT NULL,
  `catorder` tinyint(4) NOT NULL DEFAULT '0',
  `thumbs` varchar(4) NOT NULL DEFAULT 'yes',
  `parent` int(5) NOT NULL DEFAULT '0',
  `header` varchar(200) DEFAULT NULL,
  `footer` varchar(200) DEFAULT NULL,
  `headtags` varchar(200) DEFAULT NULL,
  `private` varchar(5) NOT NULL DEFAULT 'no',
  `ugnoview` varchar(255) DEFAULT NULL,
  `ugnoupload` varchar(255) DEFAULT NULL,
  `ugnopost` varchar(255) DEFAULT NULL,
  `ugnoanno` varchar(255) DEFAULT NULL,
  `children` text,
  `lastpost` int(11) unsigned DEFAULT NULL,
  `lastphoto` int(11) unsigned DEFAULT NULL,
  `photos` int(11) unsigned DEFAULT '0',
  `posts` int(11) unsigned DEFAULT '0',
  `password` varchar(24) DEFAULT NULL,
  `cattype` varchar(4) NOT NULL DEFAULT 'c',
  `theme` varchar(32) NOT NULL DEFAULT '',
  `catdepth` varchar(6) DEFAULT NULL,
  `watermark` varchar(250) NOT NULL DEFAULT '',
  `sortorder` int(2) NOT NULL DEFAULT '1',
  `extra1` varchar(250) DEFAULT NULL,
  `extra2` varchar(250) DEFAULT NULL,
  `extra3` varchar(250) DEFAULT NULL,
  `extra4` varchar(250) DEFAULT NULL,
  `extra5` varchar(250) DEFAULT NULL,
  `extra6` varchar(250) DEFAULT NULL,
  `thumbnail` int(15) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=501 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `catname`, `description`, `catorder`, `thumbs`, `parent`, `header`, `footer`, `headtags`, `private`, `ugnoview`, `ugnoupload`, `ugnopost`, `ugnoanno`, `children`, `lastpost`, `lastphoto`, `photos`, `posts`, `password`, `cattype`, `theme`, `catdepth`, `watermark`, `sortorder`, `extra1`, `extra2`, `extra3`, `extra4`, `extra5`, `extra6`, `thumbnail`) VALUES
(1, 'Main', '', 2, 'no', 0, NULL, NULL, NULL, 'no', NULL, NULL, NULL, NULL, '2', 0, 0, 0, 0, NULL, 'c', '', '', '', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2, 'A Category', 'Photos of a particular subject.', 1, 'yes', 1, NULL, NULL, NULL, 'no', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 'c', '', '', '', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(500, 'Member Galleries', 'Individual user galleries - any photo category.', 1, 'yes', 0, NULL, NULL, NULL, 'no', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, 'c', '', '', '', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0);