Go to Scriptcase store

# Associate tables

When choosing to use existing tables for the notification module, you must associate them manually.

See below the structure of the notification module tables

notif_inbox

    CREATE TABLE `notif_inbox` (
      `inbox_id` int NOT NULL AUTO_INCREMENT,
      `notif_id` int NOT NULL,
      `login` varchar(255) NOT NULL,
      `notif_dtsent` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `notif_ontop` int NOT NULL DEFAULT '0',
      `notif_isread` int NOT NULL DEFAULT '0',
      `notif_dtread` datetime DEFAULT NULL,
      `notif_tags` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`inbox_id`)
    )

notif_pref

    CREATE TABLE `notif_pref` (
      `login` varchar(255) NOT NULL,
      `receive_email` int NOT NULL DEFAULT '1',
      `receive_sms` int NOT NULL DEFAULT '0',
      PRIMARY KEY (`login`)
    )

notif_tags

    CREATE TABLE `notif_tags` (
      `tag_id` int NOT NULL AUTO_INCREMENT,
      `tag_title` varchar(50) NOT NULL,
      `login` varchar(255) NOT NULL,
      `tag_color` varchar(100) DEFAULT NULL,
      `tag_active` int NOT NULL DEFAULT '1',
      PRIMARY KEY (`tag_id`)
    )

notif_notifications

    CREATE TABLE `notif_notifications` (
      `notif_id` int NOT NULL AUTO_INCREMENT,
      `notif_title` varchar(255) NOT NULL,
      `notif_message` text NOT NULL,
      `notif_dtcreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `notif_ontop` int NOT NULL DEFAULT '0',
      `notif_dtexpire` datetime DEFAULT NULL,
      `notif_categ` varchar(60) DEFAULT NULL,
      `notif_login_sender` varchar(255) NOT NULL,
      `deleted_at` datetime DEFAULT NULL,
      PRIMARY KEY (`notif_id`)
    )

notif_profiles

    CREATE TABLE `notif_profiles` (
      `profile_id` int NOT NULL AUTO_INCREMENT,
      `name` varchar(255) DEFAULT NULL,
      `users` text,
      `groups` text,
      PRIMARY KEY (`profile_id`)
    )

notif_user_tags

    CREATE TABLE `notif_user_tags` (
      `login` varchar(255) NOT NULL,
      `login_sender` varchar(255) NOT NULL,
      `tags` varchar(255) DEFAULT NULL
    )