central.tail4f76da.ts.net / localhost / imnrc_sphere_dev / tb_lms_insignias

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Press Ctrl+Enter to execute query

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Table navigation bar

Use only icons, only text or both.

How to display various action links

Use only icons, only text or both.

Allow to display all the rows

Whether a user should be displayed a "show all (rows)" button.

Maximum number of rows to display

Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.

Default sorting order

SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.

Highlight pointer

Highlight row pointed by the mouse cursor.

Row marker

Highlight selected rows.

Grid editing: trigger action

Grid editing: save all edited cells at once

Repeat headers

Repeat the headers every X cells, 0 deactivates this feature.

Limit column characters

Maximum number of characters shown in any non-numeric column on browse view.

Where to show the table row links

These are Edit, Copy and Delete links.

Show row links anyway

Whether to show row links even in the absence of a unique key.

Primary key default sort order

Default sort order for tables with a primary key.

Remember table's sorting

When browsing tables, the sorting of each table is remembered.

Relational display

For display Options

			id	codigo Identificador unico de la insignia	nombre	descripcion	icono Tabler icon class (ti ti-*)	categoria estudio/vocabulario/speaking/writing/reading/gramm…	condicion_tipo	condicion_valor	xp_recompensa	monedas_recompensa	orden	enabled
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 1	1	first_lesson	First Steps	Complete your first lesson	ti ti-shoe	estudio	lessons_completed	1	50	10	1	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 2	2	five_lessons	Getting Started	Complete 5 lessons	ti ti-book	estudio	lessons_completed	5	100	25	2	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 3	3	ten_lessons	Dedicated Learner	Complete 10 lessons	ti ti-books	estudio	lessons_completed	10	200	50	3	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 4	4	twenty_lessons	Knowledge Seeker	Complete 20 lessons	ti ti-school	estudio	lessons_completed	20	400	100	4	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 5	5	streak_3	On a Roll	Study 3 days in a row	ti ti-flame	estudio	streak_days	3	75	15	5	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 6	6	streak_7	Weekly Warrior	Study 7 days in a row	ti ti-calendar-stats	estudio	streak_days	7	150	40	6	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 7	7	streak_30	Monthly Master	Study 30 days in a row	ti ti-crown	estudio	streak_days	30	500	150	7	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 8	8	vocab_10	Word Collector	Pass 10 vocabulary exercises	ti ti-vocabulary	vocabulario	words_learned	10	100	20	1	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 9	9	vocab_50	Word Wizard	Pass 50 vocabulary exercises	ti ti-wand	vocabulario	words_learned	50	300	75	2	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 10	10	vocab_perfect_5	Perfectionist	Score 95+ on 5 vocabulary exercises	ti ti-diamond	vocabulario	vocab_perfect_scores	5	200	50	3	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 11	11	speak_5	Finding Your Voice	Record 5 speaking exercises	ti ti-microphone	speaking	recordings	5	100	25	1	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 12	12	speak_20	Confident Speaker	Record 20 speaking exercises	ti ti-microphone-2	speaking	recordings	20	300	75	2	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 13	13	speak_ace	Speech Star	Score 90+ on 3 speaking exercises	ti ti-star	speaking	speaking_score_90	3	250	60	3	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 14	14	write_5	Pen in Hand	Complete 5 writing exercises	ti ti-pencil	writing	writings_completed	5	100	25	1	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 15	15	write_20	Prolific Writer	Complete 20 writing exercises	ti ti-notebook	writing	writings_completed	20	300	75	2	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 16	16	write_ace	Writing Prodigy	Score 90+ on 3 writing exercises	ti ti-award	writing	writing_score_90	3	250	60	3	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 17	17	read_5	Bookworm	Complete 5 reading exercises	ti ti-book-2	reading	readings_completed	5	100	25	1	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 18	18	read_20	Avid Reader	Complete 20 reading exercises	ti ti-books	reading	readings_completed	20	300	75	2	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 19	19	read_perfect_3	Sharp Eye	Score 95+ on 3 reading exercises	ti ti-eye-check	reading	reading_perfect_scores	3	200	50	3	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 20	20	grammar_10	Grammar Rookie	Complete 10 grammar exercises	ti ti-list-check	grammar	grammar_completed	10	100	25	1	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 21	21	grammar_perfect_5	Grammar Guru	Score 95+ on 5 grammar exercises	ti ti-shield-check	grammar	grammar_streak_perfect	5	300	75	2	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 22	22	pronun_5	Sound Explorer	Complete 5 pronunciation exercises	ti ti-ear	pronunciacion	pronunciation_completed	5	100	25	1	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 23	23	phonemes_10	Phoneme Master	Master 10 different phonemes	ti ti-music	pronunciacion	phonemes_mastered	10	250	60	2	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 24	24	night_owl	Night Owl	Study after 10 PM	ti ti-moon-stars	raro	study_hour_night	22	75	20	1	1
Edit	Copy	Delete DELETE FROM tb_lms_insignias WHERE `tb_lms_insignias`.`id` = 25	25	early_bird	Early Bird	Study before 7 AM	ti ti-sunrise	raro	study_hour_early	7	75	20	2	1

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customize browse mode.