27 lines
713 B
PL/PgSQL
27 lines
713 B
PL/PgSQL
CREATE SCHEMA IF NOT EXISTS app;
|
|
|
|
CREATE OR REPLACE FUNCTION app.update_lastupdated_timestamp()
|
|
RETURNS TRIGGER AS $$
|
|
BEGIN
|
|
NEW.last_updated_at = now();
|
|
RETURN NEW;
|
|
END;
|
|
$$ LANGUAGE plpgsql;
|
|
|
|
CREATE TABLE app.user (
|
|
user_id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
email VARCHAR NOT NULL,
|
|
name VARCHAR NOT NULL,
|
|
email_verified_at TIMESTAMP,
|
|
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
last_updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
CREATE TABLE app.user_auth (
|
|
user_id UUID PRIMARY KEY REFERENCES app.user(user_id),
|
|
access_token VARCHAR NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
last_updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|