Query Template: /core/components/utilities/databaseconnector.cfc:138 Execution Time: 2.18 ms Record Count: 5 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 = 'smsoptins' 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	OptedIn	bit			b'1'	NO		bit(1)
3	PhoneNumber	varchar		MUL		NO	20	varchar(20)		latin1
4	DateAdded	datetime				NO		datetime
5	DateUpdated	datetime				NO		datetime