create or replace table accountpunishments ( id int auto_increment primary key, target varchar(16) not null, category varchar(100) not null, sentence varchar(100) not null, reason varchar(100) not null, duration double not null, admin varchar(16) not null, severity int not null, time timestamp default current_timestamp() not null ) charset=latin1;