Creating a new DB table

[noesac]

I need to create a new table to help generate some data feeds.

I'm hoping this will make my life a lot easier (instead of having to constantly merge stuff via Excel).

Can someone have a quick glance over my setup to make sure I'm not doing anything wrong?

http://i52.tinypic.com/2hx7jap.png

this is the data model (very simple, one to one mapping, basically I just need to extend the ps_product table but I'm trying to avoid having to modify it as I am not confident that I would not screw it up):

http://i52.tinypic.com/acbi49.png

[Bruno Chavez]

Hi

In the first image, I recomend you use varchar 255 because a text field spend a lot of db space, and with a varchar is cheapper...

This is the only thing I can recommend because I'm new in prestashop...

Regards
Bruno

[noesac]

Ok thanks, I'm going to be putting long URL's and huge blocks of text (with html) in these fields, will that be ok for a varchar 255?

[Bruno Chavez]

If you will put a huge text then text is ok...

[noesac]

So is it ok if I leave everything else blank the way I have?

[noesac]

Just bumping this. I'm just being really cautious before I create this table...

[MrBaseball34]

The product_url and image_url columns can be varchar(500), that should handle things easily, I doubt that you will have a url that long in Prestashop ever. http://www.boutell.com/newfaq/misc/urllength.html

Leave the rest alone.