Android 作成 Gist

create-table.sql

$ mysql --version
mysql  Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1

DROP TABLE article;
CREATE TABLE IF NOT EXISTS article (
  id INT(11) NOT NULL AUTO_INCREMENT,
  title VARCHAR(50) DEFAULT NULL,
  created_datetime DATETIME NOT NULL,
  updated_datetime DATETIME NOT NULL,
  PRIMARY KEY(id)
);

CREATE TABLE IF NOT EXISTS article (
  id INT(11) NOT NULL AUTO_INCREMENT,
  title VARCHAR(50) DEFAULT NULL,
  created_datetime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_datetime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY(id)
);