ALTER TABLE `cp_createlog` CHANGE `confirmed` `confirmed` TINYINT( 1 ) NOT NULL DEFAULT '1'