SQL file to create 2016 default schema

[stephenb2]

Is there a provided SQL file to create the tables and columns for the TestStand 2016 default schema? I have not been able to find one.

I want to create an SQL file to add the columns to the tables with the changes from 2013.

Stephen

[stephenb2 · Accepted solution]

I found "MySQL Create Insert Result Tables.sql" in:

C:\Program Files (x86)\National Instruments\TestStand 2016\Components\Models\TestStandModels\Database

[stephenb2]

So it looks like the following should convert a MySQL database for TestStand 2013 to version 2016.

ALTER TABLE PROP_NUMERICLIMIT ADD THRESHOLD_TYPE VARCHAR(32);
ALTER TABLE PROP_NUMERICLIMIT ADD NOMINAL_VALUE DOUBLE;
ALTER TABLE PROP_NUMERICLIMIT ADD UPPER_THRESHOLD DOUBLE;
ALTER TABLE PROP_NUMERICLIMIT ADD LOWER_THRESHOLD DOUBLE;