/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/join_left/mysql/schema.sql
55 строк
2 KB
Kyle Gray
build: Run MySQL and PostgreSQL locally on the runner (#3095)
04 янв 2024, 00:48
Не верифицирован
04 янв 2024, 00:48
874bfc2
Код
Авторство
О чём код?
-- 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 INT PRIMARY KEY, user_nickname VARCHAR(30) UNIQUE NOT NULL, user_email VARCHAR(20) UNIQUE NOT NULL, user_display_name TEXT NOT NULL, user_password TEXT NULL, user_google_id VARCHAR(20) UNIQUE NULL, user_apple_id VARCHAR(20) UNIQUE NULL, user_bio VARCHAR(160) NOT NULL DEFAULT '', user_created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, user_avatar_id INT UNIQUE NULL ); CREATE TABLE media ( media_id INT PRIMARY KEY, media_created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, media_hash TEXT NOT NULL, media_directory TEXT NOT NULL, media_author_id INT 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;