devsnoteapi:Projeto Simples de API以及NodeJS 源码

Crie o Banco de Dados CREATE DATABASE表示字符集utf8mb4 COLLATE utf8mb4_general_ci; -devnotes.notes定义 CREATE TABLE notes ( id BIGINT(20)无符号NOT NULL AUTO_INCREMENT, title为varchar(190)COLLATE utf8mb4_unicode_ci DEFAULT NULL, body文本COLLATE utf8mb4_unicode_ci, created_at时间戳NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at时间戳NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY( id ))ENGI