VideoHosting database

Coursework for university - I implemented a database similar to YouTube.

Tables scheme

QUICK START

1. If you use windows

git config --global core.autocrlf false

2. Git clone this project

git clone https://github.com/BaggerFast/VideoHostingDatabase.git

3. Set hard password to user SA into docker-compose.yml

MSSQL_SA_PASSWORD=""

4. Connect to database via docker-compose

docker compose up

5. Scripts structure
   • STRUCTURE.sql - Create table
   • TRIGGERS.sql - Create triggers for table
   • INSERT.sql - Insert data into table
   • SELECT.sql - Select table
   • TRUNCATE.sql - Clear table
   • DROP.sql - Delete table
6. Use scripts in this order
   • TAGS
   • ACCESS_LEVELS
   • AGE_RESTRICTIONS
   • USERS
   • VIDEOS
   • FK_VIDEO_TAGS
   • VIEW
   • COMMENTS
   • SUBSCRIPTIONS
   • REACTIONS
   • PLAYLISTS
   • FK_VIDEO_PLAYLISTS
   • FUNCTIONS
   • PROCEDURES