Query Template: /core/components/utilities/databaseconnector.cfc:138 Execution Time: 2.45 ms Record Count: 24 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 = 'mrassignee' 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	id	int	0	PRI		NO		int	auto_increment
2	Name	varchar				NO	255	varchar(255)		latin1
3	MGID	int	0	MUL	0	NO		int
4	NewMGID	int	0	MUL	0	NO		int
5	Email	varchar		MUL		NO	255	varchar(255)		latin1
6	Live	char		MUL	Yes	NO	3	char(3)		latin1
7	Username	varchar				NO	50	varchar(50)		latin1
8	ShowContact	char			no	NO	3	char(3)		latin1
9	Phone	varchar				NO	50	varchar(50)		latin1
10	ShowRequests	varchar			yes	NO	50	varchar(50)		latin1
11	MrlogPref	varchar			email	NO	10	varchar(10)		latin1
12	DesigneeType	varchar			Staff	NO	50	varchar(50)		latin1
13	EmailNotice	char				YES	3	char(3)		latin1
14	AdditionalEmailOption	text				YES	65535	text		latin1
15	DeletedBy	int	0		0	YES		int
16	DeletedDate	datetime				YES		datetime
17	Title	varchar				YES	255	varchar(255)		latin1
18	AssignRequests	varchar			no	NO	3	varchar(3)		latin1
19	userID	int	0	MUL		YES		int
20	CreateRequests	char			no	NO	3	char(3)		latin1
21	usermerged	varchar			false	NO	5	varchar(5)		latin1
22	PushNotifyViewed	varchar			no	NO	3	varchar(3)		latin1
23	password	varchar				YES	255	varchar(255)		latin1
24	CreateCommunications	char			no	NO	3	char(3)		latin1