Miscellany

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 varchar(30)) RETURNS varchar(100)BEGIN	DECLARE OPTION_VALUE varchar(100);	SELECT OPTION_VALUE INTO hi FROM OPTIONS WHERE OPTION_KEY = OPTION_KEY LIMIT 1;	RETURN OPTION_VALUE;END;//SELECT OPTION_VALUE FROM OPTIONS WHERE OPTION_KEY = 'BasePath' LIMIT 1