Philosophy Conference Database

  CREATE DATABASE csps_registration;

  CREATE TABLE attendees (
    attendee_id   INT(11) NOT   NULL AUTO_INCREMENT,
    firstname     VARCHAR(20)   NOT NULL,
    lastname      VARCHAR(35)   NOT NULL,
    email         VARCHAR(45)   NOT NULL,
    phone         VARCHAR(20),
    address       VARCHAR(35),
    city          VARCHAR(20),
    state         CHAR(2),
    zip           CHAR(5),
    organization  VARCHAR(45)   NOT NULL,
    faculty       BOOLEAN,
    student       BOOLEAN,
    fridaylunch   BOOLEAN,
    saturdaylunch BOOLEAN,
    omnivore      BOOLEAN,
    vegan         BOOLEAN,
  PRIMARY KEY   (attendee_id)
  );

  SHOW COLUMNS FROM attendees;

  INSERT INTO attendees
    (firstname, lastname, email, phone, address, city, state, zip, organization,
    faculty, student, fridaylunch, saturdaylunch, omnivore, vegan)
  VALUES
    ('John', 'Doe', 'jdoe@fake.edu', '999-999-9999', '123 Street', 'Whoville',
    'TX', '77777', 'Rivendell University', 1, 0, 1, 1, 1, 0);