From 6e68b72068a9a9d85af28905dd9d269961041a2c Mon Sep 17 00:00:00 2001
From: xAlpharax <42233094+xAlpharax@users.noreply.github.com>
Date: Sun, 10 Dec 2023 11:04:56 +0200
Subject: Final demo for the presentation

Changes to be committed:
    modified:   populate_prisma.js
    renamed:    prisma/migrations/20231210070441_mig1/migration.sql -> prisma/migrations/20231210085505_mig1/migration.sql
---
 .../migrations/20231210070441_mig1/migration.sql   | 80 ----------------------
 1 file changed, 80 deletions(-)
 delete mode 100644 backend/prisma/migrations/20231210070441_mig1/migration.sql

(limited to 'backend/prisma/migrations/20231210070441_mig1')

diff --git a/backend/prisma/migrations/20231210070441_mig1/migration.sql b/backend/prisma/migrations/20231210070441_mig1/migration.sql
deleted file mode 100644
index e9acf84..0000000
--- a/backend/prisma/migrations/20231210070441_mig1/migration.sql
+++ /dev/null
@@ -1,80 +0,0 @@
--- CreateTable
-CREATE TABLE `user` (
-    `id` INTEGER NOT NULL AUTO_INCREMENT,
-    `user_data_id` INTEGER NOT NULL,
-    `email` VARCHAR(191) NOT NULL,
-    `password` VARCHAR(191) NOT NULL,
-    `username` VARCHAR(191) NOT NULL,
-
-    UNIQUE INDEX `user_user_data_id_key`(`user_data_id`),
-    UNIQUE INDEX `user_email_key`(`email`),
-    UNIQUE INDEX `user_username_key`(`username`),
-    PRIMARY KEY (`id`)
-) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
--- CreateTable
-CREATE TABLE `tag` (
-    `id` INTEGER NOT NULL AUTO_INCREMENT,
-    `name` VARCHAR(191) NOT NULL,
-
-    UNIQUE INDEX `tag_name_key`(`name`),
-    PRIMARY KEY (`id`)
-) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
--- CreateTable
-CREATE TABLE `course` (
-    `id` INTEGER NOT NULL AUTO_INCREMENT,
-    `title` VARCHAR(191) NOT NULL,
-    `description` VARCHAR(191) NOT NULL,
-    `author_id` INTEGER NOT NULL,
-    `tags` JSON NOT NULL,
-
-    UNIQUE INDEX `course_title_key`(`title`),
-    UNIQUE INDEX `course_description_key`(`description`),
-    UNIQUE INDEX `course_author_id_key`(`author_id`),
-    PRIMARY KEY (`id`)
-) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
--- CreateTable
-CREATE TABLE `user_data` (
-    `id` INTEGER NOT NULL AUTO_INCREMENT,
-    `total_seconds` INTEGER NOT NULL,
-    `total_articles` INTEGER NOT NULL,
-
-    PRIMARY KEY (`id`)
-) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
--- CreateTable
-CREATE TABLE `course_data` (
-    `id` INTEGER NOT NULL AUTO_INCREMENT,
-    `total_readers` INTEGER NOT NULL,
-    `courseId` INTEGER NULL,
-
-    PRIMARY KEY (`id`)
-) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
--- CreateTable
-CREATE TABLE `course_feedback` (
-    `id` INTEGER NOT NULL AUTO_INCREMENT,
-    `feedback_value` INTEGER NOT NULL,
-    `feedback_text` VARCHAR(191) NOT NULL,
-    `course_id` INTEGER NOT NULL,
-    `author_id` INTEGER NOT NULL,
-
-    PRIMARY KEY (`id`)
-) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
--- AddForeignKey
-ALTER TABLE `user` ADD CONSTRAINT `user_user_data_id_fkey` FOREIGN KEY (`user_data_id`) REFERENCES `user_data`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
-
--- AddForeignKey
-ALTER TABLE `course` ADD CONSTRAINT `course_author_id_fkey` FOREIGN KEY (`author_id`) REFERENCES `user`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
-
--- AddForeignKey
-ALTER TABLE `course_data` ADD CONSTRAINT `course_data_courseId_fkey` FOREIGN KEY (`courseId`) REFERENCES `course`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;
-
--- AddForeignKey
-ALTER TABLE `course_feedback` ADD CONSTRAINT `course_feedback_author_id_fkey` FOREIGN KEY (`author_id`) REFERENCES `user`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
-
--- AddForeignKey
-ALTER TABLE `course_feedback` ADD CONSTRAINT `course_feedback_course_id_fkey` FOREIGN KEY (`course_id`) REFERENCES `course`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
-- 
cgit v1.2.3