Update schema

1 files changed, 13 insertions, 1 deletions

diff --git a/topics/data-uploads/editing-data.gmi b/topics/data-uploads/editing-data.gmi
index 51f5e50..390788d 100644
--- a/topics/data-uploads/editing-data.gmi
+++ b/topics/data-uploads/editing-data.gmi
@@ -23,6 +23,18 @@ First, run this sql script to add the "metadata<sub>audit</sub>" table:
 
 => https://github.com/genenetwork/genenetwork3/blob/main/sql/metadata_audit.sql Sql script to run
 
+Example
+
+```
+mysql -u webqtlout db_webqtl < metadata_audit.sql
+```
+
+And check this works
+
+```
+select * FROM information_schema.COLUMNS WHERE table_schema=DATABASE() AND TABLE_NAME='metadata_audit';
+```
+
 For everything to run, use the latest commit on the main branch from gn3. One way to make sure that you are running the latest changes, make sure that you have genenetwork3 cloned somewhere in your path; and keep it updated. Thereafter set, a PATH in "bin/genenetwork2" which should look something similar to `export PYTHONPATH=/home/bonface/projects/genenetwork3:$PYTHON_GN_PATH:$GN2_BASE_DIR/wqflask:$PYTHONPATH`.
 
 Alternatively, install gn3 in it's own profile. This can be sometimes inconvenient since the latest changes from gn3 can be ahead of the the package definition in our channel.
@@ -47,4 +59,4 @@ After editing traits, you could see changes in a diff format at the very top of
 
 That needs to be improved.
 
-- For Probeset data, atm some tables aren't yet updated(unfortunately those tables aren't used anywhere). I need to figure that out.
\ No newline at end of file
+- For Probeset data, atm some tables aren't yet updated(unfortunately those tables aren't used anywhere). I need to figure that out.