CREATE TABLE  `chimera_devel`.`categories` (
  `category` varchar(40) NOT NULL,
  `ID` tinyint(2) NOT NULL auto_increment,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`course` (
  `class_number` smallint(3) NOT NULL default '0',
  `user_level` varchar(3) NOT NULL default '200',
  `class_title` varchar(50) NOT NULL default '',
  `class_credits` varchar(6) NOT NULL default '0',
  `semester_offered` varchar(12) NOT NULL default 'Fall',
  `class_prerequisite` varchar(128) NOT NULL default '',
  `class_description` text NOT NULL,
  `class_instructor` varchar(25) default NULL,
  PRIMARY KEY  (`class_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`events` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `start_time` datetime default NULL,
  `end_time` datetime default NULL,
  `description` varchar(300) default NULL,
  `allday` tinyint(1) default NULL,
  `recurring` enum('daily','weekly','monthly','once_only') NOT NULL default 'once_only',
  `recur_id` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`expire_dates` (
  `ID` int(3) NOT NULL default '0',
  `date` date NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`faculty` (
  `Email` varchar(100) NOT NULL default '',
  `Fname` varchar(16) NOT NULL default '',
  `Lname` varchar(16) NOT NULL default '',
  `Minit` varchar(1) NOT NULL default '',
  `Prefix` varchar(5) NOT NULL default 'Dr.',
  `Suffix` varchar(4) NOT NULL default '',
  `Position` varchar(25) NOT NULL default '',
  `Office` varchar(12) default NULL,
  `Office_Phone` varchar(12) default NULL,
  `Homepage` varchar(100) default NULL,
  `ID` int(2) NOT NULL auto_increment,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`navigation` (
  `name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `target` varchar(255) NOT NULL default '',
  `priority` tinyint(4) NOT NULL default '0',
  `visible` char(1) default '',
  `parent` varchar(255) default '',
  `user_level` varchar(3) NOT NULL default '200',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`news` (
  `ID` int(8) NOT NULL auto_increment,
  `headlines` varchar(100) NOT NULL default '',
  `post_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  `expire_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `description` varchar(3000) NOT NULL default '',
  `sticky` tinyint(1) NOT NULL default '0',
  `category_code` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`preferences` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default '',
  `description` varchar(100) default '',
  `type` varchar(25) default '',
  `value` varchar(25) default '',
  `expected_value` varchar(25) default '',
  `grp` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`rss_source` (
  `rss_url` varchar(100) NOT NULL,
  `headlines` varchar(100) NOT NULL,
  `rss_link` varchar(100) NOT NULL,
  `rss_name` varchar(100) NOT NULL,
  PRIMARY KEY  (`rss_url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`rssbot` (
  `feedURL` varchar(300) NOT NULL,
  `lastmod` text NOT NULL,
  `nextup` text NOT NULL,
  `etag` text NOT NULL,
  PRIMARY KEY  (`feedURL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE  `chimera_devel`.`sections` (
  `ID` tinyint(2) NOT NULL auto_increment,
  `section_number` varchar(4) NOT NULL default '',
  `course_number` varchar(3) NOT NULL default '',
  `instructor` varchar(42) NOT NULL default '',
  `start_time` time NOT NULL default '00:00:00',
  `end_time` time NOT NULL default '00:00:00',
  `days` varchar(5) NOT NULL default '',
  `room` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1