16 

    17 PostgreSQL

    18 ----------

    19 

    20 CREATE ROLE test LOGIN PASSWORD 'test';

    21 

    22 CREATE DATABASE test;

    23 \c test

    24 \i sql/tests.sql

    25 

    26 

    27 MySQL

    28 -----

    29 

    30 CREATE USER 'test'@'%' IDENTIFIED BY 'test';

    31 GRANT all ON test.* TO 'test'@'%';

    32 

    33 CREATE DATABASE test;

    34 USE test;

    35 

    36 CREATE TABLE test

    37 (

    38   id INT NOT NULL AUTO_INCREMENT,

    39   name TEXT,

    40   PRIMARY KEY (id)

    41 )

    42 ENGINE=InnoDB CHARSET=utf8;

    43