admin/install/create.sql

################################################################
# WARNING - DO NOT run this script against a production system #
# with LibData currently installed.                            #
################################################################

# Create libdata
CREATE DATABASE libdata;

# Create libstats
CREATE DATABASE libstats;

# Create libsession
CREATE DATABASE libsession;

# Insert users into mysql.user table
INSERT INTO mysql.user VALUES ('%', 'libsession', password('ch4ngeME'), 
 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N','N','N','N','N','N','N');
INSERT INTO mysql.user VALUES ('%', 'libdata', password('changEth1s'), 
 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N','N','N','N','N','N','N');

# Insert database/users from mysql.db table
INSERT INTO mysql.db VALUES ('%', 'libsession', 'libsession', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO mysql.db VALUES ('%', 'libdata', 'libdata', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
1	################################################################
2	# WARNING - DO NOT run this script against a production system #
3	# with LibData currently installed. #
4	################################################################
5
6	# Create libdata
7	CREATE DATABASE libdata;
8
9	# Create libstats
10	CREATE DATABASE libstats;
11
12	# Create libsession
13	CREATE DATABASE libsession;
14
15	# Insert users into mysql.user table
16	INSERT INTO mysql.user VALUES ('%', 'libsession', password('ch4ngeME'),
17	'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N','N','N','N','N','N','N');
18	INSERT INTO mysql.user VALUES ('%', 'libdata', password('changEth1s'),
19	'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N','N','N','N','N','N','N');
20
21	# Insert database/users from mysql.db table
22	INSERT INTO mysql.db VALUES ('%', 'libsession', 'libsession', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N');
23	INSERT INTO mysql.db VALUES ('%', 'libdata', 'libdata', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');