create [unique] index [if not exists] {name} on {table name} ( {column} ) [where {expr}]

-- {column} :

-- {name} [COLLATE {name}] [ASC,DESC]

CREATE INDEX uid_index ON MyTable (uid)