· 7 years ago · Nov 26, 2018, 07:42 PM
1CREATE TABLE IF NOT EXISTS `notifications` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `phone` varchar(12) NOT NULL,
4 `message` varchar(140) NOT NULL,
5 `timestampCreated` int(10) NOT NULL,
6 `timestampDispatched` int(11) NOT NULL,
7 `email` varchar(100) NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;