Server: mysql wampserver »Database: mysql »Table: event"Events"
#NameTypeCollationAttributesNullDefaultExtraAction
1char(64)utf8_bin No Change ChangeDrop Drop
2char(64)utf8_general_ci No Change ChangeDrop Drop
3longblob No NoneChange ChangeDrop Drop
4char(77)utf8_bin No Change ChangeDrop Drop
5datetime Yes NULLChange ChangeDrop Drop
6int(11) Yes NULLChange ChangeDrop Drop
7enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'Mutf8_general_ci Yes NULLChange ChangeDrop Drop
8timestampon update CURRENT_TIMESTAMPNo CURRENT_TIMESTAMPON UPDATE CURRENT_TIMESTAMPChange ChangeDrop Drop
9timestamp No 0000-00-00 00:00:00Change ChangeDrop Drop
10datetime Yes NULLChange ChangeDrop Drop
11datetime Yes NULLChange ChangeDrop Drop
12datetime Yes NULLChange ChangeDrop Drop
13enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')utf8_general_ci No ENABLEDChange ChangeDrop Drop
14enum('DROP', 'PRESERVE')utf8_general_ci No DROPChange ChangeDrop Drop
15set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTutf8_general_ci No Change ChangeDrop Drop
16char(64)utf8_bin No Change ChangeDrop Drop
17int(10)UNSIGNEDNo NoneChange ChangeDrop Drop
18char(64)latin1_swedish_ci No SYSTEMChange ChangeDrop Drop
19char(32)utf8_bin Yes NULLChange ChangeDrop Drop
20char(32)utf8_bin Yes NULLChange ChangeDrop Drop
21char(32)utf8_bin Yes NULLChange ChangeDrop Drop
22longblob Yes NULLChange ChangeDrop Drop
With selected:With selected:

Print view Print viewPropose table structure Propose table structureDocumentation Move columns Move columns
Add columnAdd column(s)
Information
Space usage
Data0B
Index2KiB
Total2KiB
Row statistics
Formatdynamic
Collationutf8_general_ci
Rows0
CreationMar 14, 2014 at 01:30 PM
Last updateMay 01, 2014 at 09:06 AM