db: Move migrations to require up/down migrations When generating migrations, up/down migrations are revertable. Thus better. This change moves the oldest migration to have both, and thus sqlx will require everyone to create up/down migrations.
Created by zj on September 7, 2021
EYZMH7NAJNR5BFUSA27Z6RUNAU76PPFDG465SZZQLQF4DPXCMGZQC Dependencies
In channels
main
Change contents
File deletion: 20210813185317_users_table.sql
-- Enable PG crypto helpers we need to store passwordsCREATE EXTENSION pgcrypto;CREATE TABLE users (id SERIAL PRIMARY KEY,name VARCHAR(64) NOT NULL,email TEXT NOT NULL,password TEXT NOT NULL);CREATE UNIQUE INDEX unique_user_name ON users(name);CREATE UNIQUE INDEX unique_user_email ON users(email);File addition: 20210813185317_users_table.up.sql
[3.199]-- Enable PG crypto helpers we need to store passwordsCREATE EXTENSION pgcrypto;CREATE TABLE users (id SERIAL PRIMARY KEY,name VARCHAR(64) NOT NULL,email TEXT NOT NULL,password TEXT NOT NULL);CREATE UNIQUE INDEX unique_user_name ON users(name);CREATE UNIQUE INDEX unique_user_email ON users(email);File addition: 20210813185317_users_table.down.sql
[3.199]DROP EXTENSION IF EXISTS pgcrypto;DROP TABLE users;