Files
project-fileshare/apps/backend/prisma/add-allowed-companies.js

21 lines
690 B
JavaScript
Raw Permalink Normal View History

2026-10-29 13:21:30 +06:00
require('dotenv').config({ path: __dirname + '/../.env' });
const { PrismaClient } = require('@prisma/client');
const prisma = new PrismaClient();
async function main() {
try {
await prisma.$executeRawUnsafe('ALTER TABLE `User` ADD COLUMN `allowedCompanies` TEXT NULL AFTER `companyName`;');
console.log('✓ Successfully added allowedCompanies column to User table');
} catch (err) {
if (err.message && err.message.includes('Duplicate column name')) {
console.log('✓ Column allowedCompanies already exists');
} else {
console.error('Error adding column:', err.message);
}
}
}
main()
.catch(console.error)
.finally(() => prisma.$disconnect());