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

--
-- Table structure for table `attachments`
--

DROP TABLE IF EXISTS `attachments`;
CREATE TABLE `attachments` (
  `attachment_id` bigint(20) NOT NULL auto_increment,
  `content_id` bigint(20) NOT NULL,
  `content_type` enum('Question','Answer') collate latin1_general_ci NOT NULL,
  `attachment_name` varchar(150) collate latin1_general_ci default NULL,
  `attachment_size` bigint(20) default '0',
  `photo_server_url` varchar(255) collate latin1_general_ci NOT NULL,
  `date_added` datetime default NULL,
  PRIMARY KEY  (`attachment_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
