competition

cmp_id
cmp_name
cmp_desc1
cmp_desc2
cmp_startdate
cmp_enddate
cmp_thumbnail
cmp_size1 (1 or 0) -- SML
cmp_size2 (1 o 0) -- Digits, but how do we make it universal
cmp_question
cmp_answer (where to find it 1=newsletter,2=podcast,3=customtext)
cmp_terms





-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 22, 2009 at 12:56 PM
-- Server version: 5.0.19
-- PHP Version: 5.1.6
-- 
-- Database: `stylespy_net_-_godsavethequeen`
-- 

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

-- 
-- Table structure for table `competition`
-- 

CREATE TABLE `competition` (
  `cmp_id` tinyint(3) NOT NULL auto_increment,
  `cmp_name` varchar(100) NOT NULL,
  `cmp_desc1` varchar(255) NOT NULL,
  `cmp_desc2` text NOT NULL,
  `cmp_startdate` datetime NOT NULL,
  `cmp_enddate` datetime NOT NULL,
  `cmp_thumbnail` varchar(20) NOT NULL,
  `cmp_size1` tinyint(1) NOT NULL default '0',
  `cmp_size2` varchar(1) NOT NULL default '0',
  `cmp_question` varchar(255) NOT NULL,
  `cmp_answer` text NOT NULL,
  `cmp_terms` varbinary(255) NOT NULL,
  PRIMARY KEY  (`cmp_id`),
  KEY `cmp_startdate` (`cmp_startdate`,`cmp_enddate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `competition`
--