-- rating of a whole ticket by the client after it was closed (reply ratings are ticket_replies.rating)
ALTER TABLE tickets ADD rating TINYINT NOT NULL DEFAULT 0, ADD rating_comment VARCHAR(1000) NOT NULL DEFAULT '', ADD rated_at DATETIME NULL, ADD KEY rated (rated_at);
ALTER TABLE ticket_replies ADD rated_at DATETIME NULL;