[FSoD] How to add a new database column/row/slot

[SwitchBot]

How to add a new database column/row/slot in database.cs that could be used for the server, like /color. or do I just need to add the column/row/slot in rotmgprod.sql?
edit: i did the rotmgprod.sql editing already

[[MPGH]Ahl]

In heidisql (or phpmyadmin)

Go to the table you want. Now when the page loads, you should find this "add column" button or something similar.

Just enter your values in.

Now, in database.cs

I'll use public Account Register(string uuid, string password, bool isGuest, XmlData data) as an example.

To add a new column for this,

just add

cmd.Parameters.AddWithValue("@column", valuetype);

under

cmd.Parameters.AddWithValue("@empty", "");

If you read through the file, you should get the flow as to how it works

(sorry for a poor tutorial. I don't have phpmyadmin or heidisql to show you how it looks like)