JBossDeveloper

I see in the dayly build of yesterday that the bb and the faq packages donot have postgreSQL setup.dll files.

for the bb part I have the following:

CREATE TABLE phpbb_categories (
 cat_id INTEGER PRIMARY KEY NOT NULL,
 cat_title VARCHAR(100) default '' NOT NULL,
 cat_order INTEGER default '0' NOT NULL
);
CREATE TABLE phpbb_forums (
 forum_id INTEGER NOT NULL PRIMARY KEY,
 cat_id INTEGER DEFAULT NULL NULL,
 forum_name VARCHAR(150) default '' NOT NULL,
 forum_desc VARCHAR default '' NOT NULL,
 forum_status INTEGER default '0' NOT NULL,
 forum_order INTEGER default '1' NOT NULL,
 forum_posts INTEGER default '0' NOT NULL,
 forum_topics INTEGER default '0' NOT NULL,
 forum_last_post_id INTEGER DEFAULT NULL NULL,
 prune_next INTEGER DEFAULT NULL NULL,
 prune_enable BOOLEAN default false NOT NULL,
 auth_view INTEGER default '0' NOT NULL,
 auth_read INTEGER default '0' NOT NULL,
 auth_post INTEGER default '1' NOT NULL,
 auth_reply INTEGER default '1' NOT NULL,
 auth_edit INTEGER default '3' NOT NULL,
 auth_delete INTEGER default '3' NOT NULL,
 auth_sticky INTEGER default '3' NOT NULL,
 auth_announce INTEGER default '3' NOT NULL,
 auth_vote INTEGER default '1' NOT NULL,
 auth_pollcreate INTEGER default '3' NOT NULL,
 auth_attachments INTEGER default '0' NOT NULL
);
CREATE TABLE phpbb_topics (
 topic_id INTEGER NOT NULL PRIMARY KEY,
 forum_id INTEGER default NULL NULL,
 topic_title char(60) default '' NOT NULL,
 topic_poster INTEGER default NULL NULL,
 topic_time TIMESTAMP default '0000-01-01 00:00:00' NOT NULL,
 topic_views INTEGER default '0' NOT NULL,
 topic_replies INTEGER default '0' NOT NULL,
 topic_status INTEGER default '0' NOT NULL,
 topic_vote BOOLEAN default false NOT NULL,
 topic_type INTEGER default '0' NOT NULL,
 topic_first_post_id INTEGER default NULL NULL,
 topic_last_post_id INTEGER default NULL NULL,
 topic_last_post_time TIMESTAMP default '0000-01-01 00:00:00' NOT NULL,
 topic_moved_id INTEGER default NULL NULL
);
CREATE TABLE phpbb_posts (
 post_id INTEGER NOT NULL PRIMARY KEY,
 topic_id INTEGER default NULL NULL,
 forum_id INTEGER default NULL NULL,
 poster_id INTEGER default NULL NULL,
 post_time TIMESTAMP default '0000-01-01 00:00:00' NOT NULL,
 poster_ip VARCHAR(8) default '' NOT NULL,
 post_username VARCHAR(25) default NULL NULL,
 enable_bbcode BOOLEAN default true NOT NULL,
 enable_html BOOLEAN default false NOT NULL,
 enable_smilies BOOLEAN default true NOT NULL,
 enable_sig BOOLEAN default true NOT NULL,
 post_edit_time TIMESTAMP default '0000-01-01 00:00:00' NOT NULL,
 post_edit_count INTEGER default '0' NOT NULL,
 post_subject VARCHAR(60) default '' NOT NULL,
 post_text TEXT default '' NOT NULL
);
CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id);
CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id);
CREATE TABLE phpbb_topics_watch (
 topic_id INTEGER NOT NULL,
 user_id INTEGER NOT NULL,
 notify_status BOOLEAN default false NOT NULL
);
CREATE TABLE phpbb_vote_desc (
 vote_id INTEGER NOT NULL PRIMARY KEY,
 topic_id INTEGER default NULL NULL,
 vote_text text NOT NULL,
 vote_start INTEGER default '0' NOT NULL,
 vote_length INTEGER default '0' NOT NULL
);
CREATE TABLE phpbb_vote_results (
 vote_option_id INTEGER NOT NULL PRIMARY KEY,
 vote_desc_id INTEGER default NULL NULL,
 vote_option_text VARCHAR(255) default '' NOT NULL,
 vote_result INTEGER default '0' NOT NULL
);
CREATE TABLE phpbb_vote_voters (
 vote_id INTEGER NOT NULL PRIMARY KEY,
 vote_desc_id INTEGER default NULL NULL,
 vote_user_id INTEGER default NULL NULL,
 vote_user_ip VARCHAR(8) default '' NOT NULL
);

INSERT INTO phpbb_categories VALUES(0,'My category',10);
INSERT INTO phpbb_forums VALUES(0,0,'My forum','This is a sample forum',0,10,0,0,NULL,NULL,false,0,0,1,1,1,1,3,3,3,3,0);

for the faq postgreSQL setup.dll I have:

CREATE TABLE public.nuke_faq_categories
(
 pn_id serial NOT NULL,
 pn_parent_id int4,
 pn_name varchar(256) NOT NULL DEFAULT '',
 pn_language varchar(30) NOT NULL DEFAULT '',
 CONSTRAINT nuke_faq_categories_pkey PRIMARY KEY (pn_id)
) WITH OIDS;

CREATE TABLE public.nuke_faq
(
 pn_id serial NOT NULL,
 pn_category_id int4,
 pn_question varchar(256) NOT NULL DEFAULT '',
 pn_submitter varchar(256) NOT NULL DEFAULT '',
 pn_answer varchar(256) NOT NULL DEFAULT '',
 CONSTRAINT nuke_faq_pkey PRIMARY KEY (pn_id)
) WITH OIDS;


I hope this helps....
I have to look at the DB stuff a little, maybe I forgot some changes in the id's...

whoops, yes... I forgot some changes I made....
here's the new bb part, copied straight from my database...

CREATE TABLE public.phpbb_categories
(
 cat_id int4 NOT NULL DEFAULT nextval('phpbb_categories_cat_id_seq'::text),
 cat_title varchar(100) NOT NULL DEFAULT '',
 cat_order int4 NOT NULL DEFAULT '0',
 CONSTRAINT phpbb_categories_pkey PRIMARY KEY (cat_id)
);

CREATE TABLE public.phpbb_forums
(
 forum_id int4 NOT NULL DEFAULT nextval('phpbb_forums_forum_id_seq'::text),
 cat_id int4,
 forum_name varchar(150) NOT NULL DEFAULT '',
 forum_desc varchar NOT NULL DEFAULT '',
 forum_status int4 NOT NULL DEFAULT '0',
 forum_order int4 NOT NULL DEFAULT '1',
 forum_posts int4 NOT NULL DEFAULT '0',
 forum_topics int4 NOT NULL DEFAULT '0',
 forum_last_post_id int4,
 prune_next int4,
 prune_enable bool NOT NULL DEFAULT false,
 auth_view int4 NOT NULL DEFAULT '0',
 auth_read int4 NOT NULL DEFAULT '0',
 auth_post int4 NOT NULL DEFAULT '1',
 auth_reply int4 NOT NULL DEFAULT '1',
 auth_edit int4 NOT NULL DEFAULT '3',
 auth_delete int4 NOT NULL DEFAULT '3',
 auth_sticky int4 NOT NULL DEFAULT '3',
 auth_announce int4 NOT NULL DEFAULT '3',
 auth_vote int4 NOT NULL DEFAULT '1',
 auth_pollcreate int4 NOT NULL DEFAULT '3',
 auth_attachments int4 NOT NULL DEFAULT '0',
 CONSTRAINT phpbb_forums_pkey PRIMARY KEY (forum_id)
);

CREATE TABLE public.phpbb_topics
(
 forum_id int4,
 topic_title bpchar(60) NOT NULL DEFAULT '',
 topic_poster int4,
 topic_time timestamp NOT NULL DEFAULT '0000-01-01 00:00:00',
 topic_views int4 NOT NULL DEFAULT '0',
 topic_replies int4 NOT NULL DEFAULT '0',
 topic_status int4 NOT NULL DEFAULT '0',
 topic_vote bool NOT NULL DEFAULT false,
 topic_type int4 NOT NULL DEFAULT '0',
 topic_first_post_id int4,
 topic_last_post_id int4,
 topic_last_post_time timestamp NOT NULL DEFAULT '0000-01-01 00:00:00',
 topic_moved_id int4,
 topic_id int4 NOT NULL DEFAULT nextval('phpbb_topics_topic_id_seq'::text),
 CONSTRAINT phpbb_topics_pkey PRIMARY KEY (topic_id)
);

CREATE TABLE public.phpbb_posts
(
 post_id int4 NOT NULL DEFAULT nextval('phpbb_posts_post_id_seq'::text),
 topic_id int4,
 forum_id int4,
 poster_id int4,
 post_time timestamp NOT NULL DEFAULT '0000-01-01 00:00:00',
 poster_ip varchar(8) NOT NULL DEFAULT '',
 post_username varchar(25),
 enable_bbcode bool NOT NULL DEFAULT true,
 enable_html bool NOT NULL DEFAULT false,
 enable_smilies bool NOT NULL DEFAULT true,
 enable_sig bool NOT NULL DEFAULT true,
 post_edit_time timestamp NOT NULL DEFAULT '0000-01-01 00:00:00',
 post_edit_count int4 NOT NULL DEFAULT '0',
 post_subject varchar(60) NOT NULL DEFAULT '',
 post_text text NOT NULL DEFAULT '',
 CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id)
);

CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id);
CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id);

CREATE TABLE public.phpbb_topics_watch
(
 topic_id int4 NOT NULL,
 user_id int4 NOT NULL,
 notify_status bool NOT NULL DEFAULT false
);

CREATE TABLE public.phpbb_vote_desc
(
 vote_id int4 NOT NULL DEFAULT nextval('phpbb_vote_desc_vote_id_seq'::text),
 topic_id int4,
 vote_text text NOT NULL,
 vote_length int4 NOT NULL DEFAULT '0',
 vote_start timestamp NOT NULL DEFAULT '0001-01-01 00:00:00 BC'::timestamp without time zone,
 CONSTRAINT phpbb_vote_desc_pkey PRIMARY KEY (vote_id)
);

CREATE TABLE public.phpbb_vote_results
(
 vote_option_id int4 NOT NULL DEFAULT nextval('phpbb_vote_results_vote_option_id_seq'::text),
 vote_desc_id int4,
 vote_option_text varchar(255) NOT NULL DEFAULT '',
 vote_result int4 NOT NULL DEFAULT '0',
 CONSTRAINT phpbb_vote_results_pkey PRIMARY KEY (vote_option_id)
);

CREATE TABLE public.phpbb_vote_voters
(
 vote_id int4 NOT NULL DEFAULT nextval('phpbb_vote_voters_vote_id_seq'::text),
 vote_desc_id int4,
 vote_user_id int4,
 vote_user_ip varchar(8) NOT NULL DEFAULT '',
 CONSTRAINT phpbb_vote_voters_pkey PRIMARY KEY (vote_id)
);


INSERT INTO phpbb_categories VALUES(0,'My category',10);
INSERT INTO phpbb_forums VALUES(0,0,'My forum','This is a sample forum',0,10,0,0,NULL,NULL,false,0,0,1,1,1,1,3,3,3,3,0);