Properties

Engine: MyISAM 
Row format:
Rows: Fixed 
Avg row length:
Data length:
Max data length:
Index length: 73014444031 
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_time  bigint(20)    PRI 
    Transition_type_id  int(10) unsigned     
Total: 3 column(s)

Indexes

Name Primary Unique
  PRIMARY     
Total: 1 indexes(s)

SQL

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL default '0',
  `Transition_time` bigint(20) NOT NULL default '0',
  `Transition_type_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Time_zone_id`,`Transition_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions'

See Also

List of tables