UNIQUE key on the sus_login_name column

[miasoft]

For the zzzzsys_user table, after each update, I add a UNIQUE key on the sus_login_name column. I don't understand why this key is not set by default?

[kev1n]

Do you mean a unique constraint?
Why would you want to add it?

All changes to zzzz-tables are overwritten with an update.

[miasoft]

Do you mean a unique constraint?
Why would you want to add it?

How is the uniqueness of sus_login_name checked? MySql rules or PHP-code? UNIQUE key needed for non-NUBuider programm (for me)

[kev1n]

Uniqueness is ensured by code.
I might be able to provide some post-update functionality that allows you to run scripts after each update.

[kev1n]

Does that make sense?

[miasoft]

Does that make sense?

It doesn't bother me

[kev1n]

There's now a possibility to run scripts after each update.

If the Procedure called nuAfterUpdate function exists, it will be run after an update.

Example:

nuAfterUpdate.png

Code: Select all

// Add a unique key to zzzzsys_user.sus_login_name
nuRunQuery(" ALTER TABLE `zzzzsys_user` ADD UNIQUE(`sus_login_name`) ";

[miasoft]

Thanks! I updated from Github. All work fine.
It's typo in script. Corrected:

Code: Select all

nuRunQuery(" ALTER TABLE `zzzzsys_user` ADD UNIQUE(`sus_login_name`) ");