CREATE TABLE OPTIONS (
  OPTION_KEY varchar(30) NOT NULL, 
  OPTION_VALUE varchar(100),
  DATE_CREATE timestamp NOT NULL,
  DATE_MOD timestamp NOT NULL,
  PRIMARY KEY (OPTION_KEY)
);

INSERT INTO OPTIONS (OPTION_KEY, OPTION_VALUE) VALUES ('BasePath', '/home/wladek/armoury');

DELIMITER //

CREATE FUNCTION FUNC_GET_OPTION (OPTION_KEY char(30)) RETURNS char(100)
BEGIN
	DECLARE hi char(100);
	SELECT OPTION_VALUE INTO hi FROM OPTIONS WHERE OPTION_KEY = 'BasePath' LIMIT 1;
	RETURN hi;
END;//