#!/usr/bin/php
drop table if exists people;

create table people (
  `id`		int,
  `name`	varchar(64),
  `role`	enum('Student', 'Employee', 'Faculty'),
  `start`	date,
  `updated`	timestamp default current_timestamp()
);

insert into people (id, name, role, start)
values
(9872343, 'Bob Jones', 'Student', '2020-01-01'),
(2348423, 'Jane Smith', 'Student', '2018-06-01'),
(3453334, 'John Adams', 'Employee', '2007-05-30'),
(2234253, 'Alice Feilds', 'Faculty', '1997-05-25'),
(1234322, 'David Long', 'Faculty', '2009-01-01'),
(1983923, 'James Aker', 'Employee', '2012-03-15'),
(6482384, 'Henry Ford', 'Student', '2019-01-10'),
(5473934, 'Frank Gibbons', 'Student', '2019-06-10');