/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/join_left/postgresql/schema.sql
53 строки
2 KB
Kyle Gray
test(endtoend): Split shema and queries (#2803)
04 окт 2023, 19:13
Не верифицирован
04 окт 2023, 19:13
5664224
Код
Авторство
О чём код?
--- https://github.com/sqlc-dev/sqlc/issues/604 CREATE TABLE users ( user_id INT PRIMARY KEY, city_id INT -- nullable ); CREATE TABLE cities ( city_id INT PRIMARY KEY, mayor_id INT NOT NULL ); CREATE TABLE mayors ( mayor_id INT PRIMARY KEY, full_name TEXT NOT NULL ); -- https://github.com/sqlc-dev/sqlc/issues/1334 CREATE TABLE authors ( id INT PRIMARY KEY, name TEXT NOT NULL, parent_id INT -- nullable ); CREATE TABLE super_authors ( super_id INT PRIMARY KEY, super_name TEXT NOT NULL, super_parent_id INT -- nullable ); -- https://github.com/sqlc-dev/sqlc/issues/1334 CREATE TABLE "users_2" ( "user_id" uuid PRIMARY KEY, "user_nickname" VARCHAR(30) UNIQUE NOT NULL, "user_email" TEXT UNIQUE NOT NULL, "user_display_name" TEXT NOT NULL, "user_password" TEXT NULL, "user_google_id" TEXT UNIQUE NULL, "user_apple_id" TEXT UNIQUE NULL, "user_bio" VARCHAR(160) NOT NULL DEFAULT '', "user_created_at" TIMESTAMP NOT NULL DEFAULT (NOW()), "user_avatar_id" uuid UNIQUE NULL ); CREATE TABLE "media" ( "media_id" uuid PRIMARY KEY, "media_created_at" TIMESTAMP NOT NULL DEFAULT (NOW()), "media_hash" TEXT NOT NULL, "media_directory" TEXT NOT NULL, "media_author_id" uuid NOT NULL, "media_width" INT NOT NULL, "media_height" INT NOT NULL ); ALTER TABLE "users_2" ADD FOREIGN KEY ("user_avatar_id") REFERENCES "media" ("media_id") ON DELETE SET DEFAULT ON UPDATE CASCADE;