-- Fix codes table to match new OOP system expectations
-- Old: code=VARCHAR(7), expire=INT (unix timestamp)
-- New: code=VARCHAR(255), expire=DATETIME

DELETE FROM codes;

ALTER TABLE codes
    MODIFY COLUMN code VARCHAR(255) NOT NULL,
    MODIFY COLUMN expire DATETIME NOT NULL;