SQL Schema Management

*Table structures are located at the bottom.

A. Create Table

create table pages
(
    id          bigint unsigned  auto_increment primary key,
    author_id   bigint unsigned  not null,
    title       varchar(128)     not null,
    content     text             not null,
    created_at  timestamp        not null,
    updated_at  timestamp        not null,
)
    collate = utf8mb4_unicode_ci;

Resulting Schema

field	type	nullable	key	other
id	bigint	no	primary	auto_increment
author_id	bigint	no
title	varchar(128)	no
content	text	no
created_at	timestamp	no
updated_at	timestamp	no