Skip to content

Instantly share code, notes, and snippets.

@SupaHam

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

Created September 15, 2015 12:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SupaHam/e8fd13f5313fc9af82b4 to your computer and use it in GitHub Desktop.
Save SupaHam/e8fd13f5313fc9af82b4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
2015-09-15_13-25-35.txt
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