ALTER TABLE news ADD COLUMN date_submitted TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

UPDATE news SET date_submitted = NOW();
