search

kvikshaug / grouphugs

A pircbot implementation whose sole purpose is creating fun, happiness and grouped hugs
http://gh.kvikshaug.no/
6 stars 3 forks source link

Changing database to multiuser #11

Closed magnuf closed 13 years ago

magnuf commented 13 years ago

ALTER TABLE timer ADD COLUMN channel TEXT; ALTER TABLE uploads ADD COLUMN channel TEXT; ALTER TABLE words ADD COLUMN channel TEXT; ALTER TABLE seen ADD COLUMN channel TEXT; ALTER TABLE factoid ADD COLUMN channel TEXT; ALTER TABLE karma ADD COLUMN channel TEXT;

magnuf commented 13 years ago

UPDATE timer SET channel="#grouphugs"; UPDATE uploads SET channel="#grouphugs"; UPDATE words SET channel="#grouphugs"; UPDATE seen SET channel="#grouphugs"; UPDATE factoid SET channel="#grouphugs"; UPDATE karma SET channel="#grouphugs";

magnuf commented 13 years ago

ALTER TABLE tracking ADD COLUMN channel TEXT; UPDATE tracking SET channel="#grouphugs";

oyvindio commented 13 years ago

Done.