Database researchguide  running on mysql.sourceforge.net

# phpMyAdmin MySQL-Dump
# version 2.3.3-rc1
# http://www.phpmyadmin.net/ (download page)
#
# Host: mysql.sourceforge.net
# Generation Time: Jan 30, 2003 at 04:31 PM
# Server version: 3.23.54
# PHP Version: 4.1.2
# Database : `researchguide`
# --------------------------------------------------------

#
# Table structure for table `admin`
#

CREATE TABLE admin (
  id mediumint(9) NOT NULL auto_increment,
  uniqname char(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `area`
#

CREATE TABLE area (
  id mediumint(5) NOT NULL default '0',
  name varchar(50) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `guide`
#

CREATE TABLE guide (
  id mediumint(9) NOT NULL auto_increment,
  sel_id mediumint(9) default NULL,
  subject varchar(60) default NULL,
  area tinyint(2) default NULL,
  image_link varchar(255) default NULL,
  image_credit varchar(255) default NULL,
  abstract blob,
  comments blob,
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `guide_cat`
#

CREATE TABLE guide_cat (
  id mediumint(9) NOT NULL auto_increment,
  cat_order smallint(100) default NULL,
  name char(100) default NULL,
  guide_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `resource`
#

CREATE TABLE resource (
  id mediumint(9) NOT NULL auto_increment,
  guide_cat_id mediumint(9) NOT NULL default '0',
  rsc_order smallint(100) default NULL,
  title varchar(255) default NULL,
  url blob,
  abstract blob,
  access_comment blob,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `selector`
#

CREATE TABLE selector (
  id mediumint(9) NOT NULL auto_increment,
  name varchar(60) default NULL,
  last_name varchar(30) default NULL,
  uniqname varchar(16) default NULL,
  title varchar(100) default NULL,
  specialty varchar(100) default NULL,
  image_link varchar(255) default NULL,
  office varchar(80) default NULL,
  phone varchar(20) default NULL,
  fax varchar(20) default NULL,
  email varchar(60) default NULL,
  what_i_do blob,
  responsibilities blob,
  background blob,
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `selector_intersection`
#

CREATE TABLE selector_intersection (
  id mediumint(9) NOT NULL default '0',
  related_selector_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (id,related_selector_id)
) TYPE=MyISAM;