change data type: fileType in Files (DB)

Bug #1171788 reported by Sophie
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
LenaSYS
Fix Committed
Undecided
Johan Gustavsson

Bug Description

change the attribute fileType in the table Files to ENUM('text', 'code', 'video', 'picture'); instead of VARCHAR(5).

also comment behind it that these are the allowed types and which number they represent. (text=1, code=2 etc..)

.. Because then the "text" can be used as a 1, "code" as a 2, and so forth..
This limits the use of fileType to the allowed file types instead of being able to implement anything in VARCHAR.

Related branches

Changed in lenasys:
status: New → Confirmed
Changed in lenasys:
assignee: nobody → Johan Gustavsson (b11johgu)
Changed in lenasys:
status: Confirmed → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.