Untitled

CREATE TABLE IF NOT EXISTS ledger (
	uid INT UNSIGNED,
	tid INT UNSIGNED AUTO_INCREMENT,
	previous FLOAT,
	change FLOAT,
	note VARCHAR,
	time TIMESTAMP,
	PRIMARY KEY (uid,tid),
	INDEX (uid,time));