Remove the SHARED_LIBRARY and STATIC_LIBRARY macros

The macros SHARED_LIBRARY and STATIC_LIBRARY are weird (they do not fit in with naming and placement of other macros), and almost never used. We should just get rid of them.