Default image location

hey guys,

I’ve been looking through the database tables and can’t seem to figure out where it stores the location to the image files, not the thumbnails.

i have a tab delimited text file with product code and name of the image on each line. I also have a folder full of 10,000 product images.

I’ve upload all the images into 2 separate folders ‘/images/large’ and ‘/images/small’. The large folder contains the large images and the small folder contains small 90x90 thumbnails of the images.

I’m writing a little script to set the product image location for each product based on the product code but i can’t find where the image locations are stored in the database.

Can someone point me in the right direction?