-
Notifications
You must be signed in to change notification settings - Fork 0
/
setup.txt
19 lines (17 loc) · 823 Bytes
/
setup.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
MySQL
=====
create database iiridayn.info
create user 'iiridayn.info'@'localhost' IDENTIFIED BY '<password>'; # random.org string generator for password
grant all on `iiridayn.info`.* to 'iiridayn.info'@'localhost';
create table games (id int unsigned primary key auto_increment, name tinytext not null, system enum('steam', 'gog', 'humble') not null, status enum('defeated', 'cleared'), gametime float, url tinytext not null default '');
alter table games add column steam_id int unsigned unique;
alter table games add column gog_id int unsigned unique;
alter table games add column notes text not null;
HTTPD
=====
put password (created above) into SetEnv ... environment.conf
include .../environment.conf
OTHER SETUP
===========
create www/cache w/permissions 0777
create var w/permissions 0777, var/wishlist.txt 0777