CREATE TABLE "triples" (
	"subject" integer,
	"predicate" integer,
	"object" integer,
	"assertid" character varying,
	"personid" character varying,
	"isresource" boolean
);


CREATE TABLE "resources" (
	"key" integer,
	"value" character varying
);

CREATE INDEX sub_index ON triples USING btree (subject);

CREATE INDEX pred_index ON triples USING btree (predicate);

CREATE INDEX obj_index ON triples USING btree (object);

CREATE UNIQUE INDEX resources_key_key ON resources USING btree ("key");

CREATE INDEX res_key_index ON resources USING btree ("key");

CREATE INDEX res_val_index ON resources USING btree (value);