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

CREATE TABLE IF NOT EXISTS `attachmenttype` (
  `extension` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `mimetype` varchar(255) NOT NULL DEFAULT '',
  `size` int(10) unsigned NOT NULL DEFAULT '0',
  `width` smallint(5) unsigned NOT NULL DEFAULT '0',
  `height` smallint(5) unsigned NOT NULL DEFAULT '0',
  `enabled` smallint(5) unsigned NOT NULL DEFAULT '1',
  `display` smallint(5) unsigned NOT NULL DEFAULT '0',
  `thumbnail` smallint(6) NOT NULL DEFAULT '0',
  `newwindow` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`extension`),
  KEY `enabled` (`enabled`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `attachmenttype`
--

INSERT INTO `attachmenttype` (`extension`, `mimetype`, `size`, `width`, `height`, `enabled`, `display`, `thumbnail`, `newwindow`) VALUES
('gif', 'a:1:{i:0;s:23:"Content-type: image/gif";}', 200000, 1250, 1250, 1, 0, 1, 1),
('jpeg', 'a:1:{i:0;s:24:"Content-type: image/jpeg";}', 20000, 620, 280, 1, 0, 1, 1),
('jpg', 'a:1:{i:0;s:24:"Content-type: image/jpeg";}', 4294967295, 1250, 1250, 1, 0, 1, 1),
('jpe', 'a:1:{i:0;s:24:"Content-type: image/jpeg";}', 20000, 620, 280, 1, 0, 1, 1),
('txt', 'a:1:{i:0;s:24:"Content-type: plain/text";}', 20000, 0, 0, 1, 2, 0, 0),
('png', 'a:1:{i:0;s:23:"Content-type: image/png";}', 20000, 620, 280, 1, 0, 1, 1),
('doc', 'a:2:{i:0;s:20:"Accept-ranges: bytes";i:1;s:32:"Content-type: application/msword";}', 20000, 0, 0, 1, 0, 0, 0),
('pdf', 'a:1:{i:0;s:29:"Content-type: application/pdf";}', 2000000, 0, 0, 1, 0, 0, 0),
('bmp', 'a:1:{i:0;s:26:"Content-type: image/bitmap";}', 200000, 800, 800, 1, 0, 1, 1),
('psd', 'a:1:{i:0;s:29:"Content-type: unknown/unknown";}', 2000000, 0, 0, 1, 0, 0, 0),
('zip', 'a:1:{i:0;s:29:"Content-type: application/zip";}', 100000, 0, 0, 1, 0, 0, 0),
('ttf', 'a:1:{i:0;s:29:"Content-type: unknown/unknown";}', 2000000, 0, 0, 1, 0, 0, 0);