All pastes #177730 Raw Edit

Something

public text v1 · immutable
#177730 ·published 2006-09-20 17:03 UTC
rendered paste body
CREATE TABLE stats (
        nick VARCHAR(20) NOT NULL,
        type VARCHAR(8) NOT NULL,
        channel VARCHAR(16) NOT NULL DEFAULT "PRIVATE",

        time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
        counter SMALLINT UNSIGNED DEFAULT '0',

        PRIMARY KEY (nick,type,channel)
);