1 files changed, 0 insertions, 27 deletions
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")
-);
-