gistfile1.txt

(default) 13 queries took 18 ms Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `cake_programs`		4	4	2
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';		1	1	1
3	SHOW FULL COLUMNS FROM `cake_dispensing_solutions`		8	8	5
4	SHOW FULL COLUMNS FROM `cake_patient_buildings`		9	9	2
5	SHOW FULL COLUMNS FROM `cake_practice_operations`		9	9	3
6	SHOW FULL COLUMNS FROM `cake_team_training_educations`		13	13	2
7	SHOW FULL COLUMNS FROM `cake_locations`		22	22	2
8	START TRANSACTION		0		0
9	INSERT INTO `cake_programs` (`goals`, `modified`, `created`, `id`) VALUES ('{\"year_1\":\"1,111\",\"year_2\":\"$11.11\",\"year_3\":\"3000\"}', '2010-12-21 15:44:34', '2010-12-21 15:44:34', '4d111fc2-61d4-40de-8154-0309e0943fa0')		1		1
10	INSERT INTO `cake_locations` (`doc_first_name`, `doc_last_name`, `practice_name`, `address_1`, `address_2`, `city`, `province`, `postal`, `phone`, `fax`, `primary_contact_first_name`, `primary_contact_last_name`, `primary_contact_title`, `primary_contact_email`, `primary_contact_phone`, `primary_contact_fax`, `modified`, `created`, `id`) VALUES ('4yan', '4ibbons', '4yan Gibbons', '4300 Ridglea Place', '4uite 408', '4ort Worth', '4X', '46116', '4177571839', '4178621401', '4yan', '4ibbons', '4r', '4yan.gibbons@warrendouglas.com', '4128399493', '4372939394', '2010-12-21 15:44:34', '2010-12-21 15:44:34', '4d111fc2-15a0-4ed1-bfb7-0309e0943fa0')		1		0
11	INSERT INTO `cake_team_training_educations` (`dispenser_quick_start_program`, `dispenser_program_signups`, `apollo_advanced_eyecare_professionals`, `apollo_signups`, `essilor_resource_library`, `manage_care_training_services`, `manage_care_training_plans`, `practice_management_workshops`, `practice_workshops_signups`, `program_id`, `modified`, `created`, `id`) VALUES (1, '[{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\",\"start_date\":\"01\\/10\",\"certification_level\":\"1\"},{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\",\"start_date\":\"01\\/10\",\"certification_level\":\"21b\"}]', 1, '[{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\",\"start_date\":\"01\\/10\",\"certification_level\":\"21b\"},{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\",\"start_date\":\"01\\/10\",\"certification_level\":\"21e\"}]', 1, 1, '[{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"1\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"1\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"1\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"1\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"2\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"3\"}]', 1, '{\"event\":\"21b\",\"0\":{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\"}}', '4d111fc2-61d4-40de-8154-0309e0943fa0', '2010-12-21 15:44:34', '2010-12-21 15:44:34', '4d111fc2-bd50-4d3c-96f8-0309e0943fa0')		1		0
12	INSERT INTO `cake_patient_buildings` (`employer_initiatives`, `eloa_marketbuilder`, `myonlineoptical`, `taye_crizal_advertising_campaign`, `appointment_scheduling`, `program_id`, `modified`, `created`, `id`) VALUES (1, 1, 1, 1, 1, '4d111fc2-61d4-40de-8154-0309e0943fa0', '2010-12-21 15:44:34', '2010-12-21 15:44:34', '4d111fc2-a78c-4edf-a83d-0309e0943fa0')		1		0
13	COMMIT