Recent
`wp_cttesnieres`.`iup5tdt_giftvouchers_setting`
Favorites
There are no favorite tables.
New
guestres
information_schema
mdgexpress
mysql
performance_schema
phpmyadmin
test
wp_cttesnieres
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: wp_cttesnieres
Table: iup5tdt_giftvouchers_setting
Browse
Structure
(current)
SQL
Search
Insert
Export
Import
Privileges
Operations
Triggers
Console
Clear
History
Options
Debug SQL
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
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 :
Loading
ENUM/SET editor
Create view
Table structure
Table structure
Settings for the table structure (list of columns).
Table structure
Hide table structure actions
Whether the table structure actions should be hidden.
Show column comments
Whether column comments should be shown in table structure view
Default transformations
Default transformations for Hex
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
2
Default transformations for Substring
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 all …
Default transformations for Bool2Text
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
T F
Default transformations for External
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 local
Default transformations for Inline
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 100
Default transformations for TextImageLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 50
Default transformations for TextLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Table structure
Relation view
iup5tdt_giftvouchers_setting
#
Name
Type
Collation
Attributes
Null
Default
Comments
Extra
Action
1
id
int(11)
No
None
AUTO_INCREMENT
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
2
is_woocommerce_enable
int(1)
Yes
0
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
3
is_style_choose_enable
int(1)
Yes
0
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
4
is_order_form_enable
int(1)
Yes
1
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
5
voucher_style
varchar(100)
utf8mb4_unicode_520_ci
Yes
0
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
6
company_name
varchar(255)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
7
currency_code
varchar(10)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
8
currency
varchar(10)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
9
currency_position
varchar(10)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
10
voucher_bgcolor
varchar(6)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
11
voucher_color
varchar(6)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
12
template_col
int(2)
Yes
3
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
13
voucher_min_value
int(4)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
14
voucher_max_value
int(6)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
15
voucher_expiry_type
varchar(6)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
16
voucher_expiry
varchar(10)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
17
voucher_terms_note
text
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
18
custom_loader
text
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
19
pdf_footer_url
varchar(255)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
20
pdf_footer_email
varchar(255)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
21
post_shipping
int(1)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
22
shipping_method
text
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
23
preview_button
int(1)
Yes
1
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
24
paypal
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
25
sofort
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
26
stripe
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
27
paypal_email
varchar(100)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
28
sofort_configure_key
varchar(100)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
29
reason_for_payment
varchar(100)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
30
stripe_publishable_key
varchar(255)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
31
stripe_secret_key
varchar(255)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
32
sender_name
varchar(100)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
33
sender_email
varchar(100)
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
34
test_mode
int(10)
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
35
per_invoice
int(10)
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
36
bank_info
longtext
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
37
landscape_mode_templates
text
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
38
portrait_mode_templates
text
utf8mb4_unicode_520_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Check all
With selected:
Browse
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Move columns
Move the columns by dragging them up and down.
Preview SQL
Loading…
Error
Print
Propose table structure
Move columns
Normalize
Add
column(s)
at beginning of table
after id
after is_woocommerce_enable
after is_style_choose_enable
after is_order_form_enable
after voucher_style
after company_name
after currency_code
after currency
after currency_position
after voucher_bgcolor
after voucher_color
after template_col
after voucher_min_value
after voucher_max_value
after voucher_expiry_type
after voucher_expiry
after voucher_terms_note
after custom_loader
after pdf_footer_url
after pdf_footer_email
after post_shipping
after shipping_method
after preview_button
after paypal
after sofort
after stripe
after paypal_email
after sofort_configure_key
after reason_for_payment
after stripe_publishable_key
after stripe_secret_key
after sender_name
after sender_email
after test_mode
after per_invoice
after bank_info
after landscape_mode_templates
after portrait_mode_templates
Indexes
Loading
Action
Keyname
Type
Unique
Packed
Column
Cardinality
Collation
Null
Comment
Edit
Rename
Drop
PRIMARY
BTREE
Yes
No
id
0
A
No
Create an index on
columns
Loading
Preview SQL
Loading…
Partitions
No partitioning defined!
Information
Space usage
Data
16.0
KiB
Index
0
B
Overhead
0
B
Effective
16.0
KiB
Total
16.0
KiB
Optimize table
Row statistics
Format
dynamic
Collation
utf8mb4_unicode_520_ci
Next autoindex
2
Creation
Sep 06, 2026 at 10:31 AM
Last update
Nov 12, 2026 at 10:56 AM
Last check
Nov 12, 2026 at 10:56 AM