CREATE TABLE submitter_strings (
    submitterstrid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,
    submitter VARCHAR(60) NOT NULL,
    submitcounter INTEGER NOT NULL
);
ALTER TABLE submitter_strings ADD CONSTRAINT pk_submitter_strings PRIMARY KEY (submitterstrid);
CREATE UNIQUE INDEX idu_submitter on submitter_strings (submitter);