How can I make email field as unique and primary key in redbeans php ?
Is there any way to do that?
Asked
Active
Viewed 35 times
0
Amit Verma
- 40,709
- 21
- 93
- 115
Vinay Sagar Savithru
- 19
- 6
-
Googled this issue for couple of hours but I din't got any working answer.. – Vinay Sagar Savithru Jun 15 '15 at 11:39
-
nothing is there in the documentation either...!! – Vinay Sagar Savithru Jun 15 '15 at 11:41
-
Rather than make the email a primary key, which i am not sure is a good idea anyway, I would have the email as a property and put a unique index on it. Now, it can be used in queries efficiently, will trigger errors if duplicate inserted. Also, if it changes then you do not lose all the relationships it already has to other tables. I think this is a win. – Ryan Vincent Jul 04 '15 at 08:51
-
Very true Ryan Vincent. .. Thanks for your help.... – Vinay Sagar Savithru Jul 04 '15 at 09:17