Query Template: ../../test4.utilities.tenanthandbooks.com/httpdocs/core/components/utilities/databaseconnector.cfc:138 Execution Time: 2.26 ms Record Count: 27 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 = 'reporting' 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	clientID	int	0	MUL		NO		int
3	name	varchar				NO	255	varchar(255)		latin1
4	ReportType	varchar				YES	255	varchar(255)		latin1
5	type	varchar				NO	50	varchar(50)		latin1
6	dateadded	datetime				NO		datetime
7	tablePrefix	varchar				YES	255	varchar(255)		latin1
8	status	varchar			New	NO	50	varchar(50)		latin1
9	lastViewedDate	datetime				YES		datetime
10	Recurring	varchar			no	NO	3	varchar(3)		latin1
11	ParentReportID	int	0	MUL	0	NO		int
12	QueuedEventAction	varchar				YES	255	varchar(255)		latin1
13	QueuedEventID	int	0			YES		int
14	RecurrUntil	datetime				YES		datetime
15	RecurringFrequency	varchar				YES	255	varchar(255)		latin1
16	RecurringEmails	text				YES	65535	text		latin1
17	RecurringFrequencyStart	varchar				YES	255	varchar(255)		latin1
18	LastRecurringDate	datetime				YES		datetime
19	DataUpdatedDate	datetime				YES		datetime
20	LayoutUpdatedDate	datetime				YES		datetime
21	TablesFinishedCopying	varchar				YES	1000	varchar(1000)		latin1
22	CurrentCopyingTable	varchar				YES	50	varchar(50)		latin1
23	LastFinishedCopyingIndex	int	0			YES		int
24	CopyAttempts	int	0		0	NO		int
25	LastAllDataLogIDCopied	int	0		0	NO		int
26	RecurringStartDate	date				YES		date
27	ArchiveFormat	varchar			RawData	YES	255	varchar(255)		latin1