CREATE TABLE folksonomy (
  id integer NOT NULL default 0,
  realm varchar(100) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  weight integer NOT NULL default 0,
  PRIMARY KEY (id,realm,name)
)