# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Sep 30, 2004 at 10:02 AM
# Server version: 4.0.18
# PHP Version: 4.3.6
# 
# Database : `deitch`
# 

# --------------------------------------------------------

#
# Table structure for table `projects`
#

DROP TABLE IF EXISTS `projects`;
CREATE TABLE `projects` (
  `projId` int(8) NOT NULL auto_increment,
  `projName` varchar(255) NOT NULL default '',
  `projSortName` varchar(255) default NULL,
  `startDate` date default NULL,
  `endDate` date default NULL,
  `projFeatBlurb` blob,
  `projDesc` blob,
  `projPoster` varchar(255) default NULL,
  `posterOrient` char(1) NOT NULL default '',
  `projQTVR` varchar(255) default NULL,
  `projVideo` varchar(255) default NULL,
  `projMusic` varchar(255) default NULL,
  `active` int(1) NOT NULL default '0',
  PRIMARY KEY  (`projId`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

#
# Dumping data for table `projects`
#

INSERT INTO `projects` VALUES (1, 'Project Name', 'Sort Name', '2002-03-23', '2002-04-23', NULL, NULL, NULL, 'v', NULL, NULL, NULL, 0);
INSERT INTO `projects` VALUES (3, 'Test2', 'Test2 Sort', '2006-01-05', '2007-02-04', 0x4665617475726564, 0x4465736372697074696f6e, NULL, '', NULL, NULL, NULL, 0);
INSERT INTO `projects` VALUES (4, 'Test3', 'Test3 Sort', '2001-01-01', '2002-02-02', 0x6665617475726564, 0x70726a6f65, NULL, '', NULL, NULL, NULL, 1);