Skip to content

Instantly share code, notes, and snippets.

@SupaHam

SupaHam/2015-09-15_13-25-35.txt Secret

Created Sep 15, 2015
Embed
What would you like to do?
CREATE TABLE IF NOT EXISTS `server_stats` (
`server_session_id` BIGINT UNSIGNED NOT NULL,
`memory` SMALLINT UNSIGNED NOT NULL,
`cpu` SMALLINT UNSIGNED NOT NULL,
`players` SMALLINT NOT NULL,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT `fk_server_stats_server_sessions` FOREIGN KEY (`server_session_id`) REFERENCES `server_sessions` (`server_session_id`) ON DELETE CASCADE
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment