WARRANTY-REGISTRATION FORM

For registration of all non-Bagger products, including ice makers, crushers, dispensers, merchandisers and bins

IMPORTANT: This registration must be fully completed within 15 days of installation, to register your product and to initiate warranty coverage.

Business Name:

Contact Name:

Address:

Suite/PO Box:

City:

State:

Zipcode:

Country:

Phone Number:

Email:

Model:

Serial:

Purchase Date:--

Installation Date:--

Installation Company:

Installer Name:

Installer Phone Number:

Installer Address

Installer Address2

Installer City

Installer State

Installer Zip

Installer Country

(default) 11 queries took 69 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `warranties`	43	43	6
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	6
3	SHOW FULL COLUMNS FROM `models`	5	5	6
4	SHOW FULL COLUMNS FROM `model_types`	3	3	6
5	SHOW FULL COLUMNS FROM `countries`	2	2	6
6	SHOW FULL COLUMNS FROM `locations`	2	2	6
7	SELECT `Kmodel`.`id`, `Kmodel`.`name` FROM `models` AS `Kmodel` LEFT JOIN `model_types` AS `ModelType` ON (`Kmodel`.`model_type_id` = `ModelType`.`id`) WHERE `ModelType`.`name` != 'In Store Bagger'	7	7	6
8	SELECT `Country`.`id`, `Country`.`country` FROM `countries` AS `Country` WHERE 1 = 1	241	241	7
9	SELECT `InstallerCountry`.`id`, `InstallerCountry`.`country` FROM `countries` AS `InstallerCountry` WHERE 1 = 1	241	241	7
10	SELECT `DistributorCountry`.`id`, `DistributorCountry`.`country` FROM `countries` AS `DistributorCountry` WHERE 1 = 1	241	241	7
11	SELECT `Location`.`id`, `Location`.`location` FROM `locations` AS `Location` WHERE 1 = 1	2	2	6

(default) 11 queries took 69 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `warranties`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';

SHOW FULL COLUMNS FROM `models`

SHOW FULL COLUMNS FROM `model_types`

SHOW FULL COLUMNS FROM `countries`

SHOW FULL COLUMNS FROM `locations`

SELECT `Kmodel`.`id`, `Kmodel`.`name` FROM `models` AS `Kmodel` LEFT JOIN `model_types` AS `ModelType` ON (`Kmodel`.`model_type_id` = `ModelType`.`id`) WHERE `ModelType`.`name` != 'In Store Bagger'

SELECT `Country`.`id`, `Country`.`country` FROM `countries` AS `Country` WHERE 1 = 1

241

SELECT `InstallerCountry`.`id`, `InstallerCountry`.`country` FROM `countries` AS `InstallerCountry` WHERE 1 = 1

241

SELECT `DistributorCountry`.`id`, `DistributorCountry`.`country` FROM `countries` AS `DistributorCountry` WHERE 1 = 1

241

SELECT `Location`.`id`, `Location`.`location` FROM `locations` AS `Location` WHERE 1 = 1