/
githubmirror
/
fizz
Обзор
Документация
Войти
/
githubmirror
/
fizz
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
testdata/e2e/fixtures/cockroach/down/5.sql
42 строки
1 KB
Yonghwan SO
updated local test script and fixtures for cockroach based on v21.1
09 сен 2022, 20:45
09 сен 2022, 20:45
c681bf3
Код
Авторство
О чём код?
-- # 1 column -- # row 1 -- ## 269 CREATE TABLE public.schema_migration ( version VARCHAR(14) NOT NULL, rowid INT8 NOT VISIBLE NOT NULL DEFAULT unique_rowid(), CONSTRAINT "primary" PRIMARY KEY (rowid ASC), UNIQUE INDEX schema_migration_version_idx (version ASC), FAMILY "primary" (version, rowid) ); -- # row 2 -- ## 247 CREATE TABLE public.e2e_users ( id UUID NOT NULL, created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL, username VARCHAR(255) NULL, CONSTRAINT "primary" PRIMARY KEY (id ASC), FAMILY "primary" (id, created_at, updated_at, username) ); -- # row 3 -- ## 324 CREATE TABLE public.e2e_user_notes ( id UUID NOT NULL, user_id UUID NOT NULL, slug VARCHAR(64) NOT NULL, notes VARCHAR(255) NULL, CONSTRAINT "primary" PRIMARY KEY (id ASC), INDEX e2e_user_notes_user_id_idx (user_id ASC), UNIQUE INDEX e2e_user_notes_slug_idx (slug ASC), FAMILY "primary" (id, user_id, slug, notes) ); -- # row 4 -- ## 152 ALTER TABLE public.e2e_user_notes ADD CONSTRAINT e2e_user_notes_e2e_users_id_fk FOREIGN KEY (user_id) REFERENCES public.e2e_users(id) ON DELETE CASCADE; -- # row 5 -- ## 115 -- Validate foreign key constraints. These can fail if there was unvalidated data during the SHOW CREATE ALL TABLES -- # row 6 -- ## 85 ALTER TABLE public.e2e_user_notes VALIDATE CONSTRAINT e2e_user_notes_e2e_users_id_fk; -- # 6 rows