-- This is included by gregslist.sql
SELECT "Create profession..." AS "COMMENT";
CREATE TABLE t_profession
(
	id				INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
	profession	VARCHAR(64)
) AS
	SELECT profession FROM t_gregslist
	GROUP BY profession
	ORDER BY profession;
SELECT * FROM t_profession;
