create table products ( 
	id serial primary key, 
	status varchar(100), 
	name varchar(500),
	condition varchar(2000),
	title varchar(1000),
	description varchar(2000),
	keywords varchar(2000),
	pseudonym varchar(1000), 
	pseudonym_picture varchar(2000),
	body text, 
	autoresponder integer(15),
	company varchar(1000), 
	layout varchar(200),
	sales_phone varchar(100),
	contact_phone varchar(100),
	international_phone varchar(100) 
);

create table articles (
	id serial primary key,
	product_id integer,
	title varchar(2000),
	description varchar(2000),
	keywords varchar(2000),
	body text
);

create table posts (
	id serial primary key,
	product_id integer,
	title varchar(2000),
	description varchar(2000),
	keywords varchar(2000),
	body text
);

create table headers (
	id serial primary key,
	product_id integer,
	description text,
	file varchar(1024),
	layout varchar(200) 
);

create table photo_banners (
	id serial primary key,
	product_id integer,
	description text,
	file varchar(1024), 
	layout varchar(200)
);

create table bottle_images (
	id serial primary key,
	product_id integer,
	description text,
	file varchar(1024)
);

create table sales_images (
	id serial primary key,
	product_id integer,
	description text,
	file varchar(1024),
); 

create table images (
	id serial primary key,
	description varchar(500),
	file varchar(1024)
);

create table affiliate_images (
	id serial primary key,
	product_id integer,
	description varchar(500),
	file varchar(1024) 
);

create table testimonials (
	id serial primary key,
	product_id integer,
	customer_image varchar(1000),
	body text 
);

create table offers (
	id serial primary key,
	cart_number integer, /* The 1shoppingcart merchantID */
	name varchar(512), /* Should match the 1shoppingcart string */
	description varchar(512), /* Copy-dependent? */
	retail_cost_per_unit decimal(10,2), /* Retail cost per unit */
	current_price decimal(10,2) /* And the current price to figure -supah savings- */
);