CREATE TABLE magcomparison( id bigint(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
targetid bigint(20) NOT NULL, instrument text DEFAULT NULL, filepath text DEFAULT NULL,
filename varchar(100) DEFAULT NULL, temppath text DEFAULT NULL, tempname varchar(100) DEFAULT NULL,
tempdate text DEFAULT NULL, dayobs text DEFAULT NULL, objname text DEFAULT NULL,
inmag double DEFAULT 9999, diffmag double DEFAULT 9999, outlier boolean DEFAULT false);