

create table plugin_contacts (
contact_id int auto_increment not null,
contact_status varchar(10),
contact_firstName varchar(100),
contact_lastName varchar(100),
contact_title varchar(100),
contact_organisation varchar(255),
contact_address1 varchar(255),
contact_address2 varchar(255),
contact_town varchar(50),
contact_county varchar(25),
contact_postcode varchar(25),
contact_country varchar(255),
contact_phone varchar(50),
contact_fax varchar(50),
contact_email1 varchar(255),
contact_email2 varchar(255),
contact_url varchar(255),
contact_desc varchar(255),
contact_scope varchar(20),
contact_webCategory varchar(100),
contact_openNodes varchar(255),
primary key(contact_id),
unique id(contact_id)
);


create table plugin_contacts_category_lu (
contact_id int,
c_id int
);


alter table plugin_contacts add column contact_status varchar(10);
alter table plugin_contacts add column contact_scope varchar(20);
