# announces
ALTER TABLE announces
CHANGE COLUMN user_id uid INT(11) not null;
+CHANGE COLUMN peremption expiration DATE NOT NULL;
ALTER TABLE announce_read
CHANGE COLUMN user_id uid INT(11) not null;
# group
ALTER TABLE group_announces
CHANGE COLUMN user_id uid INT(11) NOT NULL;
+CHANGE COLUMN peremption expiration DATE NOT NULL;
ALTER TABLE group_announces_read
CHANGE COLUMN user_id uid INT(11) NOT NULL;