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

create table partyguest (
	partyId			integer,
	userId			integer,
	userPayed		tinyint(1),
	primary key(partyId,userId),
	foreign key (partyId) references party(partyId),
	foreign key (userId) references users(userId)

	primary key(partyType)
);

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