-- DigiMina subjects table
CREATE TABLE IF NOT EXISTS prefix_digimina_subjects (
    id int(11) NOT NULL AUTO_INCREMENT,
	name varchar(255) NOT NULL,
	PRIMARY KEY(id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- DigiMina review table
CREATE TABLE IF NOT EXISTS prefix_digimina_review (
	id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	user_guid bigint(20) unsigned NOT NULL,
	test_guid bigint(20) unsigned NOT NULL,
	competency_guid bigint(20) unsigned NOT NULL,
	status varchar(255) NOT NULL DEFAULT 'pending',
	time_created int(11) NOT NULL,
	time_updated int(11) NOT NULL,
	PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
