[Summary view] [Print] [Text view]

   1  
   2  CREATE TABLE page_props (
   3    pp_page      INTEGER  NOT NULL  REFERENCES page (page_id) ON DELETE CASCADE,
   4    pp_propname  TEXT     NOT NULL,
   5    pp_value     TEXT     NOT NULL
   6  );
   7  ALTER TABLE page_props ADD CONSTRAINT page_props_pk PRIMARY KEY (pp_page,pp_propname);
   8  CREATE INDEX page_props_propname ON page_props (pp_propname);
   9