Skip to content

Instantly share code, notes, and snippets.

@Adurtxi
Last active July 19, 2021 10:27
Show Gist options
  • Select an option

  • Save Adurtxi/427db9f96ca6b744e54564550979f25c to your computer and use it in GitHub Desktop.

Select an option

Save Adurtxi/427db9f96ca6b744e54564550979f25c to your computer and use it in GitHub Desktop.
NodeJS, Express and MySQL -- db.sql
CREATE DATABASE nodejs_mysql;
USE nodejs_mysql;
CREATE TABLE documents (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(50) NOT NULL,
description text NULL,
created_at datetime NOT NULL,
updated_at datetime NOT NULL,
CONSTRAINT pk_documents PRIMARY KEY (id)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment