UNIQUE index created 20 times

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
DevGiu
AppGini Super Hero
AppGini Super Hero
Posts: 151
Joined: 2016-05-27 09:08

UNIQUE index created 20 times

Post by DevGiu » 2016-07-19 14:01

Somebody has idea why this happened?

I think it happened in all my tables with field "ref" as unique.
Attachments
Selección_011.png
Selección_011.png (59.82 KiB) Viewed 3388 times
/Giuseppe
Professional Outsourcing Services

grimblefritz
AppGini Super Hero
AppGini Super Hero
Posts: 336
Joined: 2015-12-23 16:52

Re: UNIQUE index created 20 times

Post by grimblefritz » 2016-08-30 09:59

No idea on that, DevGiu, but to help out others who may find this post...

I've found it works best in AppGini to use a field named 'id'. AppGini will detect this and automatically set it up to be the primary key field. It's the first field I add when defining a table.

Even when I know I'll have other fields that could be primary, I still let AppGini create the primary key using 'id'. The other field that might have been suitable as primary, I make that field required and unique.

Just a preference, of course, but one I've found makes AppGini work more smoothly.

DevGiu
AppGini Super Hero
AppGini Super Hero
Posts: 151
Joined: 2016-05-27 09:08

Re: UNIQUE index created 20 times

Post by DevGiu » 2016-08-30 10:24

It's a bug, recognized by AppGini Team.

In my situation, if you look at it, "id" is my PK, the other field is just a varchar field with UNIQUE index.
/Giuseppe
Professional Outsourcing Services

grimblefritz
AppGini Super Hero
AppGini Super Hero
Posts: 336
Joined: 2015-12-23 16:52

Re: UNIQUE index created 20 times

Post by grimblefritz » 2016-08-30 10:37

LOL @ ME

Too early in the morning I guess. Completely overlooked that you had 'id' as primary. All those refs to ref overwhelmed me :)

Post Reply