Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
remoteのサーバの状態をpushするためのデータベース及びテーブルを作成するためのSQL文
-- See https://pandanote.info/?p=7242 for details.
drop database if exists serverstatus;
create database serverstatus;
grant all privileges on serverstatus.* to 'serverstatus'@'%' identified by 'Some password to store the status of the remote server.';
grant all privileges on serverstatus.* to 'serverstatus'@'localhost' identified by 'Some password to store the status of the remote server.';
use serverstatus;
drop table if exists serverstatus;
create table serverstatus (
id int not null auto_increment,
status int not null,
updated_at timestamp not null,
primary key(id)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment