new field with function with generate like generateReference

[NeedZoom]

Hi,

 

I have a field in table customer DB.but i want his value like "generateReference".

How can i do it with pro technique

thanks

[NeedZoom]

i have add

ALTER TABLE `ps_customer` ADD `code` VARCHAR(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;

and in customer.php:

in public static $definition:

'code' =>  array('type' => self::TYPE_STRING),

and

public static function generateCode()
    {
        
		$last_id = Db::getInstance()->getValue('
        SELECT MAX(code)
        FROM '._DB_PREFIX_.'customer');
    return str_pad((int)$last_id + 1, 8, 'CW0000000', STR_PAD_LEFT); 
    }