ALTER TABLE notification_preferences 
ADD COLUMN enabledSystem TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledOrder TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledPayment TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledAffiliate TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledFollow TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledComment TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledLike TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledMessage TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledAnnouncement TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledBookPublished TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledBookUnpublished TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledBookRejected TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledCoauthorInvitation TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledCoauthorAccepted TINYINT(1) NOT NULL DEFAULT 1,
ADD COLUMN enabledCoauthorRejected TINYINT(1) NOT NULL DEFAULT 1;