Properties

Engine:	MyISAM
Row format:	9
Rows:	Fixed
Avg row length:	0
Data length:	0
Max data length:	0
Index length:	73014444031
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

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