Contents

\connect postgres

drop database if exists fox;
create database fox;

\connect fox

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

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

create table users (
  id integer not null generated by default as identity primary key,
  username varchar not null,
  user_role_kind varchar not null references user_roles(name),
  user_group varchar not null references user_groups(name)
);

create table emails (
  id integer not null generated by default as identity primary key,
  user_id integer not null references users(id),
  email varchar not null
);

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
fixture_fox-0.2.12	examples/kind.sql
fixture_fox-0.2.11	examples/kind.sql
fixture_fox-0.2.10	examples/kind.sql
fixture_fox-0.2.9	examples/kind.sql
fixture_fox-0.2.8	examples/kind.sql
fixture_fox-0.2.7	examples/kind.sql
fixture_fox-0.2.6	examples/kind.sql
fixture_fox-0.2.5	examples/kind.sql
fixture_fox-0.2.4	examples/kind.sql
fixture_fox-0.2.3	examples/kind.sql
fixture_fox-0.2.2	examples/kind.sql
fixture_fox-0.2.1	examples/kind.sql
fixture_fox-0.2.0	examples/kind.sql
fixture_fox-0.1.3	examples/kind.sql
fixture_fox-0.1.2	examples/kind.sql
fixture_fox-0.1.1	examples/kind.sql