[eluser]Kinsbane[/eluser]
Sure! Here it is:
Code:
CREATE TABLE `event` (
`event_id` int(10) unsigned NOT NULL auto_increment,
`event_date` int(10) unsigned NOT NULL default '0',
`event_length` int(2) NOT NULL default '0',
`event_title` varchar(128) default NULL,
`event_location` varchar(128) default NULL,
`event_status` enum('on schedule','rescheduled','cancelled','over','hidden') NOT NULL default 'on schedule',
`event_shown` enum('yes','no') NOT NULL default 'yes',
`event_description` mediumtext,
`event_type` enum('','Tradeshow','Conference','Seminar/Webinar','Road Show') NOT NULL default 'Tradeshow',
`date_created` int(10) unsigned NOT NULL default '0',
`created_by` varchar(16) NOT NULL default '',
`date_modified` int(10) unsigned NOT NULL default '0',
`modified_by` varchar(16) NOT NULL default '',
`booth` varchar(255) NOT NULL default '',
`attendance` enum('','1','2','3','4') NOT NULL default '',
`feedback_sent` enum('','Y','N') NOT NULL default 'N',
`partner_event` enum('','yes','no') NOT NULL default 'no',
PRIMARY KEY (`event_id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1110 ;
Thank you, wiredesignz!