EAR-Database.md

@@ -78,9 +78,23 @@ Additionally, if EAR was compiled in a system with GPUs (or with the GPU flag ma
 
 ### From EAR 4.2 to 4.3
 
-> **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).
+To add support for workflows, a new field was added to several tables to allow their accounting:
+```
+ALTER TABLE Jobs ADD COLUMN local_id INT UNSIGNED NOT NULL AFTER step_id;
+ALTER TABLE Jobs DROP PRIMARY KEY, ADD PRIMARY KEY (job_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 Loops ADD COLUMN local_id INT UNSIGNED NOT NULL AFTER step_id;
+```
 
 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).
+
 ```
 ALTER TABLE Signatures
 ADD COLUMN L1_misses BIGINT UNSIGNED AFTER perc_MPI,
@@ -93,6 +107,8 @@ ADD COLUMN L1_misses BIGINT UNSIGNED AFTER perc_MPI,
 ADD COLUMN L2_misses BIGINT UNSIGNED AFTER L1_misses,
 ADD COLUMN L3_misses BIGINT UNSIGNED AFTER L2_misses;
 ```
+
+
 ### From EAR 4.1 to 4.2
 
 A field in the Events table had its name changed to be more generic. One can do that with EITHER of the following commands: