Query Template: ../../test4.core.tenanthandbooks.com/httpdocs/components/utilities/databaseconnector.cfc:138 Execution Time: 3.32 ms Record Count: 35 Cached: No Lazy: No SQL: SELECT COLUMN_NAME, DATA_TYPE, NUMERIC_SCALE, COLUMN_KEY, COLUMN_DEFAULT, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, COLUMN_TYPE, EXTRA, CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'client' AND TABLE_SCHEMA = DATABASE() ORDER BY ORDINAL_POSITION
	COLUMN_NAME	DATA_TYPE	NUMERIC_SCALE	COLUMN_KEY	COLUMN_DEFAULT	IS_NULLABLE	CHARACTER_MAXIMUM_LENGTH	COLUMN_TYPE	EXTRA	CHARACTER_SET_NAME
1	ClientID	int	0	PRI		NO		int	auto_increment
2	CID	int	0	MUL		YES		int
3	AccountStatus	varchar		MUL	Active	NO	20	varchar(20)		latin1
4	Username	varchar				YES	50	varchar(50)		latin1
5	Company	varchar				YES	255	varchar(255)		latin1
6	CompanyName	varchar				YES	255	varchar(255)		latin1
7	Email	varchar				YES	255	varchar(255)		latin1
8	FirstName	varchar				YES	255	varchar(255)		latin1
9	LastName	varchar				YES	255	varchar(255)		latin1
10	AccessLevel	int	0		2	YES		int
11	Phone	varchar				YES	50	varchar(50)		latin1
12	MGID	int	0	MUL	0	NO		int
13	BetaTester	char			no	NO	3	char(3)		latin1
14	UsersBrowser	text				YES	65535	text		latin1
15	UsersBrowserShort	varchar				YES	50	varchar(50)		latin1
16	ScreenResolution	varchar				YES	255	varchar(255)		latin1
17	UsersOS	varchar				YES	25	varchar(25)		latin1
18	LastLogin	datetime				YES		datetime
19	JavascriptEnabled	char				YES	3	char(3)		latin1
20	Street1	varchar				YES	255	varchar(255)		latin1
21	Street2	varchar				YES	255	varchar(255)		latin1
22	City	varchar				YES	255	varchar(255)		latin1
23	State	varchar				YES	50	varchar(50)		latin1
24	Zip	varchar				YES	20	varchar(20)		latin1
25	Title	varchar				YES	255	varchar(255)		latin1
26	ImageName	varchar				YES	100	varchar(100)		latin1
27	tabscheck	varchar			no	NO	3	varchar(3)		latin1
28	userID	int	0	MUL		YES		int
29	usernameFlagged	varchar				YES	3	varchar(3)		latin1
30	DateAdded	datetime				YES		datetime
31	persona	varchar			undefined	YES	255	varchar(255)		latin1
32	npsSubmitDate	datetime				YES		datetime
33	usermerged	varchar			false	NO	5	varchar(5)		latin1
34	feedbackTeam	varchar			unknown	YES	10	varchar(10)		latin1
35	password	varchar				YES	255	varchar(255)		latin1