The postgres table should look like this:
CREATE TABLE {nodecarousel} (
ncid int_unsigned NOT NULL default '0',
name varchar(32) NOT NULL,
title varchar(255) default NULL,
description varchar(255) default NULL,
access varchar(255) default NULL,
dynamic smallint NOT NULL default '0',
horizontal smallint NOT NULL default '1',
wrap varchar(8) NOT NULL default '0',
autoscroll smallint NOT NULL default '0',
index_control char(3) NOT NULL default '',
number_fetch integer NOT NULL default '1',
number_scroll integer NOT NULL default '1',
number_visible integer NOT NULL default '3',
start_position integer NOT NULL default '1',
animation_speed varchar(5) NOT NULL default 'slow',
prev_text varchar(255) default NULL,
next_text varchar(255) default NULL,
first_text varchar(255) default NULL,
last_text varchar(255) default NULL,
node_source integer NOT NULL default '0',
node_types varchar(255) default NULL,
taxonomy_vids varchar(255) default NULL,
nodequeue_qid BIGINT default NULL CHECK(nodequeue_qid > 0),
sort varchar(255) default NULL,
sort_ascending smallint NOT NULL default '0',
js_scroll_function text default NULL,
PRIMARY KEY (ncid)
);
Comments
Comment #1
japerrytaxonomy_vids varchar(255) default NULL, --> should be changed to:
taxonomy_tids varchar(255) default NULL,
Comment #2
jcfiala commentedThanks! I'll try to look at this soon and incorporate it into the code. I did my best doing the postgres by dead reckoning.... I really like how drupal 6 handles that for you!