Contents

\connect postgres

drop database if exists pg_graph;
create database pg_graph;

\connect pg_graph

create table picture_kinds (
  id integer generated by default as identity primary key,
  kind varchar not null unique
);

create table pictures (
  id integer generated by default as identity primary key,
  title text not null,
  kind varchar not null references picture_kinds(kind)
);

Version data entries

25 entries across 25 versions & 1 rubygems

Version	Path
pg_graph-0.5.2	snippets/kind.sql
pg_graph-0.5.1	snippets/kind.sql
pg_graph-0.5.0	snippets/kind.sql
pg_graph-0.4.2	snippets/kind.sql
pg_graph-0.4.1	snippets/kind.sql
pg_graph-0.4.0	snippets/kind.sql
pg_graph-0.3.6	snippets/kind.sql
pg_graph-0.3.5	snippets/kind.sql
pg_graph-0.3.4	snippets/kind.sql
pg_graph-0.3.3	snippets/kind.sql
pg_graph-0.3.2	snippets/kind.sql
pg_graph-0.3.1	snippets/kind.sql
pg_graph-0.3.0	snippets/kind.sql
pg_graph-0.2.1	snippets/kind.sql
pg_graph-0.2.0	snippets/kind.sql
pg_graph-0.1.9	snippets/kind.sql
pg_graph-0.1.8	snippets/kind.sql
pg_graph-0.1.7	snippets/kind.sql
pg_graph-0.1.6	snippets/kind.sql
pg_graph-0.1.5	snippets/kind.sql