Gus Mueller

Database visualizer

create new table db tools manually enter SQL

gus_demo : tf_scriptlog : column analysis

column	foreign refs	primary refs	minval	maxval	median	mean	stand dev	nonnulls	no nulls	minsize	maxsize	type	defacto type
scriptlog_id			1734	11956	6846	6,845.000	2,951.126	10223	1	4	5	int(11)	int(5)
pre_script			9	9		0.003	8.997	10223	1	1	1	varchar(1)	varchar(1)
post_script			9	9		0.003	8.997	56		1	1	varchar(1)	varchar(1)
type								10223	1	1	1	varchar(1)	varchar(1)
time_executed								10223	1	19	19	timestamp	datetime

rescheme table based on defacto type

Read the documentation.