Top Level Namespace

Defined in:

Constant Summary

CHECK_MIGRATIONS_TABLE_EXISTS_QUERY = " SELECT EXISTS (\n SELECT FROM\n pg_catalog.pg_tables\n WHERE\n schemaname != 'pg_catalog' AND\n schemaname != 'information_schema' AND\n tablename = 'migrations'\n );"

CREATE_MIGRATIONS_QUERY = " CREATE TABLE migrations (\n date BIGINT NOT NULL\n );"

MIGRATIONS = {20240104152651_i64 => " CREATE TABLE users (\n id SERIAL PRIMARY KEY,\n secret TEXT\n );", 20240104152652_i64 => " CREATE TABLE stories (\n id SERIAL PRIMARY KEY,\n score INT NOT NULL DEFAULT 0,\n title TEXT NOT NULL,\n url TEXT NOT NULL,\n external_id TEXT NOT NULL,\n favorited_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n user_id INT REFERENCES users(id)\n );", 20240104152653_i64 => " CREATE TABLE sources (\n id SERIAL PRIMARY KEY,\n name TEXT NOT NULL,\n url TEXT NOT NULL,\n user_id INT REFERENCES users(id)\n )", 20240104152654_i64 => " ALTER TABLE stories\n ADD COLUMN source_id INT;"}