(Recent tables) ...
There are no recent tables
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.emVudGFvZXA=
cm9vdA==.emVudGFvZXA=
0
zentaoep
Javascript must be enabled past this point
Server: localhost:3306
»
Database: zentaoep
»
Table: zt_suitecase
Browse
Structure
SQL
Search
Insert
Export
Import
Operations
Triggers
The column name 'case' is a MySQL reserved keyword.
#
Name
Type
Collation
Attributes
Null
Default
Extra
Action
1
suite
mediumint(8)
UNSIGNED
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
2
product
mediumint(8)
UNSIGNED
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
3
case
mediumint(8)
UNSIGNED
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
4
version
smallint(5)
UNSIGNED
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Check All
With selected:
Browse
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Move the columns by dragging them up and down.
Print view
Propose table structure
Move columns
Add
column(s)
At End of Table
At Beginning of Table
After
suite
product
case
version
Indexes
No index defined!
Action
Keyname
Type
Unique
Packed
Column
Cardinality
Collation
Null
Comment
Edit
Drop
suitecase
BTREE
Yes
No
suite
A
No
case
0
A
No
Create an index on
columns
Information
Space usage
Data
0
B
Index
1
KiB
Total
1
KiB
Row statistics
Format
static
Collation
utf8_general_ci
Rows
0
Creation
Jul 17, 2019 at 03:48 PM
Last update
Jul 17, 2019 at 03:48 PM