text: -- --------------------------------------------------------
  
  --
  -- Table structure for table `notifications`
  --
  
  CREATE TABLE IF NOT EXISTS `notifications` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `notification_id` varchar(50) COLLATE utf8_bin NOT NULL,
    `message` text COLLATE utf8_bin NOT NULL,
    `category` varchar(50) COLLATE utf8_bin NOT NULL,
    `type` varchar(10) COLLATE utf8_bin NOT NULL,
    `read` tinyint(1) NOT NULL,
    `is_new` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `idx_notification_id` (`notification_id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=72 ;
  