(An Untitled Masterwork)
ActivePublic
Actions

Authored by stwalkerster on Jun 2 2017, 8:52 AM.

Tags

Referenced Files

	F20857:
	Jun 2 2017, 8:52 AM

Subscribers

None

	CREATE TABLE session (
	id INT(11) NOT NULL PRIMARY KEY auto_increment,
	update_version INT(11) NOT NULL DEFAULT 0,
	cookie VARCHAR(64) NOT NULL,
	user INT(11),
	location VARCHAR(32),
	lastactivity TIMESTAMP NOT NULL,
	login TIMESTAMP NOT NULL,
	nextmfa INT(11) NOT NULL DEFAULT 1,
	FOREIGN KEY fk_session_user (user) REFERENCES user (id)
	) ENGINE=InnoDB;

	CREATE TABLE sessionalert (
	id INT(11) NOT NULL PRIMARY KEY auto_increment,
	update_version INT(11) NOT NULL DEFAULT 0,
	session INT(11) NOT NULL,
	type VARCHAR(10) NOT NULL,
	content BLOB,
	FOREIGN KEY fk_sessionalert_session (session) REFERENCES session (id)
	) ENGINE=InnoDB;

stwalkerster created this object with visibility "Public (No Login Required)".

(An Untitled Masterwork)ActivePublicActions