create table picnic_student
( userID bigint(20)unsigned not null auto_increment,
  username varchar(255) not null,
  pcard bigint(20) not null,
  majorID bigint(20) not null,
  mealPlan bigint(20) not null,
  foodKind bigint(20) not null,
  guests bigint(20) not null,
  date1 bigint(20) not null,
  date2 bigint(20) not null,
  date3 bigint(20) not null,
  date4 bigint(20) not null,
);

create table picnic_faculty
( 
  facID bigint(20)unsigned not null auto_increment,
  username varchar(255) not null,
  guests bigint(20) not null,
  foodKind bigint(20) not null,
  potluckItem bigint(20) not null,
  date1 bigint(20) not null,
  date2 bigint(20) not null,
  date3 bigint(20) not null,
  date4 bigint(20) not null,
);

create table picnic_admin
(
   adminID bigint(20)unsigned not null auto_increment,
   username varchar(255) not null,
   
);

create table picnic_table 
(

  picID bigint(20)unsigned not null auto_increment,
  date1 varchar(255) not null,
  date2 varchar(255) not null,
  date3 varchar(255) not null,
  date4 varchar(255) not null,
  guests bool,

);