Properties

Engine: MyISAM 
Row format:
Rows: Fixed 
Avg row length:
Data length:
Max data length:
Index length: 163208757247 
Data free: 1024 
Auto increment:
Create time:  
Update time: 2006/19/07/2006 
Check time: 2006/19/07/2006 
Create_options:  
Comment: utf8_general_ci 

Columns

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)     
Total: 5 column(s)

Indexes

Name Primary Unique
  PRIMARY     
Total: 1 indexes(s)

SQL

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