Extend CREATE/DROP for additional types

In Drizzle we have user defined barriers and locks. Currently we use SELECT derived functions to create these objects. This is problematic because the need for adding new options to these, and additional objects, leads to a problem where we will need to add an infinite number of parameters to the functions.

Ideally we could instead use CREATE|DROP to handle this.

As an example:

CREATE [TEMPORARY] [GLOBAL|USER] LOCK foo DEFAULT TIMEOUT [num] ....

CREATE [TEMPORARY] [GLOBAL|USER] LOCK foo DEFAULT TIMEOUT [num] LIMIT WAITERS [num] LIMIT OBSERVERS [NUM] ...