Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `metric` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `host` varchar(50) NOT NULL,
- `userid` int(10) unsigned DEFAULT NULL,
- `name` varchar(255) NOT NULL,
- `sampleid` tinyint(3) unsigned NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `unique-metric` (`userid`,`host`,`name`,`sampleid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8
Add Comment
Please, Sign In to add comment