changed long type to BIGINT