How to give Free VIP

[X2_]

I would like to make VIP free for new registered users on my hotel.

How can I do this?

I'm using Phoenix 3.11.0

 

[Hindi]

Run this in your database;

UPDATE table users set vip = 1 where vip =0;

(Change the vip to whatever it is in the database as I'm not aware what it is in the actual database) and then set default for it to be 1

 

[JacobMLucado]

Hindi's post is wrong, it's actually UPDATE `users` SET `vip`='1' but that is only for existing users. You will need to click design table and make 1 default on the vip column. use CTRL + D to go to design table.

 

[X2_]

Thank you, solved my problem!

 

[Hindi]

Hindi's post is wrong, it's actually UPDATE `users` SET `vip`='1' but that is only for existing users. You will need to click design table and make 1 default on the vip column. use CTRL + D to go to design table.

That's what I said? and I made that query up without looking at the database I even said that change vip to whatever it is in the database, Nevertheless It's all good.

 

[JacobMLucado]

Well he was still asking to set it as "default" which your comment did not provide.