File: patch-page_props.sql

package info (click to toggle)
mediawiki 1%3A1.19.20%2Bdfsg-0%2Bdeb7u3
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 75,652 kB
  • sloc: php: 844,154; pascal: 6,026; sql: 5,936; perl: 769; python: 745; makefile: 413; sh: 194; xml: 91; ansic: 77
file content (9 lines) | stat: -rw-r--r-- 326 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
 

CREATE TABLE page_props (
  pp_page      INTEGER  NOT NULL  REFERENCES page (page_id) ON DELETE CASCADE,
  pp_propname  TEXT     NOT NULL,
  pp_value     TEXT     NOT NULL
);
ALTER TABLE page_props ADD CONSTRAINT page_props_pk PRIMARY KEY (pp_page,pp_propname);
CREATE INDEX page_props_propname ON page_props (pp_propname);