[Sommaire] [Imprimer]

   1  ALTER TABLE {PREFIX}entries ADD COLUMN moderate_comments BOOLEAN;
   2  ALTER TABLE {PREFIX}comments ADD COLUMN status varchar(50);
   3  UPDATE {PREFIX}comments SET status = 'approved';
   4  UPDATE {PREFIX}entries SET moderate_comments = false;
   5  ALTER TABLE {PREFIX}entries ALTER COLUMN moderate_comments SET NOT NULL;
   6  ALTER TABLE {PREFIX}comments ALTER COLUMN status SET NOT NULL;
   7