CREATE TABLE "public"."test" (
    "name" text COLLATE "default" NOT NULL,
    "parent_id" int4,
    "id" SERIAL PRIMARY KEY
)
WITH (OIDS=FALSE);
ALTER TABLE "public"."test" OWNER TO "postgres";

CREATE INDEX "test_name" ON "public"."test" USING btree ("name");
CREATE UNIQUE INDEX "test_name1" ON "public"."test" USING btree ("name", "parent_id") WHERE parent_id IS NOT NULL;
CREATE UNIQUE INDEX "test_name2" ON "public"."test" USING btree ("name", "parent_id") WHERE parent_id IS NULL;

INSERT INTO test (name) VALUES ('test');
INSERT INTO test (name) VALUES ('test');