iD3b0gmq

1CREATE TABLE IF NOT EXISTS `coffee_mugs` (
2  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3  `tag` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
4  `owner` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
5  PRIMARY KEY (`id`),
6  KEY `tag` (`tag`)
7) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
8
9INSERT INTO `coffee_mugs` (`id`, `tag`, `owner`) VALUES
10(1, 'rfid-tag-1', 'User 1'),
11(2, 'rfid-tag-1', 'User 2'),
12(3, 'rfid-tag-1', 'User 3'),
13
14-- --------------------------------------------------------
15
16CREATE TABLE IF NOT EXISTS `coffee_usage` (
17  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
18  `coffee_mugs_id` smallint(5) unsigned NOT NULL,
19  `created_at` datetime DEFAULT NULL,
20  PRIMARY KEY (`id`),
21  KEY `coffee_mugs_id` (`coffee_mugs_id`)
22) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;