#71 Bug in Postgresql script

[Anonymous]

In SQL script there are 'auto_increment' columns, but
there is no 'auto_increment' statement in Postgresql.

You have to change two tables definitions to:

DROP SEQUENCE issueDetail_seq;
CREATE SEQUENCE issueDetail_seq;

DROP TABLE issueDetail;
CREATE TABLE issueDetail (
id bigint NOT NULL DEFAULT nextval('issueDetail_seq'),
issueId bigint NOT NULL ,
trigram char (3) NOT NULL ,
description varchar (250) NULL
) ;

DROP SEQUENCE issueTime_seq;
CREATE SEQUENCE issueTime_seq;

DROP TABLE issueTime;
CREATE TABLE issueTime (
id bigint NOT NULL DEFAULT nextval('issueTime_seq'),
issueDetailId bigint NOT NULL ,
beginDate timestamp NOT NULL ,
endDate timestamp NULL
) ;