summaryrefslogtreecommitdiffstats
path: root/runtime/extra/sql/bulkload/create-db.sql
blob: 5fa34ca04958c11a617185c1e4c8a79f057fbd72 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
#
# Create CLDS database objects (tables, etc.)
#
#
CREATE DATABASE `cldsdb4`;
USE `cldsdb4`;
DROP USER 'clds';
CREATE USER 'clds';
GRANT ALL on cldsdb4.* to 'clds' identified by 'sidnnd83K' with GRANT OPTION;
CREATE DATABASE `controlloop`;
USE `controlloop`;
DROP USER 'policy';
CREATE USER 'policy';
GRANT ALL on controlloop.* to 'policy' identified by 'P01icY' with GRANT OPTION;
FLUSH PRIVILEGES;