Query Template: ../../test4.core.tenanthandbooks.com/httpdocs/components/utilities/databaseconnector.cfc:138 Execution Time: 2.72 ms Record Count: 41 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 = 'users' 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	password	varchar				NO	128	varchar(128)		latin1
3	passwordSalt	varchar				NO	256	varchar(256)		latin1
4	passwordFlagged	varchar				YES	3	varchar(3)		latin1
5	lastChanged	datetime				YES		datetime
6	tempPasswordDate	datetime				YES		datetime
7	Timezone	varchar				YES	100	varchar(100)		latin1
8	Username	varchar		MUL		YES	50	varchar(50)		latin1
9	FirstName	varchar				YES	255	varchar(255)		latin1
10	LastName	varchar				YES	255	varchar(255)		latin1
11	Title	varchar				YES	255	varchar(255)		latin1
12	Email	varchar		MUL		YES	255	varchar(255)		latin1
13	Email2	varchar				YES	255	varchar(255)		latin1
14	Email3	varchar				YES	255	varchar(255)		latin1
15	Phone	varchar				YES	50	varchar(50)		latin1
16	Fax	varchar				YES	50	varchar(50)		latin1
17	EmergencyNumber	varchar				YES	50	varchar(50)		latin1
18	SMSNumber	varchar				YES	100	varchar(100)		latin1
19	formattedSMSNumber	varchar		MUL		YES	100	varchar(100)		latin1
20	Suite	varchar				YES	100	varchar(100)		latin1
21	Floor	int	0			YES		int
22	DateAdded	datetime				YES		datetime
23	DateUpdated	datetime				YES		datetime
24	LastLogin	datetime				YES		datetime
25	UsersBrowser	text				YES	65535	text		latin1
26	UsersBrowserShort	varchar				YES	50	varchar(50)		latin1
27	ScreenResolution	varchar				YES	255	varchar(255)		latin1
28	UsersOS	varchar				YES	25	varchar(25)		latin1
29	Street1	varchar				YES	255	varchar(255)		latin1
30	Street2	varchar				YES	255	varchar(255)		latin1
31	City	varchar				YES	255	varchar(255)		latin1
32	State	varchar				YES	50	varchar(50)		latin1
33	Zip	varchar				YES	20	varchar(20)		latin1
34	AccountStatus	varchar				YES	20	varchar(20)		latin1
35	UserType	int	0			YES		int
36	LastTenant	int	0			YES		int
37	PrimaryBID	int	0			YES		int
38	ShowNewUserModal	bit			b'1'	NO		bit(1)
39	hideUserFromApps	bit			b'0'	NO		bit(1)
40	showmergeuser	bit			b'0'	NO		bit(1)
41	subscribedAtRequestAccount	bit				YES		bit(1)