Database structure
This is the layout of the files table. We need some extra fields if we want to allow remote files. Also, we need to track if files can be put inline, and if they should show up.
| fid | obid | vid | filename | filepath | filemime | show | inline | filesize | details |
|---|---|---|---|---|---|---|---|---|---|
| 20 | 450 | 50 | foo.png | http://www.picsite.com/files/foo.png | image/png | 1 | 0 | 20000 | s{height:100;width;150} |
| 21 | 450 | 51 | bar.jpg | file://images/bar.jpg | image/jpg | 0 | 1 | 20000 | s{height:100;width;150} |