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	dpavlin	25	################################################################
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');