Will adding a new row to MySQL brake my forum?

Started by General Xbox Gaming, September 02, 2014, 04:22:28 AM

Previous topic - Next topic

General Xbox Gaming

Can I add a new column to the end of smf_members without it braking my forum, even if it isn't used by my forum itself?

I want to add a key that I write with php outside of smf but I don't want to cause database errors. Is this possible to do or do I need a new database?

Arantor

Provided you set a default value on that column when adding it, it'll be fine.

General Xbox Gaming

Quote from: Arantor on September 02, 2014, 08:46:29 AM
Provided you set a default value on that column when adding it, it'll be fine.
So adding 'user_key' to the last column is fine right?

kat

Just thinking out loud, here...

Back up the database. TWICE.

Do what you're thinking of doing.

If something breaks, you can restore the backup. :)

Arantor

Quote from: General Xbox Gaming on September 02, 2014, 10:05:42 AM
Quote from: Arantor on September 02, 2014, 08:46:29 AM
Provided you set a default value on that column when adding it, it'll be fine.
So adding 'user_key' to the last column is fine right?

Yes, provided you give it a default value when you create it since registerMember() won't know what to do with it otherwise.

General Xbox Gaming


Advertisement: