Postgres Milestone table definition not the same as SQLite

[nick.stone@…]

The definition of the Milestone table for Postgres and SQLite is different. This is causing problems when converting between the two but I imagine may also cause problems elsewhere. I ve included the definitions that get created below:

SQLite def:

CREATE TABLE milestone (
    name            text PRIMARY KEY,
    due             integer, -- Due date/time
    completed       integer, -- Completed date/time
    started        integer, -- Started date/time
    description     text
)

Postgreql def:

CREATE TABLE milestone
(
  name text NOT NULL,
  due int4,
  completed int4,
  description text,
  CONSTRAINT milestone_pkey PRIMARY KEY (name)
) 
WITHOUT OIDS;

I'm happy to create a fix if somebody points me in the right direction

[nick.stone@…]

Sorry all - the problem is the burndown plug-in that we're using off the Trac-hacks site. My appologies for posting that here..