Database changes to implement a "delete report" functionality.

git-svn-id: http://www.winterrodeln.org/svn/servermediawiki/trunk/extensions/wrreport@326 7aebc617-e5e2-0310-91dc-80fb5f6d2477

diff --git a/upgrade_1.0_to_1.1.sql b/upgrade_1.0_to_1.1.sql
new file mode 100644 (file)
index 0000000..36cfbf3
--- /dev/null
+++ b/upgrade_1.0_to_1.1.sql
@@ -0,0 +1,9 @@
+begin;
+alter table wrreport add delete_date timestamp with time zone;
+alter table wrreport add delete_person_name varchar(30);
+alter table wrreport add delete_person_ip inet;
+alter table wrreport add delete_person_userid integer;
+alter table wrreport add delete_person_username varchar(30);
+alter table wrreport add delete_reason_public text;
+commit;
+

diff --git a/wrreport.sql b/wrreport.sql
index 719849d2cd8c1f2158b5cb36e2e8847fd93d59d0..12829bb5a645dc34b6d4a8e99a05a801c40f4c0c 100644 (file)
--- a/wrreport.sql
+++ b/wrreport.sql
@@ -1,18 +1,23 @@
 --- SQL command to create the wrreport table, that is necessary to use the wrreport extension.
 CREATE TABLE wrreport (
-  id serial NOT NULL,
-  page_id integer,
-  page_title character varying(255),
-  date_report date,
-  date_entry timestamp with time zone DEFAULT now(),
-  date_invalid timestamp with time zone DEFAULT (now() + '9 days'::interval),
-  condition integer,
-  description text,
-  author_name character varying(30),
-  author_ip inet,
-  author_userid integer,
-  author_username character varying(30),
-  CONSTRAINT wrreport_pkey PRIMARY KEY (id),
+  id serial primary key,
+  page_id integer,                       -- mediawiki page id the report is intended for
+  page_title varchar(255),               -- mediawiki page title the report is intended for
+  date_report date,                      -- date, the report is intended for
+  date_entry timestamp with time zone DEFAULT now(), -- date where report was created
+  date_invalid timestamp with time zone DEFAULT (now() + '9 days'::interval), -- date were report becomes invalid
+  condition integer,                     -- condition from 1 (very good) to 5 (sledding not possible). NULL allowed.
+  description text,                      -- report description (wikitext)
+  author_name varchar(30),               -- name of the person who created the report
+  author_ip inet,                        -- IP address of the person who created the report
+  author_userid integer,                 -- mediawiki user id of the person who created the report
+  author_username varchar(30),           -- mediawiki user name of the person who created the report
+  delete_date timestamp with time zone,  -- the report is considered deleted if this date is set
+  delete_person_name varchar(30),        -- name of the person who deleted the report
+  delete_person_ip inet,                 -- IP address of the person who deleted the report
+  delete_person_userid integer,          -- mediawiki user id of the person who deleted the report
+  delete_person_username varchar(30),    -- mediawiki user name of the person who deleted the report
+  delete_reason_public text,             -- reason for the deletion (wikitext)
   CONSTRAINT condition_check CHECK (condition >= 1 AND condition <= 5)
 );