mirror of
https://github.com/nowcommunity/nowdatabase.git
synced 2026-10-12 19:13:52 +03:00
17 lines
621 B
SQL
Executable File
17 lines
621 B
SQL
Executable File
|
|
DROP DATABASE IF EXISTS now_test; CREATE DATABASE now_test CHARACTER SET latin1;
|
|
DROP DATABASE IF EXISTS now_log_test; CREATE DATABASE now_log_test CHARACTER SET latin1;
|
|
SET names 'latin1';
|
|
|
|
USE now_test
|
|
SOURCE /docker-entrypoint-initdb.d/sqlfiles/now_test.sql
|
|
USE now_log_test
|
|
SOURCE /docker-entrypoint-initdb.d/sqlfiles/now_log_test.sql
|
|
USE now_test
|
|
SOURCE /docker-entrypoint-initdb.d/sqlfiles/now_view.sql
|
|
|
|
CREATE USER 'now_test'@'localhost' IDENTIFIED BY 'mariadb_password';
|
|
GRANT SELECT, INSERT, UPDATE ON `now_log_test`.* TO 'now_test'@'%';
|
|
GRANT SELECT, INSERT, UPDATE, DELETE ON `now_test`.* TO 'now_test'@'%';
|
|
|