unikent / programmes-plant

A comprehensive solution for the management of university programmes, that produces an XCRI feed.
Other
7 stars 4 forks source link

Fix/enlarge ug pg subjects column #976

Closed samyapp closed 4 years ago

samyapp commented 4 years ago

The ug_subjects and pg_subjects columns in the usersys_users table are used to hold a comma separated list of subjects that a user can edit things for.

They were not long enough to hold all of them.

Now they are longer.

SQLITE (which is used for unit tests) appears not to support modifying columns, so added a check to skip the migration if sqlite is detected.