

drop table if exists calendar;
create table calendar (
   username char (20),
   password char (20),
   email char (80),
   sched char(200),
   verified char(15),
   createTime int(20),
   ID int auto_increment not null primary key
   );
   


insert into calendar (username, password, email, sched, verified) values
  ('smithj', 'student', 'smithj@udel.edu', 'M:1,1,1,1,0,0,0,0,0,0,0,1,1,1,1,0;T:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;W:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;T:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;F:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;', 'verfied');

insert into calendar (username, password, email, sched) values
  ('jjones', 'student', 'jjones@udel.edu', 'M:1,1,1,1,0,0,0,0,0,0,0,1,1,1,1,0;T:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;W:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;T:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;F:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0; '
  );



insert into calendar (username, password, email, sched) values
  ('skogenj', 'student', 'skogenj@udel.edu', 'M:1,1,1,1,0,0,0,0,0,0,0,1,1,1,1,0;T:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;W:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;T:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0;F:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0; '
  );

