Add a database column

I’m quite new to CS Cart and am muddling my way through creating an add on to store some extra information about categories. How do I go about actually setting up the add on to install the column into the db schema when the add on is installed?

Of course I could be going about this the wrong way… is there a preferred way to store add on data using cs cart?

Any help is much appreciated!