CREATE TABLE Users (
	UserID int NOT NULL IDENTITY(1,1),
	Email varchar(100) NOT NULL,
	DisplayName varchar(100),
	Password char(32),
	CONSTRAINT pk_Users PRIMARY KEY (
		UserID
	)
)

GO

CREATE TABLE Applications (
	ApplicationID int NOT NULL IDENTITY(1,1),
	Name varchar(100) NOT NULL,
	Publisher varchar(100) NOT NULL,
	IntegrationDate datetime NOT NULL,
	RedirectUrl varchar(500) NOT NULL,
	CONSTRAINT pk_Applications PRIMARY KEY (
		ApplicationID
	)
)

GO

CREATE TABLE UserSessions (
	SessionID uniqueidentifier NOT NULL,
	UserID int NOT NULL,
	Created datetime NOT NULL,
	Expires datetime NOT NULL,
	Serviced datetime,

	CONSTRAINT pk_UserSessions PRIMARY KEY (
		SessionID
	),
	
	CONSTRAINT fk_UserSessions_UserID FOREIGN KEY (
		UserID
	) REFERENCES Users(
		UserID
	)
)