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;