create.sql

application/octet-stream

Download

drop schema if exists   "test"
        cascade;
create schema           "test";

create table            "test"."table1" (
                                "id"                    int     not null,
                                primary key ("id")
                        );
create table            "test"."table2" (
                                "table1_id"             int     not null,
                                "value"                 text    not null,
                                primary key ("table1_id")
                        );
alter table             "test"."table2"
        add             foreign key             ("table1_id")
                                references      "test"."table1" ("id");
create index		"testindex"
	on		"test"."table2" ("value");