SqueakDBX - database scripts
Last updated at 10:04 pm UTC on 16 March 2009
PostgreSQL
--Login as administrator. Default is: sudo -u postgres psql
CREATE DATABASE sodbxtest;
CREATE USER sodbxtest;
ALTER USER sodbxtest PASSWORD 'sodbxtest';
GRANT ALL PRIVILEGES ON DATABASE sodbxtest to sodbxtest;
MySQL
--Log in as administrator: example.: mysql -u username -p
CREATE DATABASE sodbxtest;
CREATE USER sodbxtest IDENTIFIED BY 'sodbxtest';
GRANT ALL ON *.* TO sodbxtest;
--Sing out and then sing in with user sodbxtest: mysql -u sodbxtest -p
--Change to the recently created database
USE sodbxtest;
Oracle
--we are using oracle-xe, so we will work on XE database because its does not permit create another DATABASE.
--Login as administrator
sqlplus sys as sysdba;
--create user
CREATE USER sodbxtest IDENTIFIED BY sodbxtest;
GRANT ALL PRIVILEGES TO sodbxtest;
Sqlite3
For Sqlite you only have to create a database from commandline. You could do something like this:
$ sqlite3 sodbxtest.db
Remember to change sqliteFacility class method in DBXXBackendFacility