From 96e2ce2e9d363a6296f9411ecb00168520258874 Mon Sep 17 00:00:00 2001 From: Alexander NeonXP Kiryukhin Date: Mon, 29 Jul 2024 02:47:35 +0300 Subject: Отказ от echo MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- migrations/1_schema.down.sql | 2 -- migrations/1_schema.up.sql | 27 --------------------------- migrations/fs.go | 6 ------ 3 files changed, 35 deletions(-) delete mode 100644 migrations/1_schema.down.sql delete mode 100644 migrations/1_schema.up.sql delete mode 100644 migrations/fs.go (limited to 'migrations') diff --git a/migrations/1_schema.down.sql b/migrations/1_schema.down.sql deleted file mode 100644 index c0a3f9d..0000000 --- a/migrations/1_schema.down.sql +++ /dev/null @@ -1,2 +0,0 @@ -DROP TABLE "nodes"; --- DROP TABLE "users"; diff --git a/migrations/1_schema.up.sql b/migrations/1_schema.up.sql deleted file mode 100644 index 2f8bc04..0000000 --- a/migrations/1_schema.up.sql +++ /dev/null @@ -1,27 +0,0 @@ -CREATE TABLE IF NOT EXISTS "users" ( - "id" INTEGER, - "email" TEXT NOT NULL, - "password" TEXT NOT NULL, - "username" TEXT NOT NULL, - "photo" TEXT, - "role" INTEGER DEFAULT(0), - PRIMARY KEY ("id" AUTOINCREMENT), - UNIQUE ("email" COLLATE NOCASE), - UNIQUE ("username" COLLATE NOCASE) -); - -CREATE TABLE IF NOT EXISTS "nodes" ( - "id" INTEGER, - "type" INTEGER, - "text" TEXT, - "author_id" INTEGER NOT NULL, - "parent_id" INTEGER, - "created_at" INTEGER NOT NULL, - "updated_at" INTEGER NOT NULL, - "deleted_at" INTEGER, - "permission" INTEGER, - PRIMARY KEY ("id" AUTOINCREMENT), - FOREIGN KEY ("author_id") REFERENCES "users" ("id"), - FOREIGN KEY ("parent_id") REFERENCES "posts" ("id") -); - diff --git a/migrations/fs.go b/migrations/fs.go deleted file mode 100644 index 91cca1c..0000000 --- a/migrations/fs.go +++ /dev/null @@ -1,6 +0,0 @@ -package migrations - -import "embed" - -//go:embed *.sql -var FS embed.FS -- cgit v1.2.3