Menu

Reddit - Please wait for verification
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/Nyrien_nml·2 days ago
#oOyzyzC4
Reading 0:00
15s threshold

Hi! I'm self-taught in programming and have never learned how to handle databases; I'm trying to run a FiveM server from this opensource code: https://github.com/SOZ-Faut-etre-Sub/SOZ-FiveM-Server and followed their explanations to migrate the database, but I'm running into an error from the command: yarn run prisma migrate deploy and can't really figure out why. This is what's in the migration.sql : -- DropForeignKey ALTER TABLE `race_score` DROP FOREIGN KEY `race_score_ibfk_1`; -- DropForeignKey ALTER TABLE `race_score` DROP FOREIGN KEY `race_score_ibfk_2`; -- AlterTable ALTER TABLE `vandalism_props` MODIFY `location` TEXT NOT NULL; -- AlterTable ALTER TABLE `vehicles` MODIFY `maxStock` INTEGER NULL DEFAULT 2; -- CreateTable CREATE TABLE `zone` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `type` ENUM('NoStress') NOT NULL DEFAULT 'NoStress', `zone` LONGTEXT NOT NULL, `name` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; --…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More