CREATE TABLE `uid_credentials` (
    `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `auth_username` VARCHAR(64) NOT NULL,
    `did` VARCHAR(64) DEFAULT '_default' NOT NULL,
    `realm` VARCHAR(64) NOT NULL,
    `password` VARCHAR(28) DEFAULT '' NOT NULL,
    `flags` INT DEFAULT 0 NOT NULL,
    `ha1` VARCHAR(32) NOT NULL,
    `ha1b` VARCHAR(32) DEFAULT '' NOT NULL,
    `uid` VARCHAR(64) NOT NULL
);

CREATE INDEX cred_idx ON uid_credentials (`auth_username`, `did`);
CREATE INDEX uid ON uid_credentials (`uid`);
CREATE INDEX did_idx ON uid_credentials (`did`);
CREATE INDEX realm_idx ON uid_credentials (`realm`);

INSERT INTO version (table_name, table_version) values ('uid_credentials','7');