CREATE INDEX code_text_idx ON codes(code_text);
For a unique index, CREATE UNIQUE INDEX…
CREATE UNIQUE INDEX