Query Question

[Cloudrunner]

ALTER TABLE `user` CHANGE `cookieuser` `cookieuser` SMALLINT(6) DEFAULT '1' NOT NULL;

This sets all new registers to default to '1', then run this query:

UPDATE `user` SET `cookieuser` = '1' WHERE `cookieuser` = '0';

This set all users whose `cookieuser` column is '0' to '1'.

Enjoy

)O( Cloudrunner )O(