DROP TABLE IF EXISTS ud_sessions;
DROP TABLE IF EXISTS ud_lastvisited;
DROP TABLE IF EXISTS ud_visitedlog;

CREATE TABLE ud_sessions(
	SesUserCookie CHAR(32) NOT NULL,
	SesUserID INT UNSIGNED NOT NULL DEFAULT 1,
	SesUserInsertPassword ENUM('0','1') NOT NULL DEFAULT '0',
	SesUserLastIP CHAR(15),
	SesUserLastAccessDate TIMESTAMP NOT NULL,
	UNIQUE INDEX (SesUserCookie)
);

CREATE TABLE ud_lastvisited (
	LVUserID INT UNSIGNED NOT NULL DEFAULT 0,
	LVUserCookie CHAR(32) NOT NULL,
	LVDate DATETIME NOT NULL,
	LVSectionType TINYINT UNSIGNED,
	LVSectionIdN INT UNSIGNED NOT NULL,
	KEY(LVUserID),
	KEY(LVUserCookie)
);

CREATE TABLE ud_visitedlog (
	VLogDate DATETIME NOT NULL,
	VLogUserType TINYINT UNSIGNED NOT NULL,
	VLogUserCookie CHAR(32) NOT NULL,
	VLogUserIP CHAR(15),
	VLogUserBrowser CHAR(32),
	VLogRefPage CHAR(255),
	VLogPage CHAR(70) NOT NULL,
	VLogPageQuery CHAR(170),
	KEY(VLogDate),
	KEY(VLogUserType),
	KEY(VLogPage)
);