perfex.tail1f1784.ts.net / 127.0.0.1 / gms_local / tblfiles

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

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.

Customize the navigation tree.

Navigation tree

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.

Servers display options.

Servers

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.

Databases display options.

Databases

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

Tables display options.

Tables

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

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

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

Showing rows 0 - 24 (128 total, Query took 0.0005 seconds.)

SELECT * FROM `tblfiles`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	rel_id	rel_type	file_name	filetype	visible_to_customer	attachment_key	external	external_link	thumbnail_link For external usage	staffid	contact_id	task_comment_id	dateadded
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 1	1	1	customer	Captura de pantalla 2023-09-27 a las 7.35.24.png	image/png	0	0eccc39a68bcdf7a7e6cb375f6646fc1	NULL	NULL	NULL	69	0	0	2023-09-27 07:35:27
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 2	2	1	lead	Captura de pantalla 2023-09-27 a las 17.41.52.png	image/png	0	56d23f271f9d28b5aa8b255e7e82778d	NULL	NULL	NULL	69	0	0	2023-09-27 17:41:54
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 3	3	8	diary	360_F_143428338_gcxw3Jcd0tJpkvvb53pfEztwtU9sxsgT.j...	image/jpeg	0	fa2317b8f8c422b4a3f6b4f963adaa0b	NULL	NULL	NULL	69	0	0	2023-10-11 13:19:21
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 4	4	8	diary	Captura de pantalla 2023-10-21 a las 5.20.53.png	image/png	0	f969e6d3ee643bf3cc4290e0db4aff34	NULL	NULL	NULL	69	0	0	2023-10-21 05:20:55
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 5	5	1	task	Screenshot 2023-11-20 at 4.56.31 PM.png	image/png	0	9f59d460f3f237aa9ffc9e9af3dff551	NULL	NULL	NULL	69	0	16	2023-11-20 16:56:38
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 6	6	8	diary	Screenshot 2023-11-20 at 5.05.17 PM.png	image/png	0	6461a67f68446f6d88adc36587109864	NULL	NULL	NULL	69	0	0	2023-11-20 17:05:18
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 9	9	4	lead	403118-svetik.jpg	image/jpeg	0	99c536f63bfddc1086271e1da7084da3	NULL	NULL	NULL	69	0	0	2024-02-08 17:22:23
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 10	10	9	diary	Captura de pantalla 2024-03-06 a las 5.24.35.png	image/png	0	d9067b74bc87d1eecca705a735dd84a2	NULL	NULL	NULL	69	0	0	2024-03-06 05:24:38
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 16	16	44	estimate	P25_287_GMS_TCI_BESS SDLA_H_PropTec_v0.pdf	application/pdf	0	eaf99988ecf517cb5d20568fe37e6437	NULL	NULL	NULL	108	0	0	2025-06-13 08:51:22
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 17	17	61	estimate	P25_307_GMS_Zelestra_CivitavecchiaPVP_H_TechProp_v...	application/pdf	0	d4dafd19f7a94e2968ab08f3593d4cab	NULL	NULL	NULL	108	0	0	2025-06-18 17:22:28
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 18	18	62	estimate	P25_308_GMS_Zelestra_BrucaPVP_H_TechProp_v0.pdf	application/pdf	0	5196818aca9aeb1379ad6c97dfc71df1	NULL	NULL	NULL	108	0	0	2025-06-18 17:23:00
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 19	19	63	estimate	P25_309_GMS_Zelestra_CapreiraPVP_H_TechProp_v0.pdf	application/pdf	0	7955a3fa8267a0ce5dd137d34fcefe6c	NULL	NULL	NULL	108	0	0	2025-06-18 17:23:20
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 20	20	64	estimate	P25_310_GMS_Zelestra_PianoSanCarloPVP_H_TechProp_v...	application/pdf	0	eec4ff740f35f86b3d4b65975fe3af9a	NULL	NULL	NULL	108	0	0	2025-06-18 17:23:48
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 21	21	65	estimate	P25_311_GMS_Zelestra_CastrenzePVP_H_TechProp_v0.pd...	application/pdf	0	76c6ad875c93cf3c5ff3c45dbbc336db	NULL	NULL	NULL	108	0	0	2025-06-18 17:24:13
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 22	22	84	estimate	P25_330_GMS_Trina Solar_Romboli 1 PVP_H_TechProp_v...	application/pdf	0	6894a4492ca04aa1ad758b5523b2fc2b	NULL	NULL	NULL	108	0	0	2025-06-25 09:07:53
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 23	23	83	estimate	P25_329_GMS_Trina Solar_Cecina PVP_H_TechProp_v1.p...	application/pdf	0	0d8b4c60c6287de56c75a247101adbee	NULL	NULL	NULL	108	0	0	2025-06-25 09:09:08
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 24	24	96	estimate	P25_342_GMS_Grenergy_PFV El Almendral_H_PropTec_v0...	application/pdf	0	9bd8e0cb5de5a73b0600e8a023f4118e	NULL	NULL	NULL	108	0	0	2025-07-01 09:48:18
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 25	25	100	estimate	P25_346_GMS_Grenergy_PFV AlconSolar_H_PropTec_v0.p...	application/pdf	0	d01e5f0d796964c3073024e15ca1d428	NULL	NULL	NULL	108	0	0	2025-07-01 10:12:17
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 26	26	98	estimate	P25_344_GMS_Grenergy_PFV Taruca_H_PropTec_v0.pdf	application/pdf	0	3b2b24213095775d304930a1afa32d2c	NULL	NULL	NULL	108	0	0	2025-07-01 10:12:41
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 27	27	116	estimate	P25_361_GMS_Chint Green Energy_DAMA PV Plantt_H_Te...	application/pdf	0	ccd03610eeb833ebe5a5481831ea3f1b	NULL	NULL	NULL	108	0	0	2025-07-09 08:45:36
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 28	28	129	estimate	P25_377_GMS_Voltalia_Dennistown PV Plant_H_TechPro...	application/pdf	0	46a15a4b8e37714c747d973866b0b344	NULL	NULL	NULL	108	0	0	2025-07-10 12:12:52
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 29	29	130	estimate	P25_378_GMS_Voltalia_Youngstown PV Plant_H_TechPro...	application/pdf	0	b8bbf88756093e9fd960f3b1d23ee1b7	NULL	NULL	NULL	108	0	0	2025-07-10 12:21:28
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 31	31	131	estimate	P25_379_GMS_Voltalia_Tullabeg 2 PV Plant_H_TechPro...	application/pdf	0	10db77be564b1850dc768993a6339722	NULL	NULL	NULL	108	0	0	2025-07-10 12:29:57
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 32	32	139	estimate	P25_387_GMS_RPower_Scornicesti BESS Project_H_Tech...	application/pdf	0	76896ad086d08f78b2e565f8a66c018d	NULL	NULL	NULL	108	0	0	2025-07-10 14:00:54
Edit	Copy	Delete DELETE FROM tblfiles WHERE `tblfiles`.`id` = 33	33	2261	task	1.4 Política Alcohol y Drogas para adherirse a pro...	application/pdf	0	b3f0dcc84a8b3046461b198b6ddb1c55	NULL	NULL	NULL	69	0	0	2025-07-24 12:36:25

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view