Skip to content

Instantly share code, notes, and snippets.

@dunnock

dunnock/actix-node-bench-db-create.sql

Last active February 26, 2020 13:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dunnock/800ddda3763adb0766dc09c23d03cb7a to your computer and use it in GitHub Desktop.
Save dunnock/800ddda3763adb0766dc09c23d03cb7a to your computer and use it in GitHub Desktop.
Download ZIP
actix-node-benchmark: create tables
Raw
actix-node-bench-db-create.sql
CREATE TABLE worker (
id SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
email varchar(255) NULL,
score integer DEFAULT 0
);
CREATE TABLE task (
id SERIAL PRIMARY KEY,
summary varchar(255) NOT NULL,
description text NOT NULL,
assignee_id integer NULL REFERENCES worker,
created TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment