Final DB modifications

[jamoore]

If we have time to perform further DB changes, the following would simplify much of the OriginalFile? and binary logic put in place for FS:

Mimetype

• register() should check for mimetypes
• originalfile super class so there's no mimetype??
• OriginalFile? extends BaseFile? to remove sha1, mimetype, etc.: Dropping several of the OriginalFile? fields would significantly simplify synchronization between the FS and the DB.
• Move DIRECTORY_MIMETYPE to constants.
• Mimetypes (including "Directory") should be compared to standards: There are various mimetypes relating to directories. Perhaps we could either use of those, or use an "application/vnn.openmicroscopy.dir" style

filesets

• add javaVersion to FilesetVersionInfo?. (And Python?) (see ​888)
• Review all the version info set by python/Java/C++
• where to put tags during upload
• check for other definitions of "Reader" (with formatString.replaceAll)
• include FileInfo (e.g. companion=true, series=2 in filesetEntry (See #10979)

Misc

• PixelsType?.MIN|MAX in database

[mtbcarroll]

Things like repositories and directories and whatnot should perhaps each have separate classes in the hierarchy.

[jburel]

Moved from sprint FS demo 4.2

[mtbcarroll]

The java version information could be stored in a hstore column; will that need extra code in Property.java and a new ParameterizedType implementation used by PostgresSqlAction?

[jamoore]

Pushing.

[mtbcarroll]

If we use a late enough JDBC driver: ​http://postgresql.1045698.n5.nabble.com/Patch-Add-support-for-hstore-extension-and-map-it-to-from-java-util-Map-td5699633.html

[mtbcarroll]

also note #7069

[mtbcarroll]

Is there any further work for beta2 here that must be accounted for by #11516?

[jamoore]

Some of these it would certainly be good to address for 5.0.0, but whether or not we get that done for beta2 is unclear.

[jamoore]

Moving to beta2 for evaluation.