drop table IF EXISTS person;
CREATE TABLE person (
  id int NOT NULL auto_increment,
  nameLast varchar(20) NOT NULL,
  nameFirst varchar(20) NOT NULL,
  institution VARCHAR(4) NOT NULL,
  email VARCHAR(64),
  activity VARCHAR(64),
  title VARCHAR(64),
  collab_member ENUM('yes', 'no') NOT NULL,
  PRIMARY KEY (id)
);
drop table IF EXISTS institution;
CREATE TABLE institution (
  abbr VARCHAR(4) NOT NULL,
  name VARCHAR(128) NOT NULL,
  sortName VARCHAR(128) NOT NULL,
  fax VARCHAR(32),
  url VARCHAR(128)
);
