diff options
| author | Christian Pointner <equinox@helsinki.at> | 2011-03-31 18:40:46 (GMT) |
|---|---|---|
| committer | Christian Pointner <equinox@helsinki.at> | 2011-03-31 18:40:46 (GMT) |
| commit | fdd96c527de9e5987c1f8592d1751c3bdc31c9c8 (patch) | |
| tree | a33c1692aa21e8435b727fee58dbacab389e141c /rhnop-server/playlog.lua | |
| parent | 8b055af834bb6de93519bbb0bff776ebb7fffe73 (diff) | |
fixed utf-8 @ rddb
switched to bigint for timestamp
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" |