> On 24 Dec 2017, at 18:52, Michelle Konzack <linux4michelle@xxxxxxxxxxxxxxx> wrote: > CREATE TABLE sqmf_stat ( > stat_login varchar(70) NOT NULL, > stat_post integer default '1', > stat_thread integer default '1', > PRIMARY KEY (stat_login), > UNIQUE KEY user (stat_login) > ); Just a minor observation, but a PRIMARY KEY is UNIQUE by definition. There's no need for that UNIQUE key "user" on the same field. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest.
