CREATE TABLE bitmagnet_processed ( id INTEGER PRIMARY KEY, magnet_id INTEGER NOT NULL, processed_at DATETIME NOT NULL, FOREIGN KEY (magnet_id) REFERENCES magnets (id) ); CREATE INDEX bitmagnet_processed_magnet_id ON bitmagnet_processed (magnet_id);