2 --- SQL command to create the wrreport table, that is necessary to use the wrreport extension.
3 CREATE TABLE wrreport (
4 id integer auto_increment primary key,
5 page_id integer, -- mediawiki page id the report is intended for
6 page_title varchar(255), -- mediawiki page title the report is intended for
7 date_report date, -- date, the report is intended for
8 date_entry datetime, -- date where report was created
9 date_invalid datetime, -- date were report becomes invalid
10 `condition` integer, -- condition from 1 (very good) to 5 (sledding not possible). NULL allowed.
11 description text, -- report description (wikitext)
12 author_name varchar(30), -- name of the person who created the report
13 author_ip varchar(15), -- IP address of the person who created the report
14 author_userid integer, -- mediawiki user id of the person who created the report
15 author_username varchar(30), -- mediawiki user name of the person who created the report
16 delete_date datetime, -- the report is considered deleted if this date is set
17 delete_person_name varchar(30), -- name of the person who deleted the report
18 delete_person_ip varchar(15), -- IP address of the person who deleted the report
19 delete_person_userid integer, -- mediawiki user id of the person who deleted the report
20 delete_person_username varchar(30), -- mediawiki user name of the person who deleted the report
21 delete_reason_public text, -- reason for the deletion (wikitext)
22 delete_invisible boolean, -- do not mention that someone deleted this recored
23 CONSTRAINT CHECK (`condition` >= 1 AND `condition` <= 5)