Since I happen to use PostgresQL not MySQL at my site I altered the cvbuilder.mysql file to be usable in postgres, this script is (pasted here as I dont seem to be allowed to include more than one file attachment to this message).

However this is not quite enough as some of the select clauses used " " to protect strings, so I altered these to the ' ' used in postgres. As I dont have a mysql server handy to test on I'm not sure wether this breaks mysql (as far as a quick glance at the rest of drupals code suggest that they just use ' ' consistently so I think mysql supports both). A patch between cvbuilder.module file in the 4.6.0.tar.gz I downloaded and the edited version is in the attached file.

BEGIN;
CREATE TABLE cvbuilder_address (
nid integer NOT NULL default '0',
address1 varchar(255) NOT NULL default '',
address2 varchar(255) NOT NULL default '',
town varchar(255) NOT NULL default '',
county varchar(255) NOT NULL default '',
postcode varchar(255) NOT NULL default '',
phone varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
web varchar(255) NOT NULL default '',
PRIMARY KEY (nid)
);

CREATE TABLE cvbuilder_experience (
nid integer NOT NULL default '0',
employeraddress varchar(255) NOT NULL default '',
jobtitle varchar(255) NOT NULL default '',
startdate_month varchar(20) DEFAULT '',
startdate_year varchar(4) DEFAULT '',
enddate_month varchar(20) DEFAULT '',
enddate_year varchar(4) DEFAULT '',
duties text NOT NULL default '',
achievements text NOT NULL default '',
PRIMARY KEY (nid)
);

CREATE TABLE cvbuilder_schoolcollege (
nid integer NOT NULL default '0',
startdate_month varchar(20) DEFAULT '',
startdate_year varchar(4) DEFAULT '',
enddate_month varchar(20) DEFAULT '',
enddate_year varchar(4) DEFAULT '',
address varchar(255) NOT NULL default '',
quals text NOT NULL default '',
PRIMARY KEY (nid)
);

CREATE TABLE cvbuilder_referee (
nid integer NOT NULL default '0',
position varchar(255) NOT NULL default '',
address varchar(255) NOT NULL default '',
relationship varchar(255) NOT NULL default '',
maycontact smallint NOT NULL default '0',
PRIMARY KEY (nid)
);

CREATE TABLE cvbuilder_skills (
nid integer NOT NULL default '0',
description text NOT NULL default '',
PRIMARY KEY (nid)
);
COMMIT;

CommentFileSizeAuthor
cvbuilder.postgres.patch2.01 KBgathond

Comments

gathond’s picture

Priority: Critical » Minor

Sorry about the criticality thing, forgot to change it

handelaar’s picture

Status: Needs review » Active

Patch doesn't apply. Altering status accordingly.