I would like to create a table using an event driven script so that I might make future installations require only the Ignition backup instead of restoring irrelevant data to my fresh databases.
So I want to have a way of creating the skeleton for the tables I will need associated with a project backup so I won’t have to enter the database management.
I want something like this
system.db.runQuery(CREATE TABLE example (id INT IDENTITY (1,1),
name VARCHAR(55) NOT NULL,timestamp datetime NOT NULL);)
Or if anyone knows a better way to manage creating tables. Lets hear it.