MySQL Test Project 

 

Database Design

  

 

 

 

 

 

 

 

 

 

23/11/2006

Index

Database: mysql _ 3

Tables _ 3

columns_priv _ 3

db _ 3

func _ 3

help_category _ 3

help_keyword _ 3

help_relation _ 3

help_topic _ 3

host _ 3

tables_priv _ 3

time_zone _ 3

time_zone_leap_second _ 3

time_zone_name _ 3

time_zone_transition _ 3

time_zone_transition_type _ 3

user _ 3

Server Info _ 3

Users _ 3

'root'@'%' _ 3

'root'@'localhost' _ 3

About _ 3

Database: mysql

Properties

Name:

mysql

Tables

	Name	Engine	Comment
	columns_priv	MyISAM	utf8_bin
	db	MyISAM	utf8_bin
	func	MyISAM	utf8_bin
	help_category	MyISAM	utf8_general_ci
	help_keyword	MyISAM	utf8_general_ci
	help_relation	MyISAM	utf8_general_ci
	help_topic	MyISAM	utf8_general_ci
	host	MyISAM	utf8_bin
	tables_priv	MyISAM	utf8_bin
	time_zone	MyISAM	utf8_general_ci
	time_zone_leap_second	MyISAM	utf8_general_ci
	time_zone_name	MyISAM	utf8_general_ci
	time_zone_transition	MyISAM	utf8_general_ci
	time_zone_transition_type	MyISAM	utf8_general_ci
	user	MyISAM	utf8_bin

Total: 15 table(s)

See Also

Server overview

Tables

Table: columns_priv

Properties

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

Columns

		Name	Data Type	NULL	Default
		Host	char(60)		PRI
		Db	char(64)		PRI
		User	char(16)		PRI
		Table_name	char(64)		PRI
		Column_name	char(64)		PRI
		Timestamp	timestamp
		Column_priv	set('Select', 'Insert', 'Update', 'Referenc

Total: 7 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY

Total: 1 indexes(s)

SQL

CREATE TABLE `columns_priv` (
  `Host` char(60) collate utf8_bin NOT NULL default '',
  `Db` char(64) collate utf8_bin NOT NULL default '',
  `User` char(16) collate utf8_bin NOT NULL default '',
  `Table_name` char(64) collate utf8_bin NOT NULL default '',
  `Column_name` char(64) collate utf8_bin NOT NULL default '',
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',
  PRIMARY KEY  (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges'

See Also

List of tables

Indexes

Index: PRIMARY on table columns_priv

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Host	A
	Db	A
	User	A
	Table_name	A
	Column_name	A

Total: 5 column(s)

See Also

List of indexes

Table: db

Properties

Engine:	MyISAM
Row format:	9
Rows:	Fixed
Avg row length:	0
Data length:	0
Max data length:	866
Index length:	1859720839167
Data free:	4096
Auto increment:	866
Create time:
Update time:	19/07/2006
Check time:	18/11/2006
Create_options:
Comment:	utf8_bin

Columns

		Name	Data Type	NULL	Default
		Host	char(60)		PRI
		Db	char(64)		PRI
		User	char(16)		PRI
		Select_priv	enum('N', 'Y')
		Insert_priv	enum('N', 'Y')
		Update_priv	enum('N', 'Y')
		Delete_priv	enum('N', 'Y')
		Create_priv	enum('N', 'Y')
		Drop_priv	enum('N', 'Y')
		Grant_priv	enum('N', 'Y')
		References_priv	enum('N', 'Y')
		Index_priv	enum('N', 'Y')
		Alter_priv	enum('N', 'Y')
		Create_tmp_table_priv	enum('N', 'Y')
		Lock_tables_priv	enum('N', 'Y')

Total: 15 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY
	User

Total: 2 indexes(s)

SQL

CREATE TABLE `db` (
  `Host` char(60) collate utf8_bin NOT NULL default '',
  `Db` char(64) collate utf8_bin NOT NULL default '',
  `User` char(16) collate utf8_bin NOT NULL default '',
  `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  PRIMARY KEY  (`Host`,`Db`,`User`),
  KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges'

See Also

List of tables

Indexes

Index: PRIMARY on table db

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Host	A
	Db	A
	User	A

Total: 3 column(s)

See Also

List of indexes

Index: User on table db

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	User	A

Total: 1 column(s)

See Also

List of indexes

Table: func

Properties

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

Columns

		Name	Data Type	NULL	Default
		name	char(64)		PRI
		ret	tinyint(1)
		dl	char(128)
		type	enum('function', 'aggregate')

Total: 4 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY

Total: 1 indexes(s)

SQL

CREATE TABLE `func` (
  `name` char(64) collate utf8_bin NOT NULL default '',
  `ret` tinyint(1) NOT NULL default '0',
  `dl` char(128) collate utf8_bin NOT NULL default '',
  `type` enum('function','aggregate') character set utf8 NOT NULL default 'function',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions'

See Also

List of tables

Indexes

Index: PRIMARY on table func

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	name	A

Total: 1 column(s)

See Also

List of indexes

Table: help_category

Properties

Engine:	MyISAM
Row format:	9
Rows:	Dynamic
Avg row length:	34
Data length:	29
Max data length:	1000
Index length:	4294967295
Data free:	3072
Auto increment:	0
Create time:
Update time:	19/07/2006
Check time:	19/07/2006
Create_options:
Comment:	utf8_general_ci

Columns

		Name	Data Type	NULL	Default
		help_category_id	smallint(5) unsigned		PRI
		name	varchar(64)		UNI
		parent_category_id	smallint(5) unsigned
		url	varchar(128)

Total: 4 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY
	name

Total: 2 indexes(s)

SQL

CREATE TABLE `help_category` (
  `help_category_id` smallint(5) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `parent_category_id` smallint(5) unsigned default NULL,
  `url` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`help_category_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help categories'

See Also

List of tables

Indexes

Index: PRIMARY on table help_category

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	help_category_id	A

Total: 1 column(s)

See Also

List of indexes

Index: name on table help_category

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	name	A

Total: 1 column(s)

See Also

List of indexes

Table: help_keyword

Properties

Engine:	MyISAM
Row format:	9
Rows:	Dynamic
Avg row length:	359
Data length:	20
Max data length:	7512
Index length:	4294967295
Data free:	12288
Auto increment:	0
Create time:
Update time:	19/07/2006
Check time:	19/07/2006
Create_options:
Comment:	utf8_general_ci

Columns

		Name	Data Type	NULL	Default
		help_keyword_id	int(10) unsigned		PRI
		name	varchar(64)		UNI

Total: 2 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY
	name

Total: 2 indexes(s)

SQL

CREATE TABLE `help_keyword` (
  `help_keyword_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`help_keyword_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help keywords'

See Also

List of tables

Indexes

Index: PRIMARY on table help_keyword

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	help_keyword_id	A

Total: 1 column(s)

See Also

List of indexes

Index: name on table help_keyword

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	name	A

Total: 1 column(s)

See Also

List of indexes

Table: help_relation

Properties

Engine:	MyISAM
Row format:	9
Rows:	Fixed
Avg row length:	644
Data length:	9
Max data length:	5796
Index length:	38654705663
Data free:	11264
Auto increment:	0
Create time:
Update time:	19/07/2006
Check time:	19/07/2006
Create_options:
Comment:	utf8_general_ci

Columns

		Name	Data Type	NULL	Default
		help_topic_id	int(10) unsigned		PRI
		help_keyword_id	int(10) unsigned		PRI

Total: 2 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY

Total: 1 indexes(s)

SQL

CREATE TABLE `help_relation` (
  `help_topic_id` int(10) unsigned NOT NULL default '0',
  `help_keyword_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`help_keyword_id`,`help_topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='keyword-topic relation'

See Also

List of tables

Indexes

Index: PRIMARY on table help_relation

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	help_keyword_id	A
	help_topic_id	A

Total: 2 column(s)

See Also

List of indexes

Table: help_topic

Properties

Engine:	MyISAM
Row format:	9
Rows:	Dynamic
Avg row length:	417
Data length:	484
Max data length:	201892
Index length:	4294967295
Data free:	15360
Auto increment:	0
Create time:
Update time:	19/07/2006
Check time:	19/07/2006
Create_options:
Comment:	utf8_general_ci

Columns

		Name	Data Type	NULL	Default
		help_topic_id	int(10) unsigned		PRI
		name	varchar(64)		UNI
		help_category_id	smallint(5) unsigned
		description	text
		example	text
		url	varchar(128)

Total: 6 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY
	name

Total: 2 indexes(s)

SQL

CREATE TABLE `help_topic` (
  `help_topic_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `help_category_id` smallint(5) unsigned NOT NULL default '0',
  `description` text NOT NULL,
  `example` text NOT NULL,
  `url` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`help_topic_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help topics'

See Also

List of tables

Indexes

Index: PRIMARY on table help_topic

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	help_topic_id	A

Total: 1 column(s)

See Also

List of indexes

Index: name on table help_topic

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	name	A

Total: 1 column(s)

See Also

List of indexes

Table: host

Properties

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

Columns

		Name	Data Type	NULL	Default
		Host	char(60)		PRI
		Db	char(64)		PRI
		Select_priv	enum('N', 'Y')
		Insert_priv	enum('N', 'Y')
		Update_priv	enum('N', 'Y')
		Delete_priv	enum('N', 'Y')
		Create_priv	enum('N', 'Y')
		Drop_priv	enum('N', 'Y')
		Grant_priv	enum('N', 'Y')
		References_priv	enum('N', 'Y')
		Index_priv	enum('N', 'Y')
		Alter_priv	enum('N', 'Y')
		Create_tmp_table_priv	enum('N', 'Y')
		Lock_tables_priv	enum('N', 'Y')

Total: 14 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY

Total: 1 indexes(s)

SQL

CREATE TABLE `host` (
  `Host` char(60) collate utf8_bin NOT NULL default '',
  `Db` char(64) collate utf8_bin NOT NULL default '',
  `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  PRIMARY KEY  (`Host`,`Db`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges;  Merged with database privileges'

See Also

List of tables

Indexes

Index: PRIMARY on table host

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Host	A
	Db	A

Total: 2 column(s)

See Also

List of indexes

Table: tables_priv

Properties

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

Columns

		Name	Data Type	NULL	Default
		Host	char(60)		PRI
		Db	char(64)		PRI
		User	char(16)		PRI
		Table_name	char(64)		PRI
		Grantor	char(77)		MUL
		Timestamp	timestamp
		Table_priv	set('Select', 'Insert', 'Update', 'Delete',
		Column_priv	set('Select', 'Insert', 'Update', 'Referenc

Total: 8 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY
	Grantor

Total: 2 indexes(s)

SQL

CREATE TABLE `tables_priv` (
  `Host` char(60) collate utf8_bin NOT NULL default '',
  `Db` char(64) collate utf8_bin NOT NULL default '',
  `User` char(16) collate utf8_bin NOT NULL default '',
  `Table_name` char(64) collate utf8_bin NOT NULL default '',
  `Grantor` char(77) collate utf8_bin NOT NULL default '',
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') character set utf8 NOT NULL default '',
  `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',
  PRIMARY KEY  (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges'

See Also

List of tables

Indexes

Index: PRIMARY on table tables_priv

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Host	A
	Db	A
	User	A
	Table_name	A

Total: 4 column(s)

See Also

List of indexes

Index: Grantor on table tables_priv

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Grantor	A

Total: 1 column(s)

See Also

List of indexes

Table: time_zone

Properties

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

Columns

		Name	Data Type	NULL	Default
		Time_zone_id	int(10) unsigned		PRI
		Use_leap_seconds	enum('Y', 'N')

Total: 2 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY

Total: 1 indexes(s)

SQL

CREATE TABLE `time_zone` (
  `Time_zone_id` int(10) unsigned NOT NULL auto_increment,
  `Use_leap_seconds` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`Time_zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones'

See Also

List of tables

Indexes

Index: PRIMARY on table time_zone

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Time_zone_id	A

Total: 1 column(s)

See Also

List of indexes

Table: time_zone_leap_second

Properties

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

Columns

		Name	Data Type	NULL	Default
		Transition_time	bigint(20)		PRI
		Correction	int(11)

Total: 2 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY

Total: 1 indexes(s)

SQL

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint(20) NOT NULL default '0',
  `Correction` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Transition_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones'

See Also

List of tables

Indexes

Index: PRIMARY on table time_zone_leap_second

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Transition_time	A

Total: 1 column(s)

See Also

List of indexes

Table: time_zone_name

Properties

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

Columns

		Name	Data Type	NULL	Default
		Name	char(64)		PRI
		Time_zone_id	int(10) unsigned

Total: 2 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY

Total: 1 indexes(s)

SQL

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL default '',
  `Time_zone_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names'

See Also

List of tables

Indexes

Index: PRIMARY on table time_zone_name

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Name	A

Total: 1 column(s)

See Also

List of indexes

Table: time_zone_transition

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:	19/07/2006
Check time:	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

Indexes

Index: PRIMARY on table time_zone_transition

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Time_zone_id	A
	Transition_time	A

Total: 2 column(s)

See Also

List of indexes

Table: time_zone_transition_type

Properties

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:	19/07/2006
Check time:	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

Indexes

Index: PRIMARY on table time_zone_transition_type

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Time_zone_id	A
	Transition_type_id	A

Total: 2 column(s)

See Also

List of indexes

Table: user

Properties

Engine:	MyISAM
Row format:	9
Rows:	Dynamic
Avg row length:	2
Data length:	88
Max data length:	216
Index length:	4294967295
Data free:	2048
Auto increment:	40
Create time:
Update time:	19/07/2006
Check time:	18/11/2006
Create_options:
Comment:	utf8_bin

Columns

		Name	Data Type	NULL	Default
		Host	varchar(60)		PRI
		User	varchar(16)		PRI
		Password	varchar(41)
		Select_priv	enum('N', 'Y')
		Insert_priv	enum('N', 'Y')
		Update_priv	enum('N', 'Y')
		Delete_priv	enum('N', 'Y')
		Create_priv	enum('N', 'Y')
		Drop_priv	enum('N', 'Y')
		Reload_priv	enum('N', 'Y')
		Shutdown_priv	enum('N', 'Y')
		Process_priv	enum('N', 'Y')
		File_priv	enum('N', 'Y')
		Grant_priv	enum('N', 'Y')
		References_priv	enum('N', 'Y')
		Index_priv	enum('N', 'Y')
		Alter_priv	enum('N', 'Y')
		Show_db_priv	enum('N', 'Y')
		Super_priv	enum('N', 'Y')
		Create_tmp_table_priv	enum('N', 'Y')
		Lock_tables_priv	enum('N', 'Y')
		Execute_priv	enum('N', 'Y')
		Repl_slave_priv	enum('N', 'Y')
		Repl_client_priv	enum('N', 'Y')
		ssl_type	enum('', 'ANY', 'X509', 'SPECIFIED')
		ssl_cipher	blob
		x509_issuer	blob
		x509_subject	blob
		max_questions	int(11) unsigned
		max_updates	int(11) unsigned
		max_connections	int(11) unsigned

Total: 31 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY

Total: 1 indexes(s)

SQL

CREATE TABLE `user` (
  `Host` varchar(60) collate utf8_bin NOT NULL default '',
  `User` varchar(16) collate utf8_bin NOT NULL default '',
  `Password` varchar(41) collate utf8_bin NOT NULL default '',
  `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Reload_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Shutdown_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Process_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `File_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Show_db_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Super_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Repl_slave_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Repl_client_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL default '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL default '0',
  `max_updates` int(11) unsigned NOT NULL default '0',
  `max_connections` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Host`,`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'

See Also

List of tables

Indexes

Index: PRIMARY on table user

Properties

Primary:
Unique:
Collation:	A
Type:	BTREE

Index Columns

	Name	Collation
	Host	A
	User	A

Total: 2 column(s)

See Also

List of indexes

Server Info

Properties

Version:

4.1.21-community-nt

Databases

	Database
	mysql

Total: 1 database(s)

Server Configuration

Name	Value
back_log	50
basedir	D:\Program Files\MySQL\MySQL Server 4.1\
binlog_cache_size	32768
bulk_insert_buffer_size	8388608
character_set_client	latin1
character_set_connection	latin1
character_set_database	utf8
character_set_results	latin1
character_set_server	utf8
character_set_system	utf8
character_sets_dir	D:\Program Files\MySQL\MySQL Server 4.1\share\charsets/
collation_connection	latin1_swedish_ci
collation_database	utf8_general_ci
collation_server	utf8_general_ci
concurrent_insert	ON
connect_timeout	5
datadir	D:\Program Files\MySQL\MySQL Server 4.1\Data\
date_format	%Y-%m-%d
datetime_format	%Y-%m-%d %H:%i:%s
default_week_format	0
delay_key_write	ON
delayed_insert_limit	100
delayed_insert_timeout	300
delayed_queue_size	1000
expire_logs_days	0
flush	OFF
flush_time	1800
ft_boolean_syntax	+ -><()~*:""&|
ft_max_word_len	84
ft_min_word_len	4
ft_query_expansion_limit	20
ft_stopword_file	(built-in)
group_concat_max_len	1024
have_archive	YES
have_bdb	NO
have_blackhole_engine	NO
have_compress	YES
have_crypt	NO
have_csv	NO
have_example_engine	NO
have_geometry	YES
have_innodb	YES
have_isam	NO
have_ndbcluster	NO
have_merge_engine	YES
have_openssl	NO
have_query_cache	YES
have_raid	NO
have_rtree_keys	YES
have_symlink	YES
init_connect
init_file
init_slave
innodb_additional_mem_pool_siz	2097152
innodb_autoextend_increment	8
innodb_buffer_pool_awe_mem_mb	0
innodb_buffer_pool_size	8388608
innodb_data_file_path	ibdata1:10M:autoextend
innodb_data_home_dir
innodb_fast_shutdown	ON
innodb_file_io_threads	4
innodb_file_per_table	OFF
innodb_flush_log_at_trx_commit	1
innodb_flush_method
innodb_force_recovery	0
innodb_lock_wait_timeout	50
innodb_locks_unsafe_for_binlog	OFF
innodb_log_arch_dir
innodb_log_archive	OFF
innodb_log_buffer_size	1048576
innodb_log_file_size	10485760
innodb_log_files_in_group	2
innodb_log_group_home_dir	.\
innodb_max_dirty_pages_pct	90
innodb_max_purge_lag	0
innodb_mirrored_log_groups	1
innodb_open_files	300
innodb_table_locks	ON
innodb_thread_concurrency	8
interactive_timeout	28800
join_buffer_size	131072
key_buffer_size	8388608
key_cache_age_threshold	300
key_cache_block_size	1024
key_cache_division_limit	100
language	D:\Program Files\MySQL\MySQL Server 4.1\share\english\
large_files_support	ON
lc_time_names	en_US
license	GPL
local_infile	ON
log	OFF
log_bin	OFF
log_error	.\aanf.err
log_slave_updates	OFF
log_slow_queries	OFF
log_update	OFF
log_warnings	1
long_query_time	10
low_priority_updates	OFF
lower_case_file_system	OFF
lower_case_table_names	1
max_allowed_packet	1048576
max_binlog_cache_size	4294967295
max_binlog_size	1073741824
max_connect_errors	10
max_connections	100
max_delayed_threads	20
max_error_count	64
max_heap_table_size	16777216
max_insert_delayed_threads	20
max_join_size	4294967295
max_length_for_sort_data	1024
max_prepared_stmt_count	16382
max_relay_log_size	0
max_seeks_for_key	4294967295
max_sort_length	1024
max_tmp_tables	32
max_user_connections	0
max_write_lock_count	4294967295
myisam_data_pointer_size	4
myisam_max_extra_sort_file_siz	107374182400
myisam_max_sort_file_size	107374182400
myisam_recover_options	OFF
myisam_repair_threads	1
myisam_sort_buffer_size	8388608
myisam_stats_method	nulls_unequal
named_pipe	OFF
net_buffer_length	16384
net_read_timeout	30
net_retry_count	10
net_write_timeout	60
new	OFF
old_passwords	OFF
open_files_limit	622
pid_file	D:\Program Files\MySQL\MySQL Server 4.1\Data\aanf.pid
port	3306
preload_buffer_size	32768
prepared_stmt_count	0
protocol_version	10
query_alloc_block_size	8192
query_cache_limit	1048576
query_cache_min_res_unit	4096
query_cache_size	0
query_cache_type	ON
query_cache_wlock_invalidate	OFF
query_prealloc_size	8192
range_alloc_block_size	2048
read_buffer_size	61440
read_only	OFF
read_rnd_buffer_size	258048
relay_log_purge	ON
relay_log_space_limit	0
rpl_recovery_rank	0
secure_auth	OFF
shared_memory	OFF
shared_memory_base_name	MYSQL
server_id	0
skip_external_locking	ON
skip_networking	OFF
skip_show_database	OFF
slave_net_timeout	3600
slave_transaction_retries	0
slow_launch_time	2
sort_buffer_size	217080
sql_mode
sql_notes	ON
sql_warnings	ON
storage_engine	InnoDB
sync_binlog	0
sync_frm	ON
sync_replication	0
sync_replication_slave_id	0
sync_replication_timeout	0
system_time_zone	GTB Standard Time
table_cache	256
table_type	InnoDB
thread_cache_size	8
thread_stack	196608
time_format	%H:%i:%s
time_zone	SYSTEM
tmp_table_size	5242880
tmpdir
transaction_alloc_block_size	8192
transaction_prealloc_size	4096
tx_isolation	REPEATABLE-READ
version	4.1.21-community-nt
version_comment	MySQL Community Edition (GPL)
version_compile_machine	ia32
version_compile_os	Win32
wait_timeout	28800

See Also

Users
Hosts

Users

User: 'root'@'%'

Properties

User:	root
Host:	%

User Privileges

Select:
Insert:
Update:
Delete:
Create:
Drop:
Reload:
Shutdown:
Process:
File:
Grant:
Referencies:
Index:
Alter:
Show DB:
Super:
Create temp table:
Lock tables:
Execute:
Repl. slave:
Repl. client:
Max questions:	0
Max updates:	0
Max connections:	0

Grants

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION;

See Also

Server overview

User: 'root'@'localhost'

Properties

User:	root
Host:	localhost

User Privileges

Select:
Insert:
Update:
Delete:
Create:
Drop:
Reload:
Shutdown:
Process:
File:
Grant:
Referencies:
Index:
Alter:
Show DB:
Super:
Create temp table:
Lock tables:
Execute:
Repl. slave:
Repl. client:
Max questions:	0
Max updates:	0
Max connections:	0

Grants

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION;

See Also

Server overview

About

Documentation details

Customer:
Project:	MySQL Test Project
Created:	23/11/2006