gistfile1.sql

-- Table: pages

-- DROP TABLE pages;

CREATE TABLE pages
(
  id serial NOT NULL,
  title character varying(255),
  link character varying(255),
  summary text,
  book_id integer,
  created_at timestamp without time zone NOT NULL,
  updated_at timestamp without time zone NOT NULL,
  CONSTRAINT pages_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE pages
  OWNER TO dogears;

-- Index: index_pages_on_book_id

-- DROP INDEX index_pages_on_book_id;

CREATE INDEX index_pages_on_book_id
  ON pages
  USING btree
  (book_id);