EAR-Database.md

@@ -92,18 +92,22 @@ ALTER TABLE Jobs DROP PRIMARY KEY, ADD PRIMARY KEY (id, step_id, local_id);
 
 ```
 ALTER TABLE Applications ADD COLUMN local_id INT UNSIGNED NOT NULL AFTER step_id;
-ALTER TABLE Applications DROP PRIMARY KEY, ADD PRIMARY KEY (job_id, step_id, local_id);
+ALTER TABLE Applications DROP PRIMARY KEY, ADD PRIMARY KEY (job_id, step_id, local_id, node_id);
 ```
 
 ```
 ALTER TABLE Loops ADD COLUMN local_id INT UNSIGNED NOT NULL AFTER step_id;
 ```
 
+**NOTE** if the `id` in Jobs has been changed to `job_id`, the query to change primary keys will be:
+```
+ALTER TABLE Jobs DROP PRIMARY KEY, ADD PRIMARY KEY (job_id, step_id, local_id);
+```
 ### From EAR 4.2 to 4.3
 
 Three new fields corresponding to L1, L2 and L3 cache misses have been added to the signatures.
 
-> **NOTE** This change only applies to the databases that have been created with the extended application signature (i.e. they have the FLOPS, instructions and cycles counters in their signatures).
+**NOTE** This change only applies to the databases that have been created with the extended application signature (i.e. they have the FLOPS, instructions and cycles counters in their signatures).
 
 ```
 ALTER TABLE Signatures