.schema user_file_info
CREATE TABLE user_file_info (
	usid INTEGER NOT NULL, 
	uid INTEGER, 
	fid INTEGER, 
	score INTEGER, 
	rating INTEGER, 
	PRIMARY KEY (usid), 
	 FOREIGN KEY(uid) REFERENCES users (uid), 
	 FOREIGN KEY(fid) REFERENCES files (fid), 
	CONSTRAINT fid_uid  UNIQUE (fid, uid) <--- this was created with __table_args__  = (schema.UniqueConstraint('fid', 'uid',name="fid_uid"),{})
);
CREATE INDEX ix_user_file_info_fid ON user_file_info (fid);
CREATE INDEX ix_user_file_info_rating ON user_file_info (rating);
CREATE INDEX ix_user_file_info_score ON user_file_info (score);
CREATE INDEX ix_user_file_info_uid ON user_file_info (uid);
sqlite> CREATE UNIQUE INDEX ix_fid_uid ON user_file_info (fid,uid);
sqlite> .schema user_file_info
CREATE TABLE user_file_info (
	usid INTEGER NOT NULL, 
	uid INTEGER, 
	fid INTEGER, 
	score INTEGER, 
	rating INTEGER, 
	PRIMARY KEY (usid), 
	 FOREIGN KEY(uid) REFERENCES users (uid), 
	 FOREIGN KEY(fid) REFERENCES files (fid), 
	CONSTRAINT fid_uid  UNIQUE (fid, uid) <--- this was created with __table_args__  = (schema.UniqueConstraint('fid', 'uid',name="fid_uid"),{})
);
CREATE UNIQUE INDEX ix_fid_uid ON user_file_info (fid,uid); <-- this was created by typing in that line.
CREATE INDEX ix_user_file_info_fid ON user_file_info (fid);
CREATE INDEX ix_user_file_info_rating ON user_file_info (rating);
CREATE INDEX ix_user_file_info_score ON user_file_info (score);
CREATE INDEX ix_user_file_info_uid ON user_file_info (uid);