Query Template: /core/components/utilities/databaseconnector.cfc:138 Execution Time: 13.4 ms Record Count: 74 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 = 'preftcm' 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			NO		int
3	Custom1Name	varchar				YES	100	varchar(100)		latin1
4	Custom2Name	varchar				YES	100	varchar(100)		latin1
5	Custom3Name	varchar				YES	100	varchar(100)		latin1
6	Custom4Name	varchar				YES	100	varchar(100)		latin1
7	Custom5Name	varchar				YES	100	varchar(100)		latin1
8	AllowTenantSignup	char			yes	YES	3	char(3)		latin1
9	ShowGroups	char			yes	YES	3	char(3)		latin1
10	CalendarTemplate	int	0		0	YES		int
11	ENSTemplate	int	0		0	YES		int
12	InstantAlertTemplate	int	0		0	YES		int
13	ShowEmailOnList	char			yes	YES	3	char(3)		latin1
14	ShowFloorOnList	char			no	YES	3	char(3)		latin1
15	ShowUsernameOnList	char			yes	YES	3	char(3)		latin1
16	ShowSuiteOnList	char			no	YES	3	char(3)		latin1
17	ArchiveEmail	int	0		60	NO		int
18	RequestEmails	text				YES	65535	text		latin1
19	CreateUser_GenerateNewUser	char			no	NO	3	char(3)		latin1
20	CreateUser_PostServiceRequests	char			no	NO	3	char(3)		latin1
21	CreateUser_TenantAdmin	char			no	NO	3	char(3)		latin1
22	CreateUser_ConfRoom	char			no	NO	3	char(3)		latin1
23	CreateUser_Freight	char			no	NO	3	char(3)		latin1
24	CreateUser_CertIns	char			no	NO	3	char(3)		latin1
25	CreateUser_BuildingCalendar	char			yes	NO	3	char(3)		latin1
26	CreateUser_EmailNotification	char			yes	NO	3	char(3)		latin1
27	CreateUser_InstantAlerts	char			yes	NO	3	char(3)		latin1
28	CreateUser_InstantAlertLevels	char			all	NO	50	char(50)		latin1
29	CreateUser_GroupList	text				YES	65535	text		latin1
30	CreateUser_ReceiveEmailNotifications	char			yes	NO	3	char(3)		latin1
31	CreateUser_ReceiveTextNotifications	char			yes	NO	3	char(3)		latin1
32	CreateUser_ReceiveHighPriorityEmailOnly	char			no	NO	3	char(3)		latin1
33	CreateUser_ReceiveHighPriorityTextOnly	char			no	NO	3	char(3)		latin1
34	Display_Users_Rows	int	0		100	NO		int
35	Display_Users_ShowuserPhoto	char			no	NO	3	char(3)		latin1
36	Display_Users_ShowName	char			yes	NO	3	char(3)		latin1
37	Display_Users_ShowCompany	char			yes	NO	3	char(3)		latin1
38	Display_Users_ShowEmail	char			yes	NO	3	char(3)		latin1
39	Display_Users_ShowPhone	char			no	NO	3	char(3)		latin1
40	Display_Users_ShowUsername	char			no	NO	3	char(3)		latin1
41	Display_Users_ShowFloor	char			yes	NO	3	char(3)		latin1
42	Display_Users_ShowBuilding	char			yes	NO	3	char(3)		latin1
43	Display_Access_Rows	int	0		50	NO		int
44	Display_Access_ShowTenant	char			yes	NO	3	char(3)		latin1
45	Display_Access_ShowDate	char			yes	NO	3	char(3)		latin1
46	Display_Access_ShowTime	char			yes	NO	3	char(3)		latin1
47	Display_Access_ShowUsername	char			yes	NO	3	char(3)		latin1
48	Display_Access_ShowPassword	char			yes	NO	3	char(3)		latin1
49	Display_Access_ShowBuilding	char			yes	NO	3	char(3)		latin1
50	Display_Access_ShowLogin	char			yes	NO	3	char(3)		latin1
51	Display_Access_ShowLocation	char			yes	NO	3	char(3)		latin1
52	SendLogin_Message	text				YES	65535	text		latin1
53	SendLogin_Message_MTC_TM	text				YES	65535	text		latin1
54	SendLogin_Template	int	0		0	NO		int
55	ApproveAccess_Message	text				YES	65535	text		latin1
56	ApproveAccess_Template	int	0		0	NO		int
57	DenyAccess_Message	text				YES	65535	text		latin1
58	DenyAccess_Template	int	0		0	NO		int
59	ResetPassword_Message	text				YES	65535	text		latin1
60	ResetPassword_Template	int	0		0	NO		int
61	Display_Users_ShowSuite	char			yes	NO	3	char(3)		latin1
62	Display_History_ShowApplication	char			yes	NO	3	char(3)		latin1
63	Display_History_ShowDateAdded	char			yes	NO	3	char(3)		latin1
64	Display_History_ShowAddedBy	char			yes	NO	3	char(3)		latin1
65	Display_History_ShowBuilding	char			yes	NO	3	char(3)		latin1
66	Display_History_ShowCompany	char			yes	NO	3	char(3)		latin1
67	AllowSMSReply	char			no	YES	3	char(3)		latin1
68	SMSReplyEmails	text				YES	65535	text		latin1
69	Display_History_ShowContact	char			yes	NO	3	char(3)		latin1
70	Display_History_ShowHistoryItems	char			yes	NO	3	char(3)		latin1
71	Display_History_ShowUserType	char			yes	NO	3	char(3)		latin1
72	Display_History_Rows	int	0		50	NO		int
73	Display_Users_ShowUserType	char			yes	NO	3	char(3)		latin1
74	SendLogin_Message_MTM	text				YES	65535	text		latin1