testdata/e2e/fixtures/sqlite3/down/9.sql - main - githubmirror/fizz

testdata/e2e/fixtures/sqlite3/down/9.sql

18 строк694 B

Yonghwan SO

moved e2e test suite into testdata so it does not affect the dependency

09 июл 2022, 15:32

09 июл 2022, 15:3258e9dd4

CREATE TABLE IF NOT EXISTS "schema_migration" (
"version" TEXT NOT NULL
);
CREATE UNIQUE INDEX "schema_migration_version_idx" ON "schema_migration" (version);
CREATE TABLE IF NOT EXISTS "e2e_users" (
"id" TEXT PRIMARY KEY,
"created_at" DATETIME NOT NULL,
"updated_at" DATETIME NOT NULL
, "name" TEXT);
CREATE TABLE IF NOT EXISTS "e2e_user_posts" (
"id" TEXT PRIMARY KEY,
"user_id" char(36) NOT NULL,
"slug" TEXT NOT NULL,
"content" TEXT NOT NULL DEFAULT '',
FOREIGN KEY (user_id) REFERENCES e2e_users (id) ON UPDATE NO ACTION ON DELETE CASCADE
);
CREATE UNIQUE INDEX "e2e_user_notes_slug_idx" ON "e2e_user_posts" (slug);
CREATE INDEX "e2e_user_notes_user_id_idx" ON "e2e_user_posts" (user_id);