diff options
Diffstat (limited to 'rhnop-server/playlog.lua')
| -rw-r--r-- | rhnop-server/playlog.lua | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/rhnop-server/playlog.lua b/rhnop-server/playlog.lua index 99fc5fe..59e572c 100644 --- a/rhnop-server/playlog.lua +++ b/rhnop-server/playlog.lua @@ -22,9 +22,10 @@ require "luasql.mysql" -- CREATE DATABASE rhnop --- GRANT select,insert,update ON rhnop.* TO 'nopsyncd' IDENTIFIED BY '123456'; +-- GRANT select,insert,update ON rhnop.* TO 'nopsyncd' IDENTIFIED BY '<password>'; +-- GRANT select ON rhnop.* TO 'nopcollectd' IDENTIFIED BY '<password>'; -- USE rhnop --- CREATE TABLE IF NOT EXISTS now (timestamp VARCHAR(16) PRIMARY KEY NOT NULL, cart INT NOT NULL, len INT, showtitle VARCHAR(255), title VARCHAR(255), artist VARCHAR(255), album VARCHAR(255), ismusic BOOLEAN); +-- CREATE TABLE IF NOT EXISTS now (timestamp BIGINT UNSIGNED PRIMARY KEY NOT NULL, cart INT NOT NULL, len INT, showtitle VARCHAR(255), title VARCHAR(255), artist VARCHAR(255), album VARCHAR(255), ismusic BOOLEAN); conf = require "conf" |