ALTER TABLE predb DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
ALTER TABLE predb MODIFY COLUMN dirname VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci;
ALTER TABLE predb MODIFY COLUMN category VARCHAR(20) NOT NULL COLLATE utf8_unicode_ci;
ALTER TABLE predb MODIFY COLUMN nuketype VARCHAR(20) NULL DEFAULT '' COLLATE utf8_unicode_ci;
ALTER TABLE predb MODIFY COLUMN nukereason VARCHAR(255) NULL DEFAULT '' COLLATE utf8_unicode_ci;
ALTER TABLE predb MODIFY COLUMN filename VARCHAR(255) NULL DEFAULT '' COLLATE utf8_unicode_ci;