Engine: | MyISAM |
Row format: | 9 |
Rows: | Fixed |
Avg row length: | 0 |
Data length: | 0 |
Max data length: | 0 |
Index length: | 163208757247 |
Data free: | 1024 |
Auto increment: | 0 |
Create time: | |
Update time: | 2006/19/07/2006 |
Check time: | 2006/19/07/2006 |
Create_options: | |
Comment: | utf8_general_ci |
Name | Data Type | NULL | Default | ||
|
Time_zone_id | int(10) unsigned |
|
PRI | |
|
Transition_type_id | int(10) unsigned |
|
PRI | |
|
Offset | int(11) |
|
||
|
Is_DST | tinyint(3) unsigned |
|
||
|
Abbreviation | char(8) |
|
Name | Primary | Unique | |
|
PRIMARY |
|
|
CREATE TABLE `time_zone_transition_type` (
`Time_zone_id` int(10) unsigned NOT NULL default '0',
`Transition_type_id` int(10) unsigned NOT NULL default '0',
`Offset` int(11) NOT NULL default '0',
`Is_DST` tinyint(3) unsigned NOT NULL default '0',
`Abbreviation` char(8) NOT NULL default '',
PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types'
See Also
List of tables