· 8 years ago · Mar 27, 2018, 07:44 AM
1const { Client } = require("pg");
2const client = new Client({
3 connectionString: process.env.DATABASE_URL,
4 ssl: true
5});
6//connection query and creation of tables
7client.connect();
8const db_creation_string = `CREATE TABLE IF NOT EXISTS invitations(id SERIAL PRIMARY KEY, created_at TIMESTAMP,
9 updated_at TIMESTAMP, link TEXT, senderId TEXT, sendermsg TEXT, senderName TEXT,
10 receiverId TEXT);
11 CREATE TABLE IF NOT EXISTS users(id SERIAL PRIMARY KEY, name TEXT, link TEXT, email TEXT);`;