Comment 10 for bug 49698

You will find the schema and the patches we have applied to it in

    ./database/schema

Each patch was landed with a branch. The patches are named in major-minor-patch format. They are applied in order when you run `make schema`

Note the style, SQL keywords are CAPS.
All begin with this statement:
    SET client_min_messages=ERROR;

All end with the patch number to check that the database is correct for the branch you are developing.
    INSERT INTO LaunchpadDatabaseRevision VALUES (2109, 61, 1);

Name your patch patch-2109-99-0.sql, the last line of your patch will be
    INSERT INTO LaunchpadDatabaseRevision VALUES (2109, 99, 0);

When you patch is approved to land, you will be given an official patch number to rename and update the patch too.