mirror of
https://github.com/OHV-IT/collabrix.git
synced 2025-12-15 08:38:36 +01:00
93b98cfb5c
- Complete chat application similar to Microsoft Teams - Code snippet library with syntax highlighting - Real-time messaging with WebSockets - File upload with Office integration - Department-based permissions - Dark/Light theme support - Production deployment with SSL/Reverse Proxy - Docker containerization - PostgreSQL database with SQLModel ORM
13 lines
454 B
SQL
13 lines
454 B
SQL
-- Erstelle Abteilung
|
|
INSERT INTO department (name, description, created_at)
|
|
VALUES ('Entwicklung', 'Software Development Team', NOW())
|
|
RETURNING id;
|
|
|
|
-- Erstelle Channel (department_id von oben ersetzen!)
|
|
INSERT INTO channel (name, description, department_id, created_at)
|
|
VALUES ('General', 'Allgemeiner Channel', 1, NOW());
|
|
|
|
-- Füge dich zur Abteilung hinzu (user_id=1 ist Ronny)
|
|
INSERT INTO user_department (user_id, department_id)
|
|
VALUES (1, 1);
|