image-pool-service/structure.sql

CREATE TABLE "image_pool"."url_hash" (
     "url" varchar(512) COLLATE "pg_catalog"."default" NOT NULL,
     "md5" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
     "hash" char(16) COLLATE "pg_catalog"."default" NOT NULL,
     "vector" float4[] NOT NULL,
     "created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     CONSTRAINT "url_hash_pkey" PRIMARY KEY ("url")
)
;

ALTER TABLE "image_pool"."url_hash"
    OWNER TO "galaxy_new.image_pool.developer";