 
 CREATE TABLE MiniGameMedia (
 	MediaID INT PRIMARY KEY IDENTITY
-	, MiniGameID INT REFERENCES Minigames (MiniGameID)
+	, MiniGameID INT REFERENCES Minigames (MiniGameID) NOT NULL
 	, Difficulty INT default NULL	--nulled if media is used for every instance of that game
 	, MiniGameMedia VARBINARY(max) NOT NULL);
 
 CREATE TABLE ProfileProgressHistory (
 	ProgressID INT PRIMARY KEY IDENTITY
-	, ProfileID INT REFERENCES Profiles (ProfileID)
+	, ProfileID INT REFERENCES Profiles (ProfileID) NOT NULL
 	, MiniGameID INT REFERENCES Minigames (MiniGameID));
	AnimalID INT PRIMARY KEY IDENTITY
	, FunFact VARCHAR(250)
	, Shiny BIT NOT NULL --1 means it is shiny
	, SoundID INT REFERENCES Sounds (SoundID)
	, ImageID INT REFERENCES Images (ImageID));

CREATE TABLE Users (
	UserID INT PRIMARY KEY IDENTITY


CREATE TABLE Profiles (
	ProfileID INT PRIMARY KEY IDENTITY
	, UserID INT REFERENCES Users (UserID) NOT NULL
	, AvatarID INT REFERENCES Images (ImageID) NOT NULL
	, ProfileName NVARCHAR(30) NOT NULL
	, ToggleSound BIT NOT NULL default 1 --0 = sound off, 1 = sound on, defualted to sound on
	, ToggleMusic BIT NOT NULL default 1
