--
-- MySQL miXen function list
--

FUNCTION add_date_1y(olddate DATE) RETURNS datetime
FUNCTION add_int_100(oldnum DECIMAL) RETURNS decimal(10,3)
FUNCTION add_number_1k(oldnum DECIMAL) RETURNS decimal(10,3)
FUNCTION chk_ccard(str VARCHAR(256)) RETURNS tinyint(4)
FUNCTION chk_iban(str VARCHAR(256)) RETURNS tinyint(4)
FUNCTION chk_piva_it(str VARCHAR(256)) RETURNS tinyint(4)
FUNCTION chk_ssn_us(str VARCHAR(256)) RETURNS tinyint(4)
FUNCTION fix_ccard(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_CF_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_city_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_city_us(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_iban(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_name_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_name_us(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_piva_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_ssn_us(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_surname_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION fix_surname_us(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION is_luhn(str VARCHAR(256)) RETURNS tinyint(4)
FUNCTION is_number(SIN VARCHAR(1024)) RETURNS tinyint(4)
FUNCTION lst_city_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION lst_name_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION lst_name_us(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION lst_surname_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION lst_surname_us(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION msk_number_last3(oldnum BIGINT) RETURNS bigint(20)
FUNCTION msk_string_last3(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION rnd_ccard_it(oldstr VARCHAR(256)) RETURNS varchar(16) CHARSET utf8
FUNCTION rnd_char8(oldstr VARCHAR(256)) RETURNS varchar(8) CHARSET utf8
FUNCTION rnd_city_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION rnd_date_1970(olddate DATE) RETURNS datetime
FUNCTION rnd_int_100(oldnum DECIMAL) RETURNS decimal(10,3)
FUNCTION rnd_name_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION rnd_name_us(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION rnd_number_1k(oldstr DECIMAL) RETURNS decimal(10,3)
FUNCTION rnd_piva_it(oldstr VARCHAR(256)) RETURNS varchar(16) CHARSET utf8
FUNCTION rnd_smart(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION rnd_ssn_us(oldstr VARCHAR(256)) RETURNS varchar(11) CHARSET utf8
FUNCTION rnd_string(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION rnd_surname_it(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8
FUNCTION rnd_surname_us(oldstr VARCHAR(256)) RETURNS varchar(256) CHARSET utf8