is_enabled TINYINT(1) DEFAULT 1, -- dev3 added this, same as active_flg last_login VARCHAR(14), -- exists here but NOT in resources/sql version failed_attempts INT DEFAULT 0, -- exists here but NOT in ...

ADD CONSTRAINT `Competition_ibfk_1` FOREIGN KEY (`Champ_ID`) REFERENCES `Championship` (`Champ_ID`), ADD CONSTRAINT `Competition_ibfk_2` FOREIGN KEY (`Round_ID`) REFERENCES `Round_Definition` ...

The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...