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

-- Now link the rows in gregslist to those of this table: