------------------------------------------
------------- CREATE TABLE --------------
------------------------------------------

CREATE TABLE template_resources
(
  id serial NOT NULL,
  template_id integer NOT NULL,
  image character varying,
  language character varying,
  resolution character varying,
  CONSTRAINT template_resources_pkey PRIMARY KEY (id),
  CONSTRAINT template_id_fkey FOREIGN KEY (template_id)
      REFERENCES templates (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE template_resources
  OWNER TO postgres;
