use ics311su1014;

create table user (
        email           char(100)       primary key,
        firstname       char(30)        not null,
        lastname        char(30)        not null,
        jobtitle        char(80)        not null,
        department      char(80)        not null,
        organization    char(80)        not null,
        workphone       char(20)        not null,
        homephone       char(20),
        fax             char(20),
        breakfast       char(30),
        lunch           char(30),
        vegetarian      char(10),
        specialneed     char(100),
        fee             char(30),
        mnscu           char(10),
        date            date
);

insert into user values
  ("kuodi.jian@msn.com", "Kuodi", "Jian", "Assistant Professor", "Information and Computer Science", "Metropolitan State University", "651-793-1478", "651-765-9603", "651-793-1246", "breakfast", "lunch", "Yes", "Vegetarian Meals", "$50", "Yes", "2003-08-01"),
  ("bogus.jian@msn.com", "Bogus", "Jian", "President of United States", "Homeland security", "The powerful of the land company", "701-345-8888", "701-666-8970", NULL, "breakfast", NULL, "No", "Vegetarian Meals", "0", "No", "2004-01-02"),
  ("Julia.Thie@msn.com", "Julia", "Thie", "Business Consultant", "Iowa branch", "The mississppi river silver and gold mine LLC", "899-555-4444","888-345-9807", NULL, NULL, "lunch", "Yes", "vegetarian food", "$50", "Yes", "2004-09-02");

select *
from user;