DROP DATABASE `sample`
GO

CREATE DATABASE `sample`
	DEFAULT CHARACTER SET latin1
	DEFAULT COLLATE latin1_swedish_ci
GO

CREATE TABLE `sample`.`customer`  ( 
	`customer_id`	double COMMENT 'Stores customer identifiers'  NOT NULL,
	`firstname`  	tinyblob COMMENT 'Blob/text does not have default values'  NULL,
	`lastname`   	mediumblob COMMENT 'Blob/text does not have default values'  NULL,
	`address_id` 	mediumtext COMMENT 'Stores address identifiers'  NULL
)
GO

CREATE EVENT `sample`.`myevent`
    ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
    DO
      UPDATE `sample`.`customer` SET `customer_id` = `customer_id` + 1
GO