Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Edit mode
Customize edit mode.
Edit mode
Documentation Disallow BLOB and BINARY columns from editing. Restore default value
Documentation Display the function fields in edit/insert mode. Restore default value
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode. Restore default value
Documentation How many rows can be inserted at one time. Restore default value
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value. Restore default value
Documentation A dropdown will be used if fewer items are present. Restore default value
Text fields
Customize text input fields.
Text fields
Documentation Defines which type of editing controls should be used for CHAR and VARCHAR columns; input - allows limiting of input length, textarea - allows newlines in columns. Restore default value
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Number of columns for CHAR/VARCHAR textareas. Restore default value
Documentation Number of rows for CHAR/VARCHAR textareas. Restore default value
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Double size of textarea for LONGTEXT columns. Restore default value
Column Type Function Null Value
id int(11)
organisation_id int(11) 1
related_to int(11)
related_preferred_communication enum --
parent_task_id int(11)
is_subtask int(11) 0
is_recurring tinyint(1) 0
subtask_order int(11)
sector_id int(11)
responsible_person_id int(11)
responsible_preferred_communication enum --
supervisor_id int(11)
supervisor_preferred_communication enum --
title varchar(255)
short_description text
long_description text
from_date date
till_date date
subtask_offset int(11) 0
completion_time enum --
file_name varchar(255)
status int(11) 1
task_status enum -- not_started
is_informed tinyint(1) 0
is_execut_informed tinyint(1) 0
is_respon_informed tinyint(1) 0
execut_informed_on datetime
respon_informed_on datetime
execut_informed_by int(11)
respon_informed_by int(11)
informed_on datetime
informed_by int(11)
partially_completed_reason_id int(11)
partially_completed_notes text
is_extended tinyint(1) 0
original_task_id int(11)
extension_days int(11) 0
extension_date date
deleted int(11) 0
addedOn datetime 2026-02-10 09:33:46.000000
addedBy int(11)
modifiedBy int(11)
modifiedOn timestamp current_timestamp()
is_communication_task tinyint(1) 0
communication_type enum --
communication_to enum -- staff
contact_info varchar(255)
original_communication_title text


Column Type Function Null Value
id int(11)
organisation_id int(11) 1
related_to int(11)
related_preferred_communication enum --
parent_task_id int(11)
is_subtask int(11) 0
is_recurring tinyint(1) 0
subtask_order int(11)
sector_id int(11)
responsible_person_id int(11)
responsible_preferred_communication enum --
supervisor_id int(11)
supervisor_preferred_communication enum --
title varchar(255)
short_description text
long_description text
from_date date
till_date date
subtask_offset int(11) 0
completion_time enum --
file_name varchar(255)
status int(11) 1
task_status enum -- not_started
is_informed tinyint(1) 0
is_execut_informed tinyint(1) 0
is_respon_informed tinyint(1) 0
execut_informed_on datetime
respon_informed_on datetime
execut_informed_by int(11)
respon_informed_by int(11)
informed_on datetime
informed_by int(11)
partially_completed_reason_id int(11)
partially_completed_notes text
is_extended tinyint(1) 0
original_task_id int(11)
extension_days int(11) 0
extension_date date
deleted int(11) 0
addedOn datetime 2026-02-10 09:33:46.000000
addedBy int(11)
modifiedBy int(11)
modifiedOn timestamp current_timestamp()
is_communication_task tinyint(1) 0
communication_type enum --
communication_to enum -- staff
contact_info varchar(255)
original_communication_title text

and then
Use TAB key to move from value to value, or CTRL+arrows to move anywhere.

Continue insertion with rows