DROP TABLE IF EXISTS `adminnotification_inbox`; DROP VIEW IF EXISTS `adminnotification_inbox`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adminnotification_inbox` (
 `notification_id` int(10) NOT NULL COMMENT 'Notification id',
 `severity` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Problem type',
 `date_added` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Create date',
 `title` varchar(255) NOT NULL COMMENT 'Title',
 `description` text COMMENT 'Description',
 `url` varchar(255) DEFAULT NULL COMMENT 'Url',
 `is_read` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Flag if notification read',
 `is_remove` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Flag if notification might b