2 nick VARCHAR(20) NOT NULL,
3 "type" VARCHAR(8) NOT NULL,
4 channel VARCHAR(30) DEFAULT 'PRIVATE' NOT NULL,
5 "time" numeric DEFAULT 0 NOT NULL,
6 counter numeric DEFAULT 0
9 REVOKE ALL ON TABLE stats FROM PUBLIC;
11 ALTER TABLE ONLY stats
12 ADD CONSTRAINT stats_pkey PRIMARY KEY (nick, "type", channel);