DROP TABLE IF EXISTS numbers; CREATE TABLE numbers ( n bigint not null primary key, dNextPrime int, dPrevPrime int, dPrimePrime int, nextPrime bigint, prevPrime bigint, factors text, factorCount int, factorSum int, prime tinyint, even tinyint, power tinyint ); DROP TABLE IF EXISTS numbers_location; CREATE TABLE numbers_location ( current_loc bigint, prevPrime bigint, ts timestamp );