1 CREATE TABLE connections (
2 server character varying(30) NOT NULL,
3 port integer DEFAULT 6667 NOT NULL,
4 nick character varying(20) NOT NULL,
5 nickservpass character varying(8) NOT NULL,
6 ircname character varying(20) DEFAULT 'blootbot IRC bot'::character varying NOT NULL,
7 timeadded numeric DEFAULT 0
10 REVOKE ALL ON TABLE connections FROM PUBLIC;
12 ALTER TABLE ONLY connections
13 ADD CONSTRAINT connections_pkey PRIMARY KEY (server, port, nick);