18 lines
460 B
SQL
18 lines
460 B
SQL
DROP TABLE IF EXISTS db.blog;
|
|
|
|
CREATE TABLE db.blog (
|
|
id INT NOT NULL AUTO_INCREMENT,
|
|
published DATE NOT NULL,
|
|
title TEXT NOT NULL,
|
|
body TEXT NOT NULL,
|
|
url varchar(2048) NOT NULL,
|
|
CONSTRAINT id_PK PRIMARY KEY (id)
|
|
)
|
|
ENGINE=InnoDB
|
|
DEFAULT CHARSET=utf8mb4
|
|
COLLATE=utf8mb4_general_ci;
|
|
CREATE FULLTEXT INDEX blog_body_IDX ON db.blog (body);
|
|
|
|
{{ block "main" .}}
|
|
{{ end }}
|