Miscellany

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- */);