-- MySQL dump 8.23
--
-- Host: localhost    Database: programming2004
---------------------------------------------------------
-- Server version	3.23.58

--
-- Table structure for table `comments`
--

-- USE programming2005

CREATE TABLE IF NOT EXISTS comments (
  commentid mediumint(8) unsigned NOT NULL auto_increment,
  parent mediumint(8) unsigned NOT NULL default '0',
  timestamp timestamp(14) NOT NULL,
  postedby text NOT NULL,
  subject text NOT NULL,
  comment text NOT NULL,
  PRIMARY KEY  (commentid),
  UNIQUE KEY commentid (commentid),
  KEY commentid_2 (commentid)
) TYPE=MyISAM;


--
-- Table structure for table `days`
--

CREATE TABLE IF NOT EXISTS days (
  dayid mediumint(8) unsigned NOT NULL auto_increment,
  description varchar(64) NOT NULL default '',
  dayorder tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (dayid),
  KEY dayorder (dayorder)
) TYPE=MyISAM;


--
-- Table structure for table `evaluations`
--

CREATE TABLE IF NOT EXISTS evaluations (
  evalid mediumint(8) unsigned NOT NULL auto_increment,
  theme varchar(64) default NULL,
  presenter varchar(64) default NULL,
  title varchar(128) default NULL,
  date varchar(32) default NULL,
  datetime varchar(5) default NULL,
  dateampm char(2) default NULL,
  guidename varchar(64) default NULL,
  attendance smallint(6) default NULL,
  length smallint(6) default NULL,
  assessment text,
  interaction text,
  comments text,
  createtimestamp timestamp(14) NOT NULL,
  sessionnumber mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (evalid),
  UNIQUE KEY evalid (evalid),
  KEY evalid_2 (evalid),
  FULLTEXT KEY theme (theme)
) TYPE=MyISAM;

--
-- Table structure for table `guides`
--

CREATE TABLE  IF NOT EXISTS guides (
  guide varchar(64) NOT NULL default ''
) TYPE=MyISAM;


--
-- Table structure for table `presenters`
--

CREATE TABLE IF NOT EXISTS presenters (
  presenter varchar(64) NOT NULL default ''
) TYPE=MyISAM;


--
-- Table structure for table `rooms`
--

CREATE TABLE IF NOT EXISTS rooms (
  roomid mediumint(8) unsigned NOT NULL auto_increment,
  room varchar(64) NOT NULL default '',
  size smallint(5) unsigned default NULL,
  PRIMARY KEY  (roomid),
  KEY roomid (roomid)
) TYPE=MyISAM;


--
-- Table structure for table `slots`
--

CREATE TABLE IF NOT EXISTS slots (
  slotid mediumint(8) unsigned NOT NULL auto_increment,
  description varchar(64) default NULL,
  dayid mediumint(8) unsigned default NULL,
  type varchar(64) default NULL,
  starttime time default NULL,
  duration smallint(6) default NULL,
  PRIMARY KEY  (slotid),
  KEY dayid (dayid)
) TYPE=MyISAM;


--
-- Table structure for table `submissions`
--

CREATE TABLE IF NOT EXISTS submissions (
  id mediumint(8) unsigned NOT NULL auto_increment,
  firstname text NOT NULL,
  middlename text NOT NULL,
  lastname text NOT NULL,
  jobtitle text NOT NULL,
  institution text NOT NULL,
  department text NOT NULL,
  address_1 text NOT NULL,
  address_2 text NOT NULL,
  city text NOT NULL,
  state_province text NOT NULL,
  zip text NOT NULL,
  phone text NOT NULL,
  extension text NOT NULL,
  fax text NOT NULL,
  email text NOT NULL,
  institutionregion text NOT NULL,
  institutiontype text NOT NULL,
  operatesthrough text NOT NULL,
  studentstaffpaidby text NOT NULL,
  numberofstudents text NOT NULL,
  numstudentsinreshalls text NOT NULL,
  fulltimeresnetstaff text NOT NULL,
  numresnetstudents text NOT NULL,
  numresnetports text NOT NULL,
  numactiveconnections text NOT NULL,
  presentationtitle text NOT NULL,
  presentationformat text NOT NULL,
  presentationtheme text NOT NULL,
  easel text NOT NULL,
  flipchart text NOT NULL,
  overheadprojector text NOT NULL,
  dryerase text NOT NULL,
  cdplayer text NOT NULL,
  presentationdescription text NOT NULL,
  presentationsynopsis text NOT NULL,
  presentationvalue text NOT NULL,
  targetaudience text NOT NULL,
  background text NOT NULL,
  postpermission text NOT NULL,
  videopermission text NOT NULL,
  jeopardyquestion text NOT NULL,
  jeopardyanswer text NOT NULL,
  firstname1 text NOT NULL,
  middlename1 text NOT NULL,
  lastname1 text NOT NULL,
  institution1 text NOT NULL,
  jobtitle1 text NOT NULL,
  email1 text NOT NULL,
  firstname2 text NOT NULL,
  middlename2 text NOT NULL,
  lastname2 text NOT NULL,
  institution2 text NOT NULL,
  jobtitle2 text NOT NULL,
  email2 text NOT NULL,
  firstname3 text NOT NULL,
  middlename3 text NOT NULL,
  lastname3 text NOT NULL,
  institution3 text NOT NULL,
  jobtitle3 text NOT NULL,
  email3 text NOT NULL,
  firstname4 text NOT NULL,
  middlename4 text NOT NULL,
  lastname4 text NOT NULL,
  institution4 text NOT NULL,
  jobtitle4 text NOT NULL,
  email4 text NOT NULL,
  slotid mediumint(8) unsigned default '0',
  roomid mediumint(8) unsigned default NULL,
  resnetsattended text,
  haveyoupresented tinytext NOT NULL,
  howmanypresentations text,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id),
  KEY slotid (slotid)
) TYPE=MyISAM;

--
-- Table structure for table `themes`
--

CREATE TABLE IF NOT EXISTS themes (
  themeid mediumint(8) unsigned NOT NULL auto_increment,
  theme varchar(128) NOT NULL default '',
  color varchar(12) default NULL,
  prefix varchar(12) default NULL,
  PRIMARY KEY  (themeid),
  KEY theme (theme)
) TYPE=MyISAM;


--
-- Table structure for table `titles`
--

CREATE TABLE IF NOT EXISTS titles (
  title text NOT NULL,
  presenter varchar(128) NOT NULL default '',
  theme varchar(128) default NULL,
  sessionnumber varchar(9) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Table structure for table `uploads`
--

CREATE TABLE IF NOT EXISTS uploads (
  uploadid mediumint(8) unsigned NOT NULL auto_increment,
  evalid mediumint(8) unsigned NOT NULL default '0',
  filename varchar(128) default NULL,
  PRIMARY KEY  (uploadid),
  UNIQUE KEY uploadid (uploadid),
  KEY evalid (evalid)
) TYPE=MyISAM;


--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS users (
  userid mediumint(8) unsigned NOT NULL auto_increment,
  username text NOT NULL,
  password text NOT NULL,
  privilege text NOT NULL,
  theme varchar(64) default NULL,
  PRIMARY KEY  (userid),
  UNIQUE KEY userid (userid),
  KEY userid_2 (userid),
  KEY theme (theme)
) TYPE=MyISAM;