change data type: fileType in Files (DB)
Bug #1171788 reported by
Sophie
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
lp:~b11johgu/lenasys/database_changes
- Gustav Hartvigsson: Pending requested
- Diff: 0 lines
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.