create a database called berkano (use another name if you want, you'll have to update your jndi configuration accordingly)

create a user for berkano and give it the right permissions.
On mysql, this can be done with the following script:

create database berkano;
grant all privileges on berkano.* to 'berkano'@'localhost' identified by 'some-password';

create the schema itself, using the following script: This is a generated script, which is why some of the columns are oddly ordered and the constraints have human-unfriendly names. I'm not sure I want to maintain a clean script, although now that might become an option since the model has been stabilizing. This will work with the Hibernate implementation of Berkano-User. It could probably work for and with other implementations, too, but since we have none for the moment, we can't really say.