Is it safe to change the sourcemod database schema?

temp321 · **Author**

I am wondering if it is safe to change the schema of the sm_admins database.

Specifically I want to change the "identity" column to be "unique". Is there any harm in doing this? And if not, why isn't it the default?

Xsinthis · 10-05-2010 , 23:57 Re: Is it safe to change the sourcemod database schema?

A better question is, why do you want to do it?

temp321 · 10-06-2010 , 14:57 Re: Is it safe to change the sourcemod database schema?

I want to do it so I can interface with my donation system.

INSERT ON DUPLICATE KEY doesn't work properly unless identity is unique.

Xsinthis · 10-06-2010 , 15:21 Re: Is it safe to change the sourcemod database schema?

Ahhh well then why not backup your database, and then try the change out and tell us how it works?

temp321 · 10-06-2010 , 16:25 Re: Is it safe to change the sourcemod database schema?

It'll probably work short term, but if sourcemod decides to change the schema in the future, then it might mess up the database.

Xsinthis · 10-06-2010 , 17:10 Re: Is it safe to change the sourcemod database schema?

Haha i didn't realize that it needs to be unique, even though my plugin uses the INSERT ON DUPLICATE KEY query :/

temp321 · 10-06-2010 , 17:34 Re: Is it safe to change the sourcemod database schema?

Yep, you need it to be unique unless you are inserting by ID.

since "identity" isn't unique, it is possible to have 2 entries like this.

ID IDENTITY IMMUNITY
1. STEAM:1234 0
2. STEAM:1234 99

And it makes no sense. I'm hoping that one of the sourcemod developers will see this and change it.

YamiKaitou · 10-06-2010 , 18:39 Re: Is it safe to change the sourcemod database schema?

Quote:

Originally Posted by temp321

I'm hoping that one of the sourcemod developers will see this and change it.

Submit a bug report if you want them to see it

Xsinthis · 10-07-2010 , 12:23 Re: Is it safe to change the sourcemod database schema?

https://bugs.alliedmods.net/show_bug.cgi?id=4651