Query Template: /core/components/utilities/databaseconnector.cfc:138 Execution Time: 2.86 ms Record Count: 68 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 = 'mastertenants' 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	BID	int	0	MUL	0	NO		int
3	CID	int	0	MUL	0	NO		int
4	old_UID	int	0		0	NO		int
5	old_CID	int	0		0	NO		int
6	Company	varchar			0	YES	255	varchar(255)		latin1
7	FirstName	varchar				YES	100	varchar(100)		latin1
8	LastName	varchar				YES	100	varchar(100)		latin1
9	Email	varchar				YES	255	varchar(255)		latin1
10	Email2	varchar				YES	200	varchar(200)		latin1
11	Email3	varchar				YES	200	varchar(200)		latin1
12	Phone	varchar				YES	50	varchar(50)		latin1
13	Username	varchar		MUL		YES	50	varchar(50)		latin1
14	Suite	varchar				YES	100	varchar(100)		latin1
15	Fax	varchar				YES	50	varchar(50)		latin1
16	Live	char			yes	NO	3	char(3)		latin1
17	Floor	int	0		0	NO		int
18	EmergencyNumber	varchar				YES	50	varchar(50)		latin1
19	DateAdded	datetime			0000-00-00 00:00:00	YES		datetime
20	LastEmail	datetime			0000-00-00 00:00:00	YES		datetime
21	SendEmail	char			no	YES	3	char(3)		latin1
22	SMSNumber	varchar				YES	100	varchar(100)		latin1
23	SMSProvider	int	0		0	YES		int
24	SecureAreas	char		MUL	no	NO	3	char(3)		latin1
25	ENS	char			no	YES	3	char(3)		latin1
26	Title	varchar				YES	255	varchar(255)		latin1
27	EmailPreference	varchar			none	YES	5	varchar(5)		latin1
28	CalendarSub	char			yes	YES	3	char(3)		latin1
29	InstantAlertSub	char			yes	YES	3	char(3)		latin1
30	ENSSub	char			yes	YES	3	char(3)		latin1
31	InstantAlertLevel	varchar			all	YES	15	varchar(15)		latin1
32	InstantAlertEmergency	char			yes	YES	3	char(3)		latin1
33	Custom1Data	varchar				YES	255	varchar(255)		latin1
34	Custom2Data	varchar				YES	255	varchar(255)		latin1
35	Custom3Data	varchar				YES	255	varchar(255)		latin1
36	Custom4Data	varchar				YES	255	varchar(255)		latin1
37	Custom5Data	varchar				YES	255	varchar(255)		latin1
38	AllowServiceRequests	char		MUL	yes	YES	3	char(3)		latin1
39	AllowConference	char		MUL	yes	YES	3	char(3)		latin1
40	AllowFreight	char		MUL	yes	YES	3	char(3)		latin1
41	AllowCert	char		MUL	yes	YES	3	char(3)		latin1
42	Tagged	char			no	NO	5	char(5)		latin1
43	NewEmail	varchar			none	NO	255	varchar(255)		latin1
44	OldEmail	varchar			none	NO	255	varchar(255)		latin1
45	UserBrowser	text				YES	65535	text		latin1
46	SyncID	int	0		0	NO		int
47	DateUpdated	timestamp				YES		timestamp
48	LastLogin	datetime				YES		datetime
49	AllowTenantAdmin	char			no	NO	3	char(3)		latin1
50	LeaseID	varchar				YES	255	varchar(255)		latin1
51	EmailBounceCount	int	0		0	NO		int
52	LastEmailError	varchar				YES	255	varchar(255)		latin1
53	forceUsernameChange	varchar			no	NO	3	varchar(3)		latin1
54	duplicateUserFlag	varchar			no	NO	3	varchar(3)		latin1
55	tabscheck	varchar			no	NO	3	varchar(3)		latin1
56	duplicateUserEmailSent	varchar			no	NO	3	varchar(3)		latin1
57	userID	int	0	MUL		YES		int
58	requestSource	varchar			desktop	NO	50	varchar(50)		latin1
59	ReceiveEmailNotifications	bit			b'0'	NO		bit(1)
60	ReceiveHighPriorityEmailOnly	bit			b'0'	NO		bit(1)
61	ReceiveTextNotifications	bit			b'0'	NO		bit(1)
62	ReceiveHighPriorityTextOnly	bit			b'0'	NO		bit(1)
63	usermerged	varchar			false	NO	5	varchar(5)		latin1
64	usermergeflagged	varchar			false	NO	5	varchar(5)		latin1
65	PushNotifyViewed	varchar			no	NO	3	varchar(3)		latin1
66	password	varchar				YES	255	varchar(255)		latin1
67	receiveNegativeSRRatingEmails	bit			b'0'	NO		bit(1)
68	receivePositiveSRRatingEmails	bit			b'0'	NO		bit(1)