You are viewing an old version of this page. View the current version. Compare with Current · View Page History
The current db schema can be created as follows:
- 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 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.