[infobot.git] / setup / sqlite2 / news.sql

CREATE TABLE news (
 channel VARCHAR(30) NOT NULL,
 id INT UNSIGNED DEFAULT '0',
 key VARCHAR(16) NOT NULL,
 value TEXT NOT NULL, # limit to ~450 or so.
 PRIMARY KEY (channel,id,key)
);