Mercurial > hg > LightPIT / file revision

• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

setup/postgres/psql_default_data.sql@698541f09380

setup/postgres/psql_default_data.sql

Sun, 14 Sep 2025 16:37:47 +0200

author

Mike Becker <universe@uap-core.de>

date

Sun, 14 Sep 2025 16:37:47 +0200

changeset 388

698541f09380

parent 253

e1cd3e698037

permissions

-rw-r--r--

improve solution for issue #719

It is no longer necessary to work with placeholder strings just to fill the gaps (=empty rows) between the fields.

insert into lpit_issue_phases (status, phase) values
    ('InSpecification', 0),
    ('ToDo', 0),
    ('Scheduled', 0),
    ('InProgress', 1),
    ('InReview', 1),
    ('Ready', 1),
    ('Done', 2),
    ('Rejected', 2),
    ('Withdrawn', 2),
    ('Duplicate', 2);