changed BIGINT to INT, completed vendor insert