 drop table if exists sittingforeman;
 drop table if exists party;
 drop table if exists partytype;
-drop table if exists partyuser;
+drop table if exists partycreator;
 drop table if exists partyguest;
 drop table if exists log;
 drop table if exists event;

	primary key(partyType)
);

create table partyuser (
	partyId			integer,
	userId			integer,
	primary key(partyId,userId),

	partyId			integer auto_increment,
	partyName		varchar(30),
	partyType		varchar(20),
	sittingDate		date NOT NULL,
	partyInterest	integer,
	partyPrel		integer DEFAULT 0,
	partyPayed		integer DEFAULT 0,
	primary key(partyId),
	foreign key(partyType) references partytype(partyType),
	foreign key(sittingDate) references sitting(sittDate)
);

create table partytype (
