Releases

First Release

• Run the studbox.sql in order to create the database
• Run the tables_all.sql in order to create the tables
• Run the sp_all.sql in order to create the stored procedures
• Run the static_data_all.sql in order to insert the default settings (roles, users, object types, etc)
• Run hierarchically the static scripts for universities

Phase 2.1

• Run static_data_2_1_unbind_course_from_year.sql
• !!! Eliminate OR rename duplicated courses (having this unique key: profileId, name) !!! ** Use this script to identify the duplicates : select c1.ObjectId, c1.ProfileId, c1.Name, c2.ObjectId, c2.ProfileId, c2.Name from Course c1 inner join Course c2 on c1.ProfileId = c2.ProfileId and c1.Name = c2.Name where c1.ObjectId != c2.ObjectId and c1.ObjectId < c2.ObjectId;
• Run static_data_2_1_course_unique_key.sql
• Run static_data_2_1_remove_year.sql