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