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.
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. min_messages= ERROR;
All begin with this statement:
SET client_
All end with the patch number to check that the database is correct for the branch you are developing. seRevision VALUES (2109, 61, 1);
INSERT INTO LaunchpadDataba
Name your patch patch-2109- 99-0.sql, the last line of your patch will be seRevision VALUES (2109, 99, 0);
INSERT INTO LaunchpadDataba
When you patch is approved to land, you will be given an official patch number to rename and update the patch too.