User:Pseudo Classes/page.sql

-- PHP Version: 7.3.2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

-- DATABASE
CREATE DATABASE IF NOT EXISTS page DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE page;

-- TABLE
DROP TABLE IF EXISTS lang;
CREATE TABLE lang (
  _number int(10) NOT NULL COMMENT '編號',
  _name varchar(10) NOT NULL COMMENT '語言代號',
  _date date NOT NULL COMMENT '更新日期',
  _status int(1) NOT NULL COMMENT '翻譯狀態',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- DATA
INSERT INTO lang (_number, _name, _date, _status) VALUES
(1, 'en', '2020-10-24', 1),
(2, 'zh-hant', '2020-10-24', 1),
(3, 'zh-hans', '2020-10-24', 1),
(4, 'ja', '2020-10-24', 0);

-- KEY
ALTER TABLE lang
  ADD PRIMARY KEY (_number);

-- AUTO_INCREMENT
ALTER TABLE lang
  MODIFY _number int(10) NOT NULL AUTO_INCREMENT COMMENT '編號', AUTO_INCREMENT=5;
COMMIT;