1 2 3 4 5 6 7 8 9 10
CREATE TABLE carboncopy ( username text NOT NULL, server_host text NOT NULL, resource text NOT NULL, namespace text NOT NULL, node text NOT NULL, PRIMARY KEY (server_host, username, resource) ); CREATE INDEX i_carboncopy_sh_user ON carboncopy (server_host, username);