Contents

\connect postgres

drop database if exists fox;
create database fox;

\connect fox

create schema user_schema;
create schema role_schema;

create table role_schema.roles (
  id integer generated by default as identity primary key,
  name text not null
);

create table user_schema.users (
  id integer generated by default as identity primary key,
  name text not null
);

create table public.user_roles (
  id integer generated by default as identity primary key,
  role_id integer not null references role_schema.roles(id),
  user_id integer not null references user_schema.users(id)
);

create table public.posts (
  id integer generated by default as identity primary key,
  user_id integer not null references user_schema.users(id),
  title text not null
);

Version data entries

32 entries across 16 versions & 1 rubygems

Version	Path
fixture_fox-0.2.2	examples/empty.sql
fixture_fox-0.2.2	examples/schema.sql
fixture_fox-0.2.1	examples/schema.sql
fixture_fox-0.2.1	examples/empty.sql
fixture_fox-0.2.0	examples/empty.sql
fixture_fox-0.2.0	examples/schema.sql
fixture_fox-0.1.3	examples/empty.sql
fixture_fox-0.1.3	examples/schema.sql
fixture_fox-0.1.2	examples/schema.sql
fixture_fox-0.1.2	examples/empty.sql
fixture_fox-0.1.1	examples/schema.sql
fixture_fox-0.1.1	examples/empty.sql