db.migration.V2015.05.23.07.14.44__pmbok-plan-ddl.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of clusterra-pmbok-plan Show documentation

A application used as an example on how to set up pushing its components to the Central Repository.

There is a newer version: 1.1.3.RELEASE


    create table pmb_task (
        id int8 not null,
        assigneeUserId varchar(255),
        createdByUserId varchar(255),
        createdDate timestamp,
        description varchar(255),
        finishDate timestamp,
        modfiedByUserId varchar(255),
        modifiedDate timestamp,
        startDate timestamp,
        status varchar(255),
        parent_id int8,
        primary key (id)
    );

    alter table pmb_task 
        add constraint FK_by5y32v3pi4vmof8h9kpvsgo 
        foreign key (parent_id) 
        references pmb_task;

    create sequence pmb_task_seq;