\connect - postgres 
CREATE TABLE "triples" (
        "subject" INT4,
        "predicate" INT4,
        "object" INT4,
        "assertid" character varying,
        "personid" character varying,
        "isresource" bool);
 
CREATE TABLE "resources" (
        "keyhash" INT4 UNIQUE,  
        "value" character varying); 

CREATE INDEX "sub_index" on triples(subject);
CREATE INDEX "pred_index" on triples(predicate);
CREATE INDEX "obj_index" on triples(object);
CREATE INDEX "res_keyhash_index" on resources(keyhash);
CREATE INDEX "res_val_index" on resources(value);


# useage: psql test < inklingsqlschema.psql   
# (test is db name)