CREATE DATABASE IF NOT EXISTS `water`;

USE `water`;

GRANT ALL PRIVILEGES ON water.* TO water IDENTIFIED BY 'rGzh15JAh9';

CREATE TABLE IF NOT EXISTS `datas` (
	`id` BIGINT NOT NULL auto_increment,
	`name` VARCHAR(12) NOT NULL,
	`vane` SMALLINT NOT NULL,
	`date` VARCHAR(5) NOT NULL,
	`value` VARCHAR(1) NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`)
) DEFAULT CHARSET=utf8;
