Skip to content

Instantly share code, notes, and snippets.

@dunnock
Last active February 26, 2020 13:02
Show Gist options
  • Save dunnock/800ddda3763adb0766dc09c23d03cb7a to your computer and use it in GitHub Desktop.
Save dunnock/800ddda3763adb0766dc09c23d03cb7a to your computer and use it in GitHub Desktop.
actix-node-benchmark: create tables
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