5fnvsGXM

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