databas.sql / Change design in DB

[Sophie]

Due to changes in the design of how the database should be used in the implementation, changes need to be done.

Tables have been added and deleted.

There are no longer a table called 'ContainerFiles', because an attribute needed to be added due to match implementation. The attribute 'executable' will be added as an attribute in the 'Containers'-table as an Boolean, and the foreign key 'fileName' will still come from the table 'Files' into the table 'Categories'.

The table 'FileInterestingLines' will get it's foreign keys from 'Files' (fileName) and 'Containers' (columnNr, orderNr, exampleName,subCategoryName, categoryName, courseID).

The table 'SubCategories' had been added due to implementation and design of the CMS and Codeviewer.
SubCategories will have the attributes 'subCategoryName' (primary key), 'orderNr', and foreign keys from 'Categories' (categoryName, courseID).
'SubCategories' will be used as a sub category in the menu for the examples and the quizzes.

The attribute 'passwdHint' should be added in the table 'Users', right below the attribute 'passwd'.

The attribute 'fileType' should change its data type to ENUM instead of VARCHAR, and should be implemented as 'text', 'code', 'video', 'picture'.
Same thing (change to ENUM) in the attribute 'userType' with the implementation 'student', 'teacher'.

[Sophie (a09sopka)]

add timeStamp-attributes in the tables 'Files', 'Examples' and 'Quizzes'.

name: 'updatedAt'