Squeak
  links to this page:    
View this PageEdit this PageUploads to this PageHistory of this PageTop of the SwikiRecent ChangesSearch the SwikiHelp Guide
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