2 nick VARCHAR(20) NOT NULL,
3 channel VARCHAR(30) NOT NULL,
4 message VARCHAR(255) NOT NULL,
5 modified_by VARCHAR(20) NOT NULL DEFAULT 'nobody',
6 modified_time INT NOT NULL DEFAULT '0',
7 PRIMARY KEY (nick, channel)
11 -- ALTER TABLE onjoin ADD COLUMN modified_by VARCHAR(20) NOT NULL DEFAULT 'nobody';
12 -- ALTER TABLE onjoin ADD COLUMN modified_time INT NOT NULL DEFAULT '0';
13 -- ** the following doesn't work for sqlite **
14 -- ALTER TABLE onjoin ADD PRIMARY KEY (nick, channel);