CREATE SEQUENCE "presences_id_seq";
CREATE TABLE "presences" (
	"id" integer DEFAULT nextval('presences_id_seq') NOT NULL,
	"jid" varchar(128) NOT NULL,
	"resource" varchar(128) NOT NULL,
	"type" varchar(16) DEFAULT 'unavailable' NOT NULL,
	"status" varchar(256) DEFAULT '' NOT NULL,
	"priority" integer DEFAULT 0 NOT NULL,
	"show" varchar(16) DEFAULT '' NOT NULL,
	"music_title" varchar(256),
	"music_state" varchar(16),
	Constraint "presences_pkey" Primary Key ("id")
);
CREATE  INDEX "presences_jid_index" on "presences" using btree ( "jid" "varchar_ops" );
CREATE  INDEX "presences_resource_index" on "presences" using btree ( "resource" "varchar_ops" );