Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-3966 Navigation Customization
  3. CORE-3967

Navigation Customization Tables

        Details

        • Type: Sub-task
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 5.0.0-b1
        • Component/s: None
        • Labels:
          None

          Description

          Create new tables:

          • actions
            • id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            • location ENUM('nav_client', 'nav_staff', 'widget_client_home', 'widget_staff_home', 'widget_staff_client', 'widget_staff_billing', 'action_staff_client') NOT NULL DEFAULT 'nav_staff',
            • url VARCHAR(255) NOT NULL
            • name VARCHAR(128) NOT NULL
            • options TEXT DEFAULT NULL
            • plugin_id INT(10) UNSIGNED NULL DEFAULT NULL
            • enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            • editable TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            • primary(id)
            • index(location)
            • index(plugin_id)
            • index(enabled)
            • index(editable)
          • navigation_items
            • id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            • company_id INT(10) UNSIGNED NOT NULL
            • action_id INT(10) UNSIGNED NOT NULL
            • level ENUM('public', 'client', 'staff')
            • order SMALLINT(5) UNSIGNED NOT NULL
            • parent_id INT(10) UNSIGNED NULL DEFAULT NULL
            • primary(id)
            • index(company_id)
            • index(action_id)
            • index(parent_id)

          Remove the `plugin_actions` table

            Activity

            Ascending order - Click to sort in descending order
            jonathan Jonathan Reissmueller created issue -
            jonathan Jonathan Reissmueller made changes -
            Field Original Value New Value
            Description Create new tables:
            * actions
            ** id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            ** location ENUM('nav_client', 'nav_staff', 'widget_client_home', 'widget_staff_home', 'widget_staff_client', 'widget_staff_billing', 'action_staff_client') NOT NULL DEFAULT 'nav_staff',
            ** url VARCHAR(255) NOT NULL
            ** name VARCHAR(128) NOT NULL
            ** plugin_id INT(10) UNSIGNED NULL DEFAULT NULL
            ** enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            ** editable TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            ** primary(id)
            ** index(location)
            ** index(plugin_id)
            ** index(enabled)
            ** index(reserved)
            * navigation_items
            ** id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            ** company_id INT(10) UNSIGNED NOT NULL
            ** action_id INT(10) UNSIGNED NOT NULL
            ** level ENUM('public', 'client', 'staff')
            ** order SMALLINT(5) UNSIGNED NOT NULL
            ** parent_id INT(10) UNSIGNED NULL DEFAULT NULL
            ** primary(id)
            ** index(company_id)
            ** index(action_id)
            ** index(parent_id)

            Remove the `plugin_actions` table             		Create new tables:
            * actions
            ** id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            ** location ENUM('nav_client', 'nav_staff', 'widget_client_home', 'widget_staff_home', 'widget_staff_client', 'widget_staff_billing', 'action_staff_client') NOT NULL DEFAULT 'nav_staff',
            ** url VARCHAR(255) NOT NULL
            ** name VARCHAR(128) NOT NULL
            ** options TEXT DEFAULT NULL
            ** plugin_id INT(10) UNSIGNED NULL DEFAULT NULL
            ** enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            ** editable TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            ** primary(id)
            ** index(location)
            ** index(plugin_id)
            ** index(enabled)
            ** index(reserved)
            * navigation_items
            ** id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            ** company_id INT(10) UNSIGNED NOT NULL
            ** action_id INT(10) UNSIGNED NOT NULL
            ** level ENUM('public', 'client', 'staff')
            ** order SMALLINT(5) UNSIGNED NOT NULL
            ** parent_id INT(10) UNSIGNED NULL DEFAULT NULL
            ** primary(id)
            ** index(company_id)
            ** index(action_id)
            ** index(parent_id)

            Remove the `plugin_actions` table
            jonathan Jonathan Reissmueller made changes -
            Assignee Jonathan Reissmueller [ jonathan ]
            Automated transition triggered when Jonathan Reissmueller created a branch in Stash -
            Status Open [ 1 ] In Progress [ 3 ]
            jonathan Jonathan Reissmueller made changes -
            Description Create new tables:
            * actions
            ** id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            ** location ENUM('nav_client', 'nav_staff', 'widget_client_home', 'widget_staff_home', 'widget_staff_client', 'widget_staff_billing', 'action_staff_client') NOT NULL DEFAULT 'nav_staff',
            ** url VARCHAR(255) NOT NULL
            ** name VARCHAR(128) NOT NULL
            ** options TEXT DEFAULT NULL
            ** plugin_id INT(10) UNSIGNED NULL DEFAULT NULL
            ** enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            ** editable TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            ** primary(id)
            ** index(location)
            ** index(plugin_id)
            ** index(enabled)
            ** index(reserved)
            * navigation_items
            ** id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            ** company_id INT(10) UNSIGNED NOT NULL
            ** action_id INT(10) UNSIGNED NOT NULL
            ** level ENUM('public', 'client', 'staff')
            ** order SMALLINT(5) UNSIGNED NOT NULL
            ** parent_id INT(10) UNSIGNED NULL DEFAULT NULL
            ** primary(id)
            ** index(company_id)
            ** index(action_id)
            ** index(parent_id)

            Remove the `plugin_actions` table             		Create new tables:
            * actions
            ** id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            ** location ENUM('nav_client', 'nav_staff', 'widget_client_home', 'widget_staff_home', 'widget_staff_client', 'widget_staff_billing', 'action_staff_client') NOT NULL DEFAULT 'nav_staff',
            ** url VARCHAR(255) NOT NULL
            ** name VARCHAR(128) NOT NULL
            ** options TEXT DEFAULT NULL
            ** plugin_id INT(10) UNSIGNED NULL DEFAULT NULL
            ** enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            ** editable TINYINT(1) UNSIGNED NOT NULL DEFAULT 1
            ** primary(id)
            ** index(location)
            ** index(plugin_id)
            ** index(enabled)
            ** index(editable)
            * navigation_items
            ** id INT(10) UNSIGNED NOT NULL AUTOINCREMENT
            ** company_id INT(10) UNSIGNED NOT NULL
            ** action_id INT(10) UNSIGNED NOT NULL
            ** level ENUM('public', 'client', 'staff')
            ** order SMALLINT(5) UNSIGNED NOT NULL
            ** parent_id INT(10) UNSIGNED NULL DEFAULT NULL
            ** primary(id)
            ** index(company_id)
            ** index(action_id)
            ** index(parent_id)

            Remove the `plugin_actions` table
            Automated transition triggered when Jonathan Reissmueller created pull request #1013 in Stash -
            Status In Progress [ 3 ] In Review [ 5 ]
            Resolution Fixed [ 1 ]
            Automated transition triggered when Jonathan Reissmueller merged pull request #1013 in Stash -
            Status In Review [ 5 ] Closed [ 6 ]

              People

              • Assignee:
                jonathan Jonathan Reissmueller
                Reporter:
                jonathan Jonathan Reissmueller
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  23/Dec/20

                  Agile