major re-organisation of the different SQL files; cleanup and fixing of the postgres...

[infobot.git] / setup / news.sql

CREATE TABLE news (
 channel VARCHAR(16) 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)
);