AdvertSchedule

new_gist_file

-- Table: advertschedule

-- DROP TABLE advertschedule;

CREATE TABLE advertschedule
(
  id bigint NOT NULL,
  advertid character varying(50),
  checkablefromday character varying(14),
  lifecyclecategory character varying(200),
  website character varying(200),
  CONSTRAINT advertschedule_pkey PRIMARY KEY (id),
  CONSTRAINT advertschedule_advertid_key UNIQUE (advertid)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE advertschedule OWNER TO postgres;

-- Index: advertschedule_advertidindex

-- DROP INDEX advertschedule_advertidindex;

CREATE INDEX advertschedule_advertidindex
  ON advertschedule
  USING btree
  (advertid);

-- Index: advertschedule_checkablefromdayindex

-- DROP INDEX advertschedule_checkablefromdayindex;

CREATE INDEX advertschedule_checkablefromdayindex
  ON advertschedule
  USING btree
  (checkablefromday);

-- Index: advertschedule_lifecatcheckableindex

-- DROP INDEX advertschedule_lifecatcheckableindex;

CREATE INDEX advertschedule_lifecatcheckableindex
  ON advertschedule
  USING btree
  (lifecyclecategory, checkablefromday);

-- Index: advertschedule_website

-- DROP INDEX advertschedule_website;

CREATE INDEX advertschedule_website
  ON advertschedule
  USING btree
  (website);

-- Index: advertschedule_websitelifecatcheckableindex

-- DROP INDEX advertschedule_websitelifecatcheckableindex;

CREATE INDEX advertschedule_websitelifecatcheckableindex
  ON advertschedule
  USING btree
  (website, lifecyclecategory, checkablefromday);